Forecasting & Pipeline

Click to enlarge

After this lesson you'll understand how the forecast is calculated, when to trust it, and how to focus on the realistic pipeline instead of the wish list.

A forecast is the most consequential number leadership touches — it drives hiring, cash planning, and what gets promised upward. It is also the easiest number to get quietly wrong, because it fails through record drift, not through math. This lesson is about knowing the difference between a forecast you can present and one you need to send back for repair.

How the forecast works

The forecast rolls up expected revenue across the live opportunities, weighted by where deals stand. Every deal carries a probability, and the forecast widgets follow the same convention the business has always used: deals at 50% probability and above count as the realistic forecast. Because the rollup is tied to live deal data, it stays current as deals move — it is not a stale snapshot someone exported last month.

That means the forecast has exactly four inputs per deal, and they are all human-maintained: stage, value, close date, and probability. When those four are honest, the forecast is honest. There is no fifth ingredient.

A realistic scenario

The click path

1. Open the Revenue Forecast view — it is already filtered to opportunities at 50%+ probability, the realistic pipeline.
2. Sort by close date. Anything with a close date in the past is a stale input inflating the forecast right now.
3. Scan the largest deals first. On each, check the four inputs: stage, value, close date, probability. A big deal with a stale close date matters more than ten small ones.
4. Open Pipeline by Business Unit to see how the forecast distributes across Technology, Venue Services, and Media & Sponsorship — concentration in one vertical is a risk worth naming.
5. Route problems back to owners as specific asks: "these three deals need current close dates before Thursday" beats "please clean up the pipeline."

The ask path

Comparing periods is where the dashboards earn their keep: you see the trend, not just a snapshot. A flat headline can hide a pipeline that is churning underneath — new deals replacing slipped ones at the same total.

Common mistakes

Two more habits to avoid: quoting the unfiltered pipeline as if it were the forecast (that includes every long shot), and treating a probability number as truth because it is precise. Probability is the owner's judgment encoded as a number — challenge it on big deals the same way you would challenge it in conversation.

What good looks like

• You know the current realistic forecast per vertical and roughly what drives it.
• No deal above 50% probability has a close date in the past — or you know exactly which ones do and have asked for fixes.
• You can explain the gap between the unfiltered pipeline and the 50%+ view: that gap is your long-shot exposure.
• The number you present is the number in the system — no private adjustments in a side spreadsheet.

Now you try →

Open the forecast, filter the pipeline to 50%+ probability, and compare it to the unfiltered number — that gap is your long-shot exposure. Then find one forecasted deal with a past close date and note who owns it.

👉 Open the CRM

Related lessons: The Dashboards · Win/Loss · RFP to Win (Workflow)