This table includes Sponsored Products budget data, by campaign name and type. It's most useful for diving into your SP advertising performance and understanding lost opportunity.
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
campaign_name
budget
recommended_budget
avg_time_in_budget
est_missed_impressions_min
est_missed_impressions_max
est_missed_clicks_min
est_missed_clicks_max
est_missed_sales_min
est_missed_sales_max
Data Dictionary
