Google Analytics Standard is a free service provided by Google. Of course, it will have many limitations. Even though technically you can export 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 Hit Level Data Extractor by Electrik.AI is designed to export 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: Click on “Add” action button.
Step 6: The Source default tab is selected just click on “Google Analytics Historical Data” connection.
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. Electrik.AI now supports 4 reports, choose the desired type to get the appropriate data. In this example we are choosing Campaign Performance.
b. Use existing/create a new Data set from/in your BigQuery bucket.
c. Select from and to month-year for which you wish to extract the data
d. Provide Success Notification Email, Failure Notification Email.
e. Click “Save and Proceed” to continue.
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.
Note:
1. Let’s say if your GA account is created on Dec 2018 then avoid choosing staring 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.
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.
The eai_ dimensions (e.g. eai_session_id) are captured by Electrik.AI. All Google Analytics dimension and metrics are renamed from ga:<name> to ga_<name>. For example, ga_pagepath is the renamed version of ga:pagePath.
