Amazon Ads: add Search Term reports (spSearchTerm / sbSearchTerm) with keyword-level fields#1818
The Amazon Ads connector currently stops at campaign/ASIN level. There is no keyword or search term data available, which makes the connector unusable for search term analysis, negative keyword harvesting, and keyword-level bid optimization.
Request
Add the Search Term reports from the Amazon Ads Reporting API v3:
spSearchTerm(Sponsored Products)sbSearchTerm(Sponsored Brands)
Needed fields (per day)
- campaign ID
- ad group ID
- keyword ID
- keyword text
- match type
- search term
- impressions
- clicks
- cost
- sales 7d / 14d
- purchases
- units
Example of the granularity we need (one row per search term per day):
{“profile_id”:4817263905142876,”date”:”2026-04-11”,”ad_product”:”SPONSORED_PRODUCTS”,”campaign_id”:31549872046183,”ad_group_id”:748213056912447,”keyword_id”:602918473355812,”keyword_text”:”loose-match”,”match_type”:”TARGETING_EXPRESSION_PREDEFINED”,”search_term”:”handdoeken”,”impressions”:312,”clicks”:3,”cost”:”1.9400”,”sales_7d”:”0.0000”,”sales_14d”:”0.0000”,”orders”:0,”units”:0,”conversions”:0}
Versus what the connector exposes today (campaign level only):
{“profile_id”:4817263905142876,”date”:”2026-03-24”,”ad_product”:”SPONSORED_PRODUCTS”,”campaign_id”:74203158969421,”campaign_name”:”Towels - Acme Home - SP - Branded Manual”,”impressions”:428,”clicks”:4,”cost”:”3.0500”,”sales_7d”:”89.9500”,”sales_14d”:”112.4000”,”orders”:2,”units”:3,”conversions”:0}