CX - Subscription Historical Trend
This table describes the Subscription Historical Trend metrics. These metrics are used in the Document Currency (DC) and Analytics Currency (AC) fact folders in this subject area.
Document Currency is the currency used while entering the data in the application. Analytics Currency is the currency defined in the application. Analytics Currency and Exchange Rate Type are configured during product implementation. The Exchange Rate date basis uses the Subscription Start Date to convert to the analytics currency. Metrics in these folders show amounts in their respective currencies.
| Metric | Metric Definition |
|---|---|
| # of Active Customers - Period Start | The total Active customers at the start of a period (Customers with an active subscription in a given period) |
| # of Active Subscriptions - Period Start | The total number of Active Subscriptions at the start of a period |
| Active MRR - Period Start | The total monthly recurring revenue of all Active Subscriptions at the start of a period |
| Average Revenue per Customer - Period Start | The total Average Revenue per Customer (ARPU) at the start of a period. This metric is computed as follows: Total Active MRR/Total number of Active Customers |
| Product Net Price (TCV) - Period Start | The total Product Net Price of Active Subscriptions at the start of a period |
| # of Active Customers - Period End | The total Active customers at the end of a period (Customers with an active subscription in a given period) |
| # of Active Subscriptions - Period End | The total number of Active Subscriptions at the end of a period |
| Active MRR - Period End | The total Monthly Recurring Revenue of all Active Subscriptions at the end of a period |
| Average Revenue per Customer - Period End | The total Average Revenue per Customer (ARPU) at the end of a period. This metric is computed as follows: Total Active MRR/Total number of Active Customers |
| Product Net Price (TCV) - Period End | The total Product Net Price of Active Subscriptions at the end of a period |
| # of New Active Subscriptions | The number of New Subscriptions started in a period. (Started in a period and which aren't a result of an amendment, suspension, or renewal of existing subscriptions) |
| # of Renewed Active Subscriptions | The number of Subscriptions Renewed in a period. (Number of active subscriptions that are renewed from existing subscriptions) |
| # of Terminated Subscriptions | The number of Subscriptions Terminated in a period. (Number of active subscriptions that are terminated in a period. This metric doesn't include closed subscriptions due to the amendment or suspension of existing subscriptions) |
| # of Due for Renewal Subscriptions | The number of Subscriptions that are due for Renewal in a period. |
| # of Expansion Subscriptions | The total Expansion Subscriptions (Target subscription MRR greater than Source Subscription MRR). |
| # of Contraction Subscriptions | The total number of Expansion Subscriptions (Target subscription MRR less than Source Subscription MRR). |
| # of Churned Renewal Subscription | The total Churned Renewal Subscriptions in a period. (Subscriptions that were Renewed from existing Subscriptions but Canceled in the given period) |
| # of Lapsed Renewal Subscriptions | The total Lapsed Renewal Subscriptions in a period. (Active subscriptions that expired in a period without being renewed). |
| New Active MRR | The total new MRR of Active subscriptions added in a period. (Started in a period and which aren't a result of an amendment, suspension, or renewal of existing subscriptions) |
| Activated Renewal MRR | The total Activated Renewal MRR in a period. (Active Subscriptions that were renewed from existing subscriptions) |
| Termination MRR | The total Termination MRR in a period. (Active subscriptions that are closed in a period, not due to the amendment or suspension of existing subscriptions) |
| MRR Due for Renewal | The total MRR of Subscriptions that are due for Renewal in a period |
| Expansion MRR | The total Expansion MRR in a period. (The difference in MRR between a target and source of an amendment relationship where the target MRR > Source MRR and the target start date falls within this period and not in Draft) |
| Contraction MRR | The total Contraction MRR in a period. (The difference in MRR between a target and source of an amendment relationship where the target MRR < Source MRR and the target start date falls within this period and not in Draft) |
| Churned Renewal MRR | The total Churned Renewal MRR in a period. (Subscriptions that were Renewed from existing Subscriptions but Canceled in the given period) |
| Lapsed Renewal MRR | The total Lapsed Renewal MRR in a period. (Active subscriptions that expired in a period without being renewed) |
| Product Net Price (TCV) - Contraction Subscriptions | The Product Net Price (TCV) due to Contraction in a period (The difference in Product Net Price (TCV) between a target and source of an amendment relationship where the target TCV less than Source TCV and the target start date falls within this period and not in Draft). |
| Product Net Price (TCV) - Expansion Subscriptions | The Product Net Price (TCV) due to Expansion in a period (The difference in Product Net Price (TCV) between a target and source of an amendment relationship where the target TCV greater than Source TCV and the target start date falls within this period and not in Draft). |
| Product Net Price (TCV) - New Active Subscriptions | The total Product Net Price of the New Subscriptions started in a period (started in a period and which aren't a result of an amendment, suspension, or renewal of existing subscriptions). |
| Product Net Price (TCV) - Renewed Active Subscriptions | The total Product Net Price of the Renewed Subscriptions in a period (number of active subscriptions that are renewed from existing subscriptions). |
| Product Net Price (TCV) - Terminated Subscriptions | The total Product Net Price of the Subscriptions Terminated in a period (number of active subscriptions that are terminated in a period). This metric does not include TCV of the closed subscriptions due to the amendment or suspension of existing subscriptions. |
| Product Net Price (TCV) - Due for Renewal | The total Product Net Price of Subscriptions that are due for Renewal in a period. |
| Product Net Price (TCV) - Churned Renewal Subscriptions | The total Product Net Price of the Churned Renewal Subscriptions in a period (Subscriptions that were Renewed from existing Subscriptions but Canceled in the given period). |
| Product Net Price (TCV) - Lapsed Renewal Subscriptions | The total Product Net Price of the Lapsed Renewal Subscriptions in a period(Active subscriptions that expired in a period without being renewed). |
| Absolute MRR Churn | The Absolute MRR Churn. This metric is calculated as follows: (Lapsed Renewal MRR + Termination MRR + Churned Renewal MRR) |
| # of New Customers | The number of New Customers added in a period. (Customers who started an active subscription in a given period) |
| # of Churned Customers | The number of Customers Churned in a period (Customers whose active subscriptions were all terminated or expired without renewal in a given period) |
| New Customer MRR | The total MRR of a new Customer added in a period (started in a period and which aren't a result of an amendment, suspension, or renewal of existing subscriptions). |
| Product Net Price (TCV) - New Customers | The total Product Net Price of the New Customers added in a period (Customers who started an active subscription in a given period) |
| Change in # of Active Customers | The change in the number of Active Customers in a given period. This metric is calculated as follows: # of Active Customers (Period End) - # of Active Customers (Period start) |
| Change in # of Active Subscriptions | The change in the Number of Subscriptions in a given period. This metric is calculated as follows: Number of active subscriptions (Period End) - Number of active subscriptions (Period Start) |
| Change in Active MRR | The change in Active MRR in a given period. This metric is calculated as follows: Active MRR (Period End) - Active MRR (Period Start) |
| Change in Average Revenue per Customer | The change in Average Revenue per Customer in a given Period. This metric is calculated as follows: Average Revenue per customer (Period End) - Average Revenue per customer (Period Start) |
| Change in Product Net Price | The change in the Product Net Price in a given period. This metric is calculated as follows: Product Net Price (Period End) - Product Net Price (Period Start) |
| Customers Churn Rate % | The Customer Churn Rate. This metric is calculated as follows: # of Churned Customers /# of Active Customers (period start) |
| MRR Churn Rate % | The MRR Churn Rate. This metric is calculated as follows: 100 * (Lapsed Renewal MRR + Termination MRR + Churned Renewal MRR) / Active MRR (Period Start) |
| MRR Lapsed Renewal % | The MRR Lapsed Renewal Rate. This metric is calculated as follows: 100*Lapsed Renewal MRR/MRR Due for Renewal |
| MRR Renewal Rate % | The MRR Renewal Rate. This metric is calculated as follows: 100 * Activated Renewal MRR / MRR due for Renewal (Period End) |
| Net Revenue Retention Rate % | The Net Revenue Retention Rate. This metric is calculated as follows: 100 * Active MRR (Period End) / Active MRR (Period Start) |
| # of Expired Subscriptions | The total number of Subscriptions Expired in a period (Started as Active while entering in the Period, and Expired without being Renewed by the end of the Period, and also includes the Subscriptions marked as 'Do Not Renew') |