Search

SP Advertised Products
SP Advertised Products

SP Advertised Products

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

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

Data Dictionary

⬅️ Go back to the Help Center

image