Google Analytics
  • 8 Minutes to read
  • Dark
    Light

Google Analytics

  • Dark
    Light

 

As of July 2, 2023, Google Analytics has been fully replaced by Google Analytics 4 and stopped producing data. This means that your GA sources will display a 'No Data Available' error message. Your historical data will be available until the end of 2023.

Article Summary

Google Analytics or Universal 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.

Refer to Google's official documentation to see all available endpoints from the Google Analytics API.

If you have multiple Google Analytics accounts and would like to extract the same data from all of them, it's possible through multi-account extraction. Contact our Solutions team to enable this feature.

Authorize Connection to Google Analytics

To authorize this service, use OAuth 2.0 to share specific data with an application while keeping usernames, passwords, and other information private.

  1. On the Authorizers page, click on Authorize New Service and select your service.
  2. Follow the prompts to grant Dataddo the necessary permissions to access and retrieve your data.
  3. [Optional] Once your authorizer is created, click on it to change the label for easier identification.

Ensure that the account you're granting access to holds at least admin-level permissions.

For more information, see our article on authorizers.

How to Create a New Google Analytics Data Source

  1. On the Sources page, 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.
    DATADDO TIP

    If you need to load historical data, please refer to the Data Backfilling article.

  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.

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.

DATADDO TIP

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

Filters

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

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

ga:country!=Ireland
ga:country!=Czechia

Segments

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


Limitations

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.

Number of Rows

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.

DATADDO TIP

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.

Historical Data Load

Due to the Google Analytics API's limitation

  • Some combinations of metrics will not work (check Google Analytics official documentation for the metrics that can be queried together)
  • A maximum of 10 metrics and 7 dimensions can be selected per source

You can edit the limit of how much data is being loaded for the historical load.

TIP: How can I see if I've reached the limit?

If you see a round number (e.g. 10,000) in the logs, most likely not everything was loaded.
Check how much daily data is being loaded when creating the source in the data preview, or in the logs. Go to Sources, click on the three dots next to your source, and select Show Logs to see the row counts from the last load.

Troubleshooting

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.
  • Insufficient permissions: Please make sure your authorized account has at least admin-level permissions.
  • 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

TotalNumber
Total Users500

Gender dimension is added:

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

Data Sources - Allow Empty

Related Articles

Now that you have successfully created a data source, see how you can connect your data to a dashboarding app or a data storage.

Sending Data to Dashboarding Apps

Sending Data to Data Storages

Other Resources


Was this article helpful?