The Amazon Sales and Traffic connector contains sales performance metrics such as ordered product sales, revenue, units ordered, and claim amount, as well as page traffic metrics such as page views and buy box percentage of the seller’s entire catalog of items aggregated by date and ASIN.

The following DATE and ASIN reports are supported;

While the UI provides three separate reports, the API will consolidate them into a unified data feed. The data is organized in two primary tables/views:

The following report types, as defined by the API, are the source of the data:

For traffic reports, the period for this data is set to DAILY (24-hour period UTC). Data is refreshed from the API daily and sent to your destination.

Amazon will not return records for sp_retail_sku_by_asin when the order count is 0 for an ASIN. They will only supply a record for an ASIN where the order count is > 0. As a result, if you do not have any orders on a given date, Amazon will not provide a report. If some ASINs have orders and others do not, only those ASINs with an order count > 0 are provided in the report. For more on this, see https://github.com/amzn/selling-partner-api-docs/issues/2441. Please comment on that issue and ask Amazon to change this behavior.

Data is collected on a trailing 2-day basis from the current date. For example, if today is 8/17, we will ask Amazon for data from 8/15. Why? Amazon states, "Business Reports will have a lag of 24 hours" before they make data available. As a result, calling for data in that period will result in NO DATA. Using 2-days allows Amazon time to "settle" its systems and make data consistently available per their direction.

Example:

Here is the page showing the results are not settled:

Hello,
​
​Reports may take up to a week to populate data after a reporting periods closes (e.g. day, week, month). We aim to update all weekly reports within 72 hours (i.e. Tuesday) and continuously work to improve our system to get reports to you faster. For a reportPeriod set to 'DAY', kindly wait up to 72 hours to pull the report.
​
​Best,Krithi, Solutions Architect, SP API
​
​See this comment from the Amazon API Solutions Architect: https://github.com/amzn/selling-partner-api-docs/issues/2303#issuecomment-1155521032

This is why we have a LOOKBACK schedule. See below.

Please note that we use a LOOKBACK schedule for Sales and Traffic for days 2, 3, 7, and 30 from the current date. This means on July 30th, we are requesting July 28th, July 27th, July 23rd, 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.

Sales and Traffic Business Report leverages the Amazon Reporting API for the above report types. For more details on the report types detailed above, please see Amazon's docs.

Amazon calculates the values in these reports as follows: