Brand promotion: this article introduces Guangsuan's Google Ads management services.
When a B2B paid-media owner closes the month and the Google Ads total does not match the CRM, the next step is not another download with the same settings. A reconcilable export needs three decisions written down first: what question the file must answer, which rows belong in the comparison, and which date and conversion definitions both sides will use.
Short answer for month-end
Use a web-table or report download for reading performance, and keep one conversion basis, one account time zone and one closed date range on both sides. Record the account, campaigns, date range, time zone, basis, primary actions, counting method and attribution model next to the file. If the CRM still differs after those fields match, check the measurement setup in the account before re-exporting. Guangsuan's guide to exporting Google Ads data sets out the same date and conversion checks as the starting point.
Which format to choose for month-end
Choose the file by what happens next, not by habit.
- To read and reconcile: download from the Campaigns, Ad groups, Keywords, Search terms or Ads table, or from the Reports section with a defined date range and columns. Set the range first, then add segments by day, week or month when a time series is needed.
- To automate a repeat pull: query through the Google Ads API with GAQL and write rows to a warehouse or database. Keep the credential and developer token in a secured store and schedule the job after the account data for the day is settled.
- To work in a spreadsheet: use CSV for scripts and databases, XLSX for spreadsheet work, and the Sheets option when several people need the same live file. Keep the raw export unchanged and do analysis in a separate copy.
Name the working copy with account, report scope, date range, basis and extraction time. When a job is re-run, replace the same slice rather than adding a second copy, or a retry can double spend and clicks in the sheet.
Which date and conversion fields to fix before downloading
Four groups decide whether the file can be compared with CRM or attribution data.
1. Identity and row grain
Include account ID, campaign ID alongside campaign name, and every segment that distinguishes a row. A campaign total and a campaign-by-day file have different grains. Names can be edited, IDs provide the stable key.
2. Date, time zone and reporting basis
Exports are dated in the account time zone, which can differ from the reviewer calendar or CRM timestamps. Write the time zone on the file.
Google Ads can report conversions on more than one basis. Conversion-time reporting counts a conversion in the period when it happened; click-time reporting counts it in the period when the click happened. 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. Neither basis is wrong, but mixing them in one comparison changes the question rather than only the display.
3. Which conversion actions count
Write down which actions are primary and which are secondary, plus the counting setting and attribution model. Secondary actions, for example a page view or a click-to-contact micro-conversion, are reported separately and should be labelled as such in the export. Changing the primary set, counting or model changes historical comparisons, so record the settings alongside the file.
4. Cost and value columns
Add the cost column and compute ratios in the spreadsheet rather than relying only on exported averages. For analysis beyond spend and clicks, export search terms and keywords, device and network, geographic location, time splits where scheduling matters, and conversion action and value where value-based bidding is in use.
Why the export and the CRM differ
An export from Google Ads shows what Google was able to record. Sales-confirmed numbers stay in the internal system, and the two do not match row for row by design. Before changing bids, compare the same set of records on both sides and separate four counts that answer different questions: clicks, platform-recorded conversions, sales-accepted qualified inquiries, and closed revenue. Adding them produces a number that describes nothing.
Check in this order with one conversion action, one campaign group and one closed period:
- Same account, same campaigns and same closed range on both sides, with totals for clicks and cost matching the interface summary.
- Same time zone and same conversion basis on both sides, with window and model noted.
- Same population: separate ad-sourced leads from organic, referral and other-channel leads before calling a gap unexplained.
- Same action definition: primary versus secondary status, counting and repeated uploads checked before treating a residual as missing data.
Hypothetical teaching example with invented numbers, not a client case: a month-end cut shows 40 form submissions recorded in Google Ads. Sales marks 15 as qualified under a written definition, with 11 qualified inside the same month and 4 in the next month, and 3 reach a later business step. The three totals describe platform recording, commercial validation and business outcome. Uploading all 40 as qualified would replace the agreed definition of a qualified lead with a form fill.
When to check the account foundation instead of re-exporting
Re-export with new columns when the question changed, for example from monthly spend to search-term diagnosis. Check the account setup when the file is complete but the meaning is unclear:
- The conversion action records the wrong step, for example a button click counted the same as a qualified inquiry.
- The landing page does not match the search term, or contact and inquiry paths are missing, so clicks cannot become measurable inquiries.
- Conversion tracking was deployed and never checked, or account structure mixes intents so the report cannot be read by campaign purpose.
In those cases a clean file cannot decide what the business should count as qualified. Guangsuan's Google Ads management work covers account structure, search terms, landing pages, conversion checks and reporting, and describes optimisation around purchasing demand rather than clicks alone. Guangsuan Google Ads management lists analytics linking, measurement and conversion setup, plus search-term analysis and negative-keyword maintenance, as separate work items. Guangsuan states that it does not promise a fixed inquiry volume or a closing result, and that fees and scope are confirmed in a contract.
For a first conversation, bring the website, target market, current problem and historical data you are authorised to share, plus the conversion-action list with primary and secondary status marked and one real export with its basis and time zone written on it.
FAQ
Is a valid file ready for attribution?
No. Validity says nothing about row grain, currency unit, date basis or which conversion actions are included.
Should both sides use conversion time or click time?
Use the basis that answers the question and keep it on both sides. Click time evaluates the ad interaction; conversion time describes outcomes recorded in a period. Record the choice, window and account time zone with every file.
Does reconciling prove which budget change to make?
No. It makes the difference explainable by fixing definitions, population and timing. The budget decision still depends on qualified-inquiry quality and sales feedback, not only on closing the numeric gap.