IDEAS home Printed from https://ideas.repec.org/a/eee/joreco/v79y2024ics0969698924001644.html
   My bibliography  Save this article

Mining spatial-temporal patterns from customer data to improve forecasting of customer flow across multiple sites

Author

Listed:
  • Liu, Hsiu-Wen

Abstract

Using a Generalized Additive Model, this study develops a novel framework to forecast hourly customer flow across multiple locations. Analyzing two years of hourly data with over 1.4 million customer visits across 106 metro stations, the model demonstrates strong potential for accurate, multi-step ahead predictions of spatial-temporal customer traffic patterns. The model provides robust forecasts to support resource planning and service levels by identifying spatial and temporal patterns in flow dynamics. The economic insights into flow dynamics and productivity possibilities enable retail headquarters to efficiently allocate staff and inventory to satisfy customers at each store. The research contributes a cost-effective city-wide hourly customer flow forecasting technique for multi-outlet retailers such as convenience stores and fast food chains.

Suggested Citation

  • Liu, Hsiu-Wen, 2024. "Mining spatial-temporal patterns from customer data to improve forecasting of customer flow across multiple sites," Journal of Retailing and Consumer Services, Elsevier, vol. 79(C).
  • Handle: RePEc:eee:joreco:v:79:y:2024:i:c:s0969698924001644
    DOI: 10.1016/j.jretconser.2024.103868
    as

    Download full text from publisher

    File URL: http://www.sciencedirect.com/science/article/pii/S0969698924001644
    Download Restriction: Full text for ScienceDirect subscribers only

    File URL: https://libkey.io/10.1016/j.jretconser.2024.103868?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Jiang, Renna & Manchanda, Puneet & Rossi, Peter E., 2009. "Bayesian analysis of random coefficient logit models using aggregate data," Journal of Econometrics, Elsevier, vol. 149(2), pages 136-148, April.
    2. Ye, Zi & Clarke, Graham & Newing, Andy, 2021. "Estimating small-area demand of urban tourist for groceries: The case of Greater London," Journal of Retailing and Consumer Services, Elsevier, vol. 58(C).
    3. Daniel, Christopher & Hernandez, Tony, 2024. "What retail apocalypse? A Delphi forecast of commercial space demand in the Toronto region," Journal of Retailing and Consumer Services, Elsevier, vol. 77(C).
    4. Daniel S. Putler & Shilpa Lele, 2003. "An Easily Implemented Framework for Forecasting Ticket Sales to Performing Arts Events," Marketing Letters, Springer, vol. 14(4), pages 307-320, December.
    5. Tian, Xin & Wang, Haoqing & E, Erjiang, 2021. "Forecasting intermittent demand for inventory management by retailers: A new approach," Journal of Retailing and Consumer Services, Elsevier, vol. 62(C).
    6. Adam N. Smith & Peter E. Rossi & Greg M. Allenby, 2019. "Inference for Product Competition and Separable Demand," Marketing Science, INFORMS, vol. 38(4), pages 690-710, July.
    7. Michael Haenlein & Mary Jo Bitner & Ajay K. Kohli & Katherine N. Lemon & David J. Reibstein, 2022. "Guest Editorial: Responsible Research in Marketing," Journal of the Academy of Marketing Science, Springer, vol. 50(1), pages 8-12, January.
    8. Greg M. Allenby & Peter E. Rossi, 1991. "Quality Perceptions and Asymmetric Switching Between Brands," Marketing Science, INFORMS, vol. 10(3), pages 185-204.
    9. Veiga, Claudimar Pereira da & Veiga, Cássia Rita Pereira da & Puchalski, Weslly & Coelho, Leandro dos Santos & Tortato, Ubiratã, 2016. "Demand forecasting based on natural computing approaches applied to the foodstuff retail segment," Journal of Retailing and Consumer Services, Elsevier, vol. 31(C), pages 174-181.
    10. Simon N. Wood, 2011. "Fast stable restricted maximum likelihood and marginal likelihood estimation of semiparametric generalized linear models," Journal of the Royal Statistical Society Series B, Royal Statistical Society, vol. 73(1), pages 3-36, January.
    11. Jean-Pierre Dubé & Günter J. Hitsch & Peter E. Rossi, 2018. "Income and Wealth Effects on Private-Label Demand: Evidence from the Great Recession," Marketing Science, INFORMS, vol. 37(1), pages 22-53, January.
    12. Peter E. Rossi & Greg M. Allenby, 2003. "Bayesian Statistics and Marketing," Marketing Science, INFORMS, vol. 22(3), pages 304-328, July.
    13. Nematollahi, Mohammadreza & Hosseini-Motlagh, Seyyed-Mahdi & Pazari, Parvin, 2024. "Analytical insights into coordination and competition in dual-channel supply chains: A multi-factor dependent demand perspective," Journal of Retailing and Consumer Services, Elsevier, vol. 78(C).
    14. Pradeep Chintagunta & Jean-Pierre Dubé & Vishal Singh, 2003. "Balancing Profitability and Customer Welfare in a Supermarket Chain," Quantitative Marketing and Economics (QME), Springer, vol. 1(1), pages 111-147, March.
    15. Erjiang E & Ming Yu & Xin Tian & Ye Tao, 2022. "Dynamic Model Selection Based on Demand Pattern Classification in Retail Sales Forecasting," Mathematics, MDPI, vol. 10(17), pages 1-16, September.
    16. Lackes, Richard & Siepermann, Markus & Vetter, Georg, 2020. "What drives decision makers to follow or ignore forecasting tools - A game based analysis," Journal of Business Research, Elsevier, vol. 106(C), pages 315-322.
    17. Li, Chenxi & Chen, Jing (Elaine) & Peng, Siyu & Huang, Jinsong & Sha, Xiqing, 2024. "Examining the effects of weather on online shopping cart abandonment: Evidence from an online retailing platform," Journal of Retailing and Consumer Services, Elsevier, vol. 78(C).
    18. Ma, Shaohui & Fildes, Robert, 2020. "Forecasting third-party mobile payments with implications for customer flow prediction," International Journal of Forecasting, Elsevier, vol. 36(3), pages 739-760.
    19. Ailawadi, Kusum L. & Farris, Paul W., 2017. "Managing Multi- and Omni-Channel Distribution: Metrics and Research Directions," Journal of Retailing, Elsevier, vol. 93(1), pages 120-135.
    20. Arunraj, Nari Sivanandam & Ahrens, Diane, 2015. "A hybrid seasonal autoregressive integrated moving average and quantile regression for daily food sales forecasting," International Journal of Production Economics, Elsevier, vol. 170(PA), pages 321-335.
    21. Xiuli Chao & Liming Liu & Shaohui Zheng, 2003. "Resource Allocation in Multisite Service Systems with Intersite Customer Flows," Management Science, INFORMS, vol. 49(12), pages 1739-1752, December.
    22. Hu, Jianhao & Zhang, Xuan & Chen, Hanyu(Yuki) & Li, Wanyue, 2024. "When it rains, it pours? The impact of weather on customer returns in the brick-and-mortar retail store," Journal of Retailing and Consumer Services, Elsevier, vol. 77(C).
    23. Datta, Alotosh & Sarkar, Biswajit & Dey, Bikash Koli & Sangal, Isha & Yang, Liu & Fan, Shu-Kai S. & Sardar, Suman Kalyan & Thangavelu, Lakshmi, 2024. "The impact of sales effort on a dual-channel dynamical system under a price-sensitive stochastic demand," Journal of Retailing and Consumer Services, Elsevier, vol. 76(C).
    24. Kris Johnson Ferreira & Bin Hong Alex Lee & David Simchi-Levi, 2016. "Analytics for an Online Retailer: Demand Forecasting and Price Optimization," Manufacturing & Service Operations Management, INFORMS, vol. 18(1), pages 69-88, February.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2019. "Retail forecasting: research and practice," MPRA Paper 89356, University Library of Munich, Germany.
    2. Taheri, Seyed Ghiasuddin & Navabakhsh, Mehrzad & Tohidi, Hamid & Mohammaditabar, Davood, 2024. "A system dynamics model for optimum time, profitability, and customer satisfaction in omni-channel retailing," Journal of Retailing and Consumer Services, Elsevier, vol. 78(C).
    3. Tian, Xin & Wang, Haoqing & E, Erjiang, 2021. "Forecasting intermittent demand for inventory management by retailers: A new approach," Journal of Retailing and Consumer Services, Elsevier, vol. 62(C).
    4. Guhl, Daniel, 2019. "Addressing endogeneity in aggregate logit models with time-varying parameters for optimal retail-pricing," European Journal of Operational Research, Elsevier, vol. 277(2), pages 684-698.
    5. Ma, Shaohui & Fildes, Robert, 2021. "Retail sales forecasting with meta-learning," European Journal of Operational Research, Elsevier, vol. 288(1), pages 111-128.
    6. Inge Geyskens & Barbara Deleersnyder & Marnik G. Dekimpe & Didi Lin, 2024. "Do consumers benefit from national-brand listings by hard discounters?," Journal of the Academy of Marketing Science, Springer, vol. 52(1), pages 97-118, January.
    7. Carl F. Mela, 2011. "Structural Workshop Paper --Data Selection and Procurement," Marketing Science, INFORMS, vol. 30(6), pages 965-976, November.
    8. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2022. "Retail forecasting: Research and practice," International Journal of Forecasting, Elsevier, vol. 38(4), pages 1283-1318.
    9. Andrés Musalem & Marcelo Olivares & Eric T. Bradlow & Christian Terwiesch & Daniel Corsten, 2010. "Structural Estimation of the Effect of Out-of-Stocks," Management Science, INFORMS, vol. 56(7), pages 1180-1197, July.
    10. Ulrich, Matthias & Jahnke, Hermann & Langrock, Roland & Pesch, Robert & Senge, Robin, 2022. "Classification-based model selection in retail demand forecasting," International Journal of Forecasting, Elsevier, vol. 38(1), pages 209-223.
    11. Robert P. Rooderkerk & Nicole DeHoratius & Andrés Musalem, 2022. "The past, present, and future of retail analytics: Insights from a survey of academic research and interviews with practitioners," Production and Operations Management, Production and Operations Management Society, vol. 31(10), pages 3727-3748, October.
    12. Putsis, William Jr. & Dhar, Ravi, 2001. "An empirical analysis of the determinants of category expenditure," Journal of Business Research, Elsevier, vol. 52(3), pages 277-291, June.
    13. repec:hum:wpaper:sfb649dp2007-059 is not listed on IDEAS
    14. Gerhard Tutz & Moritz Berger, 2018. "Tree-structured modelling of categorical predictors in generalized additive regression," Advances in Data Analysis and Classification, Springer;German Classification Society - Gesellschaft für Klassifikation (GfKl);Japanese Classification Society (JCS);Classification and Data Analysis Group of the Italian Statistical Society (CLADAG);International Federation of Classification Societies (IFCS), vol. 12(3), pages 737-758, September.
    15. Rub'en Loaiza-Maya & Didier Nibbering, 2022. "Fast variational Bayes methods for multinomial probit models," Papers 2202.12495, arXiv.org, revised Oct 2022.
    16. Ali Hortacsu & Olivia R. Natan & Hayden Parsley & Timothy Schwieg & Kevin R. Williams, 2021. "Organizational Structure and Pricing: Evidence from a Large U.S. Airline," Cowles Foundation Discussion Papers 2312R, Cowles Foundation for Research in Economics, Yale University, revised Mar 2022.
    17. Greg Lewis & Bora Ozaltun & Georgios Zervas, 2021. "Maximum Likelihood Estimation of Differentiated Products Demand Systems," Papers 2111.12397, arXiv.org.
    18. Tommaso Luzzati & Angela Parenti & Tommaso Rughi, 2017. "Spatial error regressions for testing the Cancer-EKC," Discussion Papers 2017/218, Dipartimento di Economia e Management (DEM), University of Pisa, Pisa, Italy.
    19. Davide Fiaschi & Andrea Mario Lavezzi & Angela Parenti, 2020. "Deep and Proximate Determinants of the World Income Distribution," Review of Income and Wealth, International Association for Research in Income and Wealth, vol. 66(3), pages 677-710, September.
    20. Cai, Ya-Jun & Lo, Chris K.Y., 2020. "Omni-channel management in the new retailing era: A systematic review and future research agenda," International Journal of Production Economics, Elsevier, vol. 229(C).
    21. Snir, Avichai & Levy, Daniel, 2021. "If You Think 9-Ending Prices Are Low, Think Again," EconStor Open Access Articles and Book Chapters, ZBW - Leibniz Information Centre for Economics, vol. 6(1 (Forthc).

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:eee:joreco:v:79:y:2024:i:c:s0969698924001644. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Catherine Liu (email available below). General contact details of provider: https://www.journals.elsevier.com/journal-of-retailing-and-consumer-services .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.