Use Adobe Experience Platform data in journeys datalookup

Product Category-Based Filtering

Scenario:Send a coupon to users who spend more than $40 on household products.

Journey flow:

1. Purchase Event: Capture SKUs from the user’s cart.

2. Dataset lookup activity:

   • Dataset: products-dataset (SKU as the primary key).
   • Lookup Keys: list(@event{purchase_event.products.sku}).
   • Fields to Return: ["SKU", "category", "price"].

3. Condition activity:

   • Filter SKUs where the category is “household”.

     code language-none
     @event{purchase_event.products.all( in(currentEventField.sku, @datasetlookup{MyDatasetLookupActivity1.entities.all(currentDatasetLookupField.category == 'household').sku} ) )}

   OR

   • Aggregate the total spend on household products and compare it to the $40 threshold.

     code language-none
     sum(@event{purchase_event.products.all( in(currentEventField.sku, @datasetlookup{MyDatasetLookUpActivity1.entities.all(currentDatasetLookupField.category == 'household').sku} ) )}.price}, ',', true ) > 40

4. Personalization Editor:

   Use the enriched data to personalize the email content:

   code language-none
   {% let householdTotal = 0 %} {{#each journey.datasetlookup.3709000.entities as |product|}} {%#if get(product, "category") = "household"%} {% let householdTotal = householdTotal + product.price %}{%/if%} {{/each}} "Hi, thanks for spending " + {%= householdTotal %} + " on household products. Here is your reward!"

Personalization using external loyalty data

Scenario: Identify which email account for a profile has a Loyalty Status of Platinum. In this scenario, loyalty account is associated to an email ID and loyalty data is not available in the standard profile lookup store.

Journey flow:

1. Profile Event Trigger: Capture email IDs from the profile or event context.

2. Dataset Lookup activity:

   • Dataset: loyalty-member-dataset (email as the primary key).
   • Lookup Keys: @profile.email.
   • Fields to Return: ["email", "loyaltyTier"].

3. Condition activity:

   Branch the journey based on the loyalty tier:

   code language-none
   @datasetLookup{MyDatasetLookUpActivity1.entity.loyaltyMember.loyaltyTier} == 'Platinum'

4. Personalization Editor:

   Use the enriched loyalty tier data to personalize outbound communication:

   code language-none
   {{context.journey.datasetLookup.1482319411.entity.loyaltyMember.loyaltyTier}}

AI Knowledge Reference

This section contains structured knowledge intended to support interpretation, retrieval, and question answering related to this topic.

For complete understanding, this information should be combined with the documentation on this page. Neither source is intended to stand alone; the page describes the feature, while this section provides additional context that helps disambiguate terminology, intent, applicability, and constraints.

• TL;DR: This page explains how to configure the Dataset lookup activity to dynamically retrieve data from Adobe Experience Platform record datasets at journey runtime for real-time personalization and conditional logic.

Intents:

• Add a Dataset lookup activity to a journey to fetch external Adobe Experience Platform record data at runtime
• Select specific dataset fields (leaf nodes / primitive values) to retrieve during lookup
• Define a lookup key in advanced mode to join journey context with dataset records
• Use enriched dataset data in the journey expression editor or personalization editor
• Troubleshoot “Dataset lookup not found” errors caused by using simple mode for the lookup key

Glossary:

• Dataset lookup activity: A journey orchestration activity that retrieves selected data from Adobe Experience Platform record datasets at runtime by matching a lookup key from the journey context to dataset records (product-specific)
• Leaf node: A field at the lowest level of a schema hierarchy that holds a primitive value (string, number, boolean, date) (product-specific)
• Lookup key: The joining expression (string or list of strings) used to match journey context data against records in the selected dataset (product-specific)
• Enriched data: Data retrieved by a Dataset lookup activity and stored transiently in the journey context for use in downstream activities (product-specific)

Guardrails:

• Maximum of 10 Dataset lookup activities per journey (hard limit).
• Maximum of 20 selected fields (hard limit).
• Maximum of 50 keys in the lookup keys array (hard limit).
• Enriched data size is limited to 10KB (hard limit).
• The dataset must be enabled for lookup in Adobe Experience Platform before it appears in the activity configuration.
• Only leaf nodes (primitive values) can be selected; arrays and maps cannot be selected.
• Only strings or lists of strings are supported as lookup keys.
• The lookup key must be defined in advanced mode; using simple mode causes the activity output to be unavailable as a context attribute downstream.
• Enriched data is transient and available only during journey runtime and in outbound activity personalization.
• To avoid delays in deliverability, up to 5 lookup activities per journey are recommended. Up to 20 attributes per lookup are also recommended.

Terminology:

• Canonical name: Dataset lookup activity
• Synonyms: “lookup key” = “joining key”

FAQ:

• Q: Why does my dataset not appear in the Dataset field dropdown? — The dataset must be enabled for lookup in Adobe Experience Platform. See the linked “Use Adobe Experience Platform data” section for details.
• Q: What should I check if lookup output is unavailable in a condition? — Confirm that the lookup key was defined in advanced mode and that the Dataset lookup activity was saved. In the condition’s separate expression editor, switch to advanced mode and reference the lookup output. If the key was defined using simple mode, redefine it in advanced mode and republish the journey.
• Q: Can I retrieve arrays or map fields from the dataset? — No, only primitive leaf node fields (string, number, boolean, date) can be selected.
• Q: How do I access enriched data in an email? — Use the personalization editor with the syntax {{context.journey.datasetLookup.1482319411.entities}}.
• Q: Is enriched data available after the journey runtime? — No, enriched data is transient and available only during journey runtime and in the personalization of outbound activities.