MetricKPI Compass StandardApprovedInternal
Net Revenue Retention
Recurring revenue retained from an opening customer base after churn, contraction, and expansion.
Unit
percentage
Aggregation
ratio
Definition
Recurring revenue retained from an opening customer base after churn, contraction, and expansion.
Formula
(Opening Recurring Revenue - Churned Revenue - Contraction Revenue + Expansion Revenue) / Opening Recurring Revenue
Assumed fields: {{numerator_expression}}{{denominator_expression}}{{numerator_measure}}{{denominator_measure}}
Return blank or null when a denominator is zero. Validate cohort, eligibility, timestamp, and recurring-revenue rules before use. Tableau, Looker (LookML), and Datorama templates are generated from the canonical formula — confirm field references before production use.
Standard reference formula for Net Revenue Retention.
Sources
No sources recorded yet.