How to Create a Sales Pipeline for Your SMB 

What is a Sales Pipeline

Imagine you have 30 deals in progress. Without a system, how do you know which ones are close to closing, which need attention, and which are practically dead? The answer is a sales pipeline.

A pipeline is the visual representation of your sales process: all deals in progress, organized by stage, from first contact to close. It's like a map showing you exactly where every opportunity is and what's needed to get it across the finish line.

Without a Pipeline vs With a Pipeline

Without a pipeline:

• "How many opportunities do we have?" "Not sure, maybe 20... 30?"
• "How much will we close this quarter?" "Hard to say..."
• "Why did we lose that deal?" "I don't really remember..."

With a well-structured pipeline:

• Complete visibility on all opportunities in real time
• Accurate forecasts based on data, not gut feelings
• Immediate identification of bottlenecks
• Strategic decisions based on concrete numbers

How to Design Your Pipeline

Step 1: Map Your Current Process

Before creating the pipeline, stop and document how your sales process works today. Answer these questions:

• How do leads come in? (website, referrals, trade shows, cold calling...)
• What steps do you take from first contact to sale? (intro call, needs analysis, proposal, negotiation...)
• How long does each step typically take?
• Where do deals most often get stuck?
• Who's involved at each stage?

Step 2: Define the Stages

Stages represent the phases of your process. There's no universal pipeline; it depends on your business. But here's a structure that works for most SMBs:

Step 3: Define Stage Criteria

For each stage, establish clear rules for advancement. Without criteria, salespeople move deals based on gut feeling, and the pipeline becomes unreliable.

Step 4: Assign Probabilities

Each stage has a different close probability. These percentages are used to calculate the weighted pipeline value, i.e., how much revenue you can realistically expect.

Typical probabilities by stage (for an SMB):

• Qualified Lead: 10%
• First Contact: 20%
• Needs Analysis: 40%
• Proposal Sent: 60%
• Negotiation: 80%

Pipeline Management Best Practices

1. Update Daily

The pipeline is only useful if it's current. Spend 5 minutes every morning to:

• Move deals that have advanced
• Update notes with the latest information
• Close lost deals (don't leave them there polluting your data)

2. Kill Zombie Deals

A deal stuck for 2 months with no response isn't "in negotiation"; it's dead. Don't keep zombie deals in the pipeline to make numbers look better. Be honest: move them to "lost" or back to an earlier stage.

3. Track Loss Reasons

When you lose a deal, always record why:

• Price too high
• Competitor chosen
• Project postponed
• Budget unavailable
• No response / ghosted

This data is gold: after a few months, you'll see clear patterns. If 40% of losses are due to price, maybe you need to revisit your positioning. If 30% go to a specific competitor, study their offer.

4. Monitor Key Metrics

Stage conversion rate: how many deals move from one stage to the next? If the conversion from "Proposal" to "Negotiation" is only 20%, there's a problem with your proposals. Average time per stage: how long does a deal stay in each phase? If deals stay too long in "Analysis," maybe the process is too slow. Average deal value: what's the average opportunity value? Is it growing or shrinking? Pipeline velocity: how long from lead to close? Shortening this means more revenue.

5. Weekly Team Reviews

Every week, do a 30-minute review with the team:

• Which deals advanced?
• Which are stuck and why?
• What concrete actions are needed this week?
• Are there deals at risk?

Common Mistakes to Avoid

1. Too Many Stages

5-7 stages are enough. More creates confusion and salespeople won't know where to put deals. If you have 10+ stages, you're probably confusing activities with progress.

2. Activity-Based Stages

"Email sent" isn't a stage; it's an activity. "Interest confirmed after call" is a stage. The difference: the stage describes where the deal is in the process, not what you did.

3. No Cleanup

A pipeline with 200 deals of which 150 have been stuck for months is useless. Spend 15 minutes a week on cleanup: close dead deals, update live ones.

4. Focus Only on Volume

100 low-quality deals are worth less than 10 qualified ones. Don't celebrate the number of deals in your pipeline. Celebrate the weighted value and conversion rate.

Calculating Pipeline Value

Basic Formula

Weighted Value = Sum of (Deal Value x Stage Probability)

Example with 3 deals:

• Deal A: $10,000 in "Proposal Sent" (60%) = $6,000
• Deal B: $5,000 in "Negotiation" (80%) = $4,000
• Deal C: $8,000 in "Needs Analysis" (40%) = $3,200

Total weighted value: $13,200

This is the revenue you can realistically expect from these deals.

Monthly Forecast

To predict next month's revenue:

1. Filter deals with expected close date in the month
2. Calculate weighted value
3. Apply a correction factor based on history (if you historically close 70% of what you predict, multiply by 0.7)

Implementing the Pipeline with Ingegno

Ingegno offers a drag-and-drop Kanban pipeline designed for SMBs:

Expected Results

SMBs that implement a structured pipeline with Ingegno see concrete results:

Get Started Now

Ready to structure your pipeline? With Ingegno you can create it in minutes and get immediate visibility on your opportunities. Try free for 14 days.