On average about 10% of email addresses go stale every year, people change jobs change from Gmail to Yahoo, Etc.
How do I get Excel Define did email addresses to minimize the bounce rate?
Thanks.
On average about 10% of email addresses go stale every year, people change jobs change from Gmail to Yahoo, Etc.
How do I get Excel Define did email addresses to minimize the bounce rate?
Thanks.
I've used zerobounce.net to help clean an old list. It's not perfect and it's not free, but it did a pretty good job for me. Along with that, you should send your emails through a system that manages bounces and other issues so that they will automatically be removed from your list. If you want, I can tell you what I did for teachexcel this year to transition to a more automated email setup that manages all of this for a very reasonable cost, unlike mailchimp.
Clean my List
First thing is to make sure your current list is clean and good.
I used zerobounce.net and I chose them after, at the time, looking through lots of different providers of this service. I did a lot of research and tried to figure out what would work well and zerobounce.net seemed like a good option to me, so, I chose them.
At this point though, honestly, I think that most providers of this type of service will offer a similar level of service since the mechanisms that they use to verify the emails are not particularly sophisticated; the checks are pretty standard but most sites just use snazzy language to trump themselves up and make themselves look better than the other guys.
I used zerobounce and they worked ok and I don't have any complaints.
In reality, this should be a 1-time thing that you do. So, chose a provider and get it over with and move on to the next step.
Email Sending Management
This is rather ridiculous at the moment, as companies out there, looking at you MailChimp!!!!!!, charge an insane amount of money if you have a large list. I just checked MailChimp and, though their prices seem like they have come down, they are still very expensive AND the price doesn't scale in a linear fashion!!!! This means that when you hit certain thresholds, you will have a rather large increase in price.
MailChimp: 60,000 subscribers, unlimited emails - $4,200 PER YEAR!!!
Ok, that's a bit of a rant, but I got really annoyed with all these email providers when I was searching for a cost-effective solution.
Solution: Amazon SES + Sendy
Amazon SES - .10 cents per 1,000 emails - 60,000 email sends = $6
Sendy - $60 USD one time fee.
This is the setup that I now use.
Sendy is something that you setup on your server, VERY easy to do - don't listen to websites that tell you that it's difficult to setup and then want you to user their service!
Amazon SES is what actually sends the emails.
Sendy lets you compose the emails, manage the subscriber lists, do things like that, and then, when you send the emails, Sendy sends them to Amazon SES, which then sends them.
The best part is that Amazon SES sends data back that says if the email bounced or was bad or was reported as spam by the user. Sendy takes this data and updates your email list by removing the bad emails automatically.
The one thing is that Sendy might not have some of the subscriber list management features that you would like. They have some pretty good stuff, but it is not yet as automated as I would like. What this means, to me, is that I have to send multiple campaigns each week to multiple sets of subscribers in order to send them the email in their timezone, versus sending one campaign and having it automatically send the email when it's best for the user. This is, really, my only complaint.
MailChimp: 60,000 subscribers - unlimited emails - $4,200 yearly.
Sendy + Amazon SES: 60,000 subscribers - 52 weekly emails (1 year) - $312 (+$60 1-time fee to buy Sendy)
Let me know if you have more questions or thoughts :)
Excel manages and evaluates data. It doesn't create them. So, imagine that once a year you send out a mail to the tune of "if you wish to continue receiving my emails please reply to this mail with 'Yes'". You might send this mail from a dedicated address so that replies result in a list of all the people who have responded.
This is where Excel can come in. Now, if you pass this list to Excel you would be able to reconcile it with the original mailing list and identify those who didn't respond. There are other ways of creating the list I described. Unfortunately, Excel can help only in processing it but can't be of assistance in its creation.