The Amazon Vendor Central Retail Analytics connector reflect contains sales performance metrics such as ordered product sales, revenue, units ordered, and claim amount, as well as glance view metrics.
The following Vendor reports are supported;
Vendor Sales Report
Net Pure Product Margin Report
Vendor Traffic Report
Vendor Forecasting Report
Vendor Inventory Report
While the provides a collection of separate reports, the API will use different dimensions to offer different outputs per report. The data is organized in the following primary tables/views:
sp_vendor_forecasting_report
sp_vendor_inventory_manufacturing_week_report *
sp_vendor_inventory_sourcing_week_report *
sp_vendor_net_pure_product_margin_report
sp_vendor_sales_manufacturing_report
sp_vendor_sales_sourcing_report
sp_vendor_traffic_report
* Per Amazon, Inventory reports are available weekly.
The following report types, as defined by the API, are the source of the data:
GET_VENDOR_SALES_REPORT
GET_VENDOR_NET_PURE_PRODUCT_MARGIN_REPORT
GET_VENDOR_TRAFFIC_REPORT
GET_VENDOR_FORECASTING_REPORT
GET_VENDOR_INVENTORY_REPORT
Timing
The time period for this data is set to DAILY (24-hour period UTC) for reports unless specified otherwise by Amazon.
While we request data daily, it is possible that a reporting period is not yet available, the report will not be generated. Per Amazon, data can be delayed up to 72 hours after the close of the period. For example, if the close period is Sat, the first availability would be Wed. This means Inventory reports, or any report that is weekly, that closed on Saturday 10/4, will be available until no sooner than Wednesday, 10/8.
Another example is if a report for 8/13 is requested on 8/14 it is possible that the 8/13 data is not available. The earliest 8/13 data would be available is on 8/17.
Lookback Schedules
Due to the latency of changes at Amazon as previously described, we use a LOOKBACK schedule for Vendor Retail Analytics of 4, 5, 14, and 30 days from the current date. This means on July 30th, we are requesting July 26th, July 25th, July 16th, and June 30th. As a result, any back updates Amazon may have made to older data would be updated. While we request older data, it may be possible that there is no new data to load for a given date.
See De-duplication and dealing with updates over a long time horizon for guidance on how to query this data.
Vendor Retail Analytics leverage the Amazon Reporting API for the report types listed above. For more details on the report types detailed above, see Amazon's docs.