Map Extract
Free tool

Sales win rate, and how much to trust it

Your win rate is the share of opportunities you win. The number changes a lot depending on whether you count deals that ended with no decision, and with a small number of deals it can swing by chance. This calculator gives the rate three ways, a likely range around it, and a breakdown by rep, source or segment from a pasted CRM export.

Runs in your browser. Nothing you enter is uploaded.

Three ways to count

MethodFormulaUse it when
Won ÷ won and lostwon ÷ (won + lost)You want the rate on deals that reached a clear outcome
Include no decisionwon ÷ (won + lost + no decision)Deals that stall are a real cost; the stricter, more honest view
Include openwon ÷ every opportunity, open ones tooComparing cohorts where many deals are still running; tends to understate

Working out the rate

  1. Enter the counts

    Won, lost, no decision and still open, for the same period or cohort of opportunities.

  2. Choose the method

    Pick one of the three. The examples show the same numbers counted each way, so you can see how much the choice matters.

  3. Read the rate and its range

    The figures show the win rate, a Likely range (95%), how many deals were counted and the share lost or undecided. The range narrows as you add more deals.

  4. Break it down by group

    In By rep, source or segment, paste rows of group, outcome and value from a CRM export. Outcomes can be Won, Lost, No decision or Open. Each group gets its own rate, range and won value.

  5. Export

    Download the totals and groups as CSV, Excel or JSON, or copy a summary line.

Example: a small agency's half year, and two salespeople

Over six months an agency won 9 opportunities, lost 14, saw 5 stall with no decision and still has 7 open. Counted as won over won and lost, the win rate is 39.1%. Counting the stalled deals as losses drops it to 32.1%.

The range is the important part. With only 23 decided deals, the likely range runs from about 22% to 59%, so a single good month could move the headline figure a long way. Comparing the two partners, Amira won two of three and Joe one of three, but their ranges overlap heavily: there is not yet enough evidence that one is better at closing.

Input
Won 9   Lost 14   No decision 5   Open 7

rep,outcome,value
Amira,Won,4500
Amira,Lost,3000
Amira,Won,6000
Joe,Lost,5000
Joe,No decision,2500
Joe,Won,8000
Joe,Lost,4000
Result
Won ÷ won and lost:   Win rate 39.1%   Likely range 22.2% to 59.2%   Deals counted 23
Include no decision:  Win rate 32.1%   Likely range 17.9% to 50.7%   Deals counted 28

Amira  Won 2  Lost 1  No decision 0  Win rate 66.7%  Range 20.8 to 93.9%  Won value £10,500.00
Joe    Won 1  Lost 2  No decision 1  Win rate 33.3%  Range 6.2 to 79.2%   Won value £8,000.00

Why the range matters for small teams

Large sales teams have hundreds of deals a quarter and their win rate is fairly stable. A small business might close a dozen. With so few, the difference between winning four and winning six is luck as much as skill, and decisions made on that difference, such as dropping a lead source or changing a salesperson's targets, may be wrong.

The likely range is a 95% confidence interval: roughly, the band within which the true rate probably lies given the deals you have. When two groups' ranges overlap a lot, treat them as the same until more deals come in.

Questions people ask

How do you calculate win rate in sales?

Divide the number of opportunities won by the number that reached a decision. If you won 9 and lost 14, your win rate is 9 ÷ 23, or 39%. Decide up front whether deals that ended with no decision count as losses, and use the same rule every time so the figure can be compared over time.

Should no decision count as a loss?

Many teams think it should, because the time spent on a stalled deal is lost just the same, and leaving them out flatters the rate. The calculator shows both, so you can report the stricter figure and still see the rate on deals that reached a clear yes or no.

What is a good win rate?

It varies widely by industry, deal size and how strictly opportunities are qualified. Referrals and warm leads usually convert far better than cold outreach. Compare against your own history, by lead source, rather than a general benchmark.

What does the likely range mean?

It shows how far the win rate could plausibly be from the true long-run rate, given how few deals there are. With 23 decided deals, a 39% rate could reasonably be anywhere from about 22% to 59%. As deals accumulate, the range narrows and the headline figure becomes more reliable.

Where your data goes

Deal counts and any CRM rows you paste are processed in your browser only. Rep names, outcomes and deal values are not uploaded.

Checked against the tool on

Top