LogoLogo
Daton
Daton
  • Daton Defined: From Web App Essentials to Advanced Integrations
  • Platform
    • Essentials
      • Billing
      • Integrate Facebook Ads on Daton
      • Integrate Shopify on Daton
      • Integrate Google Analytics on Daton
      • Access permissions for Daton
      • How to get started with Daton setup
      • Terminology in Daton
        • Source and Source_Table statuses
      • Various pages in Daton
    • Features
      • Navigating the pages in Daton
        • Notifications
        • Logs
        • Dashboard
        • My Account
        • Connectors
        • My Integrations
        • Integration Details
      • Templates
      • Account Management
        • My Account Page
      • Notifications
      • Monitoring
        • Logging and Log Retention
      • Manage Integrations
        • Handling Changes to Schema
        • Modifying an integration
      • Data
        • Handling Nested Data
        • Daton Metadata
        • Inserts, Updates, and Upserts
        • Data Type Mapping
        • Data Replication in Daton
          • Replication Fields
          • Replication Methods
            • Key-based Incremental Replication
      • Knowledge Base
        • What is ELT and how is it different from traditional ETL tools
          • Billing
      • Pipelines
        • Pipeline Jobs
        • Loading Behavior
      • Security
      • Feature Updates
        • Amazon Vendor Central
  • Connectors
    • Data Sources
      • Advertising
        • Adjust v1
        • Adjust v2
          • About Adjust v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Adjust v2 with Daton
          • Schema Information
        • Amazon Ads
          • Release Notes
        • Amazon Attribution
          • Release Notes
        • Amazon Brand Metrics
          • About Amazon Brand Metrics
          • Essential Attributes and Supported Tables
          • How to Integrate Amazon Brand Metrics with Daton
          • Schema Infomation
        • Amazon DSP V1
          • Release Notes
        • Amazon DSP V2
        • Amazon Marketing Cloud (AMC)
        • Amazon Marketing Streams
          • About Amazon Marketing Streams Connector
          • Essential Attributes
          • How to Integrate Amazon Marketing Streams with Daton
          • Release Notes
        • Amazon Sponsored Brand Ads
          • Release Notes
        • Amazon Sponsored Display Ads
          • Release Notes
        • Amazon Sponsored Product Ads
          • Release Notes
        • Amazon Sponsored TV Ads
        • Bing Ads
          • Release Notes
        • Bol Ads
          • Release Notes
        • Facebook Ads
          • Release Notes
        • Google Ads
          • Release Notes
        • Google My Business
        • Google My Business v2
          • About Google My Business v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Google Business Profile Account with Daton
          • Schema Information
        • Gorgias
        • Gorgias V2
        • HelpScout
        • HelpScout v2
          • About HelpScout Platform
          • Essential Attributes and Supported Tables
          • How to Integrate HelpScout with Daton
          • Schema Information
          • Release Notes
        • Outbrain
          • Release Notes
        • Outbrain v2
          • About Outbrain Platform
          • Essential Attributes & Supported Tables
          • How to Integrate Outbrain v2 with Daton
          • Schema Information
        • Pinterest v2
          • About Pinterest v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Pinterest v2 with Daton
          • Schema Information
        • Rakuten
          • About Rakuten Connector
          • Essential Attributes
          • How to Integrate Rakuten with Daton
        • StackAdapt
          • About StackAdapt Platform
          • Essential Attributes and Supported Tables
          • How to Integrate StackAdapt with Daton
          • Schema Information
        • Typeform
          • About Typeform Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Typeform with Daton
          • Schema Information
        • Upscribe
          • Release Notes
        • Upscribe V2
          • About Upscribe Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Upscribe v2 with Daton
          • Schema Information
      • Analytics Platforms
        • Appsflyer
        • GA4
          • About Google Analytics Platform
          • Essential Attributes and Table Selection
          • How to Integrate GA4 with Daton
          • Schema Information
        • Google Analytics
          • Release Notes
        • Jungle Scout
        • Northbeam
          • About Northbeam Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Northbeam with Daton
          • Schema Information
        • Prodco Analytics
          • About Prodco Analytics Platform
          • Essential Attributes and Table Selection
          • How to Integrate Prodco Analytics Account with Daton
          • Schema Information
        • Rainforest
          • About Rainforest Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Rainforest Account with Daton
          • Schema Information
        • Sprout Social
          • About Sprout Social Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Sprout Social with Daton
          • Schema Information
        • Taboola
        • Taboola v2
          • About Taboola v2
          • Essential Attributes and Supported Tables
          • How to Integrate Taboola v2 with Daton
          • Schema Information
        • Edge by Ascential
      • Business
        • ClickUp
          • About ClickUp Connector
          • Essential Attributes and Supported Tables
          • How to Integrate ClickUp with Daton
          • Schema Information
        • Bubble
        • Pipedrive
          • About Pipedrive Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Pipedrive with Daton
          • Schema Information
        • Teamwork
          • About Teamwork Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Teamwork with Daton
          • Schema Information
        • Teamwork v2
          • About Teamwork Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Teamwork v2 with Daton
          • Schema Information
        • TikTok Business
          • About TikTok Business Connector
          • Essential Attributes and Supported Tables
          • How to Integrate TikTok Business with Daton
          • Schema Information
        • Unbounce v2
          • About Unbounce v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Unbounce v2 with Daton
          • Schema Information
      • Call Center
        • Aircall
        • Callpage
        • JustCall
          • About JustCall Connector
          • Essential Attributes and Supported Tables
          • How to Integrate JustCall with Daton
          • Schema Information
      • Databases
        • Amazon Aurora MySQL
          • About Amazon Aurora Platform
          • Essential Attributes
          • How to Integrate Amazon Aurora with Daton
        • Amazon Redshift
          • About Amazon Redshift Platform
          • Essential Attributes
          • How to Integrate Amazon Redshift with Daton
        • GCP MySQL
          • About GCP MySQL Platform
          • Essential Attributes
          • How to Integrate GCP MySQL with Daton
        • GCP PostgreSQL
          • Setup Manual
        • Magento (DB)
          • About Magento Connector
          • Essential Attributes
          • How to Integrate Magento with Daton
        • MySQL
          • Release Notes
        • NetSuite
        • PostgreSQL
          • Release Notes
        • SQLServer
        • WooCommerce SQL
          • About WooCommerce SQL Platform
          • Essential Attributes
          • How to Integrate WooCommerce SQL with Daton
      • Daton Connector
        • Release Notes
      • Ecommerce Platforms
        • Amazon MWS
          • Release Notes
        • Amazon Selling Partner
          • All Report Types and Tables
          • Release Notes
        • Amazon Vendor Central
          • All Report Types and Tables
          • Real Time Reports
          • Daily Reports
          • Weekly Reports
          • Snapshot Reports
          • Monthly Reports
          • Raw Tables
          • Release Notes
        • Bigcommerce
        • BigCommerce v2
          • About BigCommerce Platform
          • Essential Attributes and Supported Tables
          • How to Integrate BigCommerce Account with Daton
          • Schema Information
          • Release Notes
        • Bol Retail v2
          • Release Notes
        • Capillary Martjack
          • Release Notes
        • Kaufland
          • About Kaufland Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Kaufland with Daton
          • Schema Information
        • Keepa
          • About Keepa Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Keepa with Daton
          • Schema Information
        • Lazada
        • Loopreturns
          • Release Notes
        • Magento
          • Release Notes
        • Magento 2 (APIs)
          • Release Notes
        • Mercado Libre
          • About Mercado Libre Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Mercado Libre with Daton
          • Schema Information
        • Shopify
          • Access tokens for Shopify
          • Release Notes
        • Shopify V2
        • Walmart
          • Release Notes
        • Walmart_v2
          • Release Notes
        • WooCommerce
      • Files
        • Amazon S3
          • Release Notes
        • Dropbox
          • Release Notes
        • Email Attachments
          • About Email Attachments Connector
          • Essential Attributes and Connector Guidelines
          • How to Integrate Email Attachments with Daton
        • Google Cloud Storage
          • Release Notes
        • Google Drive
        • Google Sheets
          • Release Notes
        • SFTP (SSH File Transfer Protocol)
      • OMS/WMS
        • Cin7
        • Goflow
          • About Goflow Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Goflow with Daton
          • Schema Information
        • Rippling
          • About Rippling Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Rippling with Daton
          • Schema Information
      • Payments
        • PayPal
          • About PayPal Connector
          • Essential Attributes and Supported Tables
          • How to Integrate PayPal with Daton
          • Schema Information
        • Razorpay
          • About Razorpay Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Razorpay with Daton
          • Schema Information
        • Razorpay v1
        • Stripe
      • Productivity Trackers
        • GitLab
          • Release Notes
        • Time Doctor
          • Release Notes
      • SaaS Integrations
        • Aftership
          • Release Notes
        • Aftership V2
        • Anvyl
        • Ascend
        • Awtomic
          • Release Notes
        • Braintree
          • About Braintree Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Braintree Account with Daton
          • Schema Information Braintree
        • Calendly
          • Release Notes
        • Calendly V2
        • Campaign Monitor
        • Capsule CRM
        • Chargebee
        • Freshworks CRM
        • Loop Subscription
        • Commission Junction
        • Constant Contact
        • Copper CRM
          • About Copper
          • Essential Attributes and Supported Tables
          • How to Integrate Copper Account with Daton
          • Schema Information
          • Release Notes
        • Criteo
        • Criteo Retail Media
        • Customer.io
        • DotDigital
        • dotdigital V2
        • Easyecom
        • EasyEcom V2
          • Release Notes
        • ePallet ERP
        • Etsy
        • Exchange Rates
          • About Exchange Rate Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Exchange Rates with Daton
          • Schema Information
          • Release Notes
        • Fairing (previously EnquireLabs)
          • Release Notes
        • FreshBooks
          • Release Notes
        • Freshdesk
          • Release Notes
        • Freshsales
          • Release Notes
        • Fulfil
        • Gladly
          • Release Notes
        • Google Search Console
          • Release Notes
        • HubSpot
          • Release Notes
        • HubSpot v2
          • About HubSpot v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate HubSpot v2 with Daton
          • Schema Information
        • Impact
          • Release Notes
        • Infusionsoft (now Keap Max Classic)
          • About Infusionsoft Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Infusionsoft with Daton
          • Schema Information
        • Insightly
        • Intercom
          • Release Notes
        • Intercom V2
          • Release Notes
        • Outbrain V2 (Old)
          • Release Notes
        • Inventory Planner
        • Jira
        • JudgeMe
          • Release Notes
        • Kibo Commerce
        • Klaviyo
          • Release Notes
        • Klaviyo V2
          • Release Notes
        • Kustomer
        • LeadSquared CRM
        • LeadSquared V2
        • LinkedIn Ads
        • LiveChat
        • LoyaltyLion
        • MailChimp
          • Release Notes
        • MNTN
        • Monday
        • NewRelic
        • Okendo Reviews
          • About Okendo Reviews Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Okendo Reviews with Daton
          • Schema Information
        • Optimove
          • Release Notes
        • Pingdom
        • Pinterest
        • Pipedrive
        • PushEngage
        • Quickbase
        • QuickBooks
        • Quickbooks v2
          • About Quickbooks Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Quickbooks v2 with Daton
          • Schema Information
        • Re:amaze
        • ReCharge Payments
          • Release Notes
        • ReCharge Payments v1
          • Setup Manual
          • Schema Information
        • Recharge Payments V2
          • Setup Manual
          • Schema Information
        • Reviewmonitoring
          • Release Notes
        • Salsify
          • Release Notes
        • SendGrid
          • Release Notes
        • Shiphero
        • Shippo
        • Shiprocket
          • Release Notes
        • Shiprocket v2
          • About Shiprocket Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Shiprocket with Daton
          • Schema Information
        • Shipstation
          • Release Notes
        • Skubana
        • SkuVault
          • About SkuVault Connector
          • Essential Attributes and Supported Tables
          • How to Integrate SkuVault with Daton
          • Schema Information
        • Smartrr
        • Smartrr v2
          • About Smartrr Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Smartrr v2 with Daton
          • Schema Information
        • Stamped.io
          • About Stamped.io Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Stamped.io with Daton
          • Schema Information
        • Stamped.io v1
        • Stay AI
        • Sticky.io
        • SugarCRM
          • Release Notes
        • Survey Monkey
        • Tune
        • Unbounce
        • Unicommerce
        • Unicommerce
          • About Unicommerce Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Unicommerce with Daton
          • Schema Information
          • Release Notes
        • When I Work
        • Xero
        • Xero V2
          • About Xero Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Xero V2 with Daton
          • Schema Information
        • Yahoo Gemini
        • Yotpo
        • Yotpo v2
          • About Yotpo Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Yotpo v2 with Daton
          • Schema Information
        • Zendesk Chat
        • Zendesk ETL
          • Release Notes
        • Zoho CRM
          • Release Notes
        • ZohoDesk
          • Release Notes
      • Surveys
        • Alchemer
          • About Alchemer Platform
          • Essential Attributes and Supported Tables Alchemer
          • How to Integrate Alchemer Account with Daton
          • Schema Information Alchemer
        • Fairing
          • About Fairing Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Fairing with Daton
          • Schema Information
        • Survicate
          • About Survicate Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Survicate with Daton
          • Schema Information
      • Shipping Platforms
        • 3PL Central
        • Byrd
        • Cin7
        • ClickPost
        • Dear
        • Easypost
        • Ohi
          • About Ohi Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Ohi with Daton
          • Schema Information
        • ShipBob
          • About ShipBob Connector
          • Essential Attributes and Supported Tables
          • How to Integrate ShipBob with Daton
          • Schema Information
      • Webhooks
    • Destinations
      • Amazon RDS PostgreSQL
        • Amazon RDS for PostgreSQL Integration with Daton
        • How to Set up RDS PostgreSQL Destination in Daton
      • Amazon RDS MySQL
        • About Integrating Amazon RDS for MySQL database with Daton
        • How to Set up RDS MySQL Destination in Daton
      • Amazon Redshift
        • Querying Daton created tables on RedShift
        • Release Notes
      • Amazon S3
        • Release Notes
      • Azure One Lake
        • About Azure One Lake as a connector in Daton
        • How to Set up an Azure One Lake Database for Integrating with Daton
        • How to Integrate your Azure One Lake Database as a Destination in Daton
      • Azure Data Lake Storage
        • About Azure Data Lake Storage as a connector in Daton
        • How to Set up an Azure Data Lake Storage for Integrating with Daton
        • How to Integrate Your Azure Data Lake Storage Database as a Destination in Daton
      • GCP PostgreSQL
        • About Google Cloud SQL for PostgreSQL Database with Daton
        • How to Set up GCP PostgreSQL Destination in Daton
      • Google BigQuery
        • Release Notes
      • GCS
      • MySQL
        • About Integrating MySQL with Daton
        • How to Set up a MySQL Database for Integrating with Daton
        • How to Set up Your MySQL Database as a Destination in Daton
      • Oracle Autonomous Data Warehouse
      • Snowflake
        • Release Notes
  • FAQs and Troubleshooting
    • Connector permissions and API Keys
      • Access tokens for Shopify
      • Amazon Ads Permissions
      • Where to find my Amazon MWS Merchant Token and Auth Token
      • How to create BigCommerce API Account and generate Client Id, Client Secret and Access tokens
      • How to create Client credentials for Bol Retail
      • How to create Developer application for Mercado Libre
      • How to create API Keys for SendGrid
      • Where to find API Keys for Freshsales
      • Where to find API Keys for Freshdesk
      • How to create REST API Keys for NewRelic
      • How to create API Keys for Chargebee
      • How to generate Access Token for Calendly
      • How to obtain Klaviyo API Key
      • Where to find API Keys for RazorPay
      • How to create API Keys for PushEngage
      • How to create Criteo API User and generate Client Id and Client Secret
      • How to find site-id/domain and create WooCommerce Consumer Key and Secret
    • Authentication Failure while connecting Database using SSH tunnel
    • Common Errors and Resolution
    • FAQs
      • How to get access to FB Ads Business Manager?
      • How to get access to Google Analytics?
      • Querying Daton created child tables for nested data
      • Google Analytics - FAQs
      • How does Lite Plan Work?
      • How do I upgrade my subscription?
      • How does loading behaviour impact billing?
      • What are the tables highlighted with the letter "F"?
      • Amazon Advertising FAQs
      • Amazon Business and Inventory Reports FAQs
      • Why don't I see my data?
      • How exactly do Business Reports work in Daton?
      • Steps to upload your own ASIN and SKU file in Amazon SP connectors
      • What are 'FATAL' and 'CANCELLED' report statuses in Amazon Selling Partner?
      • How to setup Google BigQuery Project
      • Amazon Selling Partner, Vendor Central - Access to resource denied error.
      • VendorSalesReportByManufacturing showing a FATAL report status?
      • How to Enable SSH Tunneling during a Database Source Authentication?
  • New Subscription Plans and Billing
    • Subscription Plans Overview
    • Find Your Perfect Data Integration Fit - Growth and Enterprise Plans Explored
    • Daton's Subscriptions Dashboard: Harness the Power of Your Data
    • How to Select and Subscribe to a Daton Subscription Plan?
    • Subscription Plan Upgrade and Downgrade
    • Changing Billing Cycle
  • Product Insights: Report, Roadmap, and Release Notes
    • Introduction to Product Insights
    • 2023 Recap and 2024 Roadmap
    • Release Notes
