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.