MetricKPI Compass StandardApprovedInternal
Customer Lifetime Value
Estimated economic value generated by a customer across the relationship.
Unit
currency_per_customer
Aggregation
compound
Definition
Estimated economic value generated by a customer across the relationship.
Formula
Average Revenue per Customer × Gross Margin × Average Customer Lifetime
Assumed fields: {{value_range}}{{table}}{{field}}
Return blank or null when the denominator is zero. Confirm filters, grain, and inclusion rules before production use. Tableau, Looker (LookML), and Datorama templates are generated from the canonical formula — confirm field references before production use.
Standard reference formula for Customer Lifetime Value.
Sources
No sources recorded yet.