Support
Metric Descriptions

InsightLeap Metric Descriptions

Detailed descriptions of each metric in InsightLeap. Some of metrics are taken directly from Vendor Central while others are derived and can only be found in InsightLeap.

Amazon metric used to measure vendor performance and product availability by taking into account in-stock percentages, pricing and selection of available items. If an item has a “Fast Track offer” the page states - Want it delivered Tuesday Dec 19th? Order in the next XX hours and XX minutes.

Where is it in Vendor Central?

You can find the same value on the “Operational Metrics” report with the name “Fast Track Buy Box rate” (previously: Fast track Buy Box).

Total cost of the units, Amazon received from you during the selected time period.

Where is it in Vendor Central?

You can find the same value on the “Operational Metrics” report with the name “Cost of received” (previously called Total Receipts Cost).

Total shipped cost of goods sold by Amazon during the selected time period. / Cost of goods sold to customers.

Where is it in Vendor Central?

You can it in a number of reports including “Sales & Inventory Dashboard”, “Sales & Inventory Monthly Summary”, and “Sales and Inventory Product Details”. It has the same name “Shipped COGS” and depending on the report, has both per product Shipped COGS and total Shipped COGS.

Total shipped cost of goods sold by Amazon during the selected time period. Cost of goods sold to customers.

Where is it in Vendor Central?

Amazon Shipped COGS History is derived from the “Sales & Inventory Monthly Summary” report.

Your Non-Compliance Performance – Pending, Waived and Enforced.

Where is it in Vendor Central?

You can find all chargebacks in the “Chargebacks” section.

Percentage of Items Confirmed as ‘Accepted’ during PO confirmation.

Where is it in Vendor Central?

You can find the same value on the “Operational Metrics” report with the name “Accepted confirmation rate”.

Percentage of Quantity Confirmed as ‘Back Ordered’ during PO confirmation.

Where is it in Vendor Central?

You can find the same value on the “Operational Metrics” report with the name “Backorder confirmation rate”.

The percentage page views during which Amazon had the item in replenishable state and lost buy box to a third party merchant due to uncompetitive price. This excludes items that are not released yet.

Where is it in Vendor Central?

You can find the same value on the “Operational Metrics” report with the name “LBB due to price rate”.

Monthly Estimated Net Received is a calculated value using the weekly “Net Received” value from the “InventoryHealth” report. Currently, Amazon ARA doesn’t provide a Monthly Net Received so this is used as an alternative.

It is calculated by summing up all weekly net received values for a given month. For weeks that are a part of two different months, we divide the week’s net received and proportionally add it to each month’s estimated net received.

For example, for May 2018, we would sum up the following values to get the estimated monthly value:

  • 5/7 of Net received for the week of April 29th (Since 5 days of this week falls in May)
  • All Net received for the week of May 6th
  • All Net received for the week of May 13th
  • All Net received for the week of May 20th
  • 5/7 of Net received for the week of May 27th (Since 5 days of this week falls in May)

Incomplete Estimates (*):

Estimates with a (*) next to them mean that they might be missing some data. This can occur for a number of reasons but the most common would be the following:

  • The account is added mid-month and we don’t have a full month’s worth of data.
  • We’ve calculated the month’s estimated before we got the final week’s data.
  • The account does not have enough activity and Vendor Central is not providing reports back. (This can occur for new accounts or very low volume accounts).

Total shipped cost of goods sold by Amazon during the selected time period. Cost of goods sold to customers.

Where is it in Vendor Central?

Month over month Shipped by amazon is derived from the “Sales & Inventory Monthly Summary” report.

Net amount received by Amazon after subtracting the amount returned to the supplier in the selected time frame.

Where is it in Vendor Central?

You can find the same value in the “Inventory Health” report.

On Hand Revenue is the estimated amount of revenue that amazon would generate if it sold off it’s current inventory. On Hand Revenue is calculated by multiplying On Hand Units by Retail Price.

This metric is only available for monitored products.

Listing out of stock items with a Replenishment Code of ‘Planned Replenishment (PR)’ or ‘New Product (NP)’. All other items are not listed.

Where is it in Vendor Central?

You can find out of stock items in the “Vendor Catalog Listing” report by sorting by inventory and filtering the replenishment code by ‘Planned Replenishment (PR)’ and ‘New Product (NP)’.

The percentage of customer glance views during which the item was Out of Stock but Replenishable, measured over the total customer glance views the item had.

Where is it in Vendor Central?

You can find the same value on the “Operational Metrics” report with the name “OOS & replenishable GV Pct”.

Shipped Revenue is InsightLeap’s estimate to what Amazon’s Shipped revenue is for a given period. We calculate this value by multiplying Shipped Units by Retail Price.

This metric is only available for monitored products.

Top products shipped this month (units)

Where is it in Vendor Central?

Top products are derived from the “Sales & Inventory Product Details” report.

Unit Cost is the price that amazon purchased the product. It is calculated by dividing Shipped COGS by Shipped Units. If Shipped COGS is not available we divide On Hand Cost by On Hand Units to determine the Unit Cost.

Weeks of Coverage

Weeks of Coverage (also known as Weeks of Inventory, Stock Coverage, or Weeks of Stock) is a ratio that estimates the number of weeks it will take amazon to sell through its current stock of inventory.

The formula we currently use is:

Total Inventory / (Shipped Units this week)

E.g.

If the current inventory is 15 and 5 items were shipped this week, the forward looking weeks of coverage would be 3 weeks (15 items / 5 items per week). Basically its estimated you will run out of inventory in 3 weeks!

There are other ways to calculate weeks of coverage. For example, instead of taking last week sales, take the average of the past 4 weeks or even past 52 weeks of sales when trying to calculate sales volume. If you’d like to use a different method, lets chat!

Weeks of Coverage (Open PO Qty)

We also calculate weeks of coverage that includes Open PO’s. This is to take into account the items that are already in transit to the Amazon fulfillment centers.

The formula for this is:

(Total Inventory + Open PO Quantity) / (Shipped Units this week)

E.g.

If there are 15 units at amazon, 10 units in transit to amazon, and this week 3 items were sold, weeks of coverage (with Open PO Qty) would be 8.3 weeks ((15 + 10)/3).

Where is it in InsightLeap?

Weeks of coverage can be found by going to a Weekly Report > Top Products > Products Page.

Where is it in Vendor Central?

This metric can only be found in InsightLeap.