Skip to content
  • There are no suggestions because the search field is empty.

Lifetime Revenue & Retention Analytics

Understand how much revenue customers generate after their first purchase, how often they return, and which products acquire the highest-value customers with Lifetime Revenue (LTR) analytics.

Lifetime Revenue & Retention Analytics

Lifetime Revenue (LTR) measures the revenue generated by customers over time after their first purchase. This dashboard uses Amazon's Retail Purchases dataset with a 5-year lookback, allowing you to analyze customer behavior well beyond the short attribution windows typically available in the Amazon console.

The dashboard helps you answer three key questions:

  • How much revenue do customers generate after acquisition?
  • How often do customers come back and purchase again?
  • Which products acquire customers who generate the most revenue over time?

The dashboard includes two tabs:

  1. Customer LTR & Repeat Purchase Behaviour – Analyze customer revenue and repeat purchase behavior at the account level.
  2. Product Level LTR & Performance – Analyze LTR and customer acquisition performance at the ASIN level.

Header Controls

Use the controls at the top of the dashboard to customize the analysis.

Date Range

The dashboard uses a 5-year analysis window by default. The active period is displayed in the header.

If you need the analysis to be executed for a different period, reach out to help@intentwise.com.

Brand

Select one or more brands to analyze a specific portfolio. By default, all available brands are selected.

Eye Icon

Use the eye icon on individual cards to preview or expand the corresponding visualization.

Download Icon

Use the download icon on individual cards to export the underlying data for that visualization.

Customer LTR & Repeat Purchase Behaviour

This tab provides an account-level view of how much customers spend over time and how frequently they return to purchase.

LTR Trend Analysis

The LTR Trend Analysis section includes three KPI cards showing the average LTR at:

  • 3 months
  • 6 months
  • 1 year

Each metric measures the revenue generated during the specified period following a customer's first purchase.

In a healthy account, LTR generally increases as the measurement period gets longer. For example, 1-year LTR should typically be higher than 6-month LTR, which should be higher than 3-month LTR.

The difference between 3-month and 1-year LTR provides a quick indication of how much customer revenue continues to accumulate after the initial purchase.

The trend chart plots 3-month, 6-month, and 1-year LTR across customer cohorts on a quarterly basis.

This allows you to compare the quality of customers acquired over time.

For example, if recent cohorts have lower LTR than earlier cohorts, it may indicate that the customers being acquired are generating less revenue over their lifecycle, even if overall sales remain stable.

Repeat Purchase Behaviour

Repeat Purchase Behaviour shows how frequently customers return and how many purchases they make.

Time Between Purchases

The Time Between Purchases chart shows the distribution of the average time between repeat purchases.

The interval can be adjusted, with 30 days used as the default bucket size.

The highest-volume bucket can help identify the brand's natural replenishment or repurchase cycle.

For example, if most repeat purchases occur around 60 days after the previous purchase, this can help inform the timing of:

  • Retargeting campaigns
  • Subscribe & Save initiatives
  • Email re-engagement
  • DSP remarketing

Note: This chart includes only customers who have made two or more purchases, because a purchase interval cannot be calculated for customers with only one purchase.

Repeat Purchase Pattern

The Repeat Purchase Pattern chart shows the distribution of customers based on their total number of purchases.

Customers are grouped by purchase count, such as:

  • 1 purchase
  • 2 purchases
  • 3 purchases
  • And so on

This helps you understand how many customers make a single purchase versus becoming repeat customers.

Product Level LTR & Performance

The Product Level LTR & Performance tab moves from account-level customer behavior to individual ASIN performance.

It helps distinguish between the revenue generated by a product itself and the total revenue generated by customers that the product initially acquired.

Customer LTR

Customer LTR measures the lifetime revenue generated by customers acquired through a specific ASIN.

Importantly, this includes their subsequent purchases across any ASIN within the brand, not just the original product.

This metric helps identify gateway products—products that may initially generate modest revenue but acquire customers who go on to purchase other products in the catalog.

Product LTR

Product LTR measures revenue per buyer generated by the specific ASIN itself.

Unlike Customer LTR, it does not include purchases of other products in the brand.

This helps you understand the repeat-purchase strength of an individual product in isolation.

Both Customer LTR and Product LTR are reported at:

  • 3 months
  • 6 months
  • 12 months

LTR Expansion

LTR Expansion measures how much Customer LTR grows from the first three months to the first year.

LTR Expansion = 12M Customer LTR ÷ 3M Customer LTR

A higher value indicates that customers continue generating meaningful revenue after the initial three-month period.

Halo Multiple

Halo Multiple measures the additional revenue customers generate from other products in the brand beyond the product that initially acquired them.

Halo Multiple = (Customer LTR − Product LTR) ÷ Product LTR

A high Halo Multiple can indicate that an ASIN is an effective gateway product: customers may purchase the product initially and subsequently spend significantly more on other products in the brand's catalog.

Understanding the Analysis Window

You may notice that the dashboard's 5-year date range contains fewer than five years of plotted cohorts. This is intentional.

For example, a dashboard with an active date range of August 2021 to August 2026 may show cohorts beginning in Q3 2022 and ending around Q3 2025.

This trimming ensures that the LTR calculations are based on reliable customer cohorts.

Why the First 12 Months Are Trimmed

A customer should be considered new to the brand only when there is sufficient history to confirm that they did not purchase previously.

The first 12 months of the analysis window are therefore excluded when determining new-to-brand customers. Without this history, a customer whose first visible purchase occurs near the beginning of the dataset could actually be a returning customer.

Including these customers could inflate the new-customer base and distort the resulting LTR calculations.

Why the Last 12 Months Are Trimmed

LTR measures revenue generated after customer acquisition.

A customer acquired recently has not had enough time to make subsequent purchases. Including very recent customers would therefore make their measured LTR artificially low and could create a misleading decline in recent cohorts.

The analysis therefore excludes the most recent period required to measure the selected LTR horizon reliably.

Key Use Cases

Evaluate Customer Acquisition Quality

Compare LTR across customer cohorts to determine whether newly acquired customers are becoming more or less valuable over time.

Identify Gateway Products

Use Customer LTR and Halo Multiple to identify ASINs that acquire customers who subsequently purchase across the broader product catalog.

Optimize Acquisition Spend

Compare products based on the long-term revenue generated by the customers they acquire, rather than evaluating acquisition performance solely on short-term product-level revenue.

Understand Repurchase Cycles

Use Time Between Purchases to identify when customers are most likely to return and use that insight to inform retargeting and re-engagement strategies.

Measure Repeat Purchase Strength

Use Repeat Purchase Pattern and Product LTR to understand whether customers make one-time purchases or repeatedly purchase the same product.

Compare Product and Customer Revenue

Customer LTR and Product LTR together help distinguish between products that generate strong revenue themselves and products that are particularly effective at acquiring customers for the broader brand.

Recommendations

  • Look beyond short-term ROAS: Consider Customer LTR when evaluating acquisition performance, particularly for products with strong downstream purchases.
  • Identify gateway products: Products with high Customer LTR relative to Product LTR may be valuable customer acquisition entry points.
  • Use repurchase timing: Align retargeting and re-engagement efforts with the natural purchase interval of your customers.
  • Monitor cohort trends: Compare LTR across quarterly cohorts to identify changes in customer acquisition quality.
  • Evaluate the broader catalog: When assessing an ASIN, consider the revenue generated by the customers it acquires across the entire brand, not just revenue from the initial product.

Frequently Asked Questions

What is Lifetime Revenue (LTR)?

LTR measures the revenue generated by customers after their first purchase over a specified measurement period. The dashboard reports LTR at 3 months, 6 months, and 1 year.

What data does the dashboard use?

The dashboard uses Amazon's Retail Purchases dataset with a 5-year lookback.

Why does the dashboard show fewer than five years of cohorts?

The analysis trims the first 12 months to establish reliable new-to-brand customers and trims the most recent period based on the LTR measurement horizon. This prevents returning customers from being incorrectly classified as new and prevents recent customers from artificially lowering LTR.

Why is the Time Between Purchases chart different from the Repeat Purchase Pattern chart?

The two charts measure different aspects of repeat behavior.

Time Between Purchases measures the time between purchases and includes only customers with at least two purchases.

Repeat Purchase Pattern shows how many total purchases customers have made, including customers who have made only one purchase.

What is the difference between Customer LTR and Product LTR?

Customer LTR measures the revenue generated by customers acquired through an ASIN, including their subsequent purchases across other ASINs in the brand.

Product LTR measures revenue generated by those customers on the original ASIN only.

What does a high Halo Multiple indicate?

A high Halo Multiple indicates that customers acquired through a particular ASIN generate significant additional revenue from other products in the brand's catalog. This can be a strong indicator that the ASIN is an effective gateway product.

Can I change the analysis period?

The dashboard displays a defined analysis window. If you need the analysis executed for a different period, contact help@intentwise.com for assistance.