Vendor Scorecard Metrics — Table & Column Mapping

Overview

This page documents where the four Amazon Vendor Scorecard metrics live in the Reason database, and how to approach a YTD calculation. Originally surfaced via a CFS client inquiry (June 2026).

Metric → Table → Column Mapping

Metric	Table	Column
Out of Stock (OOS)	`retail_analytics_kpis_daily`	`proc_oos_weekly` / `proc_oos_monthly`
	`retail_analytics_inventory`	`procurable_product_oos` (+ prior period & YoY)
	`retail_analytics_inventory_summary`	`procurable_product_oos` (aggregated, no ASIN)
Confirmation Rate	`retail_analytics_inventory`	`vendor_confirmation_rate` (+ prior period & YoY)
	`retail_analytics_inventory_summary`	`vendor_confirmation_rate` (aggregated, no ASIN)
Fill Rate	`retail_analytics_inventory`	`receive_fill_rate` (+ prior period & YoY)
	`retail_analytics_inventory_summary`	`receive_fill_rate` (aggregated, no ASIN)
Vendor Lead Time (VLT)	`retail_analytics_inventory`	`overall_vendor_lead_time_days` (+ prior period & YoY)
	`retail_analytics_inventory_summary`	`overall_vendor_lead_time_days` (aggregated, no ASIN)

Notes:

retail_analytics_inventory → ASIN-level detail with prior period and year-over-year variants for each metric
retail_analytics_inventory_summary → rolled up by date/period/distributor, no ASIN breakdown; available periods are Daily, Weekly, and Monthly
retail_analytics_kpis_daily → OOS also available here as a pre-computed weekly/monthly rate

YTD Calculation

A native YTD period is not stored in the database. The available periods in retail_analytics_inventory_summary are Daily, Weekly, and Monthly.

Simple approach (approximate)

Average the monthly values from January through the most recent month. This is not volume-weighted, so results may vary if volume fluctuates significantly across months.

Precise approach — Fill Rate

Fill Rate can be reconstructed precisely because its numerator (net_received_units) is available on the summary table. Back into implied units ordered per month, then aggregate:

SELECT
  SUM(net_received_units) /
  SUM(net_received_units / NULLIF(receive_fill_rate, 0)) AS ytd_fill_rate
FROM public.retail_analytics_inventory_summary
WHERE period = 'MONTHLY'
  AND date >= '2026-01-01';

This reconstructs the rate from its components rather than averaging rates directly.

⚠️ Caveat: We cannot guarantee these YTD figures will match what Amazon displays in Vendor Central. Amazon's methodology for computing YTD rollups is not fully transparent.