Email Performance Report - Discrepancy in Totals

A document by KCS Integration on behalf of Cedric Roxas on Mar 4, 2018Last modified by Vishal Sharma on Jun 26, 2018
Version 5Show Document
  • View in full screen mode

Issue Description

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.

 

 

Issue Resolution
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


Is this article helpful ?

YesNo


Attachments

    Outcomes