MetricKPI Compass StandardApprovedInternal
Customer Retention Rate
Percentage of customers retained over a defined period.
Unit
percentage
Aggregation
ratio
Definition
Percentage of customers retained over a defined period.
Formula
(Customers at End - New Customers) / Customers at Start
Assumed fields: {{numerator_expression}}{{denominator_expression}}{{numerator_measure}}{{denominator_measure}}
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 Retention Rate.
Sources
No sources recorded yet.