The Churned MRR (Delinquent) by Plan Name metric is a measure of the revenue lost due to customers who have failed to pay their subscription dues by plan. This metric helps businesses determine which subscription plans have the highest delinquent rates and revenue loss due to churn. By having insights into this metric, businesses can identify opportunities to improve customer retention and reduce delinquent payments while optimizing their subscription plans and pricing strategy. We calculate Churned MRR (Delinquent) by Plan Name by considering all 'canceled' subscriptions that have either already ended or will end after the start of the selected date range. We exclude 'canceled' trial subscriptions. Since we calculate this metric using subscriptions and delinquency, which is a current property of the customer, we cannot obtain information about past delinquencies of a customer if they have either revived their canceled subscription or signed up for a new one and are currently not marked as delinquent. If your subscriptions contain multiple subscription items and you apply discounts, the total value of this metric will be higher than the total value of an equivalent non-dimensional metric, as subscription discounts cannot be divided among multiple subscription items.
Example: The Churned MRR (Delinquent) by Plan Name metric can be used to identify which subscription plans have the highest amount of lost revenue due to payment delinquencies, allowing a company to improve their dunning processes and potentially update pricing or features for those plans.