1 Reply Latest reply on Apr 10, 2018 5:01 PM by Deepak Rai

    Cohort analysis count only repeat customers

    L L

      So I am doing your standard cohort analysis.


      Group customers into first month of purchase cohort

      [First order date]

      {FIXED [customer email]: MIN([Order Date])}


      [Repeat Purchase]

      iff( [Order Date] > [First order date],[Order Date] ,null)


      [2nd purchase]

      {FIXED [customer email]: MIN([Repeat Purchase])}



      Now what I am looking for is a count of distinct customer that made a repeat purchase.


      If I do COUNTD([2nd purchase]) it returns a count of all repeat purchase not just a count of repeat customers. Any insight would be greatly appreciated.