Follow our setup guide to connect Adobe Analytics to Fivetran.
Prerequisiteslink
To connect your Adobe Analytics account to Fivetran, you need to have the following entities active and configured:
- An active Adobe Analytics account with at least one report suite;
- This very account must have the Web Services Access enabled. This can be done following these instructions.
Setup instructionslink
Generate private key link
Generate a private key for your Adobe project. Learn how in Adobe’s Service Account Connection documentation. You will need this key to configure Fivetran.
Find credentialslink
-
Log in to your Adobe Analytics account.
-
Go to the Admin Console.
-
Under Products and Services, select your product.
-
On the Adobe Analytics Details page, select your product profile.
-
On the Analytics Settings page, go to the API Credentials tab.
-
Click Add API credentials to create a new integration.
-
Click on the new integration, then click the View on Adobe I/O Console option.
-
In the Adobe Developer Console, go to the Service Account(JWT) tab.
-
In the Credential details tab, find the Client ID, Client Secret, Technical Account ID, and Organization ID and make a note of them. You will need them to configure Fivetran.
Setup configurationslink
Each configuration must have a unique table name. We do not allow multiple configurations to have the same table name. In each configuration, you can choose the report suites, elements, and metrics you want to sync. You can also optionally choose calculated metrics and segments.
We have the following limitations for each configuration:
- 5 Elements (4 + the “datetime” element, which is included automatically) per configuration.
Use the following Adobe resources to choose which elements, metrics, calculated metrics, and segments you’d like to sync. These are the APIs which Fivetran uses to pull the data
NOTE: You cannot query all the elements and metrics together. You can only use certain elements and metrics together to create valid combinations. We verify whether all the combinations are correct, but checking yourself beforehand helps avoid any surprises.
Grant permissionslink
-
Open the Adobe Admin Console.
-
On the Overview page, select Adobe Analytics.
-
In the Product Profiles tab, select the Administrator profile.
-
In the Administrator profile, click the Permissions tab.
-
Click Edit to grant Fivetran read permissions to the Report Suites, Metrics, and Dimensions items.
-
Set the Auto-include toggle to ON to provide permission to all items.
NOTE: If you do not want to use the Auto-include option, you must select the individual items.
- Click Save.
Finish Fivetran configuration link
-
In the connector setup form, enter the Destination schema name of your choice.
-
Enter the Client ID, Client Secret, Technical Account ID, and Organization ID you found in Step 2.
-
In the Key file field, upload the private key file that you generated in Step 1.
-
Click Validate Configuration.
-
Click the + Add Table option to add a custom configuration.
-
Enter the Destination table name. It must be unique within this connector and must comply with Fivetran’s naming conventions.
-
Choose the sync mode you want to use: Sync All Report Suites or Sync Specific Report Suites. If you choose Sync Specific Report Suites, select the report suites you’d like to sync.
-
Select the elements, metrics, calculated metrics, and segments that you decided to sync in Step 3.
NOTE: You cannot modify your element selection after you have created the connector.
-
Click OK to add the configuration.
-
(Optional) To add another configuration, repeat instructions 5-8.
-
Choose your desired aggregation: hour or day.
-
Select how many months of reporting data you’d like to include in your initial sync.
-
Click Save & Test. Fivetran will take it from here and sync your data from your Adobe Analytics account.
Related Contentlink
description Connector Overview
account_tree Schema Information
settings API Connector Configuration