Expand my Community achievements bar.

SOLVED

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

Avatar

Level 3

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?

1 Accepted Solution

Avatar

Correct answer by
Level 2

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.

View solution in original post

3 Replies

Avatar

Community Advisor

@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

Avatar

Community Advisor

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



DavidKangni_0-1726525995448.png

Thanks,

David



David Kangni

Avatar

Correct answer by
Level 2

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.