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.
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?
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.
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.
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.
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.
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.
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.
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!
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!
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 😕
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.
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.
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"