Good Data: How to Avoid Duplicate Data

//Good Data: How to Avoid Duplicate Data

Good Data: How to Avoid Duplicate Data

In my first post of the Good CRM Data series, Clean CRM Data: Planning Your Data Model, I focused on the planning portion of building your data treasure chest. With an understanding of the relational data model and a customer relationship management system (CRM) selected, you are now ready to begin populating data.

You will quickly realize that with so many sources of data to choose from, you can quickly become overwhelmed.  Where do you find the time to enter your data? How do you avoid duplicating data in your CRM? Do you enter data manually or buy a list?  Great questions. For now let’s assume you are entering data manually and using your current team.  I plan to cover the topic of data providers in the next article of this series, so stay tuned.

Let’s assume you have a team of five and each member is going to enter 25 companies and 25 people. Right away, you are off to a good start… until you realize that each of your five teammates has some of the same data as you do!?!  And in fact, everyone did their part by entering in John Smith and Acme Widgets – four times.  You went from a great start to “..our data stinks…” in just a matter of minutes. Bad data is the nemesis of every organization, but there are ways to avoid the problem.

The following tips will  help you avoid duplicating data in your CRM:

  1. First and foremost: Identify a good method for uniquely identifying a company or person.  This is commonly referred to as a globally unique identifier or GUID in the data world.  Your first reaction may be name or telephone number.  Though it makes sense at first, you will soon learn there are a lot of John Smiths out there and Acme Widgets uses the same telephone number for everyone. How about address?  Good…but a company may have many addresses or perhaps they have moved.  Early on, I thought limiting my data intake to one data provider and using their ID would work.  It does at first, but as soon as you want to try another firm, your plan is foiled.Then I realized there are two very good unique IDs that could be used for every data vendor.  For companies, domain address is perfect.  Even if a company has multiple domains, they are always directly associated with the company.  It would be very rare – if ever – that a company would share a domain with another company. Formatted the same way, domains are a terrific unique ID for companies.So how about people?  In keeping the same thought process, email addresses are a great unique ID.  Sure people can have many, but rarely is a personal email shared with two people.  Make those pieces of data required when entering records and you are on your way to building a good clean database.Now that you have the unique identifiers, how do I keep from having duplicates?
  2. Avoid duplicating unique identifiers by checking rules in your CRM.  If your CRM does not have a duplication checking rule, FIND A NEW CRM!  You will work far too hard and too long to build a good database only to have it destroyed by duplicates.  Most CRMs will prompt the user about potential issues during the entry process provided you have established the criteria.  Be sure your formatting is consistent to avoid misses.  Duplication checking should be one of the first must haves on your CRM selection list.Recognize that in building a good database, you will have duplicates.  Like I mentioned Seeking Good Data: Planning Your Data Model, the process is not perfect.  Using unique identifiers will however help to keep the duplicates to a minimum.  Stay tuned for the new post in the this series where I plan to talk about data sources and the question of manual entry versus buying lists.  Until next time, happy selling!

Interested in assistance setting up your data model or just want to learn more.  Just click the link below to find out more.

By |2017-12-05T21:08:58+00:00March 10th, 2017|Categories: Sales & Marketing Technology|0 Comments

About the Author:

I am a seasoned business process engineer who has spent my career providing architectural and executional guidance to companies wanting to streamline their customer lifecycle and operational productivity. With experience in both large corporations and small entrepreneurial companies, I pride myself in being able to quickly identify the road blocks that keep organizations from reaching their full potential and then implementing solutions that remove those roadblocks. I have been fortunate to have been exposed deeply to the operational workings of many industries. The ability to quickly understand the go-to-market and delivery strategy in different industries has allowed me to achieve much success in that role. My expertise in operational elements from pre-sale to post-sale activities makes me fairly unique and allows me to create complete solutions that solve all challenges in the customer lifecycle. Where I derive the most joy and fulfillment in my career is simply making a positive impact on the organizations I work with, regardless of whether I am there for an hour or several years.

Leave A Comment

This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.