Conference PaperPDF Available

A Case for Analytical Customer Relationship Management

Authors:

Abstract and Figures

The Internet has emerged as a low cost, low latency and high bandwidth customer communication channel. Its interactive nature provides an organization the ability to enter into a close, personalized dialog with individual customers. The simultaneous maturation of data management technologies like data warehousing, and data mining, have created the ideal environment for making customer relationship management (CRM) a much more systematic effort than it has been in the past. In this paper we described how data analytics can be used to make various CRM functions like customer segmentation, communication targeting, retention, and loyalty much more effective. We briefly describe the key technologies needed to implement analytical CRM, and the organizational issues that must be carefully handled to make CRM a reality. Our goal is to illustrate problems that exist with current CRM efforts, and how using data analytics techniques can address them. Our hope is to get the data mining community interested in this important application domain.
Content may be subject to copyright.
M.-S. Chen, P.S. Yu, and B. Liu (Eds.): PAKDD 2002, LNAI 2336, pp. 14-27, 2002.
Springer-Verlag Berlin Heidelberg 2002
A Case for Analytical Customer Relationship
Management
Jaideep Srivastava1, Jau-Hwang Wang2, Ee-Peng Lim3, and San-Yih Hwang4
1Computer Science & Engineering
University of Minnesota, Minneapolis, MN 55455, USA
srivasta@cs.umn.edu
2Information Management
Central Police University, Taoyuan, ROC
jwang@sun4.cpu.edu.tw
3Chinese University of Hong Kong
Hong Kong, PRC
aseplim@ntu.edu.sg
4National Sun-Yat Sen University
Kaoshiung, ROC
syhwang@misserv.mis.nsysu.edu.tw
Abstract. The Internet has emerged as a low cost, low latency and high
bandwidth customer communication channel. Its interactive nature provides an
organization the ability to enter into a close, personalized dialog with individual
customers. The simultaneous maturation of data management technologies like
data warehousing, and data mining, have created the ideal environment for
making customer relationship management (CRM) a much more systematic
effort than it has been in the past. In this paper we described how data analytics
can be used to make various CRM functions like customer segmentation,
communication targeting, retention, and loyalty much more effective. We
briefly describe the key technologies needed to implement analytical CRM, and
the organizational issues that must be carefully handled to make CRM a reality.
Our goal is to illustrate problems that exist with current CRM efforts, and how
using data analytics techniques can address them. Our hope is to get the data
mining community interested in this important application domain.
1 Introduction
As bandwidth continues to grow, and newer information appliances become available,
marketing departments everywhere see this as an opportunity to get in closer touch
with potential customers. In addition, with organizations constantly developing more
cost-effective means of customer contact, the amount of customer solicitation has
been on a steady rise. Today, with Internet as the ultimate low latency, high
bandwidth, customer contact channel with practically zero cost, customer solicitation
has reached unprecedented levels.
Armed with such tools, every organization has ramped up its marketing effort,
and we are witnessing a barrage of solicitations targeted at the ever-shrinking
attention span of the same set of customers. Once we consider the fact that potentially
A Case for Analytical Customer Relationship Management 15
good customers, i.e. ‘those likely to buy a product’, are much more likely to get a
solicitation than those who are not so good, the situation for the good customers is
even more dire. This is really testing the patience of many customers, and thus we
have witnessed a spate of customers signing up to be on ‘no solicitation’ lists, to
avoid being bombarded with unwanted solicitations..
From the viewpoint of the organizations, the situation is no better. Even though
the cost of unit customer communication has dropped dramatically; the impact of unit
communication has dropped even faster. For example, after a lot of initial enthusiasm,
it is now widely accepted that the impact of web page banner advertisements in
affecting customer opinion is practically negligible. On the other hand, the impact of
targeted e-mails, especially with financial offers, is quite high. In essence, each
organization is spinning its wheels in tying to target the same set of good customers,
while paying insufficient attention to understanding the needs of the ‘not so good
customers’ of today, and converting them into good customers of tomorrow. A clear
example of this mutual cannibalism of customers is the cellular phone industry, where
each service provider is constantly trying to outdo the others. “Customer churn” is a
well-accepted problem in this industry.
A well-accepted wisdom in the industry is that it costs five to seven times as
much to acquire a new customer than to retain an existing one. The reason is that the
organization already has the loyalty of existing customers, and all that is required for
retention is to meet the customer’s expectations. For customer acquisition however,
the customer must be weaned away from another organization, which is a much
harder task. Given this, it is crucial that the selection of customers to target is done
with care, and the right message be sent to each one. Given these needs, it becomes
important for an organization to understand its customers well. Thus, one can consider
customer relationship management to consist of two parts as follows:
CRM = customer understanding + relationship management
This equation is not new, since in the classical ‘neighborhood store’ model of
doing business, the store had a highly localized audience, and the store owner knew
practically everyone in the neighborhood – making it easy for him to meet the needs
of his customers. It is the big corporations, serving a mass customer base, that have
difficulty in understanding the needs of individual customers. The realization of this
gap of knowledge has been one of the driving factors for the rapid adoption of CRM
software by many corporations. However, the initial deployment of CRM software
has been for the second part of the CRM equation, namely ‘relationship
management’. As described above, relationship management efforts without an
understanding of the customer can be marginally effective at best, and sometimes
even counter productive.
The approach that resolves this dilemma is the use of data analytics in CRM,
with the goal of obtaining a better understanding of the needs of individual customers.
Improved customer understanding drives better customer relationship efforts, which
leads to better and more frequent customer response; which in turn leads to more data
collection about the customer – from which a more refined customer understanding
can be gained. This positive feedback cycle – or ‘virtuous loop’ as it is often called –
is shown in Figure 1.
16 Jaideep Srivastava et al.
Figure 1. ‘Virtuous circle’ of CRM.
While this picture is very desirable, unfortunately there are a number of
technical and organizational challenges that must be overcome to achieve it. First,
much of customer data is collected for operational purposes, and is not organized for
ease of analysis. With the advance of data analysis techniques, it is becoming feasible
to exploit this data for business management, such as to find existing trends and
discover new opportunities. Second, it is critical that this knowledge cover all
channels and customer touch points - so that the information base is complete, and
delivers a holistic and integrated view of each customer. This includes customer
transactions, interactions, customer denials, service history, characteristics and
profiles, interactive survey data, click-stream/browsing behavior, references,
demographics, psychographics, and all available and useful data surrounding that
customer. This may also include data from outside the business as well, for example
from third party data providers such as Experian or Axciom. Third, organizational
thinking must be changed from the current focus on products to include both
customers and products, as illustrated in Figure 2. Successful adoption of CRM
requires a change in focus by marketing from “who I can sell this products to?” to
“what does this customer need?” It transforms marketing from ”tactical
considerations, i.e. “how do I get this campaign out of the door” to strategic focus, i.e.
“what campaigns will maximize customer value?”
Figure 2. Change of focus from product only to customer+product.
A Case for Analytical Customer Relationship Management 17
The goal of this paper is to introduce the data mining community to the data
analytics opportunities that exist in customer relationship management, especially in
the area of customer understanding. As the data collected about customers is
becoming more complete, the time is ripe for the application of sophisticated data
mining techniques towards better customer understanding. The rest of this paper is
organized as follows: in Section 2 we introduce the concept of analytical customer
relationship management. Section 3 briefly describes the underlying technologies and
tools that are needed, namely data warehousing and data mining. Section 4 describes a
number of organizational issues that are critical to successful deployment of CRM in
an organization, and Section 5 concludes the paper.
2 Analytical Customer Relationship Management
Significant resources have been spent on CRM, leading to the success of CRM
software vendors such as Seibel, Oracle, and Epiphany. However, in the initial stages
sufficient attention was not paid to analyzing customer data to target the CRM efforts.
Simple heuristics and ‘gut-feel’ approaches led to profitable customers being
bombarded with offers (often turning them off), while there being little attempt to
develop today’s the 'less valuable' customers into tomorrow’s valuable ones. This lack
of attention to customer needs is the cause of decreasing customer satisfaction across
a wide variety of industries, as illustrated in Figure 3 [Heyg2001].1
Figure 3. Declining trend in customer satisfaction index.
Fortunately, however, the tremendous advancement in data management and
analysis technologies is providing the opportunity to develop fine-grained customer
understanding on a mass scale, and use it to better manage the relationship with each
customer. It is this approach to developing customer understanding through data
analysis, for the purpose of more effective relationship management, that we call
analytical customer relationship management(ACRM)”. ACRM can make the
customer interaction functions of a company much more effective than they are
presently.
1 Of course, customer expectation keeps rising over time, and the source of
dissatisfaction today is very different that that of a few years ago. However, this is a
battle that all organizations must constantly fight.
18 Jaideep Srivastava et al.
2.1 Customer Segmentation
Customer segmentation is the division of the entire customer population into smaller
groups, called customer segments. The key idea is that each segment is fairly
homogeneous from a certain perspective – though not necessarily from other
perspectives. Thus, the customer base is first segmented by the value they represent to
an organization, and then by the needs they may have for specified products and
services.
The purpose of segmentation is to identify groups of customers with similar
needs and behavior patterns, so that they can be offered more tightly focused
products, services, and communications. Segments should be identifiable,
quantifiable, addressable, and of sufficient size to be worth addressing. For example, a
vision products company may segment the customer population into those whose
eyesight is perfect and those whose eyesight is not perfect. As far as the company is
concerned, everyone whose eyesight is not perfect falls in the same segment, i.e. of
potential customers, and hence they are all the same. This segment is certainly not
homogeneous from the perspective of a clothing manufacturer, who will perhaps
segment on attributes like gender and age.
A company’s customer data is organized into customer profiles. A customer’s
profile consists of three categories of data, namely (i) identity, (ii) characteristics, and
(iii) behavior. These categories correspond to the questions Who the person is?, What
attributes do they have?, and How do they behave? Two types of segmentation can be
performed based on the profile, namely
group customers based on common characteristics, and identify their common
patterns of behavior, and
group customers based on common patterns of behavior, and identify their
common characteristics.
Figure 4. Segmentation of customers by profitability.
As shown in Figure 4, each customer segment represents a different amount of
profit per customer; the treatment of each segment can be different. The figure shows
examples of the type of questions the company can ask about segments. Also included
A Case for Analytical Customer Relationship Management 19
are some overall strategic questions about which segments to focus on, and how
much.
2.2 Customer Communication
A key element of customer relationship management is communicating with the
customer. This consists of two components, namely (i) deciding what message to send
to each customer segment, and (ii) selecting the channel through which the message
must be sent. Message selection for each customer segment depends on the strategy
being followed for that segment, as shown in Figure 4. The selection of the
communication channel depends on a number of characteristics of each channel,
including cost, focus, attention, impact, etc.
Typical communication channels include television, radio, print media, direct
mail, and e-mail. Television is a broadcast channel, which is very good at sending a
common message to a very large population. While it is very effective in building
brand recognition, it is difficult to target a specific segment, as well as to measure
response at the individual customer level. Radio, like television is a broadcast
medium, and hence difficult to use for targeted communication to individual
customers. Some television and radio stations, e.g. public radio and public television,
develop a fairly accurate sample of their listener/viewer base through periodic
fundraisers. Print media like newspapers and magazines can be used for much more
focused communication, since the subscriber’s profile is known. However, the
readership of print media is usually much larger than the subscription base – a ratio of
1:3 in the US – and hence for a large part of the readership base, no profile is
available. Direct mail is a communication channel that enables communicating with
individual customers through personalized messages. In addition, it provides the
ability of measuring response rates of customers at the individual level, since it
enables the contacted customer to immediately respond to the message – if so desired.
Finally, given its negligible cost, e-mail is becoming the medium of choice for
customer contact for many organizations.
Figure 5. Formulating the optimal customer communication strategy.
Figure 5, courtesy of [Stev1998], illustrates the problem of formulating the
customer communication strategy. Each communication channel has its own
20 Jaideep Srivastava et al.
characteristics in terms of cost, response rate, attention, etc. The goal of
communication strategy optimization is to determine the (set of) communication
channel(s) for each customer that minimizes cost or maximizes sale, profit, etc. While
communication channel optimization has been a well-studied problem in the
quantitative marketing literature, characteristics of new channels such as e-mail and
the Web are not well understood. Thus, there is a need to revisit these problems.
Figure 6. Analyzing the response to customer communications.
Sending the message to each customer through the chosen communication
channel is not enough. It is crucial to measure the impact of the communication. This
is done by using an approach called response analysis. As shown in Figure 6,
response analysis metrics, e.g. number of respondents, acquired customers; number of
active customers, number of profitable customers, etc. can be calculated. These are
analyzed to (i) determine how effective the overall customer communication
campaign has been, (ii) validate the goodness of customer segmentation, and (iii)
calibrate and refine the models of the various communication channels used. While
response analysis for traditional communication channels is fairly well understood,
for new channels like e-mail and the Web, hardly anything is known. Understanding
how customers relate to these new medium, which aspects they like and which they
don’t, and what are the right set of metrics to measure the usage of the medium, are
all open questions.
2.3 Customer Retention
Customer retention is the effort carried out by a company to ensure that its customers
do not switch over to the competition’s products and services. A commonly accepted
wisdom, acquired through substantial experience, is that it is 5 to 7 times more
expensive to acquire a new customer than to retain an existing one. Given this, it is of
paramount importance to retain customers, especially highly profitable ones. A good
loyal customer base that persists for a long time is one of the best advertisements for a
business, creating an image of high quality. This helps in attracting other customers
who value long term relationships and high quality products and services.
A Case for Analytical Customer Relationship Management 21
Figure 7. Treatment of various customer segments.
Figure 7 shows how a company thinks of its various customer segments, from a
current and future profitability perspective. Clearly, the quadrants on the right bottom
and the right top should be targeted for retention. In addition, the right top customer
quadrant must be targeted for strengthening the relationship, as there is significant
unrealized potential.
A successful customer retention strategy for a company is to identify
opportunities to meet the needs of the customer in a timely manner. A specific
example is of a bank that used the event “ATM request for cash” is rejected due to
lack of funds” to offer unsecured personal loans to credit-worthy customers the next
day. This offer was found to have a very high success rate, with the additional
advantage of building customer loyalty. Classically, this analysis has been done at an
aggregate level, namely for customer segments. Given present day analytic tools, it
should be possible to do it at the level of individual customers.
2.4 Customer Loyalty
From a company’s perspective, a loyal customer is one who prefers the company’s
products and services to those of its competition. Loyalty can range from having a
mild preference all the way to being a strong advocate for the company. It is well
accepted in consumer marketing that an average customer who feels closer to a
company (high loyalty) is significantly more profitable than one who feels less close
(low loyalty). Thus, ideally a company would like all its customers to become loyal,
and then to quickly advance up the loyalty chain.
Figure 8, courtesy of [Heyg2001], illustrates the concept of tracking a customer
to identify events in his/her life. Many of these events offer opportunities for
strengthening the relationship the company has with this customer. For example,
sending a greeting card on a customer’s birthday is a valuable relationship building
action – with low cost and high effectiveness.
22 Jaideep Srivastava et al.
Figure 8. Lifetime impact of customer loyalty.
In marketing language this is called ‘event marketing’, where the idea is to use
the occurrence of events as marketing opportunities. Sometimes even negative events
can be used to drive sales. For example, a bank adopted the policy of offering a
personal loan to every customer whose check bounced or there were insufficient funds
for ATM withdrawal. This program was very successful, and also enhanced the
reputation of the bank as being really caring about its customers.
The data mining community has developed many techniques for event and episode
identification from sequential data. There is a great opportunity for applying those
techniques here, since recognizing a potential marketing event is the biggest problem
here.
3 Data Analytics Support for Analytical CRM
In this section we describe the backend support needed for analytical CRM.
Specifically, we first outline a generic architecture, and then focus on the two key
components, namely data warehousing and data mining.
3.1 Data Analytics Architecture
Figure 9 shows an example architecture needed to support the data analytics needs of
analytical CRM. The key components are the data warehouse and the data analysis
tools and processes.
3.2 Data Warehouse
Building a data warehouse is a key stepping stone in getting started with analytical
CRM. Data sources for the warehouse are often the operational systems, providing the
lowest level of data. Data sources are designed for operational use, not for decision
support, and the data reflect this fact. Multiple data sources are often from different
systems, running on a wide range of hardware, and much of this software is built in-
house or highly customized. This causes data from multiple sources to be
mismatched. It is important to clean warehouse data since critical CRM decisions will
be based on it. The three classes of data extraction tools commonly used are - data
migration which allows simple data transformation, data scrubbing which uses
domain-specific knowledge to scrub data, and data auditing which discovers rules and
relationships by scanning data and detects outliers.
A Case for Analytical Customer Relationship Management 23
Figure 9. Data analytics architecture.
Loading the warehouse includes some other processing tasks, such as checking
integrity constraints, sorting, summarizing, and build indexes, etc. Refreshing a
warehouse requires propagating updates on source data to the data stored in the
warehouse. The time and frequency to refresh a warehouse is determined by usage,
types of data source, etc. The ways to refresh the warehouse includes data shipping,
which uses triggers to update snapshot log table and propagate the updated data to the
warehouse, and transaction shipping, which ships the updates in the transaction log.
The key entities required for CRM include Customer, Product, Channel, etc.
Usually information about each of these is scattered across multiple operational
databases. In the warehouse these are consolidated into complete entities. For
example, the Customer entity in the warehouse provides a full picture of who a
customer is from the entire organization’s perspective, including all possible
interactions, as well as their histories. For smaller organizations the analysis may be
done directly on the warehouse, while for larger organizations separate data marts
may be created for various CRM functions like customer segmentation, customer
communication, customer retention, etc.
3.3 Data Mining
The next generation of analytic CRM requires companies to span the analytical
spectrum and focus more effort on looking forward. The 'what has happened' world of
report writers and the 'why has it happened' OLAP worlds are not sufficient. Time-to-
market pressures, combined with data explosion, are forcing many organizations to
struggle to stay competitive in the 'less time, more data' scenario. Coupled with the
need to be more proactive, organizations are focusing their analytical efforts to
determine what will happen, what they can do to make it happen, and ultimately to
automate the entire process. Data mining is now viewed today as an analytical
necessity. The primary focus of data mining is to discover knowledge, previously
unknown, predict future events and automate the analysis of very large data sets.
The data mining process consist of a number of steps. First the data collected
must be processed to make it mine-able. This requires a number of steps to clean the
24 Jaideep Srivastava et al.
data, handle mismatches in format, structure, as well as semantics, and normalization
and integration. A very good book on the subject is [Pyle99]. Once the data has been
cleaned up, various data mining algorithms can be applied to extract models from it.
A number of data mining techniques have been developed, and the one to be applied
depends on the specific purpose at hand. [HMS00] provides and excellent
introduction to various data mining algorithms, while [Rud00] shows how they can be
applied in the context of marketing.
Once a model has been developed, it can be used for two kinds of purposes.
First is to gain an understanding of the present behavior of the customers. A model
used for this purpose is called a descriptive model. Second is to use the model to make
predictions about future behavior of the customers. A model used for this purpose is
called a predictive model. The descriptive model, extracted from past behavior, is
used as a starting point from which a predictive model can be built. Such an approach
has been found to be quite successful, as is based on the assumption that past behavior
is a good predictor of the future behavior – with appropriate adjustments. This holds
quite well in practice.
4 Organizational Issues in Analytical CRM Adoption
While the promise of analytical CRM, both for cost reduction and revenue increase, is
significant, this cannot be achieved unless there is successful adoption of it within an
organization. In this section we describe some of the key organizational issues in
CRM adoption.
4.1 Customer First’ Orientation
Companies that offer a number of products and services have traditionally organized
their customer facing teams, e.g. sales, marketing, customer service, etc. along
product lines, called “Lines of Business (LOB)”. The goal of any such product
marketing team is to build the next product in this line; the goal of the sales team is to
identify the customers who would be likely to buy this product, etc. This product line
focus causes customer needs to be treated as secondary.
The customer focusing teams of an organization must be re-oriented to make
them focus on customers in addition to product lines. These teams can be organized
around well-defined customer segments, e.g. infants, children, teenagers, young
professionals, etc., and each given the charter of mapping our product design,
marketing, sales, and service strategies that are geared to satisfying the needs of their
customer segment. As part of this, some of the activities might be targeted to
individual customers.
4.2 Attention to Data Aspects of Analytical CRM
The most sophisticated analytical tool can be rendered ineffective if the appropriate
data is not available. To truly excel at CRM, an organization needs detailed
information about the needs, values, and wants of its customers. Leading
organizations gather data from many customer touch points and external sources, and
bring it together in a common, centralized repository; in a form that is available and
ready to be analyzed when needed. This helps ensure that the business has a
A Case for Analytical Customer Relationship Management 25
consistent and accurate picture of every customer; and can align its resources
according to the highest priorities. Given this observation, it is critical that sufficient
attention be paid to the data aspects of the CRM project, in addition to the software.
4.3 Organizational ‘Buy In
While data mining and data warehousing are very powerful technologies, with a
proven track record, there are also enough examples of failures when technology is
deployed without sufficient organizational ‘buy in’. As described earlier, the parts of
the organization that will benefit the most from analytical CRM are the business units,
i.e. marketing, sales, etc., and not the IT department. Thus, it is crucial to have ‘buy
in’ from the business units to ensure that the results will be used appropriately. A
number of steps must be taken to ensure this happens.
First, there needs to be a cross-functional team involved in implementing a
CRM project in the organization. While the technical members on the team play an
important role, an executive on the business side, who should also be the project
owner and sponsor, should head the team. Second, processes need to be adopted, with
an appropriate set of measurable metrics, to ensure that all steps for project success
are being taken. Finally, incentives for performing well on the project should be
included as part of the reward structure to ensure motivation.
4.4 Incremental Introduction of CRM
Introducing CRM into an organization must be managed carefully. Given its high
initial cost, and significant change on the organization’s processes, it is quite possible
that insufficient care in its introduction leads to high expense, seemingly small early
benefits, which can lead to low morale and excessive finger-pointing.
Figure 10. Incremental approach to CRM adoption
As shown in Figure 10, courtesy of [Fors2000], it is better to have an
incremental ‘pay-as-you-go’ approach rather than a ‘field-of-dreams’ approach. The
benefits accrued from the first stage become evident, and act as a catalyst for
accelerating the subsequent stages. This makes the choice of the first project and its
team very critical. Ideally, the project must be in a potentially high-impact area, where
the current process is very ineffective. The ideal (cross-functional) team should have
26 Jaideep Srivastava et al.
enthusiastic members, who are committed, and are also seen as leaders in their
respective parts of the organization. This will make the dissemination of the successes
much easier.
5 Conclusion
The Internet has emerged as a low cost, low latency and high bandwidth customer
communication channel. In addition, its interactive nature provides an organization
the ability to enter into a close, personalized dialog with its individual customers. The
simultaneous maturation of data management technologies like data warehousing, and
analysis technologies like data mining, have created the ideal environment for making
customer relationship management a much more systematic effort than it has been in
the past. While there has been a significant growth of software vendors providing
CRM software, and of using them, the focus so far has largely been on the
‘relationship management’ part of CRM rather than on the ‘customer understanding’
part. Thus, CRM functions such as e-mail based campaigns management; on-line ads,
etc. are being adopted quickly. However, ensuring that the right message is being
delivered to the right person, that multiple messages being delivered at different times
and through different channels are consistent, is still in a nascent stage. This is often
leading to a situation where the best customers are being over communicated to, while
insufficient attention is being paid to develop new ones into the best customers of the
future.
In this paper we have described how Analytical CRM can fill the gap. Specifically,
we described how data analytics can be used to make various CRM functions like
customer segmentation, communication targeting, retention, and loyalty much more
effective. Our hope is that the data mining community will address the analytics
problems in this important and interesting application domain.
6 References
[Cabe1998] Peter Cabena, Pablo Hadjinian, Rolf Stadler, Jaap Verhees, Alessandro Zanasi,
Discovering Data Mining: From Concept to Implementation, Prentice Hall, 1998.
[Fors1998] Richard Forsyth, “Customer Relationship Marketing Requirements Definition
Workshop,http://www.crm-forum.com/library/pre/pre-014/brandframe.html
[HMS00] Hand, David J., Heikki Mannila, Padhraic Smythe, “Principles of Data Mining” MIT
Press, 2000.
[Heyg2001] Richard Heygate, “How to Build Valuable Customer Relationships”,
http://www.crm-forum.com/library/sophron/sophron-022/brandframe.html
[Fors2000] Richard Forsyth, “Avoiding Post-Implementation Blues Managing the Skills”,
http://www.crm-forum.com/library/pre/pre-025/brandframe.html
[Pyle99] Pyle, Dorian, “Data Preparation for Data Mining”, Morgan Kaufmann Publishers,
1999, ISBN No. 1558605290
[Rud00] Rud, Olivia C., “Data Mining, Cookbook: Modeling Data for Marketing, Risk and
Customer Relationship Management”, John Wiley and Sons, 2000.
[Silvon] Silvon Software, “The Bottom Line of CRM: Know your Customer”,
http://www.crm2day.com/library/wp/wp0032.shtml
[Stev1998] Peter Stevens, “Analysis and Communication - Two Sides of the Same Coin”,
http://www.crm-forum.com/library/sophron/sophron-003/brandframe.html
A Case for Analytical Customer Relationship Management 27
[Stev1999] Peter Stevens, and John Hegarty, “CRM and Brand Management - do they fit
together?,http://www.crm-forum.com/library/sophron/sophron-002/brandframe.html
[Swif] Ronald S. Swift, “Analytical CRM Powers Profitable Relationships – Creating Success
by Letting Customers Guide You”, http://www.crm-forum.com/library/ncr/ncr-073/ncr-
073.html.
[Think] thinkAnalytics, “The Hidden World of Data Mining”, http://www.crm-
forum.com/library/ven/ven-051/ven-051.html
[Michigan] University of Michigan Business School Study, “American Customer Satisfaction
Index”, 2000.
... Shoemaker [8] diz que as interações entre clientes e transações em processo proporcionam uma riqueza de dados e informações que devem ser transformadas em conhecimento de clientes. Os [15], a "segmentação de clientes é a divisão da população total de clientes em grupos menores, denominados segmentos de clientes". Empresas precisam ser seletivas em correlacionar e integrar dados nos programas e esforços de marketing, através da realização de uma construção de informações apropriadas de clientes, desenvolvendo assim programas de marketing individuais [22]. ...
... Para Brown [12], Data Warehouse consiste em fator fundamental e permissivo à personalização e criação do ambiente de marketing one-to-one, através do qual é possível que a empresa aumente consideravelmente a satisfação dos clientes. Srivastava et al. [15] ...
... Minerar dados configura uma necessidade analítica [15]. Seu foco primário é voltado ao conhecimento inovador, anteriormente inexistente ou indisponível, utilizado com o intuito de predizer o futuro e automatizar a análise dos conjuntos de dados. ...
... Customer segmentation is based on various criteria. The study by Srivastava et al. (2002) points out that each customer segment brings different profit. Segmentation thus reveals key (significant) customers. ...
... "Event marketing" can also be used to promote loyalty. These actions can copy events in the life of the customer (Srivastava et al., 2002). For instance, this can be a birthday congratulation. ...
... A survey in 2010 showed that in Slovenia, CRM IS was not the most commonly used tool by management, however, and it was used only as the seventh most frequently used tool (Potočan et al., 2012). With the development of technology, new forms of CRM IS (e.g., e-CRM, m-CRM, s-CRM) have been developed that facilitate the collection of customer data with the widest possible perspective, with the creation of large-scale data warehousing and data mining as an important infrastructure of analytical customer relationship management as an information solution (aCRM IS) (Srivastava et al., 2002). When looking at the actual context of the economy, the analytical functions within the CRM IS (aCRM IS) become more important. ...
... 2 Literature review and hypothesis 2.1 Analytical tools of aCRM IS There are not many research results available regarding the in-depth use of an aCRM IS and the use of tools, techniques, and quantitative methods of an aCRM IS. On the other hand, the existing researches about the aCRM IS focus mainly on managing knowledge, on-line analytical mining, web mining, technologies, applications needed to implement aCRM IS Feng et al., 2005;Tuzhilin, 2012;Srivastava et al., 2002;Chen et al., 2012), business intelligence, and data mining techniques of CRM solutions (Ngai et al., 2009;Zeng et al., 2012;Olson, 2006;D'Haena et al., 2013;Ranjan and Bhatnagar, 2010;Huang et al., 2012Huang et al., , 2013. They have also explore more general views of aCRM IS rather than focusing on exploration of the application and usefulness of tools, techniques, and quantitative methods in aCRM IS in an organization. ...
Article
Full-text available
Background and Purpose: Information solutions for analytical customer relationship management CRM (aCRM IS) that include the use of analytical tools are becoming increasingly important, due organizations’ need for knowledge of their customers and the ability to manage big data. The objective of the research is, therefore, to determine how the organizations’ orientations (process, innovation, and technology) as critical organizational factors affect the attitude towards the use of the analytical tools of aCRM IS. Design/Methodology/Approach: To measure the orientation of the organization (process, innovation, and technology), we redesigned the existing scale, which was validated using exploratory factor analysis. In the next phase, we created a model by which we examined the impact of the organization’s stance in relation to the use of the analytical tools of aCRM IS, where we used multiple regression analysis. The model was verified on a sample of Slovenian Organizations (n=105), which use the analytical tools of aCRM IS for analyzing the data they have on their customers and business partners. Results: In the study we found that all critical factors of the organization, specifically process, technology, and innovation orientation, have a positive impact on the attitudes towards using the analytical tools of aCRM IS. Innovation orientation is particularly important and has the strongest influence on the attitude towards using the analytical tools of aCRM IS. We found that innovation orientation on new ideas, methods, and approaches has the strongest effect, followed by the impact of innovation orientation on acceptance of novelty. Conclusion: The more innovation-, technology-, and process-oriented organizations are, the more positive their attitude towards using the analytical tools of aCRM IS. The study is particularly important for organizations that are introducing an aCRM IS into their business system.
... Customer analytics consists of more sophisticated tools and technologies which are capable of processing huge amount of customer data. The main functionalities concerning an analytical customer management solution are associated with four dimensions of customer relationship management, namely customer identification (selection of target customers, customer segmentation/profiling), customer attraction (direct marketing, campaign management), customer retention (customer loyalty including scoring models, one-to-one marketing, complaints management, customer churn modeling, behavioral and clickstream analysis), and customer development (customer lifetime value modeling, up/cross selling, market basket analysis) [1], [3], [4]. The structure of any customer analytics solution consists of four layers. ...
Article
Full-text available
Since customers are seen as a strategic element in a company’s downstream supply chain, many retail organizations have been employing a customer-centric business strategy and started investing into such technologies and solutions known as customer analytics that are capable of processing huge amount customer data for enhanced decision making. Customer analytics has been of significant importance in most developed economies around the world particularly for large organizations. The off-the-shelf analytics solutions provided by vendors are perceived to be unmanageable, risky and unaffordable especially for Small and Medium Enterprises (SMEs) operating in retail sector. This becomes more vital for the SMEs in developing countries especially in the Eastern part of Europe where they constitute a noteworthy part of the economy. The majority of the SMEs in these countries lack of facilities, infrastructure and abilities to perform such analytical applications. Not being able to extract strategic knowledge using customer data is a missing component for them to be competitive and sustainable in the market from relationship marketing point of view. The aim of this paper is to propose a conceptual model that addresses this problem by providing retail SMEs with a cloud-based open platform for customer data analytics and knowledge extraction. The platform will be able to connect with numerous apps already employed at the retail SMEs, acquire customer data and then perform customer analytics in order to produce a rich set of reports and knowledge.
... Technology also makes it possible to use the extended data, conduct comprehensive analysis (Porter and Millar 1985, p.152) and develop a fine-grained customer understanding on a mass scale. This makes " various CRM functions like customer segmentation, communication targeting, retention, and loyalty much more effective " (Srivastava et al. 2002, p.14). In order to translate customer data into measurable results, banks need to focus on creating an analytic capability that enables to leverage customer information through data aggregation and analysis to gain customer insight, make better decisions, and shape future customer interactions (Harris 1999, p 3). ...
Article
Full-text available
Many executives find the subject of data management to be unglamorous and mind-numbing. They pay only lip service to their company's need for quality customer information – until they realize how much is really at stake. When a critical project cannot go live due to data quality problems, the response rate on marketing campaigns is substandard due to an inability to define proper target groups or the total credit outstanding of international customers cannot even be estimated – only then senior management begins to take notice. Poor customer information means not only wasted money, but also key performance indicators and thus the basis for guiding the corporate strategy might be flawed. After the EU has included data privacy into the Charter of Human Rights and member states have adopted the EU Data Privacy Directive into national law, the legitimacy and correctness of storing and processing customer information is at stake. This paper focuses on the banking industry; its key considerations and concepts can equally be applied to other industries where companies are storing and handling detailed data on a large number of customers.
... What is more, CRM is the most strenuous and vigorous tools in the our era and is a consolidation of trust, business and technology to gratify the requirements of the clients [1]. Furthermore, CRM implies the understanding and give some value to them and creating, best bond with them using relationship management [5]. ...
Article
Full-text available
One of the major subjects in information technology which has an outstanding influence in this field and in marketing and management area is mobile commerce. It is a key concept for variety of businesses. However, it has not fulfilled the expectations. This paper tackles the problems of mobile commerce in three separate approaches. First, it emphasizes the relative significance of customer relationship management and its relationship with mobile commerce. Second, it illustrates the ways of amplifying E-loyalty of the clients within small and medium enterprises. Eventually, the positive relationship among these, three concepts will be discussed. M-Commerce constitutes a substantial future market worldwide. This paper argues that businesses should strengthen and enhance loyalty as well as e-loyalty and M-Commerce activities, to better obtain the customers toward wireless marketing and customer relationship pathways. Moreover to get the extreme profitability businesses must generate value for consumers in a way that is different from what they get used to prior to the latest version of services from the businesses. This paper, introduces a new area of doing business with the assistance of CRM and some evaluators to grasp loyalty under the context of mobile commerce. Furthermore, businesses should consider consumer's willingness to use successful features of M-Commerce. While performing the project, we expect to achieve productivity and reputation to the organization.
Book
Full-text available
Günümüzdeki yoğun rekabet ortamında faaliyet gösteren işletmeler ürün odaklı yaklaşımdan müşteri odaklı yaklaşıma doğru yönelmektedirler. Bu yaklaşım, müşteri memnuniyetini sağlamayı, müşteri ile uzun vadeli ilişki kurmayı ve bu ilişkiyi karlı bir şekilde yönetmeyi amaçlamaktadır. Bu amaç doğrultusunda müşteri ilişkileri yönetimi işletmeler için çok önemli bir konu haline gelmiştir. İşletmeler müşteri ilişkileri yönetimi kapsamında müşterileri ile ilgili verecekleri kararlarda, hangi müşterilerinin daha karlı ve daha fazla hizmete değer olduğu, hangi müşterilerinin işletmeye katkı sağlamadığı gibi, müşterilere ait detaylı bilgilere ihtiyaç duymaktadır. Bu bilgilerden en önemlisi olan müşterilerin işletmeye sağladığı karın hesaplanabilmesi için müşterilerin maliyetlerinin doğru hesaplanması gerekmektedir. Bu kapsamda geleneksel maliyetleme sistemlerine nazaran müşterilerin daha doğru maliyetlendirilmesine olanak sağlayan faaliyet tabanlı maliyetleme sistemi yöneticilerin müşterilerle ilgili ihtiyaç duyduğu bilgileri daha doğru ve detaylı şekilde raporlayabilmektedir. Bu çalışmada işletmeler için; hem pazar ortamındaki yaşanan değişim sonrası müşteri ilişkilerini sağlıklı bir şekilde yönetebilecek hem de değişen üretim ortamındaki maliyetleri doğru analiz edebilecek bir model oluşturulması hedeflenmektedir. Bu kapsamda stratejik maliyet yönetimi yaklaşımlarından biri olan faaliyet tabanlı maliyetleme sistemi kullanılarak yapılan müşteri maliyeti analizi, müşteri karlılık analizi, müşteri segment karlılığı analizi ve müşteri değeri analizi gibi analizlerin işletme yöneticilerinin müşterileri ile ilgili daha doğru kararlar almalarını sağlayabileceği düşünülmektedir. Çalışma kapsamında grup prizleri, aydınlatma armatürleri, sigorta kutuları ve elektrik aksesuarları üreten bir işletmede, müşteri ilişkileri yönetimine yönelik olarak faaliyet tabanlı maliyetleme sisteminin kullanıldığı örnek bir uygulama yapılmıştır. Bu kitap “Müşteri İlişkileri Yönetiminde Faaliyet Tabanlı Maliyetleme Sisteminin Kullanılması ve Bir Üretim İşletmesinde Uygulama” başlıklı doktora tezinden üretilmiştir.
Article
Full-text available
Persaingan bisnis pijat refleksi khususnya di Kota Pontianak semakin mengalami peningkatan. Oleh karena itu diperlukan strategi baru untuk membantu perusahaan dalam mengelola hubungan pelanggan sehingga dapat meningkatkan loyalitas pelanggan dan mempertahankan pelanggan yang sudah ada. Salah satu strategi bisnis yang dapat membantu mengelola hubungan pelanggan yaitu menggunakan teknologi CRM. CEO Refleksi merupakan salah satu pelaku UMKM yang terletak di Kota Pontianak yang akan menerapkan teknologi CRM. Penelitian ini bertujuan untuk membuat sistem berbasis web menggunakan pola MVC dengan mengimplementasikan CRM sebagai tools marketing. Fitur-fitur CRM yang akan diimplementasikan yaitu SMS Marketing sebagai tools marketing untuk melakukan promosi dan memberikan informasi terbaru terkait produk dengan menggunakan SMS Gateway API dan fitur segmentasi pelanggan untuk mengelompokkan pelanggan menggunakan metode K-Means Clustering berdasarkan model RFM pelanggan. Hasil implementasi CRM pada penelitian ini yaitu dilakukan segmentasi pelanggan dengan diperoleh 3 kelompok pelanggan berdasarkan pada tingkat loyalitas pelanggan dan hasil implementasi SMS Gateway API pada fitur SMS Marketing berhasil dikirim kepada penerima. Hasil dari penelitian ini berupa sistem Customer Relationship Management yang telah dilakukan pengujian fungsional kepada pihak CEO Refleksi dan memperoleh hasil sesuai dengan rancangan fungsional sistem. Sedangkan pengujian interface kepada masyarakat umum memperoleh predikat sangat baik dengan persentase 87,37%.
Article
From the Publisher:Increase profits and reduce costs by utilizing this collection of models of the most commonly asked data mining questionsIn order to find new ways to improve customer sales and support, and as well as manage risk, business managers must be able to mine company databases. This book provides a step-by-step guide to creating and implementing models of the most commonly asked data mining questions. Readers will learn how to prepare data to mine, and develop accurate data mining questions. The author, who has over ten years of data mining experience, also provides actual tested models of specific data mining questions for marketing, sales, customer service and retention, and risk management. A CD-ROM, sold separately, provides these models for reader use.
Book
The growing interest in data mining is motivated by a common problem across disciplines: how does one store, access, model, and ultimately describe and understand very large data sets? Historically, different aspects of data mining have been addressed independently by different disciplines. This is the first truly interdisciplinary text on data mining, blending the contributions of information science, computer science, and statistics. The book consists of three sections. The first, foundations, provides a tutorial overview of the principles underlying data mining algorithms and their application. The presentation emphasizes intuition rather than rigor. The second section, data mining algorithms, shows how algorithms are constructed to solve specific problems in a principled manner. The algorithms covered include trees and rules for classification and regression, association rules, belief networks, classical statistical models, nonlinear models such as neural networks, and local "memory-based" models. The third section shows how all of the preceding analysis fits together when applied to real-world data mining problems. Topics include the role of metadata, how to handle missing data, and data preprocessing.
Article
Data mining is the discovery of interesting, unexpected or valuable structures in large datasets. As such, it has two rather different aspects. One of these concerns large-scale, 'global' structures, and the aim is to model the shapes, or features of the shapes, of distributions. The other concerns small-scale, 'local' structures, and the aim is to detect these anomalies and decide if they are real or chance occurrences. In the context of signal detection in the pharmaceutical sector, most interest lies in the second of the above two aspects; however, signal detection occurs relative to an assumed background model, therefore, some discussion of the first aspect is also necessary. This paper gives a lightning overview of data mining and its relation to statistics, with particular emphasis on tools for the detection of adverse drug reactions.
Article
This paper is a review of the book Discovering Data Mining: From Concept to Implementation -- Peter Cabena, Pablo Hadjinian, Rolf Stadler, Jaap Verhees, and Alessandro Zanasi (New Jersey: Prentice Hall, 195 pp., 1998). Keywords Data mining, Book review. 1. INTRODUCTION What do Cabena et al. know about data mining that practitioners, consultants, managers and academics will find useful? A lot! is my answer based on reviewing this easy to read seven chapter book that incorporates over 30 years of combined practical lessons learned by the authors. One of the central themes in this book is the process oriented view of data mining advocated by the authors and later operationalized in a chapter focusing on two detailed case studies. This book however, does not provide an assessment tool for evaluating an organizations' readiness to adopt data mining technology and, like others dealing with the subject of data mining, is a mixture of "good" and "could have been better" parts. 2. REVIEW ...
Analytical CRM Powers Profitable Relationships-Creating Success by Letting Customers Guide You
  • Swif
  • S Ronald
  • Swift
The Bottom Line of CRM: Know your Customer
  • Silvon Software
Customer Relationship Marketing Requirements Definition Workshop
  • Richard Forsyth
Analysis and Communication-Two Sides of the Same Coin
  • Peter Stevens
How to Build Valuable Customer Relationships
  • Richard Heygate