Amazon Advertising Product Report

Advertised product metrics including SKU, ASIN, spend, attributed sales, ACOS, ROAS, and units sold per campaign

Use cases to connect google sheets to amazon and ecommerce

4.8 Rating · 11k+ Downloads · Trusted by Sellers

Encased
Pet Lovers
Vahdam Teas
Boldify
Viva Naturals
Hyperzon
Ridgeline Insights
Lovebug Probiotics
Encased
Pet Lovers
Vahdam Teas
Boldify
Viva Naturals
Hyperzon
Ridgeline Insights
Lovebug Probiotics
Last updated -
June 18, 2026

Review Summary

✅ Advertised product-level data combining Sponsored Products, Sponsored Brands, and Sponsored Display into a single report — no separate pulls required.

✅ SKU and ASIN identifiers with spend, attributed sales, purchases, and units sold across 1, 7, 14, and 30-day attribution windows per campaign.

✅ Click-attributed sales and purchases plus same-SKU breakdowns to separate direct product revenue from halo sales.

The Amazon Advertising Product Report is an advertised product-level breakdown of Amazon Advertising performance data. It covers spend, attributed sales, purchases, units sold, ACOS, ROAS, and click-attributed metrics for every SKU and ASIN being advertised, with each row tied to its parent campaign. This report is part of our Amazon Advertising API Reports dataset.

Supported Fields

|Report Name|API|Field Name|Description| |---|---|---|---| |Product Report|Amazon Ads API|Marketplace|Amazon Ads marketplace tied to the advertising profile| |Product Report|Amazon Ads API|Ads Type|Amazon ad product type| |Product Report|Amazon Ads API|SKU|Advertised SKU| |Product Report|Amazon Ads API|ASIN|Advertised ASIN| |Product Report|Amazon Ads API|Campaign|Campaign name| |Product Report|Amazon Ads API|Purchases|Attributed purchase count| |Product Report|Amazon Ads API|Purchases Clicks|Purchases attributed to ad clicks| |Product Report|Amazon Ads API|Purchases Promoted Clicks|Purchases of promoted products attributed to ad clicks| |Product Report|Amazon Ads API|Purchases 1d|Attributed purchases within 1 day| |Product Report|Amazon Ads API|Purchases 7d|Attributed purchases within 7 days| |Product Report|Amazon Ads API|Purchases 14d|Attributed purchases within 14 days| |Product Report|Amazon Ads API|Purchases 30d|Attributed purchases within 30 days| |Product Report|Amazon Ads API|Purchases Same Sku 1d|Same-SKU attributed purchases within 1 day| |Product Report|Amazon Ads API|Purchases Same Sku 7d|Same-SKU attributed purchases within 7 days| |Product Report|Amazon Ads API|Purchases Same Sku 14d|Same-SKU attributed purchases within 14 days| |Product Report|Amazon Ads API|Purchases Same Sku 30d|Same-SKU attributed purchases within 30 days| |Product Report|Amazon Ads API|Sales Clicks|Sales attributed to ad clicks| |Product Report|Amazon Ads API|Sales Promoted Clicks|Promoted product sales attributed to ad clicks| |Product Report|Amazon Ads API|Sales|Total attributed sales| |Product Report|Amazon Ads API|Sales 1d|Attributed sales within 1 day| |Product Report|Amazon Ads API|Sales 7d|Attributed sales within 7 days| |Product Report|Amazon Ads API|Sales 14d|Attributed sales within 14 days| |Product Report|Amazon Ads API|Sales 30d|Attributed sales within 30 days| |Product Report|Amazon Ads API|Spend|Total ad spend| |Product Report|Amazon Ads API|Units Sold|Attributed units sold| |Product Report|Amazon Ads API|Units Sold Clicks|Units sold attributed to ad clicks| |Product Report|Amazon Ads API|Impressions|Number of ad impressions| |Product Report|Amazon Ads API|Clicks|Number of ad clicks| |Product Report|Amazon Ads API|Cpc|Average cost per click| |Product Report|Amazon Ads API|Ctr|Clicks divided by impressions| |Product Report|Amazon Ads API|Acos|Advertising cost of sales| |Product Report|Amazon Ads API|Roas|Return on ad spend| |Product Report|Amazon Ads API|Orders|Attributed order count|

What Sellers Use This For

Identifying which ASINs generate the best ad return. ACOS and ROAS per SKU and ASIN show exactly which products deserve more ad budget and which are wasting spend.

