SP Search Term Impression Rank
SP Search Term Impression Rank

SP Search Term Impression Rank

icon
Table name Vendor: ads_sponsored_products_search_term_impression_rank_vc Seller: ads_sponsored_products_search_term_impression_rank

This table includes Sponsored Products impression share data by search terms. It's most useful for understanding the competitive advertising landscape for search terms you are bidding on.

Rolling Attribution Window

All advertising tables contain 7- or 14-day attribution (depending on if you are a Seller or Vendor). This means that Amazon will attribute 7-14 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-14 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 14-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 Type (Sponsored Products, Sponsored Brands, etc.)
  • Report Type (Campaign, Targeting, etc.)

Key Metrics

customer_search_term

search_term_impression_rank

search_term_impression_share

total_advertising_cost_of_sales_acos

total_return_on_advertising_spend_roas

Data Dictionary

⬅️ Go back to the Help Center

image
SP TargetingSP Targeting