Skip to main content Skip to complementary content

Google Analytics 4

The Google Analytics 4 connector extracts traffic and engagement metrics from your Google Analytics 4-enabled websites and apps and loads that data into your Qlik Sense apps.

Information noteGoogle is replacing Universal Analytics with Google Analytics 4. For more information about this change, see Google Analytics Help.

Supported offerings

  • Qlik Sense Enterprise on Windows
  • Qlik Sense Desktop

Encryption keys

If you are using this connector on Qlik Sense Enterprise on Windows or Qlik Sense Desktop, you will need to set an encryption key.

For more information, see Setting an encryption key.

Ways to access your data

When you create a connection, you're redirected to a Google login page where you authenticate the connector by logging in with your Google account credentials. You can then retrieve your authentication code and return to the connector setup to finalize the connection. After the connection is created, select Google Analytics 4 as your data source.

Creating a data source connection

Loading data from tables

After you create the connection, use the tables to fetch your data. The table below outlines some of the use cases for some of the tables that are available.

Tables that can be loaded
Table Available in Description
ListAccounts Data manager and Data load editor Use this table to fetch all accounts accessible by the authenticated user.
ListProperties Data manager and Data load editor

Use this table to fetch child properties for the specified parent. Get the account name from the ListAccounts table.

GetMetaData Data manager and Data load editor

Use this table to fetch metadata for dimensions and metrics available in reporting methods. Get the property name from the ListProperties table.

RunRealtimeReport Data manager and Data load editor

Use this table to fetch a customized report of real-time event data for your property. Events appear in real-time reports seconds after they have been sent to Google Analytics. Real-time reports show events and usage data for the periods of time ranging from the present moment to 30 minutes ago (up to 60 minutes for Google Analytics 360 properties). Get the property name from the ListProperties table.

For more information, see Realtime Dimensions and Metrics.

RunReport Data manager and Data load editor

Use this table to fetch a customized report of your Google Analytics event data. Reports contain statistics derived from data collected by the Google Analytics tracking code. The API returns the data as a table with columns for the requested dimensions and metrics. Metrics are individual measurements of user activity on your property, such as active users or event count. Dimensions break down metrics across some common criteria, such as country or event name. Get the property name from the ListProperties table.

For more information, see API Dimensions and Metrics.

To select and load data from a table, enter the required table parameters and click Preview data. Required parameters are marked with an asterisk (*) in the dialog. The table fields are displayed under the Data preview tab. You can select fields individually by selecting the box beside each field name. Select Insert script after you have made your selection.

Creating a connection and selecting data

Working with the Google API quota limits

For information about Google API quota limits, see Google Analytics 4 Quotas.

You receive an error message that you have reached the API rate limit

Reference - Google Analytics 4 developer documentation

Refer to the Google Analytics 4 developer documentation to learn more about the Google API.

Troubleshooting

You receive an error message that you have reached the API rate limit

Possible cause

You have exceeded the Google API limits.

Proposed action

To avoid API rate limit exhaustion, develop your app with the following in mind:

  • Extract only the data you need.
  • Reload one Google Analytics-based application at a time.
  • Ensure that loops in your script that make API calls will not result in infinite loops.

You are receiving unexpected data or conflicting data

Possible cause

Differences in data can be due to a misinterpretation of the dimensions and metrics or due to the sampling used by Google Analytics.

Proposed action

Request data over smaller periods, for example, instead of requesting data for a month at a time, request data over a day or a week at a time.

Check that you also get the same numbers in the Google Query Explorer. The connector gets the data from the same system, so there should not be any differences.

Use the following procedures to identify and reconcile the differences:

  • Run exactly the same metrics in the connectors as on the platform.

  • Use the connector or the Query Explorer, and not your application, to check values by recreating the metric and looking at the data tab in Qlik Web Connectors.

  • Try to match the manual report to the connector, so if the connector gives you three columns of data, that is, date, pages visited and average time, then get the same report manually and compare the values.

  • Match the time scales. If the connector gives you each day's data for a month, but the manual report just gives you one figure for the whole month then values like averages will be affected.

  • Try a smaller time scale or data set as this will make it easier to identify where data is missing, so check numbers on a day by day basis.

  • Check the ranges coming back in the connector. If you select a date range, check that all those dates are in the data, that is, the first or last days are not missing.

If the values in the connector can be matched to the manual reports, but there is still a problem in the application, then you need to review your script, data model, expressions and objects, to check what you get in Qlik Web Connectors is the same as that fed into your application.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!