Creating Audiences with a 1-to-Many Relationship

[NickMannion]

Hello Adobe Community,

Within my RTCDP platform, we have a 1 to many relationship between our ECNs and the accounts associated with them. To solve for this, we created a schema with multiple array objects to ingest this data so it is formatted as an array where we have the main ECN and then all the objects with the accounts associated to the ECN. When we build audiences using this data, we have the ability to get all the ECNs that have an account that fall into our criteria. A random example of this could be if you want to target customers with accounts that have a balance of greater than $5. Based on that example, RTCDP would go through all the array objects associated to an ECN and as long as an ECN has at least one account that fits this description, it will qualify that ECN for our audience. However, I have a new use case where I want ECNs with only accounts that qualify for this criteria. So, if an ECN has an account with a balance less than $5, I do not want it to qualify for my audience. Does anyone have any suggestions on how I can do this in RTCDP?

Thanks,

Nick

[kautuk_sahni]

@bjoern__koth @Parvesh_Parmar @DavidRoss91 @brekrut @Anil_Umachigi @RiteshYadav18 @Harveer_SinghGi1 @arpan-garg @Pradeep_Kumar_Srivastav @dwright Hey, could you take a look at this question and share your thoughts? Your input would be really helpful!

[Harveer_SinghGi1 · Accepted solution]

Hi @NickMannion ,

I haven't tried this but wouldn't an audience set as EXCLUDE [ Where accountBalance < $5 ] work for your use case? Something like below (taking priceTotal as an example in place of accountBalance),

Cheers!

[NickMannion]

Hey Harveer, 

Thanks for the response. Yeah, we ended up using this exact solution. Sometimes the solution ends up being much simplee than you thought lol.

Thanks,
Nick

[RiteshYadav18]

@NickMannion  considering using audience composition 

https://experienceleague.adobe.com/en/docs/experience-platform/segmentation/ui/audience-composition