A Monthly Amazon Account Audit in a Fixed Order

Most Amazon dashboards answer one question: how much did we sell? A monthly audit answers a harder pair: why did the number move, and what should we do about it? Without a fixed order, an audit turns into a tour of whichever report you opened first. This guide sets a sequence. Start with sales, move to the traffic and conversion behind them, then check inventory and capacity, and finish with the customer signals that tend to shift before sales do. Run in the same order each month, with notes kept, it turns scattered reports into a trend you can act on.

Set the comparison before you open a report

An audit is only as good as its comparisons. Pick a full calendar month, then compare it with the month before and, if you have the data, with the same month a year earlier. Seasonality will otherwise pass for a trend. Use the same marketplace and currency throughout, and read units as well as dollars, because a price change moves one without the other.

Keep a change log beside the numbers: price changes, promotions, new images, ad budget changes, stock-outs and listing suppressions. When a figure moves, the log hands you the first suspects. Without it you will be reconstructing the month from memory, and memory flatters whatever you did last.

Sales by product: find where the movement lives

Start with total ordered product sales and units, then sort by child ASIN. In most catalogs a handful of ASINs carry the bulk of revenue, so a change in the total usually traces to a few products. List the biggest movers up and down, in dollars. A flat total can hide one ASIN growing while another collapses, and that pattern matters more than the net.

If your reports let you split advertising from the rest, do it here. Compare total sales with ad-attributed sales and watch the portion that is not tied to ads. If total sales rose only because ad-attributed sales rose, you bought the growth. If total sales rose while ad spend stayed flat, something organic changed, and that is worth understanding.

Be careful with small numbers. An ASIN that sells 10 units one month and 14 the next has grown 40%, but four extra units are not a trend. Choose a minimum volume below which you do not chase month-to-month swings, and review those ASINs over a three-month view instead. Otherwise you will spend the audit explaining noise.

Split every change into traffic and conversion

For each big mover, break the change into parts. Ordered sales is roughly sessions, times unit session percentage, times average selling price. Unit session percentage is the report's headline conversion measure: units ordered divided by sessions. Whichever part moved tells you where to dig.

Now run the same example two ways. If sessions fall to 4,000 and conversion holds at 10%, you sell 400 units and $10,000. If sessions hold at 5,000 and conversion slips to 8%, you again sell 400 units and $10,000. The loss is identical, but the problems have nothing in common, and so do the fixes.

• Sessions down, conversion steady: a visibility problem. Check ad spend and rank for your main search terms, stock-outs, seasonality and whether competitors took the top positions.
• Sessions steady, conversion down: a page or offer problem. Check price against competing offers, the Featured Offer (Buy Box) percentage, the star rating, the images and any new competitor in the shopper's comparison.
• Both down: look first for an availability problem, a suppressed or changed listing, or the Featured Offer going to someone else.
• Both up: find out why before celebrating, because a one-off promotion can lift both and then vanish.

Check supply: inventory, capacity and the Featured Offer

Demand analysis misleads if you could not fill the demand. For each top ASIN, calculate days of cover: units available divided by recent average daily sales. Compare that with your replenishment lead time. Any ASIN with fewer days of cover than lead time is already in trouble, even when today's dashboard looks healthy. As a hypothetical, an ASIN selling 20 units a day with 300 units on hand has 15 days of cover. If a new order takes 30 days to arrive, the stock-out is coming whether or not the report shows one yet.

Then look at what is stuck: stranded or unfulfillable stock, inbound shipments not yet received and slow movers heading toward aged-inventory surcharges. Check how much of your storage capacity you are using against the limit shown in Seller Central. A cap on what you can send in constrains next month's sales as much as this month's stock does.

Finally, read the Featured Offer percentage for each top ASIN. When it drops, conversion falls and advertising on that ASIN can stop working. Find out who else is selling it and at what price, and whether your own price or stock position changed.

Read customer experience as a leading indicator

Customer signals tend to move before sales do. Look at three of them. Returns: by ASIN and, where the report gives it, by reason, comparing each ASIN with its own history rather than a generic benchmark. Reviews: the star average and, more usefully, the themes in new one-star and two-star reviews. Account Health: customer service performance and any new policy notices.

A rising return rate or a new theme in negative reviews is often a conversion problem waiting to happen, because shoppers read the same reviews you do. Treat each theme as a question. Does the page set the right expectation? Is something wrong in production or packaging? Is a size chart missing? A pattern you can name is a pattern you can fix.

End with one page and no more than three actions

Write down what moved, your best explanation and the evidence for it. Then choose no more than three actions for the coming month, each with an owner and a date. A long list is a list nobody finishes. Next month's audit begins by checking whether last month's actions changed anything, which is the only way the audit improves itself.

Use the same one-page template every month: the same headings, the same order, the same handful of columns. A consistent template makes the month-over-month comparison almost automatic, and it lets a colleague pick the audit up if you are away. The goal is not a beautiful report. It is a short record that ties each decision to the number that prompted it.

Where to start

• Pick the month and create the change log before you open any report.
• List your top ASINs by ordered sales and the biggest movers up and down.
• Split each mover into sessions, unit session percentage and price.
• Calculate days of cover and compare it with your lead time.
• Read returns, new low-star reviews and Account Health notices for the same ASINs.
• Write one page: what moved, why, and no more than three actions.