Google AdSense

The Qlik AdSense connector uses the Google AdSense API to access data about your Google AdSense earnings, inventory, and ad clients.

Note: The built-in web connectors are only available on Qlik Sense Cloud with a Cloud Business subscription.

Ways to access your data

To access your Google AdSense data, you need to authenticate the connector with your Google AdSense account credentials. After you create a connection and select Google AdSense as your data source, you are redirected to a Google login page. Log into your Google account using your credentials to receive an authentication code. Enter this authentication code into the connector.

Creating a connection and selecting data

Loading data from tables

After you authenticate the connector with your account credentials, use the tables to fetch your data. The table below outlines use cases for some of the available tables.

Table Description
Accounts Use this table to fetch the list of accounts associated with the authenticated user. The table returns a list of account IDs which can be used to run other tables.
AdClients Use this table to fetch the list of ad clients. This table uses an account ID to return a list of ad client IDs.
SavedReports Use this table to fetch all saved reports for a specific account ID.
GenerateSavedReport Use this table to generate a saved report for a specific account. This table requires a report ID and the associated account ID.

To select and load data from a table, enter the required table parameters and click Preview data. Required parameters are marked with an asterisk (*). 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 AdSense API quota limits

The Qlik Web Connectors use the Google AdSense API to extract data from Google AdSense and load it into your Qlik Sense app. While reloading you AdSense-based app, you might receive an error message that the connector has reached the Google AdSense API rate limit and that all subsequent API calls will fail until the connector falls back under the throttling limit. If you receive this error message, then you have exceeded one of the API rate limits.

Reference - Google AdSense developer documentation

You can refer to the Google AdSense developer documentation to learn more about the requirements and restriction imposed by the Google AdSense API.


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

Possible cause

You have exceeded the API limits that are imposed on the Qlik Web Connectors by the Google AdSense API.

Proposed action

To reduce the impact of reaching the API rate limits, develop your app with the following in mind:

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

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?