1. Metrics
  2. Subscription mrr changes

Subscription mrr changes

subscription_mrr_changes
copy
Click to Copy

This table captures the historical changes in subscription status and Monthly Recurring Revenue (MRR) for each subscription. Each row represents a distinct change event, allowing for a comprehensive view of a subscription's lifecycle. The table is designed to facilitate root cause analysis of subscription upgrades, downgrades, and cancellations when joined with internal product analytics datasets.

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

Key Features:

  • New records for changes in subscription status or MRR
  • Temporal data model to track the validity period of each record
  • Currency information is included to support multi-currency analysis
  • Current and previous values stored in the same record for easy change calculation

Analytical Use Cases:

  • Churn analysis and prediction
  • Upgrade/downgrade trend identification
  • Pricing strategy impact assessment
  • Cohort analysis of subscription lifecycles
  • Customer Lifetime Value (CLV) calculations

Columns

No match found
id long, 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. This allows tracking of multiple subscriptions per customer.
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).
status string, not null
The current status of the subscription (e.g., active, paused, cancelled), providing insight into the subscription's lifecycle.
status_previous string, not null
The status of the subscription before the current change, allowing for tracking of subscription status transitions.
mrr decimal, null
The current value of subscription MRR in the currency code
mrr_previous decimal, null
The previous value of subscription MRR in the currency code, allowing for tracking of MRR transitions.
mrr_change decimal, null
The difference between current value and previous value of the subscription MRR. Positive values indiciate increase in Subscription MRR, whereas negative values indicate decrease in Subscription MRR.
record_recorded_at timestamp, null
The timestamp at which this record was inserted in the table
record_start_at timestamp, null
This timestamp marks the beginning of the period for which this record is valid.
record_end_at timestamp, null
The timestamp at which the values of this record ceased to be valid. If NULL, it represents the current active record for the particular subscription_id