Blog
Look for 4 common types of bad data in your CRM and take smart steps to help improve data quality.
Many data-driven organizations rely heavily on data stored, generated, and aggregated within their system of record: more often than not, that’s their customer relationship management (CRM) system. Whether we want to reach out to customers, convert an opportunity, or report on sales or marketing performance, we tend to use our CRM tools to collate all these insights to aid in our decision-making. After all, this is what CRM systems are built to do.
This coincides with Gartner’s definition of CRM as “a business strategy that optimizes revenue and profitability while promoting customer satisfaction and loyalty. CRM technologies enable strategy, and identify and manage customer relationships, in person or virtually. CRM software provides functionality to companies in four segments: sales, marketing, customer service, and digital commerce.”
Data is fundamental for CRM processes, especially when it comes to positively impacting business operations and goals, such as lead nurturing and customer retention. But just imagine running well-thought-out strategies that are based on incomplete data. Unreliable data puts decisions and future planning at risk. Essentially, bad data in your CRM assets can be the root cause of bad decisions.
There’s a misconception that the CRM is only to be thought of as a sales tool. Yes, it’s a powerful sales tool, but that’s only scratching at the surface of its value. The time has come for organizations to recognize that its use case goes far beyond sales and that it is a valuable tool when shared among the revenue team.
With that, we need to recognize that bad data in the CRM doesn’t merely mean that sales managers have to spend their valuable time hunting down a new phone number. Rather, bad data in the CRM means decisions that impact the entire organization are at risk.
When data quality issues penetrate your CRM, not only is user trust put at risk, but it may also have a negative impact on the effectiveness of your revenue operations (RevOps) initiatives — that’s a negative effect potentially across sales operations, marketing operations, customer success, and finance.
So, as data practitioners and data users, what should we consider “bad data,” and what are the possible causes?
Incomplete and missing data: Simply, this is when customer attributes are unknown or were left out of the customer record. When a contact record is missing the title value, for example, it’s difficult to do the segmentation that is critical for account-based marketing (ABM) outreach. Even more basic, the lack of identifying attributes such as business name, country, and telephone number makes the simplest outreach time-consuming. Incomplete data makes it difficult to nurture leads and can compromise RevOps efforts.
Stale data: Unlike food, stale data does not emit foul odors, but it may leave a bad taste in your users’ – or worse, your customers’ – mouths. Today’s organizational landscapes change quite frequently. Be it divestitures, M&As, or going out of business, you risk dampening your customer engagement strategies if you don’t keep up with these insights.
Incorrect data: Two probable scenarios contribute to this type of bad data in your CRM: first, stale data that doesn’t get refreshed; and second, inaccurate data entry. For the latter, data gathering can be challenging when no standards are in place for input data qualification. Even with the best intentions, mistakes can happen; even the most reliable ETL (extract, transform, load) processes could fail systematically as data is being processed.
Duplicate data: One can argue that there are scenarios where duplicate data needs to be created to meet internal and/or external policies, but duplicate data is generally considered harmful when its existing version serves no business purpose and reduces the effectiveness of the decision-making process. Unintentional duplicate data is likely to provide misleading results when it is aggregated without knowledge of its presence.
Don’t let your CRM and RevOps processes fall prey to bad data. If left unattended, the quality of data in your CRM systems can become less and less reliable, even with an influx of fresh data. Your “fresh” data, too, may become part of the problem in due time.
Here are four things you can do to get started on elevating the reliability of your CRM with good data-guiding principles.
1. Institute data standards: The compounding effects of unregulated freehand entry of crucial data can be debilitating to data analysis and integration projects. Lack of standardization makes it difficult to aggregate, group, and articulate data. Ironically, inconsistency can become the one consistent factor. Challenge your RevOps teams to go beyond the minimum acceptable data entry, like requiring a minimum number of characters for address data. The reward can be better habits and better data.
Provide users the error-preventing assistance of a type-ahead text function to help them auto-fill sections for faster and more accurate input. Couple this with a search-before-create capability accessing both internal and external referential data. This not only inherits the standards available from existing data/dictionaries but also helps empower users to input better and more accurate data. Follow up with KPIs to show how the data is improving quarter over quarter and year over year.
2. Develop data quality habits: Consistency and standards are key for a successful data practice, but these need to become regular habits to help strengthen data quality. Examine these two elements. Where are they in your processes? Habits can be adjusted, continued, enhanced, or stopped. They accomplish the actions on which data quality often relies. Standards can offer a baseline on the acceptability of the results of these actions.
3. Enrich and refresh: Data fundamentally describes transactions, people, places, things, events, other data, etc. As those attributes change, our data will also shift and change. This is why it’s so vital that we refresh our data and enrich it with additional insights. Acquiring new data is only one part of the solution. Keeping it as relevant as needed is the other half.
We know that data decays over time. Analysts and researchers don’t agree on the precise rate, but in general they believe that customer data can decay at a rate of 12-30% per year. Strategies for enriching and refreshing data on demand or periodically become more pertinent to organizations that depend on data for decision-making.
Before you enrich or refresh data, be sure you understand the readiness of your technology landscape. Are you able to handle API connectivity, or should it be batch refresh? How often do you need to refresh? Ensure that the business is included in the creation and implementation of these strategies, as the speed of the business will help dictate the initiative. As an example, D&B Connect® can help businesses to trust their CRM data with always-on data maintenance and management powered by the Dun & Bradstreet Data Cloud.
4. Establish an archive strategy: Because the cost of data storage plummeted in recent years, data can live longer than ever. However, this frequently comes at a price: the price of managing and accessing data. Old and immaterial data can easily pollute an environment like your CRM faster than you can spell D-A-T-A-S-W-A-M-P.
Provide context on what is material data and bake that into the policies on keeping data live in your CRM environment. As for the rest, archive it in a manner that allows you to reinstate it when needed. Then review the archiving policies periodically to ensure that your CRM data is meeting your business needs.
Your CRM environment is a socio-technological tool — it helps carry information about human behavior into its processes. The insights it delivers can be impacted by the habits you allow into the processes. Applying the guiding principles above can help provide the framework for curtailing bad behavior and elevating the level of your CRM’s success. As a result, it can help better your data quality and in turn the decisions you make based on that data.
Want to learn more about how powerful data and analytics can help optimize decisions about targeting, activating campaigns, progressing sales pipeline, and closing more deals?
The information provided in articles are suggestions only and based on best practices. Dun & Bradstreet is not liable for the outcome or results of specific programs or tactics undertaken based on your use of the information. Please contact an attorney or financial/tax professional if you are in need of legal or financial/tax advice.
There are multiple Contact Forms popups in the page. Only one Contact Form popup could be present on single page. Please reconfigure Contact Forms and refresh the page.