IGrowth & StrategyGuide

ABC Customer Analysis: Where Sales Effort Pays Off

In almost every business, a small group of customers carries most of the business. ABC analysis makes this distribution visible and answers the question of how much sales time each customer should get.

Old wooden cabinet with many small drawers
Photo: MChe Lee / Unsplash

Key takeaways

  • ABC analysis ranks customers by their contribution to the business and divides them into three classes. It rests on the Pareto principle: a few customers usually account for a large share of revenue.
  • Contribution margin is more meaningful than revenue, and adding potential turns the ranking into a tool for sales planning.
  • A study of 310 companies shows that prioritization raises average customer profitability without measurably harming relationships with less important customers (Homburg, Droll, and Totzek 2008).
  • C customers are not neglected but served more efficiently: with standards, fixed processes, and clear prices.

Why not every customer deserves the same sales time

Sales time is scarce in small businesses. The owner and two or three employees share visits, calls, quotes, and follow-ups. In practice, attention usually goes to whichever customer got in touch last. That is understandable, but random. A large customer with a quiet buyer can drop out of sight just as easily as a small customer with great potential.

This guide answers one question: How do you use an ABC analysis to find out which customers justify additional sales effort, and what follows for account care? To answer it, we first clarify the mental model behind the analysis, then work through it with a worked example, review what studies show about prioritizing customers, and finally derive rules for each customer class.

If you treat every customer the same, you treat the most important ones worse than they deserve.

What is an ABC analysis? The Pareto principle explained

The mental model behind ABC analysis is the Pareto principle. In the late 19th century, the Italian economist Vilfredo Pareto observed that a small part of the population owned a large part of the land. The quality researcher Joseph Juran later applied the observation to causes of defects and spoke of the “vital few” and the “useful many.” This became the well-known rule of thumb that about 20 percent of causes explain 80 percent of the effect.

The numbers 80 and 20 are not a law of nature but an image for an uneven distribution. In some businesses, 10 percent of customers account for 60 percent of revenue; in others, 30 percent account for 90 percent. ABC analysis measures this distribution for your own customer base and divides customers into three classes:

  • A customers: the small group that together carries most of the business, often around 70 to 80 percent.
  • B customers: a middle group with a middle share, often 15 to 20 percent.
  • C customers: the large number of customers with a small share, often 5 to 10 percent.

Each business sets the boundaries between the classes itself. What matters is to define them once and then keep them, so that changes can be compared over the years.

ABC analysis step by step: a worked example

A spreadsheet with revenue per customer from accounting or the CRM is enough for the analysis. How to make sure this data is correct is described in the guide CRM data quality.

  1. Pull the data

    Export revenue per customer for the last twelve months, better the last 24 months, so that individual large orders do not distort the picture.

  2. Sort in descending order

    Put the customer with the highest value at the top, then all others in falling order.

  3. Accumulate shares

    Calculate each customer’s share of the total and add the shares from top to bottom.

  4. Cut the classes

    Customers up to a 70 percent cumulative share are A, up to 90 percent B, the rest C.

  5. Check the result

    Does the picture match your gut feeling? Surprises are the most valuable part of the analysis.

An example business with freely chosen numbers has 200 active customers and 2 million euros in annual revenue. After sorting, it turns out that 20 customers account for 1.4 million euros, 50 customers for 400,000 euros, and 130 customers for 200,000 euros.

Share of customers and revenue per class in the example business with 200 customers and 2 million euros in revenue
  • A: share of customers10%
  • A: share of revenue70%
  • B: share of customers25%
  • B: share of revenue20%
  • C: share of customers65%
  • C: share of revenue10%

Worked example with freely chosen numbers. The actual distribution differs by business and industry.

In the example, average revenue per A customer is 70,000 euros, while a C customer brings just over 1,500 euros. If both receive the same number of visits and calls, the allocation of sales time is clearly off.

Revenue or contribution margin: what the ranking really shows

An ABC analysis by revenue is quick to do, but it can mislead. A customer with high revenue, high discounts, many special requests, and long payment terms may contribute less than a mid-sized customer who buys at list price. That is why a second pass with contribution margin pays off, meaning revenue minus the costs caused directly by the customer’s orders. How to determine it per customer is described by the Customer Value Staircase in the guide calculating customer lifetime value.

Lueg and Ilieva (2024) show in their case study of an industrial company that the effort of a more precise customer calculation pays off mainly where volumes are unevenly distributed and a lot of customer-specific effort arises. That is exactly the situation an ABC analysis reveals. A business with a very uneven distribution should therefore not stop at revenue.

The second addition is potential. ABC analysis looks backward. Today’s C customer may be a company that covers only a small part of its needs with you. That is why the value-potential grid from the guide key account management for mid-sized companies ranks customers by current value and future potential. Practice also combines criteria: in interviews with managers from 13 Slovenian exporting companies, Gracner, Cadogan, and Pfajfar (2025) found that priorities were set by product line, customer size, importance of the industry, and importance of the foreign market. Stormi, Lindholm, Laine, and colleagues (2020) extended the classic RFM analysis, which ranks customers by recency, frequency, and monetary value of purchases, at two machinery manufacturers with data on the installed machines to make service potential visible. Combined, the result is a simple matrix.

ABC class and potential read together
ClassHigh potentialLow potential
AKey account: account plan, several contacts, fixed rhythmRetain: secure quality, safeguard the relationship
BDevelop: targeted offers for further servicesMaintain: regular contact, standard offers
CTest: one or two expansion attempts a yearServe efficiently: standards, online ordering, minimum quantities

What research shows about customer prioritization

ABC analysis is only the first step. Whether it pays to treat customers differently accordingly was studied by Homburg, Droll, and Totzek (2008). They surveyed 310 companies from business and consumer markets across industries and checked the results against two further independent samples. In practice, the authors note, companies usually assign customers to tiers by actual or potential sales volume, similar to an ABC classification.

310Companies from various industries, B2B and B2C
2Independent samples for validation
3Objections to prioritization examined in the study

Source: Homburg, Droll, and Totzek (2008)

The result: prioritization led to higher average customer profitability and a higher return on sales. Two effects explain this. Relationships with the most important customers improved, while those with less important customers did not measurably worsen. At the same time, marketing and sales costs fell. The second finding is just as important: many companies want to prioritize but fail to implement it. Whether the strategy reached daily work depended on whether companies could assess customer profitability, how good their customer data was, and whether organization, leadership, and planning supported the distinction.

The limit of the study: it is based on surveys and mainly considers larger companies. For a business with 200 customers, implementation is easier because fewer people need to coordinate. Whether the effects are equally large there cannot be derived from the study.

Two readings: focus or neglect?

There are serious objections to prioritization, which Homburg, Droll, and Totzek (2008) summarize themselves. First, less important customers could become dissatisfied, defect, and speak badly of the business. Second, economies of scale could be lost if sales concentrates on a few customers. Third, a broad customer base offsets the risk of individual large relationships.

Two views of ABC analysis

Focus

  • Scarce sales time flows to where it achieves the most
  • Important customers experience noticeably better care
  • Sales costs per euro of revenue fall
  • Decisions about visits become traceable

Neglect

  • C customers feel treated as second class
  • Small customers with potential are overlooked
  • Dependence on a few A customers grows
  • The ranking explains the past, not the future

I consider both views justified, but not equally weighty. The findings suggest that well-implemented prioritization does not damage relationships with smaller customers. The objections mainly hit poorly implemented prioritization: when C customers are treated worse instead of served differently, and when potential is missing. The difference lies in the word “differently.” A C customer does not need a visit, but a quick answer, a reliable delivery date, and a clear invoice.

Setting sales effort per class

The analysis only becomes a tool when it changes the calendar. So define in writing for each class what care a customer there receives. The following rules are a starting point, not a template for every business.

