learn-sales-pipeline-analytics-with-phoebe / Business session 3 of 4
Learn B2B Sales Pipeline Analytics with Phoebe · Business session 3 of 4

Who owns the forecast

Most forecast fights are not about the number. They are about who was allowed to change it. A forecast has two halves with two different owners. The BD lead owns the number and the commit: what the team will deliver, and the judgement calls such as whether the biggest deal lands this quarter. The data team owns the method, the range around it and the method's measured error rate. Tonight draws the seam between the two, shows each half's accountability with real bench numbers, and puts both on one page that two people sign every quarter. Kettle & Co's office-tea team is constructed; the deal timings underneath come from real B2B funnel rows.

🟡 Business BD and sales leaders who read the pipeline, and the analysts who build it No code 45 min
0-3 · Welcome 3-18 · Two halves, accountability, the contract 18-40 · Build-along: Kettle's forecast contract 40-45 · Q&A
Part 0

Where we start

Business session 1 rewrote the stages as buyer acts. Business session 2 read a pipeline review for what it hides and ended with one sentence on what the pipeline really covers. Tonight that sentence becomes the first line of a forecast contract. The question underneath is old and political: when the BD lead says 7.86 million yen and the analyst's model says 5.01, whose number goes to the board? The answer is both, printed side by side, each signed by the person accountable for it. Kettle & Co, a BD lead and four reps (Aiko, Ben, Chiara, Dev) selling office tea subscriptions in Japan, is constructed; every Kettle number on this page is either printed by the bench in Analyst session 6 or labelled as constructed arithmetic.

🎫 Clear all three quiz questions to stamp your passport Live = presented in the 45 minutes Self-study = the full depth, after class ★ Build-along = everyone works it through

★ What you walk out with tonight. A one-page forecast contract for Kettle that you can copy for your own team: stage definitions, what counts as pipeline, the freeze date, the methods printed with their track record, the range and its stated coverage, who calls the whale, and the gap that triggers a conversation. Two signature lines, one for each half. Business session 4 uses the contract's track record as the evidence gate for a hiring plan.

Part 1 · covers the two halves of a forecast

Two halves, two signatures

5 min live

A forecast is a commitment and a measurement stapled together. The commitment is a promise about what the team will deliver, and only the person who runs the team can make it. The measurement is an estimate of what the pipeline usually produces, with a range and a record of how often that estimate has been wrong, and only the person who built the method can stand behind it. Mix them and nobody is accountable for either.

ONE FORECAST, TWO HALVES, TWO OWNERS Kettle & Co this quarter · constructed team, bench numbers from Analyst session 6 BD LEAD SIGNS The number what the team will deliver: 7.86m yen The commit which deals each rep calls, and coaching it The judgement calls the whale: this quarter or next signed: BD lead THE SEAM both numbers side by side nobody edits DATA SIGNS The method history-based, printed beside the commit The range 5.01m point, 2.03 to 8.00m, 80% band The error rate 38.8% over 20 replays, covered 17 of 20 signed: data lead Data never edits the commit; it publishes its own number beside it. Each half has one name on it.
🔍 Click to zoom - the left half is a promise, the right half is a measurement, and the seam is where they are printed together
LiveWhat each half is, and why it cannot be the other3 min▶

The BD lead's half is a promise. The commit is what the team says it will deliver, deal by deal. It carries information no model has: the buyer who said yes on the phone yesterday, the procurement freeze the rep heard about at lunch, whether the biggest office really signs before the quarter ends. That knowledge is real, and so is the incentive to shade it. Only the person who runs the team can coach both.

The data team's half is a measurement. The method takes the pipeline as it stood on the freeze date and asks what deals like these have usually done. Its job is not to be right this quarter; it is to be wrong by a known amount, published every quarter, so that everyone can see how far to trust it.

Neither can sign the other's half. An analyst who signs the number is promising delivery on a team they do not run. A BD lead who signs the method is vouching for an error rate they cannot measure. The ownership map that assigns these decisions between data and BD is taught in Marketing Analytics, the ownership map ↗; use it as the rulebook. Tonight is only the forecast row of that map, made concrete.

Self-studyThe leader's side: getting people to believe it2 min▶

