- Case insensitivity.
- Typos and abbreviations.
- Accented characters. For dupe detection, you probably should consider é the same as e.
- Misspellings, name substitutes and people's nicknames, such as Scott, Scotty and Scooter.
- So-called "street names" (Disney instead of The Walt Disney Company) and divisions (Pixar instead of Disney) for a Contact's employer.
- Converting a CRM lead record to a contact if there's already a match with one of the outside contacts.
- Multiplying (roughly) 10 email addresses, eight phone numbers and five mailing addresses per contact. Of course, each of these should be a related record off the main contact, but you have to accommodate systems that don't support that natively.
- Accounting for country and state variations. As I wrote previously, you really want ISO codes, but many systems' data won't have them.
- Merging multiple avatars for the same individual. Some systems won't easily support merges, so you have to have a strategy for this.
- Finally, applying adaptive or fuzzy scoring for duplicate candidates. For example, if you've matched an unusual name such as Flash qFiasco, it's probably a dupe, even if the addresses are in different states.
Now That the Simple Stuff Is Done&
The bulk of an enterprise's contact information is in everyone's email client address book. Most of those address books can be totally ignored for synchronization with the CRM. That said, address books of executives, sales people and customer support people are likely to be valuable.
There are two main use-cases for email and CRM Contact synching. First, there's aggregating everyone in the client and prospect world. This level-0 social network is useful in both prospecting and cultivating customer relationships. In this case, the value is in collecting and centralizing information from users' address books.
Tip: Avoid 3 Key CRM User Identity Mistakes
Second, there's distributing the latest contact information to anyone who needs to use it. If we find out that Joe Bigshot at Widgets Inc. has a new mobile phone number, then that new number should show up in everyone's address book.
Unfortunately, several things get in the way of these useful use cases.