Skip to content
MoeLink — Field Notes

Google Ads CSV Exports: Keep Time Zone, Date Basis and Conversions Straight

A handoff-ready way to export Google Ads data for month-end: set the question and row grain first, label time zone and conversion basis on the file, open CSV cleanly, then read any Ads-CRM gap by stage before changing bids.

MMoeLink SEO与数字营销

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

Suppose a teammate must rerun your month-end file without asking you what each column meant. The export then needs more than correct numbers. It needs a written question, a stated row shape, a stated clock, and a stated conversion scope. Build those four notes first, and the later comparison with CRM becomes a check of stages rather than a dispute about which tool is wrong.

What the file needs to show before you click download

State the handoff question in one plain sentence, for instance: which ad groups brought enquiry contacts that sales later accepted last month, and what did those groups spend. That sentence fixes the period, the level of detail, and which action is carried forward.

A campaign total shows spend. A campaign-by-day split shows timing. Keywords placed beside search terms show which wording consumed budget. Those are different row shapes, so do not force them into one sheet. Guangsuan's walkthrough for reading export dates and conversions describes the same choice as question first, then view and grain.

Decide grain you will truly study. A single monthly rollup can hide one weak week. A daily pull across a long span turns hard to scan. Use the split control for day, week or month where a time series is needed, rather than joining several separate pulls afterward.

Set the calendar labels first: range, zone and conversion timing

Each row uses the clock configured for that ad account, which can differ from the clock your CRM records with. A form saved late on the final evening can therefore sit in October on one side and November on the other, with neither side mistaken. Mark that account clock on the file name or first tab, and inspect one date line after opening before trusting day-month order.

Conversion placement needs the same written note. One timing rule files the event under the date it happened. The other files it under the date of the tap that led to it. A tap near the end of September that turns into an early October enquiry therefore lands in different months under the two rules. Keep a single rule on both sides of a period comparison, and keep the attribution window beside it.

Before shaping a conversion view, open conversion settings and note timing rule, primary flags, counting choice and attribution approach. The headline Conversions figure counts just the steps you flagged as primary; helper steps such as views or contact taps live in other columns with their own labels. A shift in counting or attribution reshapes history, so that note belongs beside the file. The export alone cannot show sales-confirmed results; those totals stay in your own system.

Choose table, report or API, then open the file cleanly

Open the Campaigns, groups, keywords, query or ad screen, fix period plus columns, then press the export icon at the top. Use that path when a defined view is enough for review.

When day, device, location or conversion pieces must appear together in one table, shape the view in the Reports area with a preset view or a custom table, then download. For repeats or heavy pulls, send a GAQL query through the Ads API instead of clicking. Returned rows carry just the fields named in the query, so include identifiers and splits in the query itself.

Ads files come as CSV, CSV for Excel, TSV and XLSX, with delivery to Sheets or by scheduled mail. 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 > From Text/CSV, force UTF-8, confirm the divider, change spend and taps from text to 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.

Leave the account identifier inside the workbook, place number-form campaign identifier next to its editable label, and keep each field that makes rows unique, such as date, device, network part, place part and action where used. Save the first download as read-only and do all sorting in a duplicate. Name the working copy with account, view, range, timing rule and pull moment so a retry replaces the same slice.

Read an Ads-CRM gap as separate stages

Hold taps, platform-recorded events, qualified enquiries and closed income as four separate tallies through the whole check. When a large share never meets the written qualified definition, treat that as a definition gap first.

Look at queries beside bought keywords. When wording sits outside what the business sells or can deliver, repair match handling and exclusions before touching bids. When visits arrive without enquiry, review product fit, loading, product detail and enquiry path. Routing every tap to the homepage instead of a matching product page calls for a page repair.

As a hypothetical teaching illustration with invented figures, not a client outcome: a file logs 54 ad-tracked contacts in a closed window. Sales marks 19 as qualified under a written definition, 14 dated inside that window and 5 dated in the first days after it, with 3 reaching order. Each number tells a different stage, so none cancels another.

Run one small match before moving bids: one primary action, one campaign set, one closed window plus the first days of the next month to catch late entries. Line up timing rule, range and zone on both extracts. Review counting behaviour and double loads before naming a remainder unknown. Keep whatever remains labelled as not yet explained instead of pushing the two sides to tie.

What to prepare before asking for help

A tidy file cannot fix a tangled account. Clear naming, one aim per campaign, and tracking that fits how leads truly arrive are what make the next export readable. Where layout, 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.

Bring the site address, main products, target market and budget band, plus history you can authorise for review. Add 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.

Quick checks

Which fields let the file join later?
Account identifier, number-form campaign identifier next to its label, plus date and each device, network, place or action split that keeps rows distinct.

Tap-time or action-time for month-end?
Use the rule that answers the opening sentence and keep it the same on both sides, with window and account clock filed with the extract.

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.

Get a live demo