Lookup schema audience
Hi,
Can we use lookup attributes in audience criteria?
I am looking for support around using the Lookup class in Audience criteria. We’re validating our RTCDP modeling approach for campaign eligibility and would appreciate architectural confirmation. We were asked last minute to include divisionNumber in an audience eligibility which is apart of the lookup schema and dataset in dev sandbox.
Current setup:
Profile schema (XDM Individual Profile) identities: accountID, urlAccName
Card Lookup dataset contains divNoLogo (Division Number + Logo)
Division Number = first 3 digits of divNoLogo (fixed length, 3 digits)
- Card Lookup does not contain
accountID - Card Lookup was previously profile enabled
- Requirement: segment based on Division Number
Question:
Given that Card Lookup is not keyed by accountID, is Adobe’s recommended pattern to:
1. Materialize divNoLogo (or derived divisionNumber) onto the Profile store via a profile enabled enrichment dataset keyed by accountID, and segment directly on the Profile attribute, rather than
2. Rely on a schema relationship between Profile.divNoLogo and CardLookup.divNoLogo for audience evaluation?
Additionally:
- Any concerns with storing
divNoLogoas a non identity profile attribute strictly for segmentation purposes? - Any architectural risks with using a non person business key as a foreign key (not identity) in Profile?
Our objective is to ensure deterministic segmentation and alignment with Adobe modeling best practices before finalizing production architecture.
Additionally, we also will need to support with using the lookups in AJO.