This quick start guide explains how you can ingest batch data into Adobe Experience Platform and then use that data in Customer Journey Analytics.
To accomplish this, you need to:
Set up a schema and dataset in Adobe Experience Platform to define the model (schema) of the data that you want to collect and where to actually collect the data (dataset).
Use workflows to easily upload your batch data to the dataset configured in Adobe Experience Platform.
Set up a connection in Customer Journey Analytics. This connection should (at least) include your Adobe Experience Platform dataset.
Set up a data view in Customer Journey Analytics to define metrics and dimension that you want to use in Analysis Workspace.
Set up a project in Customer Journey Analytics to build your reports and visualizations.
This is a simplified guide on how to ingest batch data into Adobe Experience Platform and use in Customer Journey Analytics. It is highly recommended to study the additional information when referred to.
To ingest data into Adobe Experience Platform, you first need to define which data you want to collect. All data ingested into Adobe Experience Platform must conform to a standard, denormalized structure for it be recognized and acted upon by downstream capabilities and features. Experience Data Model (XDM) is the standard framework that provides this structure in the form of schemas.
Once you have defined a schema, you use one or more datasets to store and manage the collection of data. A dataset is a storage and management construct for a collection of data, typically a table, that contains a schema (columns) and fields (rows).
All data that is ingested into Adobe Experience Platform must conform to a pre-defined schema before it can be persisted as a dataset.
For this quick start you want to collect some loyalty data, for example loyalty id, loyalty points, and loyalty status.
For this, you first need to define a schema that models this data.
To set up your schema:
In the Adobe Experience Platform UI, in the left rail, select Schemas within DATA MANAGEMENT.
Select Create schema. Select XDM Individual Profile from the list of options.
An Individual Profile schema is used to model the profile attributes (like email, loyalty status, loyalty points). An Experience Event schema is used to model the behavior of a profile (like page view, add to cart).
In the Untitled schema screen:
Enter a display name for your schema and (optional) a description.
Select + Add in Field groups.
Field groups are reusable collections of objects and attributes that allow you to easily extend your schema.
In the Add fields groups dialog, select the Loyalty Details field group from the list.
You can select the preview button, to see a preview of the fields that are part of this field group.
Select Back to close the preview.
Select Add field groups.
Select + next to your schema name in the Structure panel.
In the Field Properties panel, enter
Identification as the name, Identification as the Display name, select Object as the Type and select Profile Core v2 as the Field Group.
This adds identification capabilities to your schema. In your case, you want to identify loyalty information using the email address from your batch data.
Select Apply to add this object to your schema.
Select the email field in the identification object you just added, and select Identity and Email from the Identity namespace in the Field Properties panel.
You are specifying the email address as the identity the Adobe Experience Platform Identity service can use to combine (stitch) profiles.
Select Apply. You see that a fingerprint icon appears in the email attribute.
Select the root level of your schema (with the schema name), then select the Profile switch.
You are prompted to enable the schema for profile. Once enabled, when data is ingested into datasets based on this schema, that data is merged into the Real-Time Customer Profile.
See Enable the schema for use in Real-Time Customer Profile for more information.
Once you save a schema enabled for profile, it can no longer be disabled for profile.
Select Save to save your schema.
You have created a minimal schema that models the loyalty data you can ingest into Adobe Experience Platform. The schema allows profiles to be identified using the email address. By enabling the schema for profile, you ensure that data from your batch file is added to the Real-Time Customer Profile.
See Create and edit schemas in the UI for more information on adding and removing field groups and individual fields to a schema.
With your schema, you have defined your data model. You now have to define the construct to store and manage that data. This is done through datasets.
To set up your dataset:
In the Adobe Experience Platform UI, in the left rail, select Datasets within DATA MANAGEMENT.
Select Create dataset.
Select Create dataset from schema.
Select the schema that you created earlier and select Next.
Name your dataset and (optional) provide a description.
Select the Profile switch.
You are prompted to enable the dataset for profile. Once enabled, the dataset enriches real-time customer profiles with its ingested data.
You can only enable a dataset for profile when the schema, to which the dataset adheres to, is also enabled for profile.
See Datasets UI guide for much more information on how to view, preview, create, delete a dataset. And how to enable a dataset for Real-Time Customer Profile.
You use the workflow functionality to upload your batch data into Adobe Experience Platform. The example batch file that you are using is a CSV file with following content:
email,loyaltyID,points,status email@example.com,793406,82.16,Silver firstname.lastname@example.org,988654,40.39,Gold email@example.com,444897,91.25,Bronze firstname.lastname@example.org,239658,57.87,Gold email@example.com,365384,82.71,Silver ...
To use workflows:
In the Platform UI, select Workflows in the left rail.
Select Map CSV to XDM schema. Select Launch.
In the Map CSV to XDM schema screen, in the Dataflow detail step:
Select Existing dataset, select your dataset from the dataset list, and name your Dataflow name.
In the Select data step:
Drag and drop or select Choose files to select your CSV file with loyalty data. You see a preview of your loyalty data.
In the Mapping step:
Map your data from the CSV file to the data in your schema. Using AI, the workflow functionality tries to automatically map your batch data fields to the schema fields.
You can use Preview data to see a preview of the mapped data.
Select Finish to start ingesting your batch data into Adobe Experience Platform.
See Map a CSV file top an existing XDM schema for more information on how to map data when your incoming data is not compatible with your XDM schema, use mapping templates, use calculated field to ensure that your batch data is conforming to what the schema is expecting, and more.
To use the Adobe Experience Platform data in Customer Journey Analytics, you create a connection that includes the data resulting from setting up your schema, dataset, and workflow.
A connection lets you integrate datasets from Adobe Experience Platform into Workspace. In order to report on these datasets, you first have to establish a connection between datasets in Adobe Experience Platform and Workspace.
To create your connection:
In the Customer Journey Analytics UI, select Connections in the top navigation.
Select Create new connection.
In the Untitled connection screen:
Name and describe your connection in Connection Settings.
Select the correct sandbox from the Sandbox list in Data settings and select the number of daily events from the Average number of daily events list.
Select Add datasets.
In the Select datasets step in Add datasets:
Select the dataset that you created earlier (
Example Loyalty Dataset) and any other dataset you want to include in your connection.
In the Datasets settings step in Add datasets:
For each dataset:
Select a Person ID from the available identities defined in the dataset schemas in Adobe Experience Platform.
Select the correct data source from the Data source type list. If you specify Other, then add a description for your data source.
Set Import all new data and Dataset backfill existing data according to your preferences.
Select Add datasets.
See Connections overview for more information on how to create and manage a connection and how to select and combine datasets.
A data view is a container specific to Customer Journey Analytics that lets you determine how to interpret data from a connection. It specifies all dimensions and metrics available in Analysis Workspace and which columns those dimensions and metrics obtain their data from. Data views are defined in preparation for reporting in Analysis Workspace.
To create your data view:
In the Customer Journey Analytics UI, select Data views in the top navigation.
Select Create new data view.
In the Configure step:
Select your connection from the Connection list.
Name and (optionally) describe your connection.
Select Save and continue.
In the Components step:
Add any schema field and/or standard component that you want to include to the METRICS or DIMENSIONS component boxes.
Select Save and continue.
In the Settings step:
Leave the settings as they are and select Save and finish.
See Data views overview for more information on how to create and edit a data view, what components are available for you to use in your data view and how to use filter and sessions settings.
Analysis Workspace is a flexible browser tool that allows you to quickly build analyses and share insights based on your data. You use Workspace projects to combine data components, tables, and visualizations to craft your analysis and share with anyone in your organization.
To create your project:
In the Customer Journey Analytics UI, select Projects in the top navigation.
Select Projects in the left navigation.
Select Create project.
Select Blank project.
Select your data view from the list.
Start dragging and dropping dimensions and metrics on the Freeform table in the Panel to create your first report. As an example, drag
Program Points Balance and
Page View as metrics and
See Analysis Workspace overview for more information on how to create projects and build your analysis using components, visualizations, and panels.
You have completed all the steps. Starting by defining what loyalty data you want to collect (schema) and where to store it (dataset) in Adobe Experience Platform, you configured a workflow to batch upload loyalty data into a dataset. You defined a connection in Customer Journey Analytics to use the ingested loyalty data and other data. Your data view definition allowed you to specify which dimension and metrics to use and finally you created your first project visualizing and analyzing your data.