Managing Duplicate Names (without Operations Hub)

I’ve got a number of contacts that are duplicates based on their name and not email.

I’ve got ato enrichment going on via Apollo and when it fnds a new email address of an existing contact it is adding them as a new contact.

So I’ve got to stop the root cause but I now need a way to create a list of these contacts.

I know the Operations Hub has a Duplicate Mgmnt tool but that is not an option for me.

Was trying to create a clever dynamic list but can’t figure out the logic - if that’s at all possible?

Thanks

@DBrazil - Would it work to create a custom pivot table report with last name and first name in the rows and count of contact in the values. Order the table by highest contact of contacts descending. Any with a value of 2 (or higher) could potentially be duplicates. Like this:

In the fields, add email and record ID, so when you click on the count of contacts number that is a 2 or higher, it shows you which record has the email address assigned and also a hyperlinked record ID to take you to the records to merge as required:

I’m going to give this a go - thanks Hannah

Hi Hannah - what type of report is this in Hubspot - I can’t seem to create one like yours through the report builder.

Thanks

Dan

A pivot table. This icon in the custom report:

Thanks Hannah

Figured it out now - however, the issue I’m hitting is that there are too many records (4163) for the report to create. In preview mode I can tell it is working as per the design you shared.

What I’m trying to do - and succeeding - is to filer so that it only picks out records where count of contacts is greater than 1. But I can’t pull that into the filter criteria.

Any suggestions?

-- Update -- I ended up exporting as a CSV and doing the analysis that way which wasn’t too bad - however, still keen to know if I missed anything to keep in internal to Hubspot

@DBrazil - I don’t believe there is a way to filter by the count of contacts in HubSpot ATM unfortunately, no.