Abstract:Ads demand forecasting for Walmart's ad products plays a critical role in enabling effective resource planning, allocation, and management of ads performance. In this paper, we introduce a comprehensive demand forecasting system that tackles hierarchical time series forecasting in business settings. Though traditional hierarchical reconciliation methods ensure forecasting coherence, they often trade off accuracy for coherence especially at lower levels and fail to capture the seasonality unique to each time-series in the hierarchy. Thus, we propose a novel framework "Multi-Stage Hierarchical Forecasting Reconciliation and Adjustment (Multi-Stage HiFoReAd)" to address the challenges of preserving seasonality, ensuring coherence, and improving accuracy. Our system first utilizes diverse models, ensembled through Bayesian Optimization (BO), achieving base forecasts. The generated base forecasts are then passed into the Multi-Stage HiFoReAd framework. The initial stage refines the hierarchy using Top-Down forecasts and "harmonic alignment." The second stage aligns the higher levels' forecasts using MinTrace algorithm, following which the last two levels undergo "harmonic alignment" and "stratified scaling", to eventually achieve accurate and coherent forecasts across the whole hierarchy. Our experiments on Walmart's internal Ads-demand dataset and 3 other public datasets, each with 4 hierarchical levels, demonstrate that the average Absolute Percentage Error from the cross-validation sets improve from 3% to 40% across levels against BO-ensemble of models (LGBM, MSTL+ETS, Prophet) as well as from 1.2% to 92.9% against State-Of-The-Art models. In addition, the forecasts at all hierarchical levels are proved to be coherent. The proposed framework has been deployed and leveraged by Walmart's ads, sales and operations teams to track future demands, make informed decisions and plan resources.

A Flexible Forecasting Framework for Hierarchical Time Series with Seasonal Patterns: A Case Study of Web Traffic.

Efficient Forecasting of Large Scale Hierarchical Time Series via Multilevel Clustering

SLOTH: Structured Learning and Task-Based Optimization for Time Series Forecasting on Hierarchies

Forecasting Hierarchical Time Series

End-to-End Modeling Hierarchical Time Series Using Autoregressive Transformer and Conditional Normalizing Flow based Reconciliation

End-to-End Modeling of Hierarchical Time Series Using Autoregressive Transformer and Conditional Normalizing Flow-based Reconciliation

Flow-Based End-to-End Model for Hierarchical Time Series Forecasting via Trainable Attentive-Reconciliation

Large Scale Hierarchical Industrial Demand Time-Series Forecasting incorporating Sparsity

Enhancing Time Series Forecasting: A Hierarchical Transformer with Probabilistic Decomposition Representation

A Comprehensive Forecasting Framework based on Multi-Stage Hierarchical Forecasting Reconciliation and Adjustment

Spatio-temporal Hierarchical MLP Network for Traffic Forecasting

A Hybrid Approach with Step‐size Aggregation to Forecasting Hierarchical Time Series

Instance-wise Graph-based Framework for Multivariate Time Series Forecasting

CALTM: A Context-Aware Long-Term Time-Series Forecasting Model

A cross-temporal hierarchical framework and deep learning for supply chain forecasting

Big Data Analytics for Network Level Short-Term Travel Time Prediction with Hierarchical LSTM

Robust and Hierarchical Spatial Relation Analysis for Traffic Forecasting.

A Bayesian Model for Forecasting Hierarchically Structured Time Series

Real-Time Prediction of Seasonal Heteroscedasticity in Vehicular Traffic Flow Series.

MSFS: Multiple Spatio-temporal Scales Traffic Forecasting in Mobile Cellular Network.

Hierarchical Forecasting at Scale