IAC - Source Data
  • Source Data Models
  • Data Models
    • Amazon Source Data
      • Sponsored Ads
        • Sponsored Products
        • Sponsored Brands
        • Sponsored Display
        • Sponsored Television
      • Amazon Marketing Stream
      • Seller Central
        • Replenishment Reports
        • Business Reports
        • Order Reports
        • Inventory Reports
        • Fulfillment By Amazon
        • Performance Reports
        • Settlement Reports
        • Returns Reports
        • Finance Reports
      • Vendor Central
      • Brand Analytics Reports
      • Content Product Listing
      • Share of Voice
      • Amazon Marketing Cloud
      • Amazon DSP
      • Others
    • Criteo Source Data
      • Sponsored Ads
    • Walmart Source Data
      • Sponsored Ads
      • Marketplace Reports
  • Instacart Source Data
    • Instacart Source Data
Powered by GitBook
On this page
  • Sponsored Television Campaign
  • Sponsored Television Campaign Report
  • Sponsored Television Advertised Product
  • Sponsored Television Advertised Product Report
  • Sponsored Television Target
  • Sponsored Television Target Report

Was this helpful?

  1. Data Models
  2. Amazon Source Data
  3. Sponsored Ads

Sponsored Television

PreviousSponsored DisplayNextAmazon Marketing Stream

Last updated 9 days ago

Was this helpful?

Sponsored Television Campaign

Table name: ad_sponsoredtelevision_campaign

For details on data availability and refresh schedule, please click .

Column Name
Data type
Description

profile_id

Integer

The identifier of the amazon advertising account

account_id

Integer

Intentwise account id

account_name

String

Intentwise account name

campaignid

Integer

The identifier of the campaign

name

String

The name of the campaign

portfolioid

Integer

The identifier of an existing portfolio to which the campaign is associated.

targetingtype

String

The type of targeting of the campaign. manual or auto

state

String

The current campaign state

dailybudget

Numeric

Daily budget set for the campaign

startdate

date

The starting date of the campaign. The format of the date is YYYY-MM-DD.

enddate

date

The ending date of the campaign to stop running. The format of the date is YYYY-MM-DD.

creationdate

Date time

The creation date of the campaign. The format of the date time is YYYY-MM-DD hh:mm:ss.

lastupdateddate

Date time

The date that any value associated with the campaign was last changed. The format of the date time is YYYY-MM-DD hh:mm:ss

servingstatus

String

Serving status of the campaign

  • CAMPAIGN_PAUSED

  • CAMPAIGN_ARCHIVED

  • CAMPAIGN_STATUS_ENABLED,

  • ADVERTISER_PAYMENT_FAILED,

  • ADVERTISER_PAYMENT_FAILURE,

  • CAMPAIGN_OUT_OF_BUDGET,

  • PENDING_START_DATE, CAMPAIGN_INCOMPLETE, ENDED

biddingstrategy

String

Bidding strategy

  • autoForSales -> Dynamic bids - up and down

  • legacyForSales -> Dynamic bids - down only

  • manual -> Fixed bid

biddingplacamenttopofsearchpercentage

Numeric

The bid adjustment percentage value for Top of search

biddingplacamentproductpagepercentage

Numeric

The bid adjustment percentage value for product details page.

marketplace

String

The Amazon-owned site the product is sold one

Sponsored Television Campaign Report

Table name - ad_sponsoredtelevision_campaign_report

Column Name
Data type
Description

profile_id

integer

The identifier of the amazon advertising account

account_id

integer

Intentwise account id

account_name

string

Intentwise account name

reportdate

date

Report date

campaignid

integer

Campaign id

campaignname

string

Campaign name

campaignstatus

string

Campaign status

campaignbudget

numeric

Campaign budget

impressions

integer

Total ad impressions

clicks

integer

Total ad clicks

cost

numeric

Total cost of all clicks. Can be divided by clicks to obtain average CPC.

attributedsales14dsamesku

numeric

Aggregate value of attributed sales occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised

attributedsales14d

numeric

Number of attributed sales occurring within 14 days of click on ad

attributedconversions14dsamesku

integer

Number of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised

attributedconversions14d

integer

Number of attributed conversion events occurring within 14 days of click on ad

attributedunitsordered14d

integer

Number of attributed units ordered within 14 days of click on ad

topofsearchimpressionshare

integer

Percentage Share of top of search impressions

addtocart

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad view or click

addtocartclicks

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad click

addtocartviews

integer