Powered by GitBook
On this page
  • Snapshot
  • Tables/APIs Supported
  • Authentication Credentials
  • Integrate Amazon Sponsored Brand Ads with Daton
  • Workflow
  • Known Issues
  • AmazonAds Data
  • REPORTS

Was this helpful?

  1. Connectors
  2. Data Sources
  3. Advertising

Amazon Sponsored Brand Ads

Amazon Sponsored Brand Ads ETL connector for data replication

Snapshot

Features

Details

Release Status

Released

Source API Version

V2

Table Selection

Yes

Column Selection

Yes

Edit Integration

Yes

Replication Type Selection

No

Authentication Parameters

Seller Login Id and Password

Replication Type

Full Replication Key Based Incremental

Replication Key

Date

Suggested Replication Frequency

24 hours

Supports attribution

Yes

Tables/APIs Supported

Profile

Portfolio

Store

SponsoredBrands_ProductMetadata

SponsoredBrands_Campaign

SponsoredBrands_AdGroup

SponsoredBrands_Keywords

SponsoredBrands_Drafts

SponsoredBrands_StoresAssets

SponsoredBrands_NegativeKeywords

SponsoredBrands_Targets

SponsoredBrands_NegativeTargets

SponsoredBrands_TargetingRecommendations

SponsoredBrands_BidRecommendations

