This table includes Sponsored Products performance data, by campaign, by advertised ASIN, by day. It's most useful for diving into your SP advertising performance by which ASIN was advertised.
This table breaks out your attributed units, orders, and revenue by advertised SKU sales vs. other SKU sales, summed together as total sales. This breakdown can help you understand whether and how Amazon customers cross-shop your products.
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
- advertised_asin
- advertised_sku
Key Metrics
clicks
impressions
spend
click_thru_rate_ctr
budget
1_day_total_sales
7_day_total_sales
14_day_total_sales
30_day_total_sales
Data Dictionary
⬅️ Go back to the Help Center
