CLTV Calculator — Customer Lifetime Value

The CLTV calculation relies on a sequence of operational metrics that break down revenue, purchase frequency, average customer value, and expected lifespan. First, the average purchase value is calculated by dividing total revenue by the number of purchases (avg_pur = rev / num_pur). Next, purchase frequency is found by dividing total purchases by the number of customers (avg_freq = num_pur / num_cus). Multiplying these two yields the average customer value (avg_cus_value = avg_pur * avg_freq). The average customer lifespan (ACL) is determined by dividing the sum of all customer lifespans by the total number of customers (acl = sum_lifespan / num_cus). Finally, multiplying the average customer value by the ACL gives the ultimate Customer Lifetime Value (cltv = avg_cus_value * acl).

Imagine an e-commerce apparel store with a total annual revenue of $500,000 from 10,000 total purchases made by 2,000 unique customers. The sum of all customer lifespans equals 6,000 years across that cohort. First, find the average purchase value: $500,000 / 10,000 = $50. Second, find the average purchase frequency: 10,000 / 2,000 = 5 purchases per customer. Third, multiply these to find the average customer value: $50 * 5 = $250. Fourth, determine the average customer lifespan (ACL): 6,000 years / 2,000 customers = 3 years. Finally, multiply the average customer value by the ACL: $250 * 3 = $750. Thus, the CLTV for this cohort is $750.

To improve your CLTV outcomes, focus heavily on post-purchase retention strategies and loyalty programs that extend average customer lifespan. Regularly monitor changes in average purchase value through targeted upselling and cross-selling campaigns. Finally, ensure your customer acquisition cost (CAC) remains significantly lower than your calculated CLTV to maintain a healthy, scalable business model.