Guide to the TechWeb Network

Intelligent Enterprise

Better Insight for Business Decisions

Intelligent Enterprise - Better Insight for Business Decisions
search Intelligent Enterprise
Advanced Search
RSS
Webcasts
Whitepapers
Subscribe
Home




March 20, 2003

The Money Shift

Customer relationship management requires a radically new approach to financial analysis

by Thomas F. Richebacher

Continued from Page 1

Activity-based CRM forecasting models are appropriate for companies needing to continuously resell their merchandise. Catalogers fall into that category, when they decide to sell new products to existing customers they must first send another catalog. One characteristic of these companies is that the probability of additional customer orders, and accordingly the value of their customer base, strongly correlates to how frequently and recently a customer has made purchases. Therefore, a customer forecasting model that EDS builds for a cataloger projects financial results based on expected marketing activities, customer order frequency, and months since last purchase.

In contrast, companies that use continuity-based models either sell a continuous service (such as phone or utilities) or products delivered periodically (such as books, records, or perishables) in return for regular customer payments. They differ from activity-based companies in that their goal is not to get the next sale (their customers have already signed up for the service), but to keep customers in the service. In fact, it often doesn't make sense for service providers to sell more of a product to customers already enrolled in the service because of limits to how much can be consumed in a given time period. Accordingly, the forecasting model is based primarily on consumption and customer segmentation patterns in relation to time factors.

Therefore, before building the data warehouse, your company needs to decide how it wants to evolve its product-focused forecasting and budgeting system toward customer-based ones. Being proactive is important because while existing systems provide some of the data, the rest of it must be created from scratch.

Central to this transformation is the identification of relevant customer segments, interrelationships among business units, and the critical elements that move customers through their life cycles. With that information in place, the financial impact of customer activities is exposed, enabling a company to manage its customer base like an investment portfolio through the discovery of its own unique equilibrium between the need to acquire new customers and keep existing ones.

CRM performance management. As with all change initiatives, successful CRM implementations require that financial and operational goals, as well as the metrics to evaluate them, are clearly defined at the onset. Finance will find this task to be a challenge for the same reason that calculating customer profitability and creating customer forecasting models are difficult. The product structure of its systems makes it easy to evaluate whether sales or margin targets by product are being met, but nearly impossible to measure progress toward a goal such as customer retention (let alone understand its financial implications).

The challenge isn't just the absence of the appropriate data, but the ambiguity of CRM goals, which are often expressed in nonfinancial terms. For example, as pointed out earlier, retailers and catalogers often measure retention by time elapsed since last customer purchase. Conversely, utility and phone companies measure retention by how many customers remain without interruption in a service, and magazine publishers count the number of times customers renew their subscriptions.

Thus, the first step for finance is to establish a common enterprisewide definition. After all, from the perspective of establishing CRM goals, the value of a single customer view is not only its ability to measure the potential financial impact of a CRM strategy, but also to encourage cooperation and coordination.

The next step is to split the goal into subcomponents, a process practically identical to the one used for conventional goals. For example, a bank may want to increase its retention of checking account holders from 40 to 60 percent over a three-year period. Management wants to know, prior to that time passing, the financial impact of this goal and how to measure progress toward the target. Thus, finance needs to break the cumulative goal into smaller parts to be measured in regular intervals. Now management can be notified of unexpected developments before the three years elapse, the different means of achieving the goal become visible, and costs that truly reflect a specific stage in the goal development process can be assigned.

Best Foot Forward

Customer financial analysis capabilities are a critical element of every CRM implementation. There are pitfalls, however:

  • Because no map to success exists, finance has to assume a pioneering role in the process. It needs to explore new dimensions — detecting shifts instead of only "lifts."
  • Finance can easily fall into the trap of spending too much time reconciling data from different sources to obtain the same reliability as accounting systems. This goal is rarely accomplished; customer data combined from different business units having their own separate Charts of Accounts and customer IDs can't be reconciled back to the original system after being loaded in the CRM data warehouse.
  • Accountants like to match revenue and costs based on the accrual method, which recognizes revenue when it's earned. This approach makes sense in a retail situation, but in others, it doesn't. For example, if a customer pays in advance for a one-year magazine subscription, accrual accounting recognizes earnings over the whole year as the customer receives the magazine. But in a CRM environment, when creating a lifetime value analysis, the actual cash flow is evaluated.
  • Managing the amount and detail of data amassed in a CRM system is a big challenge. Knowledge of spreadsheet analysis alone isn't enough; analysts have to be comfortable using databases, be familiar with data structures, and understand programming basics.
  • The meaning of accountability has to be re-thought. Current accounting systems are designed to hold individual managers accountable for their actions, not to encourage coordination and knowledge sharing.
  • CRM software isn't a solution. Software doesn't make a company smarter or more customer-friendly; it simply allows a company to do whatever it wants faster, for better or worse.



Rate This Article

Comments:

Optional e-mail address:

To avoid these pitfalls, you must involve finance during the early CRM planning stages. As the guardian of company assets, that function can help maintain fiscal discipline by ensuring that a CRM undertaking is justified. Finance also provides a unique and important perspective on IT systems — relevance, reliability, timeliness, and accuracy are traditional accounting concepts that apply to all data, regardless of source.

Finally, take it slowly: Start out with small, attainable goals. That way, you can test the effectiveness of your vision as it develops and take corrective measures early.

Thomas F. Richebacher [thomas.richebacher@eds.com] is an analyst for the customer relationship management service line at EDS. He specializes in the development of customer intelligence through data analysis.


RESOURCES

Visit IntelligentCRM.com for focused content, news, and discussion about customer relationship management.

If business performance management is your interest, IntelligentBPM.com is the place to go for customized news, features, and analysis.

Thomas Richebacher's "The Model Customer" (Jan. 30, 2001) describes the value of direct marketing principles for clickstream analysis.









IE Weekly Newsletter
Subscribe to the newsletter
    Email Address







techweb
Online Communities TechWebInformationWeekLight ReadingIntelligent EnterprisebMightyNetwork ComputingDark ReadingDigital LibraryWall Street & Technology
Byte & SwitchNo JitterInternet EvolutionLight Reading's Cable Digital NewsContentinopleUnStrungBank Systems & TechnologyAdvanced TradingInsurance & Technology
Face-to-Face Events
InteropWeb 2.0 ExpoWeb 2.0 SummitVoiceConBlack HatCSISoftwareEntrprise 2.0 ConferenceGTEC
Mobile Business Expo
InformationWeek 500 ConferenceBuy Side Trading XchangeBuy Side Trading SummitBank Executive SummitInsurance Executive SummitTelcoTVEthernet ExpoOptical Expo
Magazines  
InformationWeekWall Street & TechnologyInsurance & TechnologyBank Systems & TechnologyAdvanced TradingMSDNTechNetSmart EnterpriseThe Architecture JournalDatabase Magazine
 
Research & Analyst Services  
Heavy ReadingInformationWeek ReportsInformationWeek Analytics