keymodels
Menu
FinanceKPI / metricModelAccessible

Customer profitability analytics

How should customer profitability analytics be measured and interpreted?

AccessibleStrategicIndividual3 min read
Contents

Customer profitability analytics is the process of identifying which of your customers are actually making you money.

Customer profitability analytics identifies the customers, segments, transactions and acquisition channels that actually contribute profit after their full cost to serve is recognised. Revenue alone can be deceptive: a high-spending account may consume so much support, fulfilment or sales effort that it destroys value. In many portfolios, profitability is highly concentrated in a pattern resembling the Pareto principle or 80/20 rule.

When to use it

Use this analysis continuously to understand where customer value is being created, and give it particular attention when revenue is falling, costs are rising or margins are under pressure. It can reveal whether the problem comes from customer mix, acquisition channels, service demands, pricing or operational cost.

Once customers are grouped by profitability, compare the characteristics of each group: location, first purchase, acquisition source, product mix, order frequency and service behaviour. If highly profitable customers originated from a particular magazine advertisement while loss-making customers came from a particular direct-mail list, future marketing investment can be redirected accordingly.

Because the method can work down to an individual deal or transaction, it creates a transparent basis for answering questions such as:

  • How do customers compare in profitability?
  • Which marketing initiatives create the strongest economic returns?
  • How do salespeople and regions compare?
  • What proportion of customers produces most of the profit?

Origins

Customer profitability analysis appeared in management-accounting discussions by the early 1960s, but it gained practical momentum with database marketing and the development of activity-based costing in the late 1980s. Activity-based costing made it possible to assign indirect costs to the customer activities that caused them, exposing a fact hidden by aggregate accounts: equal revenue does not mean equal profit. Banking was among the early adopters, and customer-level profitability later became a standard complement to customer-relationship and lifetime-value analysis.

What it is

A typical portfolio may contain 20 per cent of customers responsible for 80 per cent of profit and another 20 per cent responsible for 80 per cent of customer-related costs. These are not universal constants, but they illustrate why customer economics must be measured rather than inferred from sales.

Why it matters

Without a reliable distinction between customers who create profit and those who consume it, a business tends to offer everyone the same marketing, service and commercial terms. That uniform treatment can quietly reduce total profitability.

Segment-level results allow the business to vary its message and service model intelligently. The analysis connects buying habits with the costs of acquiring, supplying and supporting each customer. Managers can then protect profitable relationships, redesign the economics of costly ones and, where no viable improvement exists, stop subsidising customers that are better served by a competitor.

How to use it

Define the customer unit and analysis period first. Consolidate revenue, discounts, returns and direct product costs, then allocate acquisition, fulfilment, sales and support costs using defensible cost drivers. Rank customers or segments by contribution, inspect the drivers behind each result and test whether apparently weak economics are temporary or structural.

The method also applies where “profit” means efficient use of a constrained budget. In one NHS project, only 5 per cent of patients accounted for more than 200 accident-and-emergency visits. Identifying these super-users allowed the organisation to address their underlying needs through different support while freeing resources for other patients.

The same logic helps broadband providers identify customers whose use of an unlimited plan makes the relationship uneconomic. Regression analysis (Regression Analysis), correlation analysis (Correlation Analysis) and data mining (Data Mining) can help identify the characteristics associated with different profitability groups.

  1. Part Thre e : Financial analytics

Practical example

Although customer profitability analytics have been used since at least the early 1980s, many organisations still do not exploit the insight available in their own records.

Consider an electronic-parts supplier with 10,000 historical customers. Treat the analysis as a customer-level profit-and-loss statement: combine contribution with the cost of sales effort, delivery, returns and after-sales service, then rank the 10,000 customers in bands from the top 10 per cent to the bottom 10 per cent. A frequently purchasing account may appear attractive to the sales team yet prove loss-making once repeated questions, complaints and delivery interventions are costed. The result does not automatically justify ending the relationship; it identifies the operational or commercial terms that must change.

Top practical tip

Assess profitability across the customer’s complete relationship and expected lifetime. When systems treat a person who buys five products as five unrelated customers, each product view can look weak even though the combined relationship is highly profitable. Resolve customer identities before acting on the result.

Top pitfall

Do not leave customer profitability inside the finance function. Finance understands cost allocation, while sales, service and operations understand the behaviours that create those costs. Their combined interpretation is what turns the metric into sound pricing, service and marketing decisions.

Further reading

To learn more about customer profitability analytics see for example:

  • Pfeifer, P.W. and Farris, P.E. (2009) Customer Profitability, Charlottesville, VA: Darden Business Publishing
  • Reich, K.E. (1985) Customer Profitability Analysis: A Tool for Improving Bank Profits, 2nd edition, Chicago, IL: Probus Professional Publishing
  • http://www.xlcubed.com/solutions/analytical-applications/20-customerprofitability-analytics
  • https://www.accenture.com/bw-en/insight-determining-customerprofitability-banking-summary.aspx
  • http://office.microsoft.com/en-us/templates/customer-profitability-analysis- TC001150736.aspx
  • http://blog.visibleequity.com/customer-profitability-analytics/
  1. Part Three : Financial analytics