What price CRM data quality?
- 21 July, 2009 04:13
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.
Why change management doesn’t work
Larry Page wants to see your medical records
Dual-Persona Smartphones Not a BYOD Panacea
After two-year hiatus, EFF accepts bitcoin donations again
CIOs struggle to deliver timely mobile business apps: survey
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.
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.
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.