Using Audience in AEP's Query Service

[CRV_555]

Can we query on segmented audience in Adobe Experience Platform's Query Service? 

We want to ingest Audience data into a dataset and we are analyzing if it could be done via Query Service.

[nnakirikanti · Accepted solution]

@CRV_555 You will have profile snapshot datasets created for each merge policy on the sandbox and these profile snapshots gets refreshed on daily basis post global segment eval. you can get write your own query to filter all profile in that snapshot as per your business need

Sample query to to find count by audience, you can tune this as per your corresponding audience id

1) https://experienceleague.adobe.com/docs/experience-platform/dashboards/query.html?lang=en#count-of-p...

2) Capturing output of query results can be done in couple of ways, check the link below

https://experienceleague.adobe.com/docs/experience-platform/query/ui/create-datasets.html?lang=en#ge...

[CRV_555]

Thanks @nnakirikanti this really helped.

[EvelynSu1]

Hi,

I would like to know did you query audience with the error code "42601" of the result?

I run the code as follow, but fail to get result:

SELECT audience_id
FROM Segmentdefinition-Snapshot-Export-xxxxbe15-8xxx-4xxx-8xxx-xxxxxx63d8ac

thank you