Skip to content
Tutorials Center
My learning

Topics

Lesson 15 of 36 ยท CRM Concepts

The CRM Sales Pipeline

Learn how a CRM sales pipeline works: stages and exit criteria, probabilities, weighted forecasts, win rate, sales cycle length, activities and the habits that keep pipeline data trustworthy.

The sales pipeline is the heart of a sales CRM. It shows every open opportunity, which stage it is in and what it is worth. Managers read it to forecast revenue; salespeople use it to decide what to do today; leadership uses its history to find where deals get stuck.

This lesson covers stages and exit criteria, probabilities and weighted forecasts, the key metrics and the data habits that make a pipeline believable. Real CRM products are not available on this site, so we model pipelines with Python.

Stages

A pipeline is a sequence of stages. A typical B2B example:

flowchart LR
  A["Qualified"] --> B["Discovery"]
  B --> C["Proposal"]
  C --> D["Negotiation"]
  D --> E["Closed won"]
  D --> F["Closed lost"]

Each stage has entry and exit criteria; deals end as won or lost.

Stage names matter less than exit criteria: objective evidence that a deal may advance. "Proposal" might require "budget confirmed, decision maker identified, proposal sent". Without criteria, stages become opinions and forecasts drift.

Each stage usually carries a probability of winning, based on historical conversion. These are starting values; mature teams recalculate them from their own data.

Opportunity fields

Common fields: name, account, owner, amount, stage, expected close date, source, next step, competitor, products (line items) and a loss reason once closed.

Weighted pipeline

The weighted pipeline multiplies each amount by its stage probability and sums the results. It is a statistical estimate, not a promise.

Python Weighted forecast

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Conversion rates and win rate

Funnel analysis asks how many deals move from one stage to the next, and how many end as wins.

Python Stage conversion and win rate

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

The weakest transition shows where to coach or fix the process.

Sales cycle length and velocity

Sales cycle length is the average time from creation to close. Sales velocity combines four numbers:

velocity = (number of opportunities x average deal size x win rate) / sales cycle length

Python Sales velocity

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Four levers of sales velocity

More deals Generate pipeline
Bigger deals Upsell, bundle
Higher win rate Qualify better
Shorter cycle Remove friction

Pick the cheapest lever first

1 / 2

Activities and next steps

A healthy deal always has a next step with a date. CRMs log activities (calls, emails, meetings) and tasks, and many surface stale deals: no activity for N days, or a close date in the past.

Python Finding stale deals

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Forecast categories

Besides weighted pipeline, managers use forecast categories: pipeline, best case, commit, closed. Each salesperson sorts deals into them and managers adjust by experience. A common rule: compare commit to actual over several quarters to learn how reliable each person's calls are.

Habits that keep data honest

  • Update the stage when reality changes, not on the last day of the month.
  • Use required fields at key stages (cannot enter "Proposal" without an amount).
  • Record loss reasons from a controlled list for later analysis.
  • Review the pipeline weekly in a short meeting based on the CRM, not on slides.
  • Clean stale deals regularly (close them as lost or move the date with a reason).

Linking to ERP

When a deal reaches closed won, the quote becomes a sales order in the ERP (see ERP vs CRM). Many companies automate this or at least block the order until the customer exists in both systems.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. What are exit criteria?

    Exit criteria keep stages objective and forecasts reliable.
  2. 2. A 10,000 deal at 50% probability contributes how much to weighted pipeline?

    10,000 x 0.5 = 5,000.
  3. 3. Which lowers sales velocity?

    Cycle length is in the denominator, so longer cycles reduce velocity.
  4. 4. A deal with a close date in the past is usually

    It signals neglected data or a stuck deal; update or close it.

Summary

  • A pipeline is a staged view of opportunities with amounts, owners and close dates.
  • Exit criteria and probabilities make forecasts consistent; weighted pipeline is an estimate.
  • Track stage conversion, win rate, cycle length and velocity.
  • Always keep a dated next step; clean stale deals; record loss reasons.

Next: Lead Management and Qualification