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