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;

  1. Sales and Traffic By Date

  2. Detail Page Sales and Traffic By Parent Item

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

  • sp_retail_sku_by_asin

  • sp_retail_sku_by_date

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

  • GET_SALES_AND_TRAFFIC_REPORT

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.

Timing

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.

Per Amazon;

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.

Lookback Schedules

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.

Calculations

Amazon calculates the values in these reports as follows:

Field name

Calculation

Ordered Product Sales

Sum(ItemPrice * UnitsOrdered)

Units Ordered

Sum("Ordered Units")

Total Order Items

Sum("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

Sessions *

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

Did this answer your question?