This article will help you learn about the fields available in the Subscription Monthly Churn Rates view, the field types, descriptions and how the fields are calculated
Key Topics
Click on the links below to take you to the section where you can learn more about this View and where it is used and how it is created
WARNING: This view is only available to accounts that have Recharge installed
View Definition
This view is linked to the [drp.subscription_churn_monthly] table which generated as part of the Daasity transformation process and has the following fields available/visible for use.
| Field Name | Field Type | Description | Source / Calculation |
| Calendar Date | Dimension Group | The time period for the subscription activity | activity_month |
| Shipping Interval Frequency (Days) | Dimension | Days between subscription orders shipping | shipping_interval_frequency_days |
| Count Active Existing Subscriptions at Month End Date | Measure | Count of active subscriptions at month end that were not started in the current month | COALESCE(SUM(existing_subscriptions_at_end), 0) |
| Count Active New Subscriptions at Month End Date | Measure | Count of active subscriptions at month end that were started in the current month | COALESCE(SUM(new_subscriptions_at_end), 0) |
| Count Active Subscriptions at Month End Date | Measure | Active subscription on Month end date | COALESCE(SUM(subscriptions_at_end), 0) |
| Count Active Subscriptions at Month Start Date | Measure | Active subscription on Month start date | COALESCE(SUM(subscriptions_at_start), 0) |
| Count Churned Subscriptions | Measure | Total number of subscriptions churned | COALESCE(SUM(subscriptions_churned), 0) |
| Monthly Churn Rate | Measure | Rate customers are churning at the monthly level | AVG(days_in_month) * COALESCE(SUM(subscriptions_churned), 0) / (COALESCE(SUM(subscriptions_at_start), 0) * AVG(days_in_month) + 0.5 * (COALESCE(SUM(subscriptions_at_end), 0) - COALESCE(SUM(subscriptions_at_start), 0)) * AVG(days_in_month)) |
| Total Churned Subscriptions per Customer per Day | Measure | Rate customers are churning at the daily level | COALESCE(SUM(subscriptions_churned), 0) / (COALESCE(SUM(subscriptions_at_start), 0) * AVG(days_in_month) + 0.5 * (COALESCE(SUM(subscriptions_at_end), 0) - COALESCE(SUM(subscriptions_at_start), 0)) * AVG(days_in_month)) |
Explores
This view is part of the following explores:
- Subscription Monthly Churn Rates
Transformation Code
This view is a Daasity derived table generated by the following code:
- [4840_SUB_BAS_subscription_churn_month.sql]