Hi Alistair,I am sure you are counting unique clicks from you tracking logs, please double check if you are counting unique or all?Consoldated logs count all clciks not just uniue clcoks. i.e.,Sum of all @totalClicks with a URL type equal to "Email click"(sum(Iif([url/@type]=1, @totalClicks, 0))).Mo...