What's my average customer lifespan?
How long does the typical customer stay with you? This number drives every customer value calculation and tells you whether your relationships are built to last. Here's how to figure it out.
The short answer
Average customer lifespan = 1 / monthly churn rate. If your monthly churn rate is 4%, your average customer lifespan is 25 months. If it's 2%, your average customer stays for 50 months. You can also calculate it directly from transaction data by measuring the time between each customer's first and last purchase.
Why knowing your average customer lifespan changes how you invest
If your average customer stays for 8 months, you can afford to spend up to 8 months of profit to acquire them. If they stay for 24 months, your acquisition budget triples. Every marketing decision, pricing change, and service investment is shaped by how long customers stick around.
Most business owners have a gut feeling about this number. They think their customers stay “about two years.” But when you actually measure it, the real number is often shorter than expected. The customers you remember are the loyal ones. The ones who came, bought once, and disappeared are invisible.
Knowing the real number lets you set realistic budgets, price correctly for long-term profitability, and identify when lifespan is improving or deteriorating.
Two ways to calculate average customer lifespan
There are two approaches, and each gives you a slightly different perspective:
Method 1 (from churn rate): Average lifespan = 1 / monthly churn rate
Method 2 (from transaction data): Average lifespan = Average of (last purchase date - first purchase date) for all churned customers
Method 1 is an estimate based on current behavior. Method 2 uses actual historical data but only works for customers who have already churned. For active customers, you can only see the lifespan so far, not the final number. Most businesses use Method 1 for planning and Method 2 for validation.
How to calculate customer lifespan from QuickBooks Online data
- 1Go to Reports → Sales by Customer Detail
Set the date range to “All Dates.” This report shows every transaction for every customer, with dates.
- 2Export to CSV
Click Export and save as CSV. Open in a spreadsheet.
- 3Find first and last transaction dates per customer
Use a pivot table or MINIFS/MAXIFS formulas to find each customer's earliest and latest transaction dates.
- 4Calculate the difference in months
For each customer, subtract first date from last date to get their lifespan in days. Divide by 30 for months.
- 5Average the results
Take the average of all customer lifespans. Consider separating churned customers (whose lifespan is final) from active customers (whose lifespan is still growing).
Total time: 30-45 minutes. One large export and significant spreadsheet work with pivot tables or complex formulas.
How to calculate customer lifespan from Xero data
- 1Go to Business → Invoices
Set the date filter to all time. Export the full invoice list to CSV.
- 2Build a customer-level summary in your spreadsheet
Use pivot tables to find each customer's first invoice date and last invoice date.
- 3Calculate lifespan and average
Same math as the QuickBooks approach: last date minus first date for each customer, then average across all customers.
Total time: 30-45 minutes. Similar to QuickBooks. The biggest challenge is handling the raw invoice export and building the per-customer summary.
Why this metric is rarely tracked manually
- It requires your entire transaction history. Unlike monthly metrics, lifespan calculations need all-time data. That means larger exports and more complex formulas.
- One-time buyers skew the average. If 40% of your customers bought once and never returned, they drag the average way down. Segmenting by customer type gives you a more useful number but adds more spreadsheet work.
- The number changes slowly. Customer lifespan is a trailing indicator. By the time it changes meaningfully, the underlying behavior shift happened months ago. Monthly churn rate is a better early warning.
Or get your customer lifespan calculated automatically
Bottomline analyzes your full transaction history and calculates average customer lifespan, segmented by customer type and cohort. You see the number, the trend, and how it compares to previous periods.
The segmented view is what makes this actionable. Overall average lifespan is one thing. Knowing that repeat buyers stay 24 months while one-time buyers drag the average to 18 tells you exactly where the opportunity is: converting more first-time buyers into repeat customers.