Splitting ownership is the mechanism. Whether the sales floor and the board trust the result is a leadership problem: how the BD lead talks about the method's number in the Monday meeting, whether a miss is met with curiosity or blame, how AI forecasting tools fit in. That side is covered in AI Sales, "A forecast people actually believe" ↗. Forecasting models themselves, from moving averages to machine learning, live in Timeseries Forecasting ↗. The three methods Kettle prints are walked through, without maths, in Analyst session 4.

Real world

The analyst who fixed the commit. Kettle's first analyst noticed that Ben's commits ran high and, trying to help, quietly multiplied his number down before it went into the board pack. Ben did not know. The BD lead did not know. When one quarter Ben's deals all landed, the board saw a miss that never happened, and nobody could explain where the number had come from. The fix was not a better multiplier: it was printing Ben's commit untouched, the method's number beside it, and making the gap a conversation between Ben and the BD lead. Constructed Kettle & Co example; the pattern is common.

Part 2 · covers accountability, with the bench as evidence

What each half answers for

5 min live

Ownership means somebody answers for the result. The BD lead answers for the commit landing and for how each rep calls deals. The data team answers for the method's range covering what happened, and for publishing the method's error rate honestly, including the quarters it looked bad. Here is what that looks like on Kettle's quarter, using only numbers the bench prints.

THE COMMIT AND THE METHOD, SIDE BY SIDE, THIS QUARTER m yen · bench numbers, Kettle constructed on real rows Rep commit · the BD lead's number point 7.86 · range 7.86 to 24.36 · misses 5.86 History-based · data's method point 5.01 · range 2.03 to 8.00 · covers 5.86 actual 5.86 0 5 10 15 20 25m yen Over 20 replays, rep commit: error 48.2%, actual inside its range 4 of 20. Over 20 replays, history-based: error 38.8%, actual inside its range 17 of 20. Call ratios: Ben 4.60, Dev 0.00, Aiko 0.98, Chiara 1.45. Coaching them is the BD lead's job. Commit 7.86, method 5.01, actual 5.86. Data prints both and moves neither. Bench, Analyst session 6.
🔍 Click to zoom - the copper line is what closed; only the method's range was drawn wide enough to catch it
LiveWhat the BD lead answers for3 min▶

The commit landing. Kettle's reps committed 7.86 million yen this quarter; 5.86 million really closed. The commit missed by 2.00 million, 34.1 percent high. Over 20 replays of the quarter (different 300-deal draws from the same real open pool) the rep commit erred by 48.2 percent on average and ran 33.9 percent high. Its range, commit up to commit plus best case, held the actual in only 4 of 20.

How each rep calls deals. The call ratio is a rep's commit divided by what they really closed, over the 20 replays. Ben's is 4.60: he commits four or more times what lands, because he commits from stage 4. Dev's is 0.00: he commits nothing until a contract is signed, so his commit is always zero and always wrong. Aiko sits at 0.98 and Chiara at 1.45. These are behaviours, and behaviour is the BD lead's to coach, in a one-to-one, with the rep present.

The judgement calls. Whether the biggest deal lands this quarter or slips is a call about one buyer, and the person closest to that buyer owns it. The data team's job is to show what happens to every number if the call is wrong.

LiveWhat the data team answers for2 min▶

The method's number and its range. The history-based method said 5.01 million yen, 0.85 million under what closed (14.5 percent low), with an 80 percent band from 2.03 to 8.00 million that covered the actual. Over 20 replays its error was 38.8 percent, the smallest of the three methods, and its range covered the actual in 17 of 20. Note what that does not say: a 38.8 percent typical error is not accurate, it is the least inaccurate method on the bench.

The method's blind spots, in writing. Over 20 replays history-based ran 18.6 percent high, because the May 2018 cohort in the real rows converted at 10.0 percent against 13 to 14 percent for January to April: the method assumes next quarter behaves like the last. It also reads origin and deal age, not stage, so a real late-stage signal is invisible to it. Data owns saying both out loud.

Never editing the commit. When the commit looks high, data does not correct it. Data publishes the method's number beside it, with the range and the track record, and lets the gap start the conversation.

Real world

