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
Key Metrics
keyword_id
keyword_bid
14_day_total_sales
acos_clicks_14d
Data Dictionary
⬅️ Go back to the Help Center
