Slaesforce FAQ

how to clean up duplicates in salesforce

by Prof. Albertha Greenholt Published 2 years ago Updated 2 years ago
image

In Salesforce Classic
Click + (All Tabs) on the Navigation bar. Search for Duplicate Record Sets. Select the Duplicate Record Sets that need to be deleted. Click the Delete button.

Full Answer

How do I manage duplicates in Salesforce?

Salesforce has the capability to effectively manage duplicates by simply adjusting the standard duplicate settings or by creating custom rules. In your Salesforce org, search for Duplicate Rules in Set Up.

What does Salesforce flag as duplicates?

Salesforce flags contacts with matching phone numbers as duplicates, even though one includes a country code and the other doesn’t. Now let’s learn more about using duplicate rules to manage records.

How can I prevent sales reps from creating duplicate accounts?

By activating duplicate rules and the Potential Duplicates component, you can control whether and when sales reps can create duplicate accounts, contacts, and leads. You can also give them permission to merge duplicate leads, business and person accounts, and contacts.

How can I get the most out of Salesforce?

Maintaining clean, accurate data is one of the most important things you can do to get the most out of Salesforce. It builds the trust of your sales team and helps you work toward complying with various data protection and privacy regulations.

image

How do I mass delete duplicates in Salesforce?

Select Show all Salesforce objects and select Duplicate Record Set (DuplicateRecordSet) object. Select Id and any other desired fields and follow the prompts to complete your export. For more information, review Exporting Data. Review the resulting CSV file to verify the DuplicateRecordSet to be deleted.

How do I manage duplicates in Salesforce?

To manage duplicates that aren't surfaced by a duplicate rule, create a duplicate record set.On a duplicate record set list view, click New.Specify a duplicate rule (in the Duplicate Rule field) or a duplicate job (in the Parent field).In Lightning Experience, in the Related tab, click New.

How do I filter duplicates in Salesforce?

How to configure duplication rules:Go to Setup, in the QuickFind type Duplication Rules.Select New Rule and the object you want.Enter a name and description.Select the record-level security required: ... Set the action you want to happen when records match.More items...

Can you remove duplicates in Salesforce report?

You can't remove the duplicates in the report; the report builder doesn't do distinct so I'd recommend Excel.

How do I check for duplicates in Salesforce?

1:182:12Using Duplicate Check in Salesforce - Lightning - YouTubeYouTubeStart of suggested clipEnd of suggested clipAnother way to use the duplicate check feature is to go underneath the contacts tab in salesforce atMoreAnother way to use the duplicate check feature is to go underneath the contacts tab in salesforce at the top ribbon.

How do I report duplicates in Salesforce?

In Setup, use the Quick Find box to find Report Types.Create a report type, selecting Account, Contact, Lead, or Duplicate Record Set as the primary object. ... Click Next.Relate Duplicate Record Items to the primary object that you selected.More items...

How do you prevent duplicates in Salesforce?

Block sales reps from creating duplicate leads. In the Standard Lead Duplicate Rule, select Block instead of Allow. With the Standard Lead Duplicate Rule set to block duplicates, a rep can click to view duplicates of leads but can't save a new lead.

How do you find duplicates in Salesforce lightning?

In Setup, use the Quick Find box to find Lightning App Builder. On accounts, contacts, or leads, add the Potential Duplicates component. Select how you want to alert sales reps to duplicates. You can't add the Potential Duplicates component to custom objects.

How do you prevent duplicate cases in Salesforce?

Preventing duplicate records in Salesforce based on a single field can be achieved using a Set that can store the values of that specific field from all existing records and compare it with the list of new records that are going to be inserted.

How to Find Duplicates in Salesforce

Salesforce has the capability to effectively manage duplicates by simply adjusting the standard duplicate settings or by creating custom rules.

How to Remove Duplicates in Salesforce Lightning Experience

Once you have your duplication-catching rules in place, go through and do a quick check of your permissions. To merge duplicate contacts in Lightning Experience, you need permissions to “delete contacts.” If you want to merge Customer Portal enabled contacts, you need permissions to delete contact records and edit Self-Service Users.

How to Remove Duplicates in Salesforce Classic

In Salesforce Classic, you can remove duplicates by merging contacts. Check your permissions before getting started. To merge contacts, ensure you have permission to delete contact records. If you plan to merge Customer Portal enabled contacts, you’ll need to be able to delete contact records and edit Self-Service Users.

What happens if you don't resolve duplicates?

Duplicates can cause: Different sales reps calling the same prospect or customer. The business to appear disorganised to prospects and customers.

What are some examples of fuzzy matching?

An example of a fuzzy match of Jennifer Smith. Jenifer Smith. Jennifer Smyth. Gennifer Smith.

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.

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.

Create a Custom Matching Rule for Contacts

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

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, with one matching rule per object.

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.

Resources

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

Hands-on Challenge

You’ll be completing this challenge in your own hands-on org. Click Launch to get started, or click the name of your org to choose a different one.

image
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z 1 2 3 4 5 6 7 8 9