Blog · Topic
How much of each customer's spend you hold, by product, and how to compute it from your own data.
How an education provider reads its base by first-purchase cohort, from the order history: the institutions that first bought in each year, how many are still customers, what programmes they hold now against what the cohort held at first purchase, the cohorts that expanded and the cohort that stalled, and why a cohort view finds the year something changed in onboarding or product that the renewal rate never explains.
16 Sept 20262 min readHow an industrial manufacturer measures aftermarket capture per customer from the installed base register and the parts and service ledger: expected annual aftermarket per unit from the customers who buy it all from the OEM, actual per customer, the attach rate, and the list of customers running the OEM's equipment on someone else's parts, ranked by the revenue at norm.
16 Sept 20262 min readHow a club, league or venue measures which commercial assets each partner buys against the profile of partners like them, watches hospitality renewals with no contact, and tracks box and seat utilisation per fixture from the CRM and ticketing exports, reconciled to commercial revenue.
16 Sept 20263 min readA method for industrial and component manufacturers to measure, per customer, the product lines bought against the lines customers of that type buy, value the gap, keep direct and distributor channels from double counting, and reconcile to shipped revenue.
16 Sept 20263 min readHow an industrial, MRO or building products distributor measures category penetration per account and finds dormant accounts per branch from the ERP's invoiced sales: the norm from your own accounts, the valued gap, the dormancy window, and the roll-up that reconciles to invoiced sales.
16 Sept 20264 min readHow a builders' merchant measures each trade account's category basket against the norm for its trade rather than against the branch average: the categories a plumber's account typically buys and at what share, the same for an electrician, a general builder, a roofer, the accounts below their trade's norm in a category they should buy, the value at norm, and why the trade field on the account master is the most valuable column the branch never fills in.
16 Sept 20263 min readWhy a foodservice distributor needs category share at the chain and at the site, how the two disagree and what each disagreement means, the roll-up that produces both from one delivery ledger, and the two lists the sales team works from: chain gaps for the national account manager and site gaps for the route rep.
16 Sept 20263 min readHow a merchant or building materials manufacturer measures share of each contractor's spend by category from the trade ledger: categories bought against the norm, lapsed trade accounts per branch, an optional project overlay, and the reconciliation to invoiced sales.
16 Sept 20263 min readHow a hotel group's sales team measures production against negotiated corporate rate agreements from the reservation export: room nights consumed per account per property against the volume the agreement was priced on, the accounts under-producing and the properties they are not using, the accounts over-producing whose rate is now too low, and the list for the annual RFP season.
16 Sept 20262 min readHow a consulting or advisory firm measures which practices each client buys against the practices similar clients buy, values the gap at the firm's rates, watches partner concentration, and reconciles the book by partner to billed fees, from the practice management export alone.
16 Sept 20263 min readThe difference between cross-sell and upsell, how each is computed from the ledger, cross-sell as new product lines at an existing customer and upsell as more of a line already bought, the norm each is measured against, the two lists they produce, and why blending them into one expansion figure hides which of the two a team is good at.
16 Sept 20262 min readHow a commercial bank measures cross-sell per client and per relationship manager from the ledger: the products each client holds, what clients of that sector and size usually hold, the valued gap, and the roll-up that reconciles to the ledger so finance signs it once.
16 Sept 20264 min readHow an accounting firm finds the clients paying well below what similar clients pay for the same services, from the fee ledger and the client master: fee per client per service line, the norm from clients of the same size and complexity, the gap valued, the partners whose books sit lowest, and why the fix is a scoping conversation at the next engagement letter rather than an across-the-board increase.
16 Sept 20263 min readHow an investment bank's coverage group estimates each client's total fee wallet across products from deal data and its own fee ledger, computes the bank's share per client per product, sets the expected share from clients where the bank is a lead relationship, and ranks the clients whose wallet is largest and whose share is lowest, with the product where the gap sits.
16 Sept 20263 min readHow a sports organisation measures the path from its ticketing base to its hospitality and membership products, from the ticketing and hospitality ledgers joined on the customer: season ticket holders who have bought hospitality once, the ones who bought and did not return, the ones who fit the profile of hospitality buyers and were never offered it, the value at the norm of similar members, and the list per fixture of who to invite.
16 Sept 20262 min readHow a medical device, supplies or services company builds one view per hospital from distributor tracings, GPO reports and direct sales: product lines bought against the facility's profile, contracts signed but unused, territory coverage per manager, and the reconciliation to traced and invoiced sales.
16 Sept 20263 min readHow a wealth management firm estimates each client's total investable assets and the share it holds, from the financial plan, the fact-find and the firm's own client base: the held-away figure per client with its source and date, the share of wallet that follows, the clients with the largest held-away balances whose plan the firm already writes, and the rule that keeps an estimate labelled as one.
16 Sept 20263 min readHow a sell-side desk computes hit ratio and flow share per client and product from its own RFQ logs and blotter, why the two numbers must be read together, and the three drifts that predict a client is leaving before the revenue shows it.
16 Sept 20264 min readA working method for share of wallet in asset management distribution: what counts as the wallet, which rows you need from your own systems, the roll-up level by level, and the three places the number usually goes wrong.
16 Sept 20264 min readThe share of wallet formula, the three ways to estimate the denominator when the customer will not tell you, a worked example from a real-shaped ledger, the roll-up from customer to segment to company, and the four mistakes that make the number wrong: mixing periods, counting one-off purchases, using a benchmark as the wallet, and reporting a share with no gap value beside it.
16 Sept 20263 min readA rep has a gap list that says a customer spends a third of what similar customers do on a line. What they say in the room decides whether the number helps or offends. This guide sets out what the gap is evidence of and what it is not, the framing that works, similar customers, their basket, the customer's own trend, the questions the rep asks before proposing anything, the data the rep should never show, and three worked conversations.
16 Sept 20262 min readA reading guide for a share of wallet table: which columns are facts from the ledger, revenue and the norm, which is an estimate, the wallet and therefore the share, how the source column changes what the share is worth, why to sort by gap value rather than by share, the ceiling column that stops a rep chasing the impossible, the trend that outranks the level, and the row to act on first.
16 Sept 20262 min readA reading guide for an account-by-product whitespace grid: why most empty cells are not whitespace, the norm penetration row that says which columns are expected, the three kinds of empty cell and the shading that marks them, why returning lines come first, the value column that ranks the rows, the cannot-buy cells to ignore, and the cell to act on first: the largest expected empty with a returning-line history.
16 Sept 20263 min readHow a freight broker or 3PL measures lane share per shipper from the TMS: loads won against loads tendered by lane, rep coverage against quotes logged, and the reconciliation to invoiced loads that makes the sales list trustworthy.
16 Sept 20263 min readHow a commercial bank finds the borrowers who hold a loan and nothing else, from the loan book and the deposit and product ledgers joined on the customer identifier, values each by the deposits and fees similar full-relationship customers hold, ranks them per relationship manager, and separates the ones worth a conversation from the ones who bank elsewhere by design.
16 Sept 20263 min readHow a foodservice distributor estimates each kitchen's expected category basket from its menu type and covers rather than from the segment average: the basket norm per menu type from the distributor's own fully-supplied kitchens, the categories a kitchen of that type buys that this one does not, and the gap valued, so the route rep's list says which categories to ask about at which door.
16 Sept 20263 min readWhy an asset manager's distribution team should read assets and net flows per client side by side: the four quadrants they produce, how to compute net flows by client and strategy from subscriptions and redemptions without netting away a switch, and the quarterly list each quadrant becomes.
16 Sept 20263 min readHow a bank, insurer, payments or fintech firm selling to businesses joins its product ledgers on the customer identifier to see product depth per customer against the segment norm, segment movement by product, team coverage, and a roll-up that ties to the ledger.
16 Sept 20263 min readA method for commercial brokers to measure placement share per client from the policy system: lines placed with the broker against lines the client holds, the renewal watch by producer, and the premium reconciliation that makes the book tie to the ledger.
16 Sept 20263 min readHow a law firm measures, from the practice management export alone, which practice areas each client instructs against the norm for clients like them, which long-standing clients have gone quiet, and how referrals flow between partners, reconciled to billed fees and without exposing any partner's book to another.
16 Sept 20263 min readHow a distributor measures the share of each account's purchases that are its own private label against branded equivalents, from the invoice lines and the product master: penetration per account per category, the margin difference per line, the norm from accounts of the same type, the accounts buying branded where similar accounts buy own label and the value of the switch, and the identity that keeps own-label and branded revenue summing to the ledger.
16 Sept 20262 min readHow to compute products per customer from a sales or holdings ledger, why the raw average misleads, how to set the norm per segment from the customers who buy most, the gap per customer that comes out, the roll-up per rep and region, and the three mistakes: counting SKUs as products, mixing segments, and using a competitor's figure as the target.
16 Sept 20262 min readHow a hotel group measures share of each corporate account by property: nights booked at your properties against the account's travel footprint, segment mix per property, sales manager coverage against accounts assigned, and the reconciliation to room revenue.
16 Sept 20263 min readHow an accounting or tax practice measures which service lines each client uses against the norm for clients like them, values the advisory gap, and builds a season watch of clients with a filing deadline in the window and no engagement opened, reconciled to billed fees.
16 Sept 20263 min readShare of wallet is one formula and twelve different denominators. This hub sets out, for twelve industries, what the customer's wallet is, where the number comes from, what the numerator is in that industry's ledger, and the natural ceiling a share can reach, with a link to the full guide for each. Written for a commercial leader who has heard the term and wants to know what it means for their desk.
16 Sept 20263 min readThe complete share of wallet calculation on ten customers small enough to check by hand: the ledger revenue, the size measure, the three main-supplier customers the norm is drawn from, the norm per site, the wallet per customer with its source, the share, the gap, the ceiling, the roll-up weighted by wallet against the average of shares, and the identity, so a reader can reproduce every figure and then run it on their own export.
16 Sept 20263 min readThe difference between share of wallet and market share, when each is the right measure, why a company can grow market share while losing wallet share at its largest customers, how each is computed and what each needs, and the one situation in which they converge.
16 Sept 20263 min readHow a business telecoms or connectivity provider measures wallet share by site rather than by logo: sites on-net against the customer's estate, product attach per site against the norm, account manager load, and the reconciliation to billed revenue.
16 Sept 20263 min readWhy a trading desk's hit ratio should be weighted by ticket size as well as counted, how the two diverge when a competitor commits balance sheet, the computation from the RFQ log, and a worked example where a rising count-weighted ratio masks a falling share of volume.
16 Sept 20263 min readWhy lane share means different things on contracted and spot freight, how to carry the flag from the TMS, the two lists it produces per shipper, and the mistakes that follow when a broker reads a low share on a contract lane as a sales problem.
16 Sept 20263 min readHow a medical supplies company finds the health systems and facilities buying the same clinical category from several suppliers, from its own invoice lines and the category's known competitors: brand count per category per facility, the supplier's share within the category, the systems where sister facilities have standardised and this one has not, the value of standardising at the system's own rate, and the clinical and contract conversation that follows.
16 Sept 20262 min readThe ten questions the managing director of a builders' merchant puts to the branch managers, which trade accounts buy below their trade's norm, which accounts were opened and never used, which good payers are stuck at their credit limit, which contractors won projects nearby and have no account, which accounts lapsed against their own cadence, what is category share per branch, which branches have not typed their accounts, which counter customers deserve an account, what is contribution per account after drops and returns, and what changed, each with the table from the ledger, the account master, the credit file and the project data, and the answer to send back.
16 Sept 20263 min readThe ten questions a consumer goods commercial director puts to the sales and trade marketing teams, where are the distribution voids, which stores stopped selling a SKU on a Tuesday, which promotions moved volume and which moved it forward, which retailers are building inventory in the channel, which chargebacks are disputable, what is range penetration by channel, which accounts are under the range norm, what is the weekly gap list per store, what did trade spend buy per net unit, and what changed, each with the table from the sell-out, shipment and deduction files, and the answer to send back.
16 Sept 20263 min readThe ten questions a distributor's commercial director puts to the branch and sales managers, which accounts are dormant and worth what, which branches leak category share, which accounts earn least after cost to serve, which take too many drops, which lines were lost to stock-outs, where is private label under-penetrated, which reps cover their books, what are the unagreed discounts, which counter customers deserve an account, and what changed, each with the table from the invoice lines and the delivery log, and the answer to send back.
16 Sept 20263 min readThe ten questions the president of a foodservice distributor puts to the route and national account teams, which kitchens dropped a delivery day, which chain sites are off the agreement while the chain looks compliant, what should each kitchen be ordering given its menu, which order guides are stale, which deliveries landed during service, which accounts take a drop a day for a small order, which kitchens are dormant against their own cadence, what is contribution per account after drops, which chains are under-penetrated by site, and what changed, each with the table from the delivery ledger, the site master and the proof-of-delivery data, and the answer to send back.
16 Sept 20263 min readThe ten questions a head of commercial banking puts to the relationship managers, which borrowers hold nothing but the loan, whose balances are leaving before the customer does, which facilities are drawn to the limit and which are paid for and unused, which customers hold fewer products than their sector peers, which lines refer and which only receive, which relationship managers can carry their gap list, which customers moved segment, who has not been contacted at cadence, which products are opened and never used, and what changed, each with the table from the loan book, the balances and the CRM, and the answer to send back.
16 Sept 20262 min readThe ten questions a vice president of aftermarket at an industrial manufacturer puts to the service and parts teams, which customers run our equipment on someone else's parts, which units come off warranty next quarter with no contract offer, is the installed base register complete, which batches are claiming above the model's rate, which customers claim above the norm across batches, which quotes convert and which are price checks, which distributors and direct accounts double count, what is catalogue fit per customer, which service contracts renew with a bad claims history, and what changed, each with the table from the installed base register, the claims file and the ledger, and the answer to send back.
16 Sept 20263 min readThe ten questions a vice president of sales at a medical device or supplies company puts to the account and contract teams, which systems are on contract and off compliance, which facilities buy three brands where their sisters buy one, which ship-tos are not mapped to a facility, which invoices are off the contracted price in either direction, which agreements expire with no review, what is product depth per facility against the norm, which reps cover their facilities, which systems' tier earned exceeds their tier on, what is the GPO mix of revenue, and what changed, each with the table from the order lines, the facility masters and the agreement register, and the answer to send back.
16 Sept 20263 min readHow a financial services firm reads product depth against relationship tenure, from the customer master and the holdings: products used by tenure band, the depth a customer of each tenure typically reaches, the long-tenure customers well below it, why they are the cheapest cross-sell in the base and the most likely to be assumed fully served, and the list per relationship manager ranked by the gap.
16 Sept 20262 min readHow a forwarder or carrier measures share per customer and trade lane from the booking system: TEU or chargeable weight won against the customer's total on the lane, office coverage against quotes logged, and the reconciliation to invoiced volume.
16 Sept 20263 min readWhy there is no universal good share of wallet, the three things that set the right target for a customer, the share the company holds with customers like it, the category's natural concentration, and the customer's own trend, how to compute each from the ledger, and the two-line rule that says when a share is good enough to stop chasing and when it is not.
16 Sept 20263 min readA step-by-step method for whitespace analysis: the account-by-product grid from the ledger, the norm per segment that says which empty cells matter, the value per cell, the roll-up per rep, the identity that keeps the total honest, and the three reasons a cell is empty that decide whether it is an opportunity at all.
16 Sept 20263 min readWhy whitespace and share of wallet describe the same customer gap from two directions, whitespace by product line from the grid and share of wallet by total spend from the wallet, when each is the right measure, whitespace for the conversation about which line and share for the conversation about how much, how they reconcile, the case where they disagree and what it means, and the rule that a report shows both with the same norm behind each.
16 Sept 20263 min readHow a SaaS company turns the hand-coloured whitespace spreadsheet into a computed, valued list per account: fit from what similar customers own, the gap at list price, untouched accounts from CRM activity, AE capacity, and the reconciliation to ARR.
16 Sept 20263 min readWhitespace is an account-by-product grid with empty cells that similar accounts have filled, and what the product is changes by desk: a category, a practice, a policy line, a strategy, a service line, a site, a programme. This hub gives, for twelve industries, the rows and columns of the grid, what makes an empty cell count, how it is valued, and the guide for each.
16 Sept 20263 min readThe complete aftermarket attach calculation on five customers, small enough to check by hand: installed units by model and age band from the register, the norm per unit per year from the two customers with every unit under contract, expected aftermarket per customer, actual parts and service revenue from the ledger, attach and gap, the register check against units shipped that finds a customer whose expected figure is understated, and the identity that actual sums to the ledger, so a reader can reproduce every figure and then run it on their own register and ledger.
17 Sept 20263 min readThe complete category share by trade calculation on five trade accounts at one branch, small enough to check by hand: each account's spend by category from the ledger, its trade from the master, confirmed or inferred, the trade norm per category from the full-supply accounts of that trade, norm penetration, category share against the norm, the gap per category valued at the account's spend, the untyped account excluded and counted, and the assertion that category spend sums to the ledger, so a reader can reproduce every figure and then run it on their own ledger and account master.
17 Sept 20263 min readThe complete held-away and share of wallet calculation on five wealth clients, small enough to check by hand: assets here from the custody record, the held-away figure from a fact-find with its date or estimated from the norm, the source grade per client, the stale fact-find that is treated as an estimate, total investable, share of wallet, the consolidation list of clients whose plan the firm writes, the norm from the two fully-held clients of similar profile, and the assertion that assets here sum to the custody ledger, so a reader can reproduce every figure and then run it on their own client master.
17 Sept 20263 min readThe complete lending-only relationship calculation on five borrowers, small enough to check by hand: the loan book with origination type, the deposit ledger and product holdings joined on the customer identifier, the lending-only test, the syndicate participation and the acquired portfolio flagged, the norm from the two full-relationship borrowers of the same size and sector, the value at norm for the lending-only borrowers, and the assertion that every borrower is in the master, so a reader can reproduce every figure and then run it on their own loan book and deposit ledger.
17 Sept 20263 min readThe complete placement share calculation on five commercial insurance clients, small enough to check by hand: the lines placed with the broker and their premium, the lines each client places at all from its stated programme or the sector norm, placement share by count and by premium, the lines placed elsewhere with their estimated premium, the source column, the ceiling from clients where the broker holds the whole programme, and the identity that placed premium sums to the ledger, so a reader can reproduce every figure and then run it on their own placement ledger.
17 Sept 20263 min readThe honest answer to what net revenue retention a company should have: the widely quoted 100 percent floor and 120 percent aspiration are SaaS investor figures that depend on segment, contract structure and what is counted as expansion. This page gives the ranges by segment, the three measurable things that set the right figure for one base, the cohort, the gross retention underneath, and the expansion source, and the table to compute before anyone quotes a percentage.
17 Sept 20263 min readThe honest answer to what realisation rate a law, accounting or consulting firm should have: the 85 to 95 percent figures quoted depend on which realisation is meant, billing realisation against recorded time or collection realisation against billed, on the rate card the time was valued at, and on the client and matter mix. This page gives the ranges by firm type, the three measurable things that set the right figure for one firm, and the table to compute before anyone quotes a percentage.
17 Sept 20263 min readThe honest answer to what renewal rate a contract business should have: the 85 to 95 percent figures commonly quoted depend on whether the rate is by contract count or by value, on what is done with contracts that renewed late or at a reduced scope, and on the mix of renewal cohorts by age. This page gives the ranges by desk, the three measurable things that set the right figure for one base, and the table to compute before anyone quotes a percentage.
17 Sept 20263 min readThe honest answer to what share of contracted seats or licences should be in use: the 70 to 85 percent figures quoted depend on what active means, on the time since the contract started, and on how use is spread across the account, because a customer at 80 percent with all use in one team is a different renewal from one at 60 percent spread across five. This page gives the ranges, the three measurable things that set the right figure for one base, and the table to compute before anyone quotes a percentage.
17 Sept 20263 min readThe complete whitespace calculation on a grid of ten accounts by five product lines, small enough to check by hand: the filled cells from the ledger, the norm penetration and median spend per line from the accounts that hold each, which empty cells are expected, which are returning lines, which cannot be bought, the value per cell, the value per account, the roll-up and the identity, so a reader can reproduce every figure and then run it on their own export.
17 Sept 20263 min read