SponsoredBrands_CampaignsReports

SponsoredBrands_PlacementCampaignsReport

SponsoredBrands_AdGroupsReport

SponsoredBrands_KeywordsReport

SponsoredBrands_PlacementKeywordsReport

SponsoredBrands_SearchTermKeywordsReport

SponsoredBrands_TargetReport

SponsoredBrands_HeadlineSearchReport

SponsoredBrands_SearchTermHeadlineSearchReport

SponsoredBrands_KeywordsVideoReport

SponsoredBrands_AdGroupsVideoReport

SponsoredBrands_CampaignsVideoReport

SponsoredBrands_PlacementCampaignsVideoReport

SponsoredBrands_SearchTermKeywordsVideoReport

SponsoredBrands_PlacementKeywordsVideoReport

SponsoredBrands_TargetVideoReport

SponsoredBrands_UnifiedAdGroupsReport

SponsoredBrands_UnifiedTargetReport

SponsoredBrands_UnifiedKeywordsReport

SponsoredBrands_UnifiedCampaignsReport

SponsoredBrands_UnifiedPlacementCampaignsReport

SponsoredBrands_UnifiedSearchTermKeywordsReport

SponsoredBrands_UnifiedPlacementKeywordsReport

Reports Mapping

The following table represents how Daton maps tables with respect to the reports you see in the Amazon Ad console interface.

Report in Ad console
Report in Daton

Search term

SponsoredBrands_SearchTermKeywordsReport SponsoredBrands_SearchTermKeywordsVideoReport

Keyword

SponsoredBrands_KeywordsReport SponsoredBrands_KeywordsVideoReport

Keyword Placement

SponsoredBrands_PlacementKeywordsReport SponsoredBrands_PlacementKeywordsVideoReport

Campaign

SponsoredBrands_CampaignsReport SponsoredBrands_CampaignsVideoReport

Campaign Placement

SponsoredBrands_PlacementCampaignsReport SponsoredBrands_PlacementCampaignsVideoReport

Search Term Impression Share

-

Category Benchmark

-

Attributed Purchases

SponsoredBrands_PurchasedProductReport

Gross And Invalid Traffic

-

Authentication Credentials

  1. Sponsored Brand APIs work for 'Seller' type users. Agency users and Attribution accounts will not have access to APIs

  2. User account used for authentication must have access to Campaign Manager and all Reports

Integrate Amazon Sponsored Brand Ads with Daton

  1. Sign in to Daton.

  2. Select Amazon Sponsored Brand from the Connectors page.

  3. Provide all required configuration parameters - Integration Name, Replication Frequency, History, Region/Marketplace, and Attribution lookback. The integration name would be used while creating tables in the warehouse and cannot be changed later.

  4. You will be redirected to the Amazon Advertising login page to authorize Daton to extract data periodically. Log in with your seller account.

  5. After authentication, you can choose from the available Amazon Advertising Accounts/ProfileIds list.

  6. After account selection, you'll be prompted to select the Tables/APIs for replication.

  7. Then select the required fields for each table.

  8. Submit the integration.

Workflow

  1. Integrations would be in configuring state initially. They would be moved to the active state when selected tables are created in the warehouse.

  2. Users would be able to edit/pause/re-activate/delete integration anytime.

  3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list.

