The 6 Pillars of CRM Data Quality
The 6 Pillars of CRM Data Quality
Ensure high-value CRM data
What is CRM data quality?
Too often, when people talk about data quality, they’re really just talking about data integrity, or more specifically, data accuracy.
But data quality is more than just data integrity.
CRM data quality refers to how valuable the information you track in CRM actually is. After all, if you’re going to the trouble of entering it in the first place, your data needs to be high-value.
Of course, data integrity is a really, really big part of data quality. In fact, many of the guidelines I’m about to give you are related to data integrity.
What’s more, bad data can destroy user confidence in your CRM, driving your team to spreadsheets, Post-It notes, or other decentralized, makeshift systems for “better” record keeping.
So in order to ensure your CRM data quality is the best it can be, we recommend you follow these six guidelines:
Is your information both correct and precise? It needs to be, or you team has no reason to trust it.
And once that trust is gone, all your information in CRM is suspect, and you may not be able to convince your team to use the system even if you make improvements later on.
To ensure your information is accurate, it’s important to create processes for verifying, entering, and updating CRM data right from the start. This can help you avoid the nightmare scenario of a database full of inaccuracies.
Do you have all the information you need for each of your records?
Incomplete data isn’t uncommon, especially while prospecting or after accounts move or make organizational changes.
But chronically incomplete data can be a huge problem.
A consultant friend of mine recently performed a database audit for an organization and found that roughly 25% of their records didn’t include mailing addresses. That’s not necessarily the end of the world, but the problem was that this organization routinely mailed letters and brochures to their entire list of contacts!
And to make matters worse, those mailings were automated, meaning they were printing and paying postage for thousands of pages that simply could not be delivered. They were almost literally throwing money away.
It is critical that you identify what information is important for what actions, and develop processes for getting the information your team needs to do their jobs.
Is similar information presented in similar ways across your system?
For example, do all your email addresses and phone numbers look the same? Are customer and opportunity ratings presented on a consistent scale? Is your information entered in the correct fields?
We humans are incredibly good at spotting and acclimating to patterns in our information, and that’s what uniform data presentation is all about. Uniform data creates organizational and informational rules that help your team process and use the information in your CRM. But when your data isn’t uniform, it can be annoying, confusing, or even unusable for your team.
I recently saw a database with a 5-tier visual rating system for relationship quality. Basically, the owners of the system wanted to know at a glance how good their customer relationships were. The problem was, there were 3 faces (smiley, frowney, and indifferent), and two hand gestures (thumbs-up and A-ok), and since there were also letter grades, I could clearly see that the emojis weren’t even being used consistently.
It was not at all intuitive, and we recommended switching to a simpler set of color-coded faces instead.
Is your CRM full of duplicate data?
I recently spoke to another consultant who had just finished a database audit for an organization that had about 120,000 individual records, and nearly 70,000 of those records were duplicates. 70,000!
If you don’t have processes in place to combine and delete duplicate records, or better yet to avoid creating them in the first place, then it can be extremely difficult for users to find the information they need.
At the same time, if you delete duplicates indiscriminately, you can end up with incomplete records if the information you need was spread across multiple duplicate records.
And if you let bad processes continue for too many years, you may have a major project on your hands just to consolidate and clear out all your duplicate records!
Is your information up to date?
We recently reviewed a small list of about 800 contacts, and nearly a third of them either didn’t exist anymore or had dramatically changed since they were entered into the database.
It’s a good idea to regularly organize and clean your CRM data to ensure it’s accurate, unique, and timely.
It’s also a good idea to check for outdated information when you perform bulk data imports, like the list we reviewed.
Basically, timely data is about making sure the information in your CRM is actionable. After all, if you can’t do anything with the information you’re tracking, then what’s the point of tracking it in the first place?
Is your information secure?
CRM security is about ensuring the right people have the right access and privileges within your database.
And as much as some of your users might hate to hear this, the general rule here is to give each user the access they need to do their jobs and nothing more.
Too much access and too many privileges to too many users can create a free-for-all database; too few can make it hard for people to do their jobs.
But it tends to be easier early on to err on the side of caution and add privileges as needed. Trust me on this one: we’ve seen way too many databases ruined by too many cooks in the kitchen.
Is your CRM data quality where it needs to be?
Find out with a FREE data quality consultation from one of our highly-experienced CRM consultants!
Our team will offer you insights into where and how you can improve your CRM data quality to give your sales, service, marketing, and management teams high-value insights that will boost their performance and your organization’s profitability!
What does the new Unified Interface mean for you?
Assign or change security roles in 6 simple steps
Introducing Boosters for Microsoft Dynamics 365 and Sage CRM!
No time to burn.
Founder and president Peter Wolf to speak on thriving in the customer experience economy.
Never fail to follow up!
Reschedule your Dynamics 365 upgrade.
Create an optimal experience for CRM users!
David Marincic is Partner Experience Manager at Azamba. He also manages and edits Azamba publications and social media channels.
David believes in the importance of good planning, sound practice, effective communication, and continued education in order to get the most from any technology solution.