How to get all data from an audience

[MailySo]

Hello,

I would like to get all data from my audience but I only have sample of 9 records. 

How is it possible to have more than 9 records as sample ?

As I have 5.96k normally I would like for example have 100 records of that.

[SatheeskannaK · Accepted solution]

Hi @MailySo, Usually profile sampling gets triggered depending on the method of ingestion. You can't see more than what the UI provides within the audience sample profiles section. I don't see any profiles sometimes although the audience has a profile count due to the ingestion method. In this case, if you want to look at more samples then create a query with the same criteria and validate the records.

Take a look at this documentation.

[MailySo]

Hello, 

Thanks for your reply, ok I'll try with a query but when I click on "code view" :

_belfius.customerCloudId.isNotNull() and (select _Customer_Product_Eligibility_Details1 from _belfius.productEligibilityDetails where _Customer_Product_Eligibility_Details1.eligibilityID.equals("IsAsXx01", false)) and (select _Agreement_Details1 from _belfius.productAgreementDetails where _Agreement_Details1.productAgreementProductDetails.productId.equals("L00267", false)) and (_belfius.negativeFeedbackProductDetails.negativeFeedbackProductGroup.doesNotContain("INS_ASSIST", false) or _belfius.negativeFeedbackProductDetails.negativeFeedbackProductGroup.isNull())

I have this code and when I do the query, I get an error message that's not valid.

Could you help me ?

[Anuhya-Y]

@MailySo 

Try this query

select * from profile_snapshot_export_XXXXX  where segmentmembership['ups']['195329af-1df-49f0-993a-4d3495132e6'].status IN ('realized', 'existing','exited')

Note: replace profile_snapshot_export dataset name, audience id in the query as per the system you are using. profile_snapshot_export dataset is system generated one

[MailySo]

Hello,

Thanks but where do you find your audience id ?

When I click on code view of my audience I have this code : 

_belfius.customerCloudId.isNotNull() and (select _Customer_Product_Eligibility_Details1 from _belfius.productEligibilityDetails where _Customer_Product_Eligibility_Details1.eligibilityID.equals("IsAsXx01", false)) and (select _Agreement_Details1 from _belfius.productAgreementDetails where _Agreement_Details1.productAgreementProductDetails.productId.equals("L00267", false)) and (_belfius.negativeFeedbackProductDetails.negativeFeedbackProductGroup.doesNotContain("INS_ASSIST", false) or _belfius.negativeFeedbackProductDetails.negativeFeedbackProductGroup.isNull())

[dugganab]

You will find it on the respective audience as follows.

When you run the following query against the profile snapshot system dataset, it will return you profiles with the respective audience membership status.

select
<belfiusProfileIdentifier>
, segmentMembership['ups']['audienceId'].lastQualificationTime
, segmentMembership['ups']['audienceId'].status
from profile_snapshot_export_xxxxxxx where 

 segmentMembership['ups']['audienceId'].status in ('realized', 'existing')

What ever criteria that you took from the code view is essentially what the audience would return (as the qualifying profiles) on being evaluated by the segment job. 

[MailySo1]

Hello,

It's me again

Do you have a query for the same request but not linked with an audience but with a rule ?

I try to put the rule ID in the query but it's not working.

Maily

[Anuhya-Y]

get audience id from audience summary when you open the specific audience or from the url as well.

[MailySo]

ok, thanks, I found audience id, that's ok for this part but when I do my query :

select * from customer_main where segmentmembership['ups']['b9a4756a-662e-4de2-b50a-27af26008a90'].status IN ('realized', 'existing','exited')

I get this message :

ErrorCode: 42703 queryId: 8d42ae88-ac36-4aea-a605-a976af39a8fe Column segmentmembership does not exist.

[MailySo]

ah that's fine, I found the right query for my audience :

select * from profile_snapshot_export_7209966b_2d62_40c1_b711_170682a0daed where segmentmembership['ups']['b9a4756a-662e-4de2-b50a-27af26008a90'].status IN ('realized', 'existing','exited')

BUT when I take a profile and I check his audience, I should see the name of my audience (with the ID of the audience that I put) and I don't see it in the list, see attached.

[MailySo]

Hi again,

You can ignore my previous message, I don't know why but now I see my audience in my list of my profile selected.

Thanks a lot for your help ! Really appreciate Have a nice evening.

BR,

Maily