Audience population - profile snapshot - users are not returned

Forum|Forum|3 months ago
October 20, 2025
1 reply
431 views

I use basic query to find a profiles which belong to audience (80k users).

Why nothing is returned?? No error

SELECT *
from profile_snapshot_export_745b62c8_332c_4a79_970e_03660f18b752
WHERE segmentMembership.DDA['22eb5450-7b52-4d42-a9bc-e5dea5d34955'] IS NOT NULL

why on our demo sandbox I need to use segment.membership.ups ???

Best answer by brekrut

Hello @michael_soprano,

To locate the membership of an audience you can use the following SQL statement.

select * from profile_snapshot_export_XXXXX where segmentmembership['ups']['<<segmentID>>'].status IN ('realized'). -- this is for profiles which qualify for the segment.

The segment object is a array object. This is why you will need to use format in the above example.

brekrut

Accepted solution

Adobe Employee

Hello @michael_soprano,

To locate the membership of an audience you can use the following SQL statement.

select * from profile_snapshot_export_XXXXX where segmentmembership['ups']['<<segmentID>>'].status IN ('realized'). -- this is for profiles which qualify for the segment.

The segment object is a array object. This is why you will need to use format in the above example.