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.
Page:

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.

Page:

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

Post new comment

The content of this field is kept private and will not be shown publicly.
Users posting comments agree to the CIO comments policy.
Login or register to link comments to your user profile, or you may also post a comment without being logged in.
Related Coverage
Related Whitepapers
Latest Stories
Community Comments
Tags: CRM, data quality
Latest Blog Posts
Whitepapers
  • Ten ways to save money with IBM Tivoli Storage Manager
    According to a recent report by Gartner, “By 2014, at least 30% of organizations will have changed backup vendors due to frustration over cost, complexity and/or capability. ”However, replacing a backup infrastructure can be a painful and disruptive process. The best replacement solution will beone that not only addresses these issues, but also demonstrates significant cost savings, enables a rapid return on investment and ensures a seamless transition.This white paper describes 10 ways that IBM® Tivoli® Storage Manager solutions can help organizations save money while addressing their data storage challenges, including those associated with exponential data growth.
    Learn more »
  • New Mobility Requires a New Network Strategy
    Computing has gone through several major transitions through the ages, each of which raised the value of the network and dramatically lowered the cost of computing. In the years after its birth in the mainframe era, the computing industry shifted to client/server and then Internet computing. Today, we are beginning yet another major computing revolution: the shift to mobile computing. This revolution already allows us to carry mini computers, called “smartphones,” in our pockets. This shift will drive down the cost of computing even further and drive up the value of the network, forever changing its role in organisations. Read on.
    Learn more »
  • 2-Layer BPM: Oracle's Unique Strategy Towards Exceptional Agility and Business Process Efficiencies
    Today, a new approach to BPM — the use of BPM and SOA together in a layering strategy — offers built-in smartness and high configurability. This dynamic approach to business process management is based on context and content. It offers agility throughout an organization, and it can dramatically increase productivity and time-to-market.
    Learn more »
All whitepapers
rhs_login_lockGet exclusive access to Invitation only events CIO, reports & analysis.
Recent comments

HP and IDG news, product videos and resources