Adobe Analytics Data Export

What is Adobe Analytics?

Adobe Analytics gives web behavioral data into customizable visualizations so as to make better marketing decisions. Adobe Analytics lets you mix, match, and analyze data from anywhere in the customer journey and provides all-round reporting, predictive intelligence and more.

How to add Adobe Analytics Source in Electrik.AI?

Follow these steps to connect your Adobe Analytics account to Electrik.AI

Step 1: Ensure you have following prerequisites to create an Adobe Analytics Connection in Electrik.AI

             a. Access to Adobe Analytics account

             b. Username & Password

             c. Host, RSID & Directory to Scan details

Step 2: Sign-in into your Electrik.AI account

Step 3: Select IO in Electrik.AI dashboard

Select IO in Electrik.AI dashboard

Step 4: Select the Connections tab in the left most navigation bar & click on “Add” action button.

Select the Connections tab in the left most navigation bar & click on “Add” action button

Step 5: The Source default tab is selected just click on “Adobe Analytics” connection.

The Source default tab is selected just click on Adobe Analytics connection.

Step 6:  Choose the destination type of your Adobe Analytics Data feed, selected when creating the Data feed in Adobe. (Currently we only provide SFTP)

Choose the destination type of your Adobe Analytics Data feed selected when creating the Data feed in Adobe.

Step 7: Provide your Adobe Analytics details.

Provide your Adobe Analytics details.

Step 8: Click on Save button on the top.

Click on Save button on the top

Congratulations, you have successfully created an Adobe Analytics Connection in Electrik.AI

Congratulations, you have successfully created an Adobe Analytics Connection in Electrik.AI

What are the supported Data Destinations?

Electrik.AI creates a data flow (or ETL process) that exports Adobe Analytics data to a target data warehouse. This process runs daily at scheduled time and exports data for the previous day. Currently we are providing only BigQuery destination.

PostgreSQL Data Destination-Eletrik.AI
MySQL Data Destination-Electrik.AI
AzureSQL Data Destination-Eletrik.AI
Google Big Query Data Destination-Elecrik.AI

How to export Adobe Analytics Data?

Electrik.AI creates a data flow (or ETL process) that exports Adobe Analytics data to a target data warehouse. This process runs daily at scheduled time and exports data for the previous day. 

Follow these steps to create a Data Flow from Adobe Analytics to Data Warehouse

Step 1:  Ensure you have the following prerequisites.
1. Access to Adobe Analytics Account.
2. Access to BigQuery Data Warehouse.
3. Adobe Analytics Connection details such as Username & Password, Host, RSID & Directory to Scan details
Step 2: Sign-in into your Electrik.AI account.
Step 3: Select IO in Electrik.AI dashboard

Select IO in Electrik.AI dashboard

Step 4:  Click on Add button to create Adobe Analytics Flow

Click on Add button to create a Microsoft Ads Flow

Step 5:  Select Adobe Analytics Connection present in the list of available sources.

Select Adobe Analytics Connection present in the list of available sources.

Step 6: Select your existing Adobe Analytics connection in Electrik.AI.

Select your existing Adobe Analytics connection in Electrik.AI.

To configure a new connection, refer to this link.

Step 7: Click on a destination of your choice from list of available destinations. Currently we are providing only BigQuery destination.

Click on a destination of your choice from list of available destinations

Step 8: Select your existing BigQuery connection in Electrik.AI.

Select your existing BigQuery connection in Electrik.AI.

To Configure a new connection, refer to this  link.

 Step 9:

             a. Use existing/create a new Data set from/in your BigQuery project

             b. Provide a valid Email ID to receive the Flow Success/Failure Email Notification.

create a new Data set from/in your BigQuery project

Note:

* By Default, Electrik.AI uses the signed-in user’s Email Id.

* By Default, Electrik.AI chooses an existing Database Schema to load your Adobe Analytics Report. You can create a new schema in your database by selecting the “Create New Schema” radio button.

c. Click “Save and Proceed” to continue.

Electrik.AI uses the signed-in user’s Email Id.

Congratulations, Flow is created. Please wait while you are redirected to Flow Details Screen.

Congratulations, Flow is created. Please wait while you are redirected to Flow Details Screen

You have now successfully setup Adobe Analytics to BigQuery Data Warehouse flow in Electrik.AI

You have now successfully setup Adobe Analytics to BigQuery Data Warehouse flow in Electrik.AI

Your Adobe Analytics will start loading after 24 hours in your Data Warehouse.

Note: Following lookup table will also get created and populated for maintaining Lookup IDs – adb_browser;adb_browsertype;adb_colordepth; adb_connectiontype; adb_country; adb_event;adb_javascriptversion; adb_languages;adb_mobileattributes; adb_operatingsystems; adb_plugins;adb_referrertype;adb_resolution;adb_searchengines.

New-Your Adobe Analytics will start loading after 24 hours in your