Google Ads Month-End Export: What to Check Before You Reconcile

Brand promotion: this article introduces Guangsuan's Google Ads management services.

Direct answer with conditions: before you export for month-end, write down the question the file must answer, then lock three things on the export itself: range plus account time zone, conversion basis plus which actions count, and row identity plus file name. If you compare September spend to September outcomes, keep the same basis and zone on both sides and reconcile one primary action and one campaign group first.

What to lock before you press download

Write one decision sentence first, for example: which campaigns produced qualified leads in October, and at what spend. That sentence decides the view, the period, and which conversion action travels forward. A campaign total answers spend. A campaign-by-day split answers timing. Search terms beside the bought keyword answers intent. Do not force different grains into one table.

On the Campaigns, Ad groups, Keywords, Search terms or Ads page, set the date range and columns first, then use the download control to save the file. When day, device, location or conversion splits must sit together, build the view in the Reports area instead. For a repeated or large pull, query with GAQL through the Ads API rather than clicking each time.

Exports are dated in the account's time zone, which may not match your calendar or your CRM timestamps. Note that zone on the file itself and check one date row after opening CSV before trusting day-month order. A monthly view can hide a weak week, while a daily pull across a long span becomes hard to review, so export the grain you will actually analyse.

Keep a stable row identity. Keep the customer ID in the file and keep the campaign ID next to the campaign name, because names get edited. Keep every split that defines a row, such as date, device, network slice, location slice and conversion action where used. Name the file with account, report, range, basis and pull time. Keep the raw download unchanged and work in a copy. For the field workflow behind this checklist, see Guangsuan's guide to exporting Google Ads data and reading dates and conversions.

Conversion date vs click date: how to record it

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 basis is wrong, but a period comparison must not mix them.

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. Changing any of them changes historical comparisons, so keep that note beside the file.

Only conversion actions marked as primary ("included in Conversions") roll into the Conversions column and into bidding. Secondary steps such as a page view or contact tap stay in separate columns and should keep that label in the sheet. Do not add primary and secondary together and present the sum as customers.

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 through the whole check.

As a hypothetical teaching illustration with invented figures, not a client result: a file logs 42 ad-tracked contacts attributed to September clicks. Of those, 30 converted in September and 12 converted in October. Another 7 leads converted in September after August clicks. September by click time is 42. September by conversion time is 37. Both numbers are valid for different questions. Do not divide September spend by 37 and call it the acquisition cost of September clicks.

A narrow month-end reconciliation checklist

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 and storage, XLSX for sheet review, and Sheets when several people must see the same live file. Open CSV through the text import wizard, force UTF-8, confirm the delimiter, turn cost and clicks from text into numbers, and verify one date row first. Cost through the API arrives in micros in account currency, so convert once in a noted place.

1. Pick one primary action, one campaign group and one closed period.
2. Align range, zone and conversion basis on both the Ads extract and the CRM extract.
3. Separate ad-sourced rows from organic and referral rows.
4. Check counting, repeated uploads and import diagnostics before calling a gap unexplained.
5. Label each snapshot provisional or restated with the next review date, and leave any leftover gap marked as open rather than forcing totals to match.

When to bring a managed service

Self-serve fits a settled question where one person can keep period, zone, names and counting notes steady. Bring managed help when names mix intents, tracking logs the wrong step, or queries and landing pages point apart.

Guangsuan's Google Ads management service covers account structure, search terms, landing pages, conversion checks and reporting. Scope and fees sit in a contract, with no fixed enquiry promise. Details are on the Guangsuan Google Ads management service page. For a first review, bring the action list with primary flags plus one annotated export that shows basis and zone.

FAQ

Which date rule for month end? Use the rule that answers the opening question and keep it unchanged on both extracts, with window and zone written on the file.

Does a readable file mean a joinable file? No. Clean layout says nothing about row grain, units, date rule or which actions were summed.

Can a missing term mean hidden quiet rows? Confirm filters and grain first, because a filtered view can omit very quiet rows before you conclude the term never matched.