MRR Upgrades by New Plan Name is a metric that shows the amount of monthly recurring revenue generated from customers upgrading to a new pricing plan, organized by the specific plan they upgraded to.
With Databox you can track all your metrics from various data sources in one place.
Used to show comparisons between values.
Databox is a business analytics software that allows you to track and visualize your most important metrics from any data source in one centralized platform.
To track MRR Upgrades by New Plan Name using Databox, follow these steps:
Usage Upgrades or downgrades are tracked when they actually happen. For example, if a user moved from PlanA ($59) to PlanB ($119) today, an upgrade of $60 will be tracked. The same logic will apply to downgrades.
In cases where the user would switch back and forth, every upgrade and downgrade would be tracked and would influence the upgrade or downgrade amount in Databox. Therefore, Databox suggests using the Calculated Metrics to track the Net New Upgrade or Downgrade values.
Below is an example of the MRR Upgrades metric and the same logic will apply for other Upgrades and Downgrades metrics.
Net New MRR Upgrades = MRR Upgrades – MRR Downgrades
Limitation To calculate upgrades, downgrades, and reactivations we use the /events endpoint. In accordance with the Stripe API documentation, Databox can collect only 30 days of historical data through this API endpoint. For example, if an upgrade occurred 31 days ago, it would not be pushed to and visible in Databox today.
Refunds metric measures the amount of money refunded to customers for a specific period of time. It helps businesses understand how much revenue they have lost due to refunds and identify areas for improvement in their product or service.
Churned MRR measures the loss or decline in revenue generated from existing customers due to cancellations, downgrades, or pricing changes.
Active Subscriptions metric refers to the number of recurring payment plans that currently have an active or past due status.
New Subscriptions (incl. Trials and Inactive Plans) metric tracks the number of new recurring payments or subscription sign-ups including Trials, Active Plans, and Inactive Plans made by customers in a given period of time.
Churned Customers (Delinquent) metric measures the number of customers who fail to pay recurring payments and cancel their subscription. This helps to track the loss of revenue due to customer attrition.
The Downgrades metric measures the number of customers who have shifted from a higher-priced subscription plan to a lower-priced one within a specified timeframe.
Open Invoices is a metric that measures the total number of invoices that have been issued to customers but have not been marked as paid or voided.
Overdue Invoices Amount metric in Stripe tracks the total amount of unpaid invoices that are past their due date, providing an overview of the outstanding balance that customers owe.