CRM, Sales Pipeline and Metrics: Weighted Forecast and Pipeline Velocity

A rep with ten deals can keep them in their head. With fifty, follow-ups slip, nobody knows what next month will bring and nobody knows at which stage deals are lost. A CRM and sales metrics turn selling into a process you can manage and improve.

1. Set up the CRM
2. Define the stages
3. Build the forecast
4. Track the metrics
5. Review weekly

The CRM

A CRM (customer relationship management system) keeps your contacts, companies, deals, activities and communications in one place. There are options with free or low-cost starter plans (HubSpot, Pipedrive, Zoho CRM and others) and platforms built for large teams (such as Salesforce or Microsoft Dynamics 365). At first, a well-organized spreadsheet works; once you have more than 20 or 30 active deals or work on a team, a CRM will save you a lot of time.

The minimum you should record

• Contact and company, with title, phone, email and source (where the lead came from).
• Deal: what they might buy, estimated value, stage and expected close date.
• Activities: calls, meetings and emails, with short notes.
• Next step with a date (lesson 3): the golden rule.
• Loss reason when a deal is lost: price, competitor, no decision, no budget, timing…

Pipeline stages

Define stages with objective exit criteria (what must have happened to move forward), not the rep's gut feeling:

1. Default probability: 10%QualifiedFits the ideal customer profile and accepted a meeting.
2. Default probability: 25%Discovery doneNeed confirmed, economic buyer identified.
3. Default probability: 50%ProposalProposal presented to the decision-maker.
4. Default probability: 75%NegotiationThe customer chose your solution; terms are being negotiated.
5. 100% / 0%Won / LostSigned, or a final no.

Those default probabilities should be replaced with your own history: the share of deals that reached each stage and ended up won.

How to calculate your real probabilities

Take the deals closed (won or lost) in the past year and count how many reached each stage. Here's one rep's historical funnel, with illustrative data:

The real probability for each stage is deals won ÷ deals that reached that stage: qualified 15 ÷ 100 = 15%; discovery 15 ÷ 60 = 25%; proposal 15 ÷ 35 ≈ 43%; negotiation 15 ÷ 20 = 75%. This rep should use 43% at the proposal stage, not the default 50%; otherwise the forecast will come in high month after month. The template's Stages sheet does this calculation for you.

The weighted sales forecast

Multiply each deal's value by its stage probability and add them up:

The pipeline "adds up" to $308,000, but the reasonable expectation is about $95,000. For a monthly forecast, use only the deals with an expected close date in that month. In the template's Pipeline sheet, the eight sample deals add up to $49,200 of open pipeline but only $17,640 weighted, and $13,800 of that is expected in November 2026. Also check your pipeline coverage: how many times your quota you have in deals expected to close in the period.

Coverage needed ≈ 1 ÷ win rate (by value)

30% win rate → 1 ÷ 0.30 ≈ 3.3 times your quota
$120,000 quarterly quota at a 25% win rate → 120,000 ÷ 0.25 = $480,000 in pipeline

The exact multiple depends on your win rate: if you close half of what you propose, you need twice your quota; if you close one in five, five times. If you're short on coverage halfway through the quarter, no closing technique will make up for it: you need more prospecting.

Key sales metrics

Pipeline velocity

It combines four levers into one number: how much money your pipeline generates per day.

Velocity = (open opportunities × win rate × average deal size) ÷ sales cycle in days

Example: 20 opportunities × 25% × $10,000 ÷ 45 days ≈ $1,111 a day
                                                     ≈ $33,300 a month

To sell more you have four options: more opportunities, a higher win rate, bigger deals or a shorter cycle. For example, raising the win rate from 25% to 30% with the same pipeline lifts velocity to about $40,000 a month.

Diagnose with your metrics

The weekly pipeline review

30 to 60 minutes a week, alone or with your manager:

1. Which deals moved forward, which were won and which were lost (and why)?
2. Which deals haven't moved in more than two weeks? What step unblocks them, or should they be closed as lost?
3. Does every deal have a dated next step?
4. Does this month's forecast reach the quota? If not, which deals can be accelerated and how much extra prospecting is needed?
5. Did I complete my planned activity?

Common CRM mistakes

Columns:
Company | Contact | Source | Deal value | Stage | Probability |
Weighted (=Value*Probability) | Created | Expected close |
Next step | Next step date | Status (Open/Won/Lost) | Loss reason

Useful formulas (Excel or Google Sheets):
Month forecast:   =SUMIFS(G:G,L:L,"Open",I:I,">="&DATE(2026,11,1),I:I,"<="&DATE(2026,11,30))
Win rate:         =COUNTIF(L:L,"Won")/(COUNTIF(L:L,"Won")+COUNTIF(L:L,"Lost"))
No next step:     =COUNTIFS(L:L,"Open",J:J,"")

Summary

• A CRM centralizes contacts, deals and activities, and it only works if it's kept up to date.
• Define stages with exit criteria and probabilities based on your own data.
• A weighted forecast gives a realistic expectation; the coverage you need is roughly 1 ÷ your win rate.
• Calculate your real stage probabilities from closed deals.
• Track stage conversion, win rate, deal size, sales cycle and pipeline velocity.
• Review the pipeline weekly and clear out stalled deals.

Next lesson: Your Sales Plan: Goals, Activity, Routine, Commissions and AI. You'll pull it all together: from your goal to weekly activity, your routine, commission plans and the use of AI in sales.