1 Reply Latest reply: Jun 15, 2014 2:53 PM by Gysbert Wassenaar RSS

    Churn and Retention Analysis

      Hi fellow QlikViewers.

       

      Does anyone having any example documents with charts of retention analysis or churn stats that they would like to share here.

       

      I need to create a chart showing how many customers were active on each day in a month - that is easy. I then need to show for each day, how many of those SAME customers were still active D+1, D+2 up to D+7 days after that, e.g.

       

                 Number on Day    Day+1        Day+2        etc etc

      01-JUN-2014    60                              30 ( 50% )           20 ( 33% )    ...

      02-JUN-2014    50                              40 ( 80% )           10 ( 20% )    ...

      03-JUN-2014    32                              24 ( 75% )           16 ( 50% )

      ...

       

      In other words the 30 customers active on 02-JUN-2014 were only one half of those active on 01-JUN-2014. The fact that there were 50 people active on 02-JUN-2014 is immaterial for the 01-JUN-2014 retention line as some of these 50 people are new customers who were not active on 01-JUN-2014. Each date can be considered in isolation.

       

      Regards

      Andrew.