Amazon Replenishment Data
Technical reference for DataHawk's Subscribe & Save performance and forecast datasets, including table names, grain, fields, and deprecations.
This page is the technical reference for DataHawk's Amazon Subscribe & Save performance and forecast datasets. Use it when you need table names, grain, common fields, deprecation notes, or the source-of-truth column reference.
For business usage, metric interpretation, and inventory-planning examples, see Subscribe & Save Forecasting.
Available datasets
| Dataset | What it contains |
|---|---|
FBA_RESPLENISHMENT_SNS_PERFORMANCE | Historical Subscribe & Save performance data |
FBA_RESPLENISHMENT_SNS_FORECAST | Amazon's forward-looking Subscribe & Save projections |
Deprecated and empty: the legacy SELLING_PARTNER.FBA_SNS_PERFORMANCE_SRC and SELLING_PARTNER.FBA_SNS_FORECAST_SRC tables are no longer populated and are marked obsolete. Migrate any queries to the FBA_RESPLENISHMENT_SNS_* tables above. See the changelog entry.
Grain
Both datasets follow the same grain: 1 row = 1 ASIN x 1 marketplace x 1 time interval
Common fields
| Column | Description |
|---|---|
ASIN | Amazon Standard Identification Number |
MARKETPLACE_KEY | Marketplace identifier (e.g. Amazon-US) |
PRODUCT_KEY | DataHawk internal product identifier; use it to join with other DataHawk tables |
TIME_INTERVAL_START_DATE | Start of the period covered by the metrics |
TIME_INTERVAL_END_DATE | End of the period covered by the metrics |
CURRENCY_CODE | ISO currency code (USD, EUR, GBP, etc.) |
Field families
Use the Exhaustive Column Referential for the complete, current field list. At a high level:
| Dataset | Field families |
|---|---|
FBA_RESPLENISHMENT_SNS_PERFORMANCE | Shipped subscription units, subscription revenue, active subscriptions, missed subscription deliveries, out-of-stock impact, revenue penetration |
FBA_RESPLENISHMENT_SNS_FORECAST | Forecasted subscription revenue and forecasted subscription units for upcoming periods |
Join guidance
- Use
PRODUCT_KEYwhen joining to DataHawk product reference tables. - Use
ASINandMARKETPLACE_KEYwhen joining to Amazon-facing product or marketplace analysis. - Keep the time interval in the join or filter condition. These datasets are period-based, not single-snapshot tables.
Where to go next
Subscribe & Save Forecasting
Business usage, key metrics, and how to use performance and forecast together.
Find Tables and Columns
Use the source-of-truth schema reference for exact columns and data types.
Amazon Inventory Data
Inventory datasets for stock movement, FBA planning, and replenishment analysis.
Amazon Removal Data
Amazon FBA removal reports in DataHawk; removal Order Detail and Removal Shipment Detail, data availability, and table locations.
Amazon Vendor Demand Forecasts
How VENDOR_FORECASTING_SRC shows Amazon's latest weekly demand forecast, and how to get past forecasts to compare with your sales.