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 refreshed from the API daily to your destination.
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.
NOTE: According to Amazon, these reports may take up to a week to populate after a period close. For example, if yesterday was March 20, 2023, that date is considered "closed." Amazon says that on March 21, 2023, data may not be available until March 25th to March 27th. Amazon has stated that the target for updates is within 72 hours of the period close. It may be longer and, in some cases, faster. 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 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 above report types. For more details on the report types detailed above, please take a look at 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