1. Metrics
  2. Subscription mrr daily summary

Subscription mrr daily summary

subscription_mrr_daily_summary
copy
Click to Copy

The subscription_mrr_daily_summary table offers a comprehensive daily 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:

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

Analytical Use Cases:

  • Daily 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_date timestamp, null
The time dimension represents the end date for the reporting period. This date is in the timezone specified by the reporting_timezone column.
status string, not null
Subscription Status at the end of the reporting date
status_previous string, not null
Subscription Status at the end of the previous reporting date
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 date.
mrr_previous_billing_currency decimal, null
The MRR value in billing currency at the end of the previous reporting date, allows easy calculation of day-over-day 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 date. 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 date, 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 date. 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 date, allows easy calculation of day-over-day MRR changes in reporting currency.
mrr_difference decimal, null
The day-over-day 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.