Known Issues

  1. Amazon reconciles data and may update metrics for up to 30 days. If you want to use 7-day attribution metrics, select 8-day attribution offset in the configuration. Daton will repeat the report data for a given date depending on the attribution offset selected

  2. Data would always be fetched for the previous day after 2 AM Seller time

  3. There can be mismatches of <1% in metrics even with 30-day attribution selection in Daton

AmazonAds Data

TABLES

Profile

Purpose: Retrieve all profiles associated with the Amazon Advertising account

Replication Type: Full Load

Replication Key: N/A

Portfolio

Purpose: Retrieve a list of up to 100 portfolios

Replication Type: Full Load

Replication Key: N/A

Store

Purpose: List store information for all registered stores under an advertiser

Replication Type: Full Load

Replication Key: N/A

SponsoredBrands_ProductMetadata

Purpose: The Amazon Product Selector API allows integrators to receive product metadata such as inventory status, price, eligibility status and product details for SKUS or ASINs in their Product Catalog in order to launch, manage or optimize Sponsored Brand, Sponsored Brands or Sponsored Display advertising campaigns. The Product Selector API is available to Sellers, Vendors, and Authors

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

fetchDate

DATE

eligibilityStatus

STRING

basisPrice

RECORD

createdDate

STRING

imageUrl

STRING

priceToPay

RECORD

asin

STRING

availability

STRING

sku

STRING

title

STRING

brand

STRING

variationList

STRING

ineligibilityReasons

STRING

ineligibilityCodes

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_Campaign

Purpose: Return a list of Sponsored Brands campaigns

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

fetchDate

DATE

campaignId

STRING

name

STRING

budget

NUMERIC

budgetType

STRING

startDate

STRING

endDate

STRING

state

STRING

servingStatus

STRING

bidOptimization

BOOLEAN

bidMultiplier

NUMERIC

portfolioId

STRING

creative

RECORD

landingPage

RECORD

brandEntityId

STRING

bidAdjustments

RECORD

adFormat

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_AdGroup

Purpose: Return a list of ad groups

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

countryName

STRING

accountName

STRING

accountId

STRING

profileId

STRING

campaignId

STRING

adGroupId

STRING

name

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_Keywords

Purpose: Gets an array of keywords

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

fetchDate

DATE

keywordId

STRING

adGroupId

STRING

campaignId

STRING

keywordText

STRING

matchType

STRING

state

STRING

bid

NUMERIC

nativeLanguageKeyword

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_Drafts

Purpose: Gets an array of all draft campaigns associated with the client identifier passed in the authorization header, filtered by specified criteria. Returns both product collection and video draft campaigns by default

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

fetchDate

DATE

draftCampaignId

STRING

name

STRING

budget

NUMERIC

budgetType

STRING

startDate

STRING

endDate

STRING

bidOptimization

BOOLEAN

bidMultiplier

NUMERIC

portfolioId

STRING

creative

RECORD

landingPage

RECORD

tags

STRING

brandEntityId

STRING

bidAdjustments

RECORD

adFormat

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_StoresAssets

Purpose: For sellers or vendors, gets an array of assets associated with the specified brand entity identifier

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

fetchDate

DATE

assetId

STRING

mediaType

STRING

url

STRING

name

STRING

brandId

STRING

brandEntityId

STRING

brandRegistryName

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_NegativeKeywords

Purpose: Return a list of negative ad group-level keywords

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

fetchDate

DATE

keywordId

STRING

adGroupId

STRING

campaignId

STRING

keywordText

STRING

matchType

STRING

state

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_Targets

Purpose: Gets a list of product targets associated with the client identifier

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

fetchDate

DATE

targetId

STRING

adGroupId

STRING

campaignId

STRING

state

STRING

bid

NUMERIC

expressions

RECORD

resolvedExpressions

RECORD

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_NegativeTargets

Purpose: Gets a list of product negative targets associated with the client identifier

Replication: Full Replication

Replication Key: N/A

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

fetchDate

DATE

targetId

STRING

adGroupId

STRING

campaignId

STRING

state

STRING

bid

NUMERIC

expressions

RECORD

resolvedExpressions

RECORD

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_TargetingRecommendations

Purpose: Gets a list of recommended products for targeting. Recommendations are based on the ASINs that are passed in the request.

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

fetchDate

DATE

recommendedTargetAsin

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_BidRecommendations

Purpose: Get a list of bid recommendation objects for a specified list of keywords or products.

Replication Type: Full Load

Replication Key: N/A

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

fetchDate

DATE

keywordsBidsRecommendationSuccessResults

RECORD

keywordsBidsRecommendationErrorResults

RECORD

targetsBidsRecommendationSuccessResults

RECORD

targetsBidsRecommendationErrorResults

RECORD

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

REPORTS

SponsoredBrands_CampaignsReports

Purpose: Retrieves campaigns performance report

ReportName in Seller Central: Campaign

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

campaignName

STRING

campaignId

STRING

campaignStatus

STRING

campaignBudget

NUMERIC

campaignBudgetType

STRING

impressions

INTEGER

clicks

INTEGER

cost

NUMERIC

attributedDetailPageViewsClicks14d

INTEGER

attributedSales14d

NUMERIC

attributedSales14dSameSKU

NUMERIC

attributedConversions14d

INTEGER

attributedConversions14dSameSKU

INTEGER

attributedOrdersNewToBrand14d

INTEGER

attributedOrdersNewToBrandPercentage14d

NUMERIC

attributedOrderRateNewToBrand14d

NUMERIC

attributedSalesNewToBrand14d

NUMERIC

attributedSalesNewToBrandPercentage14d

NUMERIC

attributedUnitsOrderedNewToBrand14d

INTEGER

attributedUnitsOrderedNewToBrandPercentage14d

NUMERIC

unitsSold14d

INTEGER

dpv14d

INTEGER

applicableBudgetRuleId

STRING

applicableBudgetRuleName

STRING

campaignRuleBasedBudget

NUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_PlacementCampaignsReport

Purpose: Retrieves campaigns performance report with 'placement' segmentation

ReportName in Seller Central: Campaign Placement

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

placement

STRING

campaignId

STRING

campaignBudgetType

STRING

campaignStatus

STRING

campaignName

STRING

impressions

INTEGER

clicks

INTEGER

cost

NUMERIC

attributedDetailPageViewsClicks14d

INTEGER

attributedSales14d

NUMERIC

attributedSales14dSameSKU

NUMERIC

attributedConversions14d

INTEGER

attributedConversions14dSameSKU

INTEGER

attributedOrdersNewToBrand14d

INTEGER

attributedOrdersNewToBrandPercentage14d

NUMERIC

attributedOrderRateNewToBrand14d

NUMERIC

attributedSalesNewToBrand14d

NUMERIC

attributedSalesNewToBrandPercentage14d

NUMERIC

attributedUnitsOrderedNewToBrand14d

INTEGER

attributedUnitsOrderedNewToBrandPercentage14d

NUMERIC

unitsSold14d

INTEGER

dpv14d

INTEGER

applicableBudgetRuleId

STRING

applicableBudgetRuleName

STRING

campaignRuleBasedBudget

NUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_AdGroupsReport

Purpose: Retrieves ad-group performance report

ReportName in Seller Central: None

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

campaignId

STRING

campaignName

STRING

campaignBudget

NUMERIC

campaignBudgetType

STRING

campaignStatus

STRING

adGroupId

STRING

adGroupName

STRING

impressions

INTEGER

clicks

INTEGER

cost

NUMERIC

attributedDetailPageViewsClicks14d

INTEGER

attributedSales14d

NUMERIC

