10 Replies Latest reply on Nov 6, 2017 6:31 PM by Vandana Samtani

    Churn Rate Calculation

    Vandana Samtani

      Hi Guys, I have a data set and would like to calculate the churn rate based on the logic below -

       

      On my dashboard I have a date range filter default to 30 days and the users are looking for churn rate to change if the date range changes.

       

      Let's take an example below. From the above logic

       

      Sep 11 to Oct 11 is the 30 day rolling window - I am excluding the last few days from Oct 20 - Oct 11 because these could be trial users which is already excluded in my query.

       

      on Sep 11th - How many total subs as of Sep 11? So business is looking for total subs from July 31st to Sep 11 in this bucket. e.g. 500

      Cancellation - Total Cancellations between Sep 11 to Oct 11 in this bucket. e.g.50

       

      divide the cancelltions/total subs as of Sep 11

      50/500 = 10%

       

      the final data set should be

       

      Churn Date          Churn Percentage

      10/11/2017                   10%

      10/12/2017                    9%     For this we should look data from Oct 12 to Sep 12 - How many subs as of Oct 12? How many cancellations between Sep 12th and Oct 12? then the calculations.

      10/13/2017                    15%   For this we should look data from Oct 13 to Sep 13 - How many subs as of Oct 13? How many cancellations between Sep 13th and Oct 13? then the calculations.