Use Google AdWords as a data source

Resources

Data Source Type: Google AdWords
Authentication:

OAuth Token Authentication

API Documentation: Google AdWords API documentation
Klip Gallery:

Save time and add pre-built Klips with the Klip Gallery!

Klip Gallery: Google AdWords

Step-by-Step

Connect directly to the Google AdWords API using the Google AdWords connector and access all available reports on Google search page ads to use as data sources for your Klips.

To get started, you must first authenticate with Google AdWords and then select a report from one of the many report types.

Creating a data source using Google AdWords

To create a data source using Google AdWords, you need to accomplish the following tasks:

  • Start the data source creation process.
  • Authenticate with Google.
  • Create your AdWords data source.

Note: This guide assumes that you already have an active Google AdWords account.

Step 1: Start the data source creation process

To create a data source using Google AdWords, go to the Connector Gallery page in Klipfolio and select Google AdWords.

Step 2: Authenticate with Google

  1. At Sign in using, choose your existing token from the dropdown list or create a new token by clicking Sign in to Google . You will require a My Client Center (MCC) level access. For more information on MCC accounts, see Understanding My Client Center (MCC) access levels.
  2. If prompted, enter your username and password and allow Klipfolio to access your Google account.
  3. Name and save your Google OAuth token.
  4. After you have created your token, click Next to configure your report.

Step 3: Create your AdWords data source

  1. Select the report type you want to generate from the list and click Select Report.For a comprehensive list of report types, see the Google AdWords Report Types documentation. Below is an example using the Account Performance Report.
  2. Select a Query Mode from the dropdown menu. When you select Standard, the query is automatically generated from your subsequent field selections. Custom allows you to write your own query using the AdWords Query Language (AWQL) - See an example query below.
  3. Select the Column type from an auto-generated list based on the report type you selected.
  4. Select the parameters that you want to measure from the Filters/Predicates from the dropdown menu. (See About predicate values and filters below for more information on Predicates). Every report contains a variety of parameters or fields used for collecting specific data to generate a report. For an extensive list of report types and the meaning of each field, see the Google AdWords Report Types documentation.
  5. Select the Date Range on which you want to filter. To add a date range to a report that does not have one, select a date type from the Columns or Filters/Predicates fields.

To use a custom date range, set Query Mode to Custom and in the AWQL Query box, in the DURING clause, specify From and To dates using standard date range parameters in yyyyMMdd format and wrapped in curly braces. For example, 

DURING {date.addMonths(-1).format('yyyyMMdd')},{date.addMonths(-1).endOfMonth.format('yyyyMMdd')}

  1. Select the Download Format in which you want to download the data. XML and CSV formats are supported.
  2. When you are finished configuring your report, click Generate Report.
  3. If you are happy with the resulting data source, click Continue



About predicate values and filters

Many of the AdWords reports have a large number of different fields associated with them. Fields that include extra options are referred to by Google AdWords as predicate values. Predicate values must have an operator. Examples of operators include “Equals”, “Not Equals”, “Starts With”.

It is important to note that not every predicate value is compatible with every operator and predicates have required operators. For example, the Device predicate requires either the Equals” and “Not Equals” operators.

About AdWords money values

Money type fields in AdWord Reports that return money values in micro currency units (also known as microns). For example, $1.23 US currency is returned as 1,230,000 micros (1.23 x 1,000,000). To convert micros to the currency used by your report, divide the number of micros by 1,000,000.

Note: Options for any Money field must also be in micros.

Errors

For information on error messages you might receive when using the AdWords API, go to the AdWords Common Errors page.

Example of a custom query

The Google AdWords connector in Klipfolio allows you to write your own query in AdWords Query Language (AWQL).

Here is an example for getting AdWords data for the past 30 days:

SELECT
AverageCpc,Amount,Period,Ctr,CampaignId,Clicks,ConversionRate,Cost,CostPerConversion,Date,Impressions,AdNetworkType1,ConversionValue
FROM CAMPAIGN_PERFORMANCE_REPORT
DURING {date.add(-30).format('yyyyMMdd')},{date.today.format('yyyyMMdd')}

To change the parameters to weeks, you can use the following parameter:

{date.addWeeks(-1).format('yyyyMMdd')},{date.today.format('yyyyMMdd')}

Note: Google AdWords expects you to enter the date in this specific format: .format('yyyyMMdd')

To learn more about adding date ranges, see Date parameters in data source queries.

Related Links