ERP + CRM Solutions
INDUSTRIES WE SERVE
Digital Growth Strategies
Digital Operations Optimization
Digital Business Transformation
Special Technology Services
Korcomptenz - Total Transformation Blog - Salesforce: Preventing Data Corruption and Duplication
The value of data cannot be overstated in today’s world. Accurate data sets can be used to devise strategies, execute plans, track business performance, and make process improvements. Businesses that use CRM solutions such as Salesforce should have plans in place to ensure that their valuable data is not corrupted or duplicated.
Data corruption can occur due to a problem in a company’s process or Salesforce settings, or even through no fault of their own. For example, on May 10, 2016, a major Salesforce outage resulted in a large portion of data being corrupted. This blog will help you prevent the losses and duplications that you can control—and potentially correct with some settings or additional apps in Salesforce.
While there are a practically unlimited causes for data corruption and deduplication, the most common issues occur on data entry into the Salesforce platform. Salesforce uses certain pieces of data to identify whether a user added to the system should be considered “new,” meaning not currently present in the system. These data points can be controlled in Salesforce, but they generally include some combination of email address, first name, and last name. A duplicate record is entered if Salesforce cannot match the new entry with an existing lead, contact or account.
This can occur when:
The same issues can occur during a data import. The end result are duplicate records in the system, and incorrect reporting on your results. The situation is compounded the longer the duplicate or inaccurate record lives in the system: Future touchpoints, proposals, presentations, cases, etc. get appended to one of the duplicate records, but not the other. Repeat the process and it’s not long before you have two or more records that contain a partial record of the customer.
As human mistakes are inevitable, the question becomes how best to identify and remove the issues on an ongoing basis, catching duplicates before the data attached to them gets messy.
Salesforce provides two main tools to prevent duplications and potential corruption in your data. These tools are available in both Lightning and Classic versions.
In addition to the tools offered by Salesforce, there are a variety of third-party apps that can be used to deduplicate data. These apps either run outside of Salesforce or within the platform. For example, Duplicate Check is a popular option. This app is an all-in-one solution that allows organizations to identify, manage, and merge duplicate records. One of the advantages of most third-party apps is that you can merge duplicates across different entry types, such as leads, accounts, and contacts. These apps are generally more flexible and offer more controls than the default Salesforce features.
For more information on preventing data corruption and whether you can use the standard Salesforce tools or require a third party app, please contact us.
Korcomptenz is a Salesforce Registered Consulting Partner. We've been in business for almost 17 years and can get you started on Salesforce by procuring the software, implementing and customizing the platform, importing and integrating your data, and providing full service support. Our seasoned teams of strategic thinkers also help map out your business processes and implement them in Salesforce, all at very cost-effective price points.