I Deleted 260 of My Email Subscribers

I deleted 260 of my email subscribers

Earlier this month I talked about some of the lessons I’ve learned as a three year blogger and one of those points talked about why my email open rate (to subscribers) was only about 30%. I went through a phase where I bribed people to sign up for my list with giveaways. You know, they sign up for my email list in exchange for a giveaway entry.

So, naturally, each time I hosted a giveaway tons of people signed up with dummy email accounts (accounts they never actually check). So they never read my blog post emails and it skews my stats.

Brittany made a great comment in response to this. She said:

Re: your email subscribers…do you ever scrub your list? A few times a year, I clear out subscribers that haven’t opened any emails in the past 90 days. It helps with deliverability and open rate A LOT and has kept me out of the paid tiers for services priced on the number of subscribers.

What a great idea! …And yet, also kind of terrifying.

First I had to code something to find my “inactive” subscribers.

I use my own, custom code email subscription plugin. Since it’s my plugin, I don’t have fancy built-in features already. Everything I want to do, I have to code myself. But that’s also the beauty of it. It means that I’m only limited by my own abilities.

My subscribers are stored and managed in WordPress (via my plugin). My plugin also figures out when an email needs to be sent, who it should be sent to, and what the contents of the email are. But the actual email itself is delivered by Mandrill. Mandrill is also kind enough to add tracking to the emails, to figure out which people open and click inside each email. Plus, you can export this sending data from Mandrill into a CSV file.

So, I exported those tracking statistics from the last 30 days from Mandrill. This gave me a CSV file containing data from all outgoing emails in the last 30 days. Each row had: the email address an email went to, how many times that person opened that specific email, and how many times that person clicked in that specific email. Then, rinse and repeat for each subscriber and each email they received in the last 30 days. The file was 2.63 MB and about 20,000 rows.

This is where the coding came into play.

I had to decipher a CSV file with 20,000 rows!

I had to code a way to decipher this CSV data. Because there’s no way in hell I’m going through it manually and tallying up the open counts for each email address. I coded a script that:

  • Allowed me to upload the CSV file.
  • Went through each row of the file and added the email to an array, along with the number of times they opened that email.
  • If an email already existed in the array, it added the open count to the count that was already stored.

So, in the end, I had an array of email addresses, along with the number of times each person opened my emails in the last 30 days. It was kind of cool because I took this opportunity to figure out who had opened my emails the most. My dad was in the top 5 (hi dad!).

The next step was to modify that array so that it ONLY contained people who had opened zero emails. So I stripped out all emails unless they had the number “0” associated with them (for 0 opens).

And once I had my final array of people who had opened 0 emails, I outputted the list so I could manually review it. I wanted to see who I was removing!

Finally, I wrote another script that went through each email address in my final array and unsubscribed them from my system.

I lost 260 people

Seeing your number of subscribers go down SUCKS. You suddenly feel like you’re less successful. But you know what? It’s just a number. And I love numbers, but you know what I love more? Real numbers.

Is someone REALLY a subscriber if they’re on your list but never open your emails?

Hell fucking no!

I got rid of the people who weren’t reading anything anyway. And if they’re not reading my emails, why should I keep sending them?

My open rate went from 32% to 62%

Those are my before and after stats. All I can say is that it’s nice sending emails to people who actually read them. It was a scary move to delete 260 people from my list, but I now have a higher quality list with a more accurate subscriber number.

Have you ever pruned your email subscribers?

Photo of Ashley
I'm a 28 year old California girl living in England (I fell in love with a Brit!). My three great passions are: books, coding, and fitness. more »

Don't miss my next post!

Sign up to get my blog posts sent directly to your inbox (plus exclusive store discounts!).

You might like these

