Google Analytics
  • 4 Minutes to read
  • Dark
    Light

Google Analytics

  • Dark
    Light

Overview

Available Metrics and Dimensions

The connector supports all the fields available in the official API. The full list is available here.

Combining Metrics and Dimensions

Not all the available metrics and dimensions can be combined together. If the chosen combination is not possible, it will result in the connector error. On this page, you can check the mutual compatibility of the chosen metrics and dimensions.

Google Analytics API limits the amount of extracted metrics per source - 10 metrics and 7 dimensions per source.

How to connect data for more than 10 metrics?

If you need more than 10 metrics for a given combination of dimensions (and given that the final combination of 10+ metrics and your dimensions works together), you can create multiple sources and blend them together.

You will need to select exactly the same dimensions in all of the sources and then blend the sources using all of these dimensions as join keys directly in your BI tool or warehouse.

Extraction Limits

  • Google Analytics API has a data extraction limit of 10 000 rows per single request. Our connector features automatic pagination, so the data extraction is distributed into multiple calls, and the extraction limit can be effectively increased to 250,000 rows.
  • You can edit the limit of how much data is being loaded for the historic load.
TIP: How to check if you reached the limit?

When looking in the log, a round number (e.g. 10000) is visible, most probably you did not load all the data. An easy way to estimate the limit is to check how much daily data is being loaded, when creating the source in the preview, or go to Sources and click on the log of the source to see Row counts from the last load).

Multi-account Extraction

Our Google Analytics connector supports automatic extraction from all the available Google Analytics accounts. This feature is particularly useful when you have multiple accounts and need to automatically extract the same metrics and dimensions across them (e.g., online agencies).

No Data / Allow Empty

If you have no data in your source, it may lead to a broken source and further issues with synchronization. When checking the Allow Empty box in the source's settings, you will be able to send "empty" data.
Google Analytics - allow empty

How to Create a Google Analytics Data Source

  1. Sign in to your Dataddo account and click on Sources at the top of the page.

  2. Click on Create Source in the top right corner.

  3. From the list of sources, choose Google Analytics. You can type the name of the connector into the search bar to find it faster.
    Data sources - choose connectors

  4. From the drop-down menu, choose your Google Account connected to Dataddo, Analytics Account, Property, and View. Click on Next to continue with the setup.
    Google Analytics - account

    1. Didn't find your account?
      If you want to connect a new account that is not on the list, click on Add new Account at the bottom of the drop-down. You will be redirected to the authorization/sign-in page to confirm the right account. Once you confirm, you will be redirected back to the Dataddo app.
      Google Analytics - step 4b

    2. Authorize your account
      If you have not authorized your Account with Dataddo, click on Add new Account and you will be redirected to the authorization/sign-in page.

    3. After you log in and give Dataddo the necessary permissions to access your data, you will be redirected back to the connector.

  5. Choose a Name for your Data Source, select the Metrics, the Dimensions, and the Data Labels. To continue to the next page, click Next.

    • NOTE: You can only select 10 metrics and 7 dimensions per source
      Google Analytics - metrics
  6. The next page is optional. You can fill Filter and Segment. If you are not sure what to select in this step, we recommend you skip to the next one. Click on Next to continue.

    • Read more about the effects of Filters and Segments and some examples below.
      Google Analytics - optional settings
  7. Configure your snapshotting preferences by choosing your Sync frequency. Under Advanced setting,s you can select the exact Time, of synchronization. Confirm your setup by clicking on Next.
    If the Data range is available to select, you can load historical data. Read more in our guide.

  8. Before saving the source, you can see a preview of your data by clicking on the Preview button. you can adjust the date range to a more specific view.

    • Also, you can see the full list of the metrics you selected by clicking on Show all Metrics and attributes, in the left navigation.
      Data source - create - preview
  9. Click on Save and your new Data Source is ready.

Congratulations, your new Data Source is ready!


Broken View / Error Message

If you cannot see a preview of your data, go back a few steps and check your setup. The most common causes are:

  • Date range - we recommend a smaller date range. If you need to load historical data, check our guide.
  • Invalid metrics, attributes or breakdowns, or their combination - you may not have any values for them.
    Data source -create- error

Filters and Segments

In the Dataddo app, the filters and segments applied to your source will be visible in your destination but will not affect the original data in Google analytics.

TIP

See the article on Google Analytics Reference Fields for a description of the metric_names needed for filter/segment creation

Filters

Filters serve are a ""limiter"" to the data. You can filter for example specific countries or exclude them.

EXAMPLE

If you want to exclude some country, where country=Czechia or country=Ireland, then insert the filter as follows:
ga:country!=Ireland
ga:country!=Czechia

Segments

Segments as an optional configuration help you divide your data, so it is easier for you to navigate. For example, you want to segment the data by device or other specific audience segments.

You can check the segment syntax guide directly in the Google documentation.


Need assistance?

Feel free to contact us and we will help you with the setup. To speed the process of resolving your issue, make sure you provide us with sufficient information.


Was this article helpful?