Skip to main content

Intro

Adobe Analytics helps you create a holistic view of your business by turning customer interactions into actionable insights. Domo’s Adobe Analytics V2 connector allows you to retrieve data through prebuilt reports. You can then combine metrics with data from CRM, POS, or any other system to make faster, better-informed business decisions. To learn more about the Adobe Analytics API, visit their website (https://adobedocs.github.io/analytics-2.0-apis/#/ ). You connect to the Adobe Analytics API in the Data Center. This topic discusses the fields and menus that are specific to the Adobe Analytics v2 connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.

Prerequisites

To connect to the Adobe Analytics API v2 and create a DataSet, you must have the Client ID and Client Secret associated with your Adobe Analytics v2 account. Visit Adobe Oauth Connection documentation to learn more about obtaining your Client ID and Client Secret.

Creating a new OAuth project in Adobe Developer Console

To create a new OAuth project in Adobe Developer Console, do the following:
  1. Log into https://console.adobe.io/projects.
  2. Click Create new project button.
New_Project_button.png
  1. Click on Add API to start using the Adobe services.
Add_API.png
  1. The APIs available to you will be listed in the Add an API window. Select Adobe Analytics.
Add_an_API-Adobe_Analytics.png
  1. Now, you need to select the authentication type. Select OAuth here.
OAuth-service_account_OAuth.png
  1. Select the Web platform to configure the API. Enter the Default redirect URI as https://oauth.domo.com/api/data/v2/oauth/providers/adobe-analytics-oauth/exchange Enter the Redirect URI pattern as https://oauth/.domo/.com/api/data/v2/oauth/providers/adobe-analytics-oauth/exchange
  2. Click Save configured API.

Connecting to the Adobe Analytics API v2

This section enumerates the options in the Credentials and Details panes in the Adobe Analytics v2 connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

Credentials Pane

This pane contains fields for entering credentials to connect to the Adobe Analytics API v2. The following table describes what is needed for each field:

Field

Description

Client ID Enter the client id associated with your Adobe Analytics v2 account.
Client Secret Enter the client secret associated with your Adobe Analytics v2 account.
Once you have entered valid credentials, you can use the same account any time you go to create a new Adobe Analytics v2 DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

Details Pane

This pane contains the information about the predefined Adobe Analytics v2 reports.

Menu

Description

Report

Select the Adobe Analytics v2 report you want to run:

Calculated Metrics This report returns a list of calculated metrics.
Collections This report returns a list of report suites.
Dimensions This report returns a list of dimensions for a given report suite.
Metrics This report returns a list of metrics for a given report suite.
Report Data This report returns reporting data for the requested metric and dimension for the given date range.
Segments This report returns a list of segments.
Users This report returns a list of users for the company.

Global Company ID

Select the company.

Report Suite id

Select the Report Suite ID.

Enter the report body JSON object instead of selecting metrics, dimensions and segments

Select this checkbox to enter the report body JSON object.
Clear the checkbox to select the metrics, dimensions, and segments, and Domo will create the report body JSON for you.

Body

Paste the Body here, according to Adobe specifications (see Adobe Swagger UI ).
Do not include the dimensions or date range in the report body; instead, specify the dimensions and date range below. Domo uses the provided dimensions to create the recursive report bodies to get the multiple dimension data.
The report body must be a valid JSON and must contain the rsid and metrics.

Metrics

Select the metrics.

Use label as column name

Select the checkbox to use labels instead of IDs as column names for calculated metrics.

Dimension 1

Select the dimensions in drill order.

Dimension 2

Select the dimensions in drill order.

Dimension 3

Select the dimensions in drill order.

Dimension 4

Select the dimensions in drill order.

Dimension 5

Select the dimensions in drill order.

Dimension 6

Select the dimensions in drill order.

Segments

Select one or more segments to filter the data by segments

Include Anomaly Detection

Select the checkbox to include anomaly detection.

Date Selection type

This field appears when you select the Report Data report.

Select the date selection type for the report. You can either select a custom date range or use predefined date ranges from Adobe.

Predefined Date Range

This field appears when you select the Predefined Date Range from Adobe option in the Data Selection type field.

Select the predefined date range from Adobe.

Report Dates

This field appears when you select the Custom Date Range option in the Data Selection type field.

Select the report dates.

Include Type

Include additional calculated metrics not owned by the user. The ‘All’ option takes precedence over ‘Shared.

Date Selection

Select the specific or relative date range. You can either select Single date or Date range from the drop-down list.

Start Date - Specific Select the first date in your date range using the date selector.
End Date - Specific Select the last date in your date range using the date selector.
Start Date - Relative

Enter the number of days back that you would like to get data from (start day). Combine with End Date to create a range of represented days.

For example, if you enter10 for Start Date and 5 for the End Date, the report would contain data starting from10 days ago until 5 days ago.

End Date - Relative

Enter the number of days back that you would like to get data to (end day). Combine with Start Date to create a range of represented days.

For example, if you enter 10 for Start Date and 5 for End Date, the report would contain data for 10 days ago up until 5 days ago.

Reset Data

Select the box to reset the data if required. Run the data once by selecting the check box and then clear the checkbox to proceed normally. Note: This will replace all the data in your dataset, and may result in loss of data if the dataset uses the Append mode.

Exclude Formula Definition (checkbox)

Check the box to exclude formula definition columns.

Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.

FAQs

A: Connect your customer insight data to Domo using V2 of Adobe’s API and authenticating using OAuth. This API provides the same functionality as the V1.4 of the API.
A: Adobe Analytics OAuth has a refresh token that expires after two weeks (see Adobe documentation for details.) This causes Adobe OAuth to no longer authenticate after two weeks. This is an Adobe limitation. Older datasets use WSSE authentication (Username:Company, Password), but Adobe has deprecated WSSE authentication. Please contact Adobe support to request a resolution to this issue.
A: Refer to the Adobe Analytic’s Migrating Guide for details. Version 2 is designed to run smaller requests quickly, compared to version 1.4 which handle large requests slowly. This design change means that Domo cannot automatically migrate your datasets into version 2.
A: The Adobe Analytics and Adobe Analytics Advanced connectors use version 1.4 of the Adobe Analytics API, while this connector uses version 2.