Understanding Customer Value
18,400 customers analyzed; high-CLV buyers contribute most while buying least often.
A bicycle shop with 18,400 active customers and 60,000+ sales lines asked a familiar question: which customers actually keep this business healthy? Volume said one thing. Value said another.
About 63% of the shop's customers bought once. Another 36% bought two or three times. Fewer than 2% returned four times or more. The shop runs largely on one-off and casual buyers, not a loyal repeat base.
When I segmented by customer lifetime value, the gap was stark. High-CLV customers contributed about RM10.6M in profit. Medium-CLV: RM1.4M. Low-CLV: just RM0.12M. Losing a small number of high-CLV customers would hurt profit far more than losing many low-value ones.
The unexpected pattern: high-CLV customers don't buy often. Their purchase frequency is low, but their profit per order is much higher — typically full bikes or premium upgrades. Meanwhile, the most frequent buyers contribute the least to profit. Activity isn't value.
This creates a quiet risk. The shop's busiest customer groups generate the least money, while its most valuable customers are easy to overlook because they're not visibly active.
The recommendation: protect high-CLV customers through service and follow-up rather than discounts, develop medium-CLV customers as the growth segment, handle the long tail efficiently rather than nurture-heavy.
Customer value is structural here, not random. Treating all customers the same wastes effort on the wrong group.