At a glance
Top customer accounts by revenue across B2B + B2C. Concentration analysis.
| What it counts | SUM(revenue) GROUP BY customer ORDER BY revenue DESC LIMIT 20. |
| Currency | Reporting ledger. |
| Time window | 90D |
| Roles | owner, finance |
Calculation
Calculated automatically from your Oracle ERP Cloud data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A US Fortune 500 retailer. 90D window. Top-20 customers represent 42% of revenue (400M). Concentrated mix of B2B wholesale + a handful of large enterprise accounts. Five things to notice:- Concentration risk: top 5 = 24% of revenue.
- Mix: 14 B2B + 6 enterprise B2C.
- Pair with churn signals.
- Per-channel view available.
- Historical trend in a customer’s rank tells the relationship story.
Sibling cards merchants should reference together
| Card | Why pair |
|---|---|
| Top B2B Accounts by Revenue | B2B subset. |
| Customer Churn Signals | Retention. |
Reconciling against the vendor’s own dashboard
Where to look in Oracle ERP Cloud:OTBI → Receivables Real Time rank by customerCross-connector reconciliation: CRM customer rank may align.