Create lookup datasets to classify data in Customer Journey Analytics

NOTE
Follow the steps on this page only after you complete all previous upgrade steps. You can follow the recommended upgrade steps, or you can follow the upgrade steps that were dynamically generated for your organization with the Adobe Analytics to Customer Journey Analytics upgrade questionnaire.
After you complete the steps on this page, continue following the recommended upgrade steps or the dynamically generated upgrade steps.

Similar to classifications data in Adobe Analytics, lookup datasets are the method for classifying data in Customer Journey Analytics.

When using the Analytics source connector, some standard lookup datasets are automatically applied at report time. For more information, see Add standard lookups to your datasets.

In order to classify data in Customer Journey Analytics when using the Experience Platform Web SDK, you need to create an XDM schema and a lookup dataset for each dimension that contains data that you want to classify.

Create an XDM schema to use with the lookup dataset

Create a new XDM schema for each dimension that contains data that you want to classify in Customer Journey Analytics. When you create the lookup dataset in a later step, it will reference this schema.

Repeat this process for each dimension that contains data that you want to classify.

To create a schema for use with a lookup dataset in Customer Journey Analytics:

  1. In Adobe Experience Platform, select Schemas in the Data Management section in the left rail.

  2. Select Create schema.

    Create schema button

  3. Select Manual. This allows you to manually add fields and field groups to your schema. Choose Select to proceed to the next page of the creation wizard.

  4. On the Schema details page, select Other, then select Custom.

    Create custom

  5. Select Create class.

  6. In the Create class dialog box, specify a name and description for the schema, select Record, then select Create.

  7. Continue with Create a lookup dataset.

Create a lookup dataset

After you create an XDM schema to use for a lookup dataset, you need to create the lookup dataset and map it to your schema.

Repeat this process for each dimension that contains data that you want to classify.

To create a lookup dataset for use with a schema in Customer Journey Analytics:

NOTE
The following process uses a CSV file to create the dataset. You could also use any other method available for importing data into Experience Platform, such as setting up a datastream.
  1. In Adobe Experience Platform, select Workflows in the left rail.

    Create custom

  2. Select Map CSV to XDM schema, then select Launch.

  3. In the Dataset details section, select New dataset.

  4. Specify a name and description for your dataset.

  5. In the Schema field, select the schema that you created for lookup datasets, as described in Create a schema for lookup datasets.

  6. Select Next.

  7. On the Map CSV to XDM schema page, in the Upload files section, select Choose files, then browse your file system for the file that contains the classification information for the dimension for which you want to apply classification data. For example, this might be a spreadsheet that lists the field IDs and corresponding field names.

    Map CSV file

  8. Select Next

  9. After the file uploads, review the mappings to make sure they are accurate. The columns of the CSV file are listed under Source Data and their corresponding XDM schema fields are listed under Target Field.

    Platform automatically provides intelligent recommendations for auto-mapped fields based on the target schema or dataset that you selected. You can manually adjust mapping rules to suit your use cases.

    For more information about the mapping process, see Map a CSV file to an existing XDM schema in the Experience Platform documentation.

  10. Select Finish.

  11. Continue with Add the lookup dataset to your connection in Customer Journey Analytics.

Add the lookup dataset to your connection in Customer Journey Analytics

After you create an XDM schema and you create a lookup dataset, you need to add the lookup dataset to your connection in Customer Journey Analytics.

Repeat this process for each dimension that contains data that you want to classify.

To add the lookup dataset to your connection in Customer Journey Analytics:

  1. In Customer Journey Analytics, select the Connections tab.

  2. Select More icon next to the connection where you want to add the lookup dataset, then select Edit.

  3. Select Add datasets.

  4. In the Add datasets dialog box, select the lookup dataset that you created, then select Next.

  5. In the Person ID field, select a person ID from the available identities defined in the your dataset schema that you configured in Experience Platform.

  6. Select Add datasets, then select Save.

  7. Using the Key field and the Matching key field, create a correlation between the field in your lookup dataset with that in your event or summary dataset.

  8. After all lookup datasets are added to your connection in Customer Journey Analytics, continue following the recommended upgrade steps or the dynamically generated upgrade steps.

recommendation-more-help
080e5213-7aa2-40d6-9dba-18945e892f79