Sales Pipeline: Define the Stages, Build It and Keep It Honest
Stages with exit criteria, a step-by-step build, the arithmetic behind weighted value and coverage, and a weekly review that stops stale deals from inflating the numbers.

by Benjamin WagnerA sales pipeline is the list of every deal you are currently working, sorted by the stage it has reached, with a value and a next step on each one. You build one by writing down the stages your deals really pass through, giving each stage a condition a deal must meet to enter it, and putting every open deal into the stage it has actually reached. Most small teams need five to seven stages.
The hard part is keeping it true. A pipeline full of deals nobody has touched in two months tells you less than no pipeline at all, because it looks like money. This guide covers stage definitions with exit criteria, a build checklist, the arithmetic for weighted value, coverage and velocity, and a weekly review routine. Customermates publishes this guide; the section on setting up the pipeline in Customermates is labelled as such.
- Every open deal, grouped by stage, each with a value, an owner and a next step.
- Five to seven. Each needs an entry condition a colleague could check without asking you.
- Coverage: open pipeline value divided by the revenue you still need. The target ratio is roughly 1 divided by your win rate.
- A 30-minute weekly review of late-stage deals and anything that has not moved in two weeks.
Turn your target into account actions, owners and review dates with the filled 90-day sales plan template. Its capacity worksheet checks whether the planned work fits the team.
Pipeline, funnel and sales process
People use the three words loosely. The distinction matters only when you decide what to measure.
| Term | What it describes | Question it answers |
|---|---|---|
| Sales process | The steps your team takes to win a deal | What should we do next with this kind of buyer? |
| Sales pipeline | The deals currently moving through that process | Where is each deal, and what is it worth? |
| Sales funnel | Conversion between stages across many leads over time | How many leads do we need to win one customer? |
A pipeline is about named deals. If you can't point at a card and say who the buyer is and what happens on Thursday, it is a funnel report, not a pipeline.
The stages and their exit criteria
The stage names matter less than the rule that moves a deal from one stage to the next. Without that rule, one rep's "Proposal" is another rep's "had a nice call". The same goes for the earliest stages, where teams draw the difference between a prospect and a lead in different places. The table below uses the seven stages most guides list, with an entry condition you can check and a starting probability for weighting.
| Stage | A deal enters when… | Starting probability |
|---|---|---|
| Prospecting | You have identified the buyer and made first contact | 10% |
| Qualification | The buyer has replied and agreed to a conversation | 20% |
| Demo or discovery | Budget, decision-maker and timing are confirmed, and a meeting is booked | 40% |
| Proposal | The buyer has asked for a written offer, and you sent it | 60% |
| Negotiation | The decision-maker has read the offer and is discussing terms | 80% |
| Won | Signed contract or purchase order | 100% |
| Lost | The buyer said no, chose someone else, or went silent past your cut-off | 0% |
The probabilities are placeholders. After a quarter, replace each one with your own rate: of the deals that reached this stage, what share of their value was won?
Service businesses often merge Prospecting and Qualification into "Inquiry", because buyers come through referrals and arrive already interested. A consultancy pipeline might read: Inquiry, Discovery call, Proposal sent, Negotiation, Won, Lost. Six stages, and every one of them maps to something the client did, not something you hoped.
Four, five or seven stages? You will find all three models, and none of them is a standard. Use as many stages as there are points where deals actually stall or drop out. If two stages always pass in the same week, merge them.
How to build a sales pipeline from scratch
List your last ten won and lost deals
Write down what happened in each, in order: first contact, first call, offer, and so on. The stages are the steps that appear in nearly all of them. Don't design from a textbook; design from your own deals.Write one entry condition per stage
Make it observable. "Buyer asked for a proposal" works. "Buyer seems interested" does not.Decide what lands in Lost
Pick a silence cut-off, for example 45 days without a reply, and a short list of loss reasons: price, timing, competitor, no decision. You will want these numbers in six months.Choose a place for it
A spreadsheet works for one person and a dozen deals. Once two people share deals, or conversations happen in email and LinkedIn, a CRM saves the copy-pasting. Our spreadsheet CRM template covers the spreadsheet route.Enter every open deal at its true stage
Be strict. A deal where you sent an offer three months ago and heard nothing is not in Negotiation. Expect your total to shrink on day one; that is the point.Give every deal a next step and an owner
A deal without a next step is waiting to become Lost. A deal without an owner already is.Book the weekly review
Same day, same time, 30 minutes. The checklist is further down.
A worked example: a three-person consultancy
Take a small consultancy with three open deals. The values and probabilities are illustrative.
| Deal | Value | Stage | Probability | Weighted value |
|---|---|---|---|---|
| Website relaunch | €18,000 | Proposal | 60% | €10,800 |
| Marketing retainer, 6 months at €4,000 | €24,000 | Qualification | 20% | €4,800 |
| Sales training day | €3,000 | Negotiation | 80% | €2,400 |
| Total | €45,000 | €18,000 |
The raw pipeline says €45,000. The weighted pipeline says €18,000, and that is closer to what the partners should plan around. Notice that the biggest deal by value contributes the least weighted value, because it is still early. That is the conversation to have in Monday's review: what has to happen for the retainer to reach Demo, and by when?
To turn the weighted pipeline into a quarterly number, with expected close dates, a commit floor and a side-by-side check against win rate and run rate, see our guide to sales forecasting.
The numbers worth tracking
You do not need a dashboard of twenty metrics. Five cover almost every decision a small team makes about its pipeline.
| Metric | How to calculate it | What it tells you |
|---|---|---|
| Pipeline value | Sum of all open deal values | The ceiling of what you could win |
| Weighted value | Each deal's value × its stage probability, summed | A deterministic estimate; only as good as your probabilities |
| Coverage | Open pipeline value ÷ revenue still needed this period | Whether you have enough deals in play |
| Stage conversion | Deals that reached the next stage ÷ deals that entered this one | Where deals stall |
| Velocity | (Open deals × average value × win rate) ÷ average cycle in days | Revenue the pipeline produces per day |
Coverage, done properly. "Aim for 3x" is a convention, not a law. The ratio you need is 1 divided by your win rate by value. If you win 25% of the value you pitch, you need 4x coverage: a €60,000 quarterly target needs €240,000 in open deals that can close this quarter. If you win 40%, 2.5x is enough. Deals that cannot close before the period ends don't count, however large they are.
Velocity, with numbers. Twenty open deals, an average value of €8,000, a 25% win rate and a 60-day cycle give (20 × 8,000 × 0.25) ÷ 60 = €667 per day. Raising the win rate to 30% lifts it to €800. Shortening the cycle to 45 days lifts it to €889. That second lever is often easier for a small team to pull, because it usually means sending offers faster.
Stage conversion is where problems show up first. If most of your demos lead to proposals but few proposals reach negotiation, the offer is the problem, not the lead source.
Sales pipeline management: the weekly review
Thirty minutes, with everyone who owns deals. Go through it in this order:
- Late stages first. Every deal in Proposal and Negotiation: what did the buyer do since last week, and what is the next dated step?
- Stalled deals. Anything whose record has not changed in 14 days. Move it back a stage, make one more attempt with a different angle, or close it as Lost with a reason.
- New deals. Check that each one meets the entry condition of the stage it was put in.
- Coverage check. Compare open value that can close this period with what you still need. If it is short, the rest of the week goes to prospecting.
- Lost reasons. Once a month, count them. Three losses on price in a row is a pricing conversation, not bad luck.
Setting up the pipeline in Customermates
This section describes our own product. Customermates is an open-source sales CRM for small client-facing teams, built in Germany. Here is how the pipeline above maps onto it.
Stages. Stages are not preset: you add a Stage field to your deals list, for example with the seven stages from the table above: Prospecting, Qualification, Demo, Proposal, Negotiation, Won and Lost, weighted 10, 20, 40, 60, 80, 100 and 0 percent. In the cloud, AI setup can create it from your description. The stage is a Single choice field, so you rename, add or remove stages yourself. The probabilities are set as Probability % on each option when you open the Stage field in Data model for Deals, and a preview shows the effect before you save. For total and weighted pipeline figures, add a chart widget on the Dashboard that sums Value or Weighted value, grouped by stage. How the calculation works is in the core concepts.
Deal value. Choose the model your business needs. A deal value can be an entered money field or a calculated total of linked line items. In a line-item setup, each amount is quantity times the effective unit price; the deal total sums those amounts. Live prices follow later price changes, while saved prices keep the captured amount. The retainer in the example could be one line with a quantity of 6. Weighted value is an optional calculation: deal value times the stage probability divided by 100. The calculated-field and pricing guide covers missing inputs, currencies and access.
The board. Switch the deals list to Board under Appearance and group it by Stage. Add summaries to the grouping, such as the sum of Value and Weighted value, to see each column's totals. Dragging a card to another column changes its stage. The pipeline feature page shows the board, and the records guide lists every layout and grouping option.
Views for the weekly review. Saved views remember filters, grouping and layout. Two that match the review checklist:
- Late stage: filter Stage to Proposal and Negotiation, sort by value.
- Stalled: filter Updated at to "Older than…" 14 days. This catches any deal whose record nobody has edited. It looks only at changes to the deal itself, not at emails or messages, so check the latest conversation before you move a deal to Lost.
Create each with New view, then share it with the whole team or with selected roles, so everyone works from the same pipeline in the weekly review.
Conversations next to deals. On Pro and above, the unified inbox connects email, LinkedIn, WhatsApp, Instagram and Telegram, so the thread that moved a deal sits on the contact linked to it. Starter has no inbox. A pipeline goes stale when a conversation gets no reply and no next step. That is what Customermates is built to catch: Mate or your own AI agent drafts the reply and the next step, you review and send, and the next steps appear on your dashboard.
A routine for Monday morning (Customermates Cloud). Routines run a saved instruction for Mate, the assistant in Customermates Cloud, on a schedule, and they use hosted AI credits. A weekly routine for the review, with the schedule set to Every week, Monday, 8:00, might have these instructions:
List my deals in Proposal or Negotiation that have not been updated in 14 days. For each, summarize the notes and, if there is one, the latest conversation with the linked contact, and suggest one next step. Do not send any message and do not change any deal.
Keep the routine focused on preparation: asking it to draft is different from asking it to send. It runs as its owner and follows that user’s access and the available approval controls. Review the proposed next step against the actual conversation before acting. The routines guide covers schedules, permissions and limits.
Your own AI client instead. If you work in Claude, ChatGPT or another MCP client, it can read and update deals through the MCP server with your own provider and no hosted credits. This also works on a self-hosted installation, which has no inbox and no Mate.
What it costs. Pipeline, board, weighted values and saved views are in every plan. For three people, Starter is €36 per month and Pro, which adds the inbox, is €87 per month. Billing is monthly, and each paid plan includes monthly hosted AI credits per active user; the pricing page has the details. To build this pipeline with your own deals, start your trial: 14 days of Pro with no credit card.
Moving in from a spreadsheet. Create the lists and fields first. Import related records before the records that link to them, for example organizations and contacts before deals. The file wizard accepts XLSX, XLS and CSV, with preview and mapping before import. Check a small sample of relationships after import; the record import guide explains the supported flow.
FAQ
What are the stages of a sales pipeline?
The common seven are Prospecting, Qualification, Demo or discovery, Proposal, Negotiation, Won and Lost. Shorter versions merge the first two into one stage, or drop Demo for services sold through a discovery call. What matters more than the count is that each stage has an entry condition someone else could check.
How do I build a sales pipeline from scratch?
Write down what happened in your last ten won and lost deals, turn the recurring steps into stages, and give each stage one observable entry condition. Then enter every open deal at the stage it has truly reached, give each a next step and an owner, and review it weekly. A CRM helps once more than one person shares deals.
What does pipeline coverage mean in sales?
Coverage is the value of open deals that can still close this period, divided by the revenue you still need. A 3x coverage means €300,000 of open deals for a €100,000 gap. The target depends on your win rate by value: at 25% you need about 4x, at 40% about 2.5x.
What is the purpose of a sales pipeline?
It tells you which deals need attention this week and whether you have enough deals to hit your target. Without it, follow-ups depend on memory and the revenue outlook depends on optimism. What to write when a deal stalls is in the sales follow-up email templates.
Which CRM is best for managing a sales pipeline?
It depends on how you sell. Teams with several distinct sales processes need multiple pipelines; teams whose deals are decided in email and LinkedIn threads need those conversations on the deal; phone-heavy teams need a dialer. Our guide to sales CRMs compares options by sales motion. Customermates publishes both guides.
What is the difference between a sales pipeline and a sales funnel?
The pipeline lists named deals and where each stands today. The funnel measures how many leads convert from stage to stage over time. You work the pipeline every day and read the funnel once a month to see where deals drop out.
Competitor details checked on 8 October 2026 against HubSpot's pipeline setup guide and Pipedrive's multiple pipelines article.
Start from one description
One description. A workspace your agent built.
This is what setup builds from one sentence. Sample data, the real product.
Describe your business
One sentence about your team, your clients and how you sell.
Mate builds it
It asks a few questions, then creates the lists, pipeline, dashboard and playbook.
Work in it
Connect LinkedIn and email. Click through a finished example below.
We're a four-person strategy consultancy. Track clients, engagements and proposals, and help us follow up with prospects on LinkedIn.
Widgets built from the workspace's own lists and fields
Every client conversation from email, LinkedIn and WhatsApp in one place. Mate sets up your workspace and drafts the follow-up, you review and send. Works with Claude, ChatGPT or any agent that speaks MCP.
Related pages
Sales Plan Template: A Filled 90-Day Plan and Excel + CSV
Download an editable sales plan template with a filled three-person service-team example, target-to-activity math, capacity checks, owners and review dates.
Sales Pipeline
Sales pipeline software for small relationship-led teams: opportunities by stage with probability, value and weighted value, with customer context close by.
Sales CRM: What to Look For and Which One Fits
A sales CRM keeps every deal, contact and next step in one pipeline. What to check in a demo, which CRM fits which sales motion, and what five seats cost.
Lead Qualification: Frameworks, Questions and CRM Fields
Lead qualification explained: the criteria behind BANT, CHAMP and MEDDIC, which framework fits your sale, what to ask and how to record the answers.
Customermates
Follow up on every client conversation
Start with one channel and one client on Customermates Cloud, or self-host the open-source core.
✓ No credit card required ✓ First 14 days free





