How to get all data from an audience | Community
Skip to main content
M
MailySo2
Level 2
January 9, 2024
Solved

How to get all data from an audience

  • January 9, 2024
  • 2 replies
  • 2396 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SatheeskannaK

Hi @mailyso2, 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.

2 replies

SatheeskannaK
Community Advisor
SatheeskannaKCommunity AdvisorAccepted solution
Community Advisor
January 9, 2024

Hi @mailyso2, 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
M
MailySo2Author
Level 2
January 9, 2024

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
Community Advisor
Anuhya-YCommunity Advisor
Community Advisor
January 9, 2024

@mailyso2 

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

    M
    MailySo2Author
    Level 2
    January 9, 2024

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

    M
    MailySo2Author
    Level 2
    January 9, 2024

    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.

    Terms & ConditionsAccessibility statement

    Loading footer...