How to export an Audience from AJO?

Question

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 Answer

@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/sftp

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

MeitMedia · Answer

Hello @zoeag

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

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.
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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded