I have a .csv file that contains 289 companies. When I import, the total is only 155. There are no errors.
My .csv file has 10 columns, all of which appear to mapping okay, hence no errors. There are some companies with similar names, such as (and I am sort of making these up) Greenacres and Greenacres House, could this be the issue?
Looking at the companies who weren't imported, there is no real reason as to why they should have failed. And as I mentioned, there are no errors so I have nothing to go on. Can anyone throw any light on this at all?
Since you mentioned companies with similar names, was "company domain name" one of the columns you had in your import? If so, HubSpot does use that property to deduplicate companies in an import. Here's a snippet from one of their help articles:
"When a new company is added through import, HubSpot looks at the Company domain name property value to deduplicate companies. If a company with the same company domain name already exists in your account, the new company information will be added to the existing company record.
If you do not include this property in your import, each row of your import file will be imported as a new company record."
Since you mentioned companies with similar names, was "company domain name" one of the columns you had in your import? If so, HubSpot does use that property to deduplicate companies in an import. Here's a snippet from one of their help articles:
"When a new company is added through import, HubSpot looks at the Company domain name property value to deduplicate companies. If a company with the same company domain name already exists in your account, the new company information will be added to the existing company record.
If you do not include this property in your import, each row of your import file will be imported as a new company record."
Thanks for your response. There is a high chance that the domains will be duplicated as the sector we work in is the care industry, and therefore the individual nursing and care homes will be grouped under the same domain name. So I will remove this column and see if this makes the difference.
However, the few import ommisions I manually checked seemed to be independant homes, and therefore unlikely to share the domain with another homes I was trying to import.
I'll have a read of the link you sent me and I will shout out again if stuck.