Pulling Reporting - miscalculation on % columns? | Community
Skip to main content
Jennifer_Bisho1
Jennifer_Bisho1
New Participant
July 12, 2016
Solved

Pulling Reporting - miscalculation on % columns?

  • July 12, 2016
  • 1 reply
  • 3006 views

I'm trying to pull an overall Email Performance Report for an entire folder of email programs (roughly 50 emails).  The report calculates the totals at the bottom of the spreadsheet, however when I try to do the calculations myself using formulas, the numbers do not match up.

Does anyone know how Marketo calculates the total of the % columns?  I thought maybe the total represented the % average or median in that column, but that doesn't seem to be the case.  This makes me nervous about trusting Marketo reporting.  I need to do this for 6 different folders and then pull an average total per column for a summary report.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by gkrajeski-SWLN

Ah 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.


You need the actual # Delivered & Opened.

From there you can calculate based on the total sum & then your percentage.

1 reply

Josh_Hill13
Josh_Hill13
New Participant
July 12, 2016

What excel formula are you using and what is the difference? Can you show us?

Jennifer_Bisho1
Jennifer_Bisho1Author
New Participant
July 12, 2016

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?

Josh_Hill13
Josh_Hill13
New Participant
July 12, 2016

Ah 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.

Terms & ConditionsAccessibility statement

Loading footer...