Analysis Overview and Data Quality
Churn Prediction Configuration
Analysis overview and configuration
test_1766219250
Analysis Overview
This section provides insights into the churn prediction analysis setup, key metrics, and data characteristics to understand subscription churn risk and customer behavior.
The analysis aims to predict subscription churn risk and identify at-risk customers. The higher churn rate for the Basic plan suggests a need for targeted retention strategies. The significant MRR contribution from active subscriptions highlights the importance of retaining these customers to maintain revenue.
The analysis lacks details on customer demographics or engagement metrics, which could provide deeper insights into churn behavior. Understanding customer interactions and preferences could enhance the accuracy of churn predictions and retention efforts.
Analysis Overview
This section provides insights into the churn prediction analysis setup, key metrics, and data characteristics to understand subscription churn risk and customer behavior.
The analysis aims to predict subscription churn risk and identify at-risk customers. The higher churn rate for the Basic plan suggests a need for targeted retention strategies. The significant MRR contribution from active subscriptions highlights the importance of retaining these customers to maintain revenue.
The analysis lacks details on customer demographics or engagement metrics, which could provide deeper insights into churn behavior. Understanding customer interactions and preferences could enhance the accuracy of churn predictions and retention efforts.
Data Quality & Completeness
Data preprocessing and column mapping
Data Preprocessing
This section details the data preprocessing steps, including data cleaning, retention rate calculation, and data split information.
The data preprocessing section indicates that no data was available for analysis after cleaning. The 100% retention rate suggests that no data was lost during the cleaning process, but the absence of final data may hinder the analysis objectives.
The lack of data after preprocessing raises concerns about the availability or quality of the initial dataset. Without data for analysis, the insights and conclusions drawn from this dataset may be limited or unreliable.
Data Preprocessing
This section details the data preprocessing steps, including data cleaning, retention rate calculation, and data split information.
The data preprocessing section indicates that no data was available for analysis after cleaning. The 100% retention rate suggests that no data was lost during the cleaning process, but the absence of final data may hinder the analysis objectives.
The lack of data after preprocessing raises concerns about the availability or quality of the initial dataset. Without data for analysis, the insights and conclusions drawn from this dataset may be limited or unreliable.
Key Findings and Recommendations
Key Findings & Recommendations
| Metric | Value |
|---|---|
| Overall Churn Rate | 10% |
| Active Subscriptions | 36 |
| Churned Subscriptions | 5 |
| Total MRR | $2,566.75 |
| MRR at Risk | $0 |
| Avg Tenure | 0 months |
Bottom Line: Overall churn rate is 10% (5 churned out of 50 subscriptions), with $2,566.75 active MRR and $0 at risk.
Key Findings:
• Churn rate of 10% indicates concerning subscription health
• 36 active subscriptions generating $2,566.75 MRR
• Average subscription tenure: 0 months
• 1 pending cancellations ($0 at risk)
• 3 plans analyzed across 50 subscriptions
Recommendations:
• Focus retention on pending cancellations with highest MRR value
• Investigate plans with above-average churn rates
• Improve onboarding for cohorts with steep early drop-off
• Implement win-back campaigns for recently churned high-value customers
• Monitor monthly churn trends to catch emerging problems early
Executive Summary
This section provides a concise overview of the key findings from the executive summary of the churn prediction analysis, focusing on metrics such as overall churn rate, active subscriptions, canceled subscriptions, total monthly recurring revenue (MRR), and pending MRR.
The 10% churn rate highlights the need to focus on retention strategies to reduce customer attrition. With 36 active subscriptions contributing to $2,566.75 MRR, efforts should be directed towards retaining these customers and potentially exploring reasons for the churned subscriptions.
The analysis provides valuable insights into subscription dynamics, but further investigation into the reasons behind churn and strategies to improve retention may be necessary for a more comprehensive understanding of the subscription landscape.
Executive Summary
This section provides a concise overview of the key findings from the executive summary of the churn prediction analysis, focusing on metrics such as overall churn rate, active subscriptions, canceled subscriptions, total monthly recurring revenue (MRR), and pending MRR.
The 10% churn rate highlights the need to focus on retention strategies to reduce customer attrition. With 36 active subscriptions contributing to $2,566.75 MRR, efforts should be directed towards retaining these customers and potentially exploring reasons for the churned subscriptions.
The analysis provides valuable insights into subscription dynamics, but further investigation into the reasons behind churn and strategies to improve retention may be necessary for a more comprehensive understanding of the subscription landscape.
Current Status Distribution
Status Distribution
Subscription status distribution and health overview
Subscription Health
This section provides an overview of the current subscription status distribution, highlighting the number of active, churned, and trialing subscriptions, along with the total Monthly Recurring Revenue (MRR) from active subscriptions and pending cancellations.
The high percentage of active subscriptions and MRR contribution are positive indicators of customer retention and revenue stability. The churn rate of 10% suggests room for improvement in retaining customers. Trialing subscriptions may convert to active, impacting future MRR positively.
Understanding the distribution of subscription statuses is crucial for assessing the health of the subscription business model and identifying areas for improvement in customer retention and revenue growth.
Subscription Health
This section provides an overview of the current subscription status distribution, highlighting the number of active, churned, and trialing subscriptions, along with the total Monthly Recurring Revenue (MRR) from active subscriptions and pending cancellations.
The high percentage of active subscriptions and MRR contribution are positive indicators of customer retention and revenue stability. The churn rate of 10% suggests room for improvement in retaining customers. Trialing subscriptions may convert to active, impacting future MRR positively.
Understanding the distribution of subscription statuses is crucial for assessing the health of the subscription business model and identifying areas for improvement in customer retention and revenue growth.
Identifying Problematic Plans
Plan-Level Churn Rates
Churn rates by subscription plan
Churn by Plan
This section compares churn rates across 3 subscription plans to identify any disparities that may indicate potential issues with pricing, features, or value propositions. The overall churn rate of 10% sets a benchmark for evaluating individual plan performance.
The higher churn rate for the Basic plan compared to the other plans may signal potential issues that need further investigation. Understanding why customers are leaving this plan at a higher rate can help in devising strategies to improve retention and overall customer satisfaction.
The churn rates alone do not provide the full picture; additional analysis on customer feedback, competitor offerings, and market trends could provide deeper insights into the reasons behind the observed churn rates.
Churn by Plan
This section compares churn rates across 3 subscription plans to identify any disparities that may indicate potential issues with pricing, features, or value propositions. The overall churn rate of 10% sets a benchmark for evaluating individual plan performance.
The higher churn rate for the Basic plan compared to the other plans may signal potential issues that need further investigation. Understanding why customers are leaving this plan at a higher rate can help in devising strategies to improve retention and overall customer satisfaction.
The churn rates alone do not provide the full picture; additional analysis on customer feedback, competitor offerings, and market trends could provide deeper insights into the reasons behind the observed churn rates.
Monthly Churn Rate Over Time
Monthly Churn Over Time
Monthly churn rate trends over time
Churn Trends
This section presents the monthly churn rate trends from January 2024 to November 2024, highlighting the total of 5 cancellations during this period. Understanding these trends is crucial for identifying retention issues within the subscription service.
The consistent churn rate suggests a steady level of subscription cancellations over the months. While the overall churn rate is at 10%, the specific monthly churn rates remained low at 2%. This stability could indicate a predictable pattern in subscription cancellations.
The analysis focuses on the churn trends within the specified timeframe, providing insights into the monthly subscription cancellations. Further analysis could explore factors influencing these churn rates to improve retention strategies.
Churn Trends
This section presents the monthly churn rate trends from January 2024 to November 2024, highlighting the total of 5 cancellations during this period. Understanding these trends is crucial for identifying retention issues within the subscription service.
The consistent churn rate suggests a steady level of subscription cancellations over the months. While the overall churn rate is at 10%, the specific monthly churn rates remained low at 2%. This stability could indicate a predictable pattern in subscription cancellations.
The analysis focuses on the churn trends within the specified timeframe, providing insights into the monthly subscription cancellations. Further analysis could explore factors influencing these churn rates to improve retention strategies.
Retention by Signup Month
Retention by Signup Month
Cohort retention analysis by signup month
Cohort Retention
This section focuses on cohort retention analysis by signup month, highlighting the average subscription tenure of 0 months. It aims to identify potential onboarding issues through observing drop-off patterns in early months.
The data reveals a concerning trend where all cohorts experience high churn rates within the first month, indicating a need to improve customer retention strategies and onboarding processes. The consistent 100% retention rate implies a lack of long-term engagement.
The findings underscore the critical importance of addressing onboarding issues and enhancing early customer experiences to improve overall subscription retention rates. Further analysis into the onboarding process and early user engagement may provide insights into reducing churn and increasing customer lifetime value.
Cohort Retention
This section focuses on cohort retention analysis by signup month, highlighting the average subscription tenure of 0 months. It aims to identify potential onboarding issues through observing drop-off patterns in early months.
The data reveals a concerning trend where all cohorts experience high churn rates within the first month, indicating a need to improve customer retention strategies and onboarding processes. The consistent 100% retention rate implies a lack of long-term engagement.
The findings underscore the critical importance of addressing onboarding issues and enhancing early customer experiences to improve overall subscription retention rates. Further analysis into the onboarding process and early user engagement may provide insights into reducing churn and increasing customer lifetime value.
At-Risk Subscriptions by Category
At-Risk Subscription Distribution
Churn risk distribution for active subscriptions
Risk Assessment
This section assesses the risk distribution for active subscriptions, highlighting the financial impact of pending cancellations and the urgency for retention efforts.
The absence of MRR at risk suggests minimal financial impact from pending cancellations. However, the presence of a pending cancellation necessitates proactive retention strategies to prevent further churn. The majority of subscriptions are in the “Low” risk category, indicating a need for targeted retention efforts to mitigate potential losses.
The analysis focuses on current risk levels and pending cancellations, providing insights into the immediate churn threat. Understanding risk distribution aids in prioritizing retention efforts and optimizing revenue retention strategies.
Risk Assessment
This section assesses the risk distribution for active subscriptions, highlighting the financial impact of pending cancellations and the urgency for retention efforts.
The absence of MRR at risk suggests minimal financial impact from pending cancellations. However, the presence of a pending cancellation necessitates proactive retention strategies to prevent further churn. The majority of subscriptions are in the “Low” risk category, indicating a need for targeted retention efforts to mitigate potential losses.
The analysis focuses on current risk levels and pending cancellations, providing insights into the immediate churn threat. Understanding risk distribution aids in prioritizing retention efforts and optimizing revenue retention strategies.
MRR Contribution by Plan
MRR by Plan
Performance metrics by subscription plan
Plan Performance
This section compares performance metrics across 3 subscription plans to understand their impact on the total Monthly Recurring Revenue (MRR) of $2,566.75.
The data reveals differences in subscription counts, active rates, and MRR among the plans. The high active rate and MRR of the “Enterprise” plan suggest it may be the most profitable, while the “Basic” plan has the lowest MRR despite a higher active rate.
These metrics provide insights into the performance of individual subscription plans, helping to identify strengths and weaknesses that can inform strategies for optimizing revenue and customer retention.
Plan Performance
This section compares performance metrics across 3 subscription plans to understand their impact on the total Monthly Recurring Revenue (MRR) of $2,566.75.
The data reveals differences in subscription counts, active rates, and MRR among the plans. The high active rate and MRR of the “Enterprise” plan suggest it may be the most profitable, while the “Basic” plan has the lowest MRR despite a higher active rate.
These metrics provide insights into the performance of individual subscription plans, helping to identify strengths and weaknesses that can inform strategies for optimizing revenue and customer retention.
When Customers Churn
Churn by Subscription Age
Churn patterns by subscription tenure
Tenure Analysis
This section examines churn distribution based on subscription tenure, highlighting the $305 MRR churned in total. Early churn (0-1 months) may indicate onboarding issues, while later churn could suggest value decay.
The high churn rate within the first month suggests potential issues with onboarding, product fit, or customer expectations. Understanding and addressing these early churn factors could help improve customer retention and overall revenue.
This section provides valuable insights into the timing of churn within the subscription lifecycle. Further analysis could delve into specific reasons for early churn and strategies to mitigate it, aligning with the overall goal of predicting and reducing churn.
Tenure Analysis
This section examines churn distribution based on subscription tenure, highlighting the $305 MRR churned in total. Early churn (0-1 months) may indicate onboarding issues, while later churn could suggest value decay.
The high churn rate within the first month suggests potential issues with onboarding, product fit, or customer expectations. Understanding and addressing these early churn factors could help improve customer retention and overall revenue.
This section provides valuable insights into the timing of churn within the subscription lifecycle. Further analysis could delve into specific reasons for early churn and strategies to mitigate it, aligning with the overall goal of predicting and reducing churn.
Revenue Breakdown
Revenue Analysis
Monthly Recurring Revenue breakdown
| Metric | Value |
|---|---|
| Active MRR | $2,566.75 |
| Avg MRR/Subscription | $71.3 |
| Churned MRR | $305 |
| Pending Churn MRR | $0 |
MRR Breakdown
This section provides a breakdown of Monthly Recurring Revenue (MRR) metrics, including total MRR, average MRR per subscription, churned MRR, and pending MRR. Understanding these metrics is crucial for assessing revenue performance and identifying areas of potential revenue loss due to churn.
The total MRR of $2,566.75 indicates the current revenue stream from active subscriptions. The average MRR per subscription helps understand the value each customer brings. The churned MRR of $305 highlights the revenue impact of lost subscriptions. Pending MRR being $0 suggests no immediate revenue loss but potential future impact.
These MRR metrics are essential for tracking revenue performance and understanding the financial implications of subscription churn. However, further analysis may be needed to identify factors contributing to churn and strategies to mitigate revenue loss.
MRR Breakdown
This section provides a breakdown of Monthly Recurring Revenue (MRR) metrics, including total MRR, average MRR per subscription, churned MRR, and pending MRR. Understanding these metrics is crucial for assessing revenue performance and identifying areas of potential revenue loss due to churn.
The total MRR of $2,566.75 indicates the current revenue stream from active subscriptions. The average MRR per subscription helps understand the value each customer brings. The churned MRR of $305 highlights the revenue impact of lost subscriptions. Pending MRR being $0 suggests no immediate revenue loss but potential future impact.
These MRR metrics are essential for tracking revenue performance and understanding the financial implications of subscription churn. However, further analysis may be needed to identify factors contributing to churn and strategies to mitigate revenue loss.