Google Analytics Historical Data Extractor

Google Analytics Standard is a free service provided by Google. Of course, it will have many limitations. Even though technically you can extract data out of Google Analytics there are few problems.
a. You need to write a build a custom solution using Google Analytics APIs to export data.
b. The event/hit data does not provide a Unique Visitor Id hence the data cannot be integrated with other omnichannel marketing data sources such as  Mailchimp, Shopify and other CRM systems.
Google Analytics Historical Hit Level Data Extractor by Electrik.AI is designed to extract historical hit level data as old as your google analytics account and load it in a database.

Step 1: Ensure you have following prerequisites to create a Google Analytics Historical Data Connection in Electrik.AI

a. Access to Google Analytics Account.

b. Google Analytics Account User Id and Password.

c. Google Analytics Property Id; View Id 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 panel.

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

Step 6:  Provide your Google Analytics account User Id and Password.

Step 7: Enter all the details.

a. Select your analytics account from the drop down.

b. Select your analytics account property from the drop down.

c. Select your account property view from the drop down.

Step 8: Click on Save button on the top.

Step 9: Congratulations, you have successfully created Google Analytics Historical Data connection in Electrik.AI.

Electrik.AI supports the following databases to export Google Analytics Historical Data. It is important to note that Electrik.AI itself is not a destination. A destination is required to export data from various marketing data sources using Electrik.AI.

Electrik.AI creates a data flow (or ETL process) that exports Google Analytics data to a target database or data warehouse.

Step 1: Ensure you have the following prerequisites.

1. Access to Google Analytics Account.
2. Google Analytics Account User Id and Password.
3. Google Analytics Property Id; View Id details.
4. Admin Access to Google BigQuery.

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 a Google Analytics Historical Data Extractor Flow.

Step 5: Select Google Analytics Historical Data Connection present in the list of available sources.

Step 6: Select your existing Google Analytics Historical Data 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.
In this example we are choosing Google BigQuery. 

Step 8:  Select your existing Google BigQuery connection in Electrik.AI.
To Configure a new connection, refer to this link.

Step 9:
a. Select Month for which you wish to extract the data
b. Use existing/create a new Data set from/in your BigQuery project
c. Provide Success Notification Email, Failure Notification Email.

Success Notification Email: Enter a valid Email ID to receive the Flow Success Email Notification.
Failure Notification Email: Enter a valid Email ID to receive the Flow Failure Email Notification.

d. Click “Save and Proceed” to continue

Note:
1. Let’s say if your GA account is created on Dec 2018 then avoid choosing month less than Dec 2018.
2. If payment method is not added only first 7 days (of selected date range) of historical hit level data will be exported.
3. By Default, Electrik.AI uses the signed-in user’s Email Id to send notification.
4. By Default, Electrik.AI chooses an existing Dataset to load your GA data. You can create a new dataset in your bucket by selecting the “Create Data Set” radio button.

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

You have now successfully setup Google Analytics Historical Data to Google BigQuery flow in Electrik.AI

Your Google Analytics Historical Data will start loading after 24 hours in your Google BigQuery Dataset.

The following is an overview of the dimensions and metrics Electrik.AI can extract from Google Analytics.