Customer Lifetime Value Analysis

Clean order and margin data, historic and model-based customer value, acquisition cost and payback by channel, and the rules that turn CLV into spending caps, retention limits and budgets.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Customer Lifetime Value Analysis, and click Install. It goes into your own files, and works offline from then on.

What it installs.

1

Pillar

1

Area

50

Projects

201

Starter tasks

📊 Data & Analytics

Customer Lifetime Value Analysis

Estimating what each customer or segment is worth over time and using it to guide acquisition spend, pricing and retention efforts.

  1. Written brief for what lifetime value will decide
  2. Order and customer data extract for value analysis
  3. Customer key for lifetime value calculations
  4. Contribution margin per order for CLV
  5. Time horizon and discount rate for CLV
  6. Historic value per customer by acquisition year
  7. Formula CLV for a subscription business
  8. Formula CLV for repeat-purchase customers
  9. Customer acquisition cost by channel
  10. One-page CLV method note
  11. Monthly CLV refresh
  12. LTV to CAC ratio by channel report
  13. CAC payback period tracker
  14. Predicted versus actual CLV check
  15. High-value customer slowdown watchlist
  16. Refunds, returns and chargebacks adjustment
  17. Quarterly segment value review with marketing
  18. Yearly CLV assumptions review with finance
  19. Early value signals for new customers
  20. Discounted lifetime value maths
  21. BG-NBD and Pareto-NBD purchase models
  22. Gamma-Gamma model for order value
  23. Shifted beta-geometric model for subscriptions
  24. Auditable spreadsheet CLV model
  25. Explaining CLV uncertainty to decision makers
  26. RFM scoring as a first step to value
  27. Maximum allowable CAC per channel
  28. Retention spend limit by customer value
  29. Value of discount-acquired versus full-price customers
  30. Choosing a CLV tool or library
  31. Predicted value signals for ad platform bidding
  32. Lifetime value by first product purchased
  33. Loyalty programme value case
  34. Annual versus monthly plan lifetime value
  35. Cost to serve in customer value
  36. CLV and unit economics slide for the board or investors
  37. Acquisition budget built from CLV
  38. Peak season customer value review
  39. CLV method workshop with marketing and finance
  40. Value read-out for a new market or product line
  41. CLV for a small shop from sales exports
  42. Early-stage CLV with less than a year of data
  43. B2B account value with expansion revenue
  44. Two-sided marketplace value for buyers and sellers
  45. Client lifetime value for a services firm
  46. Taking over an inherited CLV model
  47. Hierarchical Bayesian CLV by segment
  48. Customer equity and customer-based valuation
  49. Long-run value effects in experiments
  50. Predicted value at first purchase

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Written brief for what lifetime value will decide

Lifetime value numbers get built and then ignored when nobody agreed which decision they were meant to inform. Writing down the two or three decisions CLV will feed, such as the most you can pay to win a customer in each channel or how much a retention offer may cost, fixes the level of detail, the horizon and the audience before any modelling starts.

First tasks

  • List the decisions where customer value is currently guessed
  • Ask each decision owner what number would change their choice
  • Write the one-page brief with decisions, owners and level of detail
  • Get the brief agreed by the main decision owner

Order and customer data extract for value analysis

Customer value is built from four facts: who bought, when, how much, and what was later refunded. Finding where each lives, whether the ecommerce platform, the billing system, the payment processor or the accounting package, and pulling a clean extract with at least two years of history is the step most first attempts skip.

First tasks

  • List every system that records orders, subscriptions or refunds
  • Export customer ID, order date, value and refunds for all available history
  • Remove test orders, staff purchases and internal accounts
  • Compare the extract's yearly revenue with the finance totals
  • Write a short note on gaps and migrations in the data

Customer key for lifetime value calculations

If one person appears as three customers because they checked out as a guest, changed email and later opened an account, their value is split three ways and CLV looks lower and shorter than it is. Choosing a single key for value work, with a documented rule for linking guest orders and duplicate accounts, matters more than any model choice.

First tasks

  • Count orders with no customer ID or with a guest checkout flag
  • Choose the identifier and matching rule for value work
  • Apply the rule and measure how many duplicate customers merge
  • Record the rule and its effect in the CLV method note

Make it yours.

Install Customer Lifetime Value Analysis, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.