Skip to main content
Back to the blog

How to Calculate and Track Sales Pipeline Conversion

How to work out win rate, stage-to-stage conversion and sales cycle length for a small business pipeline, with worked examples and common mistakes.

SC Steven Cahill

Why conversion is worth measuring

A pipeline shows what might happen. Conversion shows what usually does. Once you know how many enquiries become quotes, and how many quotes become work, you can answer practical questions. How many enquiries do we need next month? Is our pricing losing us jobs? Where do deals stall?

This guide explains the handful of figures worth tracking, how to calculate them, and the mistakes that make them misleading. The examples use round, made-up numbers to show the method.

Define your stages first

Conversion only means something if everyone agrees what each stage means. Write down a one-line definition for each stage and the event that moves a deal into it.

A simple pipeline for a small business might be:

  1. Enquiry — someone has asked about work.
  2. Qualified — it's real: they have a need, a budget and a timescale.
  3. Quoted — you've sent a price.
  4. Won or Lost — they've said yes or no.

[STEVEN: the stages you use, and why you settled on them.]

Keep it short. Every extra stage needs a clear rule, or people will put deals wherever feels right, and your figures will drift.

The four figures worth tracking

1. Win rate

Win rate is the share of closed deals you won.

Win rate = deals won ÷ (deals won + deals lost)

Only count deals that have closed. Deals still open don't belong in either half yet.

Example: in a quarter you closed 40 deals. You won 14 and lost 26. Win rate = 14 ÷ 40 = 35%.

2. Stage-to-stage conversion

This shows where deals drop out. For each pair of stages:

Conversion = deals that reached the next stage ÷ deals that reached this stage

Example: 100 enquiries, 60 qualified, 40 quoted, 14 won.

From → to Calculation Conversion
Enquiry → qualified 60 ÷ 100 60%
Qualified → quoted 40 ÷ 60 67%
Quoted → won 14 ÷ 40 35%
Enquiry → won 14 ÷ 100 14%

The biggest drop tells you where to look first. In this example, more than half of quotes are lost, so pricing, speed of quoting or follow-up are worth a closer look.

3. Conversion by value

Counting deals treats a £500 job the same as a £50,000 one. Work out the same figures using value:

Value win rate = value won ÷ (value won + value lost)

If your value win rate is much lower than your count win rate, you're winning the small jobs and losing the big ones. That's worth knowing.

4. Sales cycle length

How long does a deal take, from enquiry to won? Take the won deals in a period and average the days between the date each was created and the date it was won. If one or two very long deals skew the average, use the median instead.

Cycle length tells you how far ahead you need to fill the pipeline. If deals take ten weeks to close, this month's enquiries are next quarter's revenue.

Count by cohort, not just by period

There are two ways to count conversion, and they give different answers.

  • By period: "In March we won 14 deals and received 100 enquiries." Quick, but the wins may have come from January's enquiries.
  • By cohort: "Of the 100 enquiries received in March, 14 have been won so far." More accurate, but you have to wait for the cohort to close.

For a small business, by period is usually fine for a monthly check. Use cohorts when you want to compare one month or one lead source fairly against another.

Using conversion to forecast

Once you know your quoted-to-won rate, you can make a rough forecast. Multiply the value of open quotes by your historical win rate.

Example: you have £80,000 of open quotes and a value win rate of 30%. A rough expectation is £24,000 of work.

Some teams go further and give each stage its own probability: 10% at enquiry, 30% at qualified, 50% at quoted, and so on. That's called a weighted pipeline. It's only as good as the probabilities, so base them on your own history, not on a template. Revisit them every few months.

Common mistakes

  • Counting open deals as lost. A deal that's still open hasn't failed. Leave it out of win rate until it closes.
  • Never closing dead deals. The opposite problem. A deal nobody has touched in six months is lost in all but name. Close it with a reason, or your pipeline looks bigger than it is.
  • Changing stage definitions mid-year. Your figures before and after won't compare.
  • Too few deals. With ten deals a quarter, one win moves your rate by ten points. Look at longer periods, and don't over-react.
  • Ignoring lost reasons. The rate tells you how often you lose. The reason tells you why.

[STEVEN: a mistake you've made, or seen a customer make, when reading conversion figures.]

How to track it week to week

You don't need complex tools. A spreadsheet with one row per deal can hold everything you need:

  • date created
  • lead source
  • value
  • current stage
  • date won or lost
  • lost reason

From those six columns you can calculate every figure in this guide. The hard part is discipline: every deal logged, every stage change recorded, every closed deal marked won or lost with a date.

A CRM does the recording as a side effect of normal work. Moving a deal to the next stage, or marking it lost with a reason, captures the data without a separate step. Beagle CRM's reports show your win rate and pipeline value by stage from the leads you already keep. You can see what's in Beagle's reporting.

What to do with the numbers

Measurement only helps if it changes something. Some typical responses:

  • Low enquiry-to-qualified: your marketing may be attracting the wrong enquiries. Look at which lead sources qualify best.
  • Low quoted-to-won: look at pricing, how quickly you quote and how you follow up. Read the lost reasons.
  • Long sales cycle: find the stage where deals wait longest, and give each deal there a dated next step.
  • High count win rate, low value win rate: find out what's different about the larger jobs you lose.

[STEVEN: a change you made after looking at your own conversion figures, and what happened.]

A one-page summary

  • Define each stage in one line, with the event that moves a deal into it.
  • Win rate = won ÷ (won + lost). Leave open deals out.
  • Track stage-to-stage conversion to find the biggest drop.
  • Repeat by value as well as by count.
  • Measure cycle length so you know how far ahead to fill the pipeline.
  • Close dead deals with a reason.
  • Review monthly, and act on the biggest gap first.

Was this useful?

A quick like helps us shape future posts.

0 likes

Join the conversation

Comments

Log in to leave a comment.