Skip to main content
CRV_555
Level 2
October 30, 2023
Répondu

Using Audience in AEP's Query Service

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.

Ce sujet a été fermé aux réponses.
Meilleure réponse par 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

3 commentaires

nnakirikanti
Community Advisor
nnakirikantiCommunity AdvisorRéponse
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

    CRV_555Auteur
    Level 2
    November 1, 2023

    Thanks @nnakirikanti this really helped.

    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

    Conditions d'utilisationAccessibility statement

    Loading footer...