Design calculated insight for customer lifetime value with decay function

• Define CLV formula with time decay and return rate adjustment • Use calculated insight with scheduled refresh aligned to campaign cadence • Segment thresholds documented and versioned • Handle missing data gracefully — null vs zero vs exclude • Validate CLV distribution against finance model quarterly • Do not expose raw transaction rows in insight if minimization required • Test insight impact on segment counts before activation