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.
Solved! Go to Solution.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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 ?
Views
Replies
Total Likes
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
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())
Views
Replies
Total Likes
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.
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
Views
Replies
Total Likes
get audience id from audience summary when you open the specific audience or from the url as well.
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.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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
BR,
Maily
Views
Likes
Replies