Bulk Email Processing
My first experience with bulk email was back in 2003
, a colleague of mine who had his own business and
band (he always collected emails from the crowd) and ask me to setup a system to send mass emails ads
To his fans and to his existing business clients.
I purchased a package after using the demo for a couple of weeks, it seem to work well, although it only sent out
about a thousand an hour, which is ok, since he had only about 10,000. The software took
CSV files as input which was good; its interface allowed html entered to create messages just like front page by
MicroSoft, although you had to send a test message to quality control the message before
making a run.
There several processes and step we had to figure out before we could do a real production run.
1. Test the messages for typos, test the music streaming if we wanted to play background music
when the email was delivered, test image quality, test stream quality if we wanted
to test sending a video with the message.
2. Test all the above with the major ISP players (Yahoo, MSN, Google, AOL, Hotmail,
etc etc), this proved interesting because some of the ISP's added or deleted portions of the
HTML code and used their own backgrounds and colors.
3. Test the messages with different browsers
4. And because the laws were changing concerning spam, we had to embed a opt out link
into the messages, and then of course create websites that the opt out links were
directed to, these WebPages contained code that executed programs that collected the email addresses
and stored them into text files, these were then loaded into a table for future
email suppression.
5. We had to create databases to store prospect emails, emails that were sent, emails that
were responded to, emails that were asking to be removed from future emails campaigns,
we had to create programming that cleaned up emails and looked for undeliverable email
addresses, unwanted emails, created programs that converted, extracted and loaded emails from
process to process, web sites to servers etc etc.
6. We experimented with email verification programs, email spider programs for extracting emails
off the internet, marketing ideas for collecting emails, email brokers, wrote programs to collect
return codes for rejected emails, successful emails, problem emails and reports to
help control all this.
We finally got into production with some success, but it took a lot of work.
Years later I joined a company in California called AcquireWeb, which blasted
Hundreds to millions of emails daily and worked with the three big credit bureaus
I learned the business of big blast email processing and the business from cradle to grave.
I was hired as a Data Analyst Consultant from 2008 - 2009 to prepare the data and emails
before the blasting, I worked with millions of records, doing extractions, merges, Joins,
some pretty wild select statement, most of this was done with Microsofts
MS SQL 2005 server, I did some Visual Basic programming, a lot of SQL queries, a lot
of SSIS work bring data up and down from the servers, all ways trying to automate the processes.
wrote a MicroSoft service to poll the ftp directory and start processing data when our clients would drop a data file
into a FTP directory and email them automatically when this process shot off.
I also did a lot of scripting on our Linux servers to collect return code data
during the night and at noon, this allowed us to create reports and send them to our clients
to let them know the progress of their campaigns and let them make crucial decisions
affecting future runs.
By Michael Robert Cummings
www.vitalcomputerservices.into
michaelrobertcummings@gmail.com
Consulting
by: Michael Robert Cummings
Are Your Emails Impressive Enough For Your Prospects The Yahoo Hotmail Connection - Configure Hotmail For Yahoo Mail Access Proper Email Server Configuration - Separate Your Email Traffic From Your Browser Traffic Proper Email Server Configuration - Properly Configure Your Public DNS How To Make Use Of An Email Addresses Directory Create Your Own Mail Greeting Cards Reverse Lookup E-mail - Tracing An E-mail Address The Mailroom: Land of Wonder You Can Get Paid To Read Emails How to build a Mammoth Mailing List in Record Time 20 Ways To Build Your Email List By Melissa Ann Mitchell How To Fix The Ipad Email Problems Email Address Look Up - Find People