Create Connection
Objectives
- Understand the Data Connection UI
- Bring Adobe Experience Platform data into CJA
- Understand Person ID and data stitching
- Learn the concept of data streaming in Customer Journey Analytics
Connections
Ensure you are logged in to the Adobe Experience Platform.
To go to Customer Journey Analytics within the sandbox environment:
- Click on the product selector (nine-dot icon) at the top right.
- Select Customer Journey Analytics.
You will see the Customer Journey Analytics projects list.
Let's create our first connection:
- click on Connections on the top menu;
- click Create new connection.
You will see the Create Connection UI.
The UI has three distinct area:
- On the top, left side you will find Connection Settings, where you can give your Connection a name and description, and add Tags.
- On the top, right side you will find the Data Settings, where you will select the correct Sandbox (Sandbox 03) that contains our data. This will ensure the available datasets will be updated accordingly.
- At the bottom, you'll find the Dataset area for datasets you want to connect to.
Connection Settings
Name your Connection, ensuring you prefix this with your own name. E.g. [your name] - AEP Bootcamp Data Connection
Data Settings
- Select Sandbox 03 from the Sandbox dropdown in the Data Settings;
- for the Average number of daily events, select Less that 1 million. This gives CJA an indication of expected volumes, allowing for optimal processing.
Select Datasets
We will now select datasets for our connection.
- Select Add Datasets
- Search for the dataset Demo System - Event Dataset for Website (Global v1.1).
- Check the box to add this dataset to the connection.
- Search and when found also select the checkbox in front of the following datasets:
- Demo System - Event Dataset for Call Center (Global v1.1)
- Demo System - Event Dataset for POS (Global v1.1)
- Demo System - Event Dataset for Mobile App (Global v.1.1)
- Demo System - Profile Dataset for CRM (Global v1.1)
- Demo System - Event Dataset for Website (Global v1.1)
- CJA - AJO Email Tracking Experience Event Dataset
- CJA - AJO Message Feedback Event Dataset
- CJA - Journey Step Events
- CJA - AJO Entity Dataset
Your screen should now look like...
- Click on Next to add all checked datasets to your Connection.
You will be taken to the Dataset Settings step...
Person ID and Data Stitching
Our goals is now to join these datasets. If you look under the first Dataset name, you will see a field named Person ID. Each dataset has its own Person ID field. Check each dataset to see what is the Person ID.
As you will notice, most of them have the Person ID selected automatically. This is because a primary identifier is selected in every schema in Adobe Experience Platform. As an example, for the schema for Demo System - Event Schema for Call Center (Global v1.1), the Primary Identifier is set to phoneNumber.
However, you can still influence which identifier will be used to stitch datasets together for your connection. You can use any identifier that is configured as identity in the schema linked to your dataset.
- Click on the dropdown to explore the IDs available on each dataset.
As mentioned, we can set different Person IDs for each dataset. This allows you to bring different datasets from multiple origins together in CJA. Imagine bringing in NPS or survey data which would be very interesting and helpful to understand the context and why something has happened.
The name of the Person ID field isn’t important, as long as the value in the Person ID fields correspond. Let say we have email in one dataset and emailAddress in another dataset defined as Person ID. If [email protected] is the same value for the Person ID-field on both datasets, CJA will be able to stitch the data.
Stitching using Person ID
Now that you understand the concept of stitching datasets using the Person ID, lets choose CRM ID as your Person ID for each of the below datasets.
- Demo System - Event Dataset for Call Center (Global v1.1)
- Demo System - Event Dataset for POS (Global v1.1)
- Demo System - Event Dataset for Mobile App (Global v.1.1)
- Demo System - Profile Dataset for CRM (Global v1.1)
- Demo System - Event Dataset for Website (Global v1.1)
For each of these datasets:
- Select each dataset.
- Select CRM ID from the Person ID dropdown list.
- For each Dataset pick a relevant Data source type from the dropdown.
- Ensure "Import new data" is toggled on for each Dataset.
- Do not enable Dataset Backfill.
Let's now select the same Person ID from the identity map for the AJO datasets:
- CJA - AJO Email Tracking Experience Event Dataset
- CJA - AJO Message Feedback Event Dataset
- CJA - Journey Step Events
For each of these datasets:
- Select each dataset.
- Select Identity Map from the Person ID dropdown list.
- Uncheck the box "Use primary identity namespace"
- Select Demo System - CRMID from the Namespace dropdown list.
- For each Dataset pick a relevant Data source type from the dropdown.
- Ensure "Import new data" is toggled on for each Dataset.
- Do not enable Dataset Backfill.
Lastly, for the AJO lookup dataset, CJA - AJO Entity Dataset, we need to select a key and matching key:
- Select this dataset.
- Select _experience.customerJourneyManagement.entities.channelDetails.messageID from the Key dropdown list.
- Select _experience.customerJourneyManagement.messageExecution.messageID from the Matching key dropdown list.
- Pick a relevant Data source type from the dropdown.
- Ensure "Import new data" is toggled on for each Dataset.
- Do not enable Dataset Backfill.
Once you've completed your Dataset Settings, click Add datasets to add them to your Connection.
You will now see the Datasets Added to your connection...
- Click Save to save your Connection.
Note: It takes some time after saving a Connection for the data to populate in the resulting Workspaces. This time depends on the number of events being processed.
For the purposes of this lab, you can use a connection we defined for you already, named Belfius - Data Connection
You now have completed setting up a connection for CJA.