Google Ads
You can access your advertising performance data with the Qlik Google Ads Connector.
The Qlik Web Connectors help you connect to different data sources and fetch data in the same way. Learn how to authenticate a data source connection and how to use tables to fetch data.
Supported offerings
- QlikView
This connector must be installed separately.
Ways to access your data
To use this connector you need to authenticate with a Google account that has sufficient permissions to access the Google Ads account that you want to report on.
In the report tables, you will also need to specify a client ID. This value can be retried from the clientCustomer column in the Accounts table.
Tables
After authenticating the connector, you can use the following tables to load data into your app.
| Table | Description |
|---|---|
| Accounts | Lists all accounts to which the Manager has access. |
| Reports |
Allows you to specify a report query using GAQL. For more information, see Google Ads Query Builder and Google Ads Query Language. If you have an existing AdWords Query Language (AWQL), you can migrate it to GAQL query. For more information, see Query Migration Tool. |
Using The Ads Query Language
You can use the Google Ads Query Language (GAQL) to define a report query.
Troubleshooting
Timeouts
The report download request may time out on extremely large data sets. There is no explicit data size limit, however, due to a variety of factors, the server may return an error if the report is too large.
If you encounter time outs or errors, try a shorter date range or use predicates to break up the report request into multiple, smaller requests. For example, instead of running a single report for all campaigns, you could submit multiple requests that each filter for a subset of Campaign IDs.
Error Retrieving Values
The Customer ID dropdown may fail to populate or show an 'Error retrieving values' message. If this occurs, check your AdWords account type. If the account type is 'manager', changing to 'advertiser' should fix the issue.
You cannot load data from the Ads connector
Possible cause
You did not select the Manage your Google Ads Manager campaigns check-box on the consent screen when you were authenticating the connection.
Proposed action
Re-authenticate your connection, and ensure that you selected Manage your Google Ads Manager campaigns.