Jan 14, 2021 12:49 PM
I just started using the email health tool, which I understand is in beta mode so I'm not sure how many users have that feature yet. I love the tool and it's already made a huge improvement in my email marketing strategies. However, I've noticed the date ranges don't update very frequently and the percentages are different from what I'm calculating manually. Is there any way to update the date range or select a specific date range to view? And is there more data that goes into calculating the open and click rate overall percentages than meets the eye? My percentages are off if it's just a black and white average of open and click rates, and I'd love some more insight if anyone has it! Thank you so much!!
Solved! Go to Solution.
Jan 15, 2021 9:35 AM
Jan 14, 2021 4:51 PM
Happy to hear that you're loving the tool! I'll share that with the team. 🙂
Could you share some details on how you're calculating click + open rate? There can sometimes be discrepancies in how people calculate it.
For the tool, we calculate the open rate from the number of people who opened, out of the number of emails delivered- not out of the number of emails sent. That is often where we find the discrepancy.
So if your sent list was 10,000 people, but it was only delivered to 5,000 out of that 10,000, we'd be doing the math for opens/clicks out of 5k - not 10k.
If you are also calculating from opens or clicks out of delivered and not sent, a screenshot comparing the numbers you're getting vs what we are showing would be great!
Jan 15, 2021 8:40 AM
Hi Dana! Sure, I calculate the overall open rate by pulling the open rate numbers provided in the email tool. To be sure they were pulling from the delivered and not overall sent, I spot checked a few of them (in the attached screenshot). I then took all of those percentages and added them for a total of 247.5%. I divided that number by 10 (for 10 completed sends between 12/12 and 1/13) and got an average open rate of 24.75%.
Not sure if other factors might go into the calculation such as list size for each send (they are usually different since I segment them out), or maybe I did the calculation wrong! Any ideas would be greatly appreciated 😊
Jan 15, 2021 9:24 AM - edited Jan 15, 2021 9:40 AM
There is indeed a mistake in your calculation. Each open rate has a different "weight" because of different list sizes. By calculating the average, you're not taking this "weight" into account. An easy fix is looking at the sum of all opens and divide that by the sum of all emails delivered, see the example below.
Taking the average of the third column, you'd arrive at 35%. (20+5+80) / 3 = 35.
However, with 70 opens out of 350 emails delivered, the actual average open rate is 20%.
|SUM: 350||SUM: 70||AVG: 20%|
Hope this helps!
Jan 15, 2021 9:35 AM