You’re viewing the read-only demo workspace.Sign up to build your own →
KPI Compass

Command Palette

Search for a command to run...

MetricKPI Compass StandardApprovedInternal

Gross Revenue Retention

Recurring revenue retained from an opening customer base before expansion revenue.

Unit

percentage

Aggregation

ratio

Definition

Recurring revenue retained from an opening customer base before expansion revenue.

Formula

(Opening Recurring Revenue - Churned Revenue - Contraction 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 Gross Revenue Retention.

Sources

No sources recorded yet.