Skip to content

Expansion Revenue Potential (Forecasted)

Definition

Expansion Revenue Potential (Forecasted) estimates the total revenue that could be unlocked from your existing customer base via upsell, cross-sell, or usage-based growth. It helps quantify upside within the base.

Description

Expansion Revenue Potential (Forecasted) is a key indicator of base growth opportunity and future monetization capacity, reflecting how account behavior, product usage, and pricing structures inform projections of future upsell revenue.

The relevance and interpretation of this metric shift depending on the model or product:

  • In SaaS, it might include forecasted seat additions or unlocked product tiers
  • In usage-based models, it extrapolates from current usage trends or expansion paths
  • In enterprise software, it may involve multi-department rollout models

A rising forecast shows healthy adoption and scalable account growth, while a flat or declining projection may suggest usage plateaus, pricing ceiling, or limited product expansion paths. By segmenting forecast potential by segment, product line, or account size, you can identify where to direct GTM resources and focus CS efforts.

Expansion Revenue Potential (Forecasted) informs:

  • Strategic decisions, like revenue planning, territory allocation, or pricing reviews
  • Tactical actions, such as prioritizing nurture flows or QBR focus
  • Operational improvements, including forecast tooling accuracy and CS flagging
  • Cross-functional alignment, between finance, RevOps, product, and sales, ensuring future revenue is proactively unlocked, not just reactively chased

Key Drivers

These are the main factors that directly impact the metric. Understanding these lets you know what levers you can pull to improve the outcome

  • Account Tier and Plan Ceiling: Customers on entry-level plans with room to grow present higher potential.
  • Usage and Activation of Expansion Features: Interest or trial in advanced features suggests conversion potential.
  • Org Size and Team Growth: Larger companies or rapidly scaling customers offer greater expansion runway.

Improvement Tactics & Quick Wins

Actionable ideas to optimize this KPI, from fast, low-effort wins to strategic initiatives that drive measurable impact.

  • If forecasts feel inflated or vague, enrich models with live data (e.g., seat usage trends, feature clicks, org size updates).
  • Add a “max plan vs. current plan” delta to each account profile in your CRM.
  • Run simulations using current expansion conversion rates by tier to set realistic targets.
  • Refine opportunity scoring to discount accounts with low usage or health scores.
  • Partner with RevOps to integrate forecast logic into sales dashboards and QBR prep tools.

  • Required Datapoints to calculate the metric

    • Total Existing Accounts
    • Expansion Opportunity Score or Readiness Index
    • Current Plan vs. Max Plan Value
    • Account Growth Forecasts
    • Usage Trend Data (e.g., seats, volume)

  • Example to show how the metric is derived

    • 80 accounts with high readiness
    • Avg. forecasted expansion value: $4,500
    • Total Potential = 80 × $4,500 = $360,000 forecasted

Formula

Formula

\[ \mathrm{Expansion\ Revenue\ Potential\ (Forecasted)} = \sum_{i=1}^{n} \mathrm{Forecasted\ Expansion\ Value\ per\ Account}_i \]

Data Model Definition

How this KPI is structured in Cube.js, including its key measures, dimensions, and calculation logic for consistent reporting.

cube('ExpansionRevenuePotential', {
  sql: `SELECT * FROM expansion_revenue_potential`,

  joins: {
    Accounts: {
      relationship: 'belongsTo',
      sql: `${CUBE}.account_id = ${Accounts}.id`
    }
  },

  measures: {
    expansionRevenuePotential: {
      sql: `expansion_opportunity_score * (max_plan_value - current_plan_value)`,
      type: 'number',
      title: 'Expansion Revenue Potential',
      description: 'Estimates the total revenue that could be unlocked from existing customers via upsell, cross-sell, or usage-based growth.'
    }
  },

  dimensions: {
    id: {
      sql: `id`,
      type: 'string',
      primaryKey: true
    },

    accountId: {
      sql: `account_id`,
      type: 'string'
    },

    expansionOpportunityScore: {
      sql: `expansion_opportunity_score`,
      type: 'number'
    },

    currentPlanValue: {
      sql: `current_plan_value`,
      type: 'number'
    },

    maxPlanValue: {
      sql: `max_plan_value`,
      type: 'number'
    },

    accountGrowthForecast: {
      sql: `account_growth_forecast`,
      type: 'number'
    },

    usageTrendData: {
      sql: `usage_trend_data`,
      type: 'number'
    },

    createdAt: {
      sql: `created_at`,
      type: 'time'
    }
  }
});

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

