How to Track Your Amazon Sales and KPIs

December 22, 2022 by InsightLeap

You can open Vendor Central, read a sales number, and still not know whether the month is going well. Sales performance on Amazon is spread across four places: the revenue and units on the Sales Dashboard, the efficiency of the ad spend sitting behind them, the inventory that has to exist for the sale to happen at all, and the account-health record that decides whether Amazon keeps ordering from you. What follows names the report each of those numbers lives in, then puts them on a weekly and monthly schedule you can keep.

Where the Core Sales Numbers Live

Start with the Sales Dashboard in Vendor Central. It gives you a snapshot of total sales, units sold, order volume, and revenue trends over time, which is enough to see your trajectory and spot a seasonal pattern. Our tour of Amazon Vendor Central reports covers the neighboring dashboards for inventory, customer feedback, and fulfillment if you want the whole picture of what Amazon hands you natively. If you have Amazon Retail Analytics, there is more to work with: ARA covers sales performance, inventory, and customer behavior.

Everything below assumes the Vendor Central side of the business. If you sell through Seller Central as well, our comparison of the two models and the hybrid case is worth reading alongside this one.

Reading those numbers as a trend is a separate skill, and this site already has the long version. Our breakdown of Vendor Central metrics walks through Shipped COGS, Shipped Units, Sellable On Hand Units, and Open PO Quantity, and how to read each of them against year-over-year and month-over-month movement. Two habits from it carry into everything below. First, check any month-over-month swing against the same month last year before you treat it as a problem, because a soft January after a heavy Q4 is usually seasonality doing exactly what it did last year. Second, treat Open PO Quantity as the sales line that pays you, since purchase orders are what lands on the P&L.

The Three Other Levers Behind the Sales Number

Revenue records what already happened, and these three levers decide whether it happens again.

Advertising efficiency

Two formulas do the work, both straight from Amazon's guidance on marketing ROI: ROAS = ad revenue / ad spend, and ACoS = (ad spend / ad revenue) × 100. Neither figure means much in isolation, and the same guidance says why: there is no universal benchmark to clear, so establish your baseline and track progress against it. Compare each campaign against the gross margin of the product it advertises and against what that campaign did last quarter, and the figures start to mean something. A campaign whose ACoS climbs while sales hold flat is buying the same revenue for more money, and that is easier to fix in the week it happens than at the end of the quarter.

Inventory and fulfillment health

A stockout is a sale that never gets recorded, so inventory belongs in any read of sales performance. Watch Sellable On Hand Units week to week, and watch replenishment code changes along with it, because a code change is Amazon telling you it has changed its mind about restocking a product. If on-hand units are rising while sales hold flat, take a look at buy box status on that ASIN.

Account and customer health

Chargebacks, negative reviews, and A-Z guarantee claims belong in one bucket because they behave the same way: left unremedied, they draw warnings from Amazon and, far enough along, a suspension. None of that will be news to a vendor who has dealt with them, so the job here is to give them a standing place on a list somebody checks, along with ratings and review counts.

Put the Numbers on a Cadence

Naming the metrics is the easy part. The schedule is what makes them useful, and a short list you check every week will tell you more than a long one you open twice a year.

Weekly, the PO and inventory pulse. Open PO Quantity, sellable on-hand units, replenishment code changes, buy box status, and anything that would explain a sudden move in sales. It is a short read, and it catches the problems that compound while nobody is looking.

Monthly, the trend read. Shipped COGS and Shipped Units year over year and month over month, ad efficiency against margin for every campaign that matters, and a reconciliation of chargebacks and shortage claims against your records. This is where you decide whether the quarter is on track and whether the catalog mix has drifted.

What the cadence gives you over time is history. By the third cycle you are reading last week's figures next to the same week a year ago, with a note of what you changed in between, and that context is what tells you whether this month is good.

How InsightLeap Fits

Every read above can be done by hand from exported reports. What kills a cadence is the time those exports take each week: pulling the files, stitching them into last week's spreadsheet, and rebuilding the year-over-year comparison before anyone can look at it. InsightLeap automates that layer for brands and agencies, pulling product-level Vendor Central sales, inventory, and PO data on a schedule, keeping historic VC reports so the comparison is already built, and surfacing stockout risk and Net Pure Profit Margin (Net PPM) at the product level. The weekly pulse and the monthly trend read become a standing view that is already waiting when you sit down to do them. See the full feature list for what that covers.

Where to Start This Week

  1. Pull the Sales Dashboard for the last full week and write down total sales, units sold, and order volume as your baseline.
  2. Compute ROAS and ACoS for every campaign that matters, and set each against the gross margin of the product it advertises.
  3. Check Open PO Quantity and sellable on-hand units, and note any replenishment code change from the past month.
  4. Reconcile the last month of chargebacks and shortage claims against your records, and dispute the ones that look wrong.
  5. Put steps 1 and 3 on a weekly calendar entry and steps 2 and 4 on a monthly one, with a named person on each.