Sponsored Television
Last updated
Was this helpful?
Last updated
Was this helpful?
Table name: ad_sponsoredtelevision_campaign
For details on data availability and refresh schedule, please click .
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
Table name - ad_sponsoredtelevision_campaign_report
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
Table name - ad_sponsoredtelevision_productads
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
Table name - ad_sponsoredtelevision_productads_report
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
Table name - ad_sponsoredtelevision_target
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
Table name - ad_sponsoredtelevision_target_report
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