Average Customer Lifespan influences your Customer Lifetime Value, which tells you how much revenue you should expect from each customer. This number is important as you consider the costs associated with acquiring new customers, and whether you should invest more or less to find new customers.
Step 1: Create a Custom Report in Shopify
We will be adding the columns we need in order to complete the calculation. To add a column:
Step 2: Calculate the Sum of Lifespans for your Customers
We’ll be completing the remainder of the calculation in a spreadsheet. Open your exported CSV in Excel or Google Sheets.
Step 3: Calculate the Total Number of Customers
Step 4: Calculate Average Customer Lifespan
That’s it! For our scenario above, the Average Customer Lifespan for this company is 843.33 days*.
*When using this value in your Customer Lifetime Calculation, remember to convert it back to years by dividing by 365
Conclusion: How do I use it?
Average Customer Lifespan tells you how long your typical customer remains a customer. This computation is part of the larger Customer Lifetime Value (CLV) calculation which is used to determine the overall revenue expected from each additional customer you acquire for your business.
As you contemplate your allocation of resources, it is important to monitor your CLV and Customer Acquisition Cost (CAC) to ensure that you are receiving a positive return on marketing/advertising spend.