« Data Quality Tips | Main | How do you handle your e-Waste? »

Analyzing Incoming Duplicates

I’m all about metrics and measuring things, and analyzing incoming duplicates is part of that.  From a user perspective, that’s one of the things I like best about Salesforce—they make it so easy to track, measure, analyze, and crunch numbers.  But, the one major caveat is that any reports or dashboards that get created are only as good as the data that supports them.  So if data quality is a problem, data analysis will be too.

There are lots of challenges to maintaining high levels of data quality, and not so many solutions.  One quick and easy one that I’m mentioned here before is a free app for Salesforce called DupeCatcher (available on the AppExchange).  Now, DupeCatcher is limited.  It does one thing, but it does it well.  It dedupes in real time on incoming records (manual or from web forms).

What’s cool about DupeCatcher is that an admin can run an analysis on incoming duplicates without impacting user operations and procedures.  There’s a way to have DupeCatcher trigger an alert when a dupe gets created.  An admin can then look at these alerts over any given period of time and begin constructing a picture of how bad the problem is—and how quickly the data set is getting dirtier and dirtier.  If the admin likes what DupeCatcher does, he or she can choose to change the method by which the app reports duplicates and train users on what to expect and how to react.

I love it.  And it’s free.  Check it out 

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
All HTML will be escaped. Hyperlinks will be created for URLs automatically.