Month-End Google Ads Export: Keep Time Zone, Date Basis and Conversions Straight
For B2B paid-media owners: lock account time zone and click-time versus conversion-time, keep primary actions separate, open CSV cleanly, and reconcile one campaign group with CRM before changing bids.
Brand promotion: this article introduces Guangsuan's Google Ads management services.
If you close the month with spend on one side and pipeline on the other, do not touch bids until the export itself answers three questions: which date range and whose clock, which conversion actions on which date basis, and which fields let a row join to CRM later. This note shows a repeatable check for lead-generation accounts where sales decides whether a contact is genuine.
1. Lock range, time zone and conversion date basis first
Write one sentence before you open Google Ads, for example: which ad groups produced sales-accepted enquiry contacts last month, and at what spend. That sentence fixes the view, the period and the action to carry forward. A campaign total explains spend, a campaign-by-day split explains timing, and search terms beside bought keywords explain wording.
On the Campaigns, Ad groups, Keywords, Search terms or Ads page, set the date range and columns first, then use the download control at the top. When day, device, location or conversion pieces must sit together, build that view in Reports instead of stitching separate pulls. For repeats or large pulls, query with GAQL through the API instead of clicking each time.
Exports are dated in the account time zone, which may not match your calendar or CRM timestamps. A form saved late on the final evening can therefore sit in October on one side and November on the other without either side being wrong. Note that account clock 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. One basis counts the event in the period when it happened, the other counts it in the period when the click happened. If a customer clicks on the last day of the month and converts a week later, the two bases put that conversion in different months. Keep a single basis on both sides of a period comparison, and keep the attribution window beside the file.
Before you build a conversion view, open conversion settings and write down the basis, which actions are primary, the counting method and the attribution model. Only actions marked as primary roll into the Conversions column and into bidding. Secondary steps such as page views stay in separate columns with their own labels. Changing counting or attribution reshapes history, so that note belongs with the file.
2. Align platform conversions with CRM revenue as separate stages
The export only shows what Google was able to record, while sales-confirmed numbers live in your own system. Hold four separate tallies through the whole check: clicks, platform-recorded events, qualified enquiries and closed revenue. None cancels another.
For analysis beyond spend and clicks, export search terms and keywords to separate intent from the keyword you bid on. If queries sit outside what the business sells or can deliver, repair match handling and exclusions before bids. If visits arrive without enquiry, review product fit, loading, product detail and enquiry path. Routing every click to the homepage when a matching product page exists calls for a page repair.
- Keep customer ID in the file, keep numeric campaign ID beside campaign name because names get edited, and keep each split that defines a row, such as date, device, network, place and action where used.
- Export the grain you will actually analyse. A monthly rollup can hide a weak week, while a daily pull over a long span turns hard to review. Use the segment control for day, week or month rather than joining several pulls afterward.
- Keep the raw download unchanged and work in a copy named with account, view, range, basis and pull moment, so a retry replaces the same slice.
As a hypothetical teaching illustration with invented figures, not a client result: an extract logs 38 ad-recorded contacts in a closed window. Sales marks 13 as qualified under a written definition, with 10 dated inside that window and 3 dated in the first days after it, and 2 reach order. Each number describes a different stage.
Run one narrow pass first: one primary action, one campaign group, one closed window plus the first days of the next month to catch late entries. Align basis, range and zone on both extracts. Keep ad-sourced rows apart from organic and referral rows. Check counting and double loads before calling a remainder unknown. Leave what remains marked as not yet explained instead of forcing the two sides to tie. For the field workflow behind these choices, see Guangsuan's guide to exporting Google Ads data and reading dates and conversions.
3. Choose a clean open, then decide when to pause and ask for help
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 use: workbooks or Sheets when people must read and comment, comma files when the file must join to a store or script.
Open comma text through Data then From Text or CSV, force UTF-8, confirm the divider, turn spend and clicks from text into numbers, and test one date row first. Spend from the API arrives in micros in account money, so divide once by one million in a noted place and do not mix raw totals across currencies.
Pause bid changes and ask for an account and measurement review when the 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. Bring the site address, main products, target market and budget band, plus history you can authorise for review, which pages already receive paid visits, what the account counts today and what your team treats as a genuine enquiry, and the question sales hears most often. Where structure, query review, pages and checks need owned work, details are on the Guangsuan Google Ads management service, with scope and fees set in a contract and no fixed enquiry promise.
FAQ
Which fields let the file join later? Account identifier, numeric campaign identifier beside its label, plus date and each device, network, place or action split that keeps rows distinct.
Click-time or conversion-time for month-end? Use the rule that answers the opening sentence and keep it the same on both extracts, with window and account clock filed with the file.
Does a file that opens neatly join neatly? No. Neat layout says nothing about row shape, units, timing rule or which actions were summed.
See every redirect as a revenue event.
Book a live walkthrough of the MoeLink attribution dashboard. We'll route a real link through your stack in the call.