What customer lifetime value by product shows about first purchases
The short answer
Group customers by the category of their first purchase, then compare their spend and gross margin over the following 24 months to see customer lifetime value by product. Adjust for channel and first-order discount, since some categories are mostly bought on promotion. The category with the highest adjusted value is the strongest entry point.
Why it matters
Acquisition campaigns usually lead with bestsellers or the cheapest entry products. If another category produces customers worth twice as much, leading with it changes the value of every customer acquired, at no extra acquisition cost.
The question to ask
Copy this into Lexi as written.
What the answer looks like
Illustrative output on sample data
Illustrative example: how Lexi answers this for a homewares retailer. It compares 24-month margin for customers acquired two years ago by first-purchase category.
- Bedding: 8,200 customers, $640 average margin
- Kitchenware: 11,500 customers, $380
- Decor: 14,000 customers, $210
What the data shows
Bedding customers are worth three times decor customers, though decor brings in the most new customers.
What it means
On full-price first orders only, kitchenware closes much of the gap, since many kitchenware first orders came from a deep holiday promotion.
What to do
Lead acquisition campaigns with bedding and test kitchenware at full price.
Would you like this adjusted for acquisition channel?
Frequently asked questions
Why adjust first-category value for discount and channel?
Some categories are mostly bought first on promotion or through deal-heavy channels, which attract customers who return less. Comparing raw values blames the category for what the discount or channel did. Comparing within the same channel and discount level shows the category's own effect.
How is first purchase product lifetime value measured?
Take customers acquired in the same period, group them by the product or category in their first order, and total each group's spend and gross margin over a fixed window such as 24 months. Use margin net of returns, so categories with high return rates are not flattered.
How long should the comparison window be?
Long enough to capture repeat buying, which for most retail categories means at least 12 months and ideally 24. Durable categories like furniture may need longer. Use the same window for every category, measured from each customer's first order.