Amazon Ads Deep-Dive AMAZON

Ads optimization plus an ads-push view: which SKUs have no ads, and which ad type each should get.

Step 1 — Download these files from the marketplace

FILE 01

Amazon Ads reports (.xlsx/.csv) — multiple files

Campaign Manager → Measurement & Reporting → Sponsored Ads Reports → Create Report → Search Term, Targeting, Advertised Product, Placement and Campaign reports (SP/SB/SD — whatever you run). Do not upload the Bulk file. Each filename should contain the month and year, e.g. "SP Search Term Sep 2026.xlsx".

FILE 02 · OPTIONAL

Amazon MTR B2C (.csv) — picked up from Listing Performance, extra upload optional

Taken automatically from the MTR you already added for Amazon Listing Performance in the same month. Upload here only to use a different file.

FILE 03 · OPTIONAL

Business Report — Detail Page Sales and Traffic by SKU (.csv) — picked up from Listing Performance, extra upload optional

Taken automatically from the Business Report you already added for Amazon Listing Performance in the same month. Upload here only to use a different file.

FILE 04 · OPTIONAL

Inventory by SKU (.csv/.xlsx/.txt) — optional, picked up from Listing Performance

Taken automatically from the Inventory file added for Amazon Listing Performance in the same month. It only adds the Stock No Sales sheet; it is not used to judge which SKUs need ads.

Step 2 — Upload & generate

Log in to generate this report. New sellers get 15 free reports every month.

What this report does

✓All the Ads Deep-Dive sheets, with a Priority on every action

✓Non-Ads SKUs: SKUs that sell or get traffic but run no SP/SD ads, ranked by real sales

✓Ads Push Plan: what to launch or raise first, with ad type (SP, SB, SD) and a starting daily budget

✓Uses your MTR and Business Report (traffic, conversion, Buy Box) for real sales and true TACOS

✓Stock No Sales (with an Inventory file): aged stock, ads that do not sell, listings to fix first

Use case

Run monthly: everything the Ads Deep-Dive does (wasted spend, bids, negatives, placements, SD), plus the question it could not answer: which of your SKUs sell or get visits with no ads, which should be pushed first, with which ad type and what daily budget. Also lists stock that is not selling.