How to Export Google Ads Data Without Misreading Dates and Conversions
Brand promotion: this article introduces Guangsuan's Google Ads management services.
If you export Google Ads results on the first day of the month and again a week later, the two files can disagree even when nobody edited the campaigns. Late conversions arrive, offline events are uploaded, and adjustments remove value. Before calling the gap a tracking failure, lock the date rule and conversion scope that each file uses.
Lock date basis and time zone before you export
Write one question first, for example: which campaign groups produced qualified enquiries in the closed month, and at what spend. That question fixes the view, the period, and which conversion 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 at the top. When day, device, location or conversion splits must sit together, build that combined view in Reports instead of stitching separate pulls.
Exports are dated in the account's time zone, which may not match your calendar or your CRM timestamps. A form saved late on the last evening can sit in October on one side and November on the other, with neither side wrong. Note the zone on the file name or first tab and check one date row after opening before trusting day-month order.
Conversion placement needs the same written note. 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 30 September that becomes a 7 October enquiry falls in different months under the two bases. Keep one basis on both sides of a period comparison and keep the attribution window beside the file. For the field workflow behind this choice, see Guangsuan's guide to exporting Google Ads data and reading dates and conversions.
Keep the file joinable. Keep customer ID in the file, keep numeric campaign ID beside 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. Export the grain you will actually analyse. Keep the raw download unchanged and work in a copy named with account, report, range, basis and pull time.
What to check before you reconcile with CRM
Limit the first pass to one primary action, one campaign group and one closed period plus the first days of the next month to catch late entries. Keep clicks, platform-recorded conversions, qualified enquiries and closed revenue as four separate counts through the whole check.
1. Action definition and date basis
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. Before you build a report on conversions, open conversion settings and write down basis, primary flags, counting method and attribution model beside the file. Changing any of them changes historical comparisons. The export only shows what Google was able to record; sales-confirmed numbers live in your own system.
2. Scope on both sides
Separate ad-sourced rows from organic and referral rows. In the CRM, match the event that corresponds to the Ads action. Lead created is not interchangeable with qualified by sales. Align the month boundary after normalizing timestamps to the reporting time zone.
3. Counting, duplicates and import status
Apply the CRM event rules consistently. Inspect repeated submissions, reopened leads and multiple stages uploaded as separate actions. An event existing in the CRM does not prove Google accepted it. Review upload diagnostics before labeling a missing event a reporting delay. Leave any leftover gap marked as open rather than forcing totals to agree.
Choose a file format by the next step
Google Ads supports CSV, CSV for Excel, TSV and XLSX, and can send a file to Google Sheets or by email on a schedule. Use CSV for scripts, databases and CRM joins, and XLSX or Sheets when people must read and comment. Open CSV through Data > From Text/CSV, force UTF-8, confirm the delimiter, turn cost and clicks from text into numbers, and check one date row first. 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.
When to hand reporting and tuning to managed help
Consider managed help when the account structure makes every export hard to read, when search terms and landing pages point in different directions, or when conversion checks keep slipping between months. Guangsuan's Google Ads management service covers account structure, search terms, landing pages, conversion checks and reporting. Scope, fees and handoff are confirmed in a contract, with no fixed inquiry-volume promise. See Guangsuan Google Ads management service for scope and contact.
As a hypothetical teaching illustration with invented figures, not a client result: an extract logs 36 ad-recorded contacts in a closed window. Sales accepts 12 as qualified under a written definition, 9 dated inside the window and 3 dated in the first days after it, with 2 reaching order. Each total describes a separate stage, so none cancels another. When few contacts ever qualify, review query intent and landing-page fit before adjusting bids.
FAQ
Which date basis and time zone should be locked before export?
Lock the account time zone plus either conversion-time or click-time, with window and primary-action list filed with the extract. Use the same basis on both sides of any comparison.
What three items should be checked first when Ads and CRM differ?
Check action definition and date basis, then eligible scope on both sides, then counting, duplicates and import acceptance. Mark unresolved remainder as open.
When should tuning be handed to a managed team?
When structure, query review, page fit or conversion checks need owned work and internal time cannot cover a clean reconcile pass. Bring one annotated export with basis and time zone written on it.
Put this playbook to work on your funnel.
Bring your CAC, channel mix, and conversion data to a 30-minute Growth Diagnostic with a senior strategist. Walk away with a prioritised backlog of experiments.
Book a Growth DiagnosticOr read the next teardown in The Vallée Lab, or explore how we rebuilt Pipedrive's paid social engine in our case studies.