Project Study on Optimizes Customer Insight: CRM

Description
Customer Insight is the intersection between the interests of the consumer and features of the brand. Its main purpose is to understand why the consumer cares for the brand as well as their underlying mindsets, moods, motivation, desires, aspirations, and motivates that trigger their attitude and actions

CRM with Data warehouse: "Optimizes Customer Insight."

Abstract : Understanding customer behavior is important to adjusting business strategies, increasing revenues, identifying new opportunities and expanding business activities. The vital importance of such knowledge of these objectives is not new; in fact its always been a fixture of business success, What's new is that many organizations have an impressive variety of data & information resources that leads to reveal about customer behavior, purchasing decision, price sensitivity, attitudes, etc. Diverse businesses and leading enterprises, now-a-days uses data warehouses with customer focus that sets them apart from their traditional operational databases. The data mining & data warehouses have become the bases on which specific business aims can be achieved & predictive model can be built. Article Type : Theoretical with worked example. Content Indicators : Research implications** Practice implications* Originality** Readibility**. Integration of CRM with Data-Warehouse (Creating a Customer Database). Customer relationship management, is a process whose objective is to enhance customer loyalty. This process consists of the following: * * * * Creation and management of data mines & warehouses; Development of appropriate organizational structures; Investment in technology; & People development.

Data Mining & Warehousing.

People.

Loyalty

Structure : *Alliances; *Call Centre.

Technology * Web; * Voice Mail; * Telephones.

Source :- Prof. Rajan Saxena – Marketing Management, Tata McGraw- Hill Publication, New Delhi.

CRM process depends on data. Single operation focused integrated logical database, data warehousing, data mining, decision support system (DSS), campaign management tools as well as call center software & hardware. A necessary step to a complete CRM solution is the construction of a customer database or information file. This is the foundation for any customer relationship management activity. For web based businesses, constructing a database should be a relatively straightforward task, as the customer transaction & contact information is accumulated as a natural part of the interaction with customers. For existing companies that have not previously collected much customer information, the task will involve seeking historical customer contact data from internal sources such as accounting & customer service. What should be collected for the database? Ideally, the database should contain information about the following: * Transactions :- This should include a complete purchase history with accompanying details (price paid, delivery date, location etc.). * Customer Contacts :- Today, there is an increasing number of customer contact points from multiple channels and contexts. This should not only include sales calls and service requests, but any customer-or-company-initiated contact. * Descriptive Information:- This is for segmentation and other data analysis purposes. * Response to Marketing Stimuli :- This part of the information file should contain whether or not the customer responded to a direct marketing initiative, a sales contact, or any other direct contact. The data should be represented over time. Companies have traditionally used variety of methods to construct their databases. Durable goods manufactures utilize information from warranty cards for basic descriptive information. Unfortunately, response rates to warranty cards leave big gaps in the databases. Service businesses are normally in better shape since the nature of the product involves the kind of customer-company interaction that naturally leads to better data collection. For examples, banks have been in the forefront of CRM activities for a number of years. Telecom-related industries (long distance, wireless, cable services) similarly have a large amount of customer information.

Most CRM software focused on simplifying the organization and management of customer information. Such software, called 'Operational CRM', focuses on creating a customer database that presents a consistent picture of the customer's relationship with the company and providing that information in specific applications. This include sales force automation and customer service applications, in which the company "touches' the customer.

Operational CRM

Analytical CRM

Collabor ative CRM

CUSTOMER

Interaction of CRM Technologies Data mining is a process that uses a variety of data analysis and modeling techniques to discover patterns and relationships in data that are used to understand what customers want and predict what they will do. Data mining can help to select the right prospects on whom to focus, offer the right additional products to existing customers and identity of good customers who may be about to leave. These results in improved revenue because of a greatly improved ability to respond to each individual contact in the best way and reduced costs due to properly allocated resources. CRM applications that use data mining are called 'Analytical CRM'. Data mining also frequently used to identify a set of characteristics that segments customers into groups with similar behaviors, such as buying a particular product. A special type of classification can recommend items based on similar interests held by groups of customers. This is called 'Collaborative CRM'. Data mining can improve profitability in each stages of customer life cycle when integrated with operational, analytical or collaborative CRM systems or implement it as independent applications. What is Data Mining? "Data Mining is the process of extracting & presenting new knowledge, previously

