Email Performance Report Data Error

NCHAN
Level 2

Email Performance Report Data Error

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

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. 

4 REPLIES 4
Katja_Keesom
Level 10 - Community Advisor + Adobe Champion

Re: Email Performance Report Data Error

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
Level 2

Re: Email Performance Report Data Error

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
Level 10 - Community Advisor + Adobe Champion

Re: Email Performance Report Data Error

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

Jon_Wright
Level 4

Re: Email Performance Report Data Error

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