Number of times shoppers added the brands' products to their cart, attributed to an ad view

brandedsearches

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click or view

brandedsearchesviews

integer

The number of times a branded keyword was searched on Amazon based on the brands associated to the featured ASINs in your campaign, attributed to an ad view

costperthousandimpressions

numeric

The cost per thousand impressions

detailpageviews

integer

Number of detail page views occurring within 14 days of an ad click or view

detailpageviewsclicks

integer

Number of detail page views occurring within 14 days of an ad click

detailpageviewsviews

integer

The number of times a product detail page was viewed attributed to an ad view

frequencyaverage

numeric

The number of times an ad is served to an individual/ device/ account in a period

householdfrequencyaverage

numeric

The number of times an ad is served to a household in a period

householdreach

integer

The number of unique households an ad impression is served to in a period

newtobrandpurchasesviews

integer

The number of new to branch purchases attributed to an ad view

newtobrandsalesviews

numeric

Total value of sales by new to brand customers occurring within 14 days of an ad view

portfolioid

integer

The portfolio the campaign is associated with

purchasesviews

integer

Number of attributed conversion events occurring within 14 days of an ad view

reach

integer

The number of unique individuals an ad impression is served to in a period

roas

numeric

Return on ad spend

salesviews

numeric

Total value of sales occurring within 14 days of an ad view

unitssoldviews

integer

Number of attributed units sold within 14 days of an ad view

Sponsored Television Advertised Product

Table name - ad_sponsoredtelevision_productads

Column Name
Data type
Description

profile_id

integer

Amazon advertising account id

account_id

integer

Intentwise account id

account_name

string

Intentwise account name

adid

integer

The identifier of the advertised product

adgroupid

integer

The identifier of the adgroup

campaignid

integer

The identifier of the campaign

asin

string

The ASIN that is being advertised.

sku

string

The SKU that is being advertised. Not available for vendors.

state

string

ASIN state

creationdate

timestamptz(0)

ASIN created date

lastupdateddate

timestamptz(0)

ASIN last updated date

servingstatus

string

Serving status of the Advertised Product

  • AD_ARCHIVED

  • AD_PAUSED

  • AD_STATUS_LIVE

  • AD_POLICING_SUSPENDED

  • CAMPAIGN_OUT_OF_BUDGET

  • AD_GROUP_PAUSED

  • AD_GROUP_ARCHIVED

  • CAMPAIGN_PAUSED

  • CAMPAIGN_ARCHIVED

  • ACCOUNT_OUT_OF_BUDGET

  • MISSING_DECORATION, PENDING_START_DATE

ad_name

string

Ad Name

Sponsored Television Advertised Product Report

Table name - ad_sponsoredtelevision_productads_report

Column Name
Data type
Description

profile_id

integer

The identifier of the amazon advertising account

account_id

integer

Intentwise account id

account_name

string

Intentwise account name

report_date

date

Report date

adid

integer

The identifier of the advertised product

adgroupid

integer

The identifier of the adgroup

impressions

integer

Total ad impressions

clicks

integer

Total ad clicks

cost

numeric

Total cost of all clicks. Can be divided by clicks to obtain average CPC

attributedsales14dsamesku

numeric

Aggregate value of attributed sales occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised

attributedsales14d

numeric

Number of attributed sales occurring within 14 days of click on ad

attributedconversions14dsamesku

integer

Number of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised

attributedconversions14d

integer

Number of attributed conversion events occurring within 14 days of click on ad

attributedunitsordered14d

integer

Number of attributed units ordered within 14 days of click on ad

Sponsored Television Target

Table name - ad_sponsoredtelevision_target

Column Name
Data type
Description

profile_id

integer

Amazon advertising account id

account_id

integer

Intentwise account id

account_name

string

Intentwise account name

targetid

integer

Target id

adgroupid

integer

Adgroup id

campaignid

integer

Campaign id

expressiontype

string

state

string

Product target state

bid

numeric

creationdate

timestamptz(0)

Product target created date

lastupdateddate

timestamptz(0)

Product target last updated date

autoexpressionvalue

string

asinpricelessthan

numeric

Target a price that is less than the price expressed

asinpricegreaterthan

numeric

Target a price that is greater than the price expressed

asinreviewratinglessthan

numeric

Target a review rating less than the review rating that is expressed

asinreviewratinggreaterthan

numeric

Target a review rating that is greater than the review rating expressed

asincategorysameas

string

Negatively Target the same category as the category expressed

asinbrandsameas

