Report directory

Every Amazon and Walmart report, explained

What each export actually contains, what one row means, how to pull it from Seller Central, Vendor Central, the Amazon Ads console or Walmart — and the gotchas that quietly break the numbers.

Amazon Ads Console

Advertising Performance

Amazon Sponsored Products Campaign Placement Report

The Sponsored Products campaign placement report is the campaign report cut by where the ad was shown — one row per campaign per placement per day, with spend, impressions, clicks and the attributed purchases, units and sales behind them at 1, 7, 14 and 30 day windows. It answers the question the campaign report cannot, which is whether Top of Search, product detail pages or everything else is where the money went and where the sales came back from.

One row per placement

Daily

fields

Amazon Ads Console

Advertising Performance

Amazon Sponsored Products Campaign Report

The Sponsored Products campaign report gives you one row per campaign per day — spend, impressions, clicks and the attributed sales and units behind them, at four attribution windows from 1 to 30 days. It is the report every ACOS and ROAS number ultimately comes from, and the four windows are the reason two people can quote different ACOS for the same campaign and both be right.

Search Terms & Keywords

Amazon Sponsored Products Keyword Report

The Sponsored Products keyword report gives you one row per manual keyword per day — broad, phrase and exact — with the keyword's bid, impressions, clicks, cost, top-of-search share and the attributed purchases, units and sales behind them at 1, 7, 14 and 30 days. It is the keyword half of Amazon's spTargeting report, the same request as the targeting report filtered to the three keyword match types, and the report where a keyword's bid and what the auction actually charged for it sit on the same row.

Search Terms & Keywords

Amazon Sponsored Products Search Term Report (Manual Keywords)

The Sponsored Products search term report for manual targeting gives you one row per manual keyword per shopper search term per day — the query a shopper actually typed, the broad, phrase or exact keyword that caught it, and the impressions, clicks, cost and attributed sales that followed. It is the file keyword harvesting and negative-keyword lists are built from, and the column most people misread is search_term, which equals the keyword on about a quarter of rows and not on the rest.

One row per search term

Daily

fields

Amazon Seller Central

Replenishment & Subscribe and Save

Amazon Subscribe & Save Offer Metrics Report (Replenishment API)

Amazon's Replenishment API offer metrics give you one row per Subscribe & Save offer per day, identified by ASIN and SKU, carrying the subscriptions active on the offer, the subscription units and revenue that shipped, the revenue lost to out-of-stock deliveries, and the share of the offer's revenue and subscriptions that run through the program. It is pulled live from the listOfferMetrics endpoint rather than as a Reports API file, and since December 2025 it is the only programmatic source of per-ASIN Subscribe & Save performance Amazon offers.

One row per offer

Daily

fields

Amazon Seller Central

Replenishment & Subscribe and Save

Amazon Subscribe & Save Offers Report (Replenishment API listOffers)

Amazon's Replenishment API listOffers report is the configuration side of Subscribe & Save: one row per offer, identified by SKU and ASIN, carrying whether the offer is eligible for the program, its price, the inventory behind it, how many subscriptions it holds, how the discount is split between Amazon funding and seller funding, and how many subscription deliveries are due in the next 15, 30, 60 and 90 days. A second table lists, per offer, the delivery conditions those upcoming deliveries are under. Amazon keeps no history of any of it, so the only time series that can exist is the one you build by snapshotting it.

One row per offer

Point-in-time snapshot

fields

Amazon Seller Central

Replenishment & Subscribe and Save

Amazon Subscribe & Save Selling Partner Metrics Report

Amazon's Selling Partner Metrics from the Replenishment API is the account-level view of your Subscribe & Save business, one marketplace at a time. The daily rows carry active subscriptions, shipped units, subscription revenue, revenue lost to stock-outs and how much of your revenue comes through the program; alongside them Amazon returns subscriber retention at 30 and 90 days, lifetime value by customer segment, and revenue penetration and signup conversion split by how much of the discount you fund. Since Amazon retired the Subscribe & Save flat files in December 2025, this API is where those numbers live.

One row per day

Daily

fields

Amazon Vendor Central

Promotions & Coupons

Amazon Vendor Coupon Performance Report

The vendor coupon performance report is the first-party view of Amazon coupons — the one Vendor Central credentials get back, not the seller one. Amazon answers with a list of campaigns, each carrying a vendor code and its own clip and redemption totals, each holding coupons with their budgets and spend, and each coupon holding the ASINs it discounts. That nesting means one file is really three row grains, and the coupon is the row worth reading.

One row per coupon

Point-in-time snapshot

fields