This extractor allows you to import data from Google Ads. If you do not have a Google Ads manager account, follow this guide to set it up.
To run the extractor, specify your customer ID.
Optionally, you can specify the start (since) and end (until) dates of downloaded stats. The Since/Until parameter is parsed via the strtotime function and can be specified
14 days agoor
In each GAQL 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.
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 replace dot with upper case first letter (for example, for campaign.id use campaignId and for metrics.clicks use metricsClicks).
To download a campaign report, use the following query
SELECT campaign.id, campaign.name, metrics.clicks, metrics.impressions FROM campaign configuration:
This downloads the report into a
campaigns table. The
campaign.id column is listed as
campaignId in the primary columns.
When running the above configuration, you get three tables in the output bucket:
report-campaign. Incremental loading is turned on, so on subsequent runs, new rows are appended.
This table is created automatically and contains a list of all associated customers, for instance:
This table is created automatically and contains a list of all campaigns, for instance:
This table is created by the GAQL query you specified and contains the result of the defined GAQL query, for example:
|12345678||jumped||Ad Group #1||Ad Group #2|
|90123456||fox||Ad Group #1||Ad Group #2|
|78901234||quick||Ad Group #1||Ad Group #2|
|56789012||brown||Ad Group #1||Ad Group #2|