Expand my Community achievements bar.

Join us on September 25th for a must-attend webinar featuring Adobe Experience Maker winner Anish Raul. Discover how leading enterprises are adopting AI into their workflows securely, responsibly, and at scale.

Account Audience Tables

Avatar

Level 2

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!

3 Replies

Avatar

Level 6

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:

supratim320_0-1753414528165.png

 

Hope it helps!

Avatar

Level 2

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

DiegoMo5_0-1753815560814.png

 

Avatar

Administrator

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