The whale that slipped. On the bench, the biggest deal that really closed in Kettle's quarter is worth 2.11 million yen. Move it to next quarter and what closed drops from 5.86 to 3.75 million. The rep commit's range starts at 7.86 and the stage-weighted range at 5.48, so neither covers 3.75; only the history-based range, 2.03 to 8.00, still does. Over 20 replays with the whale slipping, the actual stayed inside the rep commit's range in 2 of 20, stage-weighted 3 of 20, history-based 13 of 20. Whether the whale lands is the BD lead's call; how wide the range must be to survive the call being wrong is data's. Constructed Kettle & Co team on real Olist timings; numbers from the bench in Analyst session 6.

Part 3 · covers the forecast contract

The forecast contract: one page, every quarter

5 min live

The two halves only work if the rules are agreed before the numbers arrive. Agree them after and every rule gets argued in the light of whose number looks better. The forecast contract is one page, agreed at the start of each quarter, with a line for each rule and a name against each line. It is short on purpose: a contract nobody reads protects nobody.

THE FORECAST CONTRACT, ONE PAGE every clause names its owner in the margin · Kettle & Co, constructed KETTLE & CO · FORECAST CONTRACT quarter 1 June to 30 August 2018 · agreed before the quarter starts owner 1 · Stage definitions buyer acts and their records both 2 · What counts pipeline = stage 2 and later only both 3 · Freeze date snapshot taken 1 June, never edited data 4 · Methods printed three methods and their 20-replay record data 5 · Range 80% band, coverage stated: 17 of 20 data 6 · The whale in or out this quarter: BD lead's call BD 7 · Gap trigger gap over 25%: meet (constructed) both BD lead · signs the number and the commit data lead · signs the method and range Seven lines, one owner each. The 25% trigger is a constructed threshold: set your own from your track record.
🔍 Click to zoom - the copper clause is the one that turns a disagreement into a scheduled conversation instead of a silent edit
LiveThe seven clauses, and why each is there3 min▶

1 · Stage definitions. The buyer-act stages from Business session 1, each with its record. If a stage changes mid-quarter, every method's number changes with it, so the definitions are frozen with the quarter.

2 · What counts as pipeline. Stage 2 and later. Contacted deals are leads, reported separately. Business session 2's coverage sentence goes here.

3 · The freeze date and snapshot. The pipeline as it stood on one named day, saved and never edited. Without it, nobody can later check what the forecast was based on. Analyst session 1 shows how to rebuild a snapshot from the event log when the CRM has already overwritten history.

4 · The methods printed, with their track record. Every method that is shown, with its bias, error and coverage over past quarters, from Analyst session 5. On Kettle's bench: rep commit bias +33.9 percent, error 48.2 percent, covered 4 of 20; stage-weighted +62.7 percent, 68.2 percent, 10 of 20; history-based +18.6 percent, 38.8 percent, 17 of 20. Stage probabilities come from Kettle's own history: on the same deals, the CRM's default probabilities produce 63.64 million yen against the 5.86 that closed.

5 · The range and its stated coverage. A range without a stated coverage is decoration. "80 percent band; held the actual in 17 of 20 replays" is a claim someone can check next quarter.

6 · Who calls the whale. The BD lead, by name, before the quarter starts, with the method's numbers shown both ways.

7 · The gap trigger. When the commit and the method's number differ by more than an agreed share, the BD lead and the data lead meet before the number goes anywhere. Kettle uses 25 percent of the method's number; that threshold is constructed for teaching. This quarter the gap is 7.86 minus 5.01, or 2.85 million yen, which is 56.9 percent of 5.01 (constructed arithmetic on bench numbers), so the meeting happens. Note that a rule of "commit outside the method's range" would not have fired: 7.86 sits just inside the 8.00 ceiling.

Self-studyForecast categories, and the accuracy surveys3 min▶

Categories are the BD lead's vocabulary. HubSpot's forecast tool, read on its knowledge base in October 2026, lets each deal sit in a forecast category, including Pipeline (low likelihood of closing), Best case (moderate likelihood) and Commit (high likelihood, committed to the forecast), with Closed won alongside. Categories can be mapped from deal stage automatically. The same page is not consistent about the full default list, so teach those three and check your own CRM. Salesforce's standard categories are reported by third-party guides to be similar. Either way, the category is a rep's judgement recorded in a field: it belongs in the BD lead's half of the contract, not the method's.

