Required Datapoints
- Starting Revenue from Referred Accounts (MRR/ARR)
- Expansion Revenue (upsell, cross-sell)
- Contraction Revenue (downgrades)
- Churned Revenue (lost accounts)
- Time window (typically quarterly or annual)
Referred Account Net Revenue Retention (NRR) measures the revenue retained and expanded from referred customer accounts over time, factoring in upsell, cross-sell, contraction, and churn. It helps quantify the long-term revenue quality of referrals.
Referred Account NRR is a key indicator of customer quality, advocacy-driven fit, and expansion potential, reflecting how revenue from referred accounts evolves over time—whether through renewals, upsells, or downgrades.
The relevance and interpretation of this metric shift depending on the model or product:
A rising trend signals aligned referrals, strong onboarding, and product satisfaction, while a declining trend may point to over-incentivized, low-fit referrals or friction post-signup.
By segmenting by referral source, customer cohort, or incentive structure, you uncover what types of referrals lead to loyal, growing accounts—and where referral quality may be falling short.
Referred Account NRR informs:
These are the main factors that directly impact the metric. Understanding these lets you know what levers you can pull to improve the outcome
Actionable ideas to optimize this KPI, from fast, low-effort wins to strategic initiatives that drive measurable impact.
Activities commonly tied to improving or operationalizing this KPI.
| Activity | Description |
|---|---|
| Referral Analysis | Referral Analysis involves systematically reviewing and assessing leads or accounts referred by existing customers, partners, or internal stakeholders. It turns signals into decisions, interventions, and measurable follow-up. Relevant KPIs include Referred Account Net Revenue Retention (NRR). |
| NRR Strategy | NRR Strategy focuses on developing and executing strategic initiatives to maximize Net Revenue Retention (NRR), a key metric for recurring revenue businesses. It gives teams a clear plan for where to focus, how to sequence work, and what to measure. Relevant KPIs include Referred Account Net Revenue Retention (NRR). |
| Expansion Plays | Expansion Plays focuses on Expansion Motion encompasses the strategic activities aimed at increasing the value of existing customer accounts by identifying and pursuing opportunities for upselling, cross-selling, and encouraging broader product adoption. It coordinates execution across touchpoints so teams can move users or accounts toward the target outcome. Relevant KPIs include Average Revenue Per Account and Average Revenue Per Expansion Account. |
| Post-Onboarding Programs | Post-Onboarding Programs focuses on Customer Success Enablement Programs consist of a series of ongoing initiatives and resources offered to customers after their initial onboarding. It coordinates execution across touchpoints so teams can move users or accounts toward the target outcome. Relevant KPIs include Referred Account Net Revenue Retention (NRR). |
| Usage Tracking | Usage Tracking involves the systematic observation and analysis of customer interactions with a product or service. It turns signals into decisions, interventions, and measurable follow-up. Relevant KPIs include Referred Account Net Revenue Retention (NRR). |
Starting ARR from referred accounts: $200,000
Expansion: $60,000
Contraction: $15,000
Churn: $25,000
Formula: (200K + 60K − 15K − 25K) ÷ 200K = 110% Referred Account NRR
This KPI is associated with the following stages in the AAARRR (Pirate Metrics) funnel:
This KPI is classified as a lagging Indicator. It reflects the results of past actions or behaviors and is used to validate performance or assess the impact of previous strategies.
This role is directly accountable for the KPI and is expected to drive progress and decisions around it.
These roles contribute directly to performance and typically partner on execution, reporting, or optimization.
These leading indicators influence this KPI and act as early signals that forecast future changes in this KPI.
These lagging indicators confirm, quantify, or amplify this KPI and help explain the broader business impact on this KPI after the fact.
How this KPI is structured in Cube.js, including its key measures, dimensions, and calculation logic for consistent reporting.
cube('ReferredAccounts', { sql: `SELECT * FROM referred_accounts`, measures: { startingRevenue: { sql: `starting_revenue`, type: 'sum', title: 'Starting Revenue from Referred Accounts', description: 'Total starting revenue from referred accounts (MRR/ARR).' }, expansionRevenue: { sql: `expansion_revenue`, type: 'sum', title: 'Expansion Revenue', description: 'Revenue from upsell and cross-sell activities.' }, contractionRevenue: { sql: `contraction_revenue`, type: 'sum', title: 'Contraction Revenue', description: 'Revenue lost due to downgrades.' }, churnedRevenue: { sql: `churned_revenue`, type: 'sum', title: 'Churned Revenue', description: 'Revenue lost from churned accounts.' }, netRevenueRetention: { sql: `starting_revenue + expansion_revenue - contraction_revenue - churned_revenue`, type: 'number', title: 'Net Revenue Retention', description: 'Net revenue retention from referred accounts, factoring in expansion, contraction, and churn.' } }, dimensions: { id: { sql: `id`, type: 'string', primaryKey: true, title: 'ID', description: 'Unique identifier for each referred account.' }, accountName: { sql: `account_name`, type: 'string', title: 'Account Name', description: 'Name of the referred account.' }, referralDate: { sql: `referral_date`, type: 'time', title: 'Referral Date', description: 'Date when the account was referred.' } }})Note: This is a reference implementation and should be used as a starting point. You’ll need to adapt it to match your own data model and schema