attributedSales14dSameSKU

NUMERIC

attributedConversions14d

INTEGER

attributedConversions14dSameSKU

INTEGER

attributedOrdersNewToBrand14d

INTEGER

attributedOrdersNewToBrandPercentage14d

NUMERIC

attributedOrderRateNewToBrand14d

NUMERIC

attributedSalesNewToBrand14d

NUMERIC

attributedSalesNewToBrandPercentage14d

NUMERIC

attributedUnitsOrderedNewToBrand14d

INTEGER

attributedUnitsOrderedNewToBrandPercentage14d

NUMERIC

unitsSold14d

INTEGER

dpv14d

INTEGER

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_KeywordsReport

Purpose: Retrieves keyword performance report

ReportName in Seller Central: Keyword

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

campaignId

STRING

campaignName

STRING

adGroupId

STRING

adGroupName

STRING

campaignBudgetType

STRING

campaignStatus

STRING

keywordId

STRING

keywordStatus

STRING

keywordBid

STRING

keywordText

STRING

matchType

STRING

impressions

INTEGER

clicks

INTEGER

cost

NUMERIC

attributedDetailPageViewsClicks14d

INTEGER

attributedSales14d

NUMERIC

attributedSales14dSameSKU

NUMERIC

attributedConversions14d

INTEGER

attributedConversions14dSameSKU

INTEGER

attributedOrdersNewToBrand14d

INTEGER

attributedOrdersNewToBrandPercentage14d

NUMERIC

attributedOrderRateNewToBrand14d

NUMERIC

attributedSalesNewToBrand14d

NUMERIC

attributedSalesNewToBrandPercentage14d

NUMERIC

attributedUnitsOrderedNewToBrand14d

INTEGER

attributedUnitsOrderedNewToBrandPercentage14d

NUMERIC

unitsSold14d

INTEGER

dpv14d

INTEGER

applicableBudgetRuleId

STRING

applicableBudgetRuleName

STRING

campaignBudget

NUMERIC

campaignRuleBasedBudget

NUMERIC

searchTermImpressionRank

INTEGER

searchTermImpressionShare

NUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_PlacementKeywordsReport

Purpose: Retrieves keyword performance report with 'placement' segmentation

ReportName in Seller Central: Keyword Placement

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

placement

STRING

campaignId

STRING

campaignName

STRING

adGroupId

STRING

adGroupName

STRING

campaignBudgetType

STRING

campaignStatus

STRING

keywordId

STRING

keywordStatus

STRING

keywordBid

STRING

keywordText

STRING

matchType

STRING

impressions

INTEGER

clicks

INTEGER

cost

NUMERIC

attributedDetailPageViewsClicks14d

INTEGER

attributedSales14d

NUMERIC

attributedSales14dSameSKU

NUMERIC

attributedConversions14d

INTEGER

attributedConversions14dSameSKU

INTEGER

attributedOrdersNewToBrand14d

INTEGER

attributedOrdersNewToBrandPercentage14d

NUMERIC

attributedOrderRateNewToBrand14d

NUMERIC

attributedSalesNewToBrand14d

NUMERIC

attributedSalesNewToBrandPercentage14d

NUMERIC

attributedUnitsOrderedNewToBrand14d

INTEGER

attributedUnitsOrderedNewToBrandPercentage14d

NUMERIC

unitsSold14d

INTEGER

dpv14d

INTEGER

applicableBudgetRuleId

STRING

applicableBudgetRuleName

STRING

campaignBudget

NUMERIC

campaignRuleBasedBudget

NUMERIC

searchTermImpressionRank

INTEGER

searchTermImpressionShare

NUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_SearchTermKeywordsReport

Purpose: Retrieves keyword performance report with 'query' segmentation

ReportName in Seller Central: Search term

Replication Type: Key Based Replication

Replication Key: Date

Please note that, for the "Search Term Keywords Report" table, the data for match type "-" corresponds to product-targeted campaigns which is not supported by Amazon Ads API and this limitation is not an issue caused by Daton.

Field Name
Data Type

RequestTime

TIMESTAMP

impressions

INTEGER

clicks

INTEGER

cost

NUMERIC

attributedConversions14d

INTEGER

attributedSales14d

NUMERIC

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

query

STRING

campaignId

STRING

campaignName

STRING

adGroupId

STRING

adGroupName

STRING

campaignBudgetType

STRING

campaignStatus

STRING

keywordId

STRING

keywordStatus

STRING

keywordBid

STRING

keywordText

STRING

matchType

STRING

campaignBudget

NUMERIC

searchTermImpressionRank

INTEGER

searchTermImpressionShare

NUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_TargetReport

Purpose: Retrieves performance report for targets

ReportName in Seller Central: None

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

campaignId

STRING

campaignName

STRING

adGroupId

STRING

adGroupName

STRING

campaignBudgetType

STRING

campaignStatus

STRING

targetId

STRING

targetingExpression

STRING

targetingType

STRING

targetingText

STRING

impressions

INTEGER

clicks

INTEGER

cost

NUMERIC

attributedDetailPageViewsClicks14d

INTEGER

attributedSales14d

NUMERIC

attributedSales14dSameSKU

NUMERIC

attributedConversions14d

INTEGER

attributedConversions14dSameSKU

INTEGER

attributedOrdersNewToBrand14d

INTEGER

attributedOrdersNewToBrandPercentage14d

NUMERIC

attributedOrderRateNewToBrand14d

NUMERIC

attributedSalesNewToBrand14d

NUMERIC

attributedSalesNewToBrandPercentage14d

NUMERIC

attributedUnitsOrderedNewToBrand14d

INTEGER

attributedUnitsOrderedNewToBrandPercentage14d

NUMERIC

unitsSold14d

INTEGER

dpv14d

INTEGER

campaignBudget

NUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_HeadlineSearchReport

Purpose:

ReportName in Seller Central: None

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

campaignName

STRING

campaignId

STRING

campaignStatus

STRING

campaignBudget

NUMERIC

campaignBudgetType

STRING

adGroupName

STRING

adGroupId

STRING

keywordText

STRING

keywordBid

NUMERIC

keywordStatus

STRING

targetId

STRING

targetingExpression

STRING

targetingText

STRING

targetingType

STRING

matchType

STRING

impressions

INTEGER

clicks

INTEGER

cost

NUMERIC

attributedDetailPageViewsClicks14d

INTEGER

attributedSales14d

NUMERIC

attributedSales14dSameSKU

NUMERIC

attributedConversions14d

INTEGER

attributedConversions14dSameSKU

INTEGER

attributedOrdersNewToBrand14d

INTEGER

attributedOrdersNewToBrandPercentage14d

NUMERIC

attributedOrderRateNewToBrand14d

NUMERIC

attributedSalesNewToBrand14d

NUMERIC

attributedSalesNewToBrandPercentage14d

NUMERIC

attributedUnitsOrderedNewToBrand14d

INTEGER

attributedUnitsOrderedNewToBrandPercentage14d

NUMERIC

unitsSold14d

INTEGER

dpv14d

INTEGER

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_SearchTermHeadlineSearchReport

Purpose:

ReportName in Seller Central: None

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

campaignName

STRING

campaignId

STRING

campaignStatus

STRING

campaignBudget

NUMERIC

campaignBudgetType

STRING

adGroupName

STRING

adGroupId

STRING

keywordText

STRING

keywordBid

NUMERIC

keywordStatus

STRING

targetId

STRING

targetingExpression

