Analysis of Web Log for e-CRM on B2B of the Make-To-Order Company

수주생산기업 B2B에서 e-CRM을 위한 웹 로그 분석

  • Go, Jae-Moon (School of Industrial Engineering, University of Ulsan) ;
  • Seo, Jun-Yong (School of Industrial Engineering, University of Ulsan) ;
  • Kim, Woon-Sik (School of Industrial Engineering, University of Ulsan)
  • 고재문 (울산대학교 산업정보경영공학부) ;
  • 서준용 (울산대학교 산업정보경영공학부) ;
  • 김운식 (울산대학교 산업정보경영공학부)
  • Received : 2004.12.27
  • Accepted : 2005.05.23
  • Published : 2005.06.30

Abstract

This study presents a web log analysis model for e-CRM, which combines the on-line customer's purchasing pattern data and transaction data between companies in B2B environment of make-to-order company. With this study, the customer evaluation and the customer subdivision are available. We can forecast the estimate demands with periodical products sales records. Also, the purchasing rate per each product, the purchasing intention rate, and the purchasing rate per companies can be used as the basic data for the strategy for receiving the orders in future. These measures are used to evaluate the business strategy, the quality ability on products, the customer's demands, the benefits of customer and the customer's loyalty. And it is used to evaluate the customer's purchasing patterns, the response analysis, the customer's secession rate, the earning rate, and the customer's needs. With this, we can satisfy various customers' demands, therefore, we can multiply the company's benefits. And we presents case of the 'H' company, which has the make-to-order manufacture environment, in order to verify the effect of the proposal system.

Keywords

