<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=402048033595637&amp;ev=PageView&amp;noscript=1">

Master Inbound

Honest and unfiltered advice, stories, strategies, and support for marketers and business leaders like you.

Subscribe to Our Newsletter

Subscribe Here!

A Simple Way to Calculate Customer Lifetime Value

Written by John Turner on 3, November 2017


Customer lifetime value (CLV) is one of the most critical metrics an eCommerce business should be tracking. CLV determines the value of each customer, telling you how much you can spend to acquire and retain each customer and in the end, helps you improve customer value.

This metric becomes more insightful when you begin segmenting your existing customer base. If you conducted a Google search on how to calculate CLV, you would find that there are many methods listed.

customer lifetime value formula


Although more advanced methods customer lifetime value formulas exist, we will provide a simple way for you to get the information you need to refine your approach to customer acquisition. For this simple method, we will need to calculate the following variables:

  • Average Order Size (AOS)
  • Average Order Frequency (AOF)
  • Customer Value (CV)
  • Average Customer Lifespan (ACL)

If your current eCommerce platform does not make this information readily available, you can export this data into a spreadsheet to perform the calculations. Columns required will be:

  • Customer Name
  • Total Revenue
  • Number of orders by customers
  • Number of days between first order date and last order date

If you need to calculate this manually, download your customer data with the columns highlighted above and follow the 5 steps outlined below.

Step 1: Calculate Average Order Size (AOS)

The average order size (AOS) is the average amount of money that a customer spends each time they place an order. Your average order size is calculated by calculating your total customer revenue for a given period and dividing the total orders performed by these customers to calculate your average order size.

Average Order Size Formula


Step 2: Calculate Average Order Frequency (AOF)

The average order frequency (AOF) represents the average amount of orders placed by each customer. Your average order frequency (AOF) is calculated by compiling the total number of orders for a given period and dividing it by the total number of customers for a given period.

Average Order Frequency Formula


Step 3: Calculate Average Customer Value (ACV)

The average customer Value (ACV) is the average revenue value that each customer brings to your business during a given timeframe. The average customer value can be determined by multiplying the average order size (AOS) with the average order frequency (AOF).

Improve Customer Value Formula


Step 4: Calculate Average Customer Lifespan (ACL)

The average customer lifespan is the average number of days between first order date and last order date of all of your customers. Convert the average number of days into years by dividing your number by 365. For example, if you determine that the ACL is 1,277.5 days, this would equate to an ACL of 3.5 years.

Average Customer Lifespan Formula


Step 5: Calculating the Customer Lifetime Value (CLV)

To calculate your average customer lifetime value (CLV) using this simple method, multiply your average customer lifespan (ACL) to your average customer value (ACV).

customer lifetime value formula


Bringing everything together, using the data below as an example, we can determine that the average customer lifetime value in this example is $187.50.

customer lifetime value excel

Ultimately, to determine the CLV margin contribution for each customer, we can multiply the gross margin percentage to CLV to calculate the CLV grow margin contribution. In this example, with a gross margin percentage of 50%, our CLV grow margin contribution would be $93.75 to determine how much money we should budget to acquire and retain customers. Not all customers are valued equally. Depending on the type of business you are in, you can further segment your customer base in order to gain insights on the value of each segment:

  • Most Purchases
  • Geography
  • Product and service line
  • Order frequency
  • Order value

Tactics to Increase Customer Lifetime Value

increase customer lifetime value

Based on the variables used to calculate customer lifetime value, it is evident that by increasing the average order size (AOS), average order frequency (AOF), the length of the average customer lifetime (ACL) or all three, we can increase customer lifetime value (CLV). In addition to these variables, average conversion rates can influence the customer lifetime value. Below are some tactics to increase customer lifetime value:

  • Tactics for increasing average order frequency
    • Nurturing the right customers, with personalized content and offers, at the right time with email marketing campaigns
    • Staying in front of customers with retargeting ad campaigns
    • Create a loyalty program that rewards order frequency
    • Customer Service and Return Programs
    • Using data-based personalized marketing that highlights products or services based on past activity, interest, or purchases
  • Tactics for increasing average order size
    • Offer free shipping with a minimum order size
    • Present bundled offers
    • Present upsell and cross-sell offers
    • Create a loyalty program that rewards spending levels
  • Tactics for increasing the average customer lifetime
    • Build a rapport with your customers via email marketing and social media
    • Host events for local customers, participating in the physical community presence
    • Nurture customer relations by focusing on customer service strategies and improvements
    • Establish a customer-centric approach to inbound marketing and social media that focuses on the customer’s needs and interests over the constant push to sell
  • Tactics for increasing conversion rates
    • Provide social proof with online reviews
    • Personalize content and offers to the right customer at the right time
    • Provide free shipping
    • Offer discounts
    • Streamline the checkout process by removing unnecessary steps and using smart forms
    • Send cart abandonment reminder emails
    • Provide exit offer at checkout

Although acquiring new customers is important to every business, mining customer lifetime value creates possibilities of unlocking huge value.

 Free eCommerce Assessment


Download the full report.











Topics: eCommerce

Free eCommerce Assessment Offer

From Facebook

Free eCommerce Assessment

Get custom feedback and tips for improving your eCommerce results.

Get Free Assesment

Need Help? Any Questions?

We are here to answer any questions you may have about our experiences. Reach out to us and we'll respond as soon as we can.