The Amazon Sales and Traffic Business Report connector reflect 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;
Sales and Traffic By Date
Detail Page Sales and Traffic By Parent Item
Detail Page Sales and Traffic By Child Item
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:
The time period for this data is set to DAILY (24-hour period UTC) for traffic reports. Data is refreshing from the API on a daily basis to your destination.
Data is collected on a trailing 2-day basis from the current date. For example, if today is 8/17, then we will ask Amazon for data from 8/15. Why? Amazon states it can be 24 hours until they are able to make data available. As a result, calling for data within that period will result in NO DATA. Using 2-days allows Amazon time to "settle" its systems and make data consistently available.
Note: If you use all of the reports that are available across your seller account, you might notice discrepancies across the different report types. Discrepancies are due to the way data is pivoted and based on the purpose of the report. Business Reports will have a lag of 24 hours when compared to the real-time data.
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 23, 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 leverage the Amazon Reporting API for the report types listed above. For more details on the report types detailed above, see Amazon's docs.
Amazon calculates the values in these reports as follows:
Ordered Product Sales
Sum(ItemPrice * UnitsOrdered)
Total Order Items
Average Sales per Order Item
Ordered Product Sales/Total Order Items
Average Units per Order Item
Units Ordered/Total Order Items
Average Selling Price
Ordered Product Sales/Units Ordered
Sum("Distinct Session Count")
Order Item Session Percentage
Total Order Items/Sessions
Average Offer Count
Sum("Offer Count") / Sum (1)Note: Applies only when Offering Count > 0. Sum (1), stands for "Number of days in a specific time period"
Shipped Product Sales
Sum("ItemPrice" * "UnitsOrdered") confirmed shipped in a specific time period
Shipped Order Items
Sum("Order Items") confirmed shipped in a specific time period