Google Ads to CSV or JSON: Fields to Check Before You Reconcile Spend

Brand promotion: this article introduces Guangsuan's Google Ads management service. It is a vendor introduction, not an independent review or a commissioned evaluation.

A month-end review can start with a download. Someone exports campaigns or search terms, opens the file beside a CRM report and a finance summary, and the spend figure does not agree. The file itself is rarely the problem. What decides whether it can be reconciled is which fields were selected and which settings sat behind them, and those choices are mostly made before the first byte is written.

The short answer

Google Ads reporting downloads do not offer JSON, so choose the route first: the API's REST interface, or a warehouse or connector layer that exports JSON downstream. Whichever route you use, settle six things before the file is used for reconciliation: the row grain and identity fields, the date range and the account time zone, the conversion basis and which actions count, the currency and the micro unit, the dimensions your question needs, and a file name that records all of it. These checks fit accounts used for spend reporting or for lead and order reconciliation. A one-off screenshot for a colleague needs none of them.

Why there is no JSON button, and what to use instead

When you download a table in Google Ads, the available formats are 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 the two are different languages for different consumers.

If a downstream tool insists on JSON, converting a downloaded CSV or XML file locally is a legitimate route. It is also a route your team owns: the conversion script becomes part of the reporting chain, so it needs a version, an owner and a test against a slice you have already checked by hand.

The API route does return JSON. 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, and a query returns rows carrying the attributes, metrics or segments you selected. Access is controlled through a developer token, and Google documents four access levels, from test-account access to Standard. The practical consequence is simple: the JSON contains what the query asked for, and a missing field cannot be recovered downstream.

A third route lands the data somewhere else first. A BigQuery transfer or a reporting connector can hold the data and export JSON from there. That adds a moving part someone has to maintain, but it also keeps history and lets two people reproduce the same total. For a single file, converting a CSV locally is shorter.

Scheduled exports are separate from format choice. Google Ads supports CSV, CSV for Excel, TSV and XLSX, and can send a file to Google Sheets or by email on a schedule. If you use that, review the recipient and frequency occasionally, so an old report does not keep arriving for someone who left.

Fields to record with every file

Two files can hold identical totals and still not be joinable. The groups below are what make a file reconcilable later; add or remove rows according to the question you are answering.

Field group	What to record	Why it matters
Identity	Customer ID, plus campaign ID next to the campaign name	Names get edited; IDs do not. Two accounts in one file need a key.
Grain	Every segment that separates a row: date, device, network, and the conversion action where relevant	A campaign total and a campaign-by-day-by-device file have different grains, and a key that ignores the difference lets valid rows overwrite each other.
Dates	The range, the segment (day, week, month) and the account time zone	Without these, a period comparison measures the settings rather than the market.
Cost and currency	Cost in micros, the account currency, and where the conversion to currency units was applied	Cost arrives in micros and in the account currency, and the conversion should happen once.
Conversion definition	Which actions count, which are primary, the counting method, the attribution model and the reporting basis	A total that mixes actions or bases describes more than the business agreed to count.
File metadata	Report name, range, basis, extraction time and a version	A re-run should replace the same slice rather than append a second copy.

Dates, time zone and the conversion basis

Exports are dated in the account's time zone, which may not match your calendar or the timestamps your CRM stores. A lead recorded late on the last day of a month can fall into different months on the two sides of the comparison without anyone making a mistake. Write the time zone on the file rather than in a chat message.

Conversions need the same discipline. Google Ads can attribute and report conversions on more than one basis, and the default column is not the only valid view. The two bases you are most likely to meet are click time and conversion time, and the same conversion can land in different periods under each. Neither is wrong. What breaks a comparison is mixing them, because the month-on-month change then reflects the setting.

Before building a conversion report, open the conversion action list and write down four items: the basis, which actions are primary, the counting method and the attribution model. Only conversion actions marked as primary roll into the Conversions column and into bidding. Secondary actions, such as a page view or a click to contact, are reported separately and should be labelled as such in the export.

If your team relies on offline or CRM-confirmed leads, remember that the export only shows what Google was able to record. Sales-confirmed numbers live in your own system and will not match row for row. That is a difference in what is being counted, not proof that either side is wrong.

Currency, micros and value fields

Cost arrives in micros and in the account currency, so divide by one million once, record where that happened, and do not divide an already-normalised amount again. A file that has been converted twice still looks like money and is not.

Two accounts in different currencies cannot be compared on raw totals. Either convert with a rate you can state and date, or keep the accounts separate and compare ratios instead of amounts. If value-based bidding is in play, include the conversion value column with its currency, and keep forecast or estimated value separate from booked revenue.

The order to reconcile in

Start narrow. Choose one conversion action, one campaign group and one reporting period, because a small difference is easier to explain than an account-wide total. Then align the basis, the date range and the time zone on both sides. Next, separate ad-sourced records from organic and referral ones, since those do not belong in a one-to-one comparison with an ad account. Only after that should you check the counting settings and any repeated uploads before calling a difference unexplained.

Four counts stay apart throughout: clicks, platform conversions, qualified leads and closed revenue. They answer four different questions, and adding them produces a number that means nothing. When a figure still cannot be explained, mark it unresolved rather than assigning unknown traffic to Ads to close the gap.

Hypothetical example, with invented numbers and not a client result: a campaign file records 60 conversions for a month. Sales confirms 20 qualified enquiries under a written definition, 15 dated inside the month and 5 dated after it closed, and 4 of those become orders. None of the three figures contradicts the others, because each describes a different step. If most recorded conversions were never qualified, the next question is about queries and the landing page, not the bid strategy.

One more check belongs at the end rather than the start: an export is only as useful as the account structure behind it. Clean naming, one intent per campaign and conversion tracking that matches how the business receives leads decide whether any of these joins are meaningful.

Where Guangsuan fits

Guangsuan describes its Google Ads management as covering search terms, ads, landing pages and conversion tracking, with optimisation aimed at real purchasing demand rather than clicks alone. Its published scope lists analytics linking, measurement and conversion setup, plus search term report analysis and negative keyword maintenance as separate work items. That matters for a reconciliation problem, because some causes sit inside the account rather than in the file: a conversion action that records the wrong step, a landing page that does not answer the query, or tracking that was deployed and never checked.

Guangsuan states that it does not promise a fixed inquiry volume or a deal outcome, and that fees and scope are confirmed in a contract. Two files make a first conversation specific: 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. The Guangsuan Google Ads management service page sets out the published scope, and Guangsuan's guide to exporting Google Ads data to JSON covers the interface limits and the two routes in more detail.

FAQ

Can I export JSON directly from Google Ads?

No. The reporting download offers spreadsheet, XML, PDF and Google Sheets formats. JSON comes from the API or from a warehouse layer that exports it downstream.

Is a valid JSON file ready for reconciliation?

No. Validity says nothing about completeness, row grain, units, date basis or which conversion actions are included. Those have to be established separately.

Should we standardise on click time or conversion time?

Use the basis that answers the question and keep it on both sides of every comparison. Record the choice, the conversion window and the account time zone with each file you keep.

Why do the platform total and the CRM total never match exactly?

They describe different steps measured in different systems. What can be agreed is which stage is being compared, on which basis and over which period, and which differences remain unexplained.

What should we prepare before asking about management?

The published starting list is the website, the main products, the target market and a budget range, plus the historical data you are authorised to share. Adding the conversion action list and one annotated export turns that into a concrete check.