FIELD NOTES

How to Improve Sales Forecast Accuracy: The Lag No Formula Fixes

Weighted pipelines and historical win rates already do the math correctly. The forecast still misses because of what happens before a number reaches the field.

2026-09-10 · SARA — KEEL'S AI DEAL ASSISTANT · GETKEEL.IO

Thin lines drifting apart on one side, converging through a narrow ember-orange slot, then reordering into a grid.

The forecast missed again this quarter. Not by a landslide — twelve points low on committed, high on the deals that were supposed to close.

The RevOps team's response was the usual one: switch models. Weighted pipeline instead of stage-based. Historical win rate blended in.

Next quarter missed by roughly the same amount.

The math was never the problem

Weighted pipeline models are sound. So is a historical win-rate blend. So is running three methodologies and triangulating.

Each one takes the numbers in the CRM and does honest arithmetic on them.

The arithmetic isn't what's wrong. What's wrong arrives before the math ever runs.

Where the real gap lives

A rep usually knows a deal is slipping days before they touch its stage.

They know it in a specific moment — a champion who went quiet, a budget question that came back vague, a competitor mentioned for the first time. That moment doesn't get typed anywhere.

The stage field gets updated later, once the rep is sure enough to defend the change out loud. That defending-it-out-loud problem is exactly why the update waits.

Why every technique inherits the same lag

| Technique | What it does well | What it can't see | |---|---|---| | Weighted pipeline | Discounts by stage probability | A stage nobody's updated yet | | Historical win-rate blend | Corrects for a rep's usual optimism | This quarter's specific slipping deal | | Multiple-methodology triangulation | Cross-checks one number against another | Three numbers all built on the same stale field |

Three different math approaches, one shared input problem. Forecasting techniques can only be as current as the last time a human decided a field was worth changing.

The three-day gap, made specific

Say a champion stops replying on a Monday. The rep notices immediately — it's their deal, their quota, their attention on it.

They don't move the stage Monday. Moving it Monday means explaining a downgrade to a manager who hasn't asked yet, over something that might still resolve itself by Wednesday.

By Thursday, when the stage finally changes, the forecast has already run at least once on Monday's optimistic number. Broken out by rep, that three-day gap is checkable. Rolled into a company-wide number, it just reads as noise.

What actually closes the gap

Not a fourth model. A place to log the Monday doubt the moment it happens — before it has to survive a conversation with anyone else.

The doubt doesn't need to change the CRM stage yet. It needs to exist somewhere dated, so the three-day lag has a start time instead of disappearing into "the rep should have flagged that sooner."

Sara's built for exactly that moment: the private, dated note a rep would make the same afternoon a deal starts slipping, before it's ready to become a stage change anyone has to justify. Founders Club is invite-reviewed: apply at getkeel.io/founders.

Same quarter, three days earlier

Nothing about the model needs to change. The math was already fine.

What changes is when the doubt gets written down — Monday instead of Thursday, in the rep's own words instead of a stage nobody's ready to defend yet.

Run that same weighted pipeline on Monday's number instead of Thursday's, and the twelve-point miss gets a lot smaller before anyone touches the formula at all.


By the team at Keel. We're building Sara, an AI deal assistant for the moments that don't get recorded.

MORE IN THIS SERIES
SaaS Sales Forecasting: One Number, Two Different Kinds of Unsure
SaaS sales forecasting blends new-logo ARR and expansion revenue into one line. They're not the same bet, and treating them alike hides which risk you're actually carrying.
Sales Forecasting vs Pipeline Management: Two Different Questions, One Report Trying to Answer Both
Pipeline management asks if a deal is healthy. Forecasting asks what closes and when. Clean up the pipeline and the forecast can still be wrong.
Pipeline Forecasting: The Model Gets Smarter, the Input Never Does
Pipeline forecasting models keep getting more sophisticated. The number they're built on — a rep's rounded-up stage — never gets any more honest.
keel
BLOGMANIFESTOTERMSPRIVACY
© 2026 Keel
🔐ROAD TO SOC2
🛡PRIVACY FIRST
🚫NO DATA SOLD