Average open rate per list

[Divemasterza]

Unless I missed it somewhere. Is there a way to get the average open rate per list?

 

[twisted1919]

How would you calculate it?

 

[Divemasterza]

How would you calculate it?

Average of all campaigns sent to that list open rate.

(Σ open% for the list)/count of campaigns sent to  list

it was a request from a client: What's the average open rate for the master list? Had to do it manually

 

[nadworks]

Just reiterating the increasing unreliability of open rates: https://forum.mailwizz.com/threads/how-to-keep-lists-clean.7908/post-48859
Just a couple of many sources:

"Death of the Open Rate"? Apple Mail Privacy Protection and Pardot | Salesforce Ben

Read about how Apple Mail's Privacy Protection feature is impacting email marketing and learn how to navigate these changes with Pardot.

www.salesforceben.com

How Apple’s Mail Privacy Changes Affect Email Open Tracking

Apple’s iOS 15 Mail Privacy Protection update has a major impact on email marketing. Here’s everything you need to know.

postmarkapp.com

 

[Divemasterza]

@nadworks I agree with you they are unreliable, Gmail, mimecast and others are scanning the links, so open and click rates are affected.
The lambda client is however still attached to these indicators. Even taken with a pinch of salt...

 

[twisted1919]

Average of all campaigns sent to that list open rate.

(Σ open% for the list)/count of campaigns sent to  list

it was a request from a client: What's the average open rate for the master list? Had to do it manually

I've added it for future