How to Query an Audience using Query Service? | Community
Skip to main content
Level 4
April 13, 2025
Solved

How to Query an Audience using Query Service?

  • April 13, 2025
  • 1 reply
  • 1027 views

All, 

I just need help on how I can run an query on an Audience I created, but I want to use Query Service so I can confirm some values from the Audience.

 

I've run queries on the datasets using a Journey Action ID to get Tracking/Message feedback information, but I don't see any documentation on how to run this type of query on an actual audience. 

 

Please advise. 

Best answer by Mohan_Dugganab

You can query the profile snapshot system dataset to find out the qualified profiles against your audience.

SELECT count() FROM profile_snapshot_export_ID -- replace export id WHERE segmentMembership['ups']['segment ID'] IS NOT NULL AND segmentMembership['ups']['segment ID']['status'] IN ('realized')

References 

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

https://experienceleaguecommunities.adobe.com/t5/real-time-customer-data-platform/profile-snapshot-a... 

1 reply

Mohan_Dugganab
Adobe Employee
Mohan_DugganabAdobe EmployeeAccepted solution
Adobe Employee
April 14, 2025

You can query the profile snapshot system dataset to find out the qualified profiles against your audience.

SELECT count() FROM profile_snapshot_export_ID -- replace export id WHERE segmentMembership['ups']['segment ID'] IS NOT NULL AND segmentMembership['ups']['segment ID']['status'] IN ('realized')

References 

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

https://experienceleaguecommunities.adobe.com/t5/real-time-customer-data-platform/profile-snapshot-a...