Amazon Advertising Search Term Report

Customer search term metrics including spend, attributed sales, ACOS, ROAS, conversions, and new-to-brand units per matched keyword

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

✅ Customer search term data combining Sponsored Products, Sponsored Brands, and Sponsored Display into a single report — showing exact queries that triggered your ads with spend, attributed sales, purchases, and units sold across 1, 7, 14, and 30-day attribution windows.

✅ ACOS, ROAS, CPC, CTR, conversion rate, and viewable impressions per search term and matched keyword combination.

✅ New-to-brand units ordered, same-SKU sales, and conversion fields across multiple attribution windows to measure true search term profitability.

The Amazon Advertising Search Term Report is a customer search term-level breakdown of Amazon Advertising performance data. It shows the exact queries that triggered your ads alongside spend, attributed sales, purchases, units sold, ACOS, ROAS, and new-to-brand metrics, with each row tied to the keyword or targeting term that matched the search. This report is part of our Amazon Advertising API Reports dataset.

Supported Fields

|Report Name|API|Field Name|Description| |---|---|---|---| |Search Term Report|Amazon Ads API|Marketplace|Amazon Ads marketplace tied to the advertising profile| |Search Term Report|Amazon Ads API|Ads Type|Amazon ad product type| |Search Term Report|Amazon Ads API|Search Term|Customer search term| |Search Term Report|Amazon Ads API|Campaign Name|Campaign name| |Search Term Report|Amazon Ads API|Keyword|Keyword or targeting text that matched the search term| |Search Term Report|Amazon Ads API|Purchases 1d|Attributed purchases within 1 day| |Search Term Report|Amazon Ads API|Purchases 7d|Attributed purchases within 7 days| |Search Term Report|Amazon Ads API|Purchases 14d|Attributed purchases within 14 days| |Search Term Report|Amazon Ads API|Purchases 30d|Attributed purchases within 30 days| |Search Term Report|Amazon Ads API|Purchases Same Sku 1d|Same-SKU attributed purchases within 1 day| |Search Term Report|Amazon Ads API|Purchases Same Sku 7d|Same-SKU attributed purchases within 7 days| |Search Term Report|Amazon Ads API|Purchases Same Sku 14d|Same-SKU attributed purchases within 14 days| |Search Term Report|Amazon Ads API|Purchases Same Sku 30d|Same-SKU attributed purchases within 30 days| |Search Term Report|Amazon Ads API|Sales|Total attributed sales| |Search Term Report|Amazon Ads API|Sales 1d|Attributed sales within 1 day| |Search Term Report|Amazon Ads API|Sales 7d|Attributed sales within 7 days| |Search Term Report|Amazon Ads API|Sales 14d|Attributed sales within 14 days| |Search Term Report|Amazon Ads API|Sales 30d|Attributed sales within 30 days| |Search Term Report|Amazon Ads API|Sales Same Sku 1d|Same-SKU attributed sales within 1 day| |Search Term Report|Amazon Ads API|Sales Same Sku 7d|Same-SKU attributed sales within 7 days| |Search Term Report|Amazon Ads API|Sales Same Sku 14d|Same-SKU attributed sales within 14 days| |Search Term Report|Amazon Ads API|Sales Same Sku 30d|Same-SKU attributed sales within 30 days| |Search Term Report|Amazon Ads API|Spend|Total ad spend| |Search Term Report|Amazon Ads API|Units Sold|Attributed units sold| |Search Term Report|Amazon Ads API|Units Sold 14d|Attributed units sold within 14 days| |Search Term Report|Amazon Ads API|Units Ordered New To Brand 14d|New-to-brand units ordered within 14 days| |Search Term Report|Amazon Ads API|Units Ordered New To Brand Percentage 14d|Percentage of units ordered from new-to-brand customers within 14 days| |Search Term Report|Amazon Ads API|Units Sold Clicks|Units sold attributed to ad clicks| |Search Term Report|Amazon Ads API|Units Sold Clicks 1d|Units sold from clicks within 1 day| |Search Term Report|Amazon Ads API|Units Sold Clicks 7d|Units sold from clicks within 7 days| |Search Term Report|Amazon Ads API|Units Sold Clicks 14d|Units sold from clicks within 14 days| |Search Term Report|Amazon Ads API|Units Sold Clicks 30d|Units sold from clicks within 30 days| |Search Term Report|Amazon Ads API|Units Sold Same Sku 1d|Same-SKU units sold within 1 day| |Search Term Report|Amazon Ads API|Units Sold Same Sku 7d|Same-SKU units sold within 7 days| |Search Term Report|Amazon Ads API|Units Sold Same Sku 14d|Same-SKU units sold within 14 days| |Search Term Report|Amazon Ads API|Units Sold Same Sku 30d|Same-SKU units sold within 30 days| |Search Term Report|Amazon Ads API|Impressions|Number of ad impressions| |Search Term Report|Amazon Ads API|Clicks|Number of ad clicks| |Search Term Report|Amazon Ads API|Cpc|Average cost per click| |Search Term Report|Amazon Ads API|Ctr|Clicks divided by impressions| |Search Term Report|Amazon Ads API|Acos|Advertising cost of sales| |Search Term Report|Amazon Ads API|Roas|Return on ad spend| |Search Term Report|Amazon Ads API|Conversion Rate|Conversion rate| |Search Term Report|Amazon Ads API|Viewable Impressions|Viewable ad impressions| |Search Term Report|Amazon Ads API|Orders|Attributed order count| |Search Term Report|Amazon Ads API|Conversion|Attributed conversion count| |Search Term Report|Amazon Ads API|Conversion 1d|Conversions within 1 day| |Search Term Report|Amazon Ads API|Conversion 7d|Conversions within 7 days| |Search Term Report|Amazon Ads API|Conversion 14d|Conversions within 14 days| |Search Term Report|Amazon Ads API|Conversion 30d|Conversions within 30 days| |Search Term Report|Amazon Ads API|Acos Clicks 7d|ACOS based on 7-day click-attributed sales| |Search Term Report|Amazon Ads API|Acos Clicks 14d|ACOS based on 14-day click-attributed sales| |Search Term Report|Amazon Ads API|Roas Clicks 7d|ROAS based on 7-day click-attributed sales| |Search Term Report|Amazon Ads API|Roas Clicks 14d|ROAS based on 14-day click-attributed sales|

What Sellers Use This For

Finding irrelevant search terms to negate. High spend with zero orders on a search term is your signal to add it as a negative keyword before it drains more budget.

Discovering new keyword opportunities. Search terms converting at low ACOS that you are not bidding on directly are candidates for exact match campaigns.

Measuring same-SKU versus total conversion. Same-SKU sales fields show whether a search term is converting on the advertised product or sending buyers to other ASINs in your account.

Tracking new-to-brand search term performance. Units Ordered New To Brand 14d ties specific customer queries to first-time buyer acquisition so you can see which searches are building your audience.

How Gorilla ROI Pulls This Data

Gorilla ROI connects to the Amazon Ads API using the SearchTerm 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