Skip to content
SS9SS / FIELD NOTES·

How to Export Google Ads Data Without Misreading Dates and Conversions

By SS9SS Digital

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

If you close the month with spend on one side and pipeline on the other, do not adjust bids yet. Write one question first, for example: which campaign groups produced sales-accepted contacts in the closed month, and at what spend. That sentence fixes the period, the level, and the single conversion action you will carry forward. The mistakes happen in two places: choosing a date range that does not match the question you are asking, and reading the conversions column without knowing which conversion basis it uses.

Lock dates and conversion scope before you download

On the Campaigns, Ad groups, Keywords, Search terms or Ads page, set the date range and columns, then use the download icon at the top right of the table to download a file. When day, device, location or conversion splits must sit together, build that view in Reports instead of merging separate pulls. For repeated or large pulls, query with GAQL through the Ads API instead of clicking each time.

Exports are dated in the account's time zone, which may not match your calendar or your CRM timestamps. Write that zone on the file name or first tab, and check one date row after opening before trusting day-month order. Export the grain you will actually analyse. A monthly rollup can hide a weak week, while daily rows over a long span become hard to review. Use the date-split control for day, week or month rather than joining several ranges afterward.

Conversion placement needs a written note. 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. One basis counts the event when it happened. The other counts it when the click happened. Keep one basis on both sides of a comparison and record the window beside the file. Neither basis is wrong, but they must not be mixed when comparing periods.

Only conversion actions marked as primary roll into the Conversions column and into bidding. Secondary steps such as page views or contact taps stay in separate columns with their own labels. Before you build a report on conversions, open the conversion settings and write down: the basis, 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.

The export only shows what Google was able to record; sales-confirmed numbers live in your own system. Keep clicks, platform-recorded events, qualified contacts and closed revenue as four separate counts through the whole check.

CSV, Excel or Sheets: choose by next use

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 databases, XLSX for spreadsheet work, and the Sheets option when several people need the same live file.

  • CSV for join and storage: use when the file must meet the CRM or a script. 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 for review: use when people must read, filter and comment. Confirm that totals for clicks and cost match the interface summary, and do not rely only on exported averages for ratios.
  • Sheets for shared review: use when several people need the same live file. Use the Sheets delivery option rather than re-uploading a local copy, and keep the raw download unchanged while analysis happens in a copy.

For background on fields and date handling, see Guangsuan's guide to exporting Google Ads data and reading dates and conversions.

Three checks after you have the file

Run this narrow pass before any bid move: one primary action, one campaign group, one closed period plus the first days of the next month to catch late entries.

  1. Check range, level and totals. Is the range closed, is the level account, campaign or group as named in the opening question, and do clicks and cost totals match the interface. 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 and conversion action where used. Name the file with account, report, range, basis and pull time.
  2. Check that the file opens cleanly. Force UTF-8, confirm delimiter, convert cost and clicks from text to numbers, and test one date row before trusting day-month order. Cost from the API arrives in micros in account currency, so convert once by dividing by one million in a noted place. Do not add raw totals across currencies.
  3. Check join readiness on a narrow slice. Align basis, range and zone on both the Ads extract and the CRM extract. Keep ad-sourced rows apart from organic and referral rows. Check counting, repeated uploads and import acceptance before calling a remainder unexplained. Leave any leftover gap marked as open rather than forcing totals to tie.

As a hypothetical teaching illustration with invented figures, not a client case: 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 replaces another.

When to ask for managed help

When structure makes every pull hard to read, when queries and pages point in different directions, or when conversion checks keep slipping between months, bring one annotated export with zone and timing rule written on it. Guangsuan Google Ads management covers account structure, search terms, landing pages, conversion checks and reporting. Scope and fees sit in a contract, with no fixed enquiry-volume promise. Guangsuan does not promise a fixed inquiry volume or a closing result.

FAQ

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

Can a readable file be joined to the CRM? No. Clean layout says nothing about row grain, units, date rule or which actions were summed.

Does a missing term mean zero demand? Not yet. Confirm filters and grain first, because a filtered view can omit very quiet rows.