Positive & Negative Influences

  • Negative influences

    Factors that drive the metric in an undesirable direction, often signaling risk or decline.

    • Customer Churn Rate: A high churn rate indicates customer dissatisfaction or lack of engagement, which negatively impacts the Expansion Revenue Potential.
    • Market Saturation: In highly saturated markets, there is less room for growth, which can negatively affect the Expansion Revenue Potential.
    • Economic Downturn: Economic challenges can lead to budget cuts and reduced spending, negatively impacting the Expansion Revenue Potential.
    • Competitive Pressure: Increased competition can lead to price wars and reduced customer loyalty, negatively influencing the Expansion Revenue Potential.
    • Product Limitations: If the product does not meet evolving customer needs, it can limit expansion opportunities and negatively affect the Expansion Revenue Potential.

  • Positive influences

    Factors that push the metric in a favorable direction, supporting growth or improvement.

    • Account Tier and Plan Ceiling: Customers on entry-level plans with room to grow have a higher potential for upsell and cross-sell opportunities, directly increasing the Expansion Revenue Potential.
    • Usage and Activation of Expansion Features: Increased interest or trial in advanced features indicates a higher likelihood of conversion, positively impacting the Expansion Revenue Potential.
    • Org Size: Larger organizations typically have more resources and needs, providing a greater opportunity for expansion and thus positively influencing the Expansion Revenue Potential.
    • Team Growth: Rapidly scaling customers often require more services and features, leading to increased expansion opportunities and positively affecting the Expansion Revenue Potential.
    • Customer Satisfaction: High levels of customer satisfaction can lead to increased trust and willingness to invest in additional products or services, enhancing the Expansion Revenue Potential.

Involved Roles & Activities

Funnel Stage & Type

  • AAARRR Funnel Stage

    This KPI is associated with the following stages in the AAARRR (Pirate Metrics) funnel:

    Revenue

  • Type

    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.

Supporting Leading & Lagging Metrics

  • Leading

    These leading indicators influence this KPI and act as early signals that forecast future changes in this KPI.

    • Product Qualified Leads: Product Qualified Leads (PQLs) serve as an early indicator of expansion opportunities within the customer base. A rising number of PQLs signals increased engagement and readiness for upsell or cross-sell, directly influencing future Expansion Revenue Potential (Forecasted).
    • Cross-Sell Conversion Rate: A high Cross-Sell Conversion Rate indicates that customers are receptive to purchasing additional products or services, which is a strong precursor to expansion revenue. Trends here can forecast the unlockable revenue potential in the base.
    • Upsell Conversion Rates: The rate at which customers accept upsell offers is a leading indicator of demand and willingness to expand accounts. Improving upsell conversion rates typically precede increases in forecasted expansion revenue.
    • Activation Rate: A higher Activation Rate reflects more users achieving meaningful engagement milestones, which often leads to subsequent expansion opportunities and a higher Expansion Revenue Potential (Forecasted).
    • Product Qualified Accounts: Product Qualified Accounts (PQAs) are organizational units showing strong product engagement. An increase in PQAs signals a larger pool of accounts with high expansion potential, forecasting future expansion revenue.

  • Lagging

    These lagging indicators confirm, quantify, or amplify this KPI and help explain the broader business impact on this KPI after the fact.

    • Expansion Readiness Index: The Expansion Readiness Index aggregates behavioral, fit, and usage signals to quantify how prepared accounts are for expansion. A higher index directly correlates with greater Expansion Revenue Potential (Forecasted) as it identifies ripe opportunities.
    • Expansion Revenue Growth Rate: This metric quantifies the realized growth from expansion motions. Sustained or accelerating growth rates validate and amplify the forecasted potential, confirming effectiveness of expansion strategies.
    • Expansion Opportunity Score: A high Expansion Opportunity Score across the customer base signals strong underlying drivers (usage, intent, fit) for expansion. It refines and substantiates the Expansion Revenue Potential (Forecasted) by identifying the best targets.
    • Expansion Revenue Rate: Expansion Revenue Rate quantifies the current contribution of upsell and cross-sell to total revenue. A higher rate confirms that the base is being successfully monetized, validating forecasted potential.
    • Self-Serve Upsell Revenue: Self-Serve Upsell Revenue measures realized revenue from customers expanding independently, serving as a confirmation or quantification of the potential previously forecasted in Expansion Revenue Potential.