I'm trying to create an extract of a particular group of emails. I am counting SubKeys from the _Sent table for deliveries and counting IsUnique = 1 from _Opens for unique opens.
When I test this, the numbers from the SQL query are somewhat below (<100 difference) compared to what I am seeing in Tracking>Sends for a particular email in my results table.
Should I be querying a different table? Is there a reason for the margin of error between SQL and the Tracking report?
Hello @Adam T.,
The difference in numbers between your SQL query and the Tracking>Sends report could be due to several factors. First, ensure you’re querying the correct tables: the _Sent table for deliveries and the _Opens table for unique opens is correct. However, reports may include additional filters or data points, like bounced emails or suppression lists, which your SQL might not consider. Also, reporting can sometimes have slight delays in data processing. Check for any filters or parameters in the report that might affect the counts and ensure your SQL query aligns with those.
Regards
Sunny Patwa
