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!
Views
Replies
Total Likes
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!
Views
Replies
Total Likes
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
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!
Views
Replies
Total Likes