How to build a sales pipeline: stages, metrics and examples
We earn a commission if you buy through some links on this page, at no extra cost to you. It never affects the order. How we make money.
To build a sales pipeline, you map the steps a buyer takes from first contact to paying you, give each step clear entry and exit rules, and track every deal through those steps in one place. A good pipeline shows at a glance what is likely to close, where deals get stuck and how much revenue to expect. This guide walks through designing stages, choosing the numbers to track, forecasting, and the weekly habits that keep a pipeline honest.
What a sales pipeline is
A sales pipeline is a visual and numerical view of all your open deals, arranged by stage. Each deal sits in one stage, such as Qualified, Proposal or Negotiation, and moves to the right as it progresses. The pipeline answers three questions every business needs answered: how many deals are open, how much they are worth, and which ones need attention now.
People sometimes confuse a pipeline with a funnel. The funnel describes how many leads drop out at each step overall, which is a marketing and conversion view. The pipeline is the working list of specific deals the sales team is handling right now.
Step 1: map how your customers actually buy
Start from the buyer's side, not your internal process. Write down what happens from the moment someone first contacts you to the moment they pay. For a service business this might be: enquiry, discovery call, proposal, questions and negotiation, signed contract, deposit paid. For a software company it might include a demo and a trial.
Look at a few recent won deals and a few lost ones. What steps did each go through? Where did the lost ones stop? Your pipeline stages should reflect real, observable steps, not wishful ones such as "very interested".
Step 2: define five to seven stages
Most small businesses do well with five to seven stages. Fewer and you cannot see where deals stall; more and people struggle to place deals correctly. A common B2B example:
- New lead: contact details received, not yet qualified.
- Qualified: the need, budget range and decision-maker are confirmed.
- Meeting or demo held: a proper discovery conversation has happened.
- Proposal sent: a written offer with price is with the buyer.
- Negotiation: the buyer is discussing terms, not just whether to proceed.
- Won or Lost.
Adapt the names to your language and customers. A shop selling by WhatsApp might use Enquiry, Quote sent, Awaiting payment, Paid and Delivered.
Step 3: write exit criteria for each stage
Exit criteria are the specific conditions a deal must meet to move to the next stage. They are what make a pipeline trustworthy. Without them, one salesperson's "Proposal" is another's "Qualified", and the forecast becomes guesswork.
Examples:
- Lead to Qualified: we know the problem, an approximate budget, the timeline and who decides.
- Qualified to Meeting held: a discovery call took place and notes are logged.
- Meeting held to Proposal: a written proposal with price was sent.
- Proposal to Negotiation: the buyer has responded with questions on terms, not silence.
Write these down and put them in your CRM's stage descriptions so they are visible where people move deals.
Step 4: choose a place to manage the pipeline
You can run a pipeline in a spreadsheet at first, with one row per deal and a column for stage, value and next step. It quickly becomes hard to maintain once several people are involved or you have more than a few dozen deals.
A CRM is built for this. Deals appear as cards on a board, you drag them between stages, activities are logged automatically and reports are ready-made. Compare options in the CRM ranking, or see what a CRM is if you are new to them. Pipeline-focused CRMs such as Pipedrive are especially simple to start with; see HubSpot vs Pipedrive and Pipedrive vs Freshsales.
Step 5: give every deal an owner, value and next step
Every open deal should have three things: a person responsible, an estimated value, and a next step with a date. The next step is the single most useful habit in pipeline management. A deal with no next step is a deal nobody is working on.
Add an expected close date too, but treat it as an estimate that you update honestly. Many CRMs can flag deals with no next activity or with close dates in the past. Use those alerts as a daily to-do list.
Step 6: fill the pipeline with the right leads
A pipeline is only as good as what goes in. Track where leads come from, such as referrals, search, ads, events or outbound, and which sources produce deals that close. You may find that a small source, such as referrals, produces most of your revenue.
Capture leads into the CRM automatically from website forms and chat, and assign them quickly. Speed matters: leads contacted soon after they enquire are generally more likely to convert. Our guide to lead management covers capturing, qualifying and routing leads.
The pipeline numbers that matter
You do not need dozens of reports. Five numbers tell you most of what matters:
- Number of open deals by stage.
- Pipeline value: total value of open deals, ideally by stage.
- Win rate: won deals divided by all closed deals (won plus lost) over a period.
- Average deal size of won deals.
- Sales cycle length: average days from creation to won.
These combine into pipeline velocity: number of deals multiplied by win rate and average deal size, divided by cycle length. It gives a rough figure for revenue per day flowing through the pipeline, and shows which lever to pull: more deals, better win rate, bigger deals or faster cycles.
Stage conversion rates
Look at the percentage of deals that move from each stage to the next. If many deals reach Proposal but few move to Negotiation, your proposals or pricing may be the issue. If many leads never become Qualified, your marketing may be attracting the wrong people, or follow-up may be too slow.
Conversion rates need enough deals to be meaningful. With small numbers, look at three or six months together, and read individual lost deals for reasons. Record a short "lost reason" on every lost deal, chosen from a fixed list such as price, timing, chose competitor, no decision or not a fit.
Forecasting revenue from the pipeline
The simplest forecast is a weighted pipeline: multiply each deal's value by the probability for its stage, then add them up. Stage probabilities should come from your own history, for example the share of deals at Proposal that you eventually win.
A second method is the commit forecast: each salesperson says which deals they expect to close this month, and managers review them. Comparing the two methods each month is a good check on optimism. Our sales forecast calculator does the weighted calculation for you, and AI features in modern CRMs can add risk alerts, as covered in AI for sales teams.
How big should your pipeline be?
A common rule of thumb is to have several times your sales target in open pipeline value, because many deals will be lost or delayed. The right multiple depends on your win rate. If you win about one in four deals that reach Proposal, you need roughly four times your target at that stage.
Work it backwards from your goal: target revenue divided by average deal size gives the number of deals you need to win; divided by your win rate gives the number of qualified deals you need; divided by your lead-to-qualified rate gives the number of leads. This turns a vague target into a concrete weekly activity plan.
Weekly pipeline review
A short weekly review keeps the pipeline honest. Thirty minutes is usually enough for a small team:
- Look at deals with no next step or overdue tasks and fix them.
- Review deals expected to close this month: what could stop them?
- Check deals that have not moved stage in a long time. Move them forward, set a deadline, or close them as lost.
- Look at new deals added this week and where they came from.
- Agree one or two actions for the week.
Run the review from the CRM screen, not from separate slides. That simple habit makes people keep the CRM current.
Cleaning stale deals
Pipelines fill up with deals that are not really alive: prospects who went silent months ago, budgets that disappeared, contacts who left the company. They inflate pipeline value and make forecasts unreliable.
Set a rule, such as: any deal with no customer response for a set period gets one final message, then is marked lost with reason "no decision". You can always reopen it. A smaller, honest pipeline is far more useful than a large, imaginary one.
Multiple pipelines
Some businesses need more than one pipeline, for example one for new customers and one for renewals or upsells, or separate pipelines for products with very different sales processes. Keep each pipeline simple and only split when the stages really differ. Many CRMs limit the number of pipelines on lower plans, which affects cost; see how much a CRM costs.
Pipelines for service businesses and freelancers
Freelancers and small service firms benefit from a pipeline too, even with a handful of deals. A simple board with Enquiry, Call booked, Proposal sent, Accepted and Invoiced shows which prospects need a nudge and how much work is coming. Pair it with a scheduling tool for calls and our quote generator for proposals.
When a deal is won, move it straight into delivery. Many teams connect their CRM to project management software so a won deal creates a project automatically, and to invoicing software so the deposit invoice goes out the same day.
Example pipeline: B2B software
A small software company selling to businesses might use: New lead, Discovery call, Demo, Trial, Proposal, Negotiation, Won or Lost. Exit criteria for Trial could be "the customer has set up an account and invited at least one colleague". Probabilities might be low for early stages and higher once a trial is active. The key metrics are trial-to-proposal conversion and cycle length, since long trials slow revenue.
Example pipeline: local service business
A renovation company might use: Enquiry, Site visit booked, Site visit done, Quote sent, Deposit paid, Job scheduled. Exit criteria for Quote sent: "written quote with price and dates sent". The key metrics are enquiry-to-site-visit rate and quote acceptance rate. If quote acceptance is low, they might test faster quotes or clearer options. Tools: a CRM, a scheduling link for site visits and our profit margin calculator to check that quoted prices protect margin.
Common pipeline mistakes
- Stages named after internal activities rather than buyer progress.
- No exit criteria, so stages mean different things to different people.
- Deals without next steps or owners.
- Keeping dead deals open to make the pipeline look healthy.
- Using made-up stage probabilities instead of your own history.
- Too many stages, fields and pipelines in the first version.
Questions
How many stages should a sales pipeline have?
Five to seven stages suit most small businesses. Enough to see where deals stall, few enough that everyone places deals consistently.
What is the difference between a sales pipeline and a sales funnel?
A pipeline is the working list of specific open deals by stage. A funnel shows how many prospects drop out at each step overall.
Can I build a sales pipeline in a spreadsheet?
Yes, to start. Once several people sell or you have more than a few dozen deals, a CRM is much easier to keep accurate.
How do I calculate a weighted pipeline?
Multiply each deal's value by the win probability for its stage, based on your history, and add the results.
How often should we review the pipeline?
Weekly is a good rhythm for most small teams, with a quick daily look at overdue next steps.
When should a deal be marked as lost?
When the buyer has clearly declined, or has not responded for a set period despite follow-ups. Record a reason; you can always reopen it.
What is pipeline velocity?
Number of open deals times win rate times average deal size, divided by sales cycle length. It estimates how much revenue flows through the pipeline per day.