I have extracted the figures for a single campaign from both of the above tables and was surprised to see that the Consolidated Tracking table is reporting click figures quite a lot higher than those found in the Recipient Tracking Log.
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))).
Most of the time we see that count in tracking logs is higher than the consolidated tracking logs this may have happened because of numerous reasons, such as automatic workflow to update this schema is behind the tracking logs by 5 minutes or it was failed or was not successful because of a system restart, etc.
To fix this, select the concerned delivery in the Adobe Campaign Explorer, right-click and choose Action>Recompute delivery and tracking indicators. Select the highlighted option, Click Next, then click Finish.
Thanks for the reply. The campaign in question was sent out within the last two weeks and the purge values all seem to be standard. What would be the next steps in checking the technical process - considering the environment I'm currently accessing is Adobe hosted.
I'm slightly confused as to what could be throwing off the figures as surely the consolidated table is an aggregation of the tracking table/s.
Any thoughts? To clarify I have extracted a campaign with a single delivery and have used the delivery id from both the consolidated tracking table and recipient tracking logs to make sure that I'm not double counting instances where a URL may have been used across multiple campaigns/deliveries.