Skip to main content
YashwanthPo
Level 2
Mar 6, 2025 2:17 PM UTC
Solved

Audience count variation in AEP and AJO

Hi Team,

 

Why there is count difference in AEP and AJO?

 

Example - There are 10K audience count in AEP but in Journey the read audience has only 500 audience count. Where the other audience are getting drop. All the criteria are applied and namespace is also matching.

 

Regards

Anuhya-YAccepted solution
Community Advisor
Mar 7, 2025 5:38 AM UTC

@yashwanthpo profile snapshot is a system generated dataset.

 

count records

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')

 

checkout the links for more info https://experienceleague.adobe.com/en/docs/experience-platform/dashboards/query 

https://experienceleaguecommunities.adobe.com/t5/real-time-customer-data-platform/profile-snapshot-and-segment-qualification-troubleshooting/ba-p/698998 

 

 

View in thread

4 replies

Community Advisor
Anuhya-YCommunity Advisor
Community Advisor
Mar 6, 2025 2:55 PM UTC

@yashwanthpo 

May I know the audience evaluation type which is used in the journey?

 

when the Read Audience activity is used, profiles are selected from the profile snapshot data. Cross check the count of the audience for that segment mebership in profile_snapshot_export dataset.

 

 

Translate
    YashwanthPoAuthor
    Level 2
    Mar 7, 2025 4:16 AM UTC

    May I know the audience evaluation type which is used in the journey? Batch Evaluation

     

    Where I can find the profile_snapshot_export dataset. Can I query this dataset?

     

    Thank you.

    Translate
    Community Advisor
    Anuhya-YCommunity AdvisorAccepted solution
    Community Advisor
    Mar 7, 2025 5:38 AM UTC

    @yashwanthpo profile snapshot is a system generated dataset.

     

    count records

    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')

     

    checkout the links for more info https://experienceleague.adobe.com/en/docs/experience-platform/dashboards/query 

    https://experienceleaguecommunities.adobe.com/t5/real-time-customer-data-platform/profile-snapshot-and-segment-qualification-troubleshooting/ba-p/698998 

     

     

    Translate
      SatheeskannaK
      Adobe Champion, Community Advisor, UG Leader
      SatheeskannaKAdobe Champion, Community Advisor, UG Leader
      Adobe Champion, Community Advisor, UG Leader
      Mar 6, 2025 2:59 PM UTC

      @yashwanthpo Additionaly, you can run a query to see why the profile didn't enter the journey.

      https://experienceleague.adobe.com/en/docs/journey-optimizer/using/reporting/reports/query-examples

      Translate
      Thanks, Sathees
        Terms & ConditionsAccessibility statement

        Loading footer...