top of page
horizontal lines
Gigasheet Primary logo
  • Will Andrews

Email Enrichment: Quickly Clean & Verify Email Lists

Anyone in Sales or Marketing will tell you that the best part of a sales event is the event itself! Maybe you met some interesting prospects, or had a customer willing to commit to providing a reference for your company? Maybe the junior sales rep got over-served and is questionable to return to the office next week? An instant water-cooler topic for Monday!

Anyone in Sales or Marketing will also tell you that the worst part of any sales event is the follow up activities: the real work that justifies having the event. Yes, I am talking about the data entry and analysis of the lead list. If you are lucky, someone else has typed all of the business cards from the fishbowl into your CRM. If you are even luckier, there aren't typos, and you have some real winners in the mix. But how do you know?

There is only one way to find out. Someone needs to manually process each and every one, answering the following questions:

  1. Did we get valid email addresses?

  2. Are they real email addresses, or throw-away "burner" accounts?

  3. What company do they work for?

  4. Is the company big enough for us to care about?

If you have ever done this, you will know it's not something that you would miss doing after the next event. To quote Peter from the classic movie, Office Space:

"Well, I wouldn't say I have been missing it Bob!"

Office Space Peter isn't missing his job

At Gigasheet, our mission is to make working with data easy and accessible to everyone. Since email addresses are such a common data type, we thought a free Email Verification Enrichment would help take the pain out of Sales and Marketing activities. That way you won't ask to get hypnotized to forget work completely.

Gigasheet Enrichments read data from a column and append data from other sources alongside that column to help do your job. Previously, we offered Cyber Security related enrichments for tasks like geo-locating an IP address. This is our first of many new enrichments. Please let us know what you think about our free email verification tool!

Gigasheet Email Enrichments quickly clean and verify email lists

Introducing Gigasheet's Free Email Verification Enrichment

Keeping with the Office Space theme, let's answer the Bob's question: "What would you say you do here?"

Email Verification helps you quickly clean and verify email lists by delivering the following 4 Columns:

  1. Format - Is the email address formed correctly? Emails must have one "@", no spaces, and data before and after the "@" character. Valid email addresses will be labeled "Correct" and malformed email addresses will be marked "Incorrect".

  2. Domain - What is the domain of the email address? This splits off the part of the email address after the "@" and returns the domain of the email address.

  3. Alexa Rank - The Alexa rank is a global ranking system that ranks millions of websites in order of popularity (the latest ranking is here). The Email Enrichments looks for the domain in the Alexa Rank and returns the ranking. If the domain is not found, the value 9999999 is applied.

  4. Disposition - This returns 3 values based on the Domain:

  • Organization - The email address belongs to a company, school, or other type of organization that has a registered domain

  • Free - The email address is from popular free email tools such as Gmail, yahoo, iCloud etc., and is likely a personal email address

  • Disposable - The email address is from a known disposable email address provider. This likely is not the lead's primary email address

Each of these columns will be named with a dash appended to the original column name. Here is sample output using some sample data. The column named "Email" contained email addresses and the 4 columns to the right were added.

Gigasheet Email Enrichment outputs four columns

Email Enrichment in Action

Now that we covered the basics, let's put this to work on some sample data. Here is a list of our favorite Star Wars and Harry Potter leads in our instance of Salesforce. It looks there are 668 leads in our CRM that need to be worked.

Sample Salesforce lead data that will be loaded to Gigasheet

Loading the Data to Gigasheet

There are 2 ways to get this data into Gigasheet from Salesforce.

  1. Export the report from Salesforce as an Excel file or as a Comma Separated Values (csv) file. Load the data into Gigasheet.