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:
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!"
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!
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:
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.
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.
There are 2 ways to get this data into Gigasheet from Salesforce.
We will cover our Data Connectors in more depth in another blog, but think about how amazing it would be to just log into Gigasheet and have the latest report ready to be analyzed? This can be done today! You could even apply a Saved Filter to the data and have the report just the way you like it in seconds.
Regardless of how you get the Salesforce data into Gigasheet, let's walk through how to apply the enrichment and answer our 3 questions above.
Applying the Email Enrichment literally takes 3 clicks. Never has analysis of an email list been so easy!
Click on the "Email" column (click 1) and select Enrich (click 2)
The Data Enrichment menu will appear with the "Email" column already selected. Gigasheet identifies this as a column containing email addresses and will have pre-selected "Enrich Email". Click Enrich Data (click 3).
And just like that, magic happens, and the Email Enrichment produces four columns of data about your email address list. These will briefly be highlighted in blue, to indicate that these new columns are now added.
3 clicks! That's all it takes to enrich a list of email addresses using Gigasheet.
Now that we have loaded the data and applied the Email Enrichment, it's time to analyze our lead data and determine the quality of our leads. A process that was once manual and painful, is now automated and easy in Gigasheet. Our 4 questions are answered below:
To quickly answer this question, group data on the "Email - Format" column by clicking Group and selecting "Email - Format".
This will show us groups of "Correct" and "Incorrect" email addresses. It looks like out of our 668 leads, 648 have proper email addresses and 20 have malformed emails. What makes them bad? Let's click the down arrow on the "Incorrect" email addresses to view the list of bad emails.
As we can see, there are several reasons why an email is "Incorrect":
These are all email addresses that we are going to want to exclude from our marketing efforts.
In order to answer this, let's go ahead and add two columns to our groups. To do this, click on Group and in the pop-up window, add "Email - Disposition" and "Email - Domain" beneath the existing "Email - Format" grouping.
The Disposition will tell us if the email address is issued from an Organization, a Free email provider such as Gmail, or from a known provider of disposable email addresses. The second grouping by Domain, will just roll these up so we can see how many we have from each domain.
The results show that of our 648 correct email addresses, 330 are from organizations, 292 are from free email providers, and 26 are likely disposable emails.
Click the arrows to expand each group and view the domains, to see examples of each sending type. For example, we can see that in the Free group, Gmail is by far the most popular domain. And in the Disposable group, there are only single addresses from each domain.
Based on this quick analysis, we can definitely eliminate the 26 disposable email addresses from our marketing efforts, and likely the 292 free email accounts as well. Our organization wants to focus our time and energy on the organization accounts.
By expanding the organization accounts group, we can see a list of the domains of all the organizations in our lead list. It looks like we have some big companies to target! Let's add some aggregations to our data to see what we have.
Now we can see the count and Alexa rank of every organization in our list.
The Alexa rank is a global ranking system that ranks millions of websites in order of popularity. Let's say we work for a company that only wants to target enterprise deals. We can then filter our lead list using the Alexa rank as a proxy for company size. We are going to only focus on the top 100 Alexa ranking sites. To do so, add a filter by clicking Filter, selecting "Email - Alexa Rank" and adding the condition for less than 100.
And voila! Now we have our focused target list of leads to follow up on. It looks like there are 8 organizations in our list that have a top 100 Alexa ranking. Watch out Admiral Rancit, you will be hearing from us very soon.
To wrap it up, we started with a list of 668 leads from our Salesforce CRM. We quickly eliminated the riff raff and created a targeted list for our sales and marketing teams. The Gigasheet Email Enrichment tool works in 3 clicks, and we found easy insights from simply grouping and filtering the data. And we haven't even mentioned the best part!
That is, of course, assuming you haven't already quit your desk job!