Validating An Audience for A Journey

[DanSpigs1]

How do I extract a list of customers included in an audience for QA and validation.  I am coming from Adobe Campaign where it's easy to pull a list out of a workflow in order to validate the audience for QA.  I see where we can see a sample of an audience but not where I can pull the full list to validate.

[Caveman77]

We have marketing teams that came from a similar world.  What we set up is an an internal SFTP site.  You can then activate your list/audience to that as a destination when you need to be able to access everyone in that audience.   This is not an option to see everyone, with all the attributes you may want to review from within the UI.   

[DanSpigs1]

Thank you for your reply.  Unfortunately, I'm working with some fairly stringent security requirements so I'll have to see if that will fly.  

[Anuhya-Y · Accepted solution]

@DanSpigs1 

You can export the audience into a dataset

checkout

https://experienceleague.adobe.com/en/docs/experience-platform/segmentation/tutorials/create-dataset...

https://experienceleague.adobe.com/en/docs/experience-platform/segmentation/api/export-jobs#create

use query service/ data distiller to query profile snapshot.

select * from profile_snapshot_export_XXXXX  where segmentmembership['ups']['195329af-1df-49f0-993a-4d3495132e6'].status IN ('realized', 'existing','exited')

Note: replace profile_snapshot_export dataset name, segment id in the query as per the system you are using.profile_snapshot_export dataset is system generated one, you can find these by enabling show system datasets from UI.