系統識別號 | U0002-1107201002233500 |
---|---|
DOI | 10.6846/TKU.2010.01235 |
論文名稱(中文) | 資料挖掘應用於客戶關係管理-台灣家用品出口商個案研究 |
論文名稱(英文) | Data Mining Approach in Customer Relationship Management: Case Study of a Taiwanese Household Exporter |
第三語言論文名稱 | |
校院名稱 | 淡江大學 |
系所名稱(中文) | 國際商學碩士在職專班 |
系所名稱(英文) | Executive Master's Program of Business Administration (EMBA) in International Commerce |
外國學位學校名稱 | |
外國學位學院名稱 | |
外國學位研究所名稱 | |
學年度 | 98 |
學期 | 2 |
出版年 | 99 |
研究生(中文) | 陳美琴 |
研究生(英文) | Mei-Chin Chen |
學號 | 792400060 |
學位類別 | 碩士 |
語言別 | 英文 |
第二語言別 | |
口試日期 | 2010-06-19 |
論文頁數 | 104頁 |
口試委員 |
指導教授
-
廖述賢(michael@mail.tku.edu.tw)
共同指導教授 - 周清江 委員 - 廖述賢 委員 - 吳啟絹 委員 - 蔡政言 |
關鍵字(中) |
顧客關係管理 關係行銷 企業對企業 資料挖掘 關聯性法則 |
關鍵字(英) |
Customer Relationship Management Relationship Marketing Business-to-Business Data Mining Association Rules |
第三語言關鍵字 | |
學科別分類 | |
中文摘要 |
客戶關係管理(CRM, Customer Relationship Management)在學術上已被廣泛地探討。先進科技發達的今天,雖然給企業帶來了很大的衝擊與競爭,卻也助長了CRM的應用。資料挖掘的技術在CRM扮演很重要的角色,最常見的例子是關聯性法則應用在零售業及電子商務,挖掘隱藏性的產品關聯作為CRM的行銷決策,如店內陳列、交叉銷售、客戶分群等等,證實有顯著的成效與報酬率。然而,以關係行銷為主的企業對企業B2B (Business-to-Business)產業在採用客戶關係管理的同時,因為商業模式的不同,應用資料挖掘技術在B2B CRM系統上卻不多,甚至有些經理人員認為觀念上是不可行的。本研究將透過理論文獻上的參考結合實務上的探討,針對個案公司目前在客戶關係管理的運作,進行診斷並提出建議。另外本研究嘗試性將資料挖掘技術應用在個案公司的交易資料庫,試圖以關聯性法則挖掘跨不同品類的產品關聯知識,作為個案公司推薦相關產品給同性質或來自同一區(有相同的文化)的客戶,並作為其樣品間的商品展示陳列參考。實驗結果是資料挖掘也是可以應用在CRM B2B的環境下,惟對文字或資料的處理與資料倉儲建置需要產業的知識與經驗來定義資料變數,再將挖掘結果整合併入行銷決策系統。 資料挖掘尚有更多的技術可以運用在CRM B2B,CRM的目標為收集訊息、分析客戶與產品知識,將有助訂定一對一行銷策略、客製化客服策略來增加客戶價值,提高客戶忠誠度,最終目標提高企業收益,創造競爭優勢。本篇論文強調CRM在貿易產業也很重要,資料挖掘更是可以作為CRM分析工具。在末章將提出管理上的意函與對未來的研究方向建議。 |
英文摘要 |
Customer Relationship Management (CRM) has been addressed with great interest among scholars and executives. The advanced technology brings tremendous impact and competition in nowadays business environment. At the same time, it facilitates the application of CRM. Data mining acts one of components to CRM system. Among many techniques, Association Rule is one of techniques to be evident effective with best return in retailing and e-commerce as marketing decision support. The new marketing strategy includes: in-store merchandising shelf display, cross-selling, customer segmentation, and supply chain management etc. Nevertheless, data mining approach in B2B (Business-to-Business) industry has been seen impossible by some managers in conception wise. Only a few CRM vendors act as a catalyst. Firstly, this research attempts to diagnose CRM in the case study with literature review and practical experience, moreover, to propose managerial implication and suggestion for the topic. Secondly, with data mining approach to its transaction database to find the relation between sub-sub categories for product recommendation and showroom merchandising display. According to the result of experiment, it proves applicable in CRM B2B. The concern raised shall be the information collection and data format that stored in the database. Then by giving variables and attributes with practical insights in the field to construct the database for better analysis. However, the case company is used to rely on personal judgment and seems lack of analytic tools for decision making system. The ultimate objective of CRM in B2B is to create customized marketing strategy to increase customer value, enhance customer royalty and satisfaction to gain business revenue with competitive advantages. This research aims to demonstrate a logical analysis for case study’s marketing strategy decision support. CRM is obviously necessary in trading industry, while an analytical tool is also vital to have a logical base for CRM strategy rather than personal bias and judgment when dealing with large amount of information and data. Managerial implication for the case company has been concluded in chapter five. Suggestions both for case company in aspect of Data Mining and future study will be proposed in the last chapter. |
第三語言摘要 | |
論文目次 |
Table of Content Acknowledgements I 淡江大學研究生論文中文提要 II Abstract: IV Abbreviations VI Table of Contents VII List of Figures X List of Tables XII Chapter 1: Introduction 1 1.1 Background & Motivation 1 1.2 Research Objective 3 1.3 Research Structure and Flow 4 1.4 Research Scope 7 Chapter 2: Literature Review 9 2.1 B2B characteristic and differences with B2C 9 2.2 Relationship marketing in B2B 11 2.3 Customer Relationship Management 13 2.3.1 CRM Definition 13 2.3.2 CRM Function 13 2.3.3 Perspective in CRM 16 2.3.4 CRM Strategy 18 2.4 Customer Knowledge 19 2.5 Customer Lifetime Value 21 2.6 CRM Technology 29 2.7 Data Mining 31 2.7.1 Data, Information, and Knowledge 33 2.7.2 Data Warehouses and Data Mining 34 2.7.3 Data Mining vs. CRM in B2B 36 Chapter 3: Diagnose CRM System in T Company 39 3.1 Methods 39 3.2 Trading business environment 40 3.3 Case Study 40 3.3.1 T Trading Company Brief 41 3.3.2 Management Philosophy 42 3.3.3 Household Products 43 3.3.4 Business Process 44 3.3.5 IT infrastructure relating CRM 46 3.3.6 Organization and Customer Service Department 49 3.3.7 Marketing Activity – Showroom visit 51 3.3.8 Sales & Communication Channel 51 3.4 Diagnose and Issues Identified 53 3.5 Data Mining System Design 54 3.5.1 Data Preparation 54 3.5.2 Relational Design 54 3.5.3 Physical Design 56 3.5.4 Conceptual Design 57 3.5.5 System Framework 59 3.5.6 Data mining Tool– SPSS Clementine 61 3.6 Data Mining Process 63 3.6.1 Association rules 63 3.6.2 Apriori Algorithm 65 Chapter 4: Data Mining Result 67 4.1 Description of the data structure 67 4.2 Product mix 69 4.2.1 Pattern A: Product Mix for Hard-Line Business Unit 69 4.2.2 Pattern B: Product Mix for Home Improvement Business Unit 71 4.3 Customer Type vs. Products 72 4.3.1 Pattern A1: Customer Type vs. Hard-Line Business Unit Sub-Sub Category 73 4.3.2 Pattern B1: Customer type vs. Home Improvement Business Unit sub-sub category 75 4.3.3 Pattern C: Customer type vs. Seasonal Business Unit sub-sub category 77 4.3.4 Pattern D: Customer type vs. Electrical & Lighting Business Unit sub-sub category 78 4.3.5 Pattern E: Customer type vs. SIT Business Unit sub-sub category 78 4.4 Communication Channel vs. Sub-Sub Category 79 4.4.1 Pattern A2: Communication Channel vs. Hard-Line Business Unit Sub-sub Category 79 4.4.2 Pattern B2: Communication Channel vs. Home Improvement Business Unit sub-sub category 81 4.4 Findings 82 Chapter 5: Managerial Implication 84 5.1 Data Warehouse in B2B CRM is Also Necessary 84 5.2 Data Mining Approach in CRM B2B is Feasible 86 5.3 CRM is a Continuous Project 87 5.4 IT is one of CRM Success factors 88 Chapter 6: Limitation and suggestion 90 6.1 Lessons learned 90 6.2 Research Limitation 91 6.3 Suggestions 91 6.3.1 For T Company 92 6.3.2 For future research 93 6.4 Conclusion 94 References 95 APPENDIX: Definition of Customer type 103 List of Figures Figure 1.1 Flow chart of research 6 Figure 2.1 CRM implementation model 15 Figure 2.2 Integrated marketing knowledge management 21 Figure 2.3 CRM applications, supported by ERP/data warehouse, link front and back office functions 27 Figure 2.4 CRM IT operational model 28 Figure 2.5 Data mining model 33 Figure 2.6 From data to information to knowledge 34 Figure 2.7 Data Mining Process 38 Figure 3.1 T Trading Company – global trading 42 Figure 3.2 Five business unit table in T Company 44 Figure 3.3 Business Process in T Company 45 Figure 3.4 IT supporting system in T Company 48 Figure 3.5 Organization structure 50 Figure 3.6 Database association chart 56 Figure 3.7 E-R Model 58 Figure 3.8 Data mining system framework 60 Figure 3.9 Clementine’s workbench for this research (partial) 62 Figure 3.10 Apriori Algorithm 66 Figure 4.1 Sales weight % by country 69 Figure 4.2 Web graph for Pattern A (after adjustment) 71 Figure 4.3 Web graph of Pattern B (after adjustment) 72 Figure 4.4 Web graph for Pattern A1 (after adjustment) 75 Figure 4.5 Web graph for Pattern B1 (after adjustment) 76 Figure 4.6 Web graph for Pattern C (after adjustment) 77 Figure 4.7 Web graph for Pattern D (after adjustment) 78 Figure 4.8 Web graph for Pattern E (before adjustment) 79 Figure 4.9 Web graph for Pattern A2 (after adjustment) 81 Figure 4.10 Web graph for Pattern B2 (after adjustment) 82 Figure 5.1 Data Warehouse Architecture 86 List of Tables Table 2.1 Business characteristic comparison between B2B and B2C 10 Table 2.2 Perspectives in CRM 15 Table 3.1 Master databases stored in the system 47 Table 3.2 Communication channel 52 Table 3.3 Relational database field 56 Table 3.4 Data mining tools used for a real project: Top 10 Rankings 61 Table 4.1 Transaction record by business unit 67 Table 4.2 Number of customer from different country 68 Table 4.3 Association Rules for Pattern A 70 Table 4.4 Association Rules for Patter B 71 Table 4.5 Association Rule for Pattern A1 74 Table 4.6 Association Rule for Pattern B1 76 Table 4.7 Association Rule for Pattern C 77 Table 4.8 Association Rule for Pattern A2 80 Table 4.9 Association Rule for Pattern B2 81 |
參考文獻 |
Adrian Payne & Pennie Frow (2004), "The role of multichannel integration in customer relationship management", Industrial Marketing Management Vol. 33 pp.527-538 Adrian Payne & Pennie Frow (2005) "A Strategic Framework for Customer Relationship Management" Journal of Marketing Vol. 69, pp.167-176 Angel Robert (2003), "A new dawn for CRM: This time it's B2B", Ivey Business Journal Online, http://www.iveybusinessjournal.com/article.asp?intArticle_ID=430 Babak Sohrabi & Amir Khanlari (2007), “Customer Lifetime Value (CLV) Measurement Based on RFM Model”, Iranian Accounting & Auditing Review, Spring 2007,Vol. 14 No. 47, pp 7- 20 Becerra-Fernandez, Irma;Gonzalez, Avelino;Sabherwal, Rajiv (2004), “Knowledge Management: Challengers, Solutions, and Technologies” Prentice Hall Berson, Alex, & Smith, Stephen J. (1997). Data Warehousing, Data Mining, & OLAP, McGraw-Hill, New York. Berry, M. J. A., & Linoff, G. (1997), "Data Mining Technique for Marketing, Sale, and Customer Support", Wiley Computer. Bitran, G.R. & Mondschein, S.V. (1997), 'A Comparative Analysis of Decision Making Procedures in The Catalog Sales Industry', European Management Journal, 15 (2). Bush, R. (2002), The Interactive and Direct Marketing Guide, Chapter 3.6, The Institute of Direct Marketing, Middlesex. Chablo E (1999), Marketing Director, smartFOCUS Limited. The importance of marketing data intelligence in delivering successful CRM, http://www.crm-forum.com/crm-forum-white-papers/mdi/sld01.htm Chang, J. (2002), "The Customer Relationship Management Solutions Guide, Chapter 1, CRMGuru.com. Chang, Pei-Chann, Tsai, Jie-Yuan & Hsieh, Jih-Chang (2002), "Application of data mining to customer relationship management - the case of cosmetics," Journal of the Chinese Institute of Industrial Engineers, Vol.19, pp.45-59 Chen, Shin-Yu (2001), "Research of Customer Knowledge Content and Relationship Marketing", Graduate Institute of Management Business Administration, National Chung Cheng University (in Chinese) Chen, Shu-Mei (2002), "Integrated Operations of Product R&D, Marketing and Knowledge Management - A Case Study of Chinese and Japanese Joint Venture in Taiwan" Master Dissertation, Chung-Yuan University (in Chinese) Chen, Yin-Ju (2002), "The Study of Electronic Catalogo Marketing Implements in the Retailing Commerce" National Defense Management College (in Chinese). Chris Rygieski, Jyun-Cheng Wag, & David C. Chen (2002) "Data mining techniques for customer relationship management" Technology in Society Vol.24, pp.483-502 Collins, K.(2001), "Analytical CRM: Driving Profitable Customer Relationships", Strategic Planning, SPA-12-7120 Deck (2001). “What is CRM?”, Darwin online. D. Peppers & M. Rogers (1993), “The One to One Future”, DoubleDay, Division of Bantam, DoubleDay, Dell Publishing Group, New York. D. Peppers, M. Rogers, B. Dorf (1999), “Is your company ready for oneto-one marketing?” Harvard Business Review 77 (1) pp.151-160. D.L. Goodhue, B.H. Wixom, H.J. Watson (2002), Realizing business benefits through CRM: hitting the right target in the right way, MIS Quarterly Executive 1 (2) pp.79-94. Freeman M. (1999) "The 2 customer lifecycles", Intelligent Enterprise (16):9. Glenn B. Voss & Zannie Giraud Voss (1997) "Implementing a relationship marketing program: a case study and managerial implications", The Journal of Services Marketing, Vol. 11, NO. 4 pp.279 Goodhue, D.L., Wixom, B.H., & Watson, H. J. (2002), "Realizing business benefits through CRM: Hitting the right target in the right way", MIS Quarterly Executive, 1(2), pp. 79-94. Hsiao, Shih Chung, (2007), "The Research of Data Mining Techniques Applied to One-to-One Marketing of Information Appliance", Graduate Institute of Management Sciences, Tamkang University. Hsu, Chih Yuan (2004) "A study on the relation between Market-Oriented, Relationship Marketing, Customer Relationship Management versus Business Capital", National Chung-Shin University, Business Administration Department (in Chinese) Huang, Shui-Ping (2005), "A study of Association Rule Implementation on the New Product Development of Cosmetic and Electronic Catalog Design", Graduate Institute of Management Sciences, Tamkang University. (in Chinese) Injazz J. Chen & Karen Popovich (2003), "Understanding Customer Relationship Management (CRM) People, process and technology", Business Process Management Journal, Vol. 9 No. 5, 2003, pp. 672-688 Inmon, W. H. (1997). "Managing the Data Warehouse". John Wiley & Sons. J.S.K. Ang, T.S.H. Teo (2000), "Management issues in data warehousing: insights from the Housing and Development Board", Decision Support Systems 29 (1) pp.11-20. James Edward Richard (2008) "The Impact of Customer Relationship Management (CRM) Technology on Business-to-Business Customer Relationships", Victoria University of Wellington Jayanthi Ranjan (2008), "A Review of Data Mining Tools In Customer Relationship Management", Journal of Knowledge Management Practice, Vol. 9 Jeanne Rossomme (2003) "Customer Satisfaction Measurement in a business-2-business context: a conceptual framework", Journal of Business and Industrial Marketing, Vol 18, No. 2, pp 179-195 L. Ryals & A. Payne (2001), "Customer relationship management in financial services: towards information enabled relationship marketing", Journal of Strategic Marketing 9 (1) pp. 4-27. Landry, L.(1998), "Relationship Marketing : Hype or Here to Stay", Marketing News , 32(14), p.4. Lee, Chia-Chen (2005), "A study of Association Rule Implementation on Brand and Cross-Industry Alliances", Graduate Institute of Management Sciences, Tamkang University (in Chinese) Liao, Shu-hsien , Chang Wen-jung , Lee, & Chai-chen (2008), "Mining marketing maps for business alliances" Expert Systems with Applications - ESWA Liliana L. Bove & Lester W. Johnson (2000), "A customer-service worker relationship model", International Journal of Service Industry Management, Vol. 11, pp. 491-511 Lin, Wan-Chun, (2003), "A Customer Relationship Management Study from Customer Knowledge Competence Perspective" National Chiao-Tung University (In Chinese) Lu, Hao-Ming (2001)," The Application of Customer Relationship Management System: The Case of Retail Business", Department of Industrial Engineering and Management, I-Shou University (in Chinese) Margarida Duarte & Gary Davies (2003), "Testing the conflict-performance assumption in business-to-business relationships", Industrial Marketing Management Vol. 32 pp.91-99 Maria Holmlund (2004), "Analyzing business relationship and distinguishing different interaction levels", Industrial marketing management 33 pp.279-287 Mark Xu & John Walton (2005), "Gaining customer knowledge through analytical CRM", Department of Strategy & Business Systems, Portsmouth Business School, University of Portsmouth, Portsmouth, UK. Melinda Nykamp (2001), "The Customer Differential: The Complete Guide to Implementing Customer Relationship Management", AMACOM, a division of American Management Association, NY Michael Ehret (2004), "Managing the trade-off between relationships and value networks. Toward a value-based approach of customer relationship management in business-to-business markets", Industrial Marketing Management Vol.33 pp.464-473 N.C. Romano (2000), "Customer relations management in information systems research", Proceedings of the Americas' Conference on Information Systems, August 10-13, pp. 811-819. Peter D. Haden, Olivier Sibony, & Kevin D. Sneader (2004), "New Strategies for consumer goods", The McKinsey Quarterly, Web exclusive, December 2004 Rahman Ljaz Dar & Yongchao Hu (2005), "How Banks Manage CRM", Master Thesis, Department of Business Administration and Social Sciences, Division of Industrial Marketing and E-commerce, Lulea University of Technology Rakesh Agrawal , Tomasz Imieliński & Arun Swami (1993), “Mining association rules between sets of items in large databases”, Proceedings of the 1993 ACM SIGMOD international conference on Management of data, pp.207-216 Richard, James E., Thirkell, Peter C. & Huff, Sid L. (2007) "An Examination of Customer Relationship Management (CRM) Technology Adoption and its Impact on Business-to-Business Customer Relationships", Total Quality Management & Business Excellence,Vol.18:8, pp.927 - 945 S.L. Pan & J.N. Lee (2003), "Using e-CRM for a unified view of the customer", Communications of the ACM 46 (4) 95. Samiee, S. & Walters, P. G. P. (2003). "Relationship marketing in an international context: a literature review". International Business Review, 12(2), pp. 193-214 Sandy D. Jap, Chris Manolis & Barton A. Weitz (1999), "Relationship Quality and Buy-Seller Interaction in Channels of Distribution", Journal of Business Research Vol.46 pp.303-313 Shaw, M. et el. (2001), "Knowledge Management and Data Mining in Marketing", Decision Support Systems, Vol.31, pp.127-137. Shu, Je-Wei (2002),"The Application of Data Mining and Multivariate Statistics Methods on Database Marketing : A Case Study of Cosmetics Industry" National Taipei University (in Chinese) Srivastava. J., Wang, J.H., Lim, E.P. & Hwang, S.Y. (2002), 'A Case for Analytical Customer Relationship Management', PAKDD 2002, pp. 14-27. Stavros P. Kalafatis(2000), "Buyer-seller relationships along channels of distribution", Industrial Marketing Management Vol.31 pp.215-228 Stringfellow, A., Nie, W. & Bowen, D.E. (2004), "CRM: Profiting From Understanding Customer Needs”, Business Horizons, 47/5, pp. 45-52. Surajit Chaudhuri & Umeshwar Dayal (1997), "An Overview of Data Warehousing and OLAP Technology", ACM Sigmod record, 1997 - portal.acm.org T. Puschmann & R. Alt (2001), "Customer relationship management in the pharmaceutical industry", Proceedings of the 34th Hawaii International Conference on System Science, 2333 -2341 The Catalyst CRM Methodology: An overview, European Centre for Customer Strategies 2001 Thompson S.H. Teo, Paul Devadoss, & Shan L. Pan (2006), "Towards a holistic perspective of customer relationship management (CRM) implementation: A case study of the Housing and Development Board, Singapore", Decision Support Systems 42, pp.1613-1627 Tien, Shih-Chiung (2005), "Cross-Selling Strategy for Customer Relationship Management in the Insurance Industry", National Cheng Kung University Tiwana, Amrit (2000), Knowledge-Enabled Customer Relationship Management. Cutter IT Journal, Vol. 13, No. 10, pp. 17-25. Tom O'Toole & Bill Donaldson (2002), "Relationship performance dimension of buyer-supplier exchanges", European Journal of Purchasing & supply management 8 pp.192-207 V. Kumar & Werner J. Reinartz (2006),"Customer Relationship Management: A Databased Approach", New York, NY, John Wiley & Sons, Inc. Vikas Kharbanda & Parthasarathi Dasgupta, "Data Mining for Customer Relationship Management" Wang, Jhih-Cyun (2005), "CRM Performance Evaluation", Management of Business Administration Department, National Central University (in Chinese) Wolfgang Ulaga (2003), "Capturing value creation in business relationships: A customer perspective", Industrial Marketing Management 32 pp. 677-693 Y. Xu, David C. Yen, B.S. Lin, & David C. Chou, “Adopting Customer Relationship Management Technology,” Industrial Management and Data Systems, 2002, 102(8), pp. 442-452. Zheng Yun E., Wen, H.Joseph & Yen David C. (2003), "Customer Relationship Management (CRM) in business-to-business e-commerce", Information Management & Computer Security, Vol. 11, pp. 39-44 |
論文全文使用權限 |
如有問題,歡迎洽詢!
圖書館數位資訊組 (02)2621-5656 轉 2487 或 來信