Critical.
Authoritative.
Strategic.
Subscribe to CIO Magazine »

What price CRM data quality?

In a CRM system, some data has to be perfect, such as unique keys, internal security information and order quotes. But other data can be an approximation, or missing altogether. Here's how to decide where to make your data quality investment.

In an accounting or ERP system, most of the data must be right, period. If invoices, accounts receivable, inventories, work-in-process numbers, ECAD files are "best guesses," someone will lose their job and the CIO will be on the hot seat.

In this column, I've had many quotable quotes about the need for data quality in SFA and CRM systems. And here's another one: perfectionism doesn't pay. It's so important, it's trademarked.

CRM Data is Different

In a CRM system, there's a range of allowable (and even expected) data quality that depends on the specific data element. Some things do have to be perfect, such as unique keys, internal security information, order quotes, order history, and anything that's subject to an audit (such as PCI, HIPAA, FERPA, or other compliance standards). But other things can be just an approximation or can be missing altogether. Is it essential that the customer's customer service calling history from last year be perfectly represented in your CRM system? Not likely. So how do you decide where to make your data quality investment?

How to Do Data Triage

The first step is to have an analyst pull out the CRM data dictionary (or, more likely, create one) and separate the data elements into three categories:

(1) the ones that must be there and must be correct to prevent corruption in external systems or misrepresentation of the business,

(2) the ones that should be correct for the CRM system to work at all, and

(3) the ones that people have asked for to make marketing, sales, and customer support work better.

The fun part comes in the next step. Do a quick data quality analysis on each data element in the three categories. Score the data quality by answering questions such as:

o Does this data element have an undisputed owner? Is it updated by a team member as a natural step in a key business process? Or can nearly anyone update it at any time?

o Does this data element have internal validation to prevent noisy input? Does it have an audit trail to support troubleshooting?

o What percentage of the CRM records has this data element missing, clearly incorrect, or duplicate?

Based on the resulting score, the analyst may want to reassign the triage category for some of the data elements.

Join the CIO Australia group on LinkedIn. The group is open to CIOs, IT Directors, COOs, CTOs and senior IT managers.

More about: Amazon, Amazon.com, IRS, IRS, Salesforce.com, Sigma
References show all
Comments are now closed.
Related Coverage
Related Whitepapers
Latest Stories
Community Comments
Tags: data quality, crm
Latest Blog Posts
Whitepapers
  • ESG Whitepaper: Integrated Computing Platform Survey
    Data centres, servers, storage and more are being combined for simplified management and cost savings. In this survey, ESG looks at the current and future trends surrounding today’s integrated computing solutions. Download to find out how organisations are more likely to see commit IT budgets to the purchase of integrated solutions. Read more.
    Learn more »
  • Protecting Your Data, Intellectual Property, and Brand from Cyber Attacks
    Enterprises and government agencies are under virtually constant attack today. It is clear that the cybercriminals, nation-states, and hacker activists waging these attacks are growing increasingly sophisticated and more effective in their efforts to steal and sabotage. Why are today’s security defenses failing? In this battle, your security teams are using outdated arsenal - download now to learn more.
    Learn more »
  • In Control at Layer 2: A Tectonic Shift in Network Security
    Network hacking and corporate espionage are on the rise and set to intensify. Information security risks remain commonplace, and most organisations need to increase vigilance. This paper has analyses the realistic threats to fibre optic Ethernet networks – both at the LAN and WAN level. Read now.
    Learn more »
All whitepapers
rhs_login_lockGet exclusive access to Invitation only events CIO, reports & analysis.
Recent comments

Computerworld
ARN
CFO World
CMO