STRING

targetingText

STRING

targetingType

STRING

matchType

STRING

impressions

INTEGER

clicks

INTEGER

cost

NUMERIC

attributedDetailPageViewsClicks14d

INTEGER

attributedSales14d

NUMERIC

attributedSales14dSameSKU

NUMERIC

attributedConversions14d

INTEGER

attributedConversions14dSameSKU

INTEGER

attributedOrdersNewToBrand14d

INTEGER

attributedOrdersNewToBrandPercentage14d

NUMERIC

attributedOrderRateNewToBrand14d

NUMERIC

attributedSalesNewToBrand14d

NUMERIC

attributedSalesNewToBrandPercentage14d

NUMERIC

attributedUnitsOrderedNewToBrand14d

INTEGER

attributedUnitsOrderedNewToBrandPercentage14d

NUMERIC

unitsSold14d

INTEGER

dpv14d

INTEGER

query

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_KeywordsVideoReport

Purpose: Retrieves video performance report for Keywords

ReportName in Seller Central: Keywords Video

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

campaignId

STRING

campaignStatus

STRING

campaignBudget

NUMERIC

campaignBudgetType

STRING

campaignName

STRING

impressions

INTEGER

clicks

INTEGER

cost

NUMERIC

attributedSales14d

NUMERIC

attributedSales14dSameSKU

NUMERIC

attributedConversions14d

INTEGER

attributedConversions14dSameSKU

INTEGER

keywordText

STRING

keywordBid

STRING

adGroupName

STRING

adGroupId

STRING

keywordStatus

STRING

query

STRING

keywordId

STRING

matchType

STRING

attributedDetailPageViewsClicks14d

INTEGER

attributedOrderRateNewToBrand14d

NUMERIC

SponsoredBrands_AdGroupsVideoReport

Purpose: Retrieves video performance report for AdGroups

ReportName in Seller Central: None

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

campaignId

STRING

campaignStatus

STRING

campaignBudget

NUMERIC

campaignBudgetType

STRING

campaignName

STRING

impressions

INTEGER

clicks

INTEGER

cost

NUMERIC

attributedSales14d

NUMERIC

attributedSales14dSameSKU

NUMERIC

attributedConversions14d

INTEGER

attributedConversions14dSameSKU

INTEGER

adGroupId

STRING

adGroupName

STRING

attributedDetailPageViewsClicks14d

INTEGER

attributedOrderRateNewToBrand14d

NUMERIC

attributedOrdersNewToBrand14d

INTEGER

attributedOrdersNewToBrandPercentage14d

NUMERIC

attributedSalesNewToBrand14d

NUMERIC

attributedSalesNewToBrandPercentage14d

NUMERIC

attributedUnitsOrderedNewToBrand14d

INTEGER

attributedUnitsOrderedNewToBrandPercentage14d

NUMERIC

dpv14d

INTEGER

vctr

NUMERIC

video5SecondViewRate

NUMERIC

video5SecondViews

INTEGER

videoCompleteViews

INTEGER

videoFirstQuartileViews

INTEGER

videoMidpointViews

INTEGER

videoThirdQuartileViews

INTEGER

videoUnmutes

INTEGER

viewableImpressions

INTEGER

vtr

NUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_CampaignsVideoReport

Purpose: Retrieves video performance report for Campaigns

ReportName in Seller Central: Campaigns Video

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

campaignId

STRING

campaignStatus

STRING

campaignBudget

NUMERIC

campaignBudgetType

STRING

campaignName

STRING

impressions

INTEGER

clicks

INTEGER

cost

NUMERIC

attributedSales14d

NUMERIC

attributedSales14dSameSKU

NUMERIC

attributedConversions14d

INTEGER

attributedConversions14dSameSKU

INTEGER

attributedDetailPageViewsClicks14d

INTEGER

attributedOrderRateNewToBrand14d

NUMERIC

attributedOrdersNewToBrand14d

INTEGER

attributedOrdersNewToBrandPercentage14d

NUMERIC

attributedSalesNewToBrand14d

NUMERIC

attributedSalesNewToBrandPercentage14d

NUMERIC

attributedUnitsOrderedNewToBrand14d

INTEGER

attributedUnitsOrderedNewToBrandPercentage14d

NUMERIC

dpv14d

INTEGER

vctr

NUMERIC

video5SecondViewRate

NUMERIC

video5SecondViews

INTEGER

videoCompleteViews

INTEGER

videoFirstQuartileViews

INTEGER

videoMidpointViews

INTEGER

videoThirdQuartileViews

INTEGER

videoUnmutes

INTEGER

viewableImpressions

INTEGER

vtr

NUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_PlacementCampaignsVideoReport

Purpose: Retrieves video performance report for Campaigns with 'placement' segmentation

ReportName in Seller Central: Campaigns placement video

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

campaignName

STRING

campaignId

STRING

campaignStatus

STRING

campaignBudget

NUMERIC

campaignBudgetType

STRING

placement

STRING

impressions

INTEGER

clicks

INTEGER

cost

NUMERIC

attributedSales14d

NUMERIC

attributedSales14dSameSKU

NUMERIC

attributedConversions14d

INTEGER

attributedConversions14dSameSKU

INTEGER

attributedDetailPageViewsClicks14d

INTEGER

attributedOrderRateNewToBrand14d

NUMERIC

attributedOrdersNewToBrand14d

INTEGER

attributedOrdersNewToBrandPercentage14d

NUMERIC

attributedSalesNewToBrand14d

NUMERIC

attributedSalesNewToBrandPercentage14d

NUMERIC

attributedUnitsOrderedNewToBrand14d

INTEGER

attributedUnitsOrderedNewToBrandPercentage14d

NUMERIC

dpv14d

INTEGER

vctr

NUMERIC

video5SecondViewRate

NUMERIC

video5SecondViews

INTEGER

videoCompleteViews

INTEGER

videoFirstQuartileViews

INTEGER

videoMidpointViews

INTEGER

videoThirdQuartileViews

INTEGER

videoUnmutes

INTEGER

viewableImpressions

INTEGER

vtr

NUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_SearchTermKeywordsVideoReport

Purpose: Retrieves video performance report for Keywords with 'query' segmentation

ReportName in Seller Central: Search term video

Replication Type: Key Based Replication

Replication Key: Date

Please note that, for the "Search Term Keywords Video Report" table, the data for match type "-" corresponds to product-targeted campaigns which is not supported by Amazon Ads API and this limitation is not an issue caused by Daton.

FIELDS

Field Name
Data Type

searchTermImpressionShare

INTEGER

searchTermImpressionRank

INTEGER

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

campaignId

STRING

campaignStatus

STRING

campaignBudget

NUMERIC

campaignBudgetType

STRING

campaignName

STRING

impressions

INTEGER

clicks

INTEGER

cost

NUMERIC

attributedSales14d

NUMERIC

attributedConversions14d

INTEGER

keywordText

STRING

keywordBid

STRING

adGroupName

STRING

adGroupId

STRING

keywordStatus

STRING

query

STRING

keywordId

STRING

matchType

STRING

vctr

NUMERIC

video5SecondViewRate

NUMERIC

video5SecondViews

INTEGER

videoFirstQuartileViews

INTEGER

videoMidpointViews

INTEGER

videoThirdQuartileViews

INTEGER

videoUnmutes

INTEGER

viewableImpressions

INTEGER

vtr

NUMERIC

videoCompleteViews

INTEGER

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_PlacementKeywordsVideoReport

