Spamdex - Spam Archive

Report spam

Send in your spam and get the offenders listed

Create a rule in outlook or simply forward the spam you receive to questions@spamdex.co.uk

Also in nonprofitmarketingguide.com

[Kivi's Blog] Find Your Frequent Email Readers Using Excel

Here's the latest blog post from Kivi's Nonprofit Communications Blog.

Click on the post title to see the post with graphics or to participate in the discussion in the comments.


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. Here’s what we discovered:

 

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

OPTION #1: Use the Excel Template Heidi Built

You can download the Excel template Heidi built here and follow the instructions inside.

OPTION #2: Use a Pivot Table Following Karin’s Instructions

Karin provided the following instructions, starting with MailChimp (but you can use anything that allows you to export lists).

1) MailChimp allows you to go to the email report and view all sorts of data about the email: who did you send to, who opened, who clicked, who didn’t open, etc. When you click those specifics in the report, you have the option to export them with one click as a CSV.

2) I exported “subscribers who opened” from our last four weekly emails. I quickly cut and paste those emails into one column in a new Excel workbook.

3) By creating a pivot table and putting Column A “Opens” into the “Rows” and “Values” sections, Excel will tell you how many times each unique value appears in your data. In this case, I had 690 people open at least one of the four emails.

karinscreenshot
4) Go to a fresh cell on your pivot table sheet and use the “COUNTIF” function. For example, in my pivot table sheet, column B was the count of how many emails a subscriber had opened (values ranging from 1-4). Your formula should look like this, with the # replacing your row numbers of your data and changing the 4 to a 3 to count the number of people who opened 3 of 4 emails, etc. (The quotation marks are necessary in the formula).

=COUNTIF(B#:B#, “=4″)

5) Based on an average of 1250 users, here are my results:

126 (4 opens) 10.08%
67 (3 opens) 5.36%
151 (2 opens) 12.08%
346 (1 open) 27.68%
690 (total 1+ opens over 4 emails) 55.20%

new-email-metrics-excel
I would say this took about 20 minutes, but I was going slow and trying to figure it out. Going forward as a monthly metric mechanism, I would say it would only take me about 10 minutes. Definitely worth it for this extra insight.

BONUS: I can copy and paste the emails from the pivot table for “highly engaged” subscribers and create a pasted segment in MailChimp if I ever want to email these folks directly.

Thank you Heidi and Karin!

 

 

If you no longer wish to receive our emails, click the link below:
 Click Here to Stop Receiving Email from Us

 Click Here to Manage or Update Your Subscriptions



Nonprofit Marketing Guide - EcoScribe Communications, 319 Becks Church Road Lexington, North Carolina 27292 United States (336) 300-8394

---------------------------

All titles, content, publisher names, trademarks, artwork, and associated imagery are trademarks and/or copyright material of their respective owners. All rights reserved. The Spam Archive website contains material for general information purposes only. It has been written for the purpose of providing information and historical reference containing in the main instances of business or commercial spam.

Many of the messages in Spamdex's archive contain forged headers in one form or another. The fact that an email claims to have come from one email address or another does not mean it actually originated at that address! Please use spamdex responsibly.


Yes YOU! Get INVOLVED - Send in your spam and report offenders

Create a rule in outlook or simply forward the junk email you receive to questions@spamdex.co.uk | See contributors

Google + Spam 2010- 2017 Spamdex - The Spam Archive for the internet. unsolicited electric messages (spam) archived for posterity. Link to us and help promote Spamdex as a means of forcing Spammers to re-think the amount of spam they send us.

The Spam Archive - Chronicling spam emails into readable web records index for all time

Please contact us with any comments or questions at questions@spamdex.co.uk. Spam Archive is a non-profit library of thousands of spam email messages sent to a single email address. A number of far-sighted people have been saving all their spam and have put it online. This is a valuable resource for anyone writing Bayesian filters. The Spam Archive is building a digital library of Internet spam. Your use of the Archive is subject to the Archive's Terms of Use. All emails viewed are copyright of the respected companies or corporations. Thanks to Benedict Sykes for assisting with tech problems and Google Indexing, ta Ben.

Our inspiration is the "Internet Archive" USA. "Libraries exist to preserve society's cultural artefacts and to provide access to them. If libraries are to continue to foster education and scholarship in this era of digital technology, it's essential for them to extend those functions into the digital world." This is our library of unsolicited emails from around the world. See https://archive.org. Spamdex is in no way associated though. Supporters and members of http://spam.abuse.net Helping rid the internet of spam, one email at a time. Working with Inernet Aware to improve user knowlegde on keeping safe online. Many thanks to all our supporters including Vanilla Circus for providing SEO advice and other content syndication help | Link to us | Terms | Privacy | Cookies | Complaints | Copyright | Spam emails / ICO | Spam images | Sitemap | All hosting and cloud migration by Cloudworks.

Important: Users take note, this is Spamdex - The Spam Archive for the internet. Some of the pages indexed could contain offensive language or contain fraudulent offers. If an offer looks too good to be true it probably is! Please tread, carefully, all of the links should be fine. Clicking I agree means you agree to our terms and conditions. We cannot be held responsible etc etc.

The Spam Archive - Chronicling spam emails into readable web records

The Glass House | London | SW19 8AE |
Spamdex is a digital archive of unsolicited electronic mail 4.9 out of 5 based on reviews
Spamdex - The Spam Archive Located in London, SW19 8AE. Phone: 08000 0514541.