Validating An Audience for A Journey | Community
Skip to main content
D
DanSpigs1
Level 2
December 16, 2024
Solved

Validating An Audience for A Journey

  • December 16, 2024
  • 1 reply
  • 766 views

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.

Best answer by Anuhya-Y

@danspigs1 

You can export the audience into a dataset

checkout

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

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. 

1 reply

C
Caveman77
Level 4
December 16, 2024

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.   

    D
    DanSpigs1Author
    Level 2
    December 16, 2024

    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
    Community Advisor
    Anuhya-YCommunity AdvisorAccepted solution
    Community Advisor
    December 17, 2024

    @danspigs1 

    You can export the audience into a dataset

    checkout

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

    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. 

      Terms & ConditionsAccessibility statement

      Loading footer...