
Re: Pulling Reporting  miscalculation on % columns?
Josh Hill Jul 12, 2016 8:43 AM (in response to Jennifer Bishop)What excel formula are you using and what is the difference? Can you show us?

Re: Pulling Reporting  miscalculation on % columns?
Jennifer Bishop Jul 12, 2016 9:19 AM (in response to Josh Hill)Sure, here is a screenshot of the Email Performance report I pulled (just kept the % Delivered and % Opened columns for this). I calculated the average by using the =AVERAGE(B2:B10) formula, and the median using the =MEDIAN(B2:B10) formula for the % Delivered column. As you can see, neither the average or median % I got using the formulas matches Marketo's total number. So I was wondering how they calculate the totals in those columns?

Re: Pulling Reporting  miscalculation on % columns?
Josh Hill Jul 12, 2016 9:27 AM (in response to Jennifer Bishop)2 of 2 people found this helpfulAh yes, this is a prob I had. Please use the RAW numbers to recalculate in Excel. This % avg will not give you accurate data because it is effectively unweighted.

Re: Pulling Reporting  miscalculation on % columns?
Jennifer Bishop Jul 12, 2016 9:45 AM (in response to Josh Hill)How would I get the RAW numbers in Excel from this data?

Re: Pulling Reporting  miscalculation on % columns?
Geoff Krajeski Jul 12, 2016 9:55 AM (in response to Josh Hill)You need the actual # Delivered & Opened.
From there you can calculate based on the total sum & then your percentage.

Re: Pulling Reporting  miscalculation on % columns?
Geoff Krajeski Jul 12, 2016 9:55 AM (in response to Geoff Krajeski)1 of 1 people found this helpfulNot using an average or median of the percentages as provided by Marketo.
You must use the RAW numbers as I mentioned above (totals)

Re: Pulling Reporting  miscalculation on % columns?
Jennifer Bishop Jul 12, 2016 10:45 AM (in response to Geoff Krajeski)Ahhhh, I see. So for example, I would divide the "Delivered" number by the "Sent" number and multiply that by 100 to get the actual percentage. Such as 1374/1407*100 would give me 97.7% which is the correct calculation. I get it now. I thought they were using an average/median formula for the total instead of doing it this way.
Thank you so much!!



