Skip to main content
Level 2
Aug 23, 2024 7:06 PM UTC
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
Adobe Champion, Community Advisor, UG Leader
Aug 23, 2024 10:34 PM UTC

@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

SatheeskannaK
Adobe Champion, Community Advisor, UG Leader
SatheeskannaKAdobe Champion, Community Advisor, UG LeaderAccepted solution
Adobe Champion, Community Advisor, UG Leader
Aug 23, 2024 10:34 PM UTC
Thanks, Sathees
Level 2
Aug 27, 2024 6:26 PM UTC

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

Translate
MeitMedia
Level 4
Aug 26, 2024 7:29 AM UTC

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
Aug 27, 2024 6:27 PM UTC

Thanks a lot for the response, appreciate it!

Translate