1. Metrics
  2. Subscription mrr monthly summary

Subscription mrr monthly summary

subscription_mrr_monthly_summary
copy
Click to Copy

The subscription_mrr_monthly_summary table offers a comprehensive monthly view of Monthly Recurring Revenue (MRR) for each subscription in both the billing currency and the site's reporting currency.

Note: This table is in BETA and may not be available in all Chargebee sites.

Key Features:

  • Monthly granularity: MRR is captured at the end of each month, allowing for detailed trend analysis.
  • Complete timeline: Each subscription_id has entries from its creation date up to the current day.
  • Timezone and currency sensitivity: Data is aligned with the Chargebee site's configured reporting timezone and currency.
  • Historical tracking: Includes both current and previous day's values for status and MRR in any record, enabling easy identification of changes.

Analytical Use Cases:

  • Monthly MRR growth tracking and forecasting
  • Seasonality and trend analysis in subscription performance
  • Customer segment comparisons
  • Rolling retention rate calculations
  • Foreign exchange impact assessment on reported MRR

Note:

Changes to the site's reporting timezone or currency settings will trigger a recalculation of the entire table, ensuring data consistency.

Columns

No match found
id String, not null
Primary Key
A unique identifier for the record that distinguishes each entry in the database.
customer_id string, not null
Foreign Key customers.id
A unique identifier for the customer who holds the subscription, allowing for tracking and management of customer-related data.
subscription_id string, not null
Foreign Key subscriptions.id
A unique identifier for the specific subscription
reporting_timezone string, not null
The timezone as configured in your Chargebee site setting. A change in this setting will result in recalculation of the entire table.
reporting_month timestamp, null
Represents the last date of the month (or the latest date of the current month) for which the data is reported. This in the timezone specified by the reporting_timezone column.
status string, not null
Subscription Status at the end of the reporting month
status_previous string, not null
Subscription Status at the end of the previous reporting month
billing_currency_code string, not null
The currency in which the subscription fees are charged, represented as a three-letter ISO currency code (e.g., USD, EUR).
mrr_billing_currency decimal, null
The MRR value in billing currency at the end of the reporting month.
mrr_previous_billing_currency decimal, null
The MRR value in billing currency at the end of the previous reporting month, allows easy calculation of month-over-month MRR changes in billing currency.
reporting_currency_code string, not null
The reporting currency as set in the Chargebee site, represented as a three-letter ISO currency code (eg: USD, EUR). A change in this setting will result in recalculation of the entire table.
exchange_rate decimal, null
The exchange rate at the end of reporting month. If the billing currency is different from reporting currency, then this exchange rate is used to convert MRR from billing currency to reporting currency.
exchange_rate_previous decimal, null
The exchange rate between billing currency and reporting currency at the end of previous reporting month, allows for analysis of how currency fluctuations impact reported MRR.
mrr decimal, null
The MRR value converted in reporting currency at the end of the reporting month. Primary metric for analyzing subscription value in the standardized reporting currency.
mrr_previous decimal, null
The MRR value converted in reporting currency at the end of the previous reporting month, allows easy calculation of month-over-month MRR changes in reporting currency.
mrr_difference decimal, null
The month-over-month change in MRR, accounting for both subscription changes and exchange rate fluctuations.
mrr_difference_from_exchange_rate decimal, null
The component of mrr_difference that can be attributed to difference in exchange rate. This is useful for accounting purposes but should not be used to classify subscription movements in Upgrades or Downgrades.
mrr_difference_from_subscription_change decimal, null
The component of mrr_difference that can be attributed to growth or contraction of subscription price, quantity or discount. This can be used to classify subscription changes into different categories such as Upgrades, Downgrades, Contraction or Expansion.