Solo Trader Month-End: Export Google Ads Without Misdating Conversions
For independent traders closing the month: how to set the attribution question, shape a joinable export, choose CSV, Excel, Sheets or API, and note account time zone plus conversion timing before reconciling.
Brand promotion: this article introduces Guangsuan's Google Ads management services.
A solo trader already knows how to close a brokerage month: state the question, keep the statement untouched, then match fills against the journal. Use the same discipline for Google Ads. Hold spend on one side and your own enquiry log on the other, and do not change bids until the downloaded sheet carries its own notes on period, clock and what was counted.
State the close question, then shape rows that can join
Write one line before opening the interface, for instance: which ad sets brought sales-accepted contacts for the closed month, and what did each set spend. That line fixes the level, the window and the action to carry forward. A campaign total explains spend. A daily split explains timing. Queries placed beside bought keywords explain wording that consumed budget.
Open the level you need, arrange period and columns, then press the download control at the top of the view. When day, device, place or conversion pieces must appear together, shape that combined view inside Reports rather than stitching separate pulls afterward.
Leave identifiers inside the workbook so a later join does not depend on memory. Keep the account identifier, keep the numeric campaign identifier beside its editable name, and keep each field that makes a row distinct, such as date, device slice, network slice, place slice and action where relevant. A total and a day-by-device table have different shapes and should not share one sheet. Give the working copy a name that shows account, view, range, timing rule and pull moment, and keep the first download untouched while you sort in a duplicate.
Let the next user decide the file type
The download list offers comma files, Excel workbooks and Sheets delivery, plus mail on a timetable. Select by reopening, not by habit.
- Comma text for joining and storing: keep this when the sheet must meet a journal, CRM or warehouse. Import through Data > From Text/CSV, force UTF-8, confirm the divider, turn spend and taps from text into numbers, and inspect one date line before trusting day-month order.
- Workbook or Sheets for reading and comment: keep this when a person must review and annotate. A one-off save does not build a live refresh link.
- Timetabled mail for a shared close view: keep this 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.
- Query interface for repeats or heavy pulls: when the pull repeats or grows large, send a GAQL query through the Ads API instead of clicking each time. Returned lines carry only fields named in the query, so place identifiers and splits inside the query itself and run the job after the day figures settle.
Report downloads do not offer a JSON choice. When a later 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. Do not retype a read-only view and expect it to load back without required columns. For background on views and columns, see Guangsuan's walkthrough on export dates and conversion reading.
Write the clock and the counting rule on the sheet
Each line carries the clock set inside the ad account, which can sit apart from the clock in your journal or CRM. A form saved late on the final evening can therefore fall in October on one side and November on the other without either side being wrong. Mark that account clock on the filename or first tab.
Dating of conversions needs the same written note. One rule files the event under the date it occurred. The other rule files it under the date of the tap that led to it. A tap on 30 September that turns into an enquiry on 7 October therefore lands in separate months under the two rules. Keep a single rule on both sides of a period comparison and keep the attribution window beside it.
Before shaping a conversion view, open conversion settings and record timing choice, primary flags, counting choice and attribution approach beside the file. The headline Conversions figure counts only steps flagged as primary. Helper steps such as views or contact taps belong in other columns with their own labels. A shift in counting or attribution reshapes history, so that note must travel with the extract. The download shows only what Google managed to record; sales-confirmed totals remain in your own system. Keep taps, platform-recorded events, qualified enquiries and closed income as four separate tallies.
Match one slice narrowly before acting
Limit the first match to one primary action, one ad set and one closed window plus the first days of the next month to catch late entries. Line up basis, range and clock on both extracts, keep ad-sourced lines apart from organic and referral lines, and review counting behaviour and double loads before naming a remainder unknown.
Take the next numbers only as a made-up practice example, not a client outcome: a sheet 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 tells 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. Where layout, query review, pages and checks need owned work, details are on the Guangsuan Google Ads management service.
FAQ
What identifiers let the sheet join later? Account identifier, numeric campaign identifier beside its label, plus date and each device, network, place or action split that keeps rows distinct.
Which dating rule suits month-end? Use the rule that answers the opening line and keep it the same on both extracts, with window and account clock filed with the file.
Does a sheet that opens neatly join neatly? No. Neat layout says nothing about row shape, 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.