A weighted pipeline forecast estimates expected revenue by multiplying each opportunity amount by a probability and summing the results. CRM tools can display weighted values using deal-stage probabilities, but the formula becomes misleading when probabilities are inherited folklore, close dates are stale, currencies mix, or one giant deal dominates the total. This lesson treats the forecast as a transparent model, not a promise.

VISUAL LESSON

What you will learn

  1. 01Calculate weighted value deal by deal.
  2. 02Audit stage probabilities and forecast eligibility.
  3. 03Evaluate calibration, concentration, and error.
Sales opportunities with different amounts and stage probabilities combine into a weighted revenue forecast
Weighted pipeline is the sum of deal amount times probability; its credibility depends on cohort rules, calibration, and visible concentration risk.

ILLUSTRATIVE WORKED EXAMPLE

Calculate an illustrative weighted forecast

Discovery: $20k × 20%Illustrative weighted value
$4k
Proposal: $40k × 50%Illustrative weighted value
$20k
Commit: $30k × 80%Illustrative weighted value
$24k
Total weighted forecastAgainst $90k open pipeline
$48k
Illustrative example—not a benchmark. Replace every sample value with your own campaign, market, and measurement data.

PRACTICAL INTERFACE MAP

Build a transparent weighted forecast

Cohort01Freeze eligible opportunities

Set snapshot date, forecast horizon, close-date rule, currency, pipeline, owner, amount definition, and open-stage requirement.

Math02Multiply amount by probability

Use the documented stage or approved deal probability, calculate each weighted value, and preserve amount and probability inputs.

Audit03Compare with actual outcomes

Measure forecast error, win rate by stage and segment, slippage, concentration, and calibration before changing probabilities.

Conceptual walkthrough. Labels, controls, and availability can vary by account, region, plan, and interface version; verify the current screen before acting.

STEP-BY-STEP LESSON

Eligible cohort → calibrated probability → weighted value → forecast audit

FreezeDate, horizon, currency, rules
CalculateAmount × probability
CalibrateForecast versus actual

THE LEAD ATLAS METHOD

Lead Atlas Data can research a campaign-specific business-contact list for the markets, locations, and account categories needed to replenish an early-stage pipeline, while forecasting remains grounded in actual opportunity evidence.See how custom list research works ↗
01

Define the forecast question

Write the snapshot date, revenue period, booking or revenue definition, included pipelines, stages, owners, regions, currencies, close-date rule, opportunity types, amount field, and treatment of renewals, one-time fees, taxes, and already closed deals.

Freeze the input cohort before calculation. A rolling CRM view can change while someone reviews the forecast, making totals impossible to reproduce.

02

Calibrate stage probabilities

For each stage, measure historical opportunities that reached that stage and later closed won within comparable segments and horizons. Use enough observations, preserve the cohort definition, and show uncertainty for sparse stages.

Do not assign 50% merely because a stage feels halfway through. Segment probabilities when market, deal size, product, motion, or owner creates persistent material differences, but avoid slices too small to learn from.

03

Calculate weighted value

For each eligible opportunity, multiply the defined amount by its stage probability or an approved documented deal probability. In the illustrative example, $20,000 × 20% = $4,000; $40,000 × 50% = $20,000; and $30,000 × 80% = $24,000, totaling $48,000.

Keep open pipeline of $90,000 separate from weighted forecast of $48,000. Do not sum percentages, double-count parent and child deals, mix currencies without a stated conversion date, or treat weighted value as a guaranteed booking.

04

Expose risk behind the total

Show unweighted pipeline, weighted total, stage mix, deal count, average and median deal size, largest-deal share, owner concentration, close-date slippage, next-step age, and scenarios. Two portfolios with the same weighted sum can have very different risk.

Flag opportunities with stale close dates, missing next steps, unsupported amount, unusual probability overrides, or dependencies. Present base, downside, and upside cases as assumptions rather than manufactured certainty.

05

Backtest and recalibrate

After the horizon closes, compare forecast with actual eligible revenue, absolute and percentage error, stage conversion, slippage, loss reasons, and calibration—for example, whether deals assigned near 50% win about half the time over repeated cohorts.

Deliverable: forecast definition, frozen opportunity export, eligibility rules, currency policy, probability table and evidence, deal-level calculation, unweighted and weighted totals, concentration panel, risk flags, scenarios, actual-outcome file, forecast-error report, recalibration decision, and next snapshot date.

THE TAKEAWAY

Freeze a defined cohort, use probabilities backed by historical outcomes, show both weighted total and risk distribution, and compare forecasts with realized revenue by segment and horizon.

OFFICIAL REFERENCES

Check the platform’s current instructions.

Platform labels, eligibility, and workflows can change. These official help pages were used to validate this lesson.