Retail Analytics - Inventory
Table Name: retail_analytics_inventory
The Retail Analytics Inventory table provides daily, weekly and monthly snapshots of Amazon’s inventory of your products. It is the main source for understanding sellable vs. unsellable inventory levels, aging, out of stock rates (Procurable OOS), and unhealthy inventory levels (as defined by Amazon).
*Note: some metrics are provided for WEEKLY and MONTHLY periods only, and are not available for DAILY:
- sell_through_rate
- unhealthy_inventory
- unhealthy_units
Most data in this table is ‘snapshot’ data, meaning that it should not be summed/aggregated. Instead, the value for the most recent date within the time period should be used. The exceptions are net_received and net_received units, which should be aggregated by PERIOD over the time-span of interest. See example query below for more information.
‘Procurable Product OOS’ and ‘unfilled_customer_order_units’ are only provided for Distributor View = ‘Manufacturing’, and are not available in Sourcing view.
Business questions & scenarios
What is this data useful for?
- Inventory coverage: How many weeks of cover does Amazon have for my key products?
- Understock: What products are we missing sales for because Amazon runs out of stock? How much pent up demand is there?
- Overstock: What are my unhealthy and aged products, where Amazon is likely to ask for cost support or a RMA?