The accuracy surveys are contested. Forecasting and revenue-intelligence vendors and analyst firms regularly publish figures on how few sales forecasts land close to the actual. Some leaders use them as an outside anchor: proof that a miss is normal and a reason to invest. Others treat them as marketing: the method and sample are usually not published, and the publisher sells the fix. Both readings are held by serious people. The contract sidesteps the argument by putting your own track record in clause 4, measured on your own quarters, which is the only accuracy figure you can check.

Real world

The contract that ended the Monday argument. Before Kettle had a contract, every forecast meeting reopened the same questions: does stage 1 count, which day's pipeline are we looking at, why did the model change. After the BD lead and the data lead signed one page at the start of the quarter, the meeting had one agenda item left: the gap between 7.86 and 5.01, and what Ben knew about his stage 4 deals that the method could not see. Constructed Kettle & Co example using bench numbers.

Build-along

Draft Kettle's forecast contract

★ 22 min · everyone works it through

No code, one page. Draft the contract for Kettle's quarter in five steps, then swap with a neighbour and check each clause has one owner. Do step 1 together, steps 2 to 4 in pairs (one plays the BD lead, one the data lead), and read step 5 aloud. The bench numbers are printed by Analyst session 6; every other Kettle value is constructed and labelled. Then copy the shape for your own team.

FIVE STEPS TO ONE PAGE each card fills clauses of the contract · Kettle constructed STEP 1 Stages, pipeline stage 2 and later clauses 1-2 · both STEP 2 Freeze date 1 June snapshot clause 3 · data STEP 3 Methods printed with track record clause 4 · data STEP 4 Range and whale 80% band, BD call clauses 5-6 · split STEP 5 Gap trigger two signatures clause 7 · both Steps 1 and 5 are signed together; steps 2 to 4 are each one owner's homework before the quarter.
🔍 Click to zoom - the contract is filled left to right, and the last card is the only one that needs both people in the room

Step 1 · Stages and what counts as pipeline. Copy the stage sheet from Business session 1 and the coverage sentence from Business session 2. Write the rule for what counts as pipeline in one line. Both leads sign this clause, because the BD lead defines the buyer acts and the data lead has to measure them.

★ Step 1 · clauses 1 and 2Clause 1 · stages (buyer act -> record): 1 Contacted rep only; reported as leads 2 Need confirmed office manager named the problem -> call note 3 Tasting trial office agreed to a station -> trial log 4 Proposal buyer asked for a price -> price request email 5 Contract out procurement holds the contract -> e-sign log Clause 2 · pipeline = stage 2 and later. Stage 1 reported separately. Coverage sentence from session 2: ________________________________ Owner: both (Kettle stages constructed)

Step 2 · The freeze date. Name the day the pipeline is photographed, where the snapshot is stored, and who may touch it (nobody). Kettle's quarter runs 1 June to 30 August 2018, so the snapshot is 1 June.

★ Step 2 · clause 3Freeze date: 1 June 2018 (first day of the quarter) Snapshot stored at: ______________________ (read-only) Rebuilt from: the stage event log, not the CRM's current state Edits after the freeze: none; corrections go in a dated note Owner: data

Step 3 · The methods and their track record. List every method that will be shown, with its record over past quarters. Use Kettle's bench numbers. State where the stage probabilities come from.

★ Step 3 · clause 4Methods shown, with bias / error / coverage over 20 replays: rep commit +33.9% 48.2% 4 of 20 stage-weighted +62.7% 68.2% 10 of 20 history-based +18.6% 38.8% 17 of 20 Stage probabilities: Kettle's own table, never the CRM defaults Known blind spot: history-based cannot see a real late-stage signal Owner: data

Step 4 · The range and the whale. Data writes the range and its stated coverage. The BD lead writes, by name, whether the whale is in or out, and data adds what every range does if that call is wrong.

★ Step 4 · clauses 5 and 6Clause 5 · range: history-based 5.01m (2.03 to 8.00m), 80% band stated coverage: actual inside the range in 17 of 20 replays Clause 6 · the whale (2.11m yen): IN / OUT, called by ____________ if it slips, actual 5.86m -> 3.75m; only the history-based range covers it over 20 replays with the whale slipping: rep 2, stage 3, history 13 of 20 Owners: data (5), BD lead (6)

