Data Mining Operations in CRM
Data Mining Operations in CRM
6.1 Introduction
6.11 E-CRM
6. CRM-AN OVER VIEW
This chapter brings brief idea about customer relationship management. It includes
process, the relation between Customer Relationship Management and data mining.
6.1 Introduction
current era of intense competition and demanding customers than it has ever before
faced with extremely tough competition and flat sales growth companies are finding it
hard to secure customer loyally. Research has proved that it cost five times more for
management starts with the in-depth knowledge of customers-their habits, desires and
their needs by analysing their cognitive, effective behaviour and attitudes. CRM
applies this knowledge to develop and design marketing strategies, to develop and
cultivate, long, mutually beneficial interaction and relationship with the customer.
Customer knowledge and interaction on the basis of this knowledge are the two pillars
as marketing medium and its global acceptance have forced organizations to change,
the way in which business have been conducted. Thus E. business have evolved and is
expected that within few years it will become so mature and that would be the sole
51
longer exists. Till very recently, the companies were not focused on selling as many
products and services as possible without regard to who was buying them. Most firms
stick to this product centric view today, based on their organisational structure and
compensation plans. Today consumers have more choice than ever before, about
where to go for their banking, grocery shopping and their vacationing. Deregulation
increased competition, even further as it drove price down, companies were forced to
invent new methods of interacting with customers to reduce cost and gain market
share. As a result of the above business environment the term customer relationship
came in to existence.
CRM actually a tremendous step forward in creating a system that can provide a
means for retaining individual loyalty in a world of nearly 6 billions souls. In order to
is the king” has been a mantra since 1940’s. Its contents has changed fundamentally
over the past decade. To understand these let us discuss who is a customer?
Imagine you are a company. You have paying clients. They give you money and you
give them products or services; and you call them your customers. You have
employees. You give them pay check, benefits and they give you productive work in
return. So he is also a customer to you. You have suppliers. They give you product
and services and you give them money. They too are customers for you. You have
channel partners. They give you sales, value added services and market information
and in return you give them commission. They are also your customers. Hence the
52
Due to the competition and technological evolution, executives realized that cost
reduction tact’s were not enough to satisfy either customers or shareholders, who
continued to call them on the carpet for cording margins. Maximizing profitability
was the real game. The paradox was companies could not very well increase profit.
While simultaneously enticing new customers with practice break. AT & T and NCI
learned this hard way in 1980’s as they and other long - distance companies mailed
millions of $100 checks out to consumers, who switched their long distance service
Now a days as we discussed earlier the competition is just a mouse click away.
Companies are slouching towards the realization that without customers product
won’t sell & revenues don’t materialize. They have been forced to become smarter
about selling and this means becoming smarter about who is buying. Companies are
reading the competitive writings on the wall and technology for a leg up.
This combined with the fact that it, cost a company six times more to sell a product to
a new customer than it does to sell to an existing one. Hence the smart business is
maximize the existing customer relationship. And the main way to extract every drop
of value from existing customers is to know who the best customers are and motivate
infrastructure that enables the delineation of and increase the customer value and the
correct means by which to motivate valuable customers to remain loyal, indeed to buy
53
Again CRM is a comprehensive set of processes and technologies for managing the
relationship, with potential and current customers and business partners across
> To understand the customer thoroughly and their needs even before they know
themselves.
organizations.
customer segment.
> To use technology to improve customer services and enable a greater degree
> To attract both old and new customers - through more personalized
communication.
CRM promises to help companies to get to know their customers well enough to
understand and which one’s to keep an which one they willing to loose and why? -
and how not to correspond in the mean time. CRM also means automating many of
the business process and accompanying analysis and saving precious time in bargain.
CRM also speaks about the automation of sales force with technology.
54
6.5 Types of CRM Technology
The analytical CRM includes data warehouses such as customer responses, which are
used by applications that supply algorithms to dissect the data and presented it in the
form of information’s to user. Collaborative CRM deals with the touch points of the
customers.
This is called as ERP of CRM. The typical business functions consisting customer
service, order management, billing, sales and marketing automation. One facet of
operational CRM is the possibility of integrating the financial and human resource
reporting of the customer data to a CRM user. Analytical CRM will absorb different
data’s about customer from different sources, and stores it in data where house, then
uses different techniques like data mining to process it to useful information’s. It also
55
6.8 Collaborative CRM
that provides the neural paths to the customer and his suppliers. It could mean a
interaction center (CIC). It could mean communication channels such as the Web or
email, voice applications, or snail mail. It could mean channel strategies. In other
words, it is any CRM function that provides a point of interaction between the
FORMATION PERFORMANCE
Purpose
- Increase effectiveness
- improve Efficiency
Relationship
t performance
Programmes - Strategic
Account MGT - Financial
Retention - Marketing
Strategic Partnership * Satisfaction
* Retention
* Loyalty
Employee Training
Partners
~ Criteria
- Process Evaluation
-Enhancement
— Emprovement
56
CRM Formation Process
activities for a firm with respect to a specific group of customers or with respect to an
areas relate to defining the purpose (or objectives) of engaging in CRM; selecting
parties (or customer partners) for appropriate CRM programs and developing
programs (or relational activity schemes) for relationship engagement with the
customer
CRM Purpose
mutual value for the parties involved in the relationship. CRM has the potential to
Sheth and Sisodia 1995) By seeking and achieving operational goals, such as lower
the burden of excessive customer acquisition costs, and through customer retention
economics, firms could achieve greater marketing efficiencies. They can enhance
individualizing and personalizing their market offering to anticipate and serve the
partnering to enter new markets and develop new products, and redefining the
competitive playing field for their company (Sheth and Parvatiyar 1995a). Thus,
stating objectives and defining the purpose of CRM in a company helps clarify the
57
nature of CRM programs and activities that ought to be performed by the partners.
Defining the purpose would also help in identifying suitable relationship partners who
have the necessary expectations and capabilities to fulfill mutual goals. It will further
Similarly, in the mass-market context, consumer’s expect to fulfill their goals related
and Parvatiyar (1995a) contend that consumers are motivated to engage in relational
choices, consumers are motivated to seek to rewards and associated benefits offered
by CRM programs.
Relational Parties
formation state. Even though a company may serve all customer types, few have the
necessary resources and commitment to establish CRM programs for all. Therefore, in
the initial phase, a company has to decide which customer type and specific customers
or customer groups will be the focus of their CRM efforts. Subsequently when the
company gains experience and achieve successful results, the scope of CRM activities
58
Although partner selection is an important decision in achieving CRM goals, not all
partner with those customers who demand so. Yet other companies have formalized
along chosen criteria. The criteria for partner selection vary according to company
goals and policies. These range from a single criterion such as revenue potential of the
CRM Programs
A careful review of literature and observation of corporate practices suggest that there
are three types of CRM programs: continuity marketing; one-to-one marketing; and,
partnering programs. These take different forms depending on whether they are meant
presents various types of CRM programs commonly developed for different types of
many variations and combinations of these programs to build closer and mutually
59
Table 6.1
CRM Programs
Business to Business
Customer Types Mass Markets Distribution
Markets
Program Types
Continuity Marketing After-Marketing Continuous • Special Sourcing
Loyalty Programs Replinshment Arrangements
Cross-selling ECR Programs
One-to-one Marketing Permission Marketing Customer Business • Key Account
Personalization Development • Global Account Programs
Partnering/Co-Marketing Affinity Partnering Logistics Partnering • Strategic Partnering
Co-Branding Joint Marketing • Co-Design
• Co-Development
Given the growing concern to retain customers as well as emerging the knowledge
about customer retention economics have led many companies to develop continuity
marketing programs that are aimed at both retaining customers and increasing their
loyalty (Bhattacharya 1998; Payne 1995). For consumers in mass markets, these
programs usually take the shape of membership and loyalty card programs where
consumers are often rewarded for their member and loyalty relationships with the
marketers (Raphel 1995; Richards 1995). These rewards may range from privileged
services to points for upgrades, discounts, and cross-purchased items. For distributor
processing and material resource planning (Law and Ooten 1993; Persutti 1992). In
60
programs or in special sourcing arrangements including single sourcing, dual
1995; Postula and Little 1992). The basic premise of continuity marketing programs is
to retain customers and increase loyalty through long-term special services that has a
potential to increase mutual value through learning about each other (Shultz 1995).
One-to-one Marketing
based marketing. Such a program is aimed at meeting and satisfying each customer’s
need uniquely and individually (Peppers and Rogers 1995). What was once a concept
information on customers is now possible at low costs due to the rapid development in
information technology and due to the availability of scalable data warehouses and
customer interactions, marketers aim to fulfill the unique needs of each mass-market
relationship with high yielding customers (File, Mack and Prince 1995; Pruden 1995).
For distributor customers these individual marketing programs take the shape of
customer business development. For example, Procter and Gamble have established a
customer team to analyze and propose ways in which Wal-Mart’s business could be
developed. Thus, by bringing to bare their domain specific knowledge from across
many markets, Procter & Gamble is able to offer expert advice and resources to help
build the business of its distributor customer. Such a relationship requires cooperative
61
action and an interest in mutual value creation. In the context of business-to-business
markets, individual marketing has been in place for quite sometime. Known as key
account management program, here marketers appoint customer teams to husband the
programs require extensive resource allocation and joint planning with customers.
take the shape of national account management programs, and for customers with
Partnering Programs
The third type of CRM programs is partnering relationships between customers and
marketers to serve end user needs. In the mass markets, two types of partnering
programs are most common: co-branding and affinity partnering (Teagno 1995). In
co-branding, two marketers combine their resources and skills to offer advanced
products and services to mass-market customers (Marx 1994). For example. Delta
Airlines and American Express have co-branded the Sky Miles Credit Card for gains
similar to co-branding except that the marketers do not create a new brand rather use
customer memberships in one group for cross-selling other products and services. In
efforts are how partnering programs are implemented. In such partnerships the
marketer and the distributor customers cooperate and collaborate to manage inventory
and supply logistics and sometimes engage in joint marketing efforts. For business-to-
62
business customers, partnering programs involving co-design, co-development and
co-marketing activities are not uncommon today (Young, Gilbert and McIntyre 1996).
Once CRM program is developed and rolled out, the program as well as the individual
relationships must be managed and governed. For mass-market customers, the degree
varies with tomer or the program sponsoring company will be managing the
relationship varies with the size of the market. However, for programs directed at
distributors and business customers the management of the relationship would require
norms of governance processes among relational partners given the nature of their
CRM program and the purpose of engaging in the relationship. Not al relationships
governance norms for different hybrid relationships (Borys and Jemison 1989; Heide
specification relates to determining the role of partners in fulfilling the CRM takes as
well as the role of specific individuals or teams in managing the relationships and
related activities (Heide 1994). Greater the scope of the CRM program and associated
63
tasks, and the more complex is the composition of the relationship management team;
the more complex is the composition of the relationship management team; the more
critical is the role specification decision for the partnering firms. Role specification
customers.
with customers a company can enhance their relationship with them. In addition to
that directly play a role in managing the relationship with a specific customer or
customer group.
conscious efforts for creating common bonds will have a more sustaining impact on
64
value bonding, reputation bonding and structural bonding are useful process of
the degree to which customers need to be involved in the planning process. Involving
customers in the planning process would ensure their support in plan implementation
and achievement of planned goals. All customers are not willing to participate in the
planning process nor is it possible to involve all to them for relationship marketing
programs for the mass market. However, for managing cooperative and collaborative
Executives are sometimes unaware, or they choose to initially ignore the nature of
operating processes need to be aligned depending on the nature and scope of the
Several human resource decisions are also important in creating the right organization
and climate for managing relationship marketing. Training employees to interact with
is the issue of creating the right motivation through incentives, rewards, and
term benefit of the company, personal relationships are nevertheless formed and have
65
an impact on the institutional relationship. Thus proper training and motivation of
Finally, proper monitoring processes are needed to safeguard against failure and
destabilization and creation of power asymmetries. They also help in keeping the
CRM program on track by evaluating the proper alignment of goals, results and
resources.
satisfaction from the results achieved in the relationship (Parvatiyar, Biong and
Wathne 1998).
expectations and if they are sustainable in the long run. Performance evaluation also
66
decisions regarding continuation, modification, or termination of CRM programs.
existing marketing measures, such as market share and total volume of sales may not
be appropriate in the context of CRM. Even when a more CRM oriented measures are
selected, it cannot be applied uniformly across all CRM programs particularly when
the purpose of each program is different from one another. For example, if the
overall distribution cost, measuring the programs impact on revenue growth and share
of customer’s business may not be appropriate. In this case, the program must be
evaluated based on its impact on reducing distribution costs and other metrics that are
measures one would expect to see a more goal directed managerial action by those
measures based on the defined purpose of each program (or each cooperative/
words, the performance evaluation metrics for each relationship or CRM program
should mirror the set of defined objectives for the program. However, certain global
measures of the impact of CRM effort of the company are also possible. Srivastava,
et. al. (1998) developed a model to suggest the asset value of cooperative
is treated as an intangible asset of the firm, its economic value add can be assessed
using discounted future cash flow estimates. In some ways, the value of relationships
67
is similar to the concept of brand equity of the firm and hence may scholars have
alluded to the term relationship equity (Bharadwaj 1994; Peterson 1995). Although an
well-accepted model for measuring relationship equity is not available in the literature
as yet, companies are trying to estimate its value particularly for measuring the
measurement would help in knowing to what extent relationship partners are satisfied
satisfaction measures that are applied to measure satisfaction on one side of the dyad,
relationship satisfaction measures could be applied on both sides of the dyad. Both the
customer and the marketing firm have to perform in order to produce the results in a
satisfaction, one could estimate the propensity of either party’s inclination to continue
could provide rich information on their determinants and thereby help companies
identify those managerial actions that are likely to improve relationship satisfaction
and/or loyalty.
68
CRM Evolution Process
Individual customer relationships and CRM programs are likely to undergo evolution
as they mature. Some evolution paths may be pre-planned, while others would
naturally evolve. In any case, several decisions have to be made by the partners
involved about the evolution of CRM programs. These include decisions regarding
engagement. Several factors could cause the precipitation of any of these decisions.
relationship process satisfaction) are likely to have the greatest impact on the
motivated to continue or enhance their CRM program (Shah 1997; Shamdasani and
Sheth 1995). When performance does not meet expectations, partners may consider
impact these decisions. For example, when companies are acquired, merged, or
Also, when senior corporate executives and senior leaders in the company move CRM
programs undergo changes. Yet, there are many collaborative relationships that are
terminated because they had planned endings. For companies that can chart out their
relationship evolution cycle and state the contingencies for making evolutionary
Introduction
Data mining is the process of discovering implicit and hidden patterns in data is one
69
Customer Relationship Management initiative. Normally data mining is done in two
levels which are Macro level and Micro level. The Macro level is considering
customers at a large, their behaviour. The customers data will be collected from a
cluster of datas. Wherein Micro level the attempts are made tracking a particular
customer and try to further the relationship by acting in a timely way to his or her
match the competition As a result product quality and cost no longer lies in the
technology for getting relevant information about a customers interaction through out
the firm. Advances in data storage and processing technologies has made it possible
today to store very large amounts of data in what are called data ware houses and then
used data mining tools to extract relevant information. Hence data mining helps in
the front end operation and build a mutual valuable long term relationship with the
customers. The firm might enjoy competitive advantage of its customers for long
term by building mutually beneficial relationships that increase switching cost and
70
consist of front end operations that interact with the customers and obtain a data
about him or her. This is typically consolidated from various contact points and fed
into data ware house. That data warehouse consolidates not only transaction data but
also data obtained form outside sources like senses data and provides a fertile ground
for analysis. And data analysis is done by data mining methods. The output is
all employees of the firm might access it. Thus data mining provides the intelligence
Predictive operations assigns value to some variables based on other related ones.
Classification
Classification is a process that maps a given data item into one of the several
Regression
Regression is the operation of learning a function that predicts the value of a real
71
Regression finds application in Customer Relationship Management environment
where prediction needs to be made about the behaviour involving real valued
variables. Regression needs sufficient amounts of data to be reliable and valid. If the
store does not have enough data then regression is not a technique to be employed.
Link Analysis
database record to expose patterns and trends. Link analysis can also trace
connections between items of record over time. The most important link analysis in
buyer preferences. Link analysis might some time give relations that appears to hold
true, but are of random occurrence. Links between items must be properly examined
Segmentation
categories to describe data. Segmentation is done in such way that cases belongs to a
segment or a cluster are more similar with respect to the clustering criterion while
they differ significantly from the cases belonging to other segments. In Customer
underlying groups. Data on customer of a section of the retail store, which store
72
Deviation Detection
regular basis. Suppose a retailer finds that sales from a particular section of store
have been much less than expected. This deviation on further analysis points to non
while at other times as a result of true changes in fundamentals. It must be noted that
most of the data mining operations are exploratory in nature. They do not ascertain
the reason for the occurrence of detected pattern. A further point to notice that the use
of data mining operations is detected by questions that have been raised. Two or
more data mining tasks are used in proper conjunction would give a manager with
rich inside into the phenomenal taking place and probably ferret out relationship
the customer. Data mining tasks extracts information that can provide the main
handles on relevant customer data and discovered knowledge and aligning all process
to reflect the customer santric approach are also important. Data mining would be a
Data Mining Tools and Techniques ; A variety of data mining tools and techniques
are available to support the data mining operation. These techniques differ from each
other in types of data handled, assumption about data, scope and interpretation of
73
output. Some of data mining tools are Decision Trees, Rule Induction, Case Base
Algorithm.
Decision Trees ; Decision Trees are classification tools which classify examples into
classes keeping one variable at a time and dividing the other data based on it.
Decision Trees can also be used as rule inducer for classification and segmentation.
Segmentation is possible because at each node of classification tree splits the data into
segments depending on the value of variables considered. A retailer can classify the
Rule Induction: Rule induction is a process of inducing, general rules from a data
rules are implications rules of the form B ^ C, which indicate the relationship
between B and C, where B and C may be a single item or a set of items. These rules
are exploratory in nature but are enough to handle data mining operations. The
retailer will get an idea on which products sell together by running an association rule
algorithm.
Case Based Reasoning : Case base reasoning method tries to stimulate how a
human being thinks. Typically when an example is presented to case based reasoning
solution, it tries to match the current examples with other examples which are in its
repository and retrieves the case, which is most similar to the current case. Decision
has to be taken base on exploration its power depends largely on the indexing method
used to store the case and matching method used to retrieve relevant cases. However
74
the data base of typical cases is not available then, this method will not produce a
from various angles using graphics, display techniques like charts, diagrams, displays
for multi dimensional data etc. It is used in conjunction with other data mining
techniques. Visualization techniques are ideal when users do not know what and
where to look to discover new knowledge and ideas. It is useful when the data set is
Clustering Algorithms ; Clustering Algorithms segments the data base into clusters
such as intra clusters similarly is maximised and inter clusters similarly is maximised.
These are many approaches for clustering each having its own advantages and
disadvantages.
The selection of data mining tools are much important. It depends on the ability of
Introduction : Managing relationship with the customers and making them delighted
or making them to exceed their expectations has become so important and necessary
75
due to globalization, where customer satisfaction is the key factor for the success of
any company.
The perception about a company is based on the different experiences with the people
within the organization. Today the choice is open for the customers. Here the
information is the key to success. So it is necessary to know the needs and wants of
customers. It is also equally important to know all customers are not equally
Traditional brick companies usually starts their direct marketing efforts through
simple list pulls and one shot campaigns and then gravitated to a data ware house and
software for executing multiple targeted companies that run simultaneously and
applications, and find that then they must add the backend data ware house and off
Relationship Management.
personalized and relevant communication with the customers across both electronics
about messaging, offers and channel delivery. It also focuses on understanding how
76
companies of customer relationship affects the business. Advocates of E-Customer
means to an end optimizing value of your most important asset; your customers.
channels can’t do that because they are based on applications that may not be
product bundling and pricing and so on. E-Customer Relationship Management gives
internet uses the ability to carry on users with the business through their preferred
communication channels. It also allows the business to off set expensive customer
service agents to value its ability to improve customer satisfaction and reduce cost
> Enable business to extend itself personalized messaging to the web and e-mail.
> Leverage customer information for more effective e-marketing and e-business.
77
> Focus business on improving customer relationship and earning a greater share of
appropriate technology and it will reduce the technology gap as well as refining
business process.
data ware house or customer data basket contents a consolidated and comprehensive
view of the customer. The data basket will give a broad profile of the customer. And
interacting with its customers. There may be different applications to support the
different websites of the company, and there is no link between different applications.
communication initiatives.
78