Feature-Based ARPU¶

Definition¶

Feature-Based ARPU measures the average revenue generated per user who actively uses a specific feature. It helps quantify feature value and its impact on monetization.

Description¶

Feature-Based ARPU is a key indicator of monetization effectiveness and value alignment, reflecting how engagement with specific features influences average revenue per user (ARPU).

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

In SaaS, it reveals how premium capabilities like analytics or integrations drive upsell success
In freemium models, it highlights paywall interactions and high-converting features
In modular platforms, it helps track monetization tied to optional or expansion modules

A rising Feature-Based ARPU signals strong value perception and revenue leverage, while a low or flat trend suggests low pricing impact or poor upgrade conversion. By segmenting by feature, plan, or persona, you unlock insights to prioritize high-value features, revisit packaging, and improve monetization alignment.

Feature-Based ARPU informs:

Strategic decisions, like product pricing, bundling, or roadmap planning
Tactical actions, such as designing upgrade prompts or in-app paywalls
Operational improvements, including support and onboarding for revenue-driving features
Cross-functional alignment, connecting product, finance, and growth teams to focus on features that actually move revenue

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

Feature Placement in Tiered Pricing: If a feature is paywalled at higher tiers, its usage directly drives ARPU up.
Correlation Between Feature Use and Expansion: Features tied to collaboration, automation, or customization often lead to higher seat or usage growth.
User Role or Use Case Fit: Some features only make sense for high-value segments — aligning monetization with role increases ARPU.

Improvement Tactics & Quick Wins¶

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

If feature-based ARPU is low, evaluate whether the feature should be monetized differently — e.g., usage-based vs. tier-gated.
Add usage prompts that highlight ROI (“teams using [Feature] save 4+ hrs/week”) to drive adoption among high-potential accounts.
Run a pricing test: move the feature to a higher plan or bundle with another expansion driver.
Refine packaging by role or vertical to position high-ARPU features where they have the most perceived value.
Partner with RevOps to track ARPU uplift by feature usage cohort.

Required Datapoints to calculate the metric
- List of Users Who Used the Feature
- Associated Revenue from Those Users
- Usage Window
Example to show how the metric is derived
- 1,000 users of “Advanced Reporting”
- Total revenue: $60,000
- Feature-Based ARPU = $60/user

Formula¶

Formula

\[ \mathrm{Feature\text{-}Based\ ARPU} = \frac{\mathrm{Total\ Revenue\ from\ Feature\ Users}}{\mathrm{Number\ of\ Feature\ Users}} \]

Data Model Definition¶

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

UsersFeatureUsageRevenueFeatureBasedARPU

cube('Users', {
  sql: `SELECT * FROM users`,

  joins: {
    FeatureUsage: {
      relationship: 'hasMany',
      sql: `${CUBE}.id = ${FeatureUsage}.user_id`
    },
    Revenue: {
      relationship: 'hasMany',
      sql: `${CUBE}.id = ${Revenue}.user_id`
    }
  },

  measures: {
    count: {
      type: 'count',
      sql: 'id',
      title: 'User Count',
      description: 'Number of users who used the feature.'
    }
  },

  dimensions: {
    id: {
      sql: 'id',
      type: 'string',
      primaryKey: true
    },
    name: {
      sql: 'name',
      type: 'string',
      title: 'User Name'
    }
  }
})

cube('FeatureUsage', {
  sql: `SELECT * FROM feature_usage`,

  measures: {
    usageCount: {
      type: 'count',
      sql: 'id',
      title: 'Feature Usage Count',
      description: 'Number of times the feature was used.'
    }
  },

  dimensions: {
    id: {
      sql: 'id',
      type: 'string',
      primaryKey: true
    },
    user_id: {
      sql: 'user_id',
      type: 'string',
      title: 'User ID'
    },
    usage_date: {
      sql: 'usage_date',
      type: 'time',
      title: 'Usage Date'
    }
  }
})

cube('Revenue', {
  sql: `SELECT * FROM revenue`,

  measures: {
    totalRevenue: {
      type: 'sum',
      sql: 'amount',
      title: 'Total Revenue',
      description: 'Total revenue generated from users who used the feature.'
    }
  },

  dimensions: {
    id: {
      sql: 'id',
      type: 'string',
      primaryKey: true
    },
    user_id: {
      sql: 'user_id',
      type: 'string',
      title: 'User ID'
    },
    revenue_date: {
      sql: 'revenue_date',
      type: 'time',
      title: 'Revenue Date'
    }
  }
})

