How to Find Your Most Profitable Customers Using Sales Data
- In most product businesses, the top 20% of customers generate 60 to 80% of total profit
- How to calculate customer profitability from your existing data
- Identifying what your most profitable customers have in common
- What to do with your least profitable customers
- Using customer profitability data to redesign acquisition targeting
- Making customer profitability analysis a quarterly practice
In most small businesses, the top 20% of customers by profitability generate 60 to 80% of total profit. Identifying who those customers are, what they have in common, and how they were acquired lets you redesign your entire growth strategy around replicating them.
- In most product businesses, the top 20% of customers generate 60 to 80% of total profit
- How to calculate customer profitability from your existing data
- Identifying what your most profitable customers have in common
- What to do with your least profitable customers
- Using customer profitability data to redesign acquisition targeting
In most product businesses, the top 20% of customers generate 60 to 80% of total profit#
The 80/20 rule applied to customer profitability is one of the most consistent findings in small business analytics. It also has a corollary that most operators do not examine: the bottom 20% of customers by profitability frequently generate negative profit once service, return handling, and acquisition costs are accounted for. A business serving 500 customers may have 100 who are highly profitable, 300 who are marginally profitable, and 100 who cost more to serve than they generate. The marketing budget, customer service resources, and attention of the operator are typically spread relatively evenly across all 500. Redirecting disproportionate investment toward the top 20% and reducing investment in the bottom 20% — or actively replacing them — is one of the most consistently high-return strategic decisions in SME operations.
How to calculate customer profitability from your existing data#
Customer profitability requires four inputs per customer: total revenue (all orders, all time), cost of goods for those orders, acquisition cost (what did you spend to get this customer, attributed from your marketing data), and service cost (including returns, customer service interactions, and any discounts provided). For most small businesses, acquisition cost and service cost are not tracked at the individual customer level. Start with an approximation: use your average customer acquisition cost from a given channel as the acquisition cost for all customers from that channel, and multiply your average support cost per customer by the number of interactions for each customer. The result is an approximate but usable profitability ranking. The top and bottom quartiles will be clearly identifiable even with imprecise inputs.
Identifying what your most profitable customers have in common#
Once you have ranked your customers by profitability, analyse the top 20% for common characteristics. Which acquisition channel brought them in? If 60% of your most profitable customers came from Google Search and only 15% from Instagram, that is a budget reallocation signal. What was their first purchase? High-lifetime-value customers often share a common entry point product — identifying that product lets you feature it more prominently in acquisition campaigns. What geography are they in? High-profitability concentration in specific regions may justify market-specific campaigns or logistics investment. What is their purchase frequency pattern? Customers who make their second purchase within 30 days of their first tend to have significantly higher lifetime value than those who wait 90 days. Knowing this lets you design post-purchase sequences specifically targeted at accelerating the second purchase.
Data-backed guides on AI, eCommerce, and SME strategy — straight to your inbox.
What to do with your least profitable customers#
The bottom 20% of your customer base by profitability warrants a deliberate strategy rather than passive management. Start by identifying the primary driver of low profitability for each customer: is it high return rates, heavy discounting to acquire or retain them, high service costs, or simply low order volume and value? Each cause has a different response. High return rate customers may be attracted by product descriptions that do not accurately represent what they receive — fixing the description may resolve the issue. Discount-dependent customers may never be profitable at their natural price sensitivity — raising their effective price may reduce their order frequency but improve profitability per interaction. High service cost customers may be manageable through better self-service resources. Customers who are low volume and low margin with no growth trajectory are the candidates for disinvestment: reduce marketing spend directed at their segment and redirect it toward your top-20% profile.
Using customer profitability data to redesign acquisition targeting#
The most impactful application of customer profitability analysis is using your most profitable customer profiles as the targeting template for customer acquisition. If your top-profitability customers share characteristics — a specific acquisition channel, a first purchase product, a geographic concentration, a demographic profile — you can build lookalike audiences from those customers for paid advertising. You can bias your SEO content toward the search terms that high-value customers use. You can design your referral programme to incentivise your best customers to refer similar customers. And you can evaluate new customer acquisition channels by asking not just what they cost per customer but what type of customer they tend to produce — measured by profitability rather than volume. Over 12 months, this redesign shifts your customer mix toward higher-profitability segments and significantly improves your overall unit economics.
Making customer profitability analysis a quarterly practice#
Customer profitability rankings change over time. A highly profitable customer from six months ago may have increased their return rate or shifted to lower-margin products. A previously marginal customer may have expanded their purchase frequency as their trust in your brand grew. Running a quarterly customer profitability update takes two to three hours manually or can be automated if your sales, marketing spend, and service data are connected in an analytics tool. AskBiz can surface customer profitability rankings directly from your connected Shopify, Stripe, and Xero data on request. Ask: "Which customer segments had the highest net margin this quarter?" and receive a ranked output you can act on immediately. The analysis compounds in value each quarter as you build a longitudinal picture of how your customer mix is evolving.
AskBiz connects to your sales, marketing, and finance tools and shows you the KPIs that matter most at your stage — no data team needed.
Track your 10 most important startup metrics in one Google Sheet.
Our team combines expertise in data analytics, SME strategy, and AI tools to produce practical guides that help founders and operators make better business decisions.
Track the metrics that actually predict growth
AskBiz connects to your sales, marketing, and finance tools and shows you the KPIs that matter most at your stage — no data team needed.
Connects to Shopify, Xero, Amazon, QuickBooks, Stripe & more in minutes