As we all know the profile snapshot dataset is an incredibly powerful tool! I would like to be able to do the 'inverse' and I was curious if anyone has figured out a method for this within AEP already.
I would like to be able to query a given Audience ID, and get a result of all customers that are qualified for that audience. It could be a 'realized' state or it any other method, but basically giving me a return of all profiles that fall within the given criteria. I already do this via API for one off checks, and have audiences that I have activated to various platforms, but I would love to be able to do it right within AEP.
Hi, Tyler. You can use this query to return a set of identities that qualify.
select identity from (select identity, explode(value) from (select identity, explode(segmentmembership) from profile_snapshot_export_.....)) where key = 'audience-id' and value.status = 'realized')
According to below reference link, we can export audiences as data files to cloud storage locations which contains audiences and their profile attributes.
Hi, Tyler. You can use this query to return a set of identities that qualify.
select identity from (select identity, explode(value) from (select identity, explode(segmentmembership) from profile_snapshot_export_.....)) where key = 'audience-id' and value.status = 'realized')
