Hevo can replicate your Google Analytics' data to your data warehouse using Google's Reporting API. We would recommend you to go through the Google Analytics Query Explorer before creating the pipeline to ensure you configure it the way you require. You can also refer to the Common Queries section to find the solution for you basic queries.
Note: We’re subject to limits and quotas on Core Reporting API so we may be deferring the polling jobs due to these limits.
Let's walk through the steps for adding Google Adwords as a source.
1. Create Pipeline
Click on PIPELINES option in the left navigation bar and click on Create New Pipeline.
2. Select Source Type
Select Google Analytics from the list on Select Source Type Screen.
3. Authorise Hevo to Access
You need to add your Google Account first. Click on Add New Account. You will be taken to Google to log in and asked to authorize us. The permissions we are looking is to view your reports and other reporting entity details which would help us to pull reports.
You can read more about these permissions here.
4. Configure Google Analytics Source
You need to configure some basic details like:
Source Name: A unique name for your Google Analytics Source.
Account Name: All the Analytics accounts connected to the authorized Google Account would be suggested here, select the appropriate one.
Property Name: The property names associated with the account selected above would be suggested, select one according to your need.
View Name: All the views associated with above account name and property name would be suggested here. You know what to do. You can refer this to understand the Analytics account structure.
Dimensions: Dimensions are attributes of your data. Refer this for more details. Select up to 7 Dimensions you need in your report as Google’s API request can have a total of 7 dimensions only.
Metrics: Metrics are the quantitative measurements. Refer this for more details. Select up to 10 Metrics you need in your report as Google’s API request can have a total of 10 metrics.
Historical Import Duration(in days): You can choose to import historical data. (if not, it will pull data from the last 90 days).
We have a set of advanced options which lets you limit results to metrics and dimensions with specific characteristics. To know more about this, visit our documentation on Google Analytics Filters.
5. Select the Destination
Select the Destination where you want to replicate your Google Analytics data or click on NEW DESTINATION to create a new Destination. Check out How to add a Destination tutorial for the detailed walk-through on steps needed for adding new Destination.
6. Pipeline Created
Your Pipeline will be created when you enter this page and you will have an option to Map Schema.
While Hevo tries to load your schemas, you can select CONTINUE IN BACKGROUND if it is taking too much time. Click on CREATE SCHEMA MAPPING to map Source and Destination Schemas, check out Introduction to Schema Mapper to learn about Schema Mapper or you can select DO IT LATER to directly head to Pipeline page. You can map schemas later on Schema Mapper page in your pipeline.
Please note that your data will not start replicating in Destination tables until you map source and Destination schemas.