This table replaces data from forecast_and_inventory_ordered_units.
The forecast tables are Amazon’s demand forecast on how much product they anticipate customers will order during a given time period (not how much they anticipate ordering from a vendor).
Amazon provides 4 different forecasts, each broken out by 26 weeks: mean, P-70, P-80, & P-90. The P stands for "probability" and the number stands for a percentage of the statistical confidence interval. As an example at P-90, Amazon is 90% sure that customers will order up to the listed amount of product, while at P-70, Amazon is only 70% sure. As such P-90 represents Amazon's most aggressive forecast.
Generally, Amazon typically orders from vendors based on their P-70 level forecast.
Updated: WEEKLY
Backfill: Snapshot
How to use: This report should be filtered by:
- Distributor View (Manufacturing)
- Program: Amazon Retail
- Period (WEEKLY)
week_x_p90_forecast
week_x_p80_forecast
week_x_p70_forecast
week_x_mean_forecast
Data Dictionary
