Skip to main content

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.

Information noteGoogle will stop supporting the Google AdWords API on April 27, 2022. This connector is being replaced by the Google Ads Connector. If you have an existing AdWords Query Language (AWQL), you can migrate it to the Google Ads Query Language (GAQL). For more information, see Query Migration Tool.
Information noteThis Google AdWords connector is only available in Qlik Sense SaaS. For the client managed version, see Qlik Web Connectors: Google AdWords.

Supported offerings

  • Qlik Sense Business
  • Qlik Sense Enterprise SaaS

Connecting to your data

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

Creating a data source connection

Selecting data

After you authenticate the connector with your account credentials, use the tables to fetch your data. Some tables are preconfigured to access a specific set of data while others let you create custom queries.

Do the following:

  1. Select a table from the Tables column.
  2. Enter table parameters, if required.

    Required parameters are marked with a *.

  3. Click Data preview to see a sample of your data and to select the table fields that you want to load.

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
Customers Data load editor Shows the customers and information about customers that are accessible with the authenticated Google AdWords account.
ManagedCustomers Data load editor Shows the details for managed customer accounts. You need to enter a Customer ID.
AdHocReportFromAWQL Data manager and Data load editor

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

See: Use the AWQL to build a report

Loading data into your Qlik Sense app

Once you have finished selecting data, you can load your data into your Qlik Sense app. How you proceed will depend on whether you load data with Add data or the Data load editor.

Add data

To load data using Add data, click Add data. This will open the data in the Associations view of the data manager. In the associations view, you can continue to add data sources, transform the data, and associate the tables in Data manager.

Data profiling is enabled by default when you click Add data. Data profiling does the following:

  • Recommends data associations.
  • Auto-qualifies common fields between tables. This adds a unique prefix based on table name.
  • Maps date and time fields to autoCalendar.

Tables are not associated on common field names automatically. You can associate tables in the Associations view.

Managing data associations

Tip note

If you want to load the data directly into your app, click More and then disable data profiling.

When you add data with data profiling disabled, all existing data from data sources will be reloaded when you add the data. Tables will be associated on common field names automatically. Date and time fields will not be created.

Data load editor

To load data with the Data load editor, click Insert script once you are finished selecting the data. A load script is inserted into the script editor of the Data load editor. You can continue to edit the script in the script editor or you can click Load data to run the data load script.

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

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

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.

The Customer ID dropdown shows "Error retrieving values" message

Possible cause

You are trying to run a report against a manager account. Reports can only be obtained for advertiser (non-manager) accounts.

Proposed action

Check your AdWords account type. If the account type is 'manager', change it to 'advertiser'.