cube('FeatureBasedARPU', {
  sql: `SELECT * FROM (
    SELECT
      u.id AS user_id,
      SUM(r.amount) / COUNT(DISTINCT u.id) AS arpu
    FROM
      users u
    JOIN
      feature_usage fu ON u.id = fu.user_id
    JOIN
      revenue r ON u.id = r.user_id
    GROUP BY
      u.id
  )`,

  measures: {
    arpu: {
      type: 'number',
      sql: 'arpu',
      title: 'Feature-Based ARPU',
      description: 'Average revenue per user who used the feature.'
    }
  },

  dimensions: {
    user_id: {
      sql: 'user_id',
      type: 'string',
      title: 'User ID'
    }
  }
})

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.
- Feature Complexity: Complex features may deter usage, leading to lower adoption rates and a decrease in Feature-Based ARPU.
- Poor User Experience: If a feature is difficult to use or has a poor user interface, it can lead to decreased usage and lower Feature-Based ARPU.
- Lack of Awareness: If users are unaware of a feature, its usage will be limited, negatively impacting Feature-Based ARPU.
- Inadequate Support or Training: Without proper support or training, users may not fully utilize a feature, leading to reduced Feature-Based ARPU.
- Feature Redundancy: If a feature overlaps with existing functionalities, users may not see additional value, resulting in lower Feature-Based ARPU.
Positive influences

Factors that push the metric in a favorable direction, supporting growth or improvement.
- Feature Placement in Tiered Pricing: When a feature is placed in higher pricing tiers, it encourages users to upgrade, thereby increasing the Feature-Based ARPU as users pay more to access the feature.
- Correlation Between Feature Use and Expansion: Features that promote collaboration, automation, or customization often lead to increased usage or additional seat purchases, which directly boosts Feature-Based ARPU.
- User Role or Use Case Fit: Aligning features with high-value user segments or specific use cases ensures that these users derive significant value, leading to higher willingness to pay and increased Feature-Based ARPU.
- Feature Adoption Rate: Higher adoption rates of a feature indicate its perceived value, leading to increased usage and higher Feature-Based ARPU.
- Feature Engagement Level: Increased engagement with a feature often correlates with higher satisfaction and perceived value, resulting in higher Feature-Based ARPU.

Involved Roles & Activities¶

Involved Roles

These roles are typically responsible for implementing or monitoring this KPI:

Data & Analytics
Finance
Monetization
Product Management (PM)
Product Marketing (PMM)
Activities

Common initiatives or actions associated with this KPI:

Pricing Strategy
Monetization Optimization
Product Packaging
Customer Segmentation

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 are a leading indicator for Feature-Based ARPU because they identify users who have engaged deeply with the product and are likely to adopt and monetize specific features in the future. A higher volume or quality of PQLs often forecasts increased feature uptake and subsequent revenue per active feature user.
- Activation Rate: Activation Rate measures how many users reach meaningful engagement milestones, which is a precursor to feature adoption and monetization. A high Activation Rate typically signals a growing pool of users likely to convert to active, paying feature users, thus positively influencing future Feature-Based ARPU.
- Monthly Active Users: Monthly Active Users is a key metric that drives future Feature-Based ARPU, as a larger active user base increases the potential pool for feature adoption and monetization. Growth in MAU frequently precedes rises in ARPU for specific features.
- Upsell Conversion Rates: Upsell Conversion Rates indicate how effectively users are moving to higher tiers or purchasing additional features, providing an early signal of revenue growth from specific feature usage. Improved upsell rates typically lead to higher Feature-Based ARPU downstream.
- Feature Adoption / Usage: Feature Adoption / Usage is directly tied to future Feature-Based ARPU, as increasing adoption rates of a particular feature suggest more users will contribute to that feature's revenue. Early shifts in adoption often precede changes in ARPU.
Lagging

These lagging indicators confirm, quantify, or amplify this KPI and help explain the broader business impact on this KPI after the fact.
- Average Revenue Per User: Average Revenue Per User provides a broader context for Feature-Based ARPU by showing overall monetization. Changes in overall ARPU can confirm whether increases in feature-specific ARPU are driving total revenue or if shifts are isolated to specific features.
- Net Revenue Retention: Net Revenue Retention quantifies the impact of upsells, cross-sells, and churn on recurring revenue. It amplifies the business impact of Feature-Based ARPU by demonstrating how feature monetization translates into retained and expanded revenue across the customer base.
- Expansion Revenue: Expansion Revenue measures the additional revenue from upselling or cross-selling features, directly confirming the impact of Feature-Based ARPU improvements. It quantifies how successful feature monetization strategies are in driving overall account growth.
- Customer Downgrade Rate: Customer Downgrade Rate explains decreases or stagnation in Feature-Based ARPU, as higher downgrade rates often reflect dissatisfaction or reduced value perception of premium features, thereby negatively impacting feature-related revenue.
- Churn Risk Score: Churn Risk Score helps explain and contextualize changes in Feature-Based ARPU post-facto. High churn risk among feature users can lead to reductions in ARPU, providing insight into retention challenges that are impacting monetization.