Visualizers · Visualizer

Customer Concentration Visualizer

See how dependent your revenue is on a handful of large customers, with a sorted Pareto chart of MRR by customer.

Customer MRR ($)

—

How It Works

Average revenue per customer hides a common and risky pattern: a small number of large accounts making up most of your MRR, with everyone else contributing comparatively little. If your two biggest customers together are close to half your revenue, losing either one is a very different event than losing an average customer — and a flat customer list or a single ARPU number won't show you that.

This visualizer sorts your customers by MRR and plots them as a Pareto chart, so concentration is visible at a glance instead of buried in a spreadsheet.

Enter each customer's name and MRR as its own row. Add or remove rows to match however many customers you want to include.

The chart sorts customers from highest to lowest MRR automatically — you don't need to sort your input.

Bars show each customer's MRR (left axis); the line shows cumulative percentage of total MRR as you move through customers left to right (right axis).

How to Read the Chart

  • The bars, tallest to shortest, show your revenue distribution — a few tall bars followed by a long tail of short ones is a concentrated customer base.
  • The cumulative line answers 'what share of my MRR comes from my top N customers' directly — find N on the x-axis and read the line's height at that point.
  • A cumulative line that reaches 80-90% within the first few customers signals high concentration; a line that climbs more gradually across many customers signals a more distributed base.

Example

Reading concentration from 8 customers

<built-in method values of dict object at 0x7caf1b810ac0>

Top 1 customer = 28.6% of total MRR · Top 5 customers = 87.9% of total MRR

Interpretation

  • A high Top-1 or Top-5 share means revenue continuity depends heavily on a small number of relationships — a single cancellation or a single renewal negotiation can materially move your total MRR.
  • This concentration is a factual property of the customer list you entered — it doesn't indicate whether any specific customer is at risk of churning.
  • Comparing this chart over time (re-entering an updated customer list periodically) shows whether concentration is increasing or decreasing as you grow.

Methodology

Customers are sorted by MRR in descending order. Cumulative percentage after customer i = (sum of MRR for customers 1 through i) ÷ total MRR × 100. Top 1 and Top 5 (or fewer, if you entered fewer than 5 customers) shares are computed the same way for exactly the top 1 and top 5 rows after sorting.

Limitations

This tool displays exactly the customers and MRR values you enter — it does not pull customer data from billing systems, does not track concentration over time automatically, and does not assess churn risk for any customer. Customer names are for your own reference only and aren't validated or deduplicated. Manual entry only in this version; CSV/file upload and export are not yet available.

Frequently Asked Questions

How many customers can I enter?

Up to 30 rows in this version. For a full customer base larger than that, consider entering your largest customers individually and grouping the remainder into a single 'Other' row.

Does this tell me if I'm too dependent on one customer?

It shows you the concentration number (for example, Top 1 = 28.6% of MRR) — this tool doesn't judge whether that level is too high for your specific business; that depends on your risk tolerance and contract terms.

Can I use this for ARR instead of MRR?

Yes — enter ARR figures instead of MRR in the same field. The Pareto math and percentages work identically regardless of which revenue unit you use, as long as you're consistent across all rows.

What if two customers have the same MRR?

They'll be sorted next to each other; the exact order between tied customers doesn't affect the cumulative percentage calculation.

Does removing a customer row also delete their data permanently?

It removes them from this chart. If you'd previously saved this page's data (via your browser), removing a row and not re-adding it means it won't reappear next time you load the page — there's no separate archive.

Want this tracked automatically from real data?

Connect Stripe in read-only mode and Dnoise tracks your SaaS metrics automatically every month.

Connect Stripe — free →
Back to Visualizers