Schema Information For Amazon Sponsored TV
Schema Information For Amazon Sponsored TV
In this article, we will look at the schema information of the supported APIs and tables for Amazon Sponsored TV.
Find the links to other articles related to Amazon Sponsored TV Below:
- Setup Instructions for Amazon Sponsored TV
- Essential Attributes and Supported Tables for Amazon Sponsored TV
Tables/APIs
Following is the list of tables and their details associated with the Amazon Sponsored TV connector.
Sponsored TV - Raw Data
Ad Groups
Purpose: This API allows users to create, manage, and optimize ad groups within their Amazon Sponsored TV campaigns.
Source API Documentation: Amazon Sponsored TV - Ad Groups
Replication Type: Full Load
Replication Key: N/A
| Field Name | Data Type |
|---|---|
| RequestTime | TIMESTAMP |
| profileId | STRING |
| countryName | STRING |
| accountName | STRING |
| accountId | STRING |
| fetchDate | DATE |
| campaignId | STRING |
| name | STRING |
| state | STRING |
| adGroupId | STRING |
| defaultBid | RECORD |
| extendedData | RECORD |
Ads List
Purpose: This API provides a list of all the ads associated with a particular Amazon Sponsored TV campaign.
Source API Documentation: Amazon Sponsored TV - Ads List
Replication Type: Full Load
Replication Key: N/A
| Field Name | Data Type |
|---|---|
| RequestTime | TIMESTAMP |
| profileId | STRING |
| countryName | STRING |
| accountName | STRING |
| accountId | STRING |
| fetchDate | DATE |
| adName | STRING |
| adId | STRING |
| landingPageValue | STRING |
| landingPageType | STRING |
| campaignId | STRING |
| state | STRING |
| adGroupId | STRING |
| extendedData | RECORD |
Campaigns
Purpose: This API enables users to create, update, and monitor their Amazon Sponsored TV campaigns.
Source API Documentation: Amazon Sponsored TV - Campaigns
Replication Type: Full Load
Replication Key: N/A
| Field Name | Data Type |
|---|---|
| RequestTime | TIMESTAMP |
| profileId | STRING |
| countryName | STRING |
| accountName | STRING |
| accountId | STRING |
| fetchDate | DATE |
| budgetSettings | RECORD |
| endDate | STRING |
| campaignId | STRING |
| costType | STRING |
| name | STRING |
| state | STRING |
| startDate | STRING |
| extendedData | RECORD |
| tags | RECORD |
Targeting Clauses
Purpose: This API allows users to define and manage targeting criteria for their Amazon Sponsored TV ads.
Source API Documentation: Amazon Sponsored TV - Targeting Clauses
Replication Type: Full Load
Replication Key: N/A
| Field Name | Data Type |
|---|---|
| RequestTime | TIMESTAMP |
| profileId | STRING |
| countryName | STRING |
| accountName | STRING |
| accountId | STRING |
| fetchDate | DATE |
| expression | RECORD |
| targetId | STRING |
| resolvedExpression | RECORD |
| campaignId | STRING |
| state | STRING |
| bid | NUMERIC |
| adGroupId | STRING |
| extendedData | RECORD |
Sponsored TV - Reports
Campaigns Report
Purpose: This API is used to generate reports on the performance of Amazon Sponsored TV campaigns.
Source API Documentation: Amazon Sponsored TV - Campaigns Report
Replication Type: Key Based Replication
Replication Key: Date
| Field Name | Data Type |
|---|---|
| RequestTime | TIMESTAMP |
| profileId | STRING |
| countryName | STRING |
| accountName | STRING |
| accountId | STRING |
| fetchDate | DATE |
| budgetSettings | RECORD |
| endDate | STRING |
| campaignId | STRING |
| costType | STRING |
| name | STRING |
| state | STRING |
| startDate | STRING |
| extendedData | RECORD |
| tags | RECORD |
| campaignName | STRING |
| campaignStatus | STRING |
| clicks | INTEGER |
| clickThroughRate | NUMERIC |
| cost | NUMERIC |
| date | STRING |
| detailPageViews | INTEGER |
| detailPageViewsClicks | INTEGER |
| endDate | STRING |
| impressions | INTEGER |
| newToBrandDetailPageViewClicks | INTEGER |
| newToBrandDetailPageViews | INTEGER |
| newToBrandDetailPageViewViews | INTEGER |
| newToBrandPurchases | INTEGER |
| newToBrandPurchasesClicks | INTEGER |
| newToBrandPurchasesViews | INTEGER |
| newToBrandSalesClicks | NUMERIC |
| newToBrandSalesViews | NUMERIC |
| portfolioId | INTEGER |
| purchases | INTEGER |
| purchasesClicks | INTEGER |
| purchasesViews | INTEGER |
| roas | NUMERIC |
| sales | NUMERIC |
| salesClicks | NUMERIC |
| salesViews | NUMERIC |
| startDate | STRING |
| unitsSold | INTEGER |
| unitsSoldClicks | INTEGER |
| unitsSoldViews | INTEGER |
| videoCompleteViews | INTEGER |
| videoFirstQuartileViews | INTEGER |
| videoMidpointViews | INTEGER |
| videoThirdQuartileViews | INTEGER |
| brandedSearchesViews | STRING |
| costPerThousandImpressions | NUMERIC |
| detailPageViewsViews | INTEGER |
| newToBrandSales | NUMERIC |
Targeting Report
Purpose: This API provides insights into the performance of targeting criteria used in Amazon Sponsored TV campaigns.
Source API Documentation: Amazon Sponsored TV - Targeting Report
Replication Type: Key Based Replication
Replication Key: Date
| Field Name | Data Type |
|---|---|
| RequestTime | TIMESTAMP |
| profileId | STRING |
| countryName | STRING |
| accountName | STRING |
| accountId | STRING |
| reportDate | DATE |
| addToCart | INTEGER |
| addToCartClicks | INTEGER |
| addToCartViews | INTEGER |
| adKeywordStatus | STRING |
| brandedSearches | INTEGER |
| brandedSearchesClicks | INTEGER |
| clicks | INTEGER |
| clickThroughRate | NUMERIC |
| cost | NUMERIC |
| date | STRING |
| detailPageViews | INTEGER |
| detailPageViewsClicks | INTEGER |
| endDate | STRING |
| impressions | INTEGER |
| keyword | STRING |
| keywordBid | NUMERIC |
| keywordId | STRING |
| keywordType | STRING |
| matchType | STRING |
| newToBrandDetailPageViewClicks | INTEGER |
| newToBrandDetailPageViews | INTEGER |
| newToBrandDetailPageViewViews | INTEGER |
| newToBrandPurchases | INTEGER |
| newToBrandPurchasesClicks | INTEGER |
| newToBrandPurchasesViews | INTEGER |
| newToBrandSalesClicks | NUMERIC |
| newToBrandSalesViews | NUMERIC |
| portfolioId | INTEGER |
| purchases | INTEGER |
| purchasesClicks | INTEGER |
| purchasesViews | INTEGER |
| roas | NUMERIC |
| sales | NUMERIC |
| salesClicks | NUMERIC |
| salesViews | NUMERIC |
| startDate | STRING |
| targetingText | STRING |
| unitsSold | INTEGER |
| unitsSoldClicks | INTEGER |
| unitsSoldViews | INTEGER |
| videoCompleteViews | INTEGER |
| videoFirstQuartileViews | INTEGER |
| videoMidpointViews | INTEGER |
| videoThirdQuartileViews | INTEGER |
| brandedSearchesViews | STRING |
| costPerThousandImpressions | NUMERIC |
| detailPageViewsViews | INTEGER |
| newToBrandSales | NUMERIC |