Dec 23, 2021 5:50 AM
I am Ravi from Brussels, nice to meet you all. I am presently working as a Technical operations analyst in one of the start ups. I have an issue with the duplications in Hubspot.
Whenever any company joins in my platform, somehow a huge amount of duplications are crating for some companies. I have no idea how to handle this, I am actually merging the companies manually but it is a temporary solution , I just want to find out the root cause and then fix it. Does anyone have any idea on how to solve this, it would be really helpful for me. Please do let me know, thanks for the community.
Jan 5, 2022 11:01 AM
Hi @RSiddula - it looks like @kvonloesecke has given you some really useful suggestions but if you're still having problems, do let me know and I'll see what else can be done. Want to make sure you're looked after as you're part of the Sales Enablement group 🧡
Jan 5, 2022 11:06 AM
Thanks for the reply @JonPayne I just want to check with you about the deduplication tool which I can use at HubSpot to handle the duplicate data. Do you have any recommendations other the below deduplication tools,
Please let me know if you have any recommendations @JonPayne , that really saves a lot of time. Thank you
Jan 5, 2022 11:26 AM
Can I clarify a few things @RSiddula?
1. How did the duplicate companies occur? E.g. Imported file, or via an API.
2. Approximately how many companies are in HubSpot?
3. How many duplicates?
Thanks - that will help me get my head around the problem. 🙂
Jan 5, 2022 11:44 AM
Please find the details below,
1. Via an API ( Our Dev team is working on this)
2. Around 0.6 Million plus records (companies alone)
3. There are 0.1 Million duplicate records available at HubSpot
Jan 5, 2022 12:21 PM
OK, so pretty big numbers and going up, I presume, if the API connection is pumping more in every day?
Let me have a think and get back to you tomorrow, if that's OK?
Dec 28, 2021 7:43 AM
Thanks for reaching out, and welcome to HubSpot Community!
When a new company is added, HubSpot looks at the Company domain name property value to deduplicate companies as outlined by this article: Deduplicate companies by company domain.
It sounds like there may be companies without a company domain name, which in turn leads to duplicate companies. I would recommend running an audit on your team's company imports to make sure the company domain name is included for each company. If your team is updating company records, you'll want to make sure they are adding the object ID for each company record.
|Did you know that the Community is available in other languages?|
Join regional conversations by changing your language settings !