How to export Google Ads data to CSV with a query

The Google Ads interface exports the columns of whichever table you are looking at. When you need a specific combination of fields — or the same export from several accounts — a query is quicker.

Export from GAQL Lab

1. Open GAQL Lab and pick the account.
2. Write the query, start from an example, or assemble it in the Builder tab.
3. Click Run Query.
4. Click CSV to download the rows, or Copy CSV to paste them straight into a spreadsheet.

Cost values are already converted from micros, and columns have readable headers.

A few useful queries

Search terms with cost and conversions:

SELECT search_term_view.search_term, campaign.name,
  metrics.clicks, metrics.cost_micros, metrics.conversions
FROM search_term_view
WHERE segments.date DURING LAST_30_DAYS
ORDER BY metrics.cost_micros DESC

Keywords with quality score:

SELECT ad_group_criterion.keyword.text,
  ad_group_criterion.quality_info.quality_score,
  metrics.impressions
FROM keyword_view
WHERE segments.date DURING LAST_30_DAYS

Performance by device:

SELECT campaign.name, segments.device,
  metrics.clicks, metrics.conversions
FROM campaign
WHERE segments.date DURING LAST_30_DAYS

The same export from several accounts

Switch the account in the dropdown and run the query again; your recent queries are kept in History.

Making it automatic

If you run the same export every week, turn it into a script. Click AdsApp.search() to copy a snippet that runs the query inside Google Ads, add a few lines to write the rows to a Google Sheet, and schedule it. Deployed through chiliad, one script can fill a separate sheet for each client: see How to use different script settings for each account.