I am a salesforce user. In many instances, our system flags many contacts as duplicates when they are not. For example, sometimes it will flag distinct contacts as duplicates based on similar addresses. However, this pattern has not always been consistent. I'd appreciate any insight anybody who has experienced this before can provide.
Salesforce uses three stages to determine duplicates:
- Matching Equation: Which fields have to match in order to be considered a duplicate. For Contact this would be:
(First Name AND Last Name AND Title AND Company Name)
- Matching Criteria: Which algorithm is used for each field to determine duplicates and how to deal with blank fields. For example the field MailingStreet is broken into sections and compared by those sections. Each section has its own matching method and match score. The section scores are weighted to determine a score for the field.
- Matching algorithms: Finally there is a set of different matching algorithms used in those fields. You can find a list and explanation at the Salesforce Documentation
For Contact there is also a help page on Standard Contact and Lead Matching Rules