Portals eNewsletters Web Seminars dataWarehouse.com DM Review Magazine
DM Review | Covering Business Intelligence, Integration & Analytics
   Covering Business Intelligence, Integration & Analytics Advanced Search

View all Portals

Scheduled Events

White Paper Library
Research Papers

View Job Listings
Post a job


DM Review Home
Current Magazine Issue
Magazine Archives
Online Columnists
Ask the Experts
Industry News
Search DM Review

Buyer's Guide
Industry Events Calendar
Monthly Product Guides
Software Demo Lab
Vendor Listings

About Us
Press Releases
Advertising/Media Kit
Magazine Subscriptions
Editorial Calendar
Contact Us
Customer Service

Marketing Systems:
Customer Value Dashboard

  Column published in DMReview.com
January 1, 2006
  By David M. Raab

Customer value models are powerful tools to improve business strategy, tactics and reporting, but they need a lot of input data, which is not always fully available. Some people object to the models for this reason. Their concern is that incomplete data will yield inaccurate results, leading to worse decisions than no model at all.

There are ways to overcome data limits. One is to model only areas where detailed data is available. For example, log files can capture a precise history of a customer's behavior on the Web. Marketers may build a customer value model to help with Web-related decisions even if non-Web behavior is modeled in much less detail.

Another option is to use aggregate values. A model might apply the same average payment rate to all customer segments when actual rates by segment are not known. Sensitivity analyses can determine whether variations across segments would really make a difference in relevant outputs. If so, special studies can sometimes discover the actual values when these are not available from regular reporting systems. Even without such studies, managers can estimate the different segment values and use simple math to ensure that the weighted average of the estimates matches the value of the actual average itself.

One more approach is simply to model with less detail. Again, sensitivity analysis can determine whether working with a simpler model affects the utility of these results.

Which, if any, of these approaches makes sense will depend on the situation. Often a useful model can be built using the available data. Sometimes it cannot.

But even when a true customer value model is not possible, customer value metrics can still be used. Such metrics present the inputs to a customer value model for users to evaluate directly. Although they do not provide the long-term value projections of an actual model, they can still give important insights into business performance and trends.

These metrics are based on the fundamental customer value equation: customer value is equal to acquisition value plus future value. Acquisition value is the net cost to acquire new customers. It includes prospecting costs less any revenues from the initial acquisition transactions. Future value is customer value per period multiplied by the average number of periods in a customer lifetime. Value per period is the net of customer revenues less costs. Periods per lifetime is derived from retention rates.

Standard accounting systems do not measure customer value directly. Yet nearly all can link transactions to customers and transaction dates. This means they can determine which customers purchased during current and previous time periods. (It doesn't matter whether these periods are days, weeks, months or years. Nor must the previous and current period be the same length. In some cases, it may make sense for the previous period to include activity over the past year, while the current period looks only at the current month.) Once customers have been classified this way, they fall into four categories:

  • Purchased in both periods (active customers),
  • Purchased in neither period (inactive customers),
  • Purchased in this period but not last period (new customers), and
  • Purchased last period but not this period (lost customers).

These can be displayed neatly in a two-dimensional matrix as shown in Figure 1.

Figure 1: Customer Classification Matrix

All the inputs for a simple customer value model can be derived from these values.

  • Acquisition value per customer is the costs and revenues of new customer transactions divided by the number of new customers. The costs include all prospecting expenses associated with the transactions, including costs to contact other individuals (that is, non-responders). Although a precise analysis might address some subtle issues of response attribution and cost allocation, simply charging all current-period prospecting costs to current-period new customers is usually adequate.
  • Customer value per period is the costs and revenues of active customer transactions divided by the number of active customers. As with acquisition costs, there are some general accounting issues to address, such as allocation of overheads. The "correct" answer will vary depending on the particular analysis. But, again, simply including all period costs will probably serve in most cases.
  • Periods per active customer is calculated by extending the retention rate for however many periods makes sense. Anything from three to 10 years may be reasonable, depending on the business. The retention rate itself is calculated as the number of customers who purchased in both periods (actives) divided by the number who purchased last period (actives plus lost).

The specific customer value figure that results from this calculation can be intriguing, but it has little practical use. The real value comes from examining the input figures themselves; how they change over time, in particular. The matrix described in Figure 1 can be interpreted as illustrating stages in a customer life cycle: from new through active to lost to inactive and possibly new again. Viewed over successive time periods, the values in each cell illustrate this flow.

From this perspective, changes in relative values indicate whether a company is growing or shrinking its customer base and whether retention rates are improving or getting worse. Changes in financial values show whether revenue is growing by adding new customers or expanding relationships with existing ones. Comparing past period financial values of lost customers with current values for actives give some insight into the quality of customers being lost. A complete set of relevant metrics is illustrated in Figure 2:

Figure 2: Relevant Metrics

Because period-to-period changes are so important, a matrix is less effective at presenting the data than a columnar format showing several periods simultaneously. This is similar to any traditional report comparing current and past results (see Figure 3).

Figure 3: Report Comparing Current and Past Results

A natural extension, also common to such reports, is to calculate differences between one period and the next. Exception reporting can then highlight changes that might need closer examination. Add some attractive graphics and you have the basis for a customer value dashboard (see Figure 4).

Figure 4: Report Calculating Differences Between Periods

In the hands of an insightful reader, such reports are a powerful tool for understanding the business. Drill downs to finer detail add even more value. These might present the same metrics for subsets such as specific products or customer segments. Or they might break the aggregate metrics down into components such as different categories of costs.

These refinements are common to many types of reports. What's important is not such details, but basing the report on customer value metrics. This incorporates the customer value perspective into corporate reporting even when customer value modeling itself is not a practical option.


For more information on related topics visit the following related portals...
Database Marketing, Market Segmentation and Scorecards and Dashboards.

David M. Raab is President of Client X Client, a consulting and software firm specializing in customer value management.  He may be reached at info@raabassociates.com.

Solutions Marketplace
Provided by IndustryBrains

TechExcel CRM
TechExcel CRM sets the standard for high-end CRM: powerful, configurable, affordable and easy to use.

Download trial Sales Anywhere for Salesforce.com
Anywhere, anytime access to salesforce.com on your device?with or without wireless connection. Download 30-day trial and in minutes have Sales Anywhere for salesforce.com on your device. This download is for U.S. salesforce.com customers/trial users.

TechExcel HelpDesk Software Suite
With both Windows and Web user interfaces, TechExcel HelpDesk provides powerful solutions for help desk, Web forms, asset management, and customer/employee Web portal functions.

Find CRM Consultants
Post You Project for Free. Get Bids from Thousands of Pre-Screened Consultants.

Strategic CRM Analytics White Paper
This white paper explores how companies can extend their CRM applications by using BI tools to turn CRM data into actionable information to drive strategic decision-making and improve ROI.

Click here to advertise in this space

E-mail This Column E-Mail This Column
Printer Friendly Version Printer-Friendly Version
Related Content Related Content
Request Reprints Request Reprints
Site Map Terms of Use Privacy Policy
SourceMedia (c) 2006 DM Review and SourceMedia, Inc. All rights reserved.
SourceMedia is an Investcorp company.
Use, duplication, or sale of this service, or data contained herein, is strictly prohibited.