Cover Image
Trutz Fries

The sales diagnostic report explained in detail

03/15/2021 • Reading time: ca. 7 min • by Trutz Fries
Sales diagnosis report preview
Figure 1: Sales Diagnostics Report Preview

The Sales Diagnostic report *is the most comprehensive report in Amazon Brand Analytics It allows you to track the sales performance of your ASINs and also (sub)categories. It determines relevant factors such as traffic, views, price or out of stock. By studying this report in detail, you can use its metrics to determine what exactly contributes to your sales performance and how you can optimize or improve it.

Distributor View, Sales View & Co.

Depending on your filtering, the Sales Diagnostics report displays different metrics. The default setting for Program is Amazon Retail (retail sales version).

As a Seller or Vendor you also have the choice between:

  • Amazon Business - is a new marketplace for commercial customers on Amazon.co.uk.
  • Amazon Fresh - for fresh food deliveries
  • Amazon Prime Now - Prime Now is a delivery service that delivers products within 1-2h. However, the service is currently only offered in a few cities.

Next, you can set the Distributor View. The default setting for this is Sourcing. The sourcing metrics refer to sales and inventory that Amazon has sold and sourced from your inventory only.

Sales diagnosis Sourcing View
Figure 2: Distributor View - Sourcing

In addition to Sourcing, you can also select Manufacturing. Manufacturing metrics aggregate sales and inventory for items identified with your brand - regardless of whether Amazon buys the items directly from you as the supplier.

Sales diagnosis Manufacturing View
Figure 3: Distributor View - Manufacturing

Therefore, the manufacturing view also includes third-party purchases. Third-party sourcing means sales data on units sourced from other distributors and from other dealers in the EU.

Sales diagnosis external acquisition
Figure 4: External procurement in the manufacturing view

The third important setting is the Sales View. Here you can choose between Shipped Revenue, Ordered Revenue and Shipped CoGS.

Difference Sell-Out and Sell-In

Sell-In: How many units of a product does a manufacturer sell to a retailer e.g. Amazon?
Sell-Out: How many units of a product are sold to the customer (by the retailer)?

Sales viewExplanation
Shipped RevenueThe Shipped Revenue is the revenue that Amazon makes with your products. It is based on Amazon's selling price to the customer and the time at which the product was shipped to the customer. The units sold by Amazon are also referred to as sell-out..
Ordered RevenueOrdered Revenue are the sales that Amazon makes with your products, but at a different time. Ordered refers to the fact that the goods have been ordered but not yet shipped by Amazon. The amount also refers again to the final price. Ordered revenue is therefore also attributable to sell-out.
Shipped CoGSCoGS is the cost of shipped goods incurred by Amazon when purchasing the item from the Vendor. The value cannot be specifically assigned to sell-out or sell-in, because both factors are included.

Key figures of the sales diagnosis report

In the sales diagnostics report, the summary view is always displayed first. It contains a brief overview of the most important key figures for the respective filter selection that one has made in advance. Below that, you can then view more detailed information in the detail view. The table can be filtered by ASIN, subcategory and category for better readability.

The following key figures are always visible, no matter which filter setting was made:

Key figuresExplanation
ASINThe ASIN is the Amazon Standard Identification Number. The unique identifier is assigned to all products offered on Amazon.
Product TitleThe product title is the product name of your product.
Average Sales PriceThe average sales price indicates the average price per shipped unit of your product for the selected period.
Additional key figures: Previous period (average price per unit shipped as a percentage compared to the previous time window).

The following key figures are only displayed depending on the filtering:

Key figuresExplanationFiltering
Glance ViewsThe page views represent the customer views of the product detail page of your product.

Additional key figures: Change in page views compared to the previous period (the percentage change in page views compared to the previous period. (((Current period - previous period)/previous period) x 100)) ; compared to the previous year
  • Sourcing/Ordered Revenue
  • Manufacturing/Shipped Revenue
  • Sourcing/Shipped CoGS
Ordered UnitsOrdered units denotes the number of product units ordered by Amazon customers.

Additional key figures: % of the total (Displayed percentage of the number); Previous period (Displayed percentage of the number compared to the previous time window); Last year (compared to last year)
  • Sourcing/Ordered Revenue
  • Manufacturing/Shipped Revenue
  • Sourcing/Shipped CoGS
Ordered RevenueThe Ordered Revenue indicates the ordered product sales in a selected period of time.

Additional key figures: % of the sum; Last year; Previous period
  • Sourcing/Ordered Revenue
Conversion RateConversion rate means the purchase rate of customers viewing your products.
  • Sourcing/Ordered Revenue
  • Manufacturing/Shipped Revenue
Free ReplacementsThe key figure free replacement indicates the number of replacement deliveries sent to customers.
  • Manufacturing/Shipped Revenue
  • Sourcing/Shipped CoGS
  • Sourcing/Shipped Revenue
  • Sourcing/Shipped CoGS
Lost Buy Box PriceLBB represents the percentage where the shopping cart field (buy box) has been lost to a third party merchant or without another merchant. Customers must then click again on the product detail page to buy your item.
  • Manufacturing/Ordered Revenue
  • Manufacturing/Shipped Revenue
  • Sourcing/Shipped CoGS
RepOOSThe RepOOS (Replenishable Out of Stock) metric indicates the percentage of sales that may have been missed because the item was out of stock when it could have been replenished. wue Replenishable Out of Stock.
The metric is calculated as follows: (page views when the product was out of stock / total number of page views). * 100

Additional key figures: % of the sum; Previous period
  • Sourcing/Ordered Revenue
  • Manufacturing/Shipped Revenue
  • Sourcing/Shipped CoGS
Subcategory (Sales Rank)Here the sales rank in a subcategory is displayed.
  • Sourcing/Ordered Revenue
  • Manufacturing/Shipped Revenue
  • Sourcing/Shipped CoGS
Shipped RevenueShipment yield is the revenue based on units shipped in a selected time period.

Additional key figures: Turnover of shipped units - % of total; Previous period, Last year
  • Manufacturing/Shipped Revenue
  • Sourcing/Shipped Revenue
Shipped UnitsThe units shipped are the number of product units shipped to Amazon customers.

Additional key figures: % of the sum; Last year; Previous period
  • Manufacturing/Shipped Revenue
  • Sourcing/Shipped CoGS
  • Sourcing/Shipped Revenue
  • Sourcing/Shipped CoGS
Customer ReturnsGoods returned by customers are the number of units returned by customers.
  • Manufacturing/Shipped Revenue
  • Sourcing/Shipped CoGS
  • Sourcing/Shipped Revenue
  • Sourcing/Shipped CoGS
Shipped COGSShipped CoGS is revenue based on the cost of goods sold. This refers to the costs incurred by Amazon when purchasing the item from the vendor.

Additional key figures: % of the sum; Last year; Previous period
  • Sourcing/Shipped CoGS

Conclusion

The Sales Diagnostics Report creates an overview of the various metrics that contribute to your sales performance. Through this report, you may be able to more quickly identify what contributes to sales performance and how you can improve it. It therefore proves to be very helpful to work with this report.

Would you like to have a better overview on Amazon?
Monitor your listings 14 days for free!
Do you have any questions? Don't hesitate to call us or send us an email!
Tel. +49 221-29 19 12 32 | info@amalytix.com