How to Export Google Ads Data Without Misreading Dates and Conversions
For month-end reconciliation: lock range, time zone and conversion basis, export joinable fields, choose CSV/Sheets vs API, and check queries and landing pages before changing bids.
Brand promotion: this article introduces Guangsuan's Google Ads management services.
If you close the month with Google Ads spend on one side and CRM pipeline on the other, build the export for joining, not for screenshotting. Record range plus account time zone plus conversion-time versus click-time on the file, keep only primary actions in the main total, and keep customer and campaign IDs with every segment that defines a row. Then check Excel formatting, reserve JSON for the API path, and reconcile one action and one campaign group before touching bids.
Lock fields, dates and conversion scope before download
Write one question first, for example: which campaign groups produced qualified enquiries in October, and at what spend. That question decides the view, the period and which action travels forward.
On the Campaigns, Ad groups, Keywords, Search terms or Ads page, set the date range and columns, then use the download control. When day, device, location or conversion splits must sit together, build the view in the Reports area instead.
- Row identity: Keep customer ID in the file, keep campaign ID next to campaign name because names get edited, and keep every split that defines a row, such as date, device, network slice, location slice and conversion action where used.
- Range and grain: Export the grain you will actually analyse. A monthly file can hide a weak week, while a daily file over a long range becomes hard to review. Use the segment control to split by day, week or month rather than stitching several pulls together.
- Time zone: Exports are dated in the account's time zone, which may not match your calendar or your CRM timestamps. Note the zone on the file and check one date row after opening before trusting day-month order.
For conversions, open conversion settings and write down basis, primary flags, counting method and attribution model beside the file.
- Conversion-time reporting counts a conversion in the period when it happened; click-time reporting counts it in the period when the click happened. A click on the last day of the month that converts a week later falls in different months under the two bases. Keep one basis on both sides of a comparison.
- Only conversion actions marked as primary ("included in Conversions") roll into the Conversions column and into bidding. Secondary actions such as page views or contact taps stay in separate columns with their own labels.
- 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. Keep clicks, platform-recorded conversions, qualified enquiries and closed revenue as four separate counts.
For the field workflow behind this checklist, see Guangsuan's guide to exporting Google Ads data and reading dates and conversions.
CSV, scheduled reports and API: use each where it fits
Google Ads supports CSV, CSV for Excel, TSV and XLSX, and can send a file to Google Sheets or by email on a schedule. Pick by next step, not by habit.
- CSV for scripts and storage: Use when the file must join to CRM or a warehouse. Open through Data > From Text/CSV, force UTF-8, confirm the delimiter, turn cost and clicks from text into numbers, and verify one date row first.
- XLSX or Sheets for human review: Use when people must read and comment. Scheduled email fits a shared month-end view; review recipients periodically so an old report does not keep emailing a former colleague.
- API for recurring or large pulls: For recurring, large or automated exports, query with GAQL instead of clicking through the interface. The returned rows carry only the fields named in the query, so include IDs and segments in the query itself. Cost arrives in micros in account currency, so convert once in a noted place.
There is no JSON button in the report download list. When a downstream tool asks for JSON, call the REST interface with a GAQL query or stage the data in a warehouse and emit JSON there. Name files with account, report, range, basis and pull time. Keep the raw download unchanged and work in a copy.
From reconcile to decision: adjust bids or fix the page
Do one narrow pass first: one primary action, one campaign group, one closed period. Align range, zone and basis on both extracts, separate ad-sourced rows from organic and referral, and check counting and repeated uploads before calling a gap unexplained.
- Check queries first: Open the search-terms view beside the bought keywords. If queries fall outside what the business sells or can deliver, fix match types and negatives before bids.
- Check the page next: If visits arrive without enquiry, review product relevance, loading, product information and enquiry path. Sending every click to the homepage instead of a relevant product page calls for a page fix.
- Check tracking last: Changing counting or attribution shifts history. Annotate any account change during the period so the next reader does not read a setting change as performance change.
As a hypothetical teaching illustration with invented figures, not a client result: an export logs 42 ad-recorded contacts in a month. Sales accepts 14 as qualified under a written definition, 10 dated inside that month and 4 in the next month, with 3 reaching order. Each total describes a separate stage, so none cancels another. When few contacts ever qualify, inspect query intent and landing-page fit before adjusting bids.
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 leads actually arrive. Where structure, search terms, landing pages and conversion checks need owned help, details are on the Guangsuan Google Ads management service.
FAQ
Which IDs must be in the file to join to CRM?
Customer ID, campaign ID beside campaign name, plus date and any device, network, location or conversion-action segment that defines a row.
Click-time or conversion-time for month-end?
Use the basis that answers the opening question and keep it identical on both sides, with window and account zone filed with the extract.
Does a readable file mean a joinable file?
No. Clean layout says nothing about grain, units, date basis or which actions were summed.
Ship your first image in 24 hours.
Flat $9 per asset. No shoot fees. No retouching upcharges.