Brand promotion: this article introduces Guangsuan's Google Ads management services.
A monthly review often starts with a download that looks complete but does not join to the CRM. The file opens, the totals differ, and the team argues about spend. The fix is before the export: choose the row grain, the date basis and the conversion definition, then reconcile in one order.
Short answer: Google Ads reporting downloads do not offer JSON, so use CSV, XLSX or Sheets for review and keep JSON for the API or warehouse route. Before reconciling, fix identity and grain, date range and account time zone, conversion basis and which actions count, and cost units, and record all of it in the file name.
Start with the question, not the button
You can download from a Campaigns, Ad groups, Keywords, Search terms or Ads table with the download icon, or build a report in the Reports area and download it. For recurring pulls, query with GAQL through the Google Ads API instead of clicking. In each case write the question first, for example which search terms spent budget without qualified leads last month, then pick the range and dimensions that answer it.
Check 1: Identity and row grain
A reconcilable export starts with identity and grain: include the customer ID, campaign ID alongside campaign name, and every segment that separates a row, such as date, device and conversion action.
Names are edited, IDs are not. A campaign total and a campaign-by-day-by-device file have different grains, and a key that ignores that difference lets valid rows overwrite each other. Add search terms and keywords to separate intent from the keyword you bid on, plus device, network, geographic location and time when the question needs them. Avoid one giant all-columns file.
Check 2: Date range, time zone and conversion basis
Exports are dated in the account time zone, so write that time zone on the file and compare conversion-time to conversion-time or click-time to click-time without mixing them in one comparison.
A monthly export can hide a bad week, while a daily export over a long range becomes hard to read. Segment by day, week or month with the segment control rather than joining several ranges later. Conversion-time reporting counts a conversion in the period when it happened; click-time reporting counts it in the period when the click happened. Neither is wrong, but they must not be mixed when comparing periods. Record the basis, the conversion window, counting method and attribution model next to the file, because changing any of them changes historical comparisons.
Check 3: Which conversions count, and what the file cannot show
Only conversion actions marked as primary roll into the Conversions column and into bidding. Secondary actions, such as a page view or click-to-contact, are reported separately and should be labelled as such in your export.
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 clicks, platform conversions, qualified leads and closed revenue apart. They answer four questions, and adding them produces a number that means nothing. Cost arrives in micros and in the account currency, so convert once, record where it happened, and keep forecast value separate from booked revenue.
Reconcile in a fixed, repeatable order
Reconcile one conversion action, one campaign group and one period first, then separate ad-sourced leads from organic and referral records before checking counting settings and repeated uploads.
Keep the raw export unchanged, name files with account, report, range, basis and extraction time, and replace the same slice on retry instead of appending a second copy.
Hypothetical teaching example with invented numbers, not a client result: an account file shows 40 form submissions in a month. Sales marks 15 as qualified under a written definition, 11 inside the same month and 4 after it closes, and 3 become orders. None contradicts the others because each describes a different step. If most submissions are never qualified, check queries and the landing page before changing bids.
An export is only useful if the campaign structure behind it is sound, with clean naming, one intent per campaign, and conversion tracking that matches how the business actually receives leads. For the full field workflow, see Guangsuan's guide to exporting Google Ads data and reading dates and conversions.
Where Guangsuan fits
Guangsuan's Google Ads management covers account structure, search terms, landing pages, conversion checks and reporting, with optimisation based on ad account data, website analytics and sales feedback read together. Guangsuan states it does not promise a fixed inquiry volume or deal outcome, and fees and scope are confirmed in a contract.
Two files make a first conversation concrete: the current conversion action list with primary and secondary status marked, and one real export with its date basis and time zone written on it. Read the published scope on the Guangsuan Google Ads management service page.
FAQ
Can I export JSON directly? No. Reporting downloads offer CSV, TSV, XLSX, XML, PDF and Google Sheets. JSON comes from the API REST interface or a warehouse layer.
Is a valid file ready for attribution? No. Validity says nothing about completeness, grain, units, date basis or which actions are included.
Click time or conversion time? Use the basis that answers the question and keep it on both sides, with window and time zone recorded.