Query all members of a audience

Forum|Forum|8 months ago
May 19, 2025
2 replies
444 views

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!

Journey Optimizer

Best answer by SatheeskannaK

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

SatheeskannaK

Accepted solution

Community Advisor

@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