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.

Prerequisites

  • An active Google Analytics account.

Configuring Google Analytics as a Source

Perform the following steps to configure Google Analytics as the Source in Hevo:

  1. Click PIPELINES in the Asset Palette.

  2. Click + CREATE in the Pipelines List View.

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

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

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

  6. In the Configure your Google Analytics Source page, specify the following:

    Test & Continue

    • Pipeline Name: A unique name for your Pipeline, not exceeding 255 characters.

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

    • 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.

    • 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.

    • 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.

    • 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.

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

  7. 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.

  8. Click TEST & CONTINUE.

  9. Proceed to configuring the data ingestion and setting up the Destination.


Schema Mapping Considerations

During ingestion of the report data, the following additional columns are created in the Destination database along with metrics and dimension:

  • __hevo_id: Represents a unique ID of each unique event present in the Source data. Hevo derives this from the primary key columns of your Google Analytics data.

  • __hevo_report_date: Represents the date on which a report is fetched by Hevo.

    Report structure


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.


Source Considerations

  • Hevo is subject to the limits and quotas set 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. Incompatible metrics are greyed out based on the selected dimensions.

  • Even for compatible metric/dimension combinations, 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 on 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.


Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Mar-09-2021 1.58 Added section Schema Mapping Considerations.
Last updated on 01 Jun 2021