Transferring data to Adobe Analytics
This guide explains how to transfer data to Adobe Analytics to store and further process information.
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 Collecting data from different data sources.
-
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 Advanced Adobe Analytics events data configuration.
Procedure
To transfer data from a datastream to Adobe Analytics, follow these steps:
-
Add Adobe Analytics as a destination to the workspace which contains the datastream or to one of its parent workspaces.
-
Assign the Adobe Analytics destination to the datastream.
-
Configure the Data Mapping of your datastream to conform with Adobe Analytics destination standards.
-
Enable data transfer to the destination from the datastream.
Adding Adobe Analytics as a destination
To add Adobe Analytics as a destination to a workspace, follow these steps:
-
Select the workspace you work with in Adverity and then, in the , click Destinations.
-
Click + Add Destination.
-
Click Adobe Analytics.
-
Click Setup a new Authorization.
-
Click Next.
-
In the
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 include the following boundaries:
(-----BEGIN
[Private Key]-----END)
.
-
-
Click Authorize.
-
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.
-
-
Click Create.
Assigning Adobe Analytics as a destination
To assign the Adobe Analytics destination to a datastream, follow these steps:
-
Select the workspace you work with in Adverity and then, in the , click Datastreams.
-
In the Transfer section, click + Assign destination.
-
Click Assign existing destinations.
-
Select the Adobe Analytics checkbox in the list.
-
Click Save.
Configuring Data Mapping for Adobe Analytics destination
All data that you transfer to Adobe Analytics must conform with Adobe Analytics standards. To configure Data Mapping for the Adobe Analytics destination, follow these steps:
-
Select the workspace you work with in Adverity and then, in the , click Datastreams.
-
In the Data Mapping.
, click
-
For each cell in the Target fields column, enter the value displayed in the Target column in the table below. Enter the values into the Target fields 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 fields 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 fields 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 fields 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.
The Data Mapping changes are saved automatically.
Enabling data transfer to Adobe Analytics destination
To enable data transfer to the Adobe Analytics destination from the datastream, follow these steps:
-
Select the workspace you work with in Adverity and then, in the , click Datastreams.
-
In the list in the Destinations section, find the Adobe Analytics destination, and enable the toggle.
-
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:
-
Select the workspace you work with in Adverity and then, in the , click Datastreams.
-
In the Destinations section, find the Adobe Analytics destination in the list, and click
on the right.
-
Click
Destination settings.
-
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 Data 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 Data 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 Data 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 Data 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.
-
-
Click Save.
Advanced Adobe Analytics tips
For information on transferring Adobe Analytics events data to the Adobe Analytics destination using a custom enrichment, see Advanced Adobe Analytics events data configuration.