A Missed Quarter: Pipeline, Productivity, or Forecast Process?
Northbridge's Q3 forecast missed by 34%. Commit deals delivered 71% of forecast value, Best Case 38%, and Pipeline 11%, against historical realizations of 95%, 70%, and 30%. Q4 pipeline coverage opened at 2.4x versus a three-year average of 3.1x. Stage 3 to closed-won conversion fell from 46% to 33% over two quarters while stage 2 to 3 held steady. Average sales cycle lengthened from 71 to 90 days. The team is down to 5 quota-carrying reps from 8 after attrition; two backfills start in six weeks. CRM data shows an average of 3.2 close-date pushes per open opportunity, and 61% of open opportunities have no next-step date. Reps describe the forecast categories as whatever the manager wants. The CFO must reset the annual plan and is asking whether the miss was a pipeline problem, a productivity problem, or a forecasting process problem.
1. Diagnose which of the three explanations the data supports, and what additional data you would pull before the board meeting.
Read the worked answer
All three are present, but the data points to a demand-and-capacity problem wearing a forecasting costume.
Separate the signals:
- Coverage at 2.4x is worse than it looks. With stage-3 win rates at 33% instead of 46%, the coverage needed to produce the same number rises roughly by 46/33, from 3.1x to about 4.3x. At 2.4x, Q4 is short by nearly half, not marginally.
- Conversion fell only at stage 3, not from stage 2 to 3. That is the signature of late-stage execution and deal quality, meaning pricing, procurement, security review, and budget, not bad lead generation. It also fits a team that lost 3 of 8 reps: survivors are carrying more late-stage deals and dropping them.
- Longer cycles plus 3.2 close-date pushes mean close dates are set to satisfy the forecast cadence rather than buyer events.
- 61% of open opportunities without a next step is a data-integrity failure that makes any coverage figure unreliable.
Before the board meeting, pull: win rate by rep and tenure, stage-3 loss reasons, what happened to previously pushed deals, pipeline created per rep per month versus the prior three quarters, and the same metrics split new business versus expansion. Ask for buyer-verified close plans on the top 20 commit deals.
2. Redesign the forecast categories and cadence.
Read the worked answer
Categories should be evidence tiers, not optimism tiers.
Definitions:
- Commit: signed order form or PO issued, or a documented verbal with procurement complete and a mutual close plan naming the signature date. Requires a named, buyer-verified next step within 14 days.
- Best Case: close plan agreed with the buyer, security and legal cleared, budget confirmed in writing.
- Pipeline: qualified, but at least one of the above remains unresolved.
Mechanics:
- Score every deal with a stage-and-segment conversion weight derived from the last eight quarters, and roll up a weighted number beside the categorical one. The gap between them is your bias measure.
- Split new business, expansion, and renewals. They convert differently, and blending hides the problem.
- Enforce hygiene: no open opportunity without a dated next step; close-date changes require a reason code; a deal pushed three times is escalated and re-staged.
- Weekly manager inspection of Commit only, biweekly review of full pipeline, monthly accuracy review comparing category realization to history.
Track two numbers publicly: forecast bias, which should land within plus or minus 10%, and accuracy as a percentage error. Reward managers for calibration rather than for committing high.
3. What do you tell the CFO and board, and what commitment do you make for Q4?
Read the worked answer
Tell them the truth in a form that is useful, and separate the number from the mechanism.
What I would present:
- A bridge from the original plan to reality: capacity, meaning 3 reps lost, backfills starting in six weeks and a four-month ramp; conversion falling from 46% to 33%; cycle time up 19 days. Quantify each in dollars so the miss is explained rather than narrated.
- Q4 as a range with stated assumptions: base case at 5 reps plus partial backfill contribution, downside if stage-3 conversion does not recover, upside if it does. Show the coverage math, because 2.4x against a 33% win rate does not support the original number.
What I would not do: recommit to the annual number to protect the story, or give a single-point forecast I cannot defend. Reframe the commitment as forecast integrity, a calibrated number plus the leading indicators reported monthly: pipeline created per rep, stage-3 conversion, close-date push rate, next-step coverage.
Then ask for what the miss requires: accelerated hiring approval, concession authority or a deal desk to unstick late-stage deals, and a Q1 pipeline-generation program. Boards accept a diagnosis with a plan far better than a January surprise.