39 comments

    1. Yeah numbers are nice, but there’s not much sense in clinging onto them if they’re not real and just some arbitrary, inaccurate number!

  1. I read just about every email of yours. Some I click and come to your site and some I just read from the email itself. I find everything very interesting and informative. Plus I think you have a great sense of humour. I really do not want to miss anything that could potentially help me with my blog.

    1. Thank you so much Carrie! That means a lot to me. πŸ™‚ I’m so glad you’re enjoying my posts. It’s amazing to see people say that!

  2. Well!
    This made me think, and be a bit worried too, not in any concern for my own blog, it’s fairly new and I haven’t really done anything about followers.
    So, if you could just clarify for me please. You can tell if I simply read your newsletter straight from email? I read all the ones I’m subscribed to, just like this one, but often I don’t proceed to the blog itself. I’d hate to be deleted!
    Can all bloggers tell if emails are opened or is it just your awesomeness with codes and stuff? Anyway, glad you do what you do, it’s nothing I could ever aspire to, I just keep blogging my audiobooks, it’s may way of giving authors a bit of thanks and a bit of promotion. I’m sure you are a great inspiration to loggers a bit more go ahead than me,
    So thanks for your work
    Bec

    Bec recently posted: The Broken Token
    1. Yes, I can tell if you’ve opened my email, even if you don’t click through to the post. With email marketing you can track two different figures:

      1. The amount of times someone has OPENED the email.
      2. The amount of times someone has CLICKED on a link in the email.

      I only deleted people who haven’t OPENED any of my emails in the last 30 days.

      Not all email platforms track that information. For example: Feedburner doesn’t. But if you use a more “advanced” service like MailChimp then they will include those tracking codes for you and you can see the results.

    1. That’s great Bieke! Based on that info, I don’t think you’ll have many bogus subscribers. πŸ™‚ I was a bad, bad girl in my early days. Live and learn.

    1. That’s an excellent policy, and definitely something necessary with a list that size. I imagine you end up pruning TONS of people every time!

    1. Am I correct in thinking you use MailChimp? I know it’s definitely possible to do this in MailChimp. I’m not sure how, but I think they have a knowledgebase you could look through?

  3. I only have 19 e-mail subscribers, so no, I haven’t pruned any. *grins* But I’ve also only been blogging for 7 months. I can’t imagine having to go through and not only find all those ghost subscribers, but deleting them. Lots of work even with the coding, and seeing the number of followers drop would have freaked me out too.

  4. I don’t have that many email subscribers yet and since I’m still using Jetpack subscription, I don’t necessarily have to remove subscribers for now. I’d really like to keep my numbers real too though so I’ll keep this in mind for when a good clean-out is much needed! Thanks for sharing, Ashley!

    Hazel @ Stay Bookish recently posted: Things We Know by Heart by Jessi Kirby
    1. Yeah I do pay money for each email I send, but the cost is so negligible. I get 12,000 free emails each month, then after that I pay $0.20 for each THOUSAND emails (so $0.0002 per email).

      So I personally didn’t do this for cost reasons, but I totally understand why people on MailChimp WOULD do it for cost reasons. Bogus subscribers could easily bump them up to the next pricing bracket and that’s a huge difference.

  5. Yup, that’s one of the things I love the most since I changed the way I deliver e-mails to subscribers. It’s very easy for me to see who has opened their e-mail, and who hasn’t and it’s really nice to be able to not continue sending them out to people who never open.
    I think some of those are actually spam accounts, also – they don’t need to open an e-mail to know that there is new content on my site, and so, they can easily stop by my site to leave long, spammy, stupid comments that akismet catches for me in 99% of the cases πŸ˜‰

    Lexxie @ (un)Conventional Bookviews recently posted: Review: Unwritten – Chelsea Cameron
    1. I actually don’t get many (if any) actual spam accounts since I have my own plugin. Spammers learn how popular signup forms work (like MailChimp) and that’s how they’re able to automate the signup process. But it’s harder for a plugin they have no knowledge of. πŸ™‚

        1. Not yet. πŸ™‚ I am planning on re-coding it in the coming months and then putting it for sale.

  6. Ah, the beauty of real numbers, as always. ^^ I think it was a good thing you cleaned house. I don’t have many subscribers, so I don’t need to that just yet, but it’s definitively something to keep in mind. Thanks for the post, Ashley!

    But that brings to me a question I still haven’t figured out quite yet: mail subscribers vs RSS. I’ve recently come to load RSS feeds into Thunderbird, where I also manage my e-mails, so now I get some feeds (like yours) twice. It bugs me a little, coz it’s messy. But since I’m a subscriber, I’d like to get both entries in a giveaway. How can you even tell if someone subscribed via RSS (if you don’t use feedburner — I only use the WP integrated option)? Coz I never actually clicked “subscribe” with any of the ones I read, I just added the feed link to my inbox. Do I still count into those statistics, since I often open posts from there? If yes, with what kind of ID? IP address? email address?

    Caro @ The Book Rogue recently posted: [Release Day Review] Jennifer Foor: Binge
  7. Wow, what a scary thought! I’m shivering just thinking of losing that many subscribers, but it really makes sense. They weren’t really true subscribers, so did you really lose anything? Not really. Brave move, and I applaud you for it. I’ve wondered about my unopened rate; maybe I need to try a purge and cleanse.

  8. I did! We recently switched providers and instead of moving the subscribers ourselves, we asked whomever wanted to keep receiving our emails to re-subscribe. Some did, others didn’t, and we ended up losing 50 of our subscribers. But that’s ok, they obviously didn’t want to keep receiving our updates. πŸ™‚

    Karolina @ Bookshelf Reflections recently posted: We’re Taking A Break
    1. That’s a great idea Karolina! A lot of people get really scared about moving to new providers and want to ensure that EVERY SINGLE subscriber makes it over. And I get that, but I LOVE what you did! You weeded out all the people who probably didn’t open your emails anyway. No sense in keeping those folks around. πŸ™‚

Recent Posts

    Random Posts