Exporting from Google Ads is not the hard part — the download button is easy to find. The mistakes happen in two places: choosing a date range that does not match the question you are asking, and reading the conversions column without knowing which conversion basis it uses. Get those two right and the export becomes a usable working file instead of a screenshot.
Three ways to export
- Download from a data table. On the Campaigns, Ad groups, Keywords, Search terms or Ads page, set the date range and columns, then use the download icon at the top right of the table (or the three-dot menu) to download a file.
- Use the reporting area. The Reports section offers Predefined reports (Dimensions) such as campaign, device, geographic and conversion reports, and a report editor for custom tables. Build or open the report, set the date range and segments, then download it. Menu labels are adjusted from time to time, so follow the reporting section rather than a memorised path.
- Pull data through the Google Ads API. For recurring, large or automated exports, query with GAQL instead of clicking through the interface.
Pick the date range before the columns
The range determines what the numbers mean. A few practical points:
- Monthly, weekly and daily views answer different questions. A monthly export can hide a bad week; a daily export against a long range produces a large file. Export the grain you will actually analyse.
- Segment by date when you need a time series. In a table or report, use the segment control to split data by day, week or month rather than exporting several ranges and joining them later.
- Compare like with like. If you compare two periods, make sure both use the same time zone and the same conversion basis, or the difference will partly be an artefact of the settings.
- Note the account time zone. Exports are dated in the account's time zone, which may not match your calendar or your CRM timestamps.
Conversions: click time vs conversion time
This is the part that most often makes an export look "wrong". Google Ads can attribute and report conversions on more than one basis, and the default column is not the only valid view.
- Conversion time vs click time. Conversion-time reporting counts a conversion in the period when it happened; click-time reporting counts it in the period when the click happened. If a customer clicks on the last day of the month and buys a week later, the two bases put that conversion in different months. Neither is wrong — but they must not be mixed when comparing periods.
- Which actions count. Only conversion actions marked as primary ("included in Conversions") roll into the Conversions column and into bidding. Secondary actions — often micro-conversions such as a page view or a click-to-contact — are reported separately and should be labelled as such in your export.
- Counting and attribution. Each conversion action has counting settings (for example, every conversion or one per click) and the account uses an attribution model. Changing either changes historical comparisons, so record the settings alongside the export.
Before you build a report on conversions, open the conversion settings and write down: the basis (conversion or click time), which actions are primary, the counting method and the attribution model. If you rely on offline or CRM-confirmed leads, remember the export only shows what Google was able to record; sales-confirmed numbers live in your own system.
Columns and dimensions worth exporting
The useful extra detail is usually in the dimensions, not the top-line totals. For analysis beyond spend and clicks, export by:
- Search terms and keywords, to separate intent from the keyword you bid on.
- Device and network, to see where performance differs.
- Geographic location, remembering that location reporting distinguishes the location you targeted from the location matched to the user.
- Time (day of week, hour), when scheduling matters.
- Conversion action and conversion value, if value-based bidding is in play.
Add the cost column and a couple of rate columns, then compute your own ratios in the spreadsheet rather than relying only on exported averages. Aggregated averages can hide the segments you actually need to act on.
Formats and scheduled exports
Google Ads supports CSV, CSV for Excel, TSV and XLSX, and can send a file to Google Sheets or by email on a schedule. A few notes:
- Use CSV for scripts and databases, XLSX for spreadsheet work, and the Sheets option when several people need the same live file.
- Scheduled exports need a recipient and frequency; review them occasionally so an old report does not keep emailing a former colleague.
- Name files with project and date (for example, Brand_Campaign_2026-09.csv) so versions do not overwrite each other.
Automating with the API
For recurring pulls, the Google Ads API returns rows you can write straight to a database or warehouse. A minimal Python shape using the official client library:
import csv, os, sys
from google.ads.googleads.client import GoogleAdsClient
customer_id = os.environ["GOOGLE_ADS_CUSTOMER_ID"].replace("-", "")
client = GoogleAdsClient.load_from_storage() # reads google-ads.yaml
service = client.get_service("GoogleAdsService")
query = """
SELECT campaign.id, campaign.name, metrics.clicks,
metrics.conversions, metrics.cost_micros
FROM campaign
WHERE segments.date DURING LAST_30_DAYS
"""
rows = service.search(customer_id=customer_id, query=query)
writer = csv.writer(sys.stdout)
writer.writerow(["campaign_id", "campaign_name", "clicks", "conversions", "cost_micros"])
for row in rows:
writer.writerow([
row.campaign.id, row.campaign.name,
row.metrics.clicks, row.metrics.conversions, row.metrics.cost_micros,
])Keep the service account and developer token in a secured file or secret store, respect the API's request limits, and schedule the job to run after the account's data for the day is settled. The query language is the same one used in the interface reports, so a report you build by hand can usually be translated into a query.
A short, repeatable workflow
- Write the question first ("which search terms wasted spend last month?"), then choose the report and range that answer it.
- Fix the conversion basis and record the settings with the file.
- Export the grain and dimensions you need; avoid one giant all-columns file.
- Add your own rate and cost columns in the sheet, and annotate any account changes during the period.
- Keep the raw export unchanged, and store the analysis separately so you can re-run it.
An export is only useful if the campaign structure behind it is sound — clean naming, one intent per campaign, and conversion tracking that matches how your business actually receives leads. If your reports are hard to read because the account structure is messy, or you want help turning exports into decisions, Guangsuan's Google Ads management service covers account structure, search terms, landing pages, conversion checks and reporting. You can also send us a sample export and we will point out what is worth keeping.