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

How to get all data from an audience

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.
SatheeskannaK
SatheeskannaKAccepted solution
Level 1
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
View reply

10 replies

Anuhya-Y
Anuhya-Y
New Participant
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

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

    Translate
    Mohan_Dugganab
    Mohan_Dugganab
    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. 

    Translate
      SatheeskannaK
      SatheeskannaKAccepted solution
      Level 1
      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.

      Translate
      Thanks, Sathees
      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 ?

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...