• Skip to main content
StarrDataStarrDataStarrData
  • Technologies
    Salesforce Revenue Cloud
    Salesforce CPQ

    Deliver fast & accurate proposals that empowers your sales team and maximizes company revenue.

    Salesforce Billing

    Seamlessly integrate your entire billing process with powerful Salesforce technologies.

    Salesforce Products
    Sales Cloud

    Empower your sales team by leveraging best practices throughout the company.

    Experience Cloud

    Connect your customers, employees & partners with the power of Salesforce.

  • Services
    Salesforce Implementation

    We'll help you get up and running quickly - from simple implementations to fully customized instances.

    Salesforce Administration

    Stop worrying about the day to day details of Salesforce and outsource to a 5-star certified Salesforce team.

    Salesforce Optimization

    Get the most out of your Salesforce investment by fine tuning your instance specifically for your needs.

  • Industries
  • Blog
  • Company

    Since 2009, StarrData has helped hundreds of companies leverage the power of Salesforce. We are a 5-star certified partner with an experienced team of consultants, solution architects, engineers, and administrators.

    Testimonials

    See what our clients say.

    Partners

    Companies we partner with to provide ancillary services and integrations.

    Commitment to Equality

    At StarrData we believe that all humans are equal, and diversity is a strength. We are committed to providing equal employment opportunities and world-class service to anyone, regardless of sex, color, gender, religion, or sexual orientation.

  • Client Portal
  • Contact

Managing Duplicate Records in Salesforce using the Salesforce Lead Import Wizard

By Darren Starr
Facebook
Twitter
Twitter

If you have used any business management software, CRM software, or contact management programs, you understand that duplicate records are a way of life. Although it is a best practice to search before creating a record, duplicates still happen. Salesforce understands this and has tools built in to help you merge duplicate leads, accounts, and contacts. Due to the different processes, we will cover each object separately.

Your sales leads in Salesforce probably came from multiple sources like purchased lists from sales lead generation companies, campaigns, trade shows, and manually entered. The Lead Import Wizard does a pretty good job of finding duplicates before they are mass uploaded but what do you do when they are already in the CRM system?

Salesforce Duplicates

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

When you first go to work a new sales lead, the first thing you should do is click the “Find Duplicates” button. This searches the CRM system for matching leads, contacts, accounts, and opportunities based on the lead full name, last name, company, phone number, email, or email domain. You have the option to include or exclude any of the search criteria.Salesforce duplicates

 

By doing this duplicate search first, you may find that the new sales lead is actually a contact with a slightly different spelling in your Salesforce CRM system. Or, your co-worker may have been at the same trade show and entered the same lead. Think of all the time saved with just a press of a button!

If a contact matches the lead exactly, then depending on your sales lead process, you should either delete the lead or convert it into the existing contact and account. If you find a duplicate lead, then you can use the “Merge Leads” button. You are presented with a screen that gives you the option to pick any differing data and to select which is the master record. Any related items from the duplicate lead(s), such as activity or campaign information will be associated to the merged lead so you do not have to worry about manually moving these.

To merge accounts in Salesforce, you must first open the “Merge Accounts” tool from the Tools section on the accounts tab. Then you can do a search for the accounts to merge. This search is quite simple if you know that the accounts all start with Acme as you can just search for Acme*. But how do you search for Acme Business Management Software, ABMS, and Business Management Software by Acme?

The only way to bring accounts into the merge tool that have different names that cannot be found in a single search is to rename the accounts. Find your second, third, and other (you can only merge three accounts at a time) accounts and rename the duplicates so that they can all be found from a single search.

Once you have selected the accounts to merge, you will be presented with a page like the “Merge Leads” page where you can select the master record and any differing data. All records associated to the merged accounts will be added to the master account.

When merging duplicate accounts and/or contacts in the Salesforce CRM system, please keep in mind that it is a best practice to first merge the accounts as all the contacts will be associated to the merged account.

Once the accounts have been merged, then you can go to the contact related list to merge the contacts. Contacts can only be merged from the account they are associated with so by merging the accounts, all of the duplicate contacts will be associated to the merged account.

If you have duplicate contacts in an account in your Salesforce CRM system, select the “Merge Contacts” button in the contacts related list on the account detail page. You are then presented with a list of contacts where you can either search for specific contacts or view all of them. Once you have selected the contacts to merge (you can only merge up to three contacts at a time), you will be presented with a screen like the two above where you can select the master record and any differing data. All records associated to the merged contact will be associated to the resulting merged contact.

 

For leads, accounts, and contacts, there is some basic Salesforce automation available to make merging easier. But what happens if you have duplicate cases, opportunities, or custom object data? At this time, Salesforce does not have a tool to help with these objects so they will have to be merged manually. This is another reason to do a search before creating a record.

To merge records where there is not a merge tool in the Salesforce CRM system, first decide which record will be your master record. This should be the one with the most correct data and the most related records like activities or attachments.

Open each duplicate record in a new tab in your browser and copy any needed data from the duplicate into the master. Then copy the master record name or number and edit any related activities, attachments, or other records one at a time and paste the master record name or number into the “Related to” field. When you save, the record will be associated to your master record. Once all of the related data has been moved or associated to the master record, you can now delete the duplicate records. You may want to let the creator of the duplicate record know about it so they can be more careful in the future. You may also want to create some basic reports that you can run on a regular basis so that you can easily spot duplicates before they get out of hand.

Since duplicates can rarely be avoided completely in any customer relationship management software, I hope that these tips and steps will help you keep them under control in your Salesforce CRM system.

Download Our Free Guide With Salesforce Best Practices

Posted in Cloud Computing, Salesforce Best Practices, Salesforce Support, Salesforce.com

Contact Us

888-391-4493 x101

1261 Locust St. #135, Walnut Creek, CA 94596

info@starrdata.com

Salesforce Partner Since 2009
Pledge1_ProudMember_Smallest

Additional Resources

  • Technologies
  • Services
  • Client Portal
  • Contact Us
  • Privacy Policy
  • Sitemap

About Us

StarrData is a 5-star rated salesforce.com partner who helps companies increase sales and productivity by providing Salesforce implementation and support services. Since 2009 we have helped hundreds of organizations to leverage the power of Salesforce.

© 2020 StarrData. All Rights Reserved.

Our Spring Sale Has Started

You can see how this popup was set up in our step-by-step guide: https://wppopupmaker.com/guides/auto-opening-announcement-popups/

Our Spring Sale Has Started

You can see how this popup was set up in our step-by-step guide: https://wppopupmaker.com/guides/auto-opening-announcement-popups/

Contact Us Today

To speak with someone right away, give us a call at (510) 984-3648.

  • This field is for validation purposes and should be left unchanged.