Blog · Topic
How much of each customer's spend you hold, by product, and how to compute it from your own data.
Value based segmentation groups customers by measured economic contribution under agreed cost rules. Build the account calculation, assign contribution bands, compare service costs and reconcile every group to the source totals.
Oct 19, 20266 min readDefine which clients belong in a cross-sell review before calculating line penetration. Keep unknown needs separate from confirmed gaps.
Oct 6, 20262 min readBuild a review-specific business case from quoted costs, internal effort and realized incremental contribution. Separate scenario upside from evidence and cash costs from staff time.
Oct 6, 20263 min readSeparate a single customer's wallet-share movement into changes in your category sales and changes in the customer's total category spend, with an exact ordered bridge.
Oct 6, 20263 min readMeasure the revenue and accounts represented by declared, inferred, stale and unknown wallet evidence. Publish coverage beside wallet share instead of hiding excluded customers.
Oct 6, 20263 min readTest lower, base and upper customer-wallet assumptions before choosing accounts to pursue. Separate stable priorities from rankings that depend on weak evidence.
Oct 6, 20263 min readEvaluate targeted account-growth outreach with a declared treatment and comparison population, a fixed observation window and reconciled outcomes. Separate outreach activity from incremental contribution.
Oct 6, 20263 min readChoose a feasible account-growth portfolio after reviewing eligibility, contribution and required selling effort. Compare constrained combinations instead of pursuing the largest gap alone.
Oct 6, 20263 min readExplain a book's wallet-share movement using a fixed account cohort and separate new and lost customers. Reconcile each step to sales and wallet totals.
Oct 6, 20263 min readEvaluate inferred category-spend estimates on customers withheld from the estimation process. Measure absolute error, bias and segment differences before expanding their use.
Oct 6, 20263 min readDefine comparable client peer groups and disclose small samples. Avoid turning a thin sector median into a confident client target.
Oct 3, 20263 min readUse a short customer survey to establish category spending, supplier spending and the boundaries behind both amounts. This guide supplies question wording, a response table and checks against invoiced sales without treating missing answers as zero.
Oct 3, 20266 min readRFM summarizes a customer's past buying behavior, while CLV estimates future contribution. Compare the same customer export both ways, see why rankings differ, and use each measure for the decisions it can support.
Sep 30, 20266 min readLabel confirmed external policies, client declarations and inferred gaps differently. Prevent uncertain evidence becoming a confident sales claim.
Sep 30, 20263 min readIncrease share of wallet through a measured account expansion workflow. Validate the customer wallet, qualify the gap, assign an action and review the resulting revenue and contribution.
Sep 19, 20266 min readThe honest answer to what realization rate a law, accounting or consulting firm should have: the 85 to 95 percent figures quoted depend on which realization is meant, billing realization against recorded time or collection realization 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.
Aug 27, 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.
Aug 27, 20263 min readThe honest answer to what share of contracted seats or licenses 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.
Aug 27, 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.
Aug 27, 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.
Aug 26, 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 program 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 program, 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.
Aug 19, 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.
Aug 16, 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.
Aug 13, 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.
Aug 9, 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.
Aug 9, 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.
Aug 7, 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.
Aug 7, 20263 min readHow a SaaS company turns the hand-colored 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.
Aug 7, 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 program. 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.
Aug 7, 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.
Aug 6, 20263 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.
Aug 5, 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.
Aug 2, 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 catalog 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.
Jul 31, 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.
Jul 31, 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.
Jul 30, 20262 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.
Jul 29, 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.
Jul 29, 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.
Jul 29, 20263 min readThe ten questions the president of a building materials distributor 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.
Jul 28, 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.
Jul 27, 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 standardized and this one has not, the value of standardizing at the system's own rate, and the clinical and contract conversation that follows.
Jul 27, 20262 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.
Jul 26, 20264 min readHow a business telecom 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.
Jul 26, 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.
Jul 26, 20263 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.
Jul 25, 20264 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.
Jul 25, 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.
Jul 25, 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.
Jul 25, 20263 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.
Jul 17, 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.
Jul 16, 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.
Jul 16, 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.
Jul 16, 20262 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.
Jul 15, 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.
Jul 13, 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.
Jul 12, 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.
Jul 11, 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.
Jul 9, 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.
Jul 9, 20263 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.
Jul 7, 20263 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.
Jul 7, 20263 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.
Jul 5, 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.
Jul 5, 20263 min readHow a sports organization 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.
Jul 3, 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.
Jul 3, 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 labeled as one.
Jul 3, 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.
Jul 3, 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.
Jul 1, 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.
Jul 1, 20263 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.
Jun 27, 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.
Jun 27, 20263 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.
Jun 27, 20264 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.
Jun 26, 20262 min readHow a building materials distributor or 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.
Jun 25, 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.
Jun 23, 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.
Jun 23, 20264 min readHow a building materials distributor 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 contractor, 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.
Jun 23, 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.
Jun 23, 20263 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 utilization per fixture from the CRM and ticketing exports, reconciled to commercial revenue.
Jun 21, 20263 min readHow 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 programs 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.
Jun 20, 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.
Jun 20, 20262 min readReview sales objections to an account-growth list without overwriting the evidence. Separate data errors, new constraints, missing buyer confirmation and unsupported preferences, then record an accountable decision.
Sep 23, 20204 min readFollow new-category purchases at existing customers through a comparable reorder window. Separate mature observations, recent first orders, trials and missing purchase history.
Nov 14, 20193 min readReview unresolved service issues and customer feedback before pursuing a wallet gap. Define account-specific recovery gates without treating incidents as proof of future churn.
Aug 29, 20173 min readCompare incremental contribution from a new category with concessions on purchases the customer already makes. Review the whole account basket before approving an expansion offer.
Apr 6, 20123 min readCompare purchase prices, freight, ordering effort and transition costs from the customer's perspective. Separate cash savings, released time and uncertain benefits.
Sep 15, 20083 min readExplain why a new product line can replace existing customer purchases rather than add demand. Reconcile product movement, account revenue and contribution before calling an expansion successful.
Jun 19, 20064 min read