What you’ll need
One more column on every account: its tier.
| Accounts | Share of accounts | Net new revenue | Share of revenue | Per account | |
|---|---|---|---|---|---|
| Tier A | 122 | 3.8% | $1,637.3K | 39.4% | $13,420 |
| Tier B | 407 | 12.5% | $1,340.3K | 32.2% | $3,293 |
| Tier C | 922 | 28.4% | $779.3K | 18.7% | $845 |
| Tier D | 1,777 | 54.7% | $402.5K | 9.7% | $227 |
| Not billing yet | 22 | 0.7% | $0.0K | 0.0% | |
| All new accounts | 3,250 | 100% | $4,159.3K | 100% | $1,280 |
Tiers are Power Law Nested Means on monthly volume: split the book at the average, then split each half at its own average. Each account keeps the best tier it has reached.
Sample data: an invented payments portfolio, no client data.