Google Ads to JSON: Fields to Check Before CRM Reconcile
Brand promotion: this article introduces Guangsuan's Google Ads management services.
Direct answer: There is no JSON button in the Google Ads interface. If a tool asks for JSON, call the REST form of the Google Ads API with a GAQL query, or stage data in a warehouse and emit JSON there. Before joining to the CRM, write range plus account time zone plus click-time versus conversion-time on the file, keep stable IDs on each row, separate primary actions from secondary steps, and convert micros once. Reconcile one action in one campaign group before any bid change. This answer applies when the file will decide spend, leads or orders for a closed period.
No JSON button in the interface
The download menu offers Excel CSV, TSV, PDF, XLSX, XML and Google Sheets, with no JSON option.
XML sits closest in the menu, but it serves XML readers rather than a JSON pipeline. Converting a CSV or XML download to JSON on your own machine is a local programming step, not an export option. Keep that script versioned and test it on a small slice checked by hand.
Two routes that produce JSON
The REST interface returns JSON representations of the same resources, while most official client libraries use gRPC with protocol buffers.
A GAQL query through GoogleAdsService returns rows carrying only the attributes, metrics or segments you selected. Access needs a developer token and an authenticated client, with tiered daily limits starting from test-account use. Keep tokens and credentials in a secured file or secret store.
The second route lands data elsewhere first, through a BigQuery transfer or a reporting connector, and emits JSON there. That adds a project to maintain, so it fits a recurring CRM join better than a one-off file. For the field workflow behind this checklist, see Guangsuan's guide to exporting Google Ads data to JSON.
Keep IDs and grain joinable
Keep customer ID in the file, keep campaign ID beside campaign name, and keep every split that defines a row, such as date, device and conversion action. Names are edited while IDs stay stable.
A campaign total and a campaign-by-day-by-device file are different grains. Export the grain you will actually analyse, keep the raw download unchanged, and do analysis in a copy.
Write range and time zone on the file
Exports are dated in the account's time zone, which may not match your calendar or your CRM timestamps. Conversion-time reporting counts an event where it happened, while click-time reporting counts it where the click happened.
An export is only as good as the range and time zone behind it. Record both with the file, segment by day, week or month with the segment control, and keep the same zone on both sides of a period comparison. A late-September click that becomes an early-October signup therefore sits in different months under the two rules. Pick one rule and apply it on both sides.
Fix which conversions count
Only primary conversion actions feed the Conversions column used for bidding; secondary micro-steps stay separate and should be labelled that way in the export.
Before you build the report, note basis, window, counting method and attribution model beside the file, because changing any of them changes historical comparisons. The export only shows what Google was able to record; sales-confirmed numbers live in your own system.
Handle micros and currency once
A GAQL field list includes campaign.id, campaign.name, metrics.clicks, metrics.conversions and metrics.cost_micros. Cost in API rows arrives as metrics.cost_micros in account currency, so convert once by dividing by one million and note where that step happened.
Do not sum raw totals across different currencies. Keep forecast value separate from booked revenue.
Run one narrow pass before touching bids
Select one primary action, one campaign group and one closed period. Align basis, range and zone on both extracts, separate ad-sourced records from organic and referral entries, and check counting and repeated uploads before calling a gap unexplained.
As a hypothetical teaching illustration with invented figures, not a client outcome: a file logs 48 ad-tracked contacts in a month, sales accepts 15 as qualified under a written definition, 10 dated inside that month and 5 in the next month, with 2 reaching order. Each total describes a different stage.
When Guangsuan can help
Guangsuan's Google Ads management service covers account structure, search terms, landing pages, conversion checks and reporting, with no fixed enquiry promise. Scope and fees are on the Guangsuan Google Ads management service page.
FAQ
Click time or conversion time for month end? Use the rule that answers the question and keep it identical on both sides, with window and zone filed with the extract.
Does valid JSON mean ready to reconcile? No. Parsing says nothing about completeness, grain, units, date rule or which actions were summed.
Ready to turn this into pipeline?
Book a 30-minute paid strategy audit with a senior strategist. We'll map your current spend, find the leaks, and model the 90-day lift.
Get My Free Strategy Audit