Find Your Frequent Email Readers Using Excel

Back in September, I told you about our experiment to see who our most loyal newsletter readers were. I thought that was a better measure of email engagement than simply looking at open or click rates.

We used our CRM to help us figure this out, but I knew there had to be a way to do it in Excel too, so I put out the call for help.

Two of your peers heard the call, and came up with solutions. Thank you Karin Flom of Student Press Law Center and Heidi Pickman of CAMEO!

Karin and Heidi use two different approaches, and both require that you have some Excel skills. But either way works if you want to replicate the analysis I did using Excel.