Segmentation using Customers Lifetime Value: Hybrid K-means Clustering and Analytic Hierarchy Process
Downloads
Background: Understanding customers' electricity consumption patterns is essential for developing predictive analytics, which is needed for effective supply and demand management.
Objective: This study aims to understand customers' segmentation and consumption behaviour using a hybrid approach combining the K-Means clustering, customer lifetime value concept, and analytic hierarchy process.
Methods: This study uses more than 16 million records of customers' electricity consumption data from January 2019 to December 2020. The K-Means clustering identifies the initial market segments. The results were then evaluated and validated using the customer lifetime value concept and analytical hierarchy process.
Results: Three customer segments were identified. Segment 1 has 282 business customers with a total capacity of 938,837 kWh, peak load usage of 27,827 kWh, and non-peak load usage of 115,194 kWh. Segment 2 has 508,615 business customers with a total capacity of 4,260 kWh, a peak load of 35 kWh, and a non-peak load of 544 kWh. Segment 3 has 37 business customers with a total capacity of 2,226,351 kWh, a peak load of 123.297 kWh, and a non-peak load of 390,803.
Conclusion: A business strategy that could be taken is to base customer relationship management (CRM) on the three-customer segmentation. For the least profitable segment, aside from retail account marketing, a continuous partnership program is needed to increase electricity consumption during the non-peak period. For the highly and moderately profitable segments, a premium business-to-business approach can be applied to accommodate their increasing energy consumption without excessive electricity use in the peak period. Special account executives need to be deployed to handle these customers.
Katadata, "National Electricity Consumption Continues to Increase," www.databook.com, Jan. 09, 2020. https://databoks.katadata.co.id/datapublish/2020/01/10/konsumsi-listrik-nasional-terus-meningkat (accessed Jan. 04, 2022).
F. McLoughlin, A. Duffy, and M. Conlon, "A clustering approach to domestic electricity load profile characterization using smart metering data," Appl Energy, vol. 141, pp. 190–199, Mar. 2015, doi: 10.1016/j.apenergy.2014.12.039.
P. Park, D. Kim, S. Lee, and J. Whang, "Toward an economically sustainable casino industry: A development of customer value indicators using an analytic hierarchy process," Sustainability (Switzerland), vol. 10, no. 11, Nov. 2018, doi: 10.3390/su10114255.
A. Camero, G. Luque, Y. Bravo, and E. Alba, "Customer segmentation based on the electricity demand signature: The andalusian case," Energies (Basel), vol. 11, no. 7, 2018, doi: 10.3390/en11071788.
E. Lee, J. Kim, and D. Jang, "Load profile segmentation for effective residential demand response program: Method and evidence from Korean pilot study," Energies (Basel), vol. 16, no. 3, Mar. 2020, doi: 10.3390/en13061348.
M. Jang, H. C. Jeong, T. Kim, and S. K. Joo, "Load profile-based residential customer segmentation for analyzing customer preferred time-of-use (Tou) tariffs," Energies (Basel), vol. 14, no. 19, Oct. 2021, doi: 10.3390/en14196130.
Z. J. Lee, C. Y. Lee, L. Y. Chang, and N. Sano, "Clustering and classification based on distributed automatic feature engineering for customer segmentation," Symmetry (Basel), vol. 13, no. 9, Sep. 2021, doi: 10.3390/sym13091557.
K. Gajowniczek and T. Zabkowski, "Simulation Study on Clustering Approaches for Short-Term Electricity Forecasting," Complexity, vol. 2018, Apr. 2018, doi: 10.1155/2018/3683969.
S. Bañales, R. Dormido, and N. Duro, "Smart meters time series clustering for demand response applications in the context of high penetration of renewable energy resources," Energies (Basel), vol. 14, no. 12, Jun. 2021, doi: 10.3390/en14123458.
H. Li, X. Yang, Y. Xia, L. Zheng, G. Yang, and P. Lv, "K-LRFMD: Method of Customer Value Segmentation in Shared Transportation Filed Based on Improved K-means Algorithm," in Journal of Physics: Conference Series, Jul. 2018, vol. 1060, no. 1. doi: 10.1088/1742-6596/1060/1/012012.
R. Gustriansyah, N. Suhandi, and F. Antony, "Clustering optimization in RFM analysis based on k-means," Indonesian Journal of Electrical Engineering and Computer Science, vol. 18, no. 1, pp. 470–477, 2019, doi: 10.11591/ijeecs.v18.i1.pp470-477.
F. Marisa, S. S. S. Ahmad, Z. I. M. Yusof, Fachrudin, and T. M. A. Aziz, "Segmentation model of customer lifetime value in Small and Medium Enterprise (SMEs) using K-Means Clustering and LRFM model," International Journal of Integrated Engineering, vol. 11, no. 3, pp. 169–180, 2019, doi: 10.30880/ijie.2019.11.03.018.
J. Ye, "Analysis on E-commerce Order Cancellations Using Market Segmentation Approach," in ACM International Conference
Proceeding Series, Jan. 2021, pp. 33–40. doi: 10.1145/3450588.3450596.
F. Abdi and S. Abolmakarem, "Customer Behavior Mining Framework (CBMF) using clustering and classification techniques," Journal of Industrial Engineering International, vol. 15, pp. 1–18, Dec. 2019, doi: 10.1007/s40092-018-0285-3.
Y. C. Tsao, M. Setiawati, T. Linh Vu, and A. Sudiarso, "Designing a supply chain network under a dynamic discounting-based credit payment program," RAIRO - Operations Research, vol. 55, no. 4, pp. 2545–2565, Jul. 2021, doi: 10.1051/ro/2021111.
M. J. Foncubierta-Rodríguez, F. Galiana-Tonda, and M. del Mar Galiana Rubia, "Chambers of Commerce: A new Management. The balanced scorecard approach for spanish chambers,” CIRIEC-Espana Revista de Economia Publica, Social y Cooperativa, no. 99, pp. 273–308, Jul. 2020, doi: 10.7203/CIRIEC-E.99.14602.
K. C. Rao, S. Velidandla, C. L. Scott, and P. Drechsel, "Business Models for Fecal Sludge Management in India," Resource Recovery & Reuse Series, vol. 18, 2020.
J. Gil-Quintana and E. Vida de León, "Educational influencers on instagram: Analysis of educational channels, audiences, and economic performance," Publications, vol. 9, no. 4, Dec. 2021, doi: 10.3390/publications9040043.
K. Kafkas, Z. N. Perdahçı, and M. N. Aydın, "Discovering customer purchase patterns in product communities: An empirical study on co-purchase behavior in an online marketplace," Journal of Theoretical and Applied Electronic Commerce Research, vol. 16, no. 7, pp. 2965–2980, Dec. 2021, doi: 10.3390/jtaer16070162.
N. Baniasadi, D. Samari, S. J. F. Hosseini, and M. O. Najafabadi, "Strategic study of total innovation management and its relationship with marketing capabilities in palm conversion and complementary industries," J Innov Entrep, vol. 10, no. 1, Dec. 2021, doi: 10.1186/s13731-021-00179-z.
W. Xie, B. Chen, F. Huang, and J. He, "Coordination Of A Supply Chain With A Loss-Averse Retailer Under Supply Uncertainty And Marketing Effort," Journal of Industrial and Management Optimization, vol. 17, no. 6, pp. 3393–3415, Nov. 2021, doi: 10.3934/jimo.2020125.
K. Borisavljević and G. Radosavljević, "Application of logistics model in analyzing relationship marketing in travel agencies," Zbornik Radova Ekonomskog Fakultet au Rijeci, vol. 39, no. 1, pp. 87–112, Jun. 2021, doi: 10.18045/zbefri.2021.1.87.
S. C. Daat, M. A. Sanggenafa, and R. Larasati, "The role of intellectual capital on financial performance of smes," Universal Journal of Accounting and Finance, vol. 9, no. 6, pp. 1312–1321, Dec. 2021, doi: 10.13189/ujaf.2021.090610.
J. Koponen, S. Julkunen, M. Gabrielsson, and E. B. Pullins, "An intercultural, interpersonal relationship development framework," International Marketing Review, vol. 38, no. 6, pp. 1189–1216, Oct. 2021, doi: 10.1108/IMR-11-2019-0267.
E. Kulej-Dudek, "Ecolabnet service packages as a response to the needs of manufacturing enterprises in the SME sector of the Baltic Sea Region," Production Engineering Archives, vol. 27, no. 4, pp. 265–271, Dec. 2021, doi: 10.30657/pea.2021.27.35.
Q. Yan, C. Qin, M. Nie, and L. Yang, "Forecasting the Electricity Demand and Market Shares in Retail Electricity Market Based on System Dynamics and Markov Chain," Math Probl Eng, vol. 2018, 2018, doi: 10.1155/2018/4671850.
T. B. Yudhya, "Retail store image: A study of the matahari department store (at Bandung Indonesia)," Humanities and Social Sciences Reviews, vol. 7, no. 5, pp. 98–102, Sep. 2019, doi: 10.18510/hssr.2019.7513.
F. M. Dias, M. P. V. de Oliveira, H. Z. Filho, and A. L. Rodrigues, "Analytical guidance or intuition? what guides management decisions on the most important customer value attributes in the supermarket retail?," Revista Brasileira de Marketing, vol. 20, no. 2, pp. 385–414, 2021, doi: 10.5585/REMARK.V20I2.16106.
S. Sekizaki, I. Nishizaki, and T. Hayashida, "Impact of Retailer and Consumer Behavior on Voltage in Distribution Network under Liberalization of Electricity Retail Market," Electrical Engineering in Japan (English translation of Denki Gakkai Ronbunshi), vol. 194, no. 4, pp. 27–41, Mar. 2016, doi: 10.1002/eej.22743.
G. Shmueli and O. R. Koppius, "Predictive Analytics in Information Systems," 2011.
R. Bapna, P. Goes, A. Gupta, and Y. Jin, "User Heterogeneity and Its Impact on Electronic Auction Market Design: An Empirical Exploration," 2004. [Online]. Available: http://www.jstor.orgStableURL:http://www.jstor.org/stable/25148623
A. Hosseini and R. Hosseini, "Model selection for count timeseries with applications in forecasting number of trips in bike-sharing systems and its volatility," Nov. 2020, [Online]. Available: http://arxiv.org/abs/2011.08389
M. Khajvand, K. Zolfaghar, S. Ashoori, and S. Alizadeh, "Estimating customer lifetime value based on RFM analysis of customer purchase behavior: Case study," in Procedia Computer Science, 2011, vol. 3, pp. 57–63. doi: 10.1016/j.procs.2010.12.011.
A. Hosseini, M. FallahNezhad, Y. ZareMehrjardi, and R. Hosseini, "Seasonal Autoregressive Models for Estimating the Probability of Frost in Rafsanjan,” Journal of Nuts, vol. 3, no. 2, pp. 45–52, 2012.
Copyright (c) 2022 The Authors. Published by Universitas Airlangga.
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
All accepted papers will be published under a Creative Commons Attribution 4.0 International (CC BY 4.0) License. Authors retain copyright and grant the journal right of first publication. CC-BY Licenced means lets others to Share (copy and redistribute the material in any medium or format) and Adapt (remix, transform, and build upon the material for any purpose, even commercially).
