View: Subscriber Monthly Churn Rates

This article will help you learn about the fields available in the Subscriber 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.subscriber_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 subscriber activity activity_month
Churn Rate Measure Subscriber churn rate. Calculated as subscribers who ended a period with 0
active subscriptions divided by subscribers with at least one active subscription
at the beginning of the period.
COALESCE(SUM(subscribers_churned), 0) / COALESCE(SUM(subscribers_at_start), 0)
Count Active Subscribers Measure Active subscribers in time period COALESCE(SUM(subscribers_at_start), 0)
Count Churned Subscribers Measure Churned subscribers in time period COALESCE(SUM(subscribers_churned), 0)


This view is part of the following explores:

  • Subscriber Monthly Churn Rates

Transformation Code

This view is a Daasity derived table generated by the following code:

  • [4850_SUB_BAS_subscriber_churn_month.sql]