Customer profitability analysis: do your biggest customers earn strong margins?
Customer profitability analysis looks beyond sales size. When customer revenue and recorded costs are available, it compares the margin dollars and margin rate associated with each customer. It does not automatically measure every cost of serving that customer.
Start with what the data supports
Customer ID and Revenue support concentration and Revenue ABC. Add Total Cost to calculate recorded Margin and Margin %. A lower margin rate is a reason to investigate, not proof that an account is unprofitable. If cost coverage is incomplete, the result must carry that limitation.
Worked example from the demo diagnostic
The checked-in Demo Business golden margin fixture records customer 148000 with $1.4m revenue, $457k recorded margin and a 32.4% margin rate. The overall business margin is 38.4%, so the customer margin rate is 6.0 percentage points lower. This is a point for investigation, not a judgement of performance. The customer contributes substantial positive margin dollars while its rate is below the overall rate; neither figure measures unrecorded service costs. Values are rounded for display.
Why product mix and ordering activity matter
The customer may buy products with a different recorded cost mix. If Order ID is available, Order Intensity = Order Share ÷ Revenue Share can show activity out of proportion to revenue. Order Intensity is not a cost-to-serve figure. Dependency evidence may also show reliance on important relationships.
What would you check before taking action?
Review recorded cost coverage, the products purchased and the pattern of orders. Use the sample diagnostic to see how the Four-Lens approach supports investigation; use the Free Diagnostic for your own data without uploading it to our servers.
Compare the evidence
| Demo evidence | Result | How to interpret |
|---|---|---|
| Customer 148000 revenue | $1.4m | Commercial size |
| Customer recorded margin | $457k | Revenue less recorded cost |
| Customer margin rate | 32.4% | Recorded margin divided by customer revenue |
| Overall business margin % | 38.4% | Business-wide reference, not a target or full cost-to-serve measure |