string

Target the brand that is the same as the brand expressed

asinpricebetween

string

Target a price that is between the prices expressed

asinreviewratingbetween

string

Target a review rating that is between the review ratings expressed

asinsameas

string

Target an ASIN that is the same as the ASIN expressed

asinisprimeshippingeligible

string

Target products that are Prime Shipping Eligible. This refinement can be applied at a category or brand level only

asinagerangesameas

string

Target an age range that is in the expressed range. This refinement can be applied for toys and games categories only

asingenresameas

string

Target products related to the expressed genre. This refinement can be applied for Books and eBooks categories only

asincategorysimilartoexpression

audiencesameasinmarket

contentcategorysimilartoexpression

asincategorysimilarto

audiencesameasinmarket

contentcategorysimilarto

servingstatus

string

The status of the target. TARGETING_CLAUSE_ARCHIVED, TARGETING_CLAUSE_PAUSED, TARGETING_CLAUSE_STATUS_LIVE, TARGETING_CLAUSE_POLICING_SUSPENDED, CAMPAIGN_OUT_OF_BUDGET, AD_GROUP_PAUSED, AD_GROUP_ARCHIVED, CAMPAIGN_PAUSED, CAMPAIGN_ARCHIVED, ACCOUNT_OUT_OF_BUDGET, PENDING_START_DATE

Sponsored Television Target Report

Table name - ad_sponsoredtelevision_target_report

Column Name
Data type
Description

profile_id

Integer

Amazon advertising account id

account_id

Snteger

Intentwise account id

account_name

String

Intentwise account name

reportdate

Date

Report date

targetid

Integer

Target id

impressions

Integer

Total ad impressions

clicks

Integer

Total ad clicks

cost

Numeric

Total cost of all clicks. Can be divided by clicks to obtain average CPC

attributedsales14dsamesku

Numeric

Aggregate value of attributed sales occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised

attributedsales14d

Numeric

Number of attributed sales occurring within 14 days of click on ad

attributedconversions14dsamesku

Integer

Number of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised

attributedconversions14d

Integer

Number of attributed conversion events occurring within 14 days of click on ad

attributedunitsordered14d

Integer

Number of attributed units ordered within 14 days of click on ad

viewimpressions

Integer

Total number of ad viewable impressions

viewattributedconversions14d

Integer

Total number of attributed conversion events occurring within 14 days of ad click or view

viewattributedsales14d

Numeric

Total number of attributed sales occurring within 14 days of ad click or view

viewattributedunitsordered14d

Integer

Total number of attributed units ordered occurring within 14 days of ad click or view

costperthousandimpressions

Numeric

The cost per thousand impressions

detailpageviewsviews

Integer

Number of detail page views for promoted products, attributed to an ad view. Use Total DPV views to see all conversions for the brands' products

detailpageviewsclicks

Integer

Number of detail page views occurring within 14 days of an ad click

detailpageviews

Integer

Number of detail page views occurring within 14 days of an ad click or view

brandedsearchesviews

Integer

The number of branded search conversions attributed to ad impressions

brandedsearches

Integer

The number of searches that included the name of your brand occurring within 14 days of an ad click or view

newtobrandpurchasesviews

Integer

The number of new to branch purchases attributed to an ad view

videocompleteviews

Integer

The number of impressions where the video was viewed to 100%

videofirstquartileviews

Integer

The number of impressions where the video was viewed to 25%

videomidpointviews

Integer

The number of impressions where the video was viewed to 50%

videothirdquartileviews

Integer

The number of impressions where the video was viewed to 75%

addtocart

Integer

Number of times shoppers added a brand's products to their cart, attributed to an ad view or click

addtocartviews

Integer

Number of times shoppers added the brands' products to their cart, attributed to an ad view

addtocartclicks

Integer

Number of times shoppers added a brand's products to their cart, attributed to an ad click

roas

Numeric

Return on ad spend

salesviews

Numeric

Total value of sales occurring within 14 days of an ad view

newtobrandsalesviews

Numeric

Total value of sales by new to brand customers occurring within 14 days of an ad view

purchasesviews

Integer

Number of attributed conversion events occurring within 14 days of an ad view

unitssoldviews

Integer

Number of attributed units sold within 14 days of an ad view

For details on data availability and refresh schedule, please click

For details on data availability and refresh schedule, please click

For details on data availability and refresh schedule, please click

For details on data availability and refresh schedule, please click

For details on data availability and refresh schedule, please click

here
here
here
here
here
here