CRM Basics

How to Set Up a Sales Pipeline

How to define sales pipeline stages that match how your business really sells, with exit criteria, a worked illustration and common mistakes to avoid.

On this page
  1. What a pipeline is
  2. Start from how you actually sell
  3. Define each stage clearly
  4. An illustrative example
  5. Add values and probabilities carefully
  6. Keep the pipeline honest
  7. Measuring from the pipeline
  8. Common mistakes
  9. Review and adjust

What a pipeline is

A sales pipeline is a visual or tabular way to show where each potential sale currently stands. Each opportunity sits in one stage, and moves along as the relationship progresses. Done well, it answers three questions quickly: what is in progress, what is stuck, and what needs doing next.

It is related to, but not the same as, a marketing funnel. The funnel describes how people move from awareness to purchase in general terms; a pipeline tracks named deals with a value and an owner. The work of aligning the two is covered in the discussion of sales and marketing alignment.

Start from how you actually sell

The most common mistake is copying a template with stages that look professional but do not match your process. Begin instead by describing, in plain words, what really happens between a stranger and a paying customer.

Ask the people who sell:

  • How do new enquiries arrive?
  • What do you do first, and what happens after that?
  • What does the customer need to see or decide before buying?
  • At what point do you send a quote or proposal?
  • Where do deals most often go quiet or get lost?

Write the answer as a sequence of steps. Then group steps into stages. Most small businesses end up with between four and seven; fewer can be too vague, and more tend to be abandoned.

Define each stage clearly

A stage name alone is not enough. For each one, write down:

  • What it means: a short description in everyday words.
  • Entry rule: what must be true for a deal to arrive here.
  • Exit rule: what must happen before it moves on.
  • Next action: the usual task for the owner while a deal sits in this stage.

Exit rules matter most. A rule like “customer has confirmed budget and decision timeline in writing” is far less open to interpretation than “seems interested”. Without them, two people will place the same deal in different stages, and the pipeline loses meaning.

An illustrative example

The stages below suit a fictional small web design studio. They are an illustration, not a recommendation.

Stage Exit rule
New enquiry A first reply has been sent
Discovery call The call is held and needs are noted
Proposal sent A written quote has gone to the customer
Negotiation The customer has replied with questions or changes
Won The customer has accepted and paid a deposit
Lost The customer declined or stopped responding after set follow-ups

Notice that Won and Lost are both included. Recording why deals are lost, using a short reason field with a fixed list of options, is one of the most useful things a pipeline can teach you.

Add values and probabilities carefully

Many tools let you assign each deal a value and a likelihood of closing, then add them up into a forecast. Handle this with caution. Suppose, purely as an illustration, you have 10 proposals out in the field and historically 4 of them have been accepted. Your observed proposal-to-win rate is 4 / 10 = 40 percent. Applying 40 percent to a new set of proposals worth 1,000 each gives an expected 10 x 1,000 x 0.4 = 4,000.

That figure is a rough guide. With small numbers, the rate can swing widely from one period to the next, and it should never be treated as a promise of sales. Use your own records, and recheck them as more deals complete.

Keep the pipeline honest

A pipeline is only useful if people update it. Some habits help.

  • Give every open deal an owner and a next step with a date. A deal without a next action is a candidate for review.
  • Set a staleness rule. For example, if a deal has not changed stage or had contact for a defined number of days, flag it. Choose the number based on your typical sales cycle.
  • Hold a short regular review. Fifteen minutes each week to walk through the board is often enough.
  • Close out dead deals. Leaving them open inflates the pipeline and hides real priorities.
  • Move on rules, not hopes. Resist moving a deal forward because it feels positive.

Measuring from the pipeline

Once stages are well defined, you can look at how many deals move from one stage to the next and where they drop out. This resembles the analysis in finding where your funnel leaks, but with named deals. A few simple measures:

  • the number of deals entering each stage per month;
  • the share that progress to the next stage;
  • the average time spent in each stage;
  • the most common reasons for losing.

Treat early numbers with care. A handful of deals is too few to draw firm conclusions.

Common mistakes

  • Too many stages, so nobody keeps them current.
  • Stages named after internal tasks rather than customer progress.
  • No exit criteria, so the same situation is classified differently by different people.
  • Mixing very different offers, such as small repeat orders and large custom projects, in one pipeline. Consider separate pipelines if the processes differ.
  • Treating the forecast as certain.

Review and adjust

Your first version will be imperfect. After a month or two, check where deals stall or where stage definitions caused disagreement, and adjust. Keep changes few and documented, so that past data remains comparable. Remember that records often include personal details, so keep access limited and follow the privacy rules that apply to you, which vary by country and are not covered here as legal advice.

The complete guide to crm basics

What a CRM Is and Does a Small Business Need One
Read the guide

Keep exploring

Guides from other topics

All topics →