Refresh Estimate profiles in Audience

[ButhpurKiran]

Hi Team,

While creating audience and using "Refresh Estimate" option shows the % of total and qualified audience. With this, we have few profiles displayed at the bottom of the same page. However, we wanted to get the total list of profiles qualified for that particular Audience. Is there a way to find these profiles. Any insights/direction can greatly help us moving forward whilst creating dashboard stitching the profiles with other 3rd party integration systems where the profiles are spread over.

Thanks in advance.

Kind regards,

Kiran Buthpur

[DavidRoss91]

Hello @ButhpurKiran 

You can accomplish this by exporting that audience to an S3 bucket and extract the file. Although, this will not export exact profiles, but the identity value that you choose to export.

[itsMeTechy]

you can even consider using profile snapshot table, which also has the details of qualified segments for each profile. or other way is to activate the audience to any file based destination and use the file for any downstream usage.

[TylerKrause · Accepted solution]

The profile snapshot as absolutely the way to go. You can very easily write a query to get this detail, here's a reference where we're pulling 5 sample records: 

select
your identity,
segmentmembership['ups']['segmentID']['status']
FROM
SnapShot Table
where segmentmembership['ups']['segmentID']['status'] is not null
limit 5

You can of course remove the limit 5 or do a limit 0 if needed to get more profiles.

Hope this helps!
Tyler Krause