All Collections
Data Sources
Amazon
Amazon Sales and Traffic Business Report
Amazon Sales and Traffic Business Report

Seller retail analytics reports

Openbridge Support avatar
Written by Openbridge Support
Updated over a week ago

The Amazon Sales and Traffic 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 refreshed from the API daily to your destination.

Known Issues

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. You are welcome to comment on that issue asking for Amazon to change this behavior.

Timing

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:

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.

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 above report types. For more details on the report types detailed above, please look at 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?