What the overall picture misses
Totals reveal scale but can hide combinations of customers and products that explain performance. Looking at relationships provides a second perspective.
Imagine this business
An overall product ranking may not show that one customer buys nearly all units of a specialist product. That could be intentional or fragile; it needs investigation.
Investigate the intersections
A customer-product table can reveal specialised demand obscured by aggregate totals.
Respect missing coverage
Only make relationship statements when customer and product identifiers are sufficiently present and usable.
Two situations. Different implications.
Illustrative comparison — not actual customer data or a platform-calculated result.
| Measure | Customer A | Customer B |
|---|---|---|
| Basis | $500k annual purchases | $500k annual purchases |
| What's different? | 80% spent on one specialist product | Purchases spread across twenty products |
The same customer revenue hides a much narrower product mix for A. The implications depend on whether substitution or concentrated demand matters.
Team discussion: Sales and Commercial Analytics can explore product dependence, cross-selling and customer requirements.
Compare before you conclude
Compare total product revenue against customer-by-product revenue; inspect the share of a specialist item bought by one customer versus its share of total business.
Who could act on this?
Teams: Sales and Commercial Analytics.
Sales can assess account-specific product reliance; analysts check identifier coverage and intersections.
Ideas worth testing
Discuss substitutions and alternative ranges with specific customers; test cross-selling where needs support it.
Watch the trade-offs
Missing customer or product identifiers must not be treated as zero demand.
Now ask a better question
What does our customer × product view reveal that the overall list misses?
What should I consider?
Identify what the numbers establish, what they do not establish, and which additional evidence you need before acting. Make a note of one question to investigate.
Try this with your own data
Where to look in your diagnostic
Customer × Product Mix
Data needed: Customer ID + Product ID + Revenue.
What to investigate: Inspect customer-product relationships rather than relying solely on global totals.
Open the sample or run the free diagnostic, then find the named dashboard section. Sections appear only when your data supports them; some deeper investigation and exports require Professional access. Check Evidence & Coverage before drawing conclusions.
Numbers provide evidence. Good decisions require context and judgement. Treat this lesson as a starting point for investigation, not an instruction to change your business.