How to Calculate Customer LTV on WooCommerce

Customer Lifetime Value (LTV) measures the total revenue a customer generates over their entire relationship with your store. It's the metric that determines how much you can invest to acquire a customer while remaining profitable.

Without LTV, you're flying blind on acquisition. You set ad budgets without knowing if the acquisition cost will be recouped. You treat all customers the same even though some are worth 10x more than others. You don't know if your customer base is gaining or losing value over time.

LTV isn't just a single number. It's useful by segment (VIP vs occasional customers), by acquisition channel (Google Ads vs organic), by cohort (customers acquired in January vs June) and by product (which product generates customers with the highest LTV).

WooCommerce stores all the data needed for LTV calculation: complete order history, customer profiles, purchase dates, amounts. But the WordPress/WooCommerce dashboard doesn't use this data to calculate advanced metrics.

Native WooCommerce reports show revenue by period, top products and top customers by amount spent. But they don't group customers by acquisition date, don't track their evolution over time and don't calculate predictive value.

WooCommerce extensions on WordPress.org offer partial improvements (enhanced reports, advanced exports) but none provide automatic LTV calculation by cohort with RFM segmentation. It's a complex calculation requiring cross-temporal aggregations between wp_wc_orders and wp_users tables.

The most common formula is: LTV = Average Order Value x Annual Purchase Frequency x Customer Lifespan (in years).

Example: average order 65 EUR, 2.5 purchases per year, estimated lifespan of 3 years. LTV = 65 x 2.5 x 3 = 487 EUR.

This formula is useful for a first estimate but has significant biases. It assumes all customers behave the same way (which is false). Lifespan is hard to estimate without long historical data. And it doesn't account for costs, so it's a gross LTV, not net.

For a more accurate calculation, switch to cohort analysis: group customers by acquisition month and track cumulative revenue for each cohort over time. This method is more reliable as it's based on real data rather than global averages.

Fullmetrix connects to your WooCommerce store via a module compatible with WooCommerce 7.x and 8.x. All data (orders, customers, products) is synced automatically, including complete history.

LTV is calculated two ways. First, per-customer LTV: the cumulative revenue (or cumulative net profit if profit tracking is enabled) for each customer since their first purchase. Second, per-cohort LTV: the average cumulative revenue per customer for each monthly acquisition cohort.

The cohort view is the most powerful as it lets you compare the value of customers acquired at different times. You can identify months where you acquired the best customers and understand why (specific campaign, hero product, seasonality).

Fullmetrix adds RFM segmentation (Recency, Frequency, Monetary) that automatically categorizes your customers into actionable segments: Champions, Loyalists, At Risk, Lost. Each segment has a different average LTV, letting you adapt your retention strategy by segment.

Action 1: identify your RFM Champions and create VIP treatment for them. These customers typically represent 5 to 10% of your base but 30 to 50% of your revenue. Offer them early access to new products, a premium loyalty program and priority support.

Action 2: sync your high-LTV segments to Meta and Google Ads as lookalike audiences. Ad platforms will find prospects who resemble your best customers. Lookalikes based on VIP customers generate 2 to 4x higher ROAS than interest-based audiences.

Action 3: trigger retention campaigns at the right time. Cohort analysis shows exactly when your customers drop off (typically between month 2 and month 3 after first purchase). Schedule a re-engagement email sequence at that precise moment with a personalized offer based on purchase history.