Warning: BETA. This connector is a beta version.

Google AdWords

The Qlik Google AdWords Connector uses the Google AdWords API to extract your advertising campaign information, such as customer information or campaign statistics, and load that data into your Qlik Sense app. You can also use the Google AdWords Connector to build custom reports using AdWords Query Language (AWQL) to gather data from most AdWords API services.

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 AdWords data, you will need to authenticate the connector with the Google account that has access to your Google AdWords account. After you create a connection and select Google AdWords as your data source, you will be redirected to a Google login page to retrieve your authentication token.

For some of the tables, you need to enter the client ID. To find this ID, log into the relevant Google AdWords account. On the Accounts page, the client ID is listed in the Account column below. It will have the following format: XXX-XXX-XXXX. The customer ID is also shown when you run the Customers table.

Creating a connection and selecting data

Loading data from tables

After you authenticate the connector with your account credentials, you can use the following tables to select and load data: 

Table Description
Customers Shows the customers and information about customers that are accessible with the authenticated Google Adwords account.
ManagedCustomers Shows the details for managed customer accounts. You need to enter a Client ID.
AdHocReportFromAWQL

Build an ad hoc report with AWQL. You need to enter a Client ID.

See: Use the AWQL to build a report

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

Use the AWQL to build a report

With the AdHocReportFromAWQL table, you can use AWQL to load specific data from a specific Google AdWords report type. AWQL is an SQL-type language that uses the same basic commands, such as SELECT, FROM, and DURING.

Example:  

SELECT Date, Clicks FROM CAMPAIGN_PERFORMANCE_REPORT DURING 2010101,20130101

This AWQL query selects the date and clicks data from the campaign performance report within the defined time range.

To learn more about AWQL, refer to the AWQL documentation.

Working with the Google API quota limits

Reference - Google Developer documentation

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

Troubleshooting

You may receive a report timeout message

Possible cause Possible cause

The report download request is too large. Loading too large data sets may cause the request to time out.

Proposed action Proposed action

Reduce the size of the report download request. There is no explicit data size limit but we recommend to try a smaller date range or to use predicates to break up the report into smaller requests.

Example:  

You are trying to run a report for multiple campaigns but you get timeout errors. Instead of running one report, filter on a subset of campaign IDs and run multiple reports.

Did this information help you?

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