Win/Loss Analysis: Why You Lose Deals and What ‘Price Too High’ Really Means

Most small businesses can tell you what they won last year. Very few can tell you what they lost, because a lost deal gets marked lost and the row gets deleted, or worse, never marked at all — it just stops being mentioned.

That is roughly half your sales data thrown away. In the worked business used throughout the client CRM and pipeline guide, the losses come to $155,800 against $273,000 won. Thirty-six percent of everything that was ever decided.

One extra field on the deal row — why — turns that into the most useful table in the business.

Two Win Rates, and Why the Gap Matters

Start with the headline number, calculated both ways:

Both are correct. The interesting thing is the 5.4-point gap between them, and its direction.

A value win rate above the count win rate means the deals being lost are the smaller ones — the business is winning where the money is. That is a healthy pattern and it usually means the sales effort is going to the right places.

Run the other way, and it is a different diagnosis entirely. If you win 70% of deals by count but only 45% by value, you are winning the easy small ones and losing the ones that matter, and the fix is almost never “sell harder.” It is seniority on big deals, or a pricing structure that falls apart above a certain size, or a qualification process that lets large unfunded opportunities eat the quarter.

One subtraction, and it points at completely different work.

Ranking Reasons by Money, Not Frequency

Here is the trap. A loss-reason report sorted by count says this:

Timing — 4 deals. Price too high — 3 deals. Lost to competitor — 2 deals. No response — 1 deal.

And “timing” looks like the problem.

Sorted by the money behind each reason, the same data reads differently. “Price too high” carries $51,400 of the $155,800 — a third of everything lost — because the deals that died on price were the large ones. Four small timing losses and one big pricing loss are not equal, and a frequency count insists they are.

Always rank by revenue, and show the count beside it. The count tells you how common a problem is; the revenue tells you whether to care.

The Five Reasons Worth Having

Mutually exclusive, five to seven of them, on a dropdown — never free text, or you will end up with forty reasons and no pattern:

1. Price too high — they compared your number to a budget or a rival and chose the other one.
2. Lost to competitor — someone else won it. Separate from price, because they are only sometimes the same thing, and a second field naming the competitor costs nothing.
3. No budget / not funded — there was never money. A qualification failure, and the cheapest kind to fix.
4. Timing / deferred — real need, wrong quarter. These should get a re-contact date rather than a burial.
5. No response / went dark — they stopped replying. This is a follow-up failure wearing a loss reason, and it belongs on the stalled-deal list before it ever reaches this table.

Plus one free-text note, one sentence, written the day it happens. Not a form — a sentence. “Went with the incumbent because switching mid-year meant re-training two sites” is worth more than any dropdown, and you will not remember it in March.

What does not belong on the list: “not a good fit.” It is where unexamined losses go to be filed, and it describes a feeling rather than an event.

Reading ‘Price Too High’ Properly

It is the most common loss reason in almost every small business, and it is the least literal.

It is also the politest available exit. A buyer who did not trust you, did not understand the proposal, or was never funded will still say your price was too high, because it is the one objection that ends a conversation without insulting anyone.

The way to tell them apart is the stage the deal died at:

• Died in Negotiating — they engaged with the number, argued about it, and still walked. That is genuine pricing signal, especially if you are also losing these to the same competitor.
• Died right after the quote landed, with no negotiation — nobody argued about anything. That is a value-communication problem: the quote arrived without the reasoning that justified it. Same words on the loss form, opposite fix.
• Died before a quote existed — this is a qualification failure being mislabelled. They told you their budget, or you never asked.

Which is why the loss reason is only half the record. The stage at death and the days the deal lived are the other half, and a sheet already has both.

The Speed of a Loss Tells You Something

In the worked business, wins take 50.9 days on average — fastest 13, slowest 69.

Set losses against that and a pattern appears. Losses that resolve much faster than your average win are usually qualification failures: they were never real, and finding out in nine days is a good outcome, not a bad one. Losses that drag well past your slowest win are the expensive ones — months of proposals and meetings for nothing — and they are the strongest argument for a hard rule that a deal past a certain age gets re-qualified or marked lost deliberately.

A deal at 90 days in a business whose slowest win ever took 69 is not nearly there. It is outside the range of everything that has ever worked.

What to Do With the Table

Once a quarter, with the loss table in front of you:

1. Read it by revenue. Whatever reason holds the most money is the only one worth a change this quarter.
2. Check the price losses against the stage they died at. Negotiating means look at your pricing. Post-quote silence means look at your quote.
3. Pull every “timing” loss with a re-contact date and actually contact them. This is a pipeline you have already paid for — in the worked business, the same principle applies to five dormant past clients holding $100,250 of prior revenue.
4. Count the losses with no reason recorded. If that number is not zero, nothing above is trustworthy. It is one dropdown at the moment of a “no” — the moment you are least inclined to do paperwork and most likely to remember why.

Ten lost deals a year feels too small to analyse. It is not. It is $155,800 and a third of it says the same word.

Related: the weighted pipeline forecast and lead source ROI — because a loss reason concentrated in one channel is a channel problem, not a sales problem.

Featured on ReadySheetGo

Client CRM, Sales Pipeline & Lead Tracker — $16.99

Thirteen linked tabs and 7,217 formulas, pre-filled with the 24 decided deals above.

The Win-Loss tab returns your win rate by count and by value side by side, ranks loss reasons by the revenue behind them rather than the count, and sets the speed of a loss against the speed of a win. Loss reasons come from a fixed dropdown on the Lists tab, and a row check counts any lost deal with no reason recorded — so the table cannot quietly be built on half the data.

Alongside: Pipeline and Forecast with weighted values and rolling 30/60/90-day windows, Follow-Ups building overdue and stalled lists, Source ROI returning a true cost per win by channel, Clients with lifetime value and a dormant list, plus Leads, Quotes, Activity, Dashboard and Settings.

Works in Excel and Google Sheets. No macros, no add-ons.

Get the Client CRM, Sales Pipeline & Lead Tracker →