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;

  1. Vendor Sales Report

  2. Net Pure Product Margin Report

  3. Vendor Traffic Report

  4. Vendor Forecasting Report

  5. 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:







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.

Did this answer your question?