Brand promotion: this article introduces Guangsuan's Google Ads management service.
At month-end, a B2B SaaS paid-media owner often holds two sheets that disagree: spend by campaign from Google Ads, and qualified contacts by date from the CRM. Neither sheet has to be wrong. The usual cause is preparation: the downloaded sheet lacks a stable row key, carries no note about clock or timing rule, or mixes conversion steps that should stay apart. This note gives a short preparation routine you can finish before any attribution discussion.
Who this checklist helps
This routine fits a B2B SaaS team running lead generation where sales decides whether a contact meets a written qualified definition. It does not promise more enquiries or closed deals. It only makes the next review concrete: one stated question, one annotated file, and a clear handoff list.
Guangsuan's Google Ads management work covers account layout, search-term review, landing pages, conversion checks and reporting. Scope and fees sit in a contract. If your structure is messy or tracking was set up but never checked, bring that file to the first conversation instead of debating totals. Details are on the Guangsuan Google Ads management service.
Start from one written question
Write one line before opening the account, for example: which campaign groups created sales-accepted contacts in the closed month, and at what spend. That line fixes the level, the window, and which action moves forward. A campaign total explains spend. A daily split explains timing. Queries beside purchased keywords explain wording. Keep those levels in separate sheets.
Which views and columns to keep
Set period and columns on the Campaigns, Ad groups, Keywords, Search terms or Ads screen, then use the download control at the top. When day, device, place or action cuts must appear together, assemble that combined view inside Reports rather than joining separate downloads later.
- Keep identifiers that survive edits: account identifier plus numeric campaign identifier beside the editable name, plus every cut that makes a row distinct, such as date, device slice, network slice, place slice and action where relevant.
- Keep intent detail where the opening question needs it: search terms against bought keywords, plus device, place, hour, action and cost.
- Keep the first download untouched and work in a copy labeled with account, view, range, timing rule and pull moment, so a retry replaces the same slice.
For the full download and date-reading workflow, see Guangsuan's guide to exporting Google Ads data and reading dates and conversions.
How to note clock and conversion timing
Rows carry the clock set inside the ad account, which can differ from the clock in your calendar or CRM. A form saved late on the final evening can therefore land in different months on the two sides with no error on either side. Mark that account clock on the filename or first tab, and inspect one date row after opening before trusting day-month order.
Timing of conversions needs the same written note. One rule files the event under the date it occurred. The other rule files it under the date of the click that led to it. A late-month click that turns into an enquiry a week later lands in separate months under the two rules. Use one rule on both sides of any period comparison and keep the window beside the file.
Open conversion settings before shaping a conversion view and record timing choice, primary flags, counting choice and attribution approach beside the file. The headline Conversions figure counts only steps flagged as primary. Helper steps such as page views or contact taps belong in other columns with their own labels. A shift in counting or attribution reshapes history, so that note must travel with the extract. The download shows only what Google managed to record; sales-confirmed totals remain in your own system. Hold clicks, platform-recorded events, qualified enquiries and closed revenue as four separate tallies.
Fix checks first, then discuss attribution
- Run one narrow pass: one primary action, one campaign group, one closed window plus the first days of the next month to catch late entries.
- Line up timing rule, range and clock on both extracts, and keep ad-sourced lines apart from organic and referral lines.
- Review counting behaviour and double loads before naming a remainder unknown. Leave what remains marked as open rather than forcing agreement.
As a hypothetical teaching illustration with invented figures, not a client outcome: a sheet logs 28 ad-recorded contacts in a closed window. Sales marks 11 as qualified under a written definition, 8 dated inside the window and 3 dated in the first days after it, with 2 reaching order. Each figure tells a separate stage. When queries sit outside what the business sells or can deliver, repair matching and exclusions before touching bids. When visits arrive without enquiry, review product fit, loading, product detail and enquiry path instead of only adjusting offers.
What to bring for a first review
Bring the site address, main products, target market and budget band, plus history you can authorize for review. Add the action list with primary status marked, and one real extract with timing rule and zone written on it. Also add your written qualified definition with one filled example. Those three items let Guangsuan point to what to keep without guessing.
FAQ
Does a sheet that opens neatly join neatly?
No. Neat layout says nothing about row shape, units, timing rule or which actions were summed.
Which timing rule suits month-end?
Use the rule that answers the opening line and keep it the same on both extracts, with window and account clock filed with the file.
When should tuning be handed to a managed team?
When layout, query review, pages and checks need owned work and internal time cannot cover a clean pass.