With the scope and amount of data in modern CRM systems, it's easy to ask for reports and get nice-looking dashboards, and get them in short order. Unfortunately, you could ask for lots of meaningless data on these dashboards, and subordinates aren't likely to say no to your requests. How do you avoid the trap of reports that practically beg the users to game the system?
Step 1: Don't ask users to rig the game
It's easy to ask for weekly indicators that sound meaningful, but aren't. For example, the number of leads produced each week. Leads are like Web site traffic: they are better indicators of visibility and vague interest than they are of a solid pipeline.
In another example, activity management indicators (such as "number of dials" or "customer support call volume") are very easy to get, but the numbers are rarely very meaningful. Artificial indicators of activity are easy to fake, and putting a financial reward on these indicators is like sending an engraved invitation to the rank and file to game the system.
Before you ask sales reps or customer support people to enter any new data items (which they'll view as a tax and an intrusion), walk a mile in their shoes. If you're just curious about an action, don't ask them to enter a bunch of new data so you can measure it in the CRM system.
Figure out what you would do differently if you already had that magic report in front of you. How often would you actually review it and understand the underlying business dynamics? How would that report relate to the things that you are measured on? Which decisions would you actually make differently?
While it's easy to ask for reports that you won't actually use, it's dangerous to ask for metrics and reports that you will use to bad effect. Metrics shouldn't be microscopic, because that leads to micromanagement and sub-optimization.
Measurements of a business process shouldn't focus on things outside the company's control, as that misdirects attention. Instead, focus metrics should on things that reflect the real health of your business. These are the kinds of CRM measurements that are meaningful, particularly when compared over time:
* Size of house database or online community
* Percentage of leads converted
* Number of leads accepted by sales
* Percentage of nonresponsive or stale leads
* Number of sales cycles started
* Average time in stage (or, alternatively, number of stalled deals)
* Percentage of wins, losses, and no-decisions
* Number of new customers
* Average deal size
* Percentage renewals/retained customers
* Forecast sales versus quarterly goal
* Actual bookings versus expected bookings by week
* Percentage of opportunities "moving backward"
* Number and dollar value of deals dropping out of the quarter
* Forecast accuracy
* Number and value of unforecasted deals
* Number of new problems identified vs solved by week
* Customer-perceived "time to resolve"
* Percentage satisfied customers
* Number of highly dissatisfied customers
* Cost of customer acquisition
* Percentage of revenue coming from repeat business
* Percentage of customer base that's still active/current
* Customer lifetime revenue
Join the CIO Australia group on LinkedIn. The group is open to CIOs, IT Directors, COOs, CTOs and senior IT managers.