Understanding Customer Value

Overview

Bicycle shops often stay busy, but profit can still feel hard to grow. Sales happen every day, yet it is not always clear which customers truly keep the business healthy and which ones simply create work. This analysis looks at existing customers to understand where profit really comes from and whether the shop is relying too heavily on a small group of buyers.

The purpose of this report is to help shop owners decide where to focus their time and effort. It shows which customers are worth keeping close, which ones can be developed further, and which ones should not receive extra attention. The goal is to build more stable, long-term profit by managing the right customers better, rather than simply trying to sell more.

Data Sources and Methodology

This analysis uses sales records from a bicycle shop, covering about 18,400 customers and more than 60,000 sales lines. The data shows what customers bought, how often they returned, and how much profit they generated over time, allowing us to understand customer value from the shop owner's point of view rather than short-term sales activity.

We focused on simple customer measures such as total profit, number of purchases, average order value, how long customers stayed active, and customer lifetime value based on actual profit. The data spans multiple years, so the analysis reflects long-term customer behavior and helps identify which customers matter most and how they should be managed differently.

1. How many active customers do we actually have, and how often do they buy?

The shop has 18,400 active customers, but most of them buy very little. Around 63% bought only once, and another 36% bought two to three times. Fewer than 2% of customers returned four times or more, showing that strong repeat buying is rare.

This means the shop's activity is driven mainly by one-off and casual buyers, not long-term customer relationships. A busy shop or a high number of transactions does not automatically mean customers are loyal or returning consistently.

From a business point of view, this creates risk. If nothing changes, the shop will continue to depend on new customers, leading to higher effort, less predictable income, and limited long-term growth.

2. How uneven is customer contribution to revenue and profit?

Customer contribution to profit is very uneven. A small group of customers generates a large share of total profit, while most customers contribute very little on their own. After the top group, adding more customers increases profit only slightly.

This shows the business is financially dependent on a narrow group of customers. If a few high-profit customers buy less or stop coming, profit would drop sharply even if customer numbers remain high.

The key message is simple: volume does not equal value. The shop may look busy, but profit is fragile if it relies on too few customers without actively protecting them.

3. Which customers generate the highest total profit over their lifetime with the shop?

Customers in the high-CLV group generate almost all of the shop's profit. They contribute about 10.6 million in profit, compared with 1.4 million from medium-CLV customers and just 0.12 million from low-CLV customers. The gap is very large, not marginal.

Even though high-CLV customers are fewer in number, they clearly carry the business financially. Losing a small number of them would hurt profit far more than losing many low-value customers.

Medium-CLV customers matter, but they cannot sustain the shop on their own. They represent the best opportunity for growth, while low-CLV customers create activity without meaningfully supporting profit.

4. What differentiates high-CLV customers from the rest?

High-CLV customers are valuable not because they buy often, but because they buy well. Their purchase frequency is low, yet they generate far more profit than other customers.

Medium- and low-CLV customers buy much more frequently, but their purchases tend to be small and low-margin. High activity creates work, not value. Frequent transactions do not automatically lead to strong profit.

The real difference lies in profit per order and purchase quality. High-CLV customers tend to make fewer but more meaningful purchases, such as complete bikes or premium upgrades. They are quiet, efficient, and often overlooked until they are gone.

5. Are there distinct customer groups with clearly different buying behaviours and value patterns?

Yes, very clearly. Customers do not behave as one group. They fall into distinct groups that differ strongly in how often they buy and how much profit they generate.

One group buys infrequently but produces very high profit. Another buys very often but adds little value. A third sits in the middle with moderate buying and moderate profit. A final group buys once or becomes inactive and adds almost no long-term value.

These differences are structural, not random. Treating all customers the same leads to spending too much effort on low-value customers and not enough on high-value ones, which weakens long-term profitability.

Conclusion

This analysis shows that not all customers contribute to the business in the same way. A small group of customers generates most of the profit, even though they do not buy often. Medium-value customers provide steady contribution and offer the best chance for growth, while frequent low-value customers keep the shop busy without adding much profit. One-time or inactive customers add volume but little long-term value. Being busy does not equal being profitable.

To improve long-term results, the shop needs to manage customers more deliberately. High-value customers should be protected and retained through good service and relevant follow-up, not discounts. Medium-value customers should be encouraged to grow through upgrades and repeat purchases, and low-value frequent buyers should be handled efficiently. Focusing on customer value instead of transaction volume helps the shop use its time and resources better and build a more stable, profitable business.