Transferring data to Adobe Analytics

This guide explains how to transfer data to Adobe Analytics to store and further process information.

Concept

Adobe Analytics is an Active Destination. After you set Adobe Analytics as the Destination of a Datastream, data is transferred to Adobe Analytics each time data is fetched for the Datastream. For more information, see Destination types.

You can assign multiple Destinations to a Datastream. For more information on possible limitations, see Assigning multiple Destinations to a Datastream.

Limitations

Transferring data to Adobe Analytics comes with the following limitations:

  • After transferring data to Adobe Analytics, it takes Adobe Analytics a substantial amount of time to process the data. For more information on data processing guidelines, see the Adobe Analytics documentation. Below are some typical data processing times:

    • Processing data from the current day takes approximately 2 hours to complete after the data upload.

    • Processing data from the previous day takes approximately 3 hours to complete after the data upload.

  • Only Adobe Analytics Support can remove the data from Adobe Analytics Destination. For more information, contact Adobe Engineering Services.

Prerequisites

Before you complete the procedure in this guide, perform all of the following actions:

  • Create a Datastream whose data you want to transfer to Adobe Analytics. For more information on creating a Datastream, see Introduction to collecting data.

  • Ensure that the account you use to connect to Adobe Analytics is an Adobe Analytics Service Account. For more information, see the Adobe Analytics documentation.

  • In the Data Extract, ensure the following columns are present.

    • Ensure one of the following three User Identifier fields is included:

      • marketingCloudVisitorID

      • IPAddress

      • customerID.[customerIDType].id

    • Ensure one of the following four Page Identifier fields is included:

      • pageURL

      • pageName

      • pe

      • queryString

    • Ensure the following fields are included in the Data Extract:

      • timestamp

      • userAgent

      • customerID.[customerIDType].isMCSeed (this is only required if ustomerID.[customerIDType].id is selected above in the User Identifier field).

  • (Optional) If events data is to be transferred to Adobe Analytics, the data must be in a specific format. Create an enrichment script that puts the events data in the correct format. For more information see Formatting Adobe Analytics events data.

Procedure

To transfer data from a Datastream to Adobe Analytics, follow these steps:

  1. Add Adobe Analytics as a Destination to the Workspace which contains the Datastream or to one of its parent Workspaces.

  2. Assign the Adobe Analytics Destination to the Datastream.

  3. Configure the Schema Mapping of your Datastream to conform with Adobe Analytics Destination standards.

  4. Enable data transfer to the Destination from the Datastream.

  5. Configure transfer settings.

Adding Adobe Analytics as a Destination

To add Adobe Analytics as a Destination to a Workspace, follow these steps:

  1. Click the Transfer element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. Click + Add.

  2. Click Adobe Analytics.

  1. Click Setup a new Authorization.

  2. Click Next.

  1. In the Authorization page, fill in the following fields:

    API Key (Client ID)

    The API Key of the Adobe Analytics account. For instructions on how to find your API Key, see the Adobe Analytics documentation.

    Client Secret

    The Client Secret of the Adobe Analytics account.

    Technical account ID

    The Technical account ID of the Adobe Analytics. Enter in the following format: id@techacct.adobe.com.

    Organization ID

    The Organization ID of the Adobe Analytics. Enter in the following format: org_id@AdobeOrg.

    Private key

    The Private key associated with your Adobe Analytics Service Account. The Private key must be PEM encoded and included the following boundaries: (-----BEGIN [Private Key] -----END).

  2. Click Authorize.

  3. In the Configuration page, fill in the following fields:

    Name

    (Optional) Rename the Destination.

    Company id

    Select the Company id from the drop-down list.

    Report suite id

    Select the Report suite id from the drop-down list.

  1. Click Create.

Assigning Adobe Analytics as a Destination

To assign the Adobe Analytics Destination to a Datastream, follow these steps:

  1. Click the Connect element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. Select the chosen Datastream.

  1. In the Destinations section, click + Add Destination.

  2. Click Assign Existing Destinations.

  1. Select the Adobe Analytics checkbox in the list.

  2. Click Save.

Configuring Schema Mapping for Adobe Analytics Destination

All data that you transfer to Adobe Analytics must conform with Adobe Analytics standards. To configure Schema Mapping for the Adobe Analytics Destination, follow these steps:

  1. Click the Connect element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. Select the chosen Datastream.

  1. In the top navigation panel, click Schema Mapping.

  1. For each cell of the Target column, enter the value displayed in the Target column in the table below. Enter the values into the Target column exactly as they appear.

    The Data Extract contains one of three User Identifier values. Enter one of the following User Identifier values into the Target column:

    Name

    Target

    IP address

    IPAddress

    Marketing cloud visitor ID

    marketingCloudVisitorID

    Customer ID

    customerID.[customerIDType].id

    If the value of customerID.[customerIDType].id is in the Data Extract, ensure the value of customerID.[customerIDType].isMCSeed is also in the Data Extract.

    The Data Extract will contain one of four Page Identifier values. Enter one of the following Page Identifier values into the Target column:

    Name

    Target

    Page URL

    pageURL

    Page name

    pageName

    Type of custom link

    pe

    Query string containing data

    queryString

    For more information on the queryString column, see the Adobe documentation.

    The Data Extract contains the following Required fields values. Enter the following values into the Target column:

    Name

    Target

    Time stamp

    timeStamp

    User agent

    userAgent

    Customer ID seed

    customerID.[customerIDType].isMCSeed

    In addition to the required fields, all fields listed in the CSV Column and Query String Reference in this section of the Adobe documentation are also transferable.

  2. Click Save Mapping.

Enabling data transfer to Adobe Analytics Destination

To enable data transfer to the Adobe Analytics Destination from the Datastream, follow these steps:

  1. Click the Connect element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. Select the chosen Datastream.

  1. In the list in the Destinations section, find the Adobe Analytics Destination, and enable the toggle.

  2. In the All tasks tab, find the top element, and click Requeue for Import on the right.

Configuring transfer settings

To configure transfer settings, follow these steps:

  1. Click the Connect element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. Select the chosen Datastream.

  1. In the Destinations section, find the Adobe Analytics Destination in the list, and click on the right.

  2. Click Destination Settings.

  1. Fill in the following fields:

    User Identifier

    Select the column in the Data Extract used to identify users. Ensure the selected User Identifier is entered into the target column of the Schema Mapping exactly as it appears here. For example, if marketingCloudVisitorID is selected as a User Identifier, enter marketingCloudVisitorID into the target column of the relevant row of the Schema Mapping.

    If customerID.[customerIDType].id is selected, then customerID.[customerIDType].isMCSeed must be selected in Required fields. A customerID.[customerIDType].isMCSeed must also be present in the Data Extract with a value of 1 (this corresponds to a value of TRUE). Do not enter the value of 1 in quote marks as this causes the value to be omitted from the query string.

    Page identifier

    Select the column in the Data Extract used to identify pages. Ensure the selected Page Identifier is entered into the target column of the Schema Mapping exactly as it appears here. The value of pageURL is selected by default.

    Required fields

    Select the following required fields:

    • timestamp

    • userAgent

    Ensure the selected values in Required fields are included in the Data Extract. Check the target column of the Schema Mapping and ensure the column names are exactly the same as the select value names.

    Ensure customerID.[customerIDType].isMCSeed is selected in Required fields if customerID.[customerIDType].id is selected in the User Identifier field.

  2. Click Save.