2 Replies Latest reply: Mar 24, 2010 3:44 PM by Henry Noh RSS

    Recurring Clients over Periods

    Henry Noh

      I have several years of data with thousands of clients each. How can I create a set/chart/expression that will list the recurring clients if there are any? Thank you!

        • Recurring Clients over Periods
          Vlad Gutkovsky

          You need to do this in the script of course. I would say after you have loaded in the client table, make a new table, group by client_id, then code if (count(purchase#) > 1, 1, 0) as RepeatCustomerFlag. In this example, you would be tracking whether a customer has more than 1 purchase number, and if so, he is a repeat customer. Then, in your chart, you could use set the dimension to something like this: if(RepeatCustomerFlag=1,client_id) and suppress nulls.

          Regards,