Separating same-SKU revenue from halo sales. Same-SKU purchase and sales fields isolate revenue on the advertised product so you are not crediting ad spend with sales it did not directly drive.

Comparing performance across campaigns per product. Each row ties to a campaign name, so you can see whether the same ASIN performs differently across Sponsored Products, Sponsored Brands, and Sponsored Display.

Tracking units sold by attribution window. Sales across 1, 7, 14, and 30-day windows show how your conversion timeline varies by product so you can match your bidding strategy to actual buyer behavior.

How Gorilla ROI Pulls This Data

Gorilla ROI connects to the Amazon Ads API using the AdvertisedProduct operation. Sponsored Products, Sponsored Brands, and Sponsored Display data are combined into a single pull — no separate reports to merge manually. Data updates automatically on a regular schedule. No csv exports. No manual downloads. The numbers are current the moment you open the sheet. Feed AI with our data to stay on top and ahead of your business.

For field definitions, see the Amazon Seller Data Supported article in our help center.

Other Amazon Advertising API Reports and Fields

|Report|What It Covers|Fields| |---|---|---| |[Ads Overview Report](/amazon-advertising-api-reports/ads-overview/)|Cross-campaign ad metrics including impressions, spend, ACOS, ROAS, new-to-brand orders, video engagement, and detail page views|38| |[Campaign Report](/amazon-advertising-api-reports/campaign/)|Campaign-level spend, attributed sales, purchases, and units sold across 1, 7, 14, and 30-day windows with same-SKU breakdowns, new-to-brand metrics, and video engagement|69| |[Group Report](/amazon-advertising-api-reports/group/)|Ad group-level spend, attributed sales, purchases, and units sold tied to both ad group and parent campaign, with same-SKU and new-to-brand breakdowns|44| |[Keyword Report](/amazon-advertising-api-reports/keyword/)|Keyword and targeting term performance including impressions, clicks, spend, ACOS, ROAS, orders, and conversion rate|14| |[Product Report](/amazon-advertising-api-reports/product-ads/)|Advertised product performance by SKU and ASIN with spend, attributed sales, purchases, and units sold across 1, 7, 14, and 30-day windows plus same-SKU breakdowns|33| |[Search Term Report](/amazon-advertising-api-reports/search-term/)|Customer search term-level performance showing exact queries that triggered ads with spend, attributed sales, ACOS, ROAS, new-to-brand units, and conversion fields across multiple attribution windows|52|

Frequently
Asked Questions

Black upward arrow on white background

What is a Seller Central report?

Amazon generates structured data sets from your account activity. Each report covers a specific area: orders, inventory, settlements, fees, reimbursements, and more. The fields on each page show exactly what data that report contains and how it is labeled in Amazon's system.

Black upward arrow on white background

Where does Gorilla ROI get this data?

We pull directly from Amazon's Selling Partner API. No third-party intermediaries. No manual csv exports. The data comes from Amazon's own reporting infrastructure, the same source Seller Central uses to generate your reports.

Black upward arrow on white background

How current is the data once it's connected?

Data refreshes automatically on a regular schedule. The exact cadence varies by report type based on how frequently Amazon makes that data available through the API.

Black upward arrow on white background

Do I need to download anything or export from Seller Central?

No. Once connected, your account data pulls automatically. There are no csv files to export, no manual steps, and no scheduled downloads to manage.

Black upward arrow on white background

Can I pull multiple reports at the same time?

Yes. Each report maps to a separate dataset. You can pull as many as your account supports and work with them side by side.

Black upward arrow on white background

What does the "API" column in the field table mean?

It identifies which Amazon SP-API endpoint provides that data. Different report types pull from different APIs: the Reports API, Orders API, FBA Inventory API, Product Pricing API, and others. This helps you understand the data source behind each field.

Black upward arrow on white background

Are all fields listed on each page actually available in my account?

Field availability depends on your seller account type and the marketplaces you sell in. FBA-specific fields, for example, are not available to FBM-only accounts. The fields listed reflect what Amazon exposes through the API for that report.

Black upward arrow on white background

What if I don't see a report I need?

Check the data-supported page for the full list of reports we pull. If the report you need is not there, contact our support team. We add reports based on seller demand.

Manual Exports Waste Your Team's Time

Replace the Manual Spreadsheet Work and Save 40 Hours a Month