How a medical supplies company builds a contract expiry calendar from its agreement register: GPO and system agreements by end date, the revenue and facilities under each, the agreement's utilisation, contracted categories actually bought, the tier the customer earned against the tier it is on, the agreements inside the renegotiation window with no activity logged, and the identity that revenue under agreements plus off-agreement revenue equals the ledger.
16 Sept 20262 min readHow a company that sells on orders rather than subscriptions measures churn from its ledger: the definition of a lost customer from its own order cadence, churned revenue as the run rate before the silence, the churn rate by segment and by rep, the identity that ties churned plus retained plus new to the two periods' revenue, and why a fixed 12-month rule counts the wrong customers as lost.
16 Sept 20262 min readHow a commercial insurance broker joins the claims file to the placement ledger and the renewal outcomes to see how claims experience affects retention: loss ratio per client per line, the clients whose ratio moved past the carrier's appetite, the clients with a large open claim inside the renewal window, the historical non-renewal rate by claims band from the broker's own book, and the remarketing list ranked by both the risk and the premium.
16 Sept 20263 min readHow a customer service leader turns the ticket export into a weekly list of accounts whose contact volume has jumped against their own history, why the account's own baseline beats a global threshold, the surge score, and the two readings every surge has: a product problem or an account about to leave.
16 Sept 20262 min readHow a business telecoms provider builds the renewal calendar from the contract register: contract value ending per month per account manager, the accounts within the notice window with no logged renewal activity, the co-terminus opportunities where a customer's services end months apart, and the identity that ties the calendar's total to the contracted base.
16 Sept 20262 min readHow a supply chain team measures demand forecast accuracy and bias per SKU per site from the forecast snapshots and the actual demand: error and signed bias, the SKU-site pairs that are consistently over-forecast and carry the excess stock, the ones consistently under-forecast and carry the stock-outs, why bias at one site is usually a planner's override, and the adjustment the team's own history supports.
16 Sept 20263 min readHow a commercial bank finds the relationships whose operating balances have fallen against their own baseline while the accounts remain open, from the daily or month-end balance file: the balance baseline per customer, the decline signal, the split between seasonal, business-driven and moved-elsewhere, and the list per relationship manager ranked by the balances that have gone.
16 Sept 20262 min readHow a SaaS revenue team checks whether its expansion pipeline covers the whitespace the account data shows: expansion opportunities per account against the account's valued whitespace, the accounts with large gaps and no open opportunity, the opportunities on accounts with no gap, the share of whitespace value under active pursuit per rep, and the identity that ties expansion pipeline to the whitespace grid.
16 Sept 20262 min readHow a sales leader measures forecast accuracy per rep from the weekly forecast snapshots and the closed results: error, bias and the split between them, why a rep who is always 20 percent high is more useful than one who is randomly 10 percent out, the per-rep adjustment it produces, and the identity that ties the adjusted forecast to the raw one.
16 Sept 20263 min readThe four common ways to forecast a quarter, rep roll-up, stage-weighted pipeline, run rate and historical conversion, what each needs, what each is good and bad at, a worked quarter where they give four different numbers, and why the right output is not one of them but the bridge between them, with the deals that explain the gaps.
16 Sept 20263 min readA reading guide for a forecast bridge from last period's number to this one: the check that the lines sum before anything is read, the order to read them in, closed, slipped, lost, new, resized, the deal list behind each line as the thing to open, the line with no deals behind it as the one to distrust, the repeat slippers across bridges, and the two lines that set next period's calibration.
16 Sept 20263 min readA reading guide for a pipeline table by rep and stage: why face value is the column to distrust, why weighted by historical conversion is the one to believe, what the slip count column does to both, how to read stage distribution as a shape rather than a total, the needed multiple against coverage, and the two rows to open, the rep whose weighted coverage is lowest and the rep whose face-to-weighted ratio is highest.
16 Sept 20262 min readHow a sales leader measures the share of first meetings that become a qualified opportunity within a stated window, per rep and per source, from the activity log and the pipeline: the conversion rate, the meetings with no opportunity and no follow-up, the reps with many meetings and little pipeline, the sources whose meetings convert, and why the measure sits between activity and pipeline where most teams measure neither.
16 Sept 20262 min readHow a hotel group builds a pace report from the reservation export that a revenue manager can act on: rooms and revenue on the books for each future month against the same point last year, by segment, per property, the properties behind pace in a segment where their comparable set is ahead, the pickup still needed to reach budget, and the identity that ties the pace table to the reservation system.
16 Sept 20262 min readPipeline coverage is open pipeline over remaining target, and on many desks there is no CRM pipeline at all: the pipeline is renewals due, tenders in flight, RFQs open, applications pending, or the season's filings. This hub gives, for twelve industries, what stands in for the pipeline, where it lives, how it is weighted, and the multiple the desk actually needs, with the guide for each.
16 Sept 20263 min readThe complete pipeline coverage calculation on ten open deals small enough to check by hand: the deals by stage and value, the team's historical conversion by stage at this point in the quarter, the face value, the weighted value, the slip counts and the slip adjustment, the remaining target, coverage three ways, the needed multiple, and the deal list that explains the gap, so a reader can reproduce every figure and then run it on their own snapshot.
16 Sept 20263 min readThe pipeline coverage formula, why the common three-times rule is a guess, how to derive the multiple your team actually needs from its own stage conversion history, the coverage by rep and by stage that comes out, and the gap to target in dollars that a sales leader can act on with weeks left.
16 Sept 20262 min readWhy a stage-weighted forecast is only as good as the stage definitions, what an exit criterion is, five stages with criteria a rep can verify and a manager can audit, how to check from the CRM that deals in a stage actually meet its criteria, the stage probabilities derived from the team's own history rather than set in a workshop, and the versioning that keeps last year's pipeline comparable.
16 Sept 20262 min readHow an investment bank's coverage and product groups measure pitch-to-mandate conversion from the pitch log and the mandate register: pitches made per sector team and product, mandates won, conversion by count and by estimated fee, the senior hours per pitch from time or calendar records, fees won per senior hour by cell, and the sectors and products where the bank pitches most and wins least.
16 Sept 20263 min readHow a consulting or advisory firm measures proposal win rate from its proposal log and engagement letters, by practice, by source, existing client, referral, competitive tender or cold, and by fee band, the cost of a proposal in hours from the time entries, the cost per win by cell, and the cells where the firm spends the most partner time for the least work.
16 Sept 20263 min readHow a pharmaceutical commercial team measures whether a formulary or payer win turned into prescriptions, from the access file, the prescription data and the call log: the accounts whose access opened on a date, their prescriptions before and after against accounts whose access did not change, the calls made to them in the weeks after the win, the territories where access opened and nobody called, and the honest statement of what the difference is and is not.
16 Sept 20262 min readHow an industrial manufacturer measures the share of quotes that become orders per customer, per product family and per estimator, from the quote log and the order book: conversion by count and by value, the customers who request many quotes and place few orders, the product families where the price is losing, the lead time on quotes that convert against those that do not, and the identity that ties converted quotes to booked orders.
16 Sept 20263 min readHow to build a sales forecast bridge from pipeline history: the components that explain the difference between run rate and forecast, the slip count per deal that predicts the next slip, and the follow-up questions that turn the forecast call into a conversation about evidence.
16 Sept 20263 min readWhy a month-to-date figure read on the 12th misleads in three predictable ways, the day-of-month profile that says how much of a normal month has usually landed by each day, the projection that follows and its range, which measures can be read mid-period and which cannot, and the rule that a partial-period figure is always shown with its expected share and never beside a full period as if comparable.
16 Sept 20262 min readHow an asset manager's distribution team finds the intermediaries whose net flows have turned negative against their own history while their assets still look intact, from the transfer agent file: the flow baseline per intermediary per strategy, the turn signal, the months of runway before the assets follow, and the list that reaches the wholesaler while there is still a conversation to have.
16 Sept 20262 min readHow a sports organisation reads partner renewal timing from its contract history: days before expiry at which each partner renewed in past cycles, the organisation's own norm by partner tier, the partners now past their usual signing point with no renewal, what the late renewers of past seasons had in common, falling delivery ratio, low hospitality yield, a change of marketing director, and the list that says who to call this week.
16 Sept 20263 min readHow a sports organisation's partnerships team measures what each partner received against what they paid, from the delivery log and the contract file: delivered inventory valued at rate card against contract value, the partners under-delivered who will ask for make-goods, the partners over-delivered whose renewal should price the extra in, and the timing that puts the list in front of the team before the renewal window opens.
16 Sept 20262 min readWhy run rate is the floor a forecast should be compared to rather than a forecast itself, what the gap between the two is made of, new business, expansion, churn, seasonality and known changes, the bridge from run rate to forecast with a line for each, the forecast that sits below run rate and needs a reason, the one far above it and needs pipeline, and the rule that the forecast is defended by the lines between it and the floor.
16 Sept 20263 min readThe run rate formula, the choice of window and why it matters, a worked example against a seasonal and a lumpy business, the four ways run rate misleads, seasonality, one-off orders, a short window and a trend, and the rule for when to annualise and when not to. With the account-level use that makes run rate a ranking rather than a forecast.
16 Sept 20263 min readThe sales velocity formula, opportunities times win rate times average deal value divided by cycle length, how to compute each factor from CRM snapshots and closed outcomes rather than from the CRM's own summary, per rep and per segment, why the factors are not independent, and how to find which one changed when velocity did, with a worked decomposition.
16 Sept 20263 min readHow seasonality distorts every trend-based measure, run rate, dormancy, surge, forecast bias, and the two comparisons that handle it: same period last year, and a seasonal index from the company's own history. When each applies, how the index is built per segment and per account, the accounts whose seasonality is their own, the rule that the comparison is stated on the line, and the four measures where the trailing average is simply wrong.
16 Sept 20262 min readHow a SaaS revenue team turns product usage and the contract register into a renewal risk and expansion list: active seats against contracted seats per account, the utilisation trend over the last two quarters, the accounts under a threshold with a renewal inside 120 days, the accounts at or above their seat cap, and the identity that ties the seat table to ARR.
16 Sept 20262 min readHow a CPG brand compares what it shipped to each retailer with what the retailer sold through, from the shipment ledger and the sell-out data: the channel inventory implied by the difference, weeks of cover per retailer and per SKU, the retailers where sell-in has run ahead of sell-out for a quarter, the promotions that loaded the channel, and why a strong shipment quarter with rising channel inventory is next quarter's problem.
16 Sept 20262 min readHow an industrial manufacturer builds a service contract calendar from the installed base register: units by warranty end date and contract end date per customer, the attach rate for units in their first year off warranty from the manufacturer's own history, the customers with units coming off warranty in the next two quarters and no contract offer logged, the value of a contract at the norm per unit, and why the call belongs to the service sales team before the parts desk hears from the customer.
16 Sept 20262 min readHow a business telecoms provider reads its usage data per site against each site's contracted capacity: peak utilisation against the circuit's bandwidth, the sites above a stated share of capacity for a stated number of days, the customers with several such sites, the upgrade value at the next tier, the sites whose usage fell to nothing and may be closing, and why the upgrade list beats the fault ticket as the moment to sell more.
16 Sept 20262 min readHow a sales leader measures slip count from weekly pipeline snapshots: the number of times each open deal's close date has been pushed, the close rate by slip count from the team's own history, the weighted forecast that discounts multi-slip deals by that rate, the reps whose pipeline carries the most slips, and why a deal that slipped three times is a different object from a deal that slipped once.
16 Sept 20263 min readThe ten questions a head of customer success asks about the base, which accounts are at risk, which are under-using what they bought, which renewals are inside the window untouched, which accounts are surging or silent on support, which have to call twice, which onboardings are behind the milestone that matters, which are over their seat cap, which cost more to serve than they pay, which churned last quarter and why, and what the health score got wrong, each with the computed signal that answers it and the list it produces.
16 Sept 20263 min readThe ten questions a hotel group's commercial director puts to the property and sales teams, which properties are behind pace and in which segment, which corporate accounts under-produce their agreements, which properties have the wrong segment mix for their set, where does function space sit empty, which accounts leak to public rates, which sales managers cover their accounts, which properties turn business away midweek, which agreements expire with no production review, what is the group's concentration by account, and what changed, each with the table from the reservation snapshots and the agreement file, and the answer to send back.
16 Sept 20262 min readThe ten questions a SaaS chief revenue officer puts to the sales and success teams about existing customers, what is net revenue retention by cohort and which cohort broke, which accounts renew inside 120 days under their seats, is the expansion pipeline on the accounts with whitespace, which onboardings are behind the milestone that predicts renewal, what is whitespace reconciled to ARR, which accounts are over their cap, which accounts have gone untouched, what do bookings, billings and revenue each say, which deals slipped three times, and what changed, each with the table from the subscription ledger, the usage export and the CRM, and the answer to send back.
16 Sept 20262 min readThe ten questions the chief executive of an education provider puts to the sales and success teams, which institutions renew in six months with low utilisation, which cohort stalled, which trusts and districts are counted as ten schools, what did the price uplift realise, which programmes fit which institutions, which entities have gone silent before the academic year, which account managers hold a price, what is the pipeline against the year's target, which institutions are over their seats, and what changed, each with the table from the licence register, the usage export and the orders, and the answer to send back.
16 Sept 20262 min readThe ten questions the chief executive of a commercial insurance broker puts to the placement and account teams, which renewals are in notice with no remarketing, which lines do our clients place elsewhere, where is one carrier the line, which clients' claims changed their renewal risk, what did we lose and to whom, which executives' books stopped growing, which new business leaves at the first renewal, which clients' programmes sit with one carrier, what is the commission and fee mix, and what changed, each with the table from the placement ledger, the outcomes and the claims file, and the answer to send back.
16 Sept 20263 min readHow a freight broker reads its tender log as a capacity signal: rejections over tenders per lane per week, the lanes where the rate rose against their own baseline before spot rates did, the carriers rejecting most on each lane, the cost of a rejection in the spread between the contracted rate and the cover rate, and the shipper conversation that a rising rejection rate should trigger before the lane goes to spot.
16 Sept 20262 min readHow a SaaS customer success team finds the onboarding milestone that most separates renewed from churned accounts, from the usage export, the onboarding log and the renewal outcomes: days to each milestone per account, first-renewal retention by whether and when the milestone was reached, the milestone with the largest separation, the accounts in onboarding now that are past its typical day without reaching it, and the honest statement that it is an association.
16 Sept 20263 min readHow to compute win rate from closed outcomes rather than open pipeline, why the team's single figure hides a 45 percent rate in one segment and a 12 percent rate in another, the three splits that matter, segment, source and deal size band, the minimum count that makes a split trustworthy, and how the split changes where the pipeline effort goes.
16 Sept 20262 min readThe complete sponsorship delivery ratio calculation on three partners at two thirds of a season, small enough to check by hand: each partner's contracted assets and fixtures, rate card per asset per fixture, units delivered from the delivery log, delivered value at rate card, contract value, the delivery ratio, the expected ratio from the package discount, the gap in points, the unconfirmed fixtures that count as neither, the make-goods owed with a third of the season left, and the assertion that delivered units never exceed capacity, so a reader can reproduce every figure and then run it on their own contract file and delivery log.
17 Sept 20263 min readThe complete deposit flight calculation on five commercial banking relationships, small enough to check by hand: the trailing twelve month-end balances and the median as baseline, the last three months against the baseline and against the same months last year, the decline rule, the transaction split that says whether the money moved to another bank, the business shrank or the season turned, the balances gone, and the assertion that balances reconcile to receipts and payments, so a reader can reproduce every figure and then run it on their own balance file.
17 Sept 20263 min readThe complete forecast bias and error calculation on five reps over four quarters, small enough to check by hand: each rep's week-six forecast and closed result per quarter, the signed miss, error as the mean absolute miss, bias as the mean signed miss, the four kinds of rep, the adjustment for the predictably-high rep with its range, the reps with too few quarters to adjust, and the identity that the adjusted total equals the raw total plus the adjustments, so a reader can reproduce every figure and then run it on their own snapshots.
17 Sept 20263 min readThe complete meeting-to-opportunity conversion calculation on ten first meetings from two reps, small enough to check by hand: the first-meeting rule, the source per account, the pipeline's opportunity created dates, the thirty-day window, converted or not per meeting, the follow-up check, conversion per rep and per source, the no-follow-up list, the meeting whose opportunity came outside the window, and the assertion that first meetings equal converted plus followed-up plus no-follow-up, so a reader can reproduce every figure and then run it on their own activity log and pipeline.
17 Sept 20263 min readThe complete pace calculation on one hotel for one future month, small enough to check by hand: rooms and revenue on the books by segment from today's reservation snapshot, the same month at the same point last year from the kept snapshot, pace by segment in rooms and as a share, budget by segment, pickup needed, historical pickup from this point from three years of snapshots, the segment that is behind while the comparable set is ahead, and the identity that segments sum to the snapshot, so a reader can reproduce every figure and then run it on their own snapshots.
17 Sept 20262 min readPipeline coverage and weighted pipeline are two ways of asking whether there is enough pipeline to make the number. Coverage divides unweighted in-period pipeline by the target and compares the multiple to one over the win rate. Weighted pipeline multiplies each deal by a stage probability and compares the sum to the target directly. This page sets out both, computes them on the same ten deals, shows that they agree when the stage probabilities are the team's own measured rates and disagree when they are defaults, and says which to use for what.
17 Sept 20264 min readA template for a one-to-one pipeline review between a sales manager and a rep: the pre-read table that flags which deals need discussing, the six questions to ask about each flagged deal, how to handle stalled deals and slipped close dates, how the review feeds the forecast, and what to record. This page gives the flags, the questions, a thirty-minute structure, and a copyable template, so the review is about the ten deals that need a decision and not a recital of all forty.
17 Sept 20265 min readThe complete quote-to-order conversion calculation on ten quotes from three customers and two estimators, small enough to check by hand: the quote log's requested and issued dates and value, the order book's quote references, conversion by count and by value per customer, per product family, per estimator and per turnaround band, the price-check customer, the family losing on value, the slow quotes that lose, the order that references no quote, and the identity that converted quote value equals booked orders from quotes, so a reader can reproduce every figure and then run it on their own quote log.
17 Sept 20263 min readThe complete run rate and seasonal index calculation on one company's twelve months of revenue, small enough to check by hand: the trailing three-month run rate at four points in the year and how far each is from the actual year, the seasonal index per month from three years' shares, the deseasonalised run rate, the same-period-last-year comparison, and the one-off order that doubles a quarter, so a reader can reproduce every figure and then run it on their own ledger.
17 Sept 20263 min readCommit, best case and pipeline are the usual sales forecast categories, and on most teams they mean whatever each rep wants them to mean. This page gives a definition for each category that rests on evidence in the deal rather than on confidence, the close rate each category should achieve if the definitions are being followed, how to test that on the team's own history, how to roll the categories up into a forecast range, and a copyable forecast sheet.
17 Sept 20265 min readThe complete sales velocity calculation and decomposition across two quarters, small enough to check by hand: qualified opportunities, win rate from outcomes, average won value and cycle length from won deals, velocity as revenue per day, the four one-factor recomputations that attribute the change, the interaction residual, and why cycle length explains more than the whole decline, so a reader can reproduce every figure and then run it on their own snapshots and outcomes.
17 Sept 20262 min readThe complete renewal calendar calculation on five contracts, small enough to check by hand: end date, notice period and monthly value from the register, the notice window start per contract, the activity log's renewal-type entries in the last ninety days, the untouched-in-notice list, value ending per month, the co-terminus customer whose services end months apart, the rolling contract with no end date, and the identity that the calendar's total equals the contracted base, so a reader can reproduce every figure and then run it on their own register.
17 Sept 20263 min readThe complete tier gap and utilisation calculation on three health system agreements, small enough to check by hand: each agreement's tier thresholds and the tier the customer is priced on, the trailing year's volume from the invoice lines, the tier that volume earns, the price difference per unit between the two tiers times the volume, contracted categories against categories actually bought, the agreement inside its renegotiation window with no activity, and the identity that revenue under agreements plus off-agreement equals the ledger, so a reader can reproduce every figure and then run it on their own agreement register.
17 Sept 20263 min readThe complete sell-in against sell-out calculation on one SKU at one retailer over thirteen weeks, small enough to check by hand: weekly shipments and weekly sell-out, cumulative each, implied channel inventory from a stated starting figure, the trailing eight-week sell-out rate, weeks of cover per week, the promotion weeks that explain one build and the loading that explains another, the identity that implied inventory never goes negative, and the next-quarter shipment effect, so a reader can reproduce every figure and then run it on their own files.
17 Sept 20263 min readThe honest answer to how accurate a sales forecast should be: the plus or minus 10 percent that is often quoted depends on when in the period the forecast was made, whether the miss is random or always in one direction, and whether accuracy is measured on the total or per rep. This page gives the ranges by horizon, the three measurable things that set the right figure for one team, the horizon, the bias, and the per-rep spread, and the table to compute before anyone quotes a percentage.
17 Sept 20263 min readThe honest answer to what pipeline coverage a team needs: the widely quoted 3x is a rule of thumb that only holds at one win rate and one sales cycle. This page gives the arithmetic behind 3x, the three measurable things that set the right ratio for one team, the historical win rate on qualified pipeline, the deals that will close in the period, and the pipeline by stage, and the table to compute before anyone quotes a multiple.
17 Sept 20263 min readThe honest answer to what share of quotes should turn into orders: the 25 to 50 percent figures quoted for distributors and manufacturers depend on how quotes are joined to orders, on whether conversion is by count or by value, and on the customer mix, because some customers quote everything three ways and some only quote what they intend to buy. This page gives the ranges by desk, the three measurable things that set the right figure for one business, and the table to compute before anyone quotes a percentage.
17 Sept 20263 min readThe honest answer to what B2B sales win rate a team should have: the 20 to 30 percent figures usually quoted depend entirely on the stage the rate is measured from, whether it is counted by deals or by value, and what happens to deals that never close. This page gives the ranges by stage and desk, the three measurable things that set the right figure for one team, and the table to compute before anyone quotes a percentage.
17 Sept 20263 min readWin rate, close rate and conversion rate are used interchangeably in sales reporting and have different denominators. Win rate is won over decided. Close rate is usually won over all opportunities created, decided or not. Conversion rate is the share moving from any one stage to the next. This page sets out the three definitions, computes all three on the same hundred opportunities, shows when each is the right one, and lists the questions to ask before comparing a figure to anyone else's.
17 Sept 20263 min readA template for win-loss analysis that runs on every closed deal instead of an occasional interview programme: the seven fields to record at close, a short controlled list of loss reasons, how to stop price becoming the answer to everything, and the four tables the data produces: win rate by segment and size, by competitor, by source and by stage lost. This page gives the fields, the reason list, the tables, the interview questions for the few deals worth a conversation, and a copyable form.
17 Sept 20265 min read