How to Build a Sales Pipeline That Actually Moves: Stages, Follow-Ups and Numbers
A pipeline is not a list of names. It is a set of stages with rules for moving between them. Here is how to set one up for a small business, and the numbers that tell you it is working.
Published 2026-09-21 · 4 min read
Most small businesses have a list of potential customers. Far fewer have a pipeline. The difference is movement: a pipeline shows where each opportunity stands, what happens next, and which ones are stuck.
This guide walks through building one from scratch, whether you sell services, products to other businesses, or high-value items to the public.
Stages: keep them few and clear
Every pipeline is a series of stages. The most common mistake is having too many. Five or six is plenty for a small business:
| Stage | What it means | Exit rule |
|---|---|---|
| New lead | They have shown interest | You have spoken to them |
| Qualified | They have a need, budget and timeframe | You have sent a proposal or quote |
| Proposal sent | They are reviewing your offer | They reply yes, no or want changes |
| Negotiation | Details, price or terms under discussion | Agreement or a clear no |
| Won | They have committed | Invoice sent |
| Lost | Not going ahead | Reason recorded |
The exit rule is what makes stages useful. A lead only moves forward when that rule is met. Without rules, stages turn into guesses.
Qualify early — it saves weeks
Not every lead deserves a proposal. Before moving someone to *Qualified*, check three things: do they have a real need you can solve, can they afford it, and do they intend to act within a reasonable time? A quick, honest qualification call saves you writing proposals for people who were never going to buy.
Give every open deal a next step
Every opportunity that is not won or lost should have two things recorded: the next action ("send revised quote") and its date. Each morning, work through the actions due today. This is the heartbeat of a pipeline; without it, deals simply stop.
A useful rule: if a deal has had no activity for three weeks, either take an action or move it to *Lost* with a reason. A pipeline full of ghosts gives a false sense of security.
Record why you lose
When a deal is lost, write down why in a few words: *price*, *timing*, *went with competitor*, *no response*. After twenty or thirty lost deals, patterns appear. If most are lost on price, your offer or your targeting needs work. If most go silent after the proposal, your follow-up needs work.
The four numbers that matter
Review these once a month:
- Number of new leads. Is the top of the funnel growing?
- Conversion rate. Won deals divided by all closed deals (won plus lost).
- Average deal value. Total won value divided by the number of won deals.
- Sales cycle length. Average days from new lead to won.
Together they let you forecast. If you win 25% of closed deals at an average of $2,000 and need $10,000 a month, you need about 20 qualified deals closing each month.
Keep it visual
Pipelines are easier to manage when you can see them. A simple board with one column per stage, or a chart of deal value by stage, shows at a glance where work is piling up. If *Proposal sent* is crowded and *Negotiation* is empty, your proposals need attention.
Choosing where to run it
For a few deals a month, a spreadsheet with the columns above is enough. As volume grows, a proper view of stages and follow-ups saves time. Subscription CRMs do this well, but many small businesses pay for far more features than they use.
Our Lead Management CRM Dashboard is a ready-made file that runs in your browser. It includes the stages above, next actions with dates, win and loss reasons, and pipeline charts, with your data kept on your own computer. It is a one-off purchase with no monthly fee.
*Disclosure: ReadyDashboards is made by the same small team that writes Worksmarter. We only point to it where it genuinely fits the job — the system in this article works with any tool, including a notebook.*
A worked example
A small design studio reviews its pipeline at the end of the month. It closed 16 deals: 5 won and 11 lost. The won deals total $12,500.
- Conversion rate: 5 won ÷ 16 closed = 31%
- Average deal value: $12,500 ÷ 5 = $2,500
- Average sales cycle: 24 days
The loss reasons show 7 of the 11 lost deals went silent after receiving a proposal. That points to a follow-up problem, not a pricing problem. The studio adds a rule: every proposal gets a call three working days after it is sent. The next month, conversion rises, with no change to prices.
Frequently asked questions
How many stages should a sales pipeline have? For most small businesses, five or six. Fewer and you lose detail; more and people argue about which stage a deal belongs in instead of moving it forward.
What is a good conversion rate? It varies widely by industry and deal size. The useful comparison is your own rate month to month. Improvements to qualification and follow-up usually show up there first.
When should I mark a deal as lost? When the customer says no, or when there has been no response after several follow-ups over a few weeks. Moving stale deals to lost keeps your forecast honest.
The short version
Use five or six stages with clear exit rules. Qualify before you quote. Give every open deal a next action and a date. Record why you lose. Review leads, conversion, deal value and cycle length monthly. Do these and your pipeline will move, whatever tool you choose.
Related reading: Free CRM tools that work offline · Spreadsheet or software? · More business templates on our Etsy shop