undetectable, selected from databases for actionable decisions." It is the process of extracting valid, previously unknown & ultimately comprehensible information from a large database and using it to solve business problems and to make crucial business decisions. Data mining & knowledge discovery are receiving increasing attention in the business & technological press, among industry analysts, & among corporate management. The first & simplest analytical step in data mining is to describe the data. For example : organization can summarize data's statistical attributes (such as Means & Standard Deviations), visually review data using charts and graphs. But data description alone cannot provide an action plan. Companies must build a predictive model based on patterns determined from known results & then test those model results outside the original sample. A good model should never be confused with reality, but it can be a useful guide to understanding business. Data mining can be used for both classifications & regression problems. In classification problems we are predicting what category something falls into - For example:- whether or not a person is a good credit risk or which of several offers someone is most likely to accept. In regression problems, we are predicting a number, such as the probability that a person will respond to an offer. Today detailed customer interaction data is abundant. We might have data about browsing behavior, returns, complaints, wishes, gifts and more. How many businesses are truly using this data effectively? The reason for this paradox is that technology for generating, capturing and storing data has far outpaced the human capacity to understand, analyze, & exploit it for maximum impact. Data Mining Technology, which focuses on identifying interesting patterns and developing predictive models from data, ha the greatest potential for enabling businesses to leverage data resources for strategic business success. In CRM, data mining is frequently used to assign a score to a particular customer or prospect indicating the likelihood that the individual behaves the way we want. For example: a score could measure the propensity to respond to a particular offer or to a competitor's product. It is also frequently used to identify a set of characteristics (called a profile) that segments customers into groups with the similar behavior such as buying a particular product. Data Mining Process For CRM: For successful operational CRM, organizations need to maintain a strict data flow framework within their organization. A broad framework for building data flow framework within any organization would consist of the following processes: Objective Identification ---> <---

Data Preparation * Sources of Data ---> <--Data Pre-processing *Define Problem; *Data Selection; *Data Projection. ---> <--Design Modeling * Field Selection; *Technical solution; *Segmentation ||

|| Output Generation / Business Decision Formulation. *Report Generation; *Monitoring; *Application; *Data Visualization. ---> <--Assimilation of Results ---> <--Data Analysis *Model Creation; *Model Testing; *Data Transformation; *Education. (1). Identification of the Objective:- To identify the core areas in which organization would need to implement effective customer centric views. (2). Data Preparation:- To identify the different sources of customer related data from within the organization or outside. The common sources of data for organizations are from

their transactional systems, marketing data, sales record and market research data. Secondary data sources from outside the organization could also be used. Three-sources of customer data are most critical to data mining efforts toward better understanding of behavior, which are as follows: Demographic Data: - Direct marketers have employed data about age, geographical location, & income for many years to target specific groups of customers. The goal has been to use data to aim promotional campaigns at groups with particular interests. Transaction Data: - This resource provides concrete data about what your customers are purchasing. Going beyond general demographics information, transaction data is essential in helping to predict future purchases & target promotional campaigns more effectively. In addition to the value of the transaction itself, this data also reveals key information about time, location, & other factors related to the transaction. Online Interaction Data / Online Transaction Processing (OLTP) : The dominant form of data here is 'Internet Clickstream Data', although we must also include interactions that occur through wireless devices, cable television & more. This resource can provide deeper information than transaction data; it provides a window on customers' decision processes and the navigational steps they took to find what they desired. Online interaction data records every page that the customer saw leading up to a decision. Therefore, we know not only what they purchased (or didn't purchase) but we also have strong evidence of how they arrived at that decision. (3). Data Processing:- For analysis, data collected from different sources needs to be collected & pooled together into a single repository. However, before any organization can do this, the data collected from different sources has to be made consistent, since the data could be collected from systems that are running on different platforms, architectures or application systems. (4). The Model Design :- It entails selecting an appropriate data mining algorithm to be applied to the data. Then, segmentation to apply to the data minimum will usually entail breaking the data out into a training set and one or more test sets. Segmentation might involve using clustering techniques to break the data into separate subsets based on common characteristics and then analyzing each segment separately. Note:- "Don't confuse; Segmentation with Clustering". "Segmentation refers to the general problem of identifying groups that have common characteristics." "Clustering is a way to segment data into groups that are not previously defined, whereas classification is a way to segment data by assigning it to groups that are already defined." "SPSS Inc. provides solutions that discover what customer want and predict what they will do. The company delivers solutions at the intersection of customer relationship management and business intelligence that enables its customers to interact with their customers more profitably.

