Search

SP Search Terms
SP Search Terms

SP Search Terms

đź“‚
Amazon Advertising report path Advertising > Campaign Manager
icon
Table name ads_sponsored_products_search_term

This table includes Sponsored Products performance data, by campaign, by keyword, by day. It's most useful for diving into your SP advertising keyword targeting strategy and measuring its performance over time.

The table includes match type (broad, exact, phrase), targeted term, and customer's actual search term or phrase. This table does not include automated targeting data. Automatically-targeted campaigns show up with "*" in their targeting. However, it does show the customer search terms used.

Rolling Attribution Window

All advertising tables contain 1- 7- or 14 & 30-day attributions . This means that Amazon will attribute 1-30 days of units, revenue, and orders to advertising activity on the date of the record.

What this means for you: your attributed data will not fully settle for 7-30 days. Said plainly, there's still time for customers who saw your ads to decide to buy your product—and have that purchase attributed to the ad.

Reason Automation's daily updates include a 30-day lookback in order to capture these attribution changes. We recommend that our customers wait at least two weeks before judging the overall effectiveness of their ads.

Statistics

Updated: Daily

Backfill: 60 days

How to use: You should look at

  • Campaign Id
  • Keyword Type

Data Dictionary

⬅️ Go back to the Help Center

image