What Is Revenue Concentration?
Revenue concentration is a business risk metric that measures how much of total revenue comes from a small number of customers — typically expressed as the share of revenue from the top 5 or top 10 accounts. High concentration means business continuity depends on a handful of relationships, which is a risk signal for investors and a strategic priority for customer success teams.
Upload your customer revenue export to Datamimi and get concentration analysis, HHI score, and top-account risk flags in one session.
Drop your file in and ask a question — no account needed.
Upload your spreadsheet.xlsx .xls .csv — free to try, no accountOr start with
What this export contains
| Customer ID |
| Customer Name |
| Annual Revenue |
| Contract Start |
| Contract End |
| Industry |
| Account Manager |
| Product Line |
What usually goes wrong with it
Top-N concentration calculation requires sorting and percentage computation
Measuring what share of total ARR comes from the top 10 customers requires sorting by Annual Revenue descending, summing the top 10, and dividing by total ARR — a multi-step process that many analysts do manually each quarter.
DataMimi Datamimi sorts by Annual Revenue, computes the top-N share, and calculates the Herfindahl-Hirschman Index (HHI) as a single concentration score for the full customer base.
Customer churn removes accounts from the denominator mid-year
If a top-10 customer churns in Q2, the concentration calculation for Q1 and Q2 will have different denominators — making trend comparison misleading without normalizing to a consistent base.
DataMimi It holds the denominator constant for trend comparisons, computing concentration on the customer set that was active at the start of each period.
Industry concentration is harder to measure than customer concentration
Identifying that 60% of revenue comes from financial services customers requires a consistent Industry column — which is often missing, inconsistent, or mapped differently across the CRM and billing system.
DataMimi It groups customers by Industry column and computes industry-level concentration, flagging inconsistently labeled industries for review.
Common questions
What is revenue concentration and why does it matter?
It measures how dependent a business is on a small number of customers for its total revenue. A company where the top 3 customers represent 60% of ARR has high concentration risk — losing any one of them materially impacts the business. Investors typically want no single customer above 10% of ARR and top 10 below 30%.
How do I calculate revenue concentration in a spreadsheet?
Sort customers by revenue descending. Sum the top 5 or top 10 customers' revenue. Divide by total revenue. For a more rigorous measure, compute the Herfindahl-Hirschman Index: sum of (each customer's revenue share squared). An HHI below 0.15 indicates low concentration; above 0.25 is high.
What is an acceptable level of customer revenue concentration?
As a general rule: no single customer above 10% of ARR, top 5 customers below 25%, and top 10 below 40%. These thresholds are not universal — a company with 5 large enterprise clients will have higher concentration than one with 5,000 SMB customers, and investors evaluate context alongside the raw figures.
What does Datamimi cost?
Free plan: $0/month, 40 credits, no credit card required. Lite: $9/month, 400 credits. Starter: $24/month, 1,500 credits, up to 3 simultaneous files. Pro: $59/month, 5,000 credits with rollover. Team: $199/month, 20,000 credits, 5 users.
Try it with your own file
DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.
Ask about your file