AMC analysis for Sponsored TV: tables, fields, example

The table

Sponsored ads events are in sponsored_ads_traffic (audience variant: sponsored_ads_traffic_for_audiences). The table contains impression events, click events and video creative messages from Sponsored Products, Sponsored Brands, Sponsored Display and Sponsored TV. There is one record per impression and one per click.

Use the field ad_product_type to filter to the product. For this page: sponsored_television. Possible values according to Amazon are sponsored_products, sponsored_brands, sponsored_display and sponsored_television.

What matters for this ad type

• The value is sponsored_television, not sponsored_tv. A filter with the wrong value returns no rows.
• According to Amazon the table contains impression events, click events and video creative messages from Sponsored Products, Brands, Display and TV.

Example

SELECT
  campaign,
  SUM(impressions) AS impressions,
  SUM(clicks) AS clicks,
  SUM(spend) / 100000000 AS spend_in_currency
FROM
  sponsored_ads_traffic
WHERE
  ad_product_type = 'sponsored_television'
GROUP BY
  campaign

Units

spend is stated in microcents. Divide by 100,000,000 to get dollars or your local currency (100,000,000 microcents are 1 dollar). The currency is in the field currency_name.