8 Replies Latest reply on Jul 19, 2018 12:47 AM by James Taylor

    Unique Email Opens/Clicks

    James Taylor

      I have exported all of our email data from our service provider Silverpop. The data consists of 1 row of data for each 'action' taken on a particular email, for example, send, open, click, opt-out etc.

       

      The problem I'm having is with summing the Open and Click volumes. I want to calculate the unique number of Opens/Clicks on each email rather than the total number as there are cases where perhaps a contact has opened or clicked multiple times and this then doesn't give a true reflection of the email performance.

       

      Does anybody have any suggestions of how I could write the calculation to get the unique sum?

       

      Thanks in advance