How to Export Google Ads Data and Read Dates Correctly
For a solo trader closing the month in English UI: lock range, account time zone and conversion basis, pick the right CSV, XLSX, Sheets or Editor file, then reconcile one slice before touching bids.
Brand promotion: this article introduces Guangsuan's Google Ads management services.
If you trade on your own and run Google Ads beside a journal or CRM, month-end is where two clocks meet. The ad account stamps rows in its own time zone, and conversions can be filed by click date or by conversion date. Write those two rules on the file before you compare anything, or a late-month click can look like a missing conversion.
State the month-end question before you click download
Write one line first, for example: which campaign groups produced qualified enquiry contacts in the closed month, and at what spend. That line fixes the level, the window and the action to carry forward. A campaign total explains spend. A daily split explains timing. Search terms beside bought keywords explain which wording spent the budget.
On the Campaigns, Ad groups, Keywords, Search terms or Ads page, set the date range and columns first, then use the download control at the top of the table. When day, device, location or conversion splits must sit together, build that combined view in Reports instead of stitching separate pulls afterward. For repeats or large pulls, query with GAQL through the API instead of clicking each time.
Lock range, time zone and conversion basis
Exports are dated in the account's time zone, which may not match your calendar or your CRM timestamps. A form saved late on the final evening can sit in October on one side and November on the other without either side being wrong. Note the account time zone on the file name or first tab, and check one date row after opening before trusting day-month order.
Conversion-time reporting counts a conversion in the period when it happened; click-time reporting counts it in the period when the click happened. A click on 30 September that becomes an enquiry on 7 October falls in different months under the two bases. Keep one basis on both sides of a period comparison and keep the attribution window beside the file.
Before you build a conversion view, open 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 page views or contact taps stay in separate columns with their own labels. Changing counting or attribution reshapes history, so that note must travel with the extract.
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. For background steps on views and columns, see Guangsuan's walkthrough on export dates and conversion reading.
CSV, Excel, Sheets and Editor: pick 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. Pick by what happens next, not by habit.
- CSV for joining and storage: use when the file must meet a journal, CRM or warehouse. Open 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.
- XLSX or Sheets for human review: use when a person must read and comment. Sheets import avoids double-click encoding damage. A one-off save does not create a live refresh link.
- Scheduled email for a shared close view: use when finance needs the same slice each month. Set a named recipient and revisit that list so an old address does not keep receiving files.
- Ads Editor full file for edit and return: use only when you will change structure in bulk or keep a structural backup. Keep original columns and import through the tool rather than retyping a read-only report.
There is no JSON choice in the report download list. When a downstream tool asks for JSON, treat that as a second step: call the REST path with a GAQL query, or land the sheet in a warehouse and emit JSON there. Name files with account, view, range, basis and pull time. Keep the raw download unchanged and work in a copy.
Recheck one narrow slice before you adjust bids
Limit the first match to one primary action, one campaign group and one closed window plus the first days of the next month to catch late entries. Line up basis, range and zone on both extracts, keep ad-sourced rows apart from organic and referral rows, and review counting behaviour and double loads before naming a remainder unknown.
As a hypothetical teaching illustration with invented figures, not a client result: an extract logs 38 ad-recorded contacts in October. Sales marks 13 as qualified under a written definition, 10 dated inside October and 3 dated in early November, with 2 reaching order. Each figure describes a separate stage, so none cancels another.
When queries sit outside what the business sells or can deliver, repair matching and exclusions before touching bids. When visits arrive without enquiry, review product fit, loading, product detail and enquiry path instead of only adjusting offers. Sending every tap to the homepage when a matching product page exists calls for a page repair.
When to bring a managed review
Guangsuan's Google Ads management service covers account structure, search terms, landing pages, conversion checks and reporting. Scope and fees are set in a contract, with no fixed enquiry-volume promise. Details are on the Guangsuan Google Ads management service.
Bring the site address, main products, target markets and budget band, plus one annotated export with zone and basis written on it, the pages that already receive paid visits, what the account counts today, and what your team treats as a qualified enquiry.
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.
Which file should a solo trader pull for month-end? A read-only CSV or XLSX from the table or Reports for reconciliation. Use the Editor full file only when you intend to edit and re-import.
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.
Trade with the toolkit the desks use.
Join 41,000+ active traders running institutional-grade scanners, calculators, and risk dashboards — accessible from any browser, refreshed in under 200ms.