Email Performance Report - Discrepancy in Totals

Issue

An Email Performance Report in Marketo was exported and opened in Microsoft Excel and the email open percentage and average click percentage is calculated using the AVERAGE function in Microsoft Excel. There is a difference in the average total calculated using the AVERAGE function in Microsoft Excel as opposed to the Total calculated in the Marketo Email Performance report.

 


Solution

Marketo's total is a 'Weighted Average' which is different to a normal average calculation in Microsoft Excel

"A weighted average differs from an average in that a weighted average returns a number that depends on the variables of both value and weight."

https://support.microsoft.com/en-us/help/214049/how-to-calculate-weighted-averages-in-excel