Purpose: Retrieves video performance report for Keywords with 'placement' segmentation

ReportName in Seller Central: None

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

placement

STRING

campaignId

STRING

campaignName

STRING

adGroupId

STRING

adGroupName

STRING

campaignBudgetType

STRING

campaignStatus

STRING

keywordId

STRING

keywordStatus

STRING

keywordBid

STRING

keywordText

STRING

matchType

STRING

impressions

INTEGER

clicks

INTEGER

cost

NUMERIC

attributedDetailPageViewsClicks14d

INTEGER

attributedSales14d

NUMERIC

attributedSales14dSameSKU

NUMERIC

attributedConversions14d

INTEGER

attributedConversions14dSameSKU

INTEGER

attributedOrderRateNewToBrand14d

NUMERIC

attributedOrdersNewToBrand14d

INTEGER

attributedOrdersNewToBrandPercentage14d

NUMERIC

attributedSalesNewToBrand14d

NUMERIC

attributedSalesNewToBrandPercentage14d

NUMERIC

attributedUnitsOrderedNewToBrand14d

INTEGER

attributedUnitsOrderedNewToBrandPercentage14d

NUMERIC

dpv14d

INTEGER

vctr

NUMERIC

video5SecondViewRate

NUMERIC

video5SecondViews

INTEGER

videoCompleteViews

INTEGER

videoFirstQuartileViews

INTEGER

videoMidpointViews

INTEGER

videoThirdQuartileViews

INTEGER

videoUnmutes

INTEGER

viewableImpressions

INTEGER

vtr

NUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_TargetVideoReport

Purpose: Retrieves video performance report for Targets

ReportName in Seller Central: None

Replication Type: Key Based Replication

Replication Key: Date

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

campaignId

STRING

campaignName

STRING

adGroupId

STRING

adGroupName

STRING

campaignBudget

NUMERIC

campaignBudgetType

STRING

campaignStatus

STRING

targetId

STRING

targetingExpression

STRING

targetingType

STRING

targetingText

STRING

impressions

INTEGER

clicks

INTEGER

cost

NUMERIC

attributedDetailPageViewsClicks14d

INTEGER

attributedSales14d

NUMERIC

attributedSales14dSameSKU

NUMERIC

attributedConversions14d

INTEGER

attributedConversions14dSameSKU

INTEGER

attributedOrderRateNewToBrand14d

NUMERIC

attributedOrdersNewToBrand14d

INTEGER

attributedOrdersNewToBrandPercentage14d

NUMERIC

attributedSalesNewToBrand14d

NUMERIC

attributedSalesNewToBrandPercentage14d

NUMERIC

attributedUnitsOrderedNewToBrand14d

INTEGER

attributedUnitsOrderedNewToBrandPercentage14d

NUMERIC

dpv14d

INTEGER

vctr

NUMERIC

video5SecondViewRate

NUMERIC

video5SecondViews

INTEGER

videoCompleteViews

INTEGER

videoFirstQuartileViews

INTEGER

videoMidpointViews

INTEGER

videoThirdQuartileViews

INTEGER

videoUnmutes

INTEGER

viewableImpressions

INTEGER

vtr

NUMERIC

attributedBrandedSearches14d

INTEGER

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_UnifiedAdGroupsReport

Purpose: Retrieves ad-group performance report

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

campaignId

INTEGER

campaignStatus

STRING

campaignBudget

NUMERIC

campaignBudgetType

STRING

campaignName

STRING

impressions

INTEGER

clicks

INTEGER

cost

NUMERIC

attributedSales14d

NUMERIC

attributedSales14dSameSKU

NUMERIC

attributedConversions14d

INTEGER

attributedConversions14dSameSKU

INTEGER

adGroupName

STRING

adGroupId

STRING

vctr

NUMERIC

video5SecondViewRate

NUMERIC

video5SecondViews

INTEGER

videoFirstQuartileViews

INTEGER

videoMidpointViews

INTEGER

videoThirdQuartileViews

INTEGER

videoUnmutes

INTEGER

viewableImpressions

INTEGER

vtr

NUMERIC

dpv14d

INTEGER

attributedDetailPageViewsClicks14d

INTEGER

attributedOrderRateNewToBrand14d

NUMERIC

attributedOrdersNewToBrand14d

INTEGER

attributedOrdersNewToBrandPercentage14d

NUMERIC

attributedSalesNewToBrand14d

NUMERIC

attributedSalesNewToBrandPercentage14d

NUMERIC

attributedUnitsOrderedNewToBrand14d

INTEGER

attributedUnitsOrderedNewToBrandPercentage14d

NUMERIC

attributedBrandedSearches14d

INTEGER

currency

STRING

videoCompleteViews

INTEGER

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_UnifiedKeywordsReport

Purpose: Retrieves performance report for Keywords

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

campaignId

INTEGER

campaignStatus

STRING

campaignBudget

NUMERIC

campaignBudgetType

STRING

campaignName

STRING

impressions

INTEGER

keywordBid

STRING

keywordId

STRING

keywordStatus

STRING

keywordText

STRING

matchType

STRING

clicks

INTEGER

cost

NUMERIC

attributedSales14d

NUMERIC

attributedSales14dSameSKU

NUMERIC

attributedConversions14d

INTEGER

attributedConversions14dSameSKU

INTEGER

adGroupName

STRING

adGroupId

STRING

vctr

NUMERIC

video5SecondViewRate

NUMERIC

video5SecondViews

INTEGER

videoFirstQuartileViews

INTEGER

videoMidpointViews

INTEGER

videoThirdQuartileViews

INTEGER

videoUnmutes

INTEGER

viewableImpressions

INTEGER

vtr

NUMERIC

dpv14d

INTEGER

attributedDetailPageViewsClicks14d

INTEGER

attributedOrderRateNewToBrand14d

NUMERIC

attributedOrdersNewToBrand14d

INTEGER

attributedOrdersNewToBrandPercentage14d

NUMERIC

attributedSalesNewToBrand14d

NUMERIC

attributedSalesNewToBrandPercentage14d

NUMERIC

attributedUnitsOrderedNewToBrand14d

INTEGER

attributedUnitsOrderedNewToBrandPercentage14d

NUMERIC

attributedBrandedSearches14d

INTEGER

currency

STRING

videoCompleteViews

INTEGER

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_UnifiedTargetReport

Purpose: Retrieves performance report for targets

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

campaignId

STRING

campaignStatus

STRING

campaignBudget

NUMERIC

campaignBudgetType

STRING

campaignName

STRING

impressions

INTEGER

targetId

INTEGER

targetingExpression

STRING

targetingText

STRING

targetingType

STRING

clicks

INTEGER

cost

NUMERIC

attributedSales14d

NUMERIC

attributedSales14dSameSKU

NUMERIC

attributedConversions14d

INTEGER

attributedConversions14dSameSKU

INTEGER

adGroupName

STRING

adGroupId

STRING

vctr

NUMERIC

video5SecondViewRate

NUMERIC

video5SecondViews

INTEGER

videoFirstQuartileViews

INTEGER

videoMidpointViews

INTEGER

videoThirdQuartileViews

INTEGER

videoUnmutes

INTEGER

viewableImpressions

INTEGER

vtr

NUMERIC

dpv14d

INTEGER

attributedDetailPageViewsClicks14d

INTEGER

attributedOrderRateNewToBrand14d

NUMERIC

attributedOrdersNewToBrand14d

INTEGER

