1 Reply Latest reply on May 24, 2016 1:05 AM by du yingtao

    Customer Analysis

    jitan.chainani

      Hi Guys,

       

      I am building a dashboard that includes customer purchase data by months. I want to calculate how soon or often the customer drops and comes back.

      I tried using cohort analysis but did not give me the right results.

       

      So for e.g.

       

      Customer  1 had purchased some items in Jan, Feb, March..... and dropped in April, May,June bought again in July. In this case the customer dropped after 3 months and came back after 3 months.

       

      Customer  2 had purchased some items in Jan  and dropped in Feb,March, April, May,June bought again in July. In this case the customer dropped after 1 months and came back after 5 months.

       

      I just want to give the users a high level count of how many customers dropped after 1,2,3,4,5,6........months.

       

      Any suggestions would be helpful?

       

      Thanks,

      JC

        • 1. Re: Cohort Analysis
          du yingtao

          HI JC

           

              I ran into a similar problem.

              to recognize  the custom is the real new custom(never purchase) or the custom is which had been my custom 6 months before,

               it too complex , I solved by  SQL

           

             Hope it is helpful   

           

          Duyingtao

          1 of 1 people found this helpful