Slaesforce FAQ

how to dedupe leads and contacts in salesforce

by Prof. Omer Fay II Published 2 years ago Updated 2 years ago
image

Do you have duplicate leads in Salesforce?

Everyone working with Salesforce has experienced duplicates. In your role as a salesperson, you just followed up on a lead only to find out a colleague is already in contact with this person – that’s a duplicate lead!

Does Salesforce have a deduplication solution?

To recap, Salesforce has a basic deduplication solution for the most commonly used objects (Leads, Contacts, (Person)Accounts), allowing alerting and blocking on the creation of duplicates. A batch process for deduplicating existing data is also available for higher-end Salesforce plans.

What is duplicate management in Salesforce?

The Salesforce Duplicate Management feature consists of Matching Rules and Duplicate Rules. Matching rule: Consists of criteria to identify duplicate records. Salesforce comes with three standard rules: one for business accounts, one for contacts and leads and one for person accounts.

How many new records should your Salesforce organization have?

When you work with standard objects, small record counts (< 10,000 records) and have one or two ways new records ente r your Salesforce organization, there is probably no need to look further. The number of newly created records is also an important consideration.

image

How do I manage duplicate leads in Salesforce?

– In Salesforce Classic, click the Duplicate Record Sets tab. 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).

How do I Dedupe records in Salesforce?

In the first phase of a deduplication project, you focus on your data requirements alone.List all objects that need deduplicating. Make a list of all objects that need to be deduplicated. ... List relevant fields for each object. ... Indicate matching method for all fields. ... List words to ignore.

How do you find duplicate leads in Salesforce?

Go to Salesforce setup, and search for 'Report Types'.Click 'New Custom Report Type'.Choose Leads as the Primary Object.Name your report type, eg. Duplicate Leads Detected. Add a description, I like to describe what our business considers a duplicate, ie. ... Store in the 'Administrative' category.Select 'Deployed'.

How do I duplicate a contact in Salesforce?

Merge Duplicate Contacts in Salesforce ClassicFrom the Contacts related list of an account, click Merge Contacts.Select up to three contacts to merge. ... Select one contact as the master record.If your organization uses a partner or customer portal, you can select which record you want to retain as the portal user.More items...

What is lead Dedupe?

Lead Deduplication or Duplicate Leads Lead Deduplication is the process of identifying and eliminating duplicate leads within a specified set of data. This process is able to analyze data across different directories, data types, and servers even in different locations.

How do you prevent duplicate leads in Salesforce?

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. Prevent reps from creating duplicates of records they don't have permission to view.

How do I mass merge duplicate contacts in Salesforce?

Merge Duplicate Contacts in Salesforce ClassicFrom the Contacts related list of an account, click Merge Contacts.Select up to three contacts to merge. ... Select one contact as the master record.If your organization uses a partner or customer portal, you can select which record you want to retain as the portal user.More items...

What is duplicate rule in Salesforce?

A duplicate rule defines what happens when a user views a record with duplicates or starts creating a duplicate record. Salesforce provides standard duplicate rules for business and person accounts, contacts, and leads. You can also create duplicate rules.

How do I create a duplicate contact report in Salesforce?

(To generate this report, select the Report option in a duplicate rule.)...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...

The big deal about dupes

Duplicate records are dangerous to system credibility because users can’t find the updates that they’ve made (they’re looking at the wrong copy of the record) and each of the dupes represents an incomplete record with multiple data quality issues.

Prevention is the best cure

The starting and ending point of any deduping project is this: finding defects in processes and systems to prevent the creation of dupes in the first place.

Where to start

The only place to start is to stop and think. Because you can’t do anything good without developing a strategy to fit your specific situation. And there are several situations where something that looks like a dupe actually isn’t one. Here are some examples:

Integrated systems and plug-ins

This is where things get hairy. Let’s start with the simple stuff: plug-ins. Most plug-ins installed in SFDC don’t really mind deduping and probably won’t corrupt anything when you merge. But read that word “most” – you must test with your particular configuration of plug-ins to make sure nothing nasty happens.

Danger Will Robinson!

Deduping is such a tricky business that I have to stress these best practices:

Preventing duplicate Salesforce records

Duplicate record prevention is a cute little topic, but it’s part of a much larger data quality topic. The big picture is embodied in this sentence: no record should be created without some level of procedural or automated controls.

Nipping dupes in the bud

We all make mistakes, and with certain extract, transform, load (ETL) and import cycles, big fat errors are just a mouse-click away. The problem is, with triggers and workflows, any SFDC insert or update may have tons of repercussions on other records.

Identify Salesforce Duplicates Using Any Data Field

Are you tired of exporting .CSV files and using Excel functions and VLOOKUP to identify duplicates in Salesforce? Or trying to identify and merge them manually?

Smart Merge Records in Bulk with Flexible Rules

Don’t worry about overwriting important Salesforce data or creating duplicates. With Insycle, you can set rules for determining the correct master record and pinpoint the exact fields that will be replaced during the merge.

Merge Duplicates In Bulk or One At a Time

Insycle allows you to set rules and smart merge duplicate Salesforce records in bulk. But, you can also identify and merge records one at a time as well. You have complete control over the processes that you employ for identifying and merging duplicate Slaesforce contacts, companies, and deals.

Automate Salesforce Dedupe Processes for Any Record Type

Insycle not only makes it dead-simple to identify and merge duplicates in Salesforce, it allows you to run automated deduplication processes at regular intervals. You can setup your Salesforce deduplication engine to run daily, weekly, or monthly.

Preview Saleforce CRM Data Changes Before They Go Live

In Insycle, you always have the ability to double-check your Salesforce data changes before they go live in your database. Before each process pushes the altered data to your database, you can inspect changes on a case-by-case basis to avoid unwanted data overwriting and alterations.

Maintain a Single Customer View in Salesforce

Give your sales reps a full-picture view of your brand’s engagement with each customer. Insycle makes Salesforce deduplication simple and improves the customer experience throughout the pipeline.

How to merge duplicate leads in Salesforce?

If the duplicate records are leads, you can merge them together into a single lead. Open one of the duplicate leads. Click Find Duplicates. Select the duplicate leads you want to merge. Click Merge Leads. Select a Master Record. Salesforce will pick the record that contains the most information as the "master record" to keep.

Can you merge contacts and leads?

Open the duplicate lead. You can only merge leads with other leads, and contacts with other contacts, so you’ll need to convert this lead to contact before you can merge it.

Document Your Lead Deduplication Logic

Lead deduplication is one of those seemingly simple tasks that is actually fairly complex in execution. There are many nuances you’re probably unaware of unless you have done it many times before.

Verify Your Data Sync Status Between Salesforce.com & Your Marketing Automation Solution

Whether you’re deduplicating leads, contacts, or accounts, chances are the data set you’re trying to dedupe exists in multiple systems.

Check For Data Verification Rules and Other Automation that May Interfere

Your systems may have data verification rules and other types of features turned on that can interfere with removing of duplicates. If there are, you’ll see these symptoms when you try to merge records:

Check For Bad Data & Business Processes That May Interfere

Your system may have bad data that can also prevent deduping from executing successfully. Some of these bad data situations may be quite a head-scratcher on how they came to be, but they are definitely out there. In some cases, they are explicitly allowed by your business processes. Here are some examples:

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