References

  1. Agrawal R. and R. Srikanr(1994), Fast Algorithms for Mining Association Rules in Large Databases, Proceedings of the 20th International Conference on Very Large Databases
  2. Anderson, Eugene W., Claes Fornell, and Donald R. Lehmann (1994), Customer Satisfaction, Market Share, and Profitability : Findings from Sweden,Journal of Marketing, 58(July), 53-66
  3. Bae, Y. J.(2001), An Empirical Study on the Effectiveness of On-Line Multimedia Advertising Using Log File Analysis, Korea Univ. M.A. Thesis, Korea
  4. Basseville, M. and I. V. Nikiforov (1993), Customer lifetime value: marketing models and applications, ,Journal of Interactive marketing, 12(1), 17-30 https://doi.org/10.1002/(SICI)1520-6653(199824)12:1<17::AID-DIR3>3.0.CO;2-K
  5. Berry,J. (1994), Database marketing, Business Week, September, 56-62
  6. Berson, A., S. Smith and K. Thearling(2000), Building Data Mining Applications for CRM, McGraw-Hail
  7. Borges, J. and M. Levene(1999), Mining Navigarion Pattern Discovery from Internet Data, http://www.almaden.ibm.com/cs/quest
  8. Byun, S. E.(2001). Efficient Web Sire Management Srrategy By Analyzing Log Dara - Focus on rhe ABC Jeans company case, Korea Advanced Institute of Science and Technology M. A. Thesis, Korea
  9. Chang, Y K(2002), A Study on rhe Relarionship between Cusromer's Action and Customer's Value using Log analysis, Ajou Univ. M. A. Thesis, Korea
  10. Charles C Poirier, Michael J. Bauer (2001), e-SCM, SIGMA INSIGHT
  11. Choi, D. W. and Lee, K W.(2001), A Study on Web Personalization for the Recommendation of Commodities in Electronic Commerce, Spring Semiannual Conf. of The Korean O.R and M.S Society and The Korean Institute of Industrial Engineers, 446-449
  12. Cooley, R, Mobasher, Bamshad, Srivastava, J.(1999), Data Preparation for Mining World Wide Web Browsing Patterns, The Journal of Knowledge and Information Systems, 1(1)
  13. Daniel A. Menasce & Virgilio A.F. Almeida(2000), Scaling for E-Business :Technologies. Models, Performame, and Capacity Planning, Prentice Hall
  14. Fu, Y., K Sandhu and MY Shih(l999), Clustering of Web Users Based on Access Patterns, Proceedings of the Workshop on Web Usage Analysis and User Profiling (WEBKDD'99), San Diego, CA, August
  15. Holbrook, Morris B.(1994), The Nature of Customer Value. An Axiology of Services in the Consumption Experience, in Service Quality in New Directions in Theory and Practice, eds. Roland T. Rust and Richard L. Oliver, Sage Publications, 21-71
  16. Igor V. C, Scott G. and P. Smyth (2000), A general probabilistic framework for clustering individuals and objects, Proceedings of the sixth ACM SIGKDD international conference on Knowledge discovery and data mining, 140- 149
  17. Jun, H. C(2002), A Study on the Behavioral Patterns of the Internet Shopping Mall User Using Log File, Korea Advanced Institttte of Science and Technology M. A. Thesis, Korea
  18. Kim,J. W., Kang, T. G., Jun, H. S., Park, S. S., Lee, K M., Kim Y. K, Yoo, K J.(1998), Multiple Intelligent Agent Architecture for Personalized Advertisement and Information Services on Internet Shopping Mall, Proc. 19th Conf on the Korea Society of Management Information Systems, 117- 126
  19. Kim, S. H and Lee, Y H.(2000), Current Status and Future Research Directions in Supply Chain Management. IE lnterfaces, 13(3), 288-295
  20. Kim, S. H and Oh, S. H.(2002), The Effect of Customer Value on Customer Satisfaction and Repeat Purchase Intention. journal of the Korean Association of Industrial Business Administration, 17(1), 65-92
  21. Kim, W. J, Kim, J. I., Joo, Y J.(1996), Marketing lnformation Systems, Pakyoungsa, Korea
  22. Lee, H. Y(1999), Web Minign Using Common Logfiles, Korea Advanced Institute of Science and Technology M. A. Thesis, Korea
  23. Lee, J. H.(2003), Intelligent CRM application methodology for supplier companies in Business-to-business environments, Conf. of Korea Intelligent Information System Society, 1,226-229
  24. Lee, Y H(2001), SCM Theory and Practice on e-Business, Moonyounggak, Korea
  25. Mannila, H. and C Meek (2000), Global partial orders from sequential data, Proc. of the ACM SIGKDD international conference on Knowledge discovery and data mining, 161-168
  26. Mannila, H., Toivonen, H. and I. Verkamo (1997), Discovery of frequent episodes in event sequences, Department of Computer Science Series of Publications Report C-1997 -15
  27. Park, H S.(2000), Design and Development Web Log Analysis Preprocessor for 1 to 1 Marketing: the Case of J Bank, Korea Advanced Institute of Science and Technology M. A. Thesis, Korea
  28. Park, J. S., Chen, M. S. and P. S. Yu (1995), An Effective Hash-Based Algorithm for Mining Association Rules, Proceedings of ACM SIGMOD, 175-186
  29. Parr Rud, O. (2001), Data Mining Cookbook: Modeling Data for Marketing, Risk, and Customer Relationship Management, John Wiley and Sons
  30. Richard Lancioni, Hope Jensen Schau, Micael F. Smith(2002), Internet Impacts on Supply Chain Management, Industrial Marketing Management 5336
  31. Savasere A., Omiecinski E., and S. Navathe (1995), An Efficient Algorithm for Mining Association Rules in Large Databases, Proceedings ot the 21th International Conference on Very urge Databases, 432-444
  32. Shaw, M.J., C. Subramaniam, G. W. Tan and M. E. Welge (2001), Knowledge management and data mining for marketing, Decision Support Systems, 31,127-137 https://doi.org/10.1016/S0167-9236(00)00123-8
  33. Wang, P. and T. Spiegel (1994), Database marketing and its measurements of success: Designing a managerial instrument to calculate the value of a repear customer base, Journal of Direct Marketing, 8(2), 73-81 https://doi.org/10.1002/dir.4000080210
  34. Yi, J. S. and Ha, S. H.(2003), Customer Relationship Management Techniques Based on Dynamic Customer Analysis Utilizing Data Mining, Journal of Korea Intelligent Information System Society, 9(3), 23-47
  35. Yu, Y. M.(2004), The Effect of the Consistency between Supplier Selection Criteria and Customer Order Winning Criteria on the Supply Chain Performance, Journal of the Korean Production and Operations Management Society, 15(1),87-107