Blog
Written for the desk that has to do it: what the measure is, the data you already hold, how to compute it, and where it goes wrong. 2652 articles across 33 industries.
The definitions and the arithmetic every other article leans on.
Coverage intelligence is the practice of measuring, from a company's own sales data, which customers it reaches, how much of each customer's spend it holds, and where the gaps are, with every figure reconciled to the ledger. This guide defines it, sets out its five measures, coverage, share of wallet, gap at norm, dormancy and concentration, shows how they roll up, and distinguishes it from BI, CRM reporting and sales analytics.
Aug 6, 20263 min readWhy pipeline, forecast and win rate all rest on whether anyone contacted the account, and how any B2B sales team measures coverage from CRM activity: untouched accounts, rep load, territory trend against plan, and the reconciliation to invoiced revenue.
Jun 26, 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 readThirty sales and commercial measures defined in one sentence each with the formula, grouped by what they describe: coverage and activity, wallet and depth, retention and churn, pipeline and forecast, concentration and reporting, and data quality. Each links to a full definition. Written so that a team can adopt the definitions as its own, version them, and stop arguing about what a number means.
Jul 22, 20264 min readEvery penetration, fit, share or whitespace figure needs a denominator: what a customer like this one usually buys. This guide sets out how to build that norm from your own customers by banding them on type and size, the majority rule, the minimum band size, and how to record overrides so the gap list stays credible.
Jul 5, 20263 min readThe four-level tree that every sales measure is summed through, the difference between a level and a dimension, the identity that must hold at each level, and the mapping decisions that make one hierarchy serve finance, sales operations and the salesperson at once.
Aug 4, 20263 min readThe one rule that makes AI analytics safe to put in front of a sales desk or a bank: the language model chooses the calculation and explains the result, and deterministic code computes every figure. Why the alternative fails, and what the rule changes in practice.
Aug 8, 20264 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 readCoverage is accounts touched at cadence over accounts assigned, and what a touch is, who the account is and what the cadence should be all change with the desk. This hub sets out, for twelve industries, the unit of account, the qualifying touch, the cadence a tier typically carries and the export the measure comes from, with a link to the full guide for each.
Jun 26, 20263 min readEvery gap on this site is measured against a norm from the company's own best customers of the same kind, and what the same kind means changes by desk: same menu type and covers, same size band and sector, same tenure band, same rig count, same property type and market. This hub gives, for twelve industries, the fields that define similar, the unit of size the norm scales by, the population the norm is drawn from, and the guide for each.
Aug 3, 20263 min readA hub for the role pages on this site: for each leader, from CFO and CRO to the head of a trading desk or a foodservice distributor, the ten questions they ask, the tables that answer them, the identity behind each, and the answer to send back. This page lists every role page with the desk it is written for and the first question on it, so a reader can find their own questions in one click.
Jul 21, 20264 min readA hub for the worked-example pages on this site: each core measure computed in full on a book small enough to check by hand, ten accounts, ten deals, ten invoice lines, five clients, four territories, with every intermediate figure shown and the identity at the end. This page lists them by measure with what each example demonstrates, so a reader can reproduce the arithmetic before running it on their own export.
Aug 28, 20268 min readA hub for the benchmark questions on this site: what is a good share of wallet, customer concentration, pipeline coverage, win rate, forecast accuracy, dormancy rate, account coverage, net revenue retention, renewal rate, seat utilization, quote conversion, OTIF, cost to serve, spend under management, realization and hit ratio. Each page gives the ranges people quote, says what those ranges assume, and sets out the three measurable things that decide the right figure for one business. This page lists them with the short answer to each.
Aug 21, 20263 min readA hub for the Excel guides on this site: how to calculate customer concentration, dormant customers, account coverage, win rate and pipeline coverage, forecast accuracy and bias, net revenue retention, renewal rate, quote conversion, OTIF and cost to serve in a spreadsheet, from exports a business already has. Each guide gives the columns needed, the exact formulas for Microsoft 365 and older Excel, the one check that proves the result, the usual spreadsheet mistakes, and the point at which the spreadsheet stops being enough.
Aug 20, 20264 min readA hub for the comparison pages on this site: churn and dormancy, win rate and close rate, pipeline coverage and weighted pipeline, OTIF and fill rate, gross margin and contribution, KPI and metric, leading and lagging indicators, concentration ratio and Herfindahl index, share of wallet and market share, renewal and retention, and more. Each page gives both definitions, computes both on the same rows, and says which to use when. This page lists them with the one-line difference for each.
Aug 23, 20264 min readA hub for the templates on this site: the weekly sales meeting agenda, the pipeline review, the forecast sheet with tested categories, the monthly sales report, the quarterly business review, the one-page account plan, the territory plan, the account handover checklist, the win-loss form and the lost customer review, plus dashboard examples for five readers. Each template is copyable, says which export each figure comes from, and is designed so that the document is mostly filled in before anyone sits down to write it.
Aug 23, 20263 min readA hub for the industry KPI pages on this site. For each of thirty-one industries and functions, from wholesale distribution and foodservice to commercial banking, law firms, freight, pharma, SaaS and sports, one page lists the ten measures that matter, each with its formula, the export it comes from and what it tells you, plus the three measures most teams in that industry miss, the figures to drop, the identity behind each table and who should own what. This page lists them all with the measure each industry most often overlooks.
Aug 16, 20265 min readTwenty analytics and AI tools grouped by what they are built for, what each needs before the first answer, and where a file-first approach fits.
Aug 28, 202623 min readEach hub collects every article on the subject, whichever industry it was written for.
The same measures in the vocabulary of one desk.
Newest first. The glossary has the definitions these lean on, and RSS has everything as it lands.
An accountability dashboard connects business results to targets, accountable owners, and dated corrective actions. Build it from a results export and an action register, then check which actions are overdue at a fixed reporting date.
Oct 25, 20265 min readAn accounts payable aging report groups unpaid supplier balances by how far they are past due. Build one from an open-invoice export, check the buckets and compare overdue amounts by vendor.
Oct 25, 20265 min readThe accounts receivable formula reconciles an opening customer balance to the closing ledger. Work through invoices, cash, credits, write-offs and adjustments, then bridge gross receivables to the net balance.
Oct 25, 20265 min readBuild an airline customer dashboard from booking records, refund entries, and customer history. This worked example separates repeat customers from booking frequency and reconciles customer revenue to its source rows.
Oct 25, 20266 min readAmazon marketing analytics compares advertising spend with sales, refunds, seller fees and product costs. Follow a seller-export reconciliation that separates attributed revenue from the contribution remaining on matched sales.
Oct 25, 20266 min readAverage resolution time divides total elapsed resolution hours by resolved cases. Calculate it from a support export, compare issue types and prove the company figure with a weighted check.
Oct 25, 20266 min readA business bank statement analysis report explains receipts, payments and the change in cash. Build it from transaction exports, remove internal transfers from consolidated activity and reconcile the result to the cash ledger.
Oct 25, 20265 min readBusiness data visualization makes trends, category mix and exceptions easier to compare. Use a worked revenue example to choose a chart, check its figures and connect the result to a business decision.
Oct 25, 20265 min readCall-to-action KPIs connect eligible views, clicks, completed forms, and qualified conversions. Use a worked campaign comparison to separate engagement from business value and check every denominator.
Oct 25, 20266 min readA cash drawer balance sheet compares expected cash with the physical closing count. Use this worksheet layout, worked denomination count, and deposit check to reconcile daily drawers and compare recurring shortages by location.
Oct 25, 20265 min readPrepare historical cash flow evidence that ties to your financial statements and bank records. Work through operating cash, capital spending, and existing and proposed debt payments without counting interest twice.
Oct 25, 20266 min readConnect invoice aging to actual receipts and expected collection dates. Use an invoice-level worksheet to reconcile balances, identify overdue amounts, and decide which collections need attention.
Oct 25, 20265 min readChurn management connects customer losses with evidence, review dates, and accountable owners. Follow a worked monthly review that reconciles customer counts, recurring revenue, and departure reasons.
Oct 25, 20265 min readGroup wealth-management relationships by service needs, assets, fees and recorded effort. Build a reconciled segment view from account, billing and activity exports, then use it to plan adviser capacity.
Oct 25, 20265 min readCMO analytics connects marketing spending with sourced opportunities and realized contribution. Build an executive review from campaign, CRM, and finance exports, with clear ownership, reconciliation checks, and limits on attribution claims.
Oct 25, 20266 min readCalculate manufacturing conversion cost per equivalent unit from direct labor, factory overhead, and production records. Work through a spreadsheet example, reconcile the assigned costs, and compare production periods on the same basis.
Oct 25, 20266 min readCompare a proposed supply chain change with baseline cash costs, implementation effort and measurable benefits. Build a spreadsheet appraisal, test the assumption that could change the decision and compare approved estimates with actual outcomes.
Oct 25, 20265 min readCompare channel spending with consistently defined leads, qualified leads, and won customers. This guide gives the export layout, spreadsheet formulas, worked channel table, and reconciliation checks.
Oct 25, 20266 min readCustomer lifetime value estimates the future contribution of one customer. Customer equity adds those estimates across a defined customer base, so portfolio size and customer mix matter alongside individual value.
Oct 25, 20265 min readConnect financial-services revenue, customer activity and operating costs in a business-line review. See a worked contribution example, the checks behind it and the decisions each owner makes.
Oct 25, 20265 min readMatch two business exports by a stable key and separate missing records from changed amounts. Use exact-match formulas, duplicate checks and a reconciliation that explains the full difference between the source totals.
Oct 25, 20266 min readDemand forecasting data starts with orders, shipments and stock availability at a consistent SKU and period. Use a worked example and spreadsheet checks to find missing history, duplicate rows and unexplained differences before accepting a forecast.
Oct 25, 20265 min readBuild a demand range from confirmed orders and explicit assumptions when usable sales history is missing. Keep a dated estimate, then compare it with initial orders and actual sales.
Oct 25, 20265 min readMeasure online banking activation, active usage and task completion from aggregate exports. Follow a worked channel comparison, exact spreadsheet formulas and reconciliation checks.
Oct 25, 20265 min readThe double moving average forecasting method uses two successive rolling averages to estimate a changing level and trend. Build it from an order export, reproduce the spreadsheet formulas, and compare forecasts with actuals and simpler benchmarks.
Oct 25, 20265 min readCompare late deliveries, returns, repeat contacts, and subsequent purchases from order exports. Build matched order cohorts, calculate contribution, and check the totals before choosing an improvement.
Oct 25, 20265 min readFirst response time measures the wait between a support request and the first qualifying reply. Calculate the mean, median, and target attainment from ticket timestamps while keeping unanswered tickets visible.
Oct 25, 20265 min readClassify fast-, slow- and nonmoving inventory from a stock snapshot and daily issue records. Set explicit thresholds, calculate movement frequency by SKU and site, and reconcile the class values to inventory.
Oct 25, 20265 min readBuild a human resources dashboard that compares staffing, turnover and workforce costs by department. A worked example reconciles employee movements, separates headcount from capacity and shows the spreadsheet formulas behind the totals.
Oct 25, 20265 min readIncremental profit measures the change in profit caused by a decision. Work through a proposed order, separate relevant costs from allocations, and reconcile the result to the operating statement.
Oct 25, 20266 min read