When we integrated our legacy CRM with HubSpot, we inherited about 12k company records that do not have a website URL attached to it. Because of this, we run into issues where: 1) Duplicate companies are made because HubSpot does not identify the domain when creating a company record, 2) We integrate with ZoomInfo and it can’t recognize a large number of our company records since there is no Website URL.
Any have experience with this issue? I am looking for an efficient way to capture the website url for this bulk list. This may not be a HubSpot specific question/issue but figured others may have been in a similar situation.
had the same problem after a migration. what worked for us was exporting the company list to a spreadsheet, then using a clearbit or similar enrichment tool to bulk match company names to domains. you can also try google sheets with a simple formula that searches “[company name] site:” and grabs the first result, but that only gets you maybe 60-70% accuracy.
once you have the domains, reimport them into hubspot mapping to the company domain name field. that should fix both the dedup issue and the zoominfo matching. for the ones that still don’t match, we just had reps manually verify during their next touchpoint with each account.
Hey @MDiaz705 ,
Do you have contacts associated with these companies? And if yes, do they have non-free email addresses (e.g., not @gmail.com and such)? If the answer is yes, you can export your companies including those contacts, work on a formula in Excel or Google Sheets to copy the domain from the email address into a new column and then import the companies back, mapping the new column to company domain property.
Hey @MDiaz705
Both suggestions above are good starting points. Eugene’s email domain extraction trick is probably your quickest win for the records that have associated contacts with company emails. For the rest, I’d layer a few approaches.
If you have a ZoomInfo license already, they actually offer a bulk enrichment feature where you can upload a CSV of company names (plus any other identifiers like phone, address, city) and get domains back. The match rate is way better when you include additional fields beyond just the company name, because “ABC Solutions” could be 50 different companies but “ABC Solutions, Austin TX” narrows it down fast. Worth checking if your ZoomInfo plan includes that before paying for another enrichment tool.
For the duplicates piece, once you get the domains populated, HubSpot’s built in deduplication tool can help merge records that now match on domain. But I’d do the domain enrichment import first and then run dedup, not the other way around. If you dedup before adding domains you might merge the wrong records together since theres no reliable matching key yet (Deduplicate records in HubSpot )
On the migration side, this is pretty common when moving from legacy CRMs that didnt enforce website fields. At Stacksync we see this a lot when teams sync their old CRM into HubSpot, missing fields and duplicates are almost always the first thing to deal with post migration. One thing that helps going forward is setting up validation rules so new records cant be created without a domain, which prevents the problem from growing while you clean up the backlog. Transparency note This response is grounded in my own experience and was lightly polished using AI.
Hope that helps with the cleanup!
