Author: Kadence Leung
Last Update:2026/04/12
Introduction
Standard ad reports measure the immediate return on a single sale. The Customer Lifetime Value (CLV) model zooms out to show your long-term profitability.
By tracking a shopper's behavior from their very first transaction until they stop buying, this model calculates the total revenue a user brings to your brand over time. The goal is simple: prove that the long-term value of a customer (LTV) is significantly higher than what you paid to acquire them (CAC).
Use this data to answer:
-
What is the true, long-term profitability of my brand or specific products?
-
How many months does it actually take to recoup my acquisition costs?
-
Which specific months or seasons bring in the most loyal, high-value customers?
When to Use This Report
Pull this report when you need to shift the conversation with stakeholders from short-term ROAS to sustainable business growth:
-
Justify Higher Bids: Prove that paying a high Customer Acquisition Cost (CAC) today is worth it because those users will buy repeatedly over the next 6-12 months.
-
Forecast Profitability: Know exactly when a cohort of users breaks even so you can accurately plan and allocate future marketing budgets.
-
Evaluate Customer Retention: Look beyond initial sales to measure true brand loyalty and Repeat Purchase Rates (RPR) across different seasons and product lines.
How to Use It
The dashboard is split into two main sections to help you analyze both overarching trends and specific customer cohorts.
- The Overview & Trend Chart This section plots your overall LTV and ROAS trends over time. Watch how the blue LTV bars grow month over month. By comparing this growth to your baseline Customer Acquisition Cost (CAC), you can visually estimate when a customer's total spend finally outweighs what you paid to acquire them.

2. The Monthly Cohort Heatmap This chart groups customers by their "Acquisition Month" (the month they made their very first purchase) and tracks their buying habits as time progresses.
-
Read Horizontally: Track a specific month's group over time to see when their repeat purchase behavior starts to drop off.
-
Read Vertically: Compare different acquisition months against each other (e.g., Do Black Friday shoppers have a higher 3rd-month LTV than shoppers acquired in June?).
Understanding the Timeline Columns:
-
First Purchase: The revenue from the exact, initial transaction that acquired the user.
-
First Purchase Month: Includes that initial transaction plus any extra purchases they made before that calendar month ended.
-
2nd Month, 3rd Month, etc.: The recurring revenue generated by those exact same users in subsequent months.

Strategic Scenarios
Use the table below to set up specific queries based on your reporting goals:
| Goal | How to Set Up | What to Look For | Strategic Action |
| Bidding Strategy Validation | Review the Overview Trend Chart. | The exact point where the LTV bar crosses your Cost Recovery Marker. | If LTV consistently doubles your CAC by Month 3, you can safely increase your upper-funnel bids to acquire more users. |
| Seasonality Quality | Review the Cohort Heatmap. Compare Q4 acquisition months to Q2. | High LTV growth in the 2nd and 3rd months for specific cohorts. | If holiday shoppers never return but summer shoppers become loyal, shift more retention budget toward your summer cohorts. |
| Product Profitability | Build a Custom Model filtered by a specific ASIN. Turn on the Cost Recovery Marker. | The exact month the product cohort hits your breakeven threshold. | Schedule aggressive retargeting or cross-sell campaigns right before the user becomes profitable to speed up recovery. |
FAQ
Q: What is the "Cost Recovery Marker" toggle on the dashboard?
A: This is an optional, advanced feature. If you know your client's/ brand's exact Operating Margin, you can enter it here and turn the toggle on. It draws a specific baseline on your chart showing exactly when the actual profit of a customer exceeds the acquisition cost. If you don't know the exact margin, simply leave this off and use the standard LTV vs. CAC metrics to evaluate your growth.
Q: What is the core difference between LTV and ROAS?
A: ROAS is short-term; it only counts the immediate revenue directly tied to an ad click. LTV is long-term; it includes that first ad-driven sale, plus all subsequent organic repeat purchases and cross-category buying over the customer's lifespan.
Q: Can I run this report for a short 30-day campaign?
A: No. Because Lifetime Value requires observing long-term repeat behavior, the selected time range for a custom model must be greater than 180 days.
Q: Does this model include organic repeat purchases?
A: Yes. If you have Amazon Purchase Data Insights (FSI) enabled, the model captures subsequent organic purchases, giving you a true picture of the user's entire journey beyond their initial ad click.
Glossary
| Type | Term | Description |
| Dimension | First Purchase | Initial purchase event |
| Acquisition Month | Month when the customer was acquired | |
| Xth Month | Specific month since acquisition for measurement | |
| Ads Account | Advertiser account for DSP or entity of Sponsored Ads | |
| Operating Margin | Operating margin from ad spend | |
| Metrics | UV | Unique Viewer |
| Total Cost | Total Cost of ads | |
| Purchase UV | Deduplicated number of purchase users | |
| Repeat Purchase UV | Deduplicated number of repeat purchase users | |
| Total Product Sales | Total revenue from product sales | |
| Repeat Sales | Total revenue from repeat sales | |
| LTV | Lifetime Value (Total Sales/Purchase UV) | |
| CAC | Customer Acquisition Cost (Total Cost/Purchase UV) | |
| ROAS | Return on Ad Spend (Total Product Sales/Total Cost) | |
| RPR | Repeat Purchase Rate (Repeat Purchase UV/Purchase UV) |