Resolve and Prevent Duplicate Data | Trailhead Screen Reader Instructions


Learning Objectives

After completing this unit, you’ll be able to:


Rules for Duplicate-Free Data

Matching rules and duplicate rules work together to ensure that your sales teams work with data that’s free of duplicates. Before your reps save new and updated records, matching rules and duplicate rules provide warnings of potential duplicates. You manage matching rules and duplicate rules in Setup.

But what’s the difference between matching rules and duplicate rules?

 

Matching Rules

Let’s look at how matching rules work in Salesforce.

We developed our standard matching rules to return the best possible set of match candidates for business accounts, contacts, leads, and person accounts. Here’s an example of some of the matching criteria we include for contact and lead records.

 

Contact and Lead Field Matching Algorithms Special Handling Example

First Name
  • Exact
  • Initials
  • Jaro-Winkler Distance
  • Metaphone 3
  • Name Variant

If the record contains a value for both First Name and Last Name fields, those values are transposed to consider possible data entry mistakes.

The first name is Luis and the last name is Antonio.

The matching rule evaluates the first name as Antonio and the last name as Luis.

Title
  • Acronym
  • Exact
  • Kullback-Leibler Distance

Considers acronyms and full titles.

The title is VP.

The matching rule considers VP and Vice President.

Mailing Street
  • Edit Distance
  • Exact

Addresses are broken into sections and compared with those sections. Each section has its own matching method and match score.

The section scores are weighted to determine one score for the field. This process works best with North American data.

  • Street Name (Edit Distance, 50% of field’s match score)
  • Street Number (Exact, 20% of field’s match score)
  • Street Suffix (Exact, 15% of field’s match score)
  • Suite Number (Exact, 15% of field’s match score)

Duplicate Management compares these two addresses.

  • 123 Market St, Ste 100
  • 123 Market Dr, Ste 300

Only the street number and street name match. The field has a match score of 70 out of a possible 80. This comparison isn’t a match.

We also give you other ways to identify duplicates. For example, some of your contacts include phone numbers with country codes. So you create a custom matching rule to include fuzzy matching for phone numbers. Salesforce flags contacts with matching phone numbers as duplicates, even though one includes a country code and the other doesn’t.

 

Duplicate Rules

Now let’s learn more about using duplicate rules to manage records.

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.

Let’s say you let reps create duplicate records. You can create report types that show potential duplicate records created after your reps bypass warnings. We talk about these reports more a bit later.

 

Activate a Matching Rule

We provide standard matching rules for you. If you established your instance of Salesforce for Winter ’15 or earlier, like Maria, you activate the standard rules you want to use. Maria, however, wants to activate standard rules for only accounts and leads. She has other plans for her contacts, which we cover after this procedure.

  1. From Setup, Maria enters Matching Rules in the Setup search box, then selects the result for Matching Rules.
  2. She navigates through the table of rules and presses ENTER on the Activate  link to the left of the rules for accounts and leads. Easy!

 

Create a Custom Matching Rule for Contacts

For contacts, Maria wants to include fuzzy matching for the Mailing Street field.

And instead of letting sales reps create the duplicates, she wants to block them from doing so, which we cover after this procedure.

  1. From Setup, Maria enters Matching Rules in the Setup search box, then selects the result for Matching Rules.
  2. She activates the New Rule button.
  3. Maria selects Contact from the Object combo box, then presses ENTER on the Next button.
  4. She gives the rule a descriptive name, Custom Contact Matching Fuzzy Mailing Street. She also adds a description so that other admins understand its value.
  5. Maria adds the matching criteria using the combo boxes on the page. She saves her rule and activates it.

 

Block Duplicates with Fuzzy Mailing Streets

Before an active matching rule can do anything, you pair it with a duplicate rule. You can include up to three matching rules in each duplicate rule, and up to five active matching rules per object. Maria wants to prevent sales teams from creating duplicates when the Mailing Street field includes variants, such as SW Barnes Ave and Southwest Barnes Avenue.

  1. From Setup, Maria enters Duplicate Rules in the Setup search box, then selects the result for Duplicate Rules.
  2. She presses ENTER on text saying New Rule. It doesn’t announce as a button element to screen readers. A few links appear below the New Rule text, and Maria presses ENTER on the link for Contact.
  3. Maria gives the duplicate rule a name and description.
  4. Using the Action on Create combo box and the Action on Edit combo box, she blocks the creation of duplicates. She also blocks her teams from editing contacts that result in duplicates.
  5. Continuing with the combo boxes on the page, she compares the new or updated contact with contacts already in Salesforce using the custom matching rule she created earlier. Then, she saves her duplicate rule.

 

Report on the Creation of Duplicate Accounts and Leads

Maria doesn’t block reps from creating duplicates for accounts and leads. So Lincoln wants to see the quality of account and lead data and how well the duplicate rules work. To help Lincoln, Maria sets up custom report types. Lincoln can then run reports on accounts and leads that his reps create after bypassing the warnings of creating potential duplicate records.

  1. From Setup, Maria enters Report Types in the Setup search box, then selects Report Types. She then activates the New Custom Report Type button.
  2. She selects Accounts from the Primary Object combo box. She gives the report type a name and stores it in a category.
  3. Maria selects Duplicate Record Items, so that newly created duplicate account records appear on the report. Then, she saves the report type.

From here, Maria can adjust the page layout. Then, she repeats this procedure for leads.

 

Creating an environment free of duplicates keeps your sales teams on their A game, and sales management informed on the quality of their data.


Resources

Use these resources to learn more about matching rules and duplicate rules.



Click to return to the unit on Trailhead to access your challenge and proceed to the next step.