Marketplace Sidekick
AMAZON · REPORTCSV / XLSX

The SP Advertised Product Report.

A product looks fine on campaign ACoS and you want to know whether the product itself is actually profitable, which is a different number.

What the file contains.

Advertising performance broken down by the SKU or ASIN being advertised, rather than by the keyword that triggered it or the campaign that contains it. Spend, impressions, clicks, attributed sales and orders, per product.

This is the level at which advertising and margin finally meet. Break-even ACOS is a property of a product — its price, its cost, its fee band — not of a campaign, so a target ACOS set account-wide is necessarily wrong for almost every SKU it covers. This report is what lets you set it per product instead.

It also surfaces the quiet case that campaign reporting hides completely: a product being advertised inside several campaigns at once, where no single campaign looks alarming and the product's total spend is well past what it can carry.

What it can tell you.

  • Which products the advertising budget is actually going to
  • Whether each product's ACOS is under its own break-even, rather than the account average
  • Which SKUs are advertised across multiple campaigns and at what combined cost
  • Which products get spend but almost no attributed sales

How to export it.

  1. 01Login to Amazon Seller Central
  2. 02Open Amazon Ads
  3. 03Navigate to Measurement & Reporting
  4. 04Click Sponsored ads reports
  5. 05Click Create report
  6. 06Under Report category, select Sponsored Products
  7. 07Under Report type, select Advertised Product Report
  8. 08Set the Report period and your required Date Range
  9. 09Click Run report
  10. 10Download it once it has finished running.
  11. 11Upload the downloaded CSV/XLSX file here.

You end up with a CSV / XLSX file.

Where reading it goes wrong.

  1. 01

    Comparing product ACOS against an account target

    Products have different margins, so they have different break-even ACOS figures. One target across a catalogue overspends on the thin ones and starves the strong ones.

ANALYSE IT

SP Advertised Product Report

Your Advertised Product report rolled up per ASIN instead of per campaign row. Separates the ACoS Amazon reports from the ACoS on the product actually advertised — a product can pass on the first and lose money on the second.

  • Per-ASIN Roll-up
  • Advertised vs Reported ACoS
  • Product-level Profit
Open SP Products

The file is parsed in your browser. Report rows never reach our servers.

Reports to pull alongside it.