Company properties: uniqueness, duplicate company records, property details during imports
A couple questions about properties:
Are the details relative to how properties are handled during imports documented? For example, I recently did an import into an existing portal, and was under the impression there was a sort of merging of properties - i.e. the original portal's properties were retained, and the import data's properties added. Is that the case? Is there any attempt to resolve duplicates? If so, what determines property uniqueness? Display name or the programmatic name?
There doesn't seem to be a notion of value uniqueness for properties, e.g. when I create a property, nothing asks if I want it to be considered a "primary key". Or is there and I'm simply not aware of how to do that? The reason I ask is I've been tasked with a variety of goals with respect to Hubspot portal "data wellness" and such, and the first thing I learned was that most of the companies in the data have not just one, but often many duplicates. It's not at all clear to me what is causing that, but it's rather troubling because those who need to leverage the data might converse with someone that leads them to want to update company data, and they're probably going to update the first company record they find (users were actually surprised to hear there were duplicates to begin with..), which might not necessarily be the "most golden" version of the company. (If I'm making any sense...) Which leads to the question of since records with duplicate "Name" properties are allowed, and name uniqueness isn't enforced (or can it be?), is there an API way to merge companies? Or at least a way to accomplish that in Hubspot itself?