How to Build a Sales Pipeline: A Step-by-Step Guide

To build a sales pipeline, define the stages a deal moves through from first contact to closed-won, write clear exit criteria for each stage, then load your real opportunities into a CRM or spreadsheet and move them forward as those criteria are met. The fastest way to get the stages right is to map them to how your customers actually buy, not to a generic template.

The part most guides skip is the math. A pipeline is not just a place to park deals; it is a forecasting tool. Once you know your average deal size, win rate, and sales cycle, you can work backward from your revenue target to figure out exactly how many qualified opportunities you need at the top. The seven steps below walk through both halves: building the structure, and sizing it so it can actually hit your number.

What is a sales pipeline (and how is it different from a funnel)?

A sales pipeline is a visual, stage-by-stage map of where every active deal sits in your sales process. Each stage represents a concrete step toward a purchase, and each deal occupies exactly one stage at a time. The pipeline answers a seller's most pressing question: what is the next action that moves this deal forward?

People mix up three related terms, so it helps to separate them:

• Sales pipeline: the seller's view of open deals and the activities needed to advance them. It tracks what your team does.
• Sales funnel: the buyer's view, showing how many people drop off at each stage of awareness, consideration, and decision. It tracks conversion volume narrowing over time.
• Sales process: the repeatable playbook of actions a rep performs to win a deal. Your pipeline stages should be the visible mirror of this process.

What do you need before you build one?

Gather a few inputs first so your pipeline reflects reality instead of guesswork. Spending an hour here saves weeks of rework later.

• A defined ideal customer profile (ICP) and buyer personas, so you know who belongs in the pipeline.
• A list of real prospects or open deals to populate it with on day one.
• Your sales process written out, even roughly, as a sequence of steps.
• Your revenue target for the quarter or year, plus three numbers if you have history: average deal size, win rate, and average sales cycle length.
• A home for the pipeline: a spreadsheet works under about 10 active deals; a CRM is worth it beyond that or with more than one rep.

How do you build a sales pipeline step by step?

Here is the full sequence, from a blank page to a pipeline you can forecast against.

1. Map your buyer's journey. Talk to recent winners and your reps: what actually happened between first touch and signature? Those real moments (a discovery call, a demo, a security review, a procurement step) become your candidate stages.
2. Define your stages. Aim for five to seven. Common stages are Prospecting, Qualified, Discovery, Proposal/Quote, Negotiation, and Closed Won/Lost. Fewer than five and you lose visibility; more than seven and reps spend more time updating than selling.
3. Write exit criteria for each stage. This is the single biggest upgrade over a generic pipeline. For each stage, define the objective event that must be true to advance, for example: 'budget confirmed and a decision-maker is engaged' before a deal can leave Qualified.
4. Assign the activity that completes each stage. Pair every stage with the rep action that earns the move forward, such as a discovery call, a sent proposal, or a signed order form. The pipeline then doubles as a to-do list.
5. Size the pipeline against your target (the math is in the next section). Decide how many qualified opportunities you need and whether you currently have enough coverage.
6. Load your deals and set a single source of truth. Put every open opportunity in, assign a stage, a value, and an expected close date, and agree that the CRM, not memory, is the truth.
7. Establish a review and cleanup cadence. Schedule a weekly pipeline review and a rule for stalled deals so the pipeline stays accurate rather than slowly filling with dead weight.

How many deals do you actually need in your pipeline?

This is the question competitors gloss over, and it is the whole point of a pipeline. You reverse-engineer it from your revenue target. Work through it in plain arithmetic:

• Start with the target. Say you need $300,000 in new revenue this quarter.
• Divide by average deal size. If deals average $10,000, you need 30 closed-won deals.
• Divide by win rate. If you close 25% of qualified opportunities, you need 30 / 0.25 = 120 qualified opportunities entering the pipeline.
• Apply a coverage ratio. Because not every open deal closes in-quarter, sales leaders commonly carry roughly 3x to 4x their target in open pipeline value. For a $300k target, that means keeping $900k to $1.2M of qualified opportunity open at any time.
• Work back to activity. If 1 in 4 prospects you contact becomes qualified, those 120 qualified opps require around 480 quality prospect touches. That is your weekly outreach math.

What are good exit criteria for each stage?

Vague stages are why two reps put the same deal in different places. Replace fuzzy labels with a binary test: either the criterion is met or the deal stays put. Examples you can adapt:

• Leaves Prospecting when: the prospect has responded and agreed to a first conversation.
• Leaves Qualified when: need, budget, authority, and timeline are confirmed (the classic BANT check, or your own equivalent).
• Leaves Discovery when: you have documented the buyer's specific pain and success metrics and confirmed you can address them.
• Leaves Proposal when: a formal quote has been sent and the buyer has acknowledged it.
• Leaves Negotiation when: terms and price are verbally agreed and only signature remains.
• Always mark Closed Lost with a reason code (price, timing, competitor, no decision) so you can learn from the pattern.

How do you measure a healthy sales pipeline?

A pipeline that looks full can still be sick. Track a handful of metrics so you catch problems before they hit the forecast. Most CRMs calculate these automatically once your stages and dates are clean.

• Pipeline coverage: total open pipeline value divided by your target. Below ~3x is a warning sign you need more top-of-funnel.
• Stage conversion rates: the percentage of deals that advance from each stage to the next. A sharp drop pinpoints exactly where deals die.
• Sales velocity: how fast revenue moves through, calculated as (number of opportunities x win rate x average deal value) / sales cycle length. Improving any single input speeds the whole system.
• Average deal age and stage age: deals sitting far longer than your typical cycle are usually stalled, not progressing. Flag them.
• Win rate trend: tracked over time, it tells you whether qualification is getting sharper or sloppier.

Which tools should you build it in?

Match the tool to your stage of growth. A spreadsheet is free and fine when you are managing a handful of deals and want to think through your stages before committing. The moment you have multiple reps, more than roughly 10 active deals, or you want reliable forecasting, a CRM pays for itself by killing manual updates and surfacing the metrics above automatically.

Modern CRMs increasingly fold in the surrounding work too: capturing inbound leads, booking meetings, and following up across email and SMS without a rep lifting a finger. MapleConnect, for example, is an all-in-one CRM that pairs the pipeline with AI chat, online booking, and automated follow-up, so qualified opportunities reach the right stage instead of leaking between disconnected tools. Whatever you choose, the rule holds: the CRM is the single source of truth, and a deal that is not in it does not exist.

Common mistakes that quietly break a pipeline

• Stages named after time ('this week') instead of buyer actions, so nobody knows what advances a deal.
• Treating the pipeline as a storage closet for dead leads, which inflates coverage and ruins the forecast.
• Skipping the math and hoping volume works out, then missing quota with a 'full-looking' pipeline.
• No weekly hygiene, so close dates drift and the forecast becomes fiction.
• Copying a competitor's stages instead of mapping your own buyer's journey.