Google Analytics
  • 6 Minutes to read
  • Dark

Google Analytics

  • Dark

Article Summary

Google Analytics is a web analytics tool that provides detailed insights and data about website and app performance. It tracks visitor behavior, traffic sources, user engagement, conversion rates, and other metrics, helping businesses understand their audience, optimize their marketing strategies, and make data-driven decisions to improve their online presence.

Dataddo's Google Analytics connector supports all fields available in the official Google Analytics API. The full list is available here.

How to Create a New Google Analytics Data Source

  1. Under the Sources tab, click on the Create Source button and select the connector from the list.
  2. From the drop-down menu, choose your account.
    Didn't find your account?

    Click on Add new Account at the bottom of the drop-down and follow the on-screen prompts. You can also go to the Authorizers tab and click on Add New Service.

  3. Name your data source and select your metrics and attributes.
  4. [Optional] Configure your advanced settings (for more information please refer to the section on Advanced Settings). If you are unsure about how to proceed, we recommend skipping this step.
  5. Configure your snapshotting preferences. Choose your sync frequency or the exact synchronization time under Show advanced settings.

    If you need to load historical data, please refer to the Manual Data Load page.

  6. Preview your data by clicking on the Test Data button in the top right corner. You can adjust the date range for a more specific time frame.
  7. Click on Save and congratulations, your new data source is ready!

Connector Overview

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 a connector error. On this page, you can check the compatibility of the metrics and dimensions you have chosen.

The Google Analytics API limits the amount of extracted metrics per source. You can extract up to 10 metrics and 7 dimensions per source. If you need more metrics/dimensions, please refer to this section.

Multi-Account Extraction

Our Google Analytics connector supports automatic extraction from all 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.

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.


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


Filters serve as a "limiter" to the data. For example, you can select only specific countries or exclude them.

You want to exclude Czechia and Ireland from your data. In this case, insert the filter as following:



Segments as an optional configuration help you divide your data for more simple navigation. You can, for example, segment the data by device or other specific audience segments.

You can check the segment syntax guide in the Google documentation (if the link doesn't work, simply refresh the page).


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

Select the same dimensions for 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

The 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 when loading historical data.


When creating your source, check how much daily data is being loaded in the data preview. If you have already created your source, click on the three dots next to it, select Show Logs and check the number of rows.

If there is a round number (e.g. 10 000), it is highly probable that not all of your data was loaded as you might have reached the Google Analytics API limit.


Data Preview Unavailable

If there is no data preview after clicking on Test Data, there might be a problem with your source configuration. The most common causes are:

  • Date range: Try a smaller date range. You can load the rest of your data afterward through our manual data load function.
  • Invalid metrics, attributes, or breakdowns: You may not have any data for the selected metrics, attributes, or breakdowns.
  • Incompatible combination of metrics, attributes, or breakdowns: The combination you have selected cannot be queried together. Please refer to the service's documentation to view a full list of metrics that can be included in the same source.

Duplicates in Table

Duplicates are the result of too many dimensions selected when configuring the source. Please replace with a source with less dimensions or make sure these dimensions can work together.

Example: We want to get the total daily number of sessions.

Original table

DateNumber of Sessions
Jan 1 20222

Pagepath dimension (what pages are visited by every user) is added:

DateNumber of SessionsPage
Jan 1 20222Page 1
Jan 1 20221Page 2

Total number of sessions: 3

Where is the problem?

One user visited both Page 1 and Page 2 during the same session.
The same session appeared twice in combination with each page, aka it resulted in a duplicate.

Missing Data

Missing data occurs when the total values was broken down into subcategories and the sum of the two subcategories differs. When working with your data, you need to keep this difference in mind.

This error is caused by Google being unable to retrieve the subcategory information on all of its users and this value is left blank. These blank values are then disregarded instead of being put into their own category.

This error happens most often with Gender or Country dimensions so keep the possibility of this error in mind when working with them.

Example: We want to get how many men and how many women visited my website last week.

Original table

Total Users500

Gender dimension is added:

Total Female Users200
Total Male Users200

What about the rest 100 users?

This error occured because Google was not able to retrieve information on 100 users’ gender and the undetermined values were not put into a separate row.

Fresh Data Unavailable

As Google takes between 24 – 72 hours to process data, it’s possible to get data only from 3 days ago or older.

For Google Analytics, YouTube, or Google My Business, change your date range expression to 3d3 or older.
For Google Search Console, change your date range expression to 4d4 or older.

You may get fresh data from Google Analytics 4 but keep in mind that it might not be the finalized version.

Data Delay Workaround

If you need fresh Google data, Dataddo offers a way to bypass the data delay. Check our blog post on Google Data Processing Delay Workaround.

Intentionally Blank Data in Source Causing Issues

If you have no data in your source, it may lead to a broken source and further issues with synchronization. To be able to send "empty" data to your destination, check the Allow Empty box in the source's settings.

Click on the three dots next to your source, select Edit and scroll down on the Basic Info tab.
Google Analytics - allow empty

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?