Account Audience Tables | Community
Skip to main content
D
DiegoMo5
Level 2
July 18, 2025
Question

Account Audience Tables

  • July 18, 2025
  • 2 replies
  • 291 views

Hello Community,

Today, I have a question regarding the ability to view the full list of B2B account audiences using Query Service and join them with account profiles.

I've noticed that there are three key snapshot tables: profile, account, and segmentation. I was able to join customer profiles with audience data using the segmentMembership attribute. However, in the context of accounts, this attribute appears to be unavailable—all records in the corresponding column are null, even though account-based audiences have been created.

Has anyone encountered this before or have any advice on how to retrieve account audience data using Query Service?

Thank you in advance!

2 replies

S
supratim320
Level 5
July 25, 2025

Hi @diegomo5 ,

A profile schema must have a 1-M relationship with account. Please see the below screenshot of data relationship in a B2B schema relations: url

Ideally, you should be able to see it as relationship in your profile schema(s) under "personalComponents" array node, and it should also be marked with matching Identity in both profile & account schemas.

 

Now coming to your question on joining: you can refer to profile snapshot, find the columns marked with the account related Identity namespace and that should be matching with the same namespace inside the account snapshot - I will refer you to the schemas first and take it from there:

 

Hope it helps!

D
DiegoMo5Author
Level 2
July 29, 2025

Hi hello @supratim320 , @sukrity_wadhwa 


Thank very much for your support.

 

But I consider the questions is alive, I understand the way how the accounts and profiles are conected using the personComponents attribute, to return the accounts related with a customer segmentation.

 

However my question is regarding to the account audience itself.In the table:

segmentdefinition_snapshot_export_7e572d41_0766_4bce_b3e8_0509ec

 It seems to only contain IDs from customer audiences. I am unable to find the account audiences pre-created in the audince builder UI with the service Query.

 

Furthermore, in the table,

account_snapshot_export_26798c08_24e2_449f_bbc9_06703c5346e

the segmentMembership field is null for all the accounts, even for those that are members of an account audiences

 

    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    July 29, 2025

    Hi @diegomo5,

    Was the given solution helpful to resolve your query or do you still need more help here? Do let us know. In case the given solution was helpful, then kindly choose it as the 'Correct Reply'.

    Thanks!

    Sukrity Wadhwa
    Terms & ConditionsAccessibility statement

    Loading footer...