We have been using the free version of hhubSpot for aroun 18 months and now upgraded to sales, marketing and serivce pro.
We have just over 8,000 contacts on our database however I believe a lot of these contacts have incorrect email addresses. I have a tool called Zero Bounce which I can run all the email addresses through and validate.
My question is - is there a way to import that cleansed data back into our HubSpot and during that import "ask" HubSpot to remove the invalid email addresses? or is this a manual process of comparing the csv of cleansed data and deleting each contact on HubSpot?
I have created a list of email hard bounce which has given me just over 800 contacts but as mentioned I don't want to send out mass emails to discover who actually bounces.
No problem at all. It's perfectly fine to not know these things and if I can help you get this right and make your HubSpot learning journey easier, that also makes me happy.
From what I understand, here's what you would do:
Export all contacts from HubSpot.
Import all contacts into ZeroBounce for validation.
Export all contacts from ZeroBounce.
Remove invalid contacts from Zerobounce export file
Remove all columns from file but the Email column
Import this file (valid contacts) into HubSpot
During import, create a list of imported contacts
Create a HubSpot new contact list that contains all contacts which are not in the list from step 7 (invalid contacts)
Delete contacts on the list from step 8
In the list of step 8, consider excluding contacts with Lifecycle stage Customer. You might want to consider other stakeholders as well. Personally, I would want to keep customer records, even if the email address bounces.
Let me know if I should detail any of the steps further!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
I would approach this slightly differently. ZeroBounce should give you a list that specifies whether an email is valid or invalid. The invalid ones I would immediately remove from the ZeroBounce file. You can then import this list into HubSpot. This enables you to find all of the contacts which were not validated easily – and also apply additional filter logic.
To be more specific, you could then create a deletion list in HubSpot. This would be an active contact-based list that filters for all contacts that are not in the list you just imported. Once this list is done populating, you can select all contacts and bulk delete them.
More importantly, you could exclude contacts group from the upcoming deletion, e.g. contacts with Lifecycle stage 'Customer', business partners, internal contacts etc. That's what I was referring to above: applying additional logic to your deletion list.
So in other words, no, it's not possible to do this during the import process – but you can easily achieve what you're looking for with active contact lists.
Lastly:
HubSpot automatically excludes contacts from marketing emails automatically if they have bounced before.
Could you just clarify how I see / distinguish between the valid and invalid emails when I import back into HubSpot? If remove all the records marked as invalid from Zerobounce and then import the good contacts back in I don't understand how I then remove the invalid contacts already in HubSpot that are showing as invalid from Zero bounce.
To be clear I am exporting all of our current contacts in HubSpot, running through Zerobounce to then re import those same contacts and delete the invalid returns from HubSpot easily.
No problem at all. It's perfectly fine to not know these things and if I can help you get this right and make your HubSpot learning journey easier, that also makes me happy.
From what I understand, here's what you would do:
Export all contacts from HubSpot.
Import all contacts into ZeroBounce for validation.
Export all contacts from ZeroBounce.
Remove invalid contacts from Zerobounce export file
Remove all columns from file but the Email column
Import this file (valid contacts) into HubSpot
During import, create a list of imported contacts
Create a HubSpot new contact list that contains all contacts which are not in the list from step 7 (invalid contacts)
Delete contacts on the list from step 8
In the list of step 8, consider excluding contacts with Lifecycle stage Customer. You might want to consider other stakeholders as well. Personally, I would want to keep customer records, even if the email address bounces.
Let me know if I should detail any of the steps further!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer