Store sales evaluation and prediction using spatial panel data models of sales components

Auke Hunneman, J. Paul Elhorst*, Tammo H. A. Bijmolt

*Corresponding author for this work

Research output: Contribution to journalArticleAcademicpeer-review

11 Downloads (Pure)


This paper sets out a general framework for store sales evaluation and prediction. The sales of a retail chain with multiple stores are first decomposed into five components, and then each component is explained by store, competitor and consumer characteristics using random effects models for components observable at the store level and spatial error random effects models for components observable at the zip code level. We use spatial panel data over four years for estimation and a subsequent year for evaluating one-year-ahead predictions. Set against a benchmark model that explains total sales directly, the prediction error of our framework is reduced by 34% for existing stores during the sample period, by 5% for existing stores one year ahead and by 26% for new stores.

Original languageEnglish
Number of pages24
JournalSpatial Economic Analysis
Publication statusE-pub ahead of print - 17-May-2021


  • retailing
  • decomposition
  • sales components
  • loyalty programmes
  • spatial econometrics

Cite this