Using Audience in AEP's Query Service | Community
Skip to main content
C
CRV_555
Level 2
October 30, 2023
Solved

Using Audience in AEP's Query Service

  • October 30, 2023
  • 2 replies
  • 2426 views

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.

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 nnakirikanti

@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-profiles-by-audience

 

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#generate-datasets-with-a-pre-defined-experience-data-model-schema

2 replies

nnakirikanti
Community Advisor
nnakirikantiCommunity AdvisorAccepted solution
Community Advisor
October 30, 2023

@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-profiles-by-audience

 

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#generate-datasets-with-a-pre-defined-experience-data-model-schema

    C
    CRV_555Author
    Level 2
    November 1, 2023

    Thanks @nnakirikanti this really helped.

    E
    EvelynSu1
    November 28, 2024

    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

    Terms & ConditionsAccessibility statement

    Loading footer...