Lists, Lead Scoring & Workflows

UnicornMarketer
Member

Make a contact list of Free Email Domains?

SOLVE

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
AM8
Solution
Top Contributor

Make a contact list of Free Email Domains?

SOLVE

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 @HelenaLatimer  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.

View solution in original post

19 Replies 19
AM8
Solution
Top Contributor

Make a contact list of Free Email Domains?

SOLVE

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 @HelenaLatimer  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.
JSmasal
Participant

Make a contact list of Free Email Domains?

SOLVE

Amazing tip. I have typed / copy pasted so many lists one-by-one. This one is way too big to do that.

0 Upvotes
ShiranA
Contributor | Diamond Partner
Contributor | Diamond Partner

Make a contact list of Free Email Domains?

SOLVE

OMG. This is priceless!
Someone give that man (or woman) a cookie!

0 Upvotes
Jonno_Price
Guide | Platinum Partner
Guide | Platinum Partner

Make a contact list of Free Email Domains?

SOLVE

Thanks AM8 - this worked perfectly and took me 2 mins to create an active list of every contact with a free email domain. It is then easy to use this as exclusion list for lead routing etc. Nice one. 


Jonno Price
Growth London Ltd.
Platinum Hubspot Solutions Partner

Did my post help answer your query? Please help the community by marking it as a solution.

SmileUser
Participant

Make a contact list of Free Email Domains?

SOLVE

Fortunately, HubSpot has now made it easier to download the list via .csv from the page you linked to - https://knowledge.hubspot.com/forms/what-domains-are-blocked-when-using-the-forms-email-domains-to-b...

 

But a built-in filter option would be nice.

 

PamCotton
Community Manager
Community Manager

Make a contact list of Free Email Domains?

SOLVE

Hello @SmileUser 

 

Thank you for sharing this Knowledgebase with our Community users.

 

For the filter, I would highly recommend you to please post this idea at our ideas forum (here).

Our product team, who monitors the forum regularly, can read your specific use case and understand why this would be a useful functionality or change. It also helps other customers facing the same issue to advocate for its implementation on your behalf by upvoting on the thread as well.

 

Kindly,

Pam

Você sabia que a Comunidade está disponível em outros idiomas?
Participe de conversas regionais, alterando suas configurações de idioma !


Did you know that the Community is available in other languages?
Join regional conversations by changing your language settings !




AgneB
Participant

Make a contact list of Free Email Domains?

SOLVE

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!

JeremyP
Participant

Make a contact list of Free Email Domains?

SOLVE

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!

Ramin
Participant

Make a contact list of Free Email Domains?

SOLVE

+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 😕

ColinC
Participant

Make a contact list of Free Email Domains?

SOLVE

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.

AirswiftRob
Contributor

Make a contact list of Free Email Domains?

SOLVE

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

Stacey08
Participant

Make a contact list of Free Email Domains?

SOLVE

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!

Lorna
Member

Make a contact list of Free Email Domains?

SOLVE

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

anthonyrichards
Participant

Make a contact list of Free Email Domains?

SOLVE

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. 

juanismoreno
Member

Make a contact list of Free Email Domains?

SOLVE

Hi! Did you ever get a response on this?

Please let me know!

aalvarado
Contributor

Make a contact list of Free Email Domains?

SOLVE

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

rohanpai
Member

Make a contact list of Free Email Domains?

SOLVE

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"

Josh
Recognized Expert | Platinum Partner
Recognized Expert | Platinum Partner

Make a contact list of Free Email Domains?

SOLVE

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

0 Upvotes
rui_uk
Participant

Make a contact list of Free Email Domains?

SOLVE

Hi Josh,

 

Does it make any difference in this case?

0 Upvotes