How to Build a Sales Pipeline in Your CRM
A step-by-step guide to setting up CRM deal stages with clear exit criteria, required fields and the 5 reports that keep your sales pipeline honest.
To build a sales pipeline in your CRM, turn the 5 to 7 steps your buyers actually take into stages, and give each stage an exit criterion based on something the buyer did. Require key fields like deal value and close date, set a probability per stage and review stalled deals and stage conversion reports every week.
Photo: Unsplash
On this page
- What a sales pipeline is (and isn’t)
- Step 1: Map how your buyers actually buy
- Step 2: Define stages with exit criteria
- Step 3: Set up the pipeline in your CRM
- Step 4: Decide which fields every deal needs
- Step 5: Build the 5 reports that keep it accurate
- Step 6: Run a weekly pipeline review
- Where to start this week
- Conclusion
- Sources
Most CRM pipelines start out tidy and turn into fiction within a few months. Deals sit in “Proposal” for 200 days. Half the close dates are in the past. The forecast says you’ll have a record quarter, and then you don’t.
The problem usually isn’t the CRM. It’s that the stages were never defined well enough for 2 people to agree on where a deal belongs. Fix that, and the pipeline becomes a tool you can actually run the business on.
This guide walks you through building a sales pipeline from scratch: how to define stages, write exit criteria, choose required fields and set up the reports that keep it accurate.
What a sales pipeline is (and isn’t)
A sales pipeline is a visual view of every open deal, organized by where each one sits in your sales process. In a CRM, it usually appears as columns (stages) with deal cards you move from left to right.
It does 3 jobs:
- Shows what to do next. Every deal in a stage has an obvious next action.
- Forecasts revenue. Deal values and stage probabilities add up to an expected number.
- Reveals where deals get stuck. Conversion between stages shows your weakest step.
A pipeline is not the same as a sales funnel. A funnel describes how buyers move from awareness to purchase, mostly from the marketing side. A pipeline tracks specific deals your team is actively working. If you’re new to CRMs in general, start with our guide on what a CRM is.
Step 1: Map how your buyers actually buy
Before touching the CRM, grab your last 10 to 20 won deals and write down what happened in each, in order. Who reached out first? When did you send pricing? Was there a site visit, a demo or a trial? Who signed?
You’ll usually see 5 to 7 milestones that repeat. Those are your stages. Base them on what the buyer does, not on what your team does internally. “We sent a proposal” tells you about your activity. “The buyer reviewed the proposal with the decision-maker” tells you about the deal.
If you sell very different things (for example, one-off installs and annual service contracts), you may need separate pipelines. Otherwise, keep one.
Step 2: Define stages with exit criteria
This is the step most teams skip, and it’s the one that matters most. Each stage needs an exit criterion: a specific, checkable event that must happen before a deal moves forward.
Here is a sample pipeline for a small B2B or high-ticket service business. Adjust the names and criteria to fit how you sell.
| Stage | What it means | Exit criterion (must be true to move on) | Sample probability |
|---|---|---|---|
| New lead | Inquiry received, not yet contacted | First conversation completed | 5% |
| Qualified | Real need, budget range and timeline confirmed | Buyer agreed to a needs call, demo or site visit | 15% |
| Needs assessed | You understand the problem and who decides | Decision-maker identified and scope agreed | 30% |
| Proposal sent | Pricing and scope delivered | Buyer reviewed proposal and gave feedback | 50% |
| Negotiation | Terms, timing or price being discussed | Verbal yes or agreed final terms | 75% |
| Closed won | Signed or paid | Contract signed or deposit received | 100% |
| Closed lost | Buyer chose not to proceed | Loss reason recorded | 0% |
The probabilities above are placeholders, not benchmarks. Once you have a few months of data, replace them with your own historical rates: of all deals that reached a stage, what share eventually closed?
Key takeaway: If a deal can move to the next stage without the buyer doing anything, your exit criterion is too weak. Good criteria describe a buyer action you could prove in a CRM note.
Step 3: Set up the pipeline in your CRM
The steps are similar across tools. In HubSpot, for example, you edit deal stages in the pipeline settings, set a deal probability for each stage and keep both a won and a lost stage so reports handle closed deals correctly. Salesforce works the same way in principle: each opportunity stage has a default probability, and expected revenue is calculated from the deal amount and that probability.
A practical setup checklist:
- Create or rename stages to match your table from Step 2.
- Add the exit criteria to each stage’s description, or pin them in a shared doc your team can see.
- Set stage probabilities. Start with estimates and update quarterly from real data.
- Make key fields required at specific stages. For example, require deal amount and close date before “Proposal sent,” and a loss reason before “Closed lost.” Many CRMs let you require properties when a deal enters a stage.
- Create a loss reason list. Use a dropdown (price, timing, chose competitor, no decision, not a fit) rather than free text so you can report on it.
- Automate the busywork. Create a follow-up task when a deal enters a stage, or alert the owner when a deal hasn’t moved in a set number of days. See what marketing automation can do for more ideas.
- Set permissions. Decide who can edit stages and probabilities. Usually just 1 admin.
If you’re still choosing a system, our guides on how to choose a CRM and HubSpot vs Salesforce cover pipeline features worth comparing.
Step 4: Decide which fields every deal needs
Too many required fields and your team stops updating the CRM. Too few and your reports are useless. These 6 cover most small teams:
- Deal amount: your best estimate of the contract value.
- Expected close date: a real date, updated when it slips.
- Deal owner: 1 person accountable.
- Next step and date: what happens next and when.
- Lead source: where the deal came from, so you can judge marketing channels.
- Loss reason: required only when closing a deal as lost.
A “next step” field is the single best habit for pipeline accuracy. A deal with no next step on the calendar isn’t really active.
Step 5: Build the 5 reports that keep it accurate
Reports turn the pipeline from a to-do list into a management tool. Set up these 5 and review them weekly.
| Report | What it shows | What to do with it |
|---|---|---|
| Weighted pipeline | Sum of deal amount multiplied by stage probability | Compare against your revenue target for the period |
| Stage conversion rates | Share of deals moving from each stage to the next | Fix the stage with the biggest drop-off first |
| Stalled deals | Deals with no stage change or activity in X days | Update, push forward or close as lost |
| Past-due close dates | Open deals whose close date has passed | Re-date with the buyer or close them out |
| Win/loss by reason and source | Why you win and lose, and which channels bring winners | Adjust pricing, targeting and marketing spend |
A quick note on coverage. If your win rate from “Qualified” is around 25%, you need roughly 4 times your target in qualified pipeline to hit it. That’s simple math: target divided by win rate. Use your own win rate rather than a generic rule.
If you want these numbers on 1 screen, see our guide to building a business dashboard.
Step 6: Run a weekly pipeline review
A 30-minute weekly review keeps data clean and deals moving. Use the same agenda each time:
- Stalled deals first. For each, decide: next step booked, or close as lost.
- Past-due close dates. Update every one.
- Deals moving stages this week. Confirm the exit criterion was really met.
- Biggest deals. What could block them, and who’s helping?
- Forecast check. Does the weighted pipeline still support your target?
Closing dead deals is healthy. A smaller, honest pipeline beats a large, imaginary one, because forecasts and staffing decisions depend on it.
Common pipeline mistakes
- Too many stages. If 2 stages always happen together, merge them.
- Activity-based stages. “Called twice” is an activity, not a stage.
- No closed lost discipline. Deals that never close should be marked lost with a reason, not left open forever.
- Optimistic probabilities. Without real data, people round up. Recalculate from history every quarter.
- One pipeline for everything. Renewals, new business and partner deals often move differently. Separate them if the stages genuinely differ.
Where to start this week
- Pull your last 10 to 20 won deals and list the milestones.
- Draft 5 to 7 stages with exit criteria in a shared doc.
- Get your team to agree on the definitions before you change the CRM.
- Update the CRM stages, required fields and loss reasons.
- Clean up existing deals: re-stage, re-date or close.
- Book a recurring 30-minute pipeline review.
Pricing for pipeline features varies by CRM plan, and extra pipelines or custom reports are often limited to paid tiers. Our CRM cost guide explains the pricing models.
Conclusion
A useful sales pipeline comes down to definitions. Build stages around what buyers do, attach a clear exit criterion to each, require only the fields you’ll actually use and review the same 5 reports every week. Do that, and your CRM stops being a guessing game and starts telling you which deals to chase, which to drop and how much revenue is really coming.
Sources
- HubSpot Knowledge Base: Set up and customize pipelines — deal stages, deal probability and won/lost stage requirements
- Salesforce Help: Opportunity fields — stage probability and expected revenue definitions
- Salesforce Trailhead: Create and manage stages and sales processes — default stage probabilities and sales processes
Frequently asked questions
What are the stages of a sales pipeline?
Most sales pipelines have 5 to 7 stages, such as new lead, qualified, needs assessed, proposal sent, negotiation, closed won and closed lost. The right stages depend on how your buyers actually buy. Map them from your recent won deals, and give each stage a clear exit criterion based on something the buyer did, like agreeing to a demo or reviewing a proposal.
How do I set up a sales pipeline in a CRM?
Define your stages and exit criteria first, then open your CRM's pipeline settings to rename or add stages, set a probability for each and require key fields like deal amount and close date. Add a loss reason dropdown, create tasks or alerts for stalled deals and set up weekly reports on conversion rates, stalled deals and weighted pipeline value.
What are exit criteria in a sales pipeline?
Exit criteria are specific, verifiable conditions a deal must meet before it moves to the next stage. Good exit criteria describe a buyer action, such as "decision-maker identified" or "buyer reviewed the proposal." They stop reps from moving deals forward on optimism and make your stage counts and forecasts far more reliable across the team.
How many stages should a sales pipeline have?
Most small businesses do well with 5 to 7 stages, including closed won and closed lost. Fewer than that and you can't see where deals stall. More than that and reps struggle to tell stages apart, so data gets messy. If 2 stages always happen at the same time, merge them into one.
What is a weighted sales pipeline?
A weighted pipeline multiplies each deal's value by the probability of its current stage, then adds the results. A $10,000 deal in a 50% stage counts as $5,000. Salesforce calls this expected revenue. It gives a more realistic forecast than simply totaling all open deals, especially once your stage probabilities come from your own historical data.
How often should I review my sales pipeline?
Review it weekly. A short, consistent meeting covering stalled deals, past-due close dates, deals that changed stages and your forecast keeps data accurate and deals moving. Recalculate stage probabilities and conversion rates quarterly, using your own closed deals, so your forecast reflects how your team actually performs rather than guesses.
Can I build a sales pipeline in a free CRM?
Yes, most free CRM plans include at least one deal pipeline with customizable stages. Limits usually apply to the number of pipelines, required fields, automation and advanced reporting. Check the specific plan, because features like multiple pipelines, custom reports and stage-based automations are often reserved for paid tiers.
Was this guide useful
No reviews yet. Share your experience and help other readers.