Account care rules per customer class as a starting point
ClassContactResponsibilityQuotes
APersonal meeting at least quarterly, annual reviewFixed account manager, named deputyIndividual, with an eye on further needs
BContact twice a year, occasion from customer historyAccount manager within the teamBuilding blocks, adapted
CAs needed, newsletter, fast handling of inquiriesInside salesStandard prices and fixed packages

For implementation, the study by Homburg, Droll, and Totzek (2008) shows where prioritization fails: missing figures, poor customer data, and an organization that treats everyone the same. In a small business, this means: the class belongs in the CRM as a field, the contact rules are part of the weekly sales meeting, and the owner sticks to them too. How to grow A and B customers deliberately is described in the guide growing existing customers.

  • Each customer’s class is in the CRM and visible to the whole team.
  • For each class there are written rules for contact, responsibility, and quotes.
  • Every A customer has a named account manager and a deputy.
  • C customers get fast answers and clear standards instead of personal visits.
  • The analysis is repeated once a year, and customers moving up or down are discussed.

Conclusion: where sales effort pays off

To the guiding question: ABC analysis shows which small part of the customer base carries most of the business. Additional sales effort pays off where high current value, best measured as contribution margin, or high potential come together. For C customers without potential it does not pay off, but reliable, efficient service does. Research supports this distinction as long as it is implemented properly and small customers are served differently rather than worse.

  1. Export revenue per customer for the last 24 months and create the ranking with cumulative shares.
  2. Cut the classes at 70 and 90 percent and compare the result with your own assessment.
  3. Repeat the ranking with contribution margin and mark customers who change class.
  4. Define contact rules for each class and enter the classes in the CRM.

The analysis takes an afternoon. Its value shows only in the next quarter, when sales time no longer follows chance but a decision.

Frequently asked questions

What is an ABC customer analysis?

ABC analysis ranks customers by their contribution to revenue or contribution margin and divides them into three classes. A customers together carry most of the business; C customers are numerous but have a small share. From this, you derive how much care each customer receives.

How do I do an ABC analysis in Excel?

Sort customers in descending order of revenue, calculate each one’s share of total revenue, and add the shares from top to bottom. Customers up to a 70 percent cumulative share are A, up to 90 percent B, the rest C. You can adapt the boundaries to your business.

Which boundaries apply to A, B, and C customers?

Typical values are about 70 to 80 percent of revenue for A, 15 to 20 percent for B, and 5 to 10 percent for C. There are no fixed rules. What matters is keeping the chosen boundaries so that years can be compared.

Should you drop C customers?

Usually not. Together, C customers carry part of revenue, and some have potential. It makes sense to serve them more efficiently, for example with standard prices, fixed packages, and fast answers instead of personal visits. Customers with a persistently negative contribution margin are candidates for a price adjustment.

How often should you repeat the ABC analysis?

Once a year is enough for most businesses, ideally together with annual planning. Customers who change class are the most interesting, because they point to growth or beginning churn.

Sources

  1. Homburg, C.; Droll, M.; Totzek, D. (2008): Customer Prioritization: Does It Pay Off, and How Should It Be Implemented? Journal of Marketing, 72(5), 110-130.
  2. Lueg, R.; Ilieva, D. (2024): Customer Profitability Analysis in decision-making-The roles of customer characteristics, cost structures, and strategizing. PLoS ONE, 19(5), 1-25.
  3. Stormi, K.; Lindholm, A.; Laine, T. et al. (2020): RFM customer analysis for product-oriented services and service business development: an interventionist case study of two machinery manufacturers. Journal of Management & Governance, 24(3), 623-653.
  4. Gracner, M.; Cadogan, J. W.; Pfajfar, G. (2025): Customer Prioritization: From Conceptualization to International Application. Economic & Business Review, 27(2), 80-101.

All sources in the knowledge base

Reading room of a historic library with galleries, walls of books, and a skylight

Found a mistake or a topic that’s missing?

Feedback, corrections, and topic ideas go straight to the editorial team. We correct openly and with a date.