How to Calculate Win Rate When Deals Are Still Open

Win rate looks like a two-input calculation until you decide what to do with the opportunities that have no outcome yet. Most pipelines have more open deals than closed ones at any moment, so the treatment of that group determines the number more than the selling does. This guide covers the correct denominator, the cohort alternative, and how long to wait before either version means anything.

How do you calculate win rate when deals are still open?

Exclude open deals from both halves and count only opportunities that reached a won or lost outcome in the period.

``` Win Rate = Closed Won / (Closed Won + Closed Lost) x 100 ```

A quarter that ends with 40 won deals, 60 lost deals, and 200 still open has a win rate of 40 percent. The 200 open opportunities have not produced information yet, and adding them to the denominator gives 40 divided by 300, or 13.3 percent. That figure moves whenever marketing generates more pipeline, which makes it a measure of volume rather than of conversion.

The rule is simple to state and gets violated constantly, usually through a report filter that pulls all opportunities with a close date in the quarter rather than all closed opportunities. Deals sitting open past their forecast close date land inside that filter and quietly enter the denominator.

Which win rate method should you use?

Match the method to the question, because the two correct methods answer different things. The closed period method is right for a quarterly business review, since it describes what happened in the quarter. The cohort method is right for lead source, segment, and campaign decisions, because it follows a specific set of opportunities from creation to resolution without letting a heavy pipeline-building quarter distort the comparison.

Reporting both is standard practice, and reporting them without labels is how two people end up quoting different win rates from the same CRM in the same meeting.

How long before a cohort win rate is readable?

Wait until most of the cohort has resolved, which is around 12 weeks for most opportunity groups.

At ORM every opportunity is grouped by a machine learning model, and each group gets a predicted curve for how long it takes to close. Those curves run from 1 to 80 weeks, with most of the expectation falling before week 12 and very few groups carrying expectation past 52 weeks.

That distribution sets the reading schedule. A cohort measured at week 4 is dominated by fast disqualifications, since losses resolve faster than wins, and it will show a win rate well below the eventual answer. At week 12 most of the outcomes have landed. At 52 weeks the cohort is effectively closed for practical purposes.

Reading a cohort too early is the most common cause of a lead source getting cut for underperformance it never had. The channel with a longer sales cycle always looks worse at week 6.

What do you do with deals that never resolve?

Close them out on a documented rule instead of letting them age in the pipeline forever.

ORM applies a 12 month rule for most of its customers. Meaningful activity means a change in stage, close date, or amount. An opportunity with none of those in twelve months is not a live deal, whatever the rep says in a pipeline review.

Stale opportunities do more damage than a wrong win rate. Across ORM customer accounts, more than 10 percent of pipeline typically has not been touched in twelve months. That inventory inflates pipeline coverage, makes the denominator of every conversion metric unreliable, and hides the fact that the real coverage is thinner than the dashboard claims.

The absence of activity is itself the signal. The earliest indicator that a deal is dead is nothing happening on it: no stage movement, no data changes, no notes. From the seller's side, a buyer who stops returning email and stops taking calls has already decided.

How do close date changes distort period win rate?

Every close date push moves an opportunity from one denominator to another, which changes both periods without changing any outcome.

A rep who moves ten deals from March to April removes them from Q1's calculation and adds them to Q2's. If those deals were headed for losses, Q1's win rate improves and Q2 inherits the problem. Nothing about the deals changed.

Close date changes are the clearest deal slippage signal in the CRM. A deal that slips from one quarter to the next is less likely to close, even when it sits in commit. Track the count of close date changes per deal alongside the win rate rather than trying to correct the win rate for them.

How does open deal treatment affect the forecast?

A win rate that includes open deals feeds a low conversion assumption into every weighted calculation built on it.

Stage probabilities, coverage targets, and expected value math all inherit whatever win rate you supplied. Understate it and the model demands pipeline the business does not need. Overstate it by excluding no-decision losses and the plan runs short.

The deeper issue is that a single win rate applied across a whole pipeline treats every opportunity as average. A weighted pipeline built that way carries the same blind spot, since it multiplies a blended rate against deals whose real conversion odds differ by segment, source, and age. Read the win rate as a diagnostic input rather than as a forecast in itself.