SPSS solutions integrate and analyze marketing, customer & operational data in key vertical markets worldwide including: - telecommunications, healthcare, banking, finance, insurance, manufacturing, retail, customer packaged goods, market research & the public sector." (5). Data Analysis: - Data which has been collected may then be subjected to different data mining applications depending on this business requirements. Thus, phase involves a further preparatory activity (data transformation) to reorganize the data to best match the selected algorithm and the business problem. The selected data-mining tool is applied to the data, & this typically involves creating a model using the training set of data & then verifying the model with atleast one separate set of test data. The model's accuracy & validity can then be evaluated. It is very likely that the initial model will not meet the goals of the data mining exercise & that much iteration will be necessary, especially among the Model design & Data Analysis phases. This will involve trying out different data mining techniques or parameters on different subsets of the data before arriving at a successful outcome. (6). Assimilation of Results: - Results obtains from the analysis could then be analyzed for effectiveness or applicability in the business process. Systems working without preconceived hypotheses, as in Data Mining Applications, could throw up results that might not be of direct relevance to organization process. All results have to be analyzed to identify those that may be converted into strategic knowledge for the business objective. This is the stage at which organizations would be able to formulate different value propositions for their customers. (7). Output Generation / Business Decision Formulation: Depending on the result obtained from the Analysis state, a business decision might be taken. This could be an automated business decision for real-time application system, or a long-term strategic decision for any organization depending on the requirement. This stage ideally represents the selection of a value proposition or a set of value propositions that the organization might want to present to their customers. Analysis & Refinement

--->

Knowledge Discovery |

The CRM iterative Learning Process.

| Customer Interaction

<---

Market Planning

Applications / Uses of Data Warehousing

Product Planning

Customization of Marketing Mix

Management of Intermediaries

|

Targeted Promotions. -DATA WAREHOUSE -Relationship Marketing

|

Sales Force Productivity

Up-Selling / Cross-Selling

Customized Services Data mining is a broad technology that can potentially benefit any functional areas within a business where there is a major need or opportunity for improved performance, and where data can impact the performance improvement is available for analysis. The applications of the technology of data warehousing and / or data mining towards solving business problems like: - Target Marketing, Customer Retention, Fraud Detection, Customer Segmentation, Credit Risk assessment, Security Management, Resource Management, Customer Profitability Analysis, Customer Service Automation, Campaign Management, Product Planning, Cross-Selling / Up-Selling, Distribution Channel Management, Inventory Control, Relationship Marketing etc. Customer relationship management in its broadest sense simply means managing all customer information and interactions. In practice, this requires using information about customers and prospects to more effectively interact with customers in all stages of relationship with them. Data Warehousing / Data Mining facilitate the organization in all the 3-stages of customer life cycle i.e.; * Acquiring new customers via data mining; * Increasing the value of existing customers: cross-selling via data mining; * Retaining good customers via data mining. CRM helps companies improve profitability of their interactions with customers, while at the same time, makes the interactions appear friendlier through individualization. To succeed with CRM, companies need to match products and campaigns to prospects and customers – in other words, to intelligently manage the customer life cycle. Conclusion:There is the growing significance of data mining & warehousing in computer satisfaction & business development. In order to be effective, data mining has to be more intelligent & offer information of the customer in real time. The data mining should help the organization to disseminate information on customers to everybody in the organization; which should facilitate each person's functioning & also make him/her customer responsive. Companies have used & are using data mining to support their sales & service staff in particular. They have also supported their sales & service staff with advance technology, which in turn has helped them to use the data for the purposes of developing a customer

offer. Smart Cards & Credit Cards are good examples of the customer sharing his data with the organization. References:1). Brown stanley A, Customer Relationship Management, John Wiley & Sons Ltd; Canada. 2). Prof. Rajan Saxena, Marketing Management, TaTa McGraw-Hill Publication Ltd; New Delhi. 3). Usama Fayyad : Optimizing Customer Insight; 4). Vikas Kharbanda & Parthasarathi Dasgupta : Data mining for Customer Relationship Management. 5). H. Peeru Mohamed & A Sagadevan : Customer Relationship Management A Step-by-Step Approach, vikas publishing House Pvt. Ltd; New Delhi. 6). Role of Database servers in CRM applications, Microsoft Press. 7). Russell S. Winer, A framework for Customer Relationship Management, California Management Review Vol. 43, No. 4, summer-2001. 8).Herb Edelstein, Prtesident, Two crows corporation,- Building Profitable CRM with Data Mining. 9).Frank Teklitz & Robert L, McCrathy Siebel Corporation-Analytical Customer Relationship Management. 10). Gary Saarenvirta, A charactersitics of Data Mining Techonologies & Processing, Information Discovery Inc. 11). Vikas Saraf, "Understanding & Implementing CRM: A Key Component for Tomorrows' Business Leader's":- Indian Journal of Marketing New Delhi Vol.-1, Jan. 2003.



doc_279614372.docx
 

Attachments

Back
Top