Cloudy's Favorite Apps: DupeCatcher

The number one Salesforce.com data quality complaint at most organizations is duplicate accounts and contacts.  Without safeguards in place, it can be all too easy to add duplicate records.  When this problem reaches a critical threshold, is it impossible to trust your data and make the daily decisions that depend on it. 

Salesforce.com experts and developers have many strategies, tools, and apps to address this common issue, including proper search technique for users and good matching criteria for data uploads.  The third strategy used by many companies who are winning the battle against "dupes" is DupeCatcher from Symphonic Source.  This simple, free app stops dupes on their way in, based on rules that you define.  

If you have never installed an AppExchange app in your Salesforce.com org, DupeCatcher is a great first choice.  Start the process by going to the AppExchange listing and clicking the green "Get it now" button.  After you follow the step-by-step directions to install it in your org, you will find you have a new listing for Dupecatcher in the App menu drop-down in the upper right corner of your Salesforce.com.  If you click on it, you will have a new view of the collection of tabs that comprise the DupeCatcher App.  To start blocking dupes in your org only requires two steps:

Step 1: Create a Filter
On the "DupeCatcher Filters" tab, click "New" to create a new filter.  From the drop-downs, select whether the filter will apply to Contacts, Accounts, or Leads and define the action you want to occur when a duplicate is detected.  For instance, do you want the duplicate to be completely blocked, or just display a warning to the user?

Step 2: Define the Filter Rules
Once you have saved your filter, it is time to define the duplicate-matching criteria.  On the filter record, scroll down the the DupeCatcher Filter Rules related list and click the "New DupeCatcher Filter Rule" button.  You will probably want to add several rules to have a well defined filter.  

Here is an example of a good set of rules for one contact filter:

Resources:
DupeCatcher on the AppExchange <--Go here to download to your Salesforce.com org
www.DupeCatcher.com <--For more information and resources about this app
Cloudy's favorite: Quick-Start Guide from DupeCatcher
Cloudy's Step-by-Step Direction to install an app

For more of Cloudy's advise about Dirty Data:
Clean ALL the Data!!! Part I
Clean ALL the Data!!! Part II

If you would like help setting up DupeCatcher in your org, if you are struggling with duplicates and need help cleaning up the mess, or if you would like more resources and training on how to effectively manage your data, please Contact Us!

More of Cloudy's Favorite Apps:
FormAssembly
Rollup Helper
Conga Composer
FlipTop