Reports
Fivetran supports the following Amazon Selling Partner reports:
| Table Name | Report Type | Aggregation | Seller/Vendor | Max Look Back Window | Latency | Selling Program | Distributor View |
|---|---|---|---|---|---|---|---|
| MARKET_BASKET_ANALYSIS_REPORT_DAILY | GET_BRAND_ANALYTICS_MARKET_BASKET_REPORT | DAY | BOTH | 1 year | 2 days | ||
| MARKET_BASKET_ANALYSIS_REPORT_MONTHLY | GET_BRAND_ANALYTICS_MARKET_BASKET_REPORT | MONTH | BOTH | 3 years | 2 months | ||
| MARKET_BASKET_ANALYSIS_REPORT_QUARTERLY | GET_BRAND_ANALYTICS_MARKET_BASKET_REPORT | QUARTER | BOTH | 3 years | 2 months | ||
| NET_PURE_PRODUCT_MARGIN_REPORT_DAILY | GET_VENDOR_NET_PURE_PRODUCT_MARGIN_REPORT | DAY | VENDOR | 1,460 days | 4 days | ||
| NET_PURE_PRODUCT_MARGIN_REPORT_MONTHLY | GET_VENDOR_NET_PURE_PRODUCT_MARGIN_REPORT | MONTH | VENDOR | 36 months | 1 month | ||
| NET_PURE_PRODUCT_MARGIN_REPORT_QUARTERLY | GET_VENDOR_NET_PURE_PRODUCT_MARGIN_REPORT | QUARTER | VENDOR | 8 quarters | 1 quarter | ||
| RAPID_RETAIL_ANALYTICS_INVENTORY_REPORT_HOURLY | GET_VENDOR_REAL_TIME_INVENTORY_REPORT | HOUR | VENDOR | 30 days | 5 minutes | ||
| RAPID_RETAIL_ANALYTICS_SALES_REPORT_HOURLY | GET_VENDOR_REAL_TIME_SALES_REPORT | HOUR | VENDOR | 30 days | 5 minutes | ||
| RAPID_RETAIL_ANALYTICS_TRAFFIC_REPORT_HOURLY | GET_VENDOR_REAL_TIME_TRAFFIC_REPORT | HOUR | VENDOR | 30 days | 5 minutes | ||
| REPEAT_PURCHASE_REPORT MONTHLY | GET_BRAND_ANALYTICS_REPEAT_PURCHASE_REPORT | MONTH | BOTH | 3 years | 1 month | ||
| REPEAT_PURCHASE_REPORT QUARTERLY | GET_BRAND_ANALYTICS_REPEAT_PURCHASE_REPORT | QUARTER | BOTH | 3 years | 1 quarter | ||
| SALES_AND_TRAFFIC_BUSINESS_REPORT_DAILY | GET_SALES_AND_TRAFFIC_REPORT | DAY | SELLER | 2 years | 1 day | ||
| SALES_AND_TRAFFIC_BUSINESS_REPORT_MONTHLY | GET_SALES_AND_TRAFFIC_REPORT | MONTH | SELLER | 2 years | 1 month | ||
| SEARCH_TERMS_REPORT_DAILY | GET_BRAND_ANALYTICS_SEARCH_TERMS_REPORT | DAY | BOTH | 1 year | 1 day | ||
| SEARCH_TERMS_REPORT_MONTHLY | GET_BRAND_ANALYTICS_SEARCH_TERMS_REPORT | MONTH | BOTH | 2 years | 2 months | ||
| SEARCH_TERMS_REPORT_QUARTERLY | GET_BRAND_ANALYTICS_SEARCH_TERMS_REPORT | QUARTER | BOTH | 2 years | 2 months | ||
| SUBSCRIBE_AND_SAVE_FORECAST_REPORT | GET_FBA_SNS_FORECAST_DATA | SELLER | 12 months | ||||
| SUBSCRIBE_AND_SAVE_PERFORMANCE_REPORT | GET_FBA_SNS_PERFORMANCE_DATA | SELLER | 18 months | ||||
| VENDOR_FORECASTING_FRESH_REPORT | GET_VENDOR_FORECASTING_REPORT | VENDOR | FRESH | ||||
| VENDOR_FORECASTING_RETAIL_REPORT | GET_VENDOR_FORECASTING_REPORT | VENDOR | RETAIL | ||||
| VENDOR_INVENTORY_MANUFACTURING_FRESH_REPORT_DAILY | GET_VENDOR_INVENTORY_REPORT | DAY | VENDOR | 1,460 days | 4 days | FRESH | MANUFACTURING |
| VENDOR_INVENTORY_MANUFACTURING_RETAIL_REPORT_DAILY | GET_VENDOR_INVENTORY_REPORT | DAY | VENDOR | 1,460 days | 4 days | RETAIL | MANUFACTURING |
| VENDOR_INVENTORY_MANUFACTURING_FRESH_REPORT_MONTHLY | GET_VENDOR_INVENTORY_REPORT | MONTH | VENDOR | 36 months | 1 month | FRESH | MANUFACTURING |
| VENDOR_INVENTORY_MANUFACTURING_RETAIL_REPORT_MONTHLY | GET_VENDOR_INVENTORY_REPORT | MONTH | VENDOR | 36 months | 1 month | RETAIL | MANUFACTURING |
| VENDOR_INVENTORY_MANUFACTURING_FRESH_REPORT_QUARTERLY | GET_VENDOR_INVENTORY_REPORT | QUARTER | VENDOR | 8 quarters | 1 quarter | FRESH | MANUFACTURING |
| VENDOR_INVENTORY_MANUFACTURING_RETAIL_REPORT_QUARTERLY | GET_VENDOR_INVENTORY_REPORT | QUARTER | VENDOR | 8 quarters | 1 quarter | RETAIL | MANUFACTURING |
| VENDOR_INVENTORY_SOURCING_FRESH_REPORT_DAILY | GET_VENDOR_INVENTORY_REPORT | DAY | VENDOR | 1,460 days | 4 days | FRESH | SOURCING |
| VENDOR_INVENTORY_SOURCING_RETAIL_REPORT_DAILY | GET_VENDOR_INVENTORY_REPORT | DAY | VENDOR | 1,460 days | 4 days | RETAIL | SOURCING |
| VENDOR_INVENTORY_SOURCING_FRESH_REPORT_MONTHLY | GET_VENDOR_INVENTORY_REPORT | MONTH | VENDOR | 36 months | 1 month | FRESH | SOURCING |
| VENDOR_INVENTORY_SOURCING_RETAIL_REPORT_MONTHLY | GET_VENDOR_INVENTORY_REPORT | MONTH | VENDOR | 36 months | 1 month | RETAIL | SOURCING |
| VENDOR_INVENTORY_SOURCING_FRESH_REPORT_QUARTERLY | GET_VENDOR_INVENTORY_REPORT | QUARTER | VENDOR | 8 quarters | 1 quarter | FRESH | SOURCING |
| VENDOR_INVENTORY_SOURCING_RETAIL_REPORT_QUARTERLY | GET_VENDOR_INVENTORY_REPORT | QUARTER | VENDOR | 8 quarters | 1 quarter | RETAIL | SOURCING |
| VENDOR_SALES_MANUFACTURING_BUSINESS_REPORT_DAILY | GET_VENDOR_SALES_REPORT | DAY | VENDOR | 1,460 days | 4 days | BUSINESS | MANUFACTURING |
| VENDOR_SALES_MANUFACTURING_BUSINESS_REPORT_MONTHLY | GET_VENDOR_SALES_REPORT | MONTH | VENDOR | 36 months | 1 month | BUSINESS | MANUFACTURING |
| VENDOR_SALES_MANUFACTURING_BUSINESS_REPORT_QUARTERLY | GET_VENDOR_SALES_REPORT | QUARTER | VENDOR | 8 quarters | 1 quarter | BUSINESS | MANUFACTURING |
| VENDOR_SALES_MANUFACTURING_FRESH_REPORT_DAILY | GET_VENDOR_SALES_REPORT | DAY | VENDOR | 1,460 days | 4 days | FRESH | MANUFACTURING |
| VENDOR_SALES_MANUFACTURING_FRESH_REPORT_MONTHLY | GET_VENDOR_SALES_REPORT | MONTH | VENDOR | 36 months | 1 month | FRESH | MANUFACTURING |
| VENDOR_SALES_MANUFACTURING_FRESH_REPORT_QUARTERLY | GET_VENDOR_SALES_REPORT | QUARTER | VENDOR | 8 quarters | 1 quarter | FRESH | MANUFACTURING |
| VENDOR_SALES_MANUFACTURING_RETAIL_REPORT_DAILY | GET_VENDOR_SALES_REPORT | DAY | VENDOR | 1,460 days | 4 days | RETAIL | MANUFACTURING |
| VENDOR_SALES_MANUFACTURING_RETAIL_REPORT_MONTHLY | GET_VENDOR_SALES_REPORT | MONTH | VENDOR | 36 months | 1 month | RETAIL | MANUFACTURING |
| VENDOR_SALES_MANUFACTURING_RETAIL_REPORT_QUARTERLY | GET_VENDOR_SALES_REPORT | QUARTER | VENDOR | 8 quarters | 1 quarter | RETAIL | MANUFACTURING |
| VENDOR_SALES_SOURCING_BUSINESS_REPORT_DAILY | GET_VENDOR_SALES_REPORT | DAY | VENDOR | 1,460 days | 4 days | BUSINESS | SOURCING |
| VENDOR_SALES_SOURCING_BUSINESS_REPORT_MONTHLY | GET_VENDOR_SALES_REPORT | MONTH | VENDOR | 36 months | 1 month | BUSINESS | SOURCING |
| VENDOR_SALES_SOURCING_BUSINESS_REPORT_QUARTERLY | GET_VENDOR_SALES_REPORT | QUARTER | VENDOR | 8 quarters | 1 quarter | BUSINESS | SOURCING |
| VENDOR_SALES_SOURCING_FRESH_REPORT_DAILY | GET_VENDOR_SALES_REPORT | DAY | VENDOR | 1,460 days | 4 days | FRESH | SOURCING |
| VENDOR_SALES_SOURCING_FRESH_REPORT_MONTHLY | GET_VENDOR_SALES_REPORT | MONTH | VENDOR | 36 months | 1 month | FRESH | SOURCING |
| VENDOR_SALES_SOURCING_FRESH_REPORT_QUARTERLY | GET_VENDOR_SALES_REPORT | QUARTER | VENDOR | 8 quarters | 1 quarter | FRESH | SOURCING |
| VENDOR_SALES_SOURCING_RETAIL_REPORT_DAILY | GET_VENDOR_SALES_REPORT | DAY | VENDOR | 1,460 days | 4 days | RETAIL | SOURCING |
| VENDOR_SALES_SOURCING_RETAIL_REPORT_MONTHLY | GET_VENDOR_SALES_REPORT | MONTH | VENDOR | 36 months | 1 month | RETAIL | SOURCING |
| VENDOR_SALES_SOURCING_RETAIL_REPORT_QUARTERLY | GET_VENDOR_SALES_REPORT | QUARTER | VENDOR | 8 quarters | 1 quarter | RETAIL | SOURCING |
| VENDOR_TRAFFIC_REPORT_DAILY | GET_VENDOR_TRAFFIC_REPORT | DAY | VENDOR | 1,460 days | 4 days | ||
| VENDOR_TRAFFIC_REPORT_MONTHLY | GET_VENDOR_TRAFFIC_REPORT | MONTH | VENDOR | 36 months | 1 month | ||
| VENDOR_TRAFFIC_REPORT_QUARTERLY | GET_VENDOR_TRAFFIC_REPORT | QUARTER | VENDOR | 8 quarters | 1 quarter |