Email list cleaning format and sizes



Email list cleaning needs to be robust and move mountains. When an email marketer cleans their list, they send to it immediately, so the timing is essential plus the size of the file needs to be just right for the correct conditions. Many email marketing systems use different formats so every email marketer should own parsers and appending software to manipulate their databases so there are not errors when it comes to sending mail.

Delimiters

Email cleaning companies and service providers use several different delimiters for their system. The average is comma with semicolon in second place. Some use pipe delimiters and colon but comma is what most email list validation service uses. Separating your data is so important. Many use a semi colon because some data uses comma only to separate data inside one cell. In example, some data has/have sentences with periods. In this case, using a comma to separate is a bad idea, therefore semi-colon is the right choice.

Multiple Columns

It’s rare to find email verification free, let alone a company that will not support multiple columns. Most data comes with name, email, phone and hundreds of other combinations. These are called “headers” and with that comes multiple columns. If an Email list cleaning company does not support multiple columns, then that is a red flag. Professional systems should support at least a million records and with multiple columns.

Size

There should be no reason to scrub any more than 1 million records at a time. We have clients upload hundreds of files into our FTP utilizing our batch API and can get the files out quickly. A typical file with 1 million records and multiple columns can be up to 250 mb. Anything over that is not necessary since most lists are not as big as that anymore. There was a time, ten years ago, where these lists were needed cleaned, but hygiene and email marketing has changed since then. Most lists are now smaller and targeted versus the shotgun approach.

Excel

Excel can open up to 1.2 million records. Anything over that, it will show an error. Use excel as a rule of thumb on sizes of files you need scrubbed. If your database is larger and you need to open it up to cut it down, TextPad for windows works well and BBEdit if you use MAC. Both applications can open up at least 1 gb files.

This is the syndicated copy of an original article posted at https://verify550.com/email-list-cleaning-format-sizes/

Comments

Post a Comment

Popular posts from this blog

Email Validation Services - A Thorough Walk Through

Image
Email validation services, unlike email verification, focuses on the threats outside of the email itself. Email validation removes spamtraps, complainers, litigators, botclickers, roles/departmental and seeds while fixing the email removing syntax errors, unicode/latin characters and lastly checks the mx and domain for setup issues. Email validation is the first step in max scrubbing before you use an email verification software to remove bounces. Here are a list of all the modules inside our validation process: Traps   Spamtraps are email addresses that are purposely and strategically placed inside email marketing lists. They are can be caught by harvesting websites, expired domains and in some cases used to fill out forms. Traps can harm email deliverability by being triggered. Litigators   There are several lawyers nationwide and worldwide that sue email marketers. Sleeper cells   Many spam fighters are hosting providers. A sleeper cell email is one...
Read more

Knock Knock, Email List Validation Service Humor

Image
Email list validation has a humorous side. I have been scrubbing email lists for over 10 years and I think it’s time to share with you the hilarious stories while doing email hygiene services. 10 years is a long time to be doing what you love and it seems fitting to finally disclose the funny moments of email list validation service . The Senator Can Spam has no say when it comes to the political field. In comes a very well-known Senator a few years back. I received a call from his campaign manager. It was short and sweet. 1.) I need all the data you have in <state redacted> and 2.) I need all of it cleaned. We don’t supply data but we were able to find it for him. We also do not mail but we consulted with them on where to go. At the end of the day, we tens of thousands of dollars from this campaign and received a phone call from the Senator himself, “Great job guys. You F***ing blew my mind at how fast you put this all together!” I still have th e recording. ...
Read more

Email verification software schematics

Image
Many have asked me what are my Email verification software schematics for list hygiene. It really isn’t a secret. There are 5 fundamental parts of the email address. The user, the name, the domain, the string and the ending. This blog post explains each one of these and why it’s important to build your hygiene schematics around them. The user is the element before the at sign. The user encompasses many different parts. There are dots/periods, underscores and hyphens that separate the user information. Too many of these characters tell us the email is bad. The user information helps remove bad emails before we have to do a SMTP/MX check. The name tells is a lot about the email. Usually names are associated with B2B data in any email verify tool . In many cases, B2B emails do not last that long. This tells us what to do with the email. For example, let’s say we recorded the email as james.carner@. This tells us the person is professional and is interested in their name. We...
Read more