Make Your Project Successful with Salesforce
Our CRM consultants will assist you in Salesforce implementation, and tell you when and how you should start preparing your data for migration to Salesforce.
Poor data quality can cause up to $15 million of annual financial losses on average, based on research from Gartner. Doesn’t it sound convincing enough to start rethinking the ways you keep your data clean and accurate? But, if you are already exploring ways of instilling trust through your accurate data then it’s the right time to dive with us into the topic of Salesforce duplicate management.
Of course, duplicate data is only a part of the problem if we think about data inaccuracy. It also involves missing fields, invalid data formatting, invalid data like emails, phone numbers, or addresses. But, duplicated data is still the top data management pain point preventing the successful operation of the organization.
And, if maintaining clean a thousand records may seem not a big deal, keeping clean and up-to-date huge volumes of data across various departments or regions of the company can become a real problem.
Moreover, you can choose several options depending on the amount of information stored and entering your CRM system.
This post will explore the key topics related to how to prevent duplicate records in Salesforce, like:
Let’s revise the most common Salesforce duplicate management approaches on how to find duplicates in Salesforce and to get the most out of your platform.
Problems related to the data quality may result in:
Data disorganization may seem a disturbing sign for customers because if the company can’t track its own business, how can they properly care for their clients’ interests? And it’s when trust in your company can be at stake.
However, Salesforce wouldn’t be the leader in the CRM market if this company hadn’t thought ahead of time and designed ways of weeding out bad data. You can save your sales reps time and prevent them from missing important sales opportunities by flagging records that are potential duplicates and having access to all their prospects’ and clients’ reliable data.
And, as a result, your teams can be confident that they’re capturing correct data at the right time and stop guessing games of whether they’ve qualified the same prospect. And all of this can be achieved with Salesforce data management solutions.
Our CRM consultants will assist you in Salesforce implementation, and tell you when and how you should start preparing your data for migration to Salesforce.
We’ve outlined some of the issues that duplicate data can cause. But, fortunately, to ensure that your organization complies with various data protection and privacy regulations, Salesforce enabled duplicate management tools to find duplicates in Salesforce as well as to track your progress in their removal.
Also, Salesforce data management helps prevent your sales reps from generating more duplicates. However, CRM data deduplication isn’t available out of the box on Salesforce and needs manual involvement in the activation of Salesforce duplicate management functionality.
Salesforce Duplicate Management allows you to easily deal with duplicates for:
You can configure its logic up to your needs and exceed just exact detection and matching capabilities. Standard matching logic can identify possible duplicate records based on exact matches. For example, two contacts with the same name.
But if you choose to set up a rule including fuzzy matching, you’ll be able to find potential duplicate records based on a variety of fields.
For example, if you activate a rule including fuzzy matching for first names. Duplicate management tool will identify the two contacts Antony Brandon and Brandon Brown as possible duplicate records.
The inbuilt Salesforce duplicate management tools are already included in Essentials, Professional, Enterprise, Performance, Unlimited, and Developer Editions. And they imply Matching Rules, Duplicate Rules, and Duplicate Jobs.
Now, let’s have a look at the gist of this function. We’ll go through the process of deduplication, and how to determine what’s the best approach for your organization.
Top Salesforce Apps to Power Up Your Salesforce Org: How You Can Benefit from Duplicate Check App
Matching Rule in Salesforce is about the criteria of identifying duplicates and matching records as a duplicate. You can pair records within an object or across two objects with different matching algorithms. For example, Lead and Contact matching algorithms may include exact matches, fuzzy matches like an acronym, initials, or name variants.
You can also create custom matching rules to include fuzzy matching for phone numbers. Salesforce will flag contacts with matching phone numbers as duplicates, even if one includes a country code and the other doesn’t.
Limitations of Salesforce duplicate matching rules:
A Duplicate Rule in Salesforce defines in what situations the Matching Rule can be executed and what action should take place once a duplicate is detected using the Matching Rule.
There are four sets up to cover the different scenarios of comparing:
Duplicate rules can initiate two possible results:
Depending on how you configure duplicate management, sales reps will see an alert if they’re about to create a duplicate or they will be blocked from creating the duplicate altogether.
After matching rules do the work of identifying potential duplicates, duplicate rules step in, and determine what to do with them. As the admin, you choose whether to block your sales teams from creating duplicate records or let them create the record.
You may also watch a video dedicated to using Duplicate Rules and the Potential Duplicates Component.
For Salesforce users on the ‘Performance’ and ‘Unlimited’ editions, Salesforce has improved Duplicate Management with Duplicate Job functionality for detecting duplicates in existing data in mass. The Duplicate Job produces a list of duplicate record sets from which you can compare and merge duplicate records.
Ok, now when you already know what Duplicate Jobs in Salesforce stands for it’s time to get to know its constraints.
Limitations of Salesforce duplicate jobs:
CRM Adoption Best Practices: The Top Ten Reasons Why You Can’t Adopt a CRM
Besides, limitations related to Matching Rules and Duplicate Jobs, there are certain constraints related to duplicate merging in Salesforce. Among them are:
But the good news is that you can overcome most of the limitations with data deduplication apps or via setting custom Salesforce Apex Triggers.
More details concerning Salesforce customization and duplicate management can be found in the following Salesforce Help articles:
We offer all types of Salesforce consulting services such as implementation, integration, customization, administration, AppExchange app development.
Matching Rules and Duplicate Rules align together to help your teams work with data that’s duplicate-free. Let’s imagine you create a contact in Salesforce. When you create the contact, the system looks for potential duplicates according to criteria set in a Matching Rule and generates a list of potential duplicates.
The Duplicate Rule defines whether the contact will be blocked from creating or the CRM will create it with a warning.
If you choose to create the contact, the rule can even add the possible duplicate to a duplicate contact report in Salesforce. However, if you have difficulties with figuring out how to activate duplicate rules in Salesforce or how to use Salesforce Duplicate Management tools to your advantage, you can always seek professional advice from our seasoned Salesforce professionals.
Salesforce standard duplicate management functionality as Matching and Duplicate Rules ideally fit SMB’s or companies who are new to Salesforce. A firm that works with standard objects, a small amount of data (less than 10,000 records), and has one or two ways new records enter your Salesforce CRM, will be satisfied with it.
The number of newly created records is also an important factor to consider. Tens of new records each day can be easily managed with Salesforce Duplicate Management features. But if you have hundreds or even thousands of incoming data, automation and customization can become a necessity.
Even though data deduplication isn’t available out of the box, luckily, Salesforce allows you to create your own Duplicate Rules for preventing duplicates. And here’s the list of must-have Salesforce duplicate rules you need to enable right now.
We’ll start with the Salesforce Account duplicate check. When users create Accounts (companies of your potential or existing clients), it’s highly possible that they can forget to search for this company and to check if it already in the CRM. And, as a result, they can create duplicates. To prevent duplicate generation, you can create the following duplicate rules:
By setting up this rule, you can avoid creating multiple Accounts with the exact same Account name.
Here’s how to activate an Account Exact Name Matching Rule in Salesforce
After that, you need to activate an Account Exact Name Duplicate Rule
To do it you need to use the Matching Rule you’ve recently created, and generate a unique error message. Check if you selected “Block” on both Create and Edit Actions.
Account Name Potential Match Duplicate Rule will alert users of a possible duplicate where account names somewhat differ. For example, for company names that include an acronym where users can type “Inc.” instead of “Incorporated” or companies that use similar naming for different regions such as “Bosch USA” or “Bosch UK”.
To create this duplicate rule, it’s necessary to create Salesforce’s Fuzzy logic, and use a different error message.
This is how to create an Account Name Potential Match Matching Rule in Salesforce
While creating an Account Name Potential Match Duplicate Rule you need to ascertain to Allow on Create and Edit Actions
It’s that simple. Now your Accounts are monitored for duplicates!
However, Leads and Contacts duplicate detection in Salesforce is a more sophisticated task comparing to that one in Accounts because they both refer to individual people. And duplicate rules should not only ward off Leads duplicates, and Contacts duplicates, but also they should prevent users from creating Contacts that are already Leads, and prevent users from creating Leads that are already Contacts.
Altogether, there are four possible cases that may happen:
To prevent them, you have to set up individual Duplicate Rule and assign to each of them a very specific error message to direct the user on what they need to do. Also, a good practice is to link rules to a person’s email address because it’s highly possible that several people can have exactly the same first and last name.
Here’s how to create a Lead Email Exact Matching Rule in Salesforce
How to Create Lead Email Exact Matching Rule and Prevent Duplicate Leads in Salesforce
Afterward, set up a Contact Email Exact Matching Rule:
We’re going to use these two Matching Rules to make the rest of our Duplicate Rules.
Lead-to-Lead Email Exact Match duplicate rule helps to avert the creation of multiple Leads with the exact same email.
How to Activate The Lead-to-Lead Email Exact Match Duplicate Rules and Prevent Duplicate Leads in Salesforce
Lead-to-Contact Email Exact Duplicate Rule will prevent duplicate of multiple Leads-to-Contacts with the exact same email.
Prior to creating it, compare Leads to Contacts, and assign it a unique error message.
With the help of this duplicate rule, you can avoid creating multiple Contacts with the exact same email.
How to Create Contact-to-Contact Email Exact Duplicate Rule and Prevent Duplicate Contacts in Salesforce
By activation of this rule, you will prevent the creation of multiple Contacts-to-Leads with the exact same email. Don’t forget to compare Contacts to Leads, and give it a unique error message.
In this example of the rules our Salesforce consultant, Marissa Mills has set up matching rules and duplicates rules against Leads and Contacts to match on the Email field and a custom “LinkedIn” URL field.
If you sell to B2B companies and don’t track LinkedIn links for your Contacts, Leads, and Accounts, then we strongly recommend starting doing it right away. While not all people obviously have their LinkedIn profiles, the majority of us have them.
Every time when we change the employer we change our work email. However, the LinkedIn profile remains the same.
Based on our experience, you can identify quite a lot of duplicates when simply add LinkedIn profiles for contacts and then run the Duplicate detection rule based on Linkedin profiles.
Why? Because you might have the same person created multiple times with different companies and the email detection rule is helpless in such cases.
Please note that the LinkedIn URL can be slightly different, depending on where you get the link from:
You should agree with your team on what link format to save to maximize the effect of this rule. And if you have some links in the system, make sure to check and unify them.
Here’s how to create Contact/Lead Email or LinkedIn Exact Matching Rules in Salesforce
Below you may find how to create Lead Email or LinkedIn Exact Matching Rules in Salesforce
The following are the duplicate rules that were set up using the above matching rules. There were four different scenarios of comparing:
To create Lead-to- Lead Email or LinkedIn Exact duplicate rule you need to do the following:
To create a Lead-to-Contact Email or LinkedIn Exact duplicate rule you need to do the following:
To create a Contact-to-Lead Email or LinkedIn Exact duplicate rule you need to do the following:
How to Create Contact to Lead Email or LinkedIn Exact Duplicate Rules and Prevent Duplicate Contacts in Salesforce
To create a Contact-to-Contact Email or LinkedIn Exact duplicate rule you need to do the following:
And that’s it! To check if everything works as it’s been planned, you can test these duplicate rules out in your Sandbox or Developer Org first. You can use the following testing scenarios with sample Email or LinkedIn URL data:
All in all, configuring the above-mentioned duplicate rules is the first step in ensuring high data quality standards and maintaining a healthy Salesforce Org.
For additional information about dealing with duplicates, you can explore the Trailhead Modules on Duplicate Rules Management in Salesforce.
We will teach you how to use CRM software to the fullest without overpaying for unnecessary functionality.
Clean and accurate data is an integral part of any successful business. And even though it requires time to manually activate duplicate rules in Salesforce to keep your records deduplicated, the result promises to be rewarding at the end.
However, if you can’t afford to spend much time on getting to know Salesforce duplicate management functionality, our CRM consultants will help speed up the way to a well-organized and healthy database. We’ll select the most optimal approach to your data deduplication and maintenance considering the specifics of your Salesforce org, the number of records, budget, and complexity of the overall project.
Contact us and break the ice between you and the top-notch CRM technology available on the market.
Anzhelika is a seasoned B2B content marketing strategist with extensive experience in elevating corporate profiles through compelling content. At Ascendix, she offers a wealth of knowledge in Salesforce consulting, providing valuable tips, tricks, and comprehensive guides. Additionally, Anzhelika stays at the forefront of the industry, delivering expert analysis on the latest Salesforce tools and emerging technology trends.
Ascendix Technologies is your trusted Salesforce implementation partner. Maximize your Salesforce investment and help your team become more productive. Contact us to discuss your project today!