Email Performance Report - Discrepancy in Totals

Version 5

    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