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.