Skip to content
SEO与数字营销

Google Ads to JSON for Month-End: Lock Fields Before You Reconcile

A AdSun• • By AdSun Editorial

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

At month-end a paid-media lead holds two files that refuse to agree: spend by campaign and day from Google Ads, and qualified pipeline by close date from the CRM. Before moving bids or budgets, check whether the Ads file itself carries enough notes to support a join.

You cannot export Google Ads data to JSON from the interface, because there is no JSON button. That fact sets the workflow for this task: use the interface file for reading and matching, and use a different path where JSON is required.

Define the task in one sentence

Write what the file must prove before opening Google Ads. Example: which ad groups drove trial requests accepted by sales in November, and at what cost. That sentence fixes period, row detail, and which conversion action travels forward.

A campaign total answers spend. A campaign-by-day split answers timing. Search terms placed beside the bought keyword answer intent. Those three grains need different files. Do not force them into one sheet.

On the Campaigns, Ad groups, Keywords, Search terms or Ads page, set date range and columns first, then use the download control at the top of the table. Where day, device, place, or conversion splits must sit together, build the view in Reports. Where pulls repeat or grow large, query with GAQL through the Google Ads API rather than clicking each time.

What the download menu gives you

Available formats include Excel CSV, TSV, PDF, XLSX, XML, and Google Sheets. JSON is not one of them. XML appears near JSON in a format list but is read by different tools, so it cannot stand in where JSON is expected.

If you genuinely need JSON — for a script, a data pipeline, or an app — there are two realistic routes: query the Google Ads API through its REST interface, which returns JSON, or land the data in a warehouse and export JSON downstream. For detail on the two routes and the field shape, see Guangsuan's guide to exporting Google Ads data to JSON.

Turning a one-off CSV into JSON on a local machine can work for a single file. Where that step is used, keep the script under version control, name an owner, and test it against a small slice checked by hand.

Keep rows joinable

Names change. Numbers stay. Keep customer ID in the file. Keep numeric campaign ID beside campaign name. Keep each split that defines a row, such as date, device, network slice, place slice, and conversion action where used.

Name the file with account, report, range, date basis, and pull time. Keep the raw download unchanged and do analysis in a copy, so a retry replaces the same slice instead of doubling it.

Put calendar and conversion rules on the file

Exports are dated in the account's time zone, which may not match your calendar or your CRM timestamps. A lead saved late on the last evening can sit in November on one side and December on the other, with no fault on either side. Write the zone on the file and check one date row after opening before trusting day-month order.

Conversion placement needs the same written note. Conversion-time reporting counts the event where it happened. Click-time reporting counts it where the click happened. A 28 November click that becomes a 3 December request therefore falls in different months under the two rules. Keep one rule on both sides of a period comparison, and keep window, counting method, and attribution model beside the file, because a change in any of them shifts history.

Secondary actions — often micro-conversions 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. Where offline or CRM-confirmed leads matter, remember the export shows only what Google could record. Sales-confirmed numbers stay in your own system. Keep clicks, platform events, qualified enquiries, and closed revenue as four separate counts.

Handle format, money, and storage

Use CSV for joins and storage, XLSX for sheet review, and Sheets where several people must see the same live copy. Open CSV through Data > From Text/CSV, force UTF-8, confirm the delimiter, turn cost and clicks from text into numbers, and verify one date row first.

In API rows cost arrives in micros in account currency. Divide once by one million in a noted place and do not add raw totals across currencies. Add the cost column and build ratios in the sheet rather than relying only on exported averages, because an average can hide the segment that needs action.

A small closed check before bid moves

Limit the first pass to one primary action, one campaign group, and one closed period plus the first days of the next month to catch late entries. Align basis, range, and zone on both extracts. Keep ad-sourced rows apart from organic and referral rows. Check counting and repeated uploads before calling a remainder unexplained. Quiet rows can drop from a filtered view, so confirm filters and grain before saying a term never matched.

As a hypothetical teaching illustration with invented figures, not a client outcome: an extract logs 29 ad-recorded contacts in a closed window. Sales accepts 11 as qualified under a written definition, 8 dated inside that window and 3 dated in the first days after it, with 2 reaching order. Each total describes a different stage, so the file and the CRM can both be right while showing different numbers.

Where only a small share meets the written qualified definition, review query intent and page fit before adjusting bids. A clean structure helps: one intent per campaign, clear naming, and tracking tied to how leads actually arrive.

Where Guangsuan fits

Guangsuan's Google Ads management service covers account structure, search terms, landing pages, conversion checks and reporting. Scope and fees sit in a contract, with no fixed enquiry promise. Details are on the Guangsuan Google Ads management service page.

For a first look, bring the action list with primary flags marked plus one annotated extract that shows basis, window, and zone.

FAQ

Click time or conversion time for month-end? Pick the rule that answers the opening sentence and keep it on both extracts, with window and account zone written on the file.

Does a file that opens cleanly join cleanly? No. Readable layout says nothing about grain, money units, date rule, or which actions were added together.

Can a missing term mean hidden rows? Not yet. Confirm filters and grain first, because a filtered view can omit very quiet rows.

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