Analisis Customer Retention Dalam Ritel Online Data United States E-Commerce Records 2020

Andy Hermawan; Muhamad Fauzi Hakim; B Hilda Nida Alistiqlal; Bagas Dio Hanggoro

doi:10.61132/jiesa.v1i4.276

Authors

Andy Hermawan Universitas Indraprasta PGRI
Muhamad Fauzi Hakim Purwadhika Digital Technology School
B Hilda Nida Alistiqlal Purwadhika Digital Technology School
Bagas Dio Hanggoro Purwadhika Digital Technology School

DOI:

https://doi.org/10.61132/jiesa.v1i4.276

Keywords:

e-commerce, customer retention, cohort retention, data analysis, promotional strategies, customer loyalty, United States

Abstract

This study investigates the level of customer loyalty in e-commerce in the United States in 2020. Using e-commerce customer data from 2020 available on Kaggle, this research analyzes cohort retention to understand the number of customers from each cohort who continue to make purchases in subsequent months. Additionally, this study evaluates the implementation of data analysis to assess the effectiveness of promotional strategies and their impact on customer loyalty and retention. The results show that retention percentages decline over time, with the number of active customers decreasing after registration. However, some cohorts exhibit better retention performance. For instance, the April cohort saw a significant increase from 18.46% to 29.23%, and the May cohort experienced the highest increase from 14.29% to 30.16%. On the other hand, the January cohort showed the most drastic retention drop from 100% to 10.42% after the first month, with the largest monthly decline from 23.96% in April to 7.29% in May. These findings provide practical guidance for e-commerce companies in developing more effective strategies to improve customer retention. Further analysis is recommended to understand the specific causes of these retention trends and to develop more holistic strategies to support better business decisions and increase long-term profitability.

References

Anderson, M., & Lee, S. (2017). Analyzing cohort data in digital marketing. Journal of Marketing Analytics, 4(3), 189-204.

Aparicio, D., Metzman, Z., & Rigobon, R. (2024). The pricing strategies of online grocery retailers. Quantitative Marketing and Economics, 22(1), 1-21.

Ascarza, E. (2018). Retention futility: Targeting high-risk customers might be ineffective. Journal of Marketing Research, 55(1), 80–98.

Brown, A. (2018). The impact of retention strategies in e-commerce. Journal of Business Research, 62(2), 133-145.

Carlo, S., & Batini, M. (2018). Data and information quality: Dimensions, principles and techniques. Springer.

Donthu, N., & Gustafsson, A. (2020). Effects of COVID-19 on business and research. Journal of Business Research, 117, 284-289.

Fatihudin, D., & Firmansyah, A. (2019). Pemasaran jasa (strategi, mengukur kepuasan dan loyalitas pelanggan). Deepublish.

Fedushko, S., & Ustyianovych, T. (2022). E-commerce customers behavior research using cohort analysis: A case study of COVID-19. Journal of Open Innovation: Technology, Market, and Complexity, 8(1), 12.

Gonzalez, M., & Rabbi, F. (2023). Evaluating the impact of big data analytics on personalized e-commerce shopping experiences and customer retention strategies. Journal of Computational Social Dynamics, 8(2), 13-25.

Hadley, W., & Garrett, G. (2016). R for data science: Import, tidy, transform, visualize, and model data. O'Reilly Media, Inc.

Hanaysha, J. R. (2018). Customer retention and the mediating role of perceived value in the retail industry. World Journal of Entrepreneurship, Management and Sustainable Development, 14(1), 2–24.

Hung, P. H., Doi, K., & Inoi, H. (2020). User retention tendency of bus routes based on user behavior transition in an area with low mode share of public transport.

Joel, L. O., Doorsamy, W., & Paul, B. S. (2022). A review of missing data handling techniques for machine learning. International Journal of Innovative Technology and Interdisciplinary Sciences, 5(3), 971-1005.

Johnson, K. (2019). Customer cohort analysis in practice. Journal of Consumer Behavior, 15(1), 29-37.

Kim, J. (2019). The impact of different price promotions on customer retention. Journal of Retailing and Consumer Services, 46(October), 95–102.

Kotsiantis, S. B., Kanellopoulos, D., & Pintelas, P. E. (2006). Data preprocessing for supervised learning. International Journal of Computer Science, 1(2), 111-117.

McKinney, W. (2013). Python for data analysis. O'Reilly Media, Inc.

Meyer, D. (2016). Advanced techniques in cohort analysis. Journal of Data Science, 14(2), 223-237.

Rahman, M. G., & Islam, M. Z. (2013). Missing value imputation using decision trees and decision forests by splitting and merging records: Two novel techniques. Knowledge-Based Systems, 53, 51-65.

Seo, D. B., Ranganathan, C., & Babad, Y. (2008). Two-level model of customer retention in the US mobile telecommunications service market.

Shmueli, G., Bruce, P. C., Yahav, I., Patel, N. R., & Lichtendahl Jr, K. C. (2017). Data mining for business analytics: Concepts, techniques, and applications in R. John Wiley & Sons.

Tamuliene, V., & Gabryte, R. (2014). Factors influencing customer retention: A theoretical model. Business and Management Review, 5(1), 23-31.

Van Buuren, S., & Groothuis-Oudshoorn, K. (2011). mice: Multivariate imputation by chained equations in R. Journal of Statistical Software, 45, 1-67.

Xhema, J., Groumpos, P. P., & Metin, H. (2018). Switching-costs, corporate image and product quality effect on customer loyalty: Kosovo retail market. IFAC-PapersOnLine, 51(30), 51-55.

Zelalem Jembre, Y., Jung, W. Y., Attique, M., Paul, R., & Kim, B. (2022). Mobile broadband performance evaluation: Analysis of national reports. Electronics, 11(3), 485.

Zhang, Z. (2016). Missing data imputation: Focusing on single imputation. Annals of Translational Medicine, 4(1).