Google Analytics

Hevo can replicate your Google Analytics data to your data warehouse using Google’s Reporting API. We 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.

Note: For Pipelines created with this Source, Hevo provides you a fully-managed BigQuery data warehouse Destination if you do not already have one set up. You are only charged the cost that Hevo incurs for your project in Google BigQuery. The invoice is generated at the end of each month and payment is recovered as per the payment instrument you have set up. You can now create your Pipeline and directly start analyzing your Source data. Read Hevo Managed Google BigQuery .

Providing Access to Your Google Analytics Account

Hevo needs permission to view your reports and other reporting entity details. You can read more about these permissions here.

Connection Settings

To configure Google Analytics as a Source:

  1. Click on PIPELINES in the Asset Palette, and then, click + CREATE PIPELINE in the Pipeline Overview page.

  2. In the Select Source Type page, select Google Analytics as the Source.

  3. In the Configure your Google Analytics Account page, click Add Account.

  4. Select your linked Google account, and click Allow to provide Hevo read access to your analytics data.

  5. In the Configure Your Google Analytics Source page, provide the following information:

    1. Pipeline Name: A unique name for your Pipeline.

    2. Account Name: All the Analytics accounts connected to the authorized Google Account would be suggested here; select the appropriate one.

    3. Property Name: The website, application, or entity for which user analytics data is to be read. All the property names associated with the account selected above are suggested; select one according to your need.

    4. View Name: Select the view on which reports must be generated. All the views associated with above account name and property name would be suggested here. Read Hierarchy of organizations, accounts, users, properties, and views to understand the Analytics account structure.

    5. Metrics: Metrics are quantitative measurements that can be reported, based on the View Name you selected in Step 4 above. Select up to 10 Metrics you need in your report as Google’s API request can have a total of 10 metrics. Read Metric for more details.

    6. Dimensions: Dimensions are attributes of your data. Select up to seven dimensions you need in your report as Google’s API request can have a total of 7 dimensions only. Read Dimension for more details.

      Note: Only the dimensions compatible with the metric selected above are available for selection. Read Source Considerations below.

    7. Historical Import Duration (in days): You can choose to import historical data. (if not, it will pull data from the last 90 days).

  6. Specify the Advanced Options which let you limit results to metrics and dimensions with specific characteristics. To know more about this, visit our documentation on Google Analytics Filters.

Source Considerations

  • Hevo is subject to the limits and quotas on the Core Reporting API. Therefore, ingestion may be deferred due to these limits.

  • You can only select the dimensions that are compatible with the metric you select.

  • Even for compatible metric/dimension combination, an error may be displayed stating that the selected metrics and dimensions cannot be queried together, or that the selected metrics/dimensions are restricted. If the metric/dimension set belongs to Google Adwords, Google Analytics 360, or Google Adsense, this may be due to lack of permissions in the selected view.

    For information on valid metric/dimension combinations, refer to Dimensions and Metrics Explorer.

    For information on different types of errors, refer to Google Analytics Core Reporting API Changelog.

Last updated on 20 Oct 2020