AJO Audience Clean up Efforts - Export the names of the audiences that have been built

[Caveman77]

We have been using AJO for almost 3 years and have built over 1400 audiences.  Some are archived, some are still used.

The interface only shows 25 per page....so we have 58 pages.   

Is there a way to export a list of the audience names, ideally with the description, created, last used.  I need to be able to provide some overarching direction, spot any inconsistencies to the department/teams and need to see the patterns by reviewing in an excel/table format.

Can this be exported?

[Anuhya-Y]

@Caveman77 

check out "Connect clients to Query Service" and run query according to the requirement in desktop client application and export the results via csv format.

https://experienceleague.adobe.com/en/docs/experience-platform/query/clients/overview

[DavidKangni]

Hi @Caveman77,

You can use queries to get the data. First through the UI go to datasets, search for segmentdefinition and find the table name 

 segmentdefinition_snapshot_export_XXXXXXXX_XXXX_XXXX_XXXX_XXXXXX

select  * from segmentdefinition_snapshot_export_XXXXXXXX_XXXX_XXXX_XXXX_XXXXXX

Thanks,

David

[mohitkhare123 · Accepted solution]

Hi @Caveman77 ,

We can use query service to query the dataset: segmentdefinition_snapshot_export_XYZ

the query should be like this:
Select
identityMap.aepsegments.id as audience_id,
segmentName,
_repo.modifyDate,
_repo.createDate
from
segmentdefinition_snapshot_export_XYZ 
where
identityMap.aepsegments.id is not NULL
AND
_repo.createDate::date >= '2024-09-16'
order by
_repo.createDate DESC 

-- replace the name of the table as per the dataset in your instance.