Amazon Ads Deep-Dive AMAZON

Pure ads optimization across SP, SB and SD — kill, scale, harvest.

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). IMPORTANT: each filename must contain the month and year, e.g. "SP Search Term Jun 2026.xlsx".

FILE 02 · OPTIONAL

Amazon MTR B2C (.csv) — optional

Seller Central → Reports → Manage Taxes → GST Monthly Reports → Download Report → Merchant Tax Report (MTR) → B2C → select the month → Download Report. Enables true TACOS.

FILE 03 · OPTIONAL

Amazon MTR B2B (.csv) — optional

Same path, MTR → B2B (only if you sell on Amazon Business). Added to B2C for total Real Sales / TACOS. Filename must contain the month + year, e.g. MTR_B2B_May_2026.csv.

Step 2 — Upload & generate

Log in to generate this report. New sellers get 3 free reports a month.

What this report does

✓Search Term, Targeting, Advertised Product, Placement and Campaign — every angle in one workbook

✓Clear action per line: Kill, Negate, Fix Bid, Harvest, Scale or TOS Boost — plus Hero and Bleeder SKUs

✓Wasted spend surfaced separately from spend that converts, so cuts are safe

✓True TACOS on real sales when you add MTR (B2C + B2B); stock-aware flags when you add inventory

✓Consolidated Action List with estimated annual ₹ impact + a ready-to-paste Negative Keyword export

Use case

Run monthly (or fortnightly at scale): cut wasted spend, harvest converting search terms into exact targets, push winners and rein in bleeders — a prioritised task list your team runs straight in Campaign Manager.