calc_customer_clv
Calculate projected customer lifetime value (CLV) using average order value, purchase frequency, and projection years, then classify customers into Platinum, Gold, Silver, or Bronze tiers.
Instructions
Calculate projected Customer Lifetime Value (CLV = avg order value × purchase frequency per year × projection years) and tier customers as Platinum / Gold / Silver / Bronze.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| lookbackDays | No | History window for frequency/value calculation (default 730 = 2 years) | |
| projectionYears | No | Forecast horizon in years for CLV (default 3) |