attributedOrdersNewToBrandPercentage14d

NUMERIC

attributedSalesNewToBrand14d

NUMERIC

attributedSalesNewToBrandPercentage14d

NUMERIC

attributedUnitsOrderedNewToBrand14d

INTEGER

attributedUnitsOrderedNewToBrandPercentage14d

NUMERIC

attributedBrandedSearches14d

INTEGER

currency

STRING

videoCompleteViews

INTEGER

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_UnifiedPlacementCampaignsReport

Purpose: Retrieves campaign's performance report with 'placement' segmentation

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

campaignId

STRING

campaignStatus

STRING

campaignBudget

NUMERIC

campaignBudgetType

STRING

campaignName

STRING

impressions

INTEGER

placement

STRING

clicks

INTEGER

cost

NUMERIC

attributedSales14d

NUMERIC

attributedSales14dSameSKU

NUMERIC

attributedConversions14d

INTEGER

attributedConversions14dSameSKU

INTEGER

vctr

NUMERIC

video5SecondViewRate

NUMERIC

video5SecondViews

INTEGER

videoFirstQuartileViews

INTEGER

videoMidpointViews

INTEGER

videoThirdQuartileViews

INTEGER

videoUnmutes

INTEGER

viewableImpressions

INTEGER

vtr

NUMERIC

dpv14d

INTEGER

attributedDetailPageViewsClicks14d

INTEGER

attributedOrderRateNewToBrand14d

NUMERIC

attributedOrdersNewToBrand14d

INTEGER

attributedOrdersNewToBrandPercentage14d

NUMERIC

attributedSalesNewToBrand14d

NUMERIC

attributedSalesNewToBrandPercentage14d

NUMERIC

attributedUnitsOrderedNewToBrand14d

INTEGER

attributedUnitsOrderedNewToBrandPercentage14d

NUMERIC

attributedBrandedSearches14d

INTEGER

currency

STRING

videoCompleteViews

INTEGER

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

SponsoredBrands_UnifiedPlacementKeywordsReport

Purpose: Retrieves keyword performance report with 'placement' segmentation

Note: The API reports don't return the data for match type "-" i.e. auto-targeting data

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

adGroupId

STRING

adGroupName

STRING

campaignId

INTEGER

campaignStatus

STRING

campaignBudget

NUMERIC

campaignBudgetType

STRING

campaignName

STRING

keywordBid

STRING

keywordId

STRING

keywordStatus

STRING

keywordText

STRING

matchType

STRING

impressions

INTEGER

placement

STRING

clicks

INTEGER

cost

NUMERIC

attributedSales14d

NUMERIC

attributedSales14dSameSKU

NUMERIC

attributedConversions14d

INTEGER

attributedConversions14dSameSKU

INTEGER

vctr

NUMERIC

video5SecondViewRate

NUMERIC

video5SecondViews

INTEGER

videoFirstQuartileViews

INTEGER

videoMidpointViews

INTEGER

videoThirdQuartileViews

INTEGER

videoUnmutes

INTEGER

viewableImpressions

INTEGER

vtr

NUMERIC

dpv14d

INTEGER

attributedDetailPageViewsClicks14d

INTEGER

attributedOrderRateNewToBrand14d

NUMERIC

attributedOrdersNewToBrand14d

INTEGER

attributedOrdersNewToBrandPercentage14d

NUMERIC

attributedSalesNewToBrand14d

NUMERIC

attributedSalesNewToBrandPercentage14d

NUMERIC

attributedUnitsOrderedNewToBrand14d

INTEGER

attributedUnitsOrderedNewToBrandPercentage14d

NUMERIC

attributedBrandedSearches14d

INTEGER

currency

STRING

videoCompleteViews

INTEGER

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_UnifiedCampaignsReport

Purpose: Retrieves campaigns performance report

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

campaignId

STRING

campaignStatus

STRING

currency

STRING

campaignBudget

NUMERIC

campaignBudgetType

STRING

campaignName

STRING

impressions

INTEGER

clicks

INTEGER

cost

NUMERIC

attributedSales14d

NUMERIC

attributedSales14dSameSKU

NUMERIC

attributedConversions14d

INTEGER

attributedConversions14dSameSKU

INTEGER

attributedDetailPageViewsClicks14d

INTEGER

attributedOrderRateNewToBrand14d

NUMERIC

attributedOrdersNewToBrand14d

INTEGER

attributedOrdersNewToBrandPercentage14d

NUMERIC

attributedSalesNewToBrand14d

NUMERIC

attributedSalesNewToBrandPercentage14d

NUMERIC

attributedUnitsOrderedNewToBrand14d

INTEGER

attributedUnitsOrderedNewToBrandPercentage14d

NUMERIC

dpv14d

INTEGER

vctr

NUMERIC

video5SecondViewRate

NUMERIC

video5SecondViews

INTEGER

videoCompleteViews

INTEGER

videoFirstQuartileViews

INTEGER

videoMidpointViews

INTEGER

videoThirdQuartileViews

INTEGER

videoUnmutes

INTEGER

viewableImpressions

INTEGER

vtr

NUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

SponsoredBrands_UnifiedSearchTermKeywordsReport

Purpose: Retrieves keyword performance report with 'query' segmentation

Please note that, for the "Unified Search Term Keywords Report" table, the data for match type "-" corresponds to product-targeted campaigns which is not supported by Amazon Ads API and this limitation is not an issue caused by Daton.

FIELDS

Field Name
Data Type

RequestTime

TIMESTAMP

profileId

STRING

countryName

STRING

accountName

STRING

accountId

STRING

reportDate

DATE

campaignId

STRING

campaignStatus

STRING

campaignBudget

NUMERIC

campaignBudgetType

STRING

campaignName

STRING

impressions

INTEGER

clicks

INTEGER

cost

NUMERIC

attributedSales14d

NUMERIC

attributedConversions14d

INTEGER

keywordText

STRING

keywordBid

STRING

adGroupName

STRING

adGroupId

STRING

keywordStatus

STRING

query

STRING

keywordId

STRING

matchType

STRING

vctr

NUMERIC

video5SecondViewRate

NUMERIC

video5SecondViews

INTEGER

videoFirstQuartileViews

INTEGER

videoMidpointViews

INTEGER

videoThirdQuartileViews

INTEGER

videoUnmutes

INTEGER

viewableImpressions

INTEGER

vtr

NUMERIC

videoCompleteViews

INTEGER

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

PreviousRelease NotesNextRelease Notes

Last updated 1 year ago

Was this helpful?

Read more on attribution - [FAQs] ()

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

https://docs.sarasanalytics.com/faqs/faqs/amazon-advertising-faqs
Amazon Sponsored Brand Ads - Profile
Amazon Sponsored Brand Ads - Portfolio
Amazon Sponsored Brand Ads - Store
Amazon Sponsored Brand Ads - Product Metadata
Amazon Sponsored Brand Ads - Campaign
Amazon Sponsored Brand Ads - Ad Group
Amazon Sponsored Brand Ads - Keywords
Amazon Sponsored Brand Ads - Drafts
Amazon Sponsored Brand Ads - Stores
Amazon Sponsored Brand Ads - Negative Keywords
Amazon Sponsored Brand Ads - Targets
Amazon Sponsored Brand Ads - Negative Targets
Amazon Sponsored Brand Ads - Targeting Recommendations
Amazon Sponsored Brand Ads - Bid Recommendations
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports
Amazon Sponsored Brand Ads - Reports