How to export an Audience from AJO?

[ZoeAG]

Hello All,

I'm trying to export an audience in AJO from the UI (to Excel or CSV). I noticed there's a way to do it using an API. I'm wondering if there's a different way to do it from the UI, as there's a way to import audiences from the UI. If anyone can help me with this, it'll be greatly appreciated. Thanks a lot!

[SatheeskannaK · Accepted solution]

@ZoeAG Follow this documentation to export the audiences as csv from AJO using cloud storage destinations (sftp/amazonS3/AzureBlob etc.).

https://experienceleague.adobe.com/en/docs/experience-platform/destinations/catalog/cloud-storage/sf...

https://experienceleague.adobe.com/en/docs/experience-platform/destinations/catalog/cloud-storage/am...

[Zoe_G]

Hey Sathees, Thanks a lot for the reply, I tried this and it works!!!

[MeitMedia]

Hello @ZoeAG 

Here is a two-step approach for exporting data from AJO:

1. Schedule a SQL Query: Write your SQL query and schedule it to run at a predefined time. This will save your results into a temporary dataset. For guidance on scheduling queries, please refer to this documentation.

2. Export the Data: Once your query results are saved, you can export the data in CSV format to your desired location. For details on exporting datasets, see this documentation.

Let me know if you need any further assistance!

Best regards,

MEIT MEDIA (https://www.meitmedia.com)

Find us on LinkedIn

Contact Us: infomeitmedia@gmail.com

[Zoe_G]

Thanks a lot for the response, appreciate it!