Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

Schema Information For Amazon Sponsored TV

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Saras Pulse

    • Saras Daton

      • Saras IQ

        Need help with something?

        Talk to data expert

        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
        tv sponsored tv amazon sponsored tv

        Was this article helpful?

        Yes
        No
        Give feedback about this article

        Related Articles

        • Schema Information
        • Set up Instructions for Amazon Sponsored TV
        • Schema Information

        Table of Contents

        Tables/APIs Sponsored TV - Raw Data Ad Groups Ads List Campaigns Targeting Clauses Sponsored TV - Reports Campaigns Report Targeting Report

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Experts
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Follow Us

        Linkedin Youtube

        Company

        • Customers
        • Partner With Us
        • Contact Us

        Culture

        • About
        • People
        • Careers

        Offerings

        • Daton
        • For Brands
        • For Agencies

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA

        Follow Us

        Linkedin Youtube

        DISCLAIMER: Various trademarks are held by their respective owners

        © 2023 sarasanalytics.com

        Sitemap

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Sales
        DISCLAIMER: Trademarks are held by their respective owners
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Company

        • Customers
        • Partners
        • About
        • People
        • Careers
        • Contact Us

        Offerings

        • Daton
        • Solution for Brands
        • Solution for Agencies
        • Dashboards
        • Founder's Note
        • Status

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA
        • Sitemap

        © 2023 sarasanalytics.com

        Linkedin Youtube

        Knowledge Base Software powered by Helpjuice

        Expand