877.703.4488 info@cloudmybiz.com
Managing Duplicates in Salesforce

Managing Duplicates in Salesforce

Managing duplicates can be a big deal. Most businesses these days are collecting larger and larger amounts of data, however, too much data, especially if it lacks organization or management, just becomes a whole lot of noise that can be more confusing than helpful. 

If your Salesforce instance has tens of thousands of leads and contacts, you know exactly what I am talking about. In this article, we want to quickly talk about some of the main issues that arise from having unchecked duplicates in your CRM. Following that, we will discuss the default duplicate checking and prevention rules in Salesforce, and give you a few tips on using them.

Issues Related to Data Duplicates

Prevent Multiple Reps from Contacting the Same Leads 

This is obviously a big no-no, and makes your company look pretty bad. Duplicates of your accounts, contacts, and leads can make it impossible to track who has done what, no matter how diligent your team is with updating their activities. The ugly scenarios are many, including sales calls being made to current or former clients. 

Automation Nightmares

You probably want to automate as many processes as you can right? But duplicate data can put a wrench in the works. If you use automated lead assignment, multiple reps can get assigned different versions of leads, creating many extra phone calls, and unhappy customers. If you have duplicate records, your reporting will certainly be off and make it impossible to get good metrics on sales pipelines and more. Even works, dupes could cause repeated transactions, processes, or info requests creating plenty of extra work and possibly even losing you money directly. 

Disconnects Between Marketing and Sales

If you are using Salesforce and one of the marketing programs out there, Marketing Cloud, Pardot, HubSpot, etc. you will be sharing those leads and contacts. Most people unsubscribe pretty fast if they receive the same marketing email 2 or 3 times in a day. Beyond that, if you have a large volume of duplicate records, you can actually negatively effect your marketing performance, either by slowing down the works with too much volume or by getting your emails marked as SPAM by various email filters. 

Duplicate Management in Salesforce

If you type the word “dupe” into the AppExchange, you will a plethora of powerful, functional apps. If your system is riddled with duplicates and suffering from significant problems, we recommend looking into these apps, or even hiring a consultant who specializes in data de-duplication.

However, for those who aren’t suffering from critical data issues, Salesforce comes standard with duplicate management options that, with a little time and effort, should get the job done. It needs to be noted that these rules are geared at leads and contacts, with accounts being an option as well.  

If your org was purchased after 2015, your duplicate check rules come automatically activated, while those who purchased earlier, you need to activate them yourself. Watch this video for a quick guide on setting up your duplicate rules. 

These rules will allow you to do a couple of things:

1) When someone manually enters a new lead, a notification will pop up if the matching rules register the lead or contact as a dupe. You can also block matched duplicates from being entered here. 

2) On an already created contact or lead page, the system will automatically check for possible duplicates, and the lead page can be set up so that users can quickly see and merge possible dupes.

Not bad right? Well, there is one more bit of info here to be aware of, and that is what the criteria are for the matching rules. Different companies all look for different data points when entering leads, such as, company, location, email, etc. Salesforce has defined a small series of their most common rules that would flag a lead as a possible dupe, such as First Name, Last Name, Title, and Company. This is obviously important, because depending on your business practices, the default rules may give you too many dupe hits, or not enough. For a full list of what Salesforce looks for, click here.

Of course, Salesforce being pretty darn customizable, you can also create your own matching rules if you find that the default rules are not effective enough for your org. Simply find “matching rules” under your Salesforce Setup menu – click New, and define your own custom set of criteria!


-Ryan and the CloudMyBiz Team


Want to get started with Salesforce? 

Need some custom consulting or development to enhance the Salesforce you already have?


Contact us

App of the Week – Duplicate Check for Salesforce

App of the Week – Duplicate Check for Salesforce

Duplicates in your CRM are rarely a good thing. Luckily, it is such an important problem, that there are many different companies out there working to help you solve this probelm. Duplicate Check is just one of those. As the most downloaded de-duping app on the AppExchange, Duplicate Check does the job by comparing objects at the point of entry and allowing you to delete or merge dupes. It even works across objects, so that you can avoid entering new leads if they are already contacts!

Duplicate Check offers the most complete and extensive duplicate prevention tools. An all-in-one native application.

Check it out here!


App of the Week – Clean your data fast with Duplicate Check for Salesforce

App of the Week – Clean your data fast with Duplicate Check for Salesforce

Data cleanup is a tricky business. Finding duplicates is time-consuming and tedious, while preventing duplicates can be just as difficult. Matching up records involves cross-checking multiple fields and hoping no one mistyped or used different data entry conventions. Maintaining a clean database can be a fulltime job for a full team. Having a tool at your disposal that can scale as the size of your system grows is critical, and Duplicate Check for Salesforce is an awesome choice!

Duplicate Check for Salesforce is highly customizable and able to perform fully automated deduplication jobs—have a report ready at any chosen moment. Data transfer is not needed in order to cleanse your data. The application is quick and easy to use. If needed, a dedicated support team is at your disposal with a response time within 24 hours.

Duplicate Check for Salesforce is a freemium app with clear pricing information on their site to help you decide which license will work for your team. Check it out and clean up your Salesforce org today!