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

    Mohan_Dugganab
    Adobe Employee
    Mohan_DugganabAdobe Employee
    Adobe Employee
    January 9, 2024

    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. 

      Terms & ConditionsAccessibility statement

      Loading footer...