Report tool
Amazon advertised product report analyzer
Drop in your Advertised product report to see spend, sales and ACoS for every ASIN, the product ads that got clicks without an order, and how much of your ad sales were other products.
- Free, no sign-up
- Your file stays in your browser
Drop your Advertised product report here
XLSX or CSV, straight from the Amazon Ads console. Summary or daily.
Your report is read by your browser and never uploaded. Close the tab and it's gone.
A product ad is listed once it has this many clicks and no orders at all. Set it to 0 to list every product ad without an order.
Next step
Do this every day in Merch Jar.
Automation logic you can read, adjust and preview on your account. It's saved switched off, and runs once you turn it on.
How to download the advertised product report
- 1In the Amazon Ads console, open Reporting under Measurement & Reporting and start from the Advertised product template in All templates.
- 2Pick 30 to 60 days. A week rarely gives a product ad enough clicks to judge.
- 3Download the report and drop it in above. XLSX and CSV both load, summary or daily, and daily rows are added up per product ad.
FAQ
How to read the results
The headline is the spend on product ads that reached your click minimum without a single order. In the sample data, a garden tools seller spent $118.40 of $1,295.90 that way, on three ads. The folding saw tops the list at $59.10 over 49 clicks.
The By ASIN tab adds up every product ad for each ASIN across campaigns and ad groups, so you can see which products carry your spend and what ACoS each one runs at. In the sample, the anvil pruners spend about $322 at roughly 60% ACoS, while the bypass pruners run just under 29%.
The other-products column is the share of an ASIN's ad sales that were something else, bought by a shopper who clicked its ad. Amazon calls these Other SKU sales, and Halo in the newer reports. That's a record of what shoppers bought after the click. Whether they'd have bought it anyway is something no report can show.
Before you pause a product ad
A product ad with clicks and no orders deserves a second look before you pause it. Check these first.
- Stock, price and the Buy Box. If the product was out of stock or lost the Buy Box for part of the range, the clicks weren't a fair test.
- Where the ad runs. In the sample, the leather holster is advertised in the pruners ad group, so it shows up on pruner searches. A product can fail in the wrong ad group and sell in the right one.
- Thin data. The hedge shears ad has 18 clicks and no orders, which says very little yet, so it stays off the list until it reaches your minimum.
- Sales of other products. In the sample, the anvil pruners ad in the auto campaign had two orders, both for the bypass pruners. Its own product sold nothing there, and the tag says so. Whether to keep it depends on what those clicks cost against what they were followed by.
What happens to your file
Your report never leaves your browser. The page reads it on your device, with no account and no upload. It looks for the advertised ASIN or SKU, clicks, spend, sales and orders columns, plus campaign, ad group and the Other SKU (or Halo) sales column when they are there, in the header spellings Amazon has used.
If ACoS is climbing and you want to know why, the ACoS breakdown tool splits the rise into CPC, conversion rate and order value. To find the searches that spend without an order, use the search term report analyzer, and to check what ACoS your margins allow, the breakeven ACoS calculator.