How to export an Audience from AJO? | Community
Skip to main content
Level 2
August 23, 2024
Solved

How to export an Audience from AJO?

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
SatheeskannaKAccepted solution
Level 1
August 23, 2024

@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

Thanks, Sathees

4 replies

MeitMedia
Level 4
August 26, 2024

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

Translate
Level 2
August 27, 2024

Thanks a lot for the response, appreciate it!

Translate
SatheeskannaK
SatheeskannaKAccepted solution
Level 1
August 23, 2024
Thanks, Sathees
Level 2
August 27, 2024

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

Translate