list of profile qualified as part of segmentation job

[Pradeep-Jaiswal]

segmentation job API, only returns the count of profile. how do i get the details of those profile, which got qualified after a particular segment job rans ? https://experienceleague.adobe.com/en/docs/experience-platform/segmentation/api/segment-jobs

1) when we execute the flexible audience which gets evaluated right away, but profile snapshot is only available next day. So without waiting for next day, how can we find list of profile that qualified under that audience ?

2) when we built streaming audience, without waiting for next day, how can we find list of profile that qualified under that audience ?

[itsMeTechy]

Hi Pradeep

Please use the below query to get the list of profiles in realized status for a particular audience id. as we select identity attribute, you can select any profile attributes,

select id from
(select id, explode(value) from
(select <identity_attribute_path> as id, explode(segmentmembership) from
profile_snapshot_export_<xxxxxxxxx>))
where key = <audienceid> and value.status = 'realized' limit 10

[Pradeep-Jaiswal]

I updated my question to give more context. Sorry I should been clear while posting it.

[Pradeep-Jaiswal]

What i have found that there is table flexible_audience which has the information related to which profile gets qualified for which audience when on demand batch evaluation is completed.

But for the streaming audience, I didnt find any solution except waiting for snapshot table next day.  Do u know if there is any solution for streaming audience ?

[itsMeTechy]

if i now understand your question more, you need, which profiles are qualified newly, or you need to know on daily basis which are all the profiles are qualified. 

in that case, every day after segment evaluation job, you can consider to use data distiller to query the snapshot table and get the details of which profiles are qualified for which audience or may be specific audience and store into another dataset.

as far my understanding, the snapshot table will be having the latest data only, and not the history. but in cases the status of the audience will have 3 entries, like "realized", "existing" and "exited". please find the difference between "realized" and "existing" in the below community post.