Skip to main content
DiegoMo5
Level 2
May 19, 2025 4:08 PM UTC
Solved

Query all members of a audience

Hello there, 

Any way to query all the members from one particular audience?
I know just to check if a members is part of one particular audience and, furthermore the sample data is not enough

 

thanks for the help!

SatheeskannaK
SatheeskannaKAccepted solution
Adobe Champion, Community Advisor, UG Leader
May 19, 2025 4:59 PM UTC

@diegomo5 Use this query and modify it based on your needs.

 

select to_json(identityMap['email']['id']), to_json(segmentMembership['ups']['<<segment_id>>'])
from profile_snapshot_export_<<snapshot_id>>
where segmentMembership['ups']['<<segment_id>>']['status'] in ('existing', 'realized', 'exited')

Thanks, Sathees
View in thread

3 replies

SatheeskannaK
Adobe Champion, Community Advisor, UG Leader
SatheeskannaKAdobe Champion, Community Advisor, UG LeaderAccepted solution
Adobe Champion, Community Advisor, UG Leader
May 19, 2025 4:59 PM UTC

@diegomo5 Use this query and modify it based on your needs.

 

select to_json(identityMap['email']['id']), to_json(segmentMembership['ups']['<<segment_id>>'])
from profile_snapshot_export_<<snapshot_id>>
where segmentMembership['ups']['<<segment_id>>']['status'] in ('existing', 'realized', 'exited')

Translate
Thanks, Sathees
    DiegoMo5Author
    Level 2
    May 20, 2025 2:58 PM UTC

    Thank you very much @satheeskannak

    It is working as expected, the existence of the table "profile_snapshot_export" was the piece of cake

    query = "SHOW TABLES LIKE 'profile_snapshot_export_%';"
     
    Translate
      AnkitJasani29
      AnkitJasani29
      Level 6
      May 20, 2025 10:46 AM UTC

      Hi @diegomo5 ,

      Agree with @satheeskannak 's response. For more information, you can visit https://experienceleague.adobe.com/en/docs/experience-platform/query/home

      Translate
        Terms & ConditionsAccessibility statement

        Loading footer...