E-commerce Customer Lifetime Value Calculator
Calculate customer lifetime value (CLV) from AOV, purchase frequency, and lifespan. Set acquisition budgets and evaluate retention strategy ROI.
Score customers on Recency, Frequency, and Monetary value (1-5 each) and assign segments like Champions, At Risk, and Hibernating for targeted marketing.
Low priority. Try a reactivation campaign with a strong offer, but don't over-invest.
RFM analysis is a proven customer segmentation technique that scores each customer on three dimensions: Recency (how recently they purchased), Frequency (how often they purchase), and Monetary (how much they spend). Each dimension is scored 1โ5, creating segments that drive targeted marketing strategies.
Customers scoring 5-5-5 are "Champions" โ your best customers who buy frequently, recently, and at high values. Customers scoring 1-1-1 are "Hibernating" and may need win-back campaigns. Between these extremes lie segments like "Loyal Customers," "At Risk," "Can't Lose Them," and "New Customers."
This calculator lets you input a customer's recency (days since last order), frequency (total orders), and monetary value (total spend), then scores and segments them automatically. Use it to understand the composition of your customer base and allocate marketing resources accordingly.
Sending the same marketing to all customers wastes budget and annoys recipients. RFM segmentation lets you personalize by value and recency, and this page shows how the scoring framework works before you roll it out broadly.
Recency Score (1โ5): Lower days since purchase = higher score
Frequency Score (1โ5): More purchases = higher score
Monetary Score (1โ5): Higher spend = higher score
RFM Segment = function(R, F, M) mapped to named segmentsResult: R:5, F:5, M:5 โ Champion
A customer who purchased 15 days ago (very recent = R:5), has made 12 purchases (very frequent = F:5), and spent $1,450 total (high value = M:5) is a "Champion." These customers should receive VIP treatment, early access to new products, and referral program invitations.
RFM analysis has been used since the 1930s in direct mail marketing. Its longevity proves its value โ knowing when a customer last bought, how often, and how much predicts future behavior better than demographics. E-commerce businesses that implement RFM see 15โ30% improvement in email revenue through better targeting.
The real value is not in the scores but in the actions they drive. Champions get VIP treatment. At Risk customers get personalized win-back offers. Hibernating customers get reactivation campaigns or are excluded from expensive acquisition channels. Each segment has a specific, testable strategy.
For a small store, you can run RFM analysis in a spreadsheet. For larger operations, CRM and email platforms (Klaviyo, HubSpot, Salesforce) have built-in RFM capabilities or integrations. The key is automating the scoring so segments update dynamically and trigger appropriate workflows.
Last updated:
Common segments include Champions (5,5,5), Loyal (4-5, 3-5, 3-5), Potential Loyalists (4-5, 1-2, 1-2), At Risk (1-2, 3-5, 3-5), Can't Lose (1-2, 5, 5), Hibernating (1-2, 1-2, 1-2), and About to Sleep (2-3, 1-2, 1-2). The exact mapping varies by business.
Use quintiles (top 20% = 5, next 20% = 4, etc.) from your customer data. For recency, score 5 means purchased within the shortest interval. For frequency and monetary, 5 means the highest values. Calculate from your actual distribution.
Absolutely. While machine learning models can create more sophisticated segments, RFM remains valuable because it is intuitive, easy to explain to stakeholders, and can be implemented in a spreadsheet. Many advanced segmentation models use RFM as a starting point.
Monthly or quarterly is typical. More frequent recalculation is needed for businesses with short purchase cycles. Key insight: watch for segment migration โ Champions becoming At Risk is an early warning that demands action.
Yes, but adapt the dimensions. Recency could be days since last login or engagement. Frequency could be number of active months. Monetary could be lifetime subscription revenue. The scoring logic remains the same.
Champions: loyalty rewards, VIP access, referral requests. Loyal: upsells and cross-sells. At Risk: win-back discounts, "we miss you" emails. New: welcome series with product education. Hibernating: deep discounts or product announcements to re-engage.
Calculate customer lifetime value (CLV) from AOV, purchase frequency, and lifespan. Set acquisition budgets and evaluate retention strategy ROI.
Calculate the percentage of customers who make more than one purchase. Benchmark against industry averages and measure the health of your retention efforts.
Calculate retention by cohort over multiple periods. Track how many customers from each acquisition month remain active in subsequent periods.