Google Ads to JSON or Sheets: Fields to Check Before You Reconcile
Google Ads has no JSON download button. Learn the REST API and warehouse routes, and which identity, date, conversion and currency fields to lock before reconciling spend with CRM.
Brand promotion: this article introduces Guangsuan's Google Ads management services.
Month-end review for a performance marketing team often starts with two totals that do not agree: a Google Ads export and a CRM revenue report. The export shows what the ad account recorded under its own range, time zone and conversion definition. The CRM shows enquiries your team qualified and deals it closed. Check the export fields first, then compare, and change bids last.
Direct answer: There is no JSON button in the Google Ads interface. If you need JSON, query the Google Ads API through its REST interface, or land the data in a warehouse and export JSON downstream. Before you reconcile with CRM, record row grain and identity fields, date range and account time zone, conversion basis and which actions are primary, and currency and cost units. This checklist applies when you reconcile spend, leads or orders for a month. A one-off screenshot for a colleague does not need it.
There is no JSON button in the interface
When you click the download icon above a statistics table, the available formats include Excel CSV, TSV, PDF, XLSX, XML, and Google Sheets. JSON is not one of them. XML is the closest native format and is easy to confuse with JSON, but they are different languages for different consumers.
If a downstream tool asks for JSON, converting a downloaded CSV or XML file locally is a programming step you own. Keep the script under version control, with an owner and a test on a small slice you have checked by hand.
Two routes that produce JSON
Route 1 is the REST API. The Google Ads API supports two interfaces, gRPC and REST, and the REST interface uses JSON representations of the same resources. Queries are written in the Google Ads Query Language (GAQL), and a GoogleAdsService query returns a list of GoogleAdsRow instances, each carrying the attributes, metrics or segments you selected.
Access needs a developer token and an authenticated client. Google documents four access levels: Test Account Access (15,000 operations a day, test accounts only), Explorer (2,880 operations a day against production accounts), Basic (15,000 operations a day) and Standard (unlimited). Permissible use decides which features you are allowed to call. Keep tokens and credentials in a secured file or secret store. Details of both native limits and API access are in Guangsuan's guide to exporting Google Ads data to JSON.
Route 2 lands the data elsewhere first, through a BigQuery transfer or a reporting connector, and exports JSON from there. That adds a vendor, a project or a scheduled transfer you must maintain. For a one-off file, local CSV conversion is shorter. For a recurring join against CRM revenue, the warehouse keeps history and lets two people reproduce the same total.
Lock identity, grain, dates and time zone
Two files can show the same totals and still not join. Record customer ID, campaign ID alongside campaign name, and every segment that separates a row, such as date, device and conversion action. Names are edited, while IDs stay stable.
Exports are dated in the account's time zone, which may not match your calendar or your CRM timestamps. A lead recorded late on the last day of a month can fall into different months on the two sides without anyone making a mistake. Write the range, segment grain and time zone on the file, and segment by day, week or month with the segment control rather than joining several ranges later.
Lock conversion basis and currency handling
Secondary actions, such as a page view or a click to contact, are reported separately and should be labelled as such in your export. Only actions marked as primary feed the Conversions column used for bidding, so a total that mixes primary and secondary actions describes more than the business agreed to count.
Before you build a conversion report, open the conversion settings and write down click-time versus conversion-time basis, counting method and attribution model. The same conversion falls in different months under the two bases, so do not mix them in one comparison.
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. Cost arrives as micros in the account currency, so convert once, note where that step happened, and keep forecast value separate from booked revenue.
Reconcile in order, then ask for help
Keep four counts apart: clicks, platform conversions, qualified enquiries and closed revenue. Adding them together describes nothing the business agreed to count.
Reconcile narrow first. Start with one conversion action, one campaign group and one period. Align basis, range and time zone on both sides. Separate ad-sourced leads from organic and referral ones. Check counting settings and repeated uploads before calling a difference unexplained. Leave any remaining gap marked as unresolved rather than assigning unknown traffic to Ads.
Hypothetical teaching example with invented numbers, not a client result: an export records 42 form submissions for a month. Sales confirms 16 qualified enquiries under a written definition, with 12 dated inside the same month and 4 dated after it closed, and 3 become orders. No figure contradicts another because each describes a different step. If most submissions are never qualified under the written definition, check queries and the landing page before changing bids.
Guangsuan provides Google Ads management covering account structure, search terms, landing pages, conversion checks and reporting, with optimisation read from account data, analytics and sales feedback together. Scope, fees and handoff are on the Guangsuan Google Ads management service page. Bring the conversion action list with primary status marked and one real export with basis and time zone written on it, plus website, products, market and budget range.
FAQ
Can a missing keyword mean zero rows were dropped? Yes. Report Editor can drop rows with zero clicks and impressions, so check grain and filters before concluding the keyword never matched.
Click time or conversion time? Pick the basis that answers the question and keep it on both sides, with window and time zone recorded.
Does valid JSON mean ready to reconcile? No. Validity says nothing about completeness, grain, units, date basis or which conversion actions are included.
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.