Skip to content
MoeLink — Field Notes

Month-End Google Ads Export: Lock Dates and Conversions Before You Touch Bids

For a lead-generation account at month-end: write account time zone and conversion basis on the export, pick CSV, Sheets, Ads Editor or API by task, and check definition, queries and page fit before changing bids.

MMoeLink SEO与数字营销

Brand promotion: this article introduces Guangsuan's Google Ads management service. It is a vendor introduction, not an independent review.

This note is for a paid-media owner who closes the month with two files that do not match: spend by campaign and day from Google Ads, and qualified pipeline by close date from the CRM. Do not adjust bids until the export itself carries three notes: which calendar rule was used, which conversion actions were counted, and which fields make a row joinable.

Write the reconcile question before you open Google Ads

One sentence decides the view, the period, and the action to carry forward. Example: which campaign groups produced sales-accepted demo requests in October, and at what spend. A campaign total answers spend. A campaign-by-day split answers timing. Search terms beside the bought keyword answers intent.

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

Put range, zone and timing rule on the file

Exports are dated in the account's time zone, which may not match your calendar or your CRM timestamps. A lead saved late on the last evening can sit in October on one side and November on the other, with no error on either side. Write 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. One basis counts the event on the date it happened. The other counts it on the date of the click that led to it. A 30 September click that becomes a 7 October enquiry therefore falls in different months under the two rules. Keep one basis on both sides of a period comparison and keep the attribution window beside it.

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. Only conversion actions marked as primary roll into the Conversions column and into bidding. Page views and button 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 account currency on the file. Do not add raw totals across accounts in different currencies. When an API row returns cost in micros, divide once by one million in a noted place. For background on dates and columns, see Guangsuan's guide to exporting Google Ads data and reading dates and conversions.

Match format to the next action

  • CSV for join and storage: use when the file must meet the CRM. Open through Data > From Text/CSV, force UTF-8, confirm the delimiter, and turn cost and clicks from text into numbers.
  • XLSX or Sheets for review: use when people must read and comment. A single download does not create a live refresh connection.
  • Ads Editor for edit and return: use when you will change structure in bulk or keep a structural backup. Keep original columns and use import rather than retyping.
  • API or warehouse for JSON: use when a downstream tool asks for JSON. Report downloads list Excel CSV, TSV, PDF, XLSX, XML, and Google Sheets, not JSON. Call the REST interface with a GAQL query and receive only the fields named in the query, or stage data in a warehouse and emit JSON there.

Keep customer ID in the file. Keep numeric campaign ID beside campaign name because names get edited. Keep each split that defines a row, such as date, device, network slice, place slice and conversion action where used. Export the grain you will actually analyse. Name the file with account, report, range, basis and pull time. Keep the raw download unchanged and work in a copy.

When platform numbers and sales notes differ, check in this sequence

  1. Definition first: keep clicks, platform-recorded events, qualified enquiries and closed revenue as four separate counts. When a large share never meets the written qualified definition, the gap is a definition gap.
  2. Queries next: open the available search-terms view. When queries fall outside what the business sells or can deliver, fix matching and negatives before bids.
  3. Page next: when 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.
  4. Link survival last: keep ad-sourced rows apart from organic and referral rows. Do not treat country, device or nearby time alone as a match.

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.

One narrow pass before any bid change

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. Align basis, range and zone on both extracts. Check counting and repeated uploads before calling a remainder unexplained. Leave any leftover gap marked as open rather than forcing totals to agree.

An export is only useful if the campaign structure behind it is sound — clean naming, one intent per campaign, and 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.

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.

Get a live demo