Lifetime Value Report Walkthrough
This guide explains how to interpret the Lifetime Value (LTV) report, adjust its settings and filters, and extract actionable insights!
- What is cohort analysis and why is it valuable?
- How to read the LTV report
- How to customize your LTV report
What is cohort analysis and why is it valuable?
Cohort analysis involves grouping customers and tracking each group's engagement with your business over time.
The LTV report groups customers by the month of their first order and calculates their average initial value. This figure updates as repeat purchases occur, helping you estimate customer lifetime value.
The LTV report offers various filters and settings to help you understand the value of different customer subsets, allowing you to confidently make informed decisions such as:
- How much can I afford to spend to acquire new customers?
- Which of my marketing initiatives should I abandon, and which should I scale up?
- Which product categories should I expand to maximize long-term profits?
How to read the LTV report
Log into your Lifetimely account, from the left-side menu, click the “Lifetime Value" tab and "Cohorts".
By default, the report shows accumulated sales per customer over the past six months, grouped by the month of their first order. (Don’t worry if this is confusing - we’ll explain what all this means in a moment.)
Here’s an example from one of our test stores:
Analyzing data for a single cohort
Let's examine the components of a single cohort in the report.
- New customers - the total number of customers in the cohort. The reason they are “New” is because they made their first order in June 2024.
- CAC (Customer Acquisition Cost) - an estimate of the average cost of acquiring each customer in the cohort, measured by total marketing spend divided by the number of new customers. This isn’t a perfect measure, but it should be accurate enough to draw general conclusions.
- R-% - the percentage of customers in the cohort who made at least one additional order within the selected time period of the report
In the above example, the June 2024 cohort includes 578 new customers, acquired at an estimated cost of $21 each, with 38% making a second purchase within six months.
In our example, we see that customers in our June 2024 cohort spent an average of $81 on their first orders, meaning each was initially worth $81 in sales.
- The value in the first cell of this section (0 months since the first order) is:
-
(total first-order cohort sales + total additional sales in the same month) ÷ total customers in the cohort
-
- The next cell adds additional sales from the second month, and so on
- The final cell (in this example, Month 6) shows all cohort sales in the six months after first orders, the calculation:
- total cohort sales (including first orders) ÷ total customers in the cohort.
Let's look at the numbers!
As we move across the row, the figure continues to rise month-to-month. By 3 months after their first order, customers from this cohort had an average value of $124 in sales. This is calculated by summing all sales from June (including first orders), July, August, and September, and dividing that total by the number of customers in the cohort.
The report provides six months of data. The final cell in the June 2024 row shows an average value of $124, meaning that customers who made their first purchase in June 2024 generated, on average, $124 in sales over this period. This represents a 53% increase from their initial value of $81, demonstrating the value of returning customers.
With a repeat rate (R-%) of 38% for this cohort, it’s clear that most customers (62%) did not make a second order. However, the customers who did return placed substantial or frequent orders, significantly increasing the cohort's overall average value.
In column "0," we see a value of $83 for the June 2024 cohort. This indicates that after placing their first order, several customers returned to make additional purchases within the same month. These additional sales raised the average value of a customer in this cohort from their initial first-order value of $81 to $83.
👉 Use case 2: The average customer value in the June 2024 cohort steadily increased from $83 to $124 by month 3, but plateaued after that. Is this typical behavior for your customers? Did earlier cohorts experience similar trends? Does the average customer value at month 6 represent their approximate lifetime value, or does it continue to grow beyond this time frame? To answer these questions, you could run reports with adjusted timeframes to analyse earlier cohorts over a longer period. If you noticed significant differences in customer value trends, you could apply filters (e.g., by marketing channel, product, or region) to identify which segments are driving higher customer value and focus on targeting them.
Analyzing data across multiple cohorts
Studying data across multiple cohorts will give you a more complete picture of how your customer base is evolving over the lifetime of your business.
One of the best ways to compare cohorts is to compare values within a single column of the report. Let’s zoom back out on our sample report to see how.
- 1
- Comparing important figures such as CAC and R-% across cohorts can help you quickly identify trends in your business. In the example above, we see that repurchasing percentages are steadily dropping, this trend would certainly raise some flags and instigate further analysis!
- 2
- Comparing values in this section of the report shows you how customer behavior is changing over time. Using the report above, we see that despite equivalent first order values across all cohorts, customers in the June 2024 cohort generated much higher repeat sales over subsequent months than later cohorts, with a noticeable downward trend for each group of new customers.
The value of comparing metrics across cohorts is that it helps you quickly identify changes in customer behavior. You need to know how your customer base is changing in order to start asking the right questions (and running the right reports) to determine why it’s changing, which will then help you to make more profitable business decisions.
Spaghetti graphs
To see your metrics plotted on a line graph, you can toggle your LTV report to a line graph (or "spaghetti chart") view using the button highlighted above. The advantages of a spaghetti chart is that it:
- Helps you visualize the trajectories of each cohort's LTVs
- Makes it easier to compare LTVs at similar points in time relative to first orders.
How to customize your LTV report
The top banner of the LTV report includes a number of settings you can customize to dig deeper into your customer data. Let’s take a closer look at what you can learn by adjusting each of these settings.
Selecting timeframes for your cohorts
Time period
The default LTV report displays customer data from the previous six months. If you’d prefer to see a different time range, click on the box marked “Time period”. You’ll see options to reach as far back as four years, or you can define your own custom date range.
When does it make sense to look at reports with shorter vs longer time periods?
- Shorter time periods may make more sense for you if your customer base is dynamic, meaning that new customer cohorts may behave very differently in comparison to previous cohorts.
- Reports with longer time periods, however, will be better-suited for businesses where customer behavior has held relatively steady over time.
Timeframe
In the next box to the right, you can choose to separate your customers into cohorts based on the week, month, quarter, or year in which they made their first purchase.
When does it make sense to split customers into smaller cohorts (grouped by week or month of first order) vs larger cohorts (grouped by quarter or year)?
- As with time periods, shorter timeframes (which result in smaller cohorts) may make more sense if you have a dynamic customer base and/or if you’re trying to quickly draw conclusions about a new group of customers.
- If your customer base has behaved in a relatively stable manner over multiple quarters or years, then selecting longer timeframes can give you a reliable estimate of the lifetime value of your customers.
Choosing which metrics to analyze
The LTV report gives you the option to display thirteen types of metrics in your report! The report will keep the same format regardless of the metric you select, but different metrics will help you reach different insights and conclusions about your data.
By default, your report will display data as accumulated sales per customer. To change this metric, simply select a new one from the Metrics drop-down menu (see below), and a new report will instantly generate.
⚠️ Note: The Net Sales metric in Lifetimely is calculated differently from the Net Sales in Shopify. In Shopify, Net Sales = Gross Sales - Discounts - Refunds and it doesn't take into account the Shipping Revenue. Whereas in Lifetimely, Net Sales = Product Revenue + Shipping Charged - Discounts - Refunds - Taxes
Accumulated sales per customer
This metric calculates the total sales generated by an average customer from a given cohort over time. This and accumulated gross margin per customer are the two most useful metrics for giving you an estimate of the lifetime value of your customers, and therefore will be your go-to reports for calculating average customer values and monitoring how these values change over time.
Accumulated net sales per customer
Total net sales (after taxes, discount codes, and refunds have been deducted) per customer in that cohort so far. Not just across returning customers, but across all the customers in that cohort.
Accumulated gross margin per customer
The difference between this and accumulated sales per customer is that this metric calculates your gross margin by subtracting all product-related costs (marketing costs are not removed from this value). This helps you estimate the average profit of your customers over time.
Assuming that your product costs are accurately captured in Lifetimely, this is our recommended metric for determining the lifetime value of your customers and for understanding how much you can afford to spend to acquire new customers.
Accumulated contribution margin per customer
Total sales - discount codes - refunds - taxes - COGS - marketing spend per customer in that cohort.
Average order value
This metric tracks each cohort's average order value in each year/quarter/month/week following initial orders. It's calculated by taking total sales (after discount codes and before refunds) and dividing by the total number of orders for each time period.
Customers
The customers metric sets aside sales numbers to show you how many customers from each cohort are making additional orders in your store over time. This helps you analyze when your customers are most likely to make an additional purchase and see whether new customers are repurchasing at a faster or slower rate compared to older customers.
Cohort transactions
To get even more granular than the Customers metric, you can run a report that gives you discreet transactions per cohort over time. These last two metrics (cohort sales and cohort transactions) may be especially helpful in building financial models.
Cohort sales
This metric shows you how the total sales volume for each cohort increases over time, allowing you to compare net sales across cohorts and see how much each cohort is contributing to total sales. Total discreet sales per cohort during week/month/year.
Cohort net sales
Total net sales (after taxes, discount codes, and refunds have been deducted) per cohort during week/month/year.
Accumulated orders per customer
Like the customers metric, accumulated orders per customer also sets aside sales numbers to show you how many orders are placed by a cohort over time. This helps you analyze the frequency at which new customers order additional products compared to previous cohorts.
Customers who purchased X times
This metric is a bit different from the others - instead of giving you a measure of lifetime value, it breaks down how often different customers within each cohort are placing orders. When using this metric, keep in mind that timeframe is removed as a factor, so comparing cohort values within each column isn't as much of an apples-to-apples comparison as with other metrics. E.g. How many new customers from Jan-2024 cohort have made 3 or more orders?
Accumulated sales per customer / CAC
Accumulated sales divided by CAC. The ratio measures the relationship between the lifetime value of a customer and the cost of acquiring that customer
Accumulated gross margin per customer / CAC
Accumulated gross margin divided by CAC. Once > 1.0, your cohort has become profitable and CAC payback has happened. The ratio measures the relationship between the lifetime value of a customer and the cost of acquiring that customer
Using the CAC Payback tool
For many businesses, one of the most important insights to be gained from the LTV report is an estimate of how long it takes to break even on new customers. This is known as “CAC payback time” - the point at which the accumulated gross margin of an average customer finally outweighs the average cost of acquiring a customer. (Reminder: your gross margin is sales after refunds and discounts, minus shipping costs, handling costs, transaction costs, and custom costs). In other words, this is the time it takes for an average customer to become profitable.
The CAC payback tool helps you visualize where this breakeven point is for each of your cohorts.
- 1
- To activate the CAC payback tool, simply click the CAC payback switch to the "on" position.
- 2
- As soon as you activate the tool, you will see a bright green marker along the timeline of all of your cohorts that have reached breakeven, indicating the exact point where accumulated gross margin per customer equals CAC for the cohort.
- 3
- You can hover over any of these green markers to see the actual CAC payback figure.
- 4
- If you don't see a green marker anywhere along a cohort's timeline, then you have not yet broken even on your CAC.
- 5
- If the green marker is at the very beginning of your timeline (such as in the Jan 2024 and Aug 2024 cohort above), then you have already broke even on your CAC on your cohort's first orders.
Applying filters for more advanced analysis
On the far right of the settings bar of the LTV report is a button that will pull up a long list of filters you can apply to your report. Applying these filters is the most effective way to extract actionable insights from your customer data.
The following filters are available:
Marketing channels/sources
If your store's data includes tracking information from various marketing and referral channels, you have the option to filter your report results to include only the customers directed to your store by specific channels:
- Affiliates
- CPC Google
- Direct
- Facebook Paid
- Klaviyo list, segment or campaign
- Organic Search
- Other Social Advertising (i.e. non-FB or IG, such as TikTok and Pinterest)
- Referral
- Social (i.e. all social media sources)
Tags
These filters let you take advantage of the feature in Shopify that allows you to tag customer data. You have the option to filter the report to only include OR only exclude customers with a given tag. Again, clicking on the empty text box will pull up a list of available tags to select from.
Products
With these filters, you can run reports to:
- Only include customers who purchased a certain product with their first order
- Only include customers who purchased from a certain collection with their first order
- Only include customers who purchased a certain product type with their first order
Sales channels
The sales channel filters let you account for the different ways you might sell your product, such as in-store vs. online. You can choose to only include OR only exclude customers from a given source.
Other
Filters in the “Other” category allow you to run reports to:
- Only include customers from specific Countries, or a certain State
Surveys
Connect Upsell to use post-purchase survey responses as a filter and segment customers by Questions or Responses.
Saving cohorts
If there are combinations of frequently used filters that you plan on applying again, you can save time by saving your customized cohorts with the "Save cohort" button at the bottom of the Filters window.
To save a cohort:
- Select a combination of one or more filters.
- Click the "Save cohort" button at the bottom of the Filters window.
- Assign a name to your new cohort. This will add it to the "Saved cohorts" drop-down menu at the top of the Filters window
To access a saved cohort:
- Click on the "Saved Cohorts" drop-down menu at the top of the Filters window
- Select your saved cohort and click the blue "Apply filters" button. This will automatically apply the correct combination of filters associated with the cohort to your LTV report.