AJO Audience Clean up Efforts - Export the names of the audiences that have been built | Community
Skip to main content
C
Caveman77
Level 4
September 16, 2024
Solved

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

  • September 16, 2024
  • 3 replies
  • 697 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by mohit_khare

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.

3 replies

Anuhya-Y
Community Advisor
Anuhya-YCommunity Advisor
Community Advisor
September 16, 2024

@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
Community Advisor
DavidKangniCommunity Advisor
Community Advisor
September 16, 2024

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

David Kangni
mohit_khare
mohit_khareAccepted solution
Level 2
September 17, 2024

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.

Terms & ConditionsAccessibility statement

Loading footer...