Every win/loss template on the internet has the same columns and the same fate: filled in for one quarter's post-mortem, then abandoned. Having watched a sales team of fifty run geographic deal tracking every single day for two years, I can tell you the difference between the ceremonial version and the one that changes behavior, it's the address column, and what you do with it.
So here's the template, free, with the two fields that matter most, and then the ten-minute upgrade that turns your deal history into a map of exactly where you win.
- →Grab the free template: account, address, outcome, competitor, deal size, close date, primary reason, notes. Five sample rows included.
- →The two fields that make it strategic instead of ceremonial: competitor (who actually took the deal) and address (where it happened).
- →Win/loss by REASON tells you what to fix in the pitch. Win/loss by PLACE tells you where you're structurally strong — and it's the layer almost nobody adds.
- →Map the sheet and patterns appear that no pivot table shows: you win everywhere within reach of a reference customer, and lose in the incumbent's home turf.
- →Keep it living: one row per closed deal, logged the same week, reviewed monthly on the map.
The Google Sheets-ready CSV: account, address, outcome, competitor, deal size, close date, reason — with five sample rows showing the format.
The template and how to use it
Columns: Account, Address, City, State, Outcome (Won/Lost), Competitor, Deal Size, Close Date, Primary Reason, Notes. One row per closed deal, logged the week it closes, not reconstructed at quarter end, when memory has already rewritten the story. The download above includes five realistic sample rows so the format is unambiguous.
Discipline notes from the field: keep Primary Reason to a short controlled list (price, incumbent contract, relationship, product gap, timing, reference) so it aggregates; leave Competitor blank rather than guessing; and record losses with the same care as wins, the losses are where the strategy lives.
The competitor column is your quiet gold mine
Six months of honestly-filled competitor cells and you own something most companies pay data vendors for: a real map of who you actually meet in deals and who beats you. Not the competitors in your pitch deck, the ones in your pipeline. Every displacement campaign and battlecard should start from this column, not from a market report.
The geographic layer everyone skips
Now the upgrade: geocode the address column and color pins by outcome, wins one color, losses another. Two patterns show up on almost every team's map within minutes. First, wins cluster around existing customers: deals close where you have a nearby reference, because 'we work with your neighbors' is the strongest opener in field sales. Second, losses cluster in the incumbent's strongholds, and now you can see exactly where those are and stop wasting cold effort there.
That's win RATE by area, and it feeds directly into an offensive plan: attack the areas adjacent to your win clusters (references ready), avoid or prepare properly for the loss zones. The Nearest Customer Finder automates the reference half from this very sheet, and the whole file maps in one click with InstaMaps, the address column you're already keeping does all the work.
Map your Salesforce accounts in under 5 minutes — no admin setup.
Common Questions
Two fields: Competitor and Address. Most templates capture reasons and quotes; this one also captures who beat you and where, which turns a post-mortem document into a market map you can act on.
Patterns in reasons emerge around 20-30 closed deals; geographic patterns often show up faster because clustering is visual. Even 15 pins colored by outcome usually reveal your strong and weak ground.
The rep who worked the deal, same week it closes, in under two minutes. Manager-reconstructed win/loss data drifts toward politeness; fresh rep-entered data keeps the competitor and reason columns honest.
Formal buyer interviews (the Clozd-style practice) add depth for large deals, but the sheet-level discipline, outcome, competitor, reason, place, delivers most of the directional value for SMB and mid-market teams at zero cost.
Your win/loss sheet has an address column for a reason — geocode it and see where you actually win.
Install InstaMaps free