Email Performance Report Data Error

[NCHAN]

My colleague runs a yearly email performance report. Marketo shows a total sent of 5.8m. 

However, after downloading, the true number we find in Exel is 6.8m.

I create a new report and also see 6.8m.

I think there's a chance that Marketo does the wrong calculations. 

[Katja_Keesom]

I am not sure how you did the reconciliation in excel, but please bear in mind that the email performance report has some logic applied. For example, the same email being sent to the same person twice will only count as 1 sent in the report, even though you will see two activities listed. Another suggestion would be to always refresh your report before looking at it, this does not always happen automatically. If you rebuild the same report and it shows different numbers, that could be the likely cause. Finally, check whether your smart list contains any filters.

Hope this helps in finding out what the cause of the issue is.

[NCHAN]

Good points for a double-check. However, I did refresh the report and nothing was contained in my smart list.

I suppose this is a system error or something.

[Katja_Keesom]

Last silly check: Both reports have the same time reference set?

[Jon_Wright]

Make sure your colleague has refreshed the report itself (bottom left of report tab pane) - browser refresh alone won't give you latest numbers.