Sales pipeline management

Why it matters

Revenue is a lagging indicator; by the time it is low, it is too late to fix. Pipeline is the leading indicator. If you know you need three times your target in qualified pipeline to hit it, and you can see you only have twice, you have months to generate more leads, not days. Pipeline discipline is also what makes a sales hire manageable: you can coach on stages and conversion rates, not just on results.

Stages that reflect buyer behaviour

Pipeline stages should describe what the buyer has done, not what you have done. "Sent proposal" is your activity; "proposal reviewed with the decision-maker" is buyer behaviour. The difference matters because a proposal you emailed into silence is not progress, and treating it as progress inflates the pipeline.

Four to six stages is the right range for most small businesses. Fewer and you cannot see where deals stall; more and nobody keeps it up to date. For each stage write a one-line exit criterion: the thing that must be true before the deal moves on. Then record the typical probability of winning from each stage once you have a few months of data; those probabilities are what later feed your forecast.

• Qualified: need, timing and decision-maker confirmed in a conversation.
• Discovery: scope, success criteria and rough budget agreed.
• Proposal: written offer delivered and walked through with the buyer.
• Negotiation: buyer has given feedback and is working towards terms.
• Verbal commitment: buyer has said yes; contract or PO in progress.
• Closed won or closed lost, with a reason recorded.

Coverage: how much pipeline is enough

Pipeline coverage is the total value of open, qualified deals expected to close in a period divided by the revenue target for that period. If your historical win rate from "qualified" is one in three, you need roughly three times your target in pipeline to hit it, and a little more to allow for deals that slip. Coverage is the single number that tells you whether to spend this week prospecting or closing.

Calculate it for the next quarter, not just this month, because the lag between a new lead and a closed deal is usually weeks or months. Low coverage two quarters out is a prospecting problem you can fix now; low coverage this month is a problem you can only partly fix by closing faster.

The weekly pipeline review

Once a week, open the pipeline and go through every deal, ideally in the same thirty-minute slot. For each one ask three questions: what has the buyer done since last week, what is the next step and when, and is the close date still realistic? Any deal with no buyer action for longer than your usual stage duration gets a specific plan or gets moved to closed lost.

The review is also where you look at the shape of the pipeline. Lots of deals at proposal and few at discovery means a dry patch is coming. Lots at qualified and nothing further on means something is stopping deals from progressing, often a missing discovery conversation or a slow proposal turnaround. The shape tells you what to work on this week.

Hygiene: the pipeline is only as good as its data

A pipeline with stale deals, missing values and fantasy close dates is worse than no pipeline, because it gives false confidence. Set simple rules: every deal has a value, a close date, a stage and a next action with a date. Any deal whose close date has passed is updated or closed the same week. Any deal with no activity for twice the normal stage length is reviewed and usually closed lost.

Closing deals as lost is not failure; it is honesty, and it produces the most useful data you have. Record why: no budget, chose a competitor, timing, no decision. After a quarter the reasons will tell you where to tighten qualification or improve your offer.

How to set up and run a pipeline

1. Define four to six stages with buyer-based exit criteria Write one line per stage describing what the buyer has done.
2. Load every live opportunity Value, stage, expected close date, decision-maker and next action. Be honest about which stage each is really at.
3. Set your revenue target for the next quarter Pipeline only means something against a number.
4. Calculate coverage Qualified pipeline for the quarter divided by target. Compare with 1 ÷ your win rate.
5. Hold a 30-minute weekly review Every deal: buyer movement, next step, realistic date. Close stale deals.
6. Record win and loss reasons Use them quarterly to improve qualification and your offer.
7. Measure stage conversion and duration After a quarter of data, you will know your win rate by stage and where deals stall.

Real-world example

A Brisbane IT services firm fixes its coverage problem

Northside Managed IT supports small professional firms across Brisbane. Revenue is lumpy: some months they sign three new clients, others none. The pipeline spreadsheet shows $400,000 of "opportunities", which sounds comfortable against a target of $90,000 of new annual contract value per quarter.

When the owner, Lee, rebuilds the pipeline with buyer-based stages, half the deals turn out to be proposals sent months ago with no response. She closes them as lost and is left with $150,000 of genuine qualified pipeline for the quarter. Her win rate from qualified is about one in three, so she needs around $270,000 of coverage and she has just over half of that. Rather than discover this in the last week of the quarter, she knows it in week two, and shifts two mornings a week to prospecting. The quarter still comes in a little short, but the following one hits target, and the weekly review becomes the first fixed meeting in the calendar.

Common mistakes

• Stages based on your activity "Sent proposal" tells you nothing about the buyer. Define stages by what the buyer has done, and move deals only when it has happened.
• Letting dead deals linger Stale opportunities inflate coverage and hide the real shortfall. Close them, record the reason, and move on.
• Close dates that always slide If a date moves more than twice, the buyer has not committed to a timeline. Ask them directly what has to happen by when.
• Skipping the weekly review A pipeline you look at monthly is a report. A pipeline you review weekly is a management tool.
• Measuring total pipeline instead of qualified coverage A big number of unqualified maybes is not security. Count only deals past qualification with a date in the period.

KPIs to track

• Pipeline coverage Qualified pipeline divided by target for the period. Needs to be at least 1 ÷ win rate; many businesses aim for three to four times.
• Stage conversion rates The share of deals moving from each stage to the next. Shows exactly where deals stall.
• Average days in stage How long deals spend at each stage. A deal well past the average is at risk and needs a plan.
• Win rate Deals won divided by deals that reached qualification and closed either way. Track by source and deal size.
• Sales velocity Number of deals × average value × win rate ÷ sales cycle days. One number for how fast the pipeline turns into revenue.

Frequently asked questions

How many stages should my pipeline have?

Four to six for most small businesses. Enough to show where deals stall, few enough that you and your team will keep them accurate.

Do I need software to manage a pipeline?

A spreadsheet works for one person with a dozen deals. Once there are two people or more than about thirty live opportunities, a CRM pays for itself in time saved and deals not forgotten.

What counts as qualified pipeline?

A deal where you have confirmed a genuine need, a realistic timeframe, access to the decision-maker and a budget range in a conversation with the buyer. Anything less is a lead, not pipeline.

When should I mark a deal as lost?

When the buyer has told you no, chosen someone else, or gone silent for longer than twice your normal stage duration despite a proper follow-up sequence. You can always reopen it later.

Key takeaways

• Define stages by buyer behaviour and write an exit criterion for each.
• Coverage, not total pipeline, tells you whether you will hit the number.
• Review every deal weekly: buyer movement, next action, realistic date.
• Close stale deals honestly and record why; the reasons improve your selling.
• Pipeline is a leading indicator; use it to fix next quarter while there is still time.