How to Export Google Ads Data Without Misreading Conversions
For month-end reporting, lock date range, account time zone and conversion basis before downloading, then check search intent, page fit and sales definition before changing bids.
Brand promotion: this article introduces Guangsuan's Google Ads management services.
Direct answer with conditions: before month-end reporting, write the single question the file must answer, then lock range plus account time zone, conversion basis plus which actions count, and row identity plus file name on the export itself. If you compare a closed month to sales records, keep the same basis and zone on both sides and reconcile one primary action and one campaign group first before adjusting bids.
Lock the export scope before you click download
On the Campaigns, Ad groups, Keywords, Search terms or Ads page, set the date range and columns, then use the download icon at the top right of the table to download a file. When day, device, location or conversion splits must sit together, build that combined view in Reports instead of stitching separate pulls afterward. For recurring, large or automated exports, query with GAQL through the API instead of clicking through the interface. Menu labels are adjusted from time to time, so follow the reporting section rather than a memorised path.
Exports are dated in the account's time zone, which may not match your calendar or your CRM timestamps. Note that zone on the file and check one date row after opening before trusting day-month order. A monthly export can hide a bad week; a daily export against a long range produces a large file. Export the grain you will actually analyse. In a table or report, use the segment control to split data by day, week or month rather than exporting several ranges and joining them later.
The web interface is the fastest path to download a report for review. Ads Editor fits a different task: bulk structural changes or a structural backup of the account. Decide intent before downloading, because a read-only report lacks columns required for edit and re-import.
Read conversion dates without mixing two calendars
Conversion-time reporting counts a conversion in the period when it happened; click-time reporting counts it in the period when the click happened. If a customer clicks on the last day of the month and buys a week later, the two bases put that conversion in different months. Neither basis is wrong, but a period comparison must not mix them.
Before you build a report on conversions, open the conversion settings and write down 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 steps such as a page view or contact tap stay in separate columns with their own labels and should not be added to primary demand. Changing counting or attribution reshapes history, so that note must travel with the extract.
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-recorded events, qualified enquiries and closed revenue as four separate tallies through the whole check.
Pick format and file hygiene by next use
Google Ads supports CSV, CSV for Excel, TSV and XLSX, and can send a file to Google Sheets or by email on a schedule. Use CSV for scripts and databases, XLSX for spreadsheet work, and the Sheets option when several people need the same live file. Scheduled exports need a recipient and frequency, so review that list when team addresses change.
Name files with account, view, range, basis and pull time. Keep the raw download unchanged and work in a copy so a retry replaces the same slice. There is no JSON choice in the report download list. When a downstream tool asks for JSON, treat that as a second step through the REST path with a GAQL query, or stage the sheet in a warehouse and emit JSON there.
For field steps on views, dates and columns, see Guangsuan's guide to exporting Google Ads data and reading dates and conversions.
When the report looks good but sales does not feel it
Check the handoff in order: intent, page, then definition. First read the search-terms view beside the bought keyword. Search that is too broad, targeted to the wrong region, or mixed with job-seeking or tutorial queries spends budget without purchase demand. Repair match handling and exclusions before bids.
Next check page fit when visits arrive without enquiry. When ad promise and page disagree, or product detail, trust material or contact entry is thin, review relevance, loading, product detail and enquiry path. Routing every click to the homepage when a matching product page exists calls for a page correction, not a higher bid.
Then check the definition gap. A button tap is not a qualified enquiry, and an enquiry is not a closed order. Align which CRM event corresponds to the Ads action, normalize both timestamps to the reporting zone at month edges, and review counting and duplicate uploads before calling a remainder unexplained.
As a hypothetical teaching illustration with invented figures, not a client result: an extract logs 34 ad-recorded contacts in October. Sales marks 11 as qualified under a written product, market and contact rule, with 8 dated inside October and 3 dated in early November, and 2 reaching order. Each figure describes a separate stage, so none cancels another.
Run it yourself or ask for managed help
An export is only useful if the campaign structure behind it is sound — clean naming, one intent per campaign, and conversion tracking that matches how your business actually receives leads. Self-serve fits when one person can keep period, zone, names and counting notes steady for a settled question.
If your reports are hard to read because the account structure is messy, or you want help turning exports into decisions, Guangsuan's Google Ads management service covers account structure, search terms, landing pages, conversion checks and reporting. That work runs from search terms, ads and landing pages to conversion tracking, focused on real purchase demand. Scope and fees sit in a contract, with no fixed enquiry-volume promise. Details are on the Guangsuan Google Ads management service.
Month-end checklist you can copy
- Write one question, for example which campaign groups created qualified enquiries in the closed month and at what spend.
- Set level, range, columns and splits that answer that question; export the grain you will actually analyse.
- Write range, account zone, conversion basis, primary-action list, counting and attribution beside the file.
- Keep customer ID and numeric campaign ID beside labels; keep every split that defines a row.
- Open CSV through text import, confirm UTF-8 and delimiter, turn cost and clicks into numbers, verify one date row.
- Reconcile one primary action and one campaign group first; leave any leftover gap marked as open.
FAQ
Which three scope notes prevent a misdated close? Date range plus account time zone, conversion basis plus primary-action list, and file grain plus pull moment. File all three with the sheet.
Does a clean-looking sheet mean it can be joined? No. Clean layout says nothing about grain, units, timing rule or which actions were summed.
When does managed help fit? When structure makes every pull hard to read, when queries and pages point in different directions, or when conversion checks keep slipping across months. Bring one annotated export with zone and basis written on it.
Get the weekly brief.
One long-read, every Friday. The dashboards other analysts won't show you, the post-mortems the vendors hope you skip.