Adobe Analytics Data Export

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.

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

Step 4: 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.

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)

Step 7: Provide your Adobe Analytics details.

Step 8: Click on Save button on the top.

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

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.

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. 

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

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

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

Step 6: 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.

Step 8: 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.

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.

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

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.