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.
- 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.
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:
- Select a table from the Tables column.
Enter table parameters, if required.
Required parameters are marked with a *.
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.
|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.
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.
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.
If you want to load the data directly into your app, click 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.
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.
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
You can refer to the Google Developer documentation to learn more about the requirements and restriction imposed by the Google AdWords API.
You may receive a report timeout message
The report download request is too large. Loading too large data sets may cause the request to time out.
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.
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
You are trying to run a report against a manager account. Reports can only be obtained for advertiser (non-manager) accounts.
Check your AdWords account type. If the account type is 'manager', change it to 'advertiser'.