Step 5 · The gap trigger and the signatures. Agree the threshold, check whether this quarter trips it, and sign. Show the arithmetic so anyone can check it.

★ Step 5 · clause 7 and signaturesClause 7 · if |commit - method| > 25% of method, meet before publishing (25% is a constructed threshold; set yours from your track record) This quarter: commit 7.86m, method 5.01m gap = 7.86 - 5.01 = 2.85m ; 2.85 / 5.01 = 56.9% -> meeting Agenda: what Ben knows about his stage 4 deals that the method cannot see Signed: ____________ BD lead (number and commit) Signed: ____________ data lead (method, range, error rate)

Keep the page. Next quarter, clause 4's track record gains one more row and clause 5's coverage becomes a fact rather than a promise. Business session 4 uses that record as the evidence gate before anyone hires against the pipeline.

Homework

Before Business session 4

30 min
  1. Find out who can edit your forecast between the rep's commit and the board pack. List every person and every spreadsheet it passes through, and mark any step where the number changes without the rep knowing.
  2. Ask for the method's error rate. Whatever produces your non-commit forecast (a model, a weighted pipeline, a tool), ask for its error over the last four or more quarters. If nobody has it, that is clause 4's first job.
  3. Compute one call ratio. Pick one rep and divide their commits by what they really closed over the last few quarters. Bring it to a one-to-one, not a team meeting.
  4. Draft clause 7 for your team. Choose a gap threshold from your own history and test it on last quarter: would it have triggered a meeting, and would that meeting have changed anything? Business session 4 starts from your contract.
Check yourself

Three questions

Clear all three and Business session 3 gets stamped in your passport.

1 · Who owns the range around the forecast, and its stated coverage?

The range is a property of the method. Data signs it with its coverage, for example 17 of 20 replays for Kettle's history-based method, so it can be checked next quarter.

2 · The reps commit 7.86 million yen; the method says 5.01. What does the data team do?

Data never edits the commit. It prints its own number next to it, and the contract's gap trigger turns the difference into a meeting with the BD lead.

3 · Which set belongs in the one-page forecast contract?

Every clause has one owner and can be checked after the quarter. Compensation lives elsewhere, and an outside survey cannot replace your own measured record.

Sources covered

What this session teaches, and where it came from

✓Rep commit 7.86 vs 5.86 closed; history-based 5.01 (2.03 to 8.00); error 48.2% vs 38.8%, coverage 4 vs 17 of 20; call ratios Ben 4.60, Dev 0.00; whale 2.11mComputed by the bench in Analyst session 6 on real Olist B2B funnel rows (Olist, "Marketing Funnel by Olist", Kaggle dataset, CC BY-NC-SA 4.0, read at source)
✓HubSpot forecast categories: Pipeline, Best case, CommitHubSpot Knowledge Base, "Set up the forecast tool", read at source October 2026; the page's full default list is inconsistent, re-verify before teaching
◐Salesforce forecast categoriesSalesforce Help, opportunity stages and forecast categories; reported
◐Vendor forecast-accuracy surveysContested; the disagreement is taught and no figures are quoted
◐The ownership map between data and BDTaught in Marketing Analytics, the ownership map; linked, not re-taught
◐Kettle & Co team, contract clauses, the 25% gap trigger and its 56.9% checkConstructed and labelled; the arithmetic uses bench numbers

Every fact on this page, and its verification tier, is recorded in the course's source map.

Business session 3 cheat sheet · pin this

Two halvesBD lead signs the number and the commit. Data signs the method, the range and the error rate.
Never edit the commitPrint the method's number beside it. A silent correction makes both numbers unaccountable.
Call ratios are coachingBen 4.60, Dev 0.00 on the bench: behaviour for the BD lead's one-to-one, not a data fix.
A range states its coverage"80% band, held 17 of 20" can be checked. A range alone is decoration.
Agree before the quarterStages, pipeline, freeze date, methods, range, whale, gap trigger: one page, two signatures.
Your record beats a surveyOutside accuracy figures are contested; your own track record is the one you can check.