Expand my Community achievements bar.

Join us for the Adobe Journey Optimizer Community Q&A Coffee Break on 28th February at 8 am PT with Ariel Sultan, Daniel Wright, Josee Haeley and Rohit Basuri.
SOLVED

How to get all data from an audience

Avatar

Level 2

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.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

Thanks, Sathees

View solution in original post

10 Replies

Avatar

Correct answer by
Community Advisor

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.

Thanks, Sathees

Avatar

Level 2

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 ?

Avatar

Community Advisor

@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

Avatar

Level 2

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())

Avatar

Employee

You will find it on the respective audience as follows.

 

dugganab_0-1704813668276.png

 

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. 

Avatar

Level 1

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

Avatar

Community Advisor

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

Avatar

Level 2

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.

Avatar

Level 2

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.

 

 

Avatar

Level 2

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