How to reconcile data from an event with data from a customer profile from CDP

Question

We have a Journey in AJO that is an event based audience. In our full data model, customers can have multiple accounts. Within the event, it tells us which account the customer is using to trigger the event.

However before sending the e-mail we need to execute an account eligibility check (i.e. check our account level suppressions) by reconciling that account with the account data in the customer real time CDP / AEP.

What type of syntax or how can we pull the account from the event then use that account to compare against the customers CDP/AEP profile?

Mayank_Gandhi · Answer

@user77095  In AJO you can reference both the fields that arrived in the triggering event and the arrays that live on the real-time profile inside the same Condition node. Considering that the profile must store the accounts as an array field (object or string) so the Condition node can reach them.  If the accounts only live in a separate dataset you will need to bring them onto the Profile or send them in the event. Then you can try following approach.1.  read the account identifier that sits in the event payload, and2.  look through the profile-level array of accounts to see whether that same account is flagged as ineligible / suppressed.A pattern looks like this:/* event object contains a single accountId */var thisAccountId      = event.account.accountId;/* profile array: accounts[ ] each has id + suppression flag */exists(        filter(profile.accounts,               a -> a.accountId == thisAccountId && a.suppressed == true)      )

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded