Make a contact list of Free Email Domains?

SOLVE
Highlighted
New Member

I know Hubspot allows you to block free email domains on forms, but in an effort to clean junk contacts out of our database (we're at 51K contacts), I want to build a list of all free domain emails to remove them from our database.

 

I found a list of all the domains here:  https://knowledge.hubspot.com/articles/kcs_article/forms/what-domains-are-blocked-when-using-the-for...

 

When I create a list based on Contact>Email>Contains, and then paste all of the free domains in, Hubspot just sort of freezes on me, like it's too much information to process.

 

Is there a way to add Hubspot's existing list of free domains to build a contact list from as an easier way for Hubspot to process this filter?

1 Accepted solution

Accepted Solutions
Highlighted
Esteemed Contributor

Hi @UnicornMarketer : I completely agree with you that this should be a HubSpot built in list that auto updates. But till that happes, you can build your own active list to solve this issue.  

<I checked and It works for both free CRM and HubSpot marketing >

Go to list and select Active list. Use the condition: Email Domain Contains: < List of all the free domains> ( Thanks to @DrewLatimer  for helping with validating this list ) 

@Ramin You dont have to type in every single free email domain. It's impossible becasue there are 4746 domains on that list. Here is my solution for that. 
1. Copy the free domains from this list into an Excel file https://knowledge.hubspot.com/articles/kcs_article/forms/what-domains-are-blocked-when-using-the-for...
2. Use the formula  [ =A1&";" ]  in a diffrent column to add semicolon to the names of the free domains. 
3. Go through the list to delete any blank rows and clean your data ( it works, and doesnt freeze, but it may take a couple of minutes to process) 
4. Copy the column with semicolon and paste them into the list filter. 

Your list should work. 

If you want I can paste the values here too, let me know. 

Screen Shot 2019-08-29 at 12.33.06 PM.png

 

Hope this helps

Thank you.

-AM 

#Did my post help answer your query? Help the Community by marking it as a solution.




Hope this helps
Thank you.
-AM8 
#Did my post help answer your query? Help the Community by marking it as a solution.
14 Replies 14
Highlighted
Esteemed Advisor | Platinum Partner

Hi @UnicornMarketer,

 

Are you using HubSpot's Free CRM only, or do you also have Hubspot Marketing?




Did this post help solve your problem? If so, please mark it as a solution.

Josh Curcio

HubSpot support and inbound marketing for OEMs, contract manufacturers, and industrial suppliers.
HubSpot Platinum Partner & HubSpot Certified Trainer

Reply
0 Upvotes
Highlighted
New Contributor

Hi Josh,

 

Does it make any difference in this case?

Reply
0 Upvotes
Highlighted
New Member

Yes. I second this request.

There should be an out of the box list of contacts whose email domain is one of the ones listed on this page - https://knowledge.hubspot.com/articles/kcs_article/forms/what-domains-are-blocked-when-using-the-for...

It could be put to many uses. And HubSpot customers won't have to worry about maintaining or updating it. It will be automatically updated everytime HubSpot made a change.

 

An alternative would be to have a calculated out of the box contact property that is a "yes/no" field. If the contacts email domain is from the email domains to block list the value of that contact property is "yes" (may be the property is called - "Email domain is part of universal block list"

Highlighted
Regular Contributor

Has anyone found a fix for this? For some of our workflows, we would like to filter out free emails.

Highlighted
New Member

Hi! Did you ever get a response on this?

Please let me know!

Highlighted
Occasional Contributor

Hi, we're also looking for a response to this. 

 

We'd like to setup an enrollment trigger of filling out a specific form, then using an If/then branch to treat the list of free email providers differently for our MQL process. 

Highlighted
New Contributor

Hey, I came across this because I'm having a similar problem with a large database. Does anyone know the answer to this problem?

Highlighted
New Contributor

Yes, this needs to be an out-of-the-box list or setting we can use in making lists.

We need more upvotes to get this more attention!

Highlighted
Occasional Contributor

I would like to see this as an automated list managed by HubSpot. It would make our lead automation process so much easier

Highlighted
Occasional Contributor

Agree - would like to see a Workflow option to evaluate based on this, and for Lead Scoring so that those with a free domain can be given a negative value.

Highlighted
New Contributor

+1 on this.

A potentially easy workaround for this could be the contact property Email domain.

However, it's not actually practical because it's not possible to just paste a list of domains in there (doing so will result in Hubspot interpreting the entire list as one domain, which is ridiculous).

Instead, you need to add each domain and then hit enter before entering the next domain—super time-consuming and cumbersome UX :/

Highlighted
Esteemed Contributor

Hi @UnicornMarketer : I completely agree with you that this should be a HubSpot built in list that auto updates. But till that happes, you can build your own active list to solve this issue.  

<I checked and It works for both free CRM and HubSpot marketing >

Go to list and select Active list. Use the condition: Email Domain Contains: < List of all the free domains> ( Thanks to @DrewLatimer  for helping with validating this list ) 

@Ramin You dont have to type in every single free email domain. It's impossible becasue there are 4746 domains on that list. Here is my solution for that. 
1. Copy the free domains from this list into an Excel file https://knowledge.hubspot.com/articles/kcs_article/forms/what-domains-are-blocked-when-using-the-for...
2. Use the formula  [ =A1&";" ]  in a diffrent column to add semicolon to the names of the free domains. 
3. Go through the list to delete any blank rows and clean your data ( it works, and doesnt freeze, but it may take a couple of minutes to process) 
4. Copy the column with semicolon and paste them into the list filter. 

Your list should work. 

If you want I can paste the values here too, let me know. 

Screen Shot 2019-08-29 at 12.33.06 PM.png

 

Hope this helps

Thank you.

-AM 

#Did my post help answer your query? Help the Community by marking it as a solution.




Hope this helps
Thank you.
-AM8 
#Did my post help answer your query? Help the Community by marking it as a solution.
Highlighted
New Contributor

This would be great.  Also acceptable would be a workflow enrollment trigger of 'email domain = free' or a workflow logic condition of the same. 

 

Blocking free email domains is helpful for our sales team, but means the marketing team is constantly answering requests from people with free emails. I'd love to find a way to accept all emails, but route them differently based on free or not!

Reply
0 Upvotes
Highlighted
New Contributor

This is great advice, just done it myself and helps us loads to filter personal contact records. I would only suggest adding slight adjustment instead fo filtering by contains and all these listed options of domains to equals to, as some of our customer records were part of this "personal email list" while they were legit business account domains. Hope this helps!