This extractor allows you to import data from Google AdWords reports. If you do not have a Google AdWords account, create a test account.
Find Google AdWords in the list of extractors and create a new configuration. Name it.
Then click Authorize Account to be redirected to Google, and authorize the extractor to access your AdWords reports.
To run the extractor, specify your customer ID.
To download a report, specify an AWQL query, through which you can customize the output of a predefined report type. There are some specific instructions for using AWQL with reports and mapping of AWQL reports to the UI.
Optionally, you can specify the target bucket in Storage and the start (since) and end (until) dates of downloaded stats.
In each AWQL query, pick columns to download from allowed report values, and the FROM clause from allowed report types. You also need to specify the name of the query and destination table in Storage (in the specified bucket).
Important: customers and campaigns are reserved names, thus cannot be used as table names.
Additionally, for each query, specify a list of columns to be used as a primary key. Use Display Name of the columns as defined in the reports types documentation and replace spaces with underscores (for example, for CampaignId use Campaign_ID and for Date use Day).
To download a keyword performance report, use the following query configuration:
This downloads the report into a
keywords table. The
Id column is listed as
Keyword_ID in the primary columns
because that is its display name.
When running the above configuration, you get three tables in the output bucket:
keywords. Incremental loading is turned on, so on subsequent runs, new rows are appended.
This table is created automatically and contains a list of all campaigns in the used account, for instance:
This table is created automatically and contains a list of all associated customers, for instance:
|1111111111||mycompany||My Company Ltd.||CZK||Europe/Prague|
This table is created by the AWQL query you specified and contains the result of the defined AWQL query, for example:
|12345678||jumped||Ad Group #1|
|90123456||fox||Ad Group #1|
|78901234||quick||Ad Group #1|
|56789012||brown||Ad Group #1|