Amazon Sponsored Brand Ads
Amazon Sponsored Brand Ads ETL 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

Authentication Credentials

  1. 1.
    Sponsored Brand APIs work for 'Seller' type users. Agency users and Attribution accounts will not have access to APIs
  2. 2.
    User account used for authentication must have access to Campaign Manager and all Reports

Integrate Amazon Sponsored Brand Ads with Daton

  1. 1.
    Signin to Daton
  2. 2.
    Select Amazon Sponsored Brand from Connectors page
  3. 3.
    Provide all required configuration parameters - Integration Name, Replication Frequency, History, Region/Marketplace, Attribution lookback. Integration name would be used while creating tables in the warehouse and cannot be changed later
  4. 4.
    You will be redirected to Amazon Advertising login page for authorizing Daton to extract data periodically. Login with your seller account
  5. 5.
    After authentication, you will be prompted to choose from the list of available Amazon Advertising Accounts/ProfileIds
  6. 6.
    After account selection, you'll be prompted to select the Tables/APIs for replication
  7. 7.
    Then select required fields for each table
  8. 8.
    Submit the integration

Workflow

  1. 1.
    Integrations would be in configuring state initially. They would be moved to active state when selected tables are created in the warehouse.
  2. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 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. 1.
    Amazon reconciles data and may update metrics for up to 30 days. If you want to use 7-day attribution metrics, then you must select 8 day attribution offset in configuration. Daton will repeat the report data for a given date depending on the attribution offset selected
  2. 2.
    Data would always be fetched for previous day after 2 AM Seller time
  3. 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
Source API Documentation: Amazon Sponsored Brand Ads - Profile
Replication Type: Full Load
Replication Key: N/A
Portfolio
Purpose: Retrieve a list of up to 100 portfolios
Source API Documentation: Amazon Sponsored Brand Ads - Portfolio
Replication Type: Full Load
Replication Key: N/A
Store
Purpose: List store information for all registered stores under an advertiser
Source API Documentation: Amazon Sponsored Brand Ads - Store
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
SponsoredBrands_Campaign
Purpose: Return a list of Sponsored Brands campaigns
Source API Documentation: Amazon Sponsored Brand Ads - Campaign
Replication Type: Full Load
Replication Key: N/A
SponsoredBrands_AdGroup
Purpose: Return a list of ad groups
Source API Documentation: Amazon Sponsored Brand Ads - Ad Group
Replication Type: Full Load
Replication Key: N/A
SponsoredBrands_Keyword
Purpose: Gets an array of keywords
Source API Documentation: Amazon Sponsored Brand Ads - Keywords
Replication Type: Full Load
Replication Key: N/A
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 productCollection and video draft campaigns by default
Source API Documentation: Amazon Sponsored Brand Ads - Drafts
Replication Type: Full Load
Replication Key: N/A
SponsoredBrands_StoresAssets
Purpose: For sellers or vendors, gets an array of assets associated with the specified brand entity identifier
Source API Documentation: Amazon Sponsored Brand Ads - Stores
Replication Type: Full Load
Replication Key: N/A
SponsoredBrands_NegativeKeywords
Purpose: Return a list of negative ad group-level keywords
Replication Type: Full Load
Replication Key: N/A
SponsoredBrands_Targets
Purpose: Gets a list of product targets associated with the client identifier
Source API Documentation: Amazon Sponsored Brand Ads - Targets
Replication Type: Full Load
Replication Key: N/A
SponsoredBrands_NegativeTargets
Purpose: Gets a list of product negative targets associated with the client identifier
Replication: Full Replication
Replication Key: N/A
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
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
SponsoredBrands_CampaignsReports
Purpose: Retrieves campaigns performance report
Source API Documentation: Amazon Sponsored Brand Ads - Reports
ReportName in Seller Central: Campaign
Replication Type: Key Based Replication
Replication Key: Date
SponsoredBrands_PlacementCampaignsReport
Purpose: Retrieves campaigns performance report with 'placement' segmentation
Source API Documentation: Amazon Sponsored Brand Ads - Reports
ReportName in Seller Central: Campaign Placement
Replication Type: Key Based Replication
Replication Key: Date
SponsoredBrands_AdGroupReports
Purpose: Retrieves ad-group performance report
Source API Documentation: Amazon Sponsored Brand Ads - Reports
ReportName in Seller Central: None
Replication Type: Key Based Replication
Replication Key: Date
SponsoredBrands_KeywordReport
Purpose: Retrieves keyword performance report
Source API Documentation: Amazon Sponsored Brand Ads - Reports
ReportName in Seller Central: Keyword
Replication Type: Key Based Replication
Replication Key: Date
SponsoredBrands_PlacementKeywordsReport
Purpose: Retrieves keyword performance report with 'placement' segmentation
Source API Documentation: Amazon Sponsored Brand Ads - Reports
ReportName in Seller Central: Keyword Placement
Replication Type: Key Based Replication
Replication Key: Date
SponsoredBrands_SearchTermKeywordReport
Purpose: Retrieves keyword performance report with 'query' segmentation
Source API Documentation: Amazon Sponsored Brand Ads - Reports
ReportName in Seller Central: Search term
Replication Type: Key Based Replication
Replication Key: Date
SponsoredBrands_TargetReport
Purpose: Retrieves performance report for targets
Source API Documentation: Amazon Sponsored Brand Ads - Reports
ReportName in Seller Central: None
Replication Type: Key Based Replication
Replication Key: Date
SponsoredBrands_HeadlineSearchReport
Purpose:
Source API Documentation: Amazon Sponsored Brand Ads - Reports
ReportName in Seller Central: None
Replication Type: Key Based Replication
Replication Key: Date
SponsoredBrands_SearchTermHeadlineSearchReport
Purpose:
Source API Documentation: Amazon Sponsored Brand Ads - Reports
ReportName in Seller Central: None
Replication Type: Key Based Replication
Replication Key: Date
SponsoredBrands_KeywordsVideoReport
Purpose: Retrieves video performance report for Keywords
Source API Documentation: Amazon Sponsored Brand Ads - Reports
ReportName in Seller Central: Keywords Video
Replication Type: Key Based Replication
Replication Key: Date
SponsoredBrands_AdGroupsVideoReport
Purpose: Retrieves video performance report for AdGroups
ReportName in Seller Central: None
Source API Documentation: Amazon Sponsored Brand Ads - Reports
Replication Type: Key Based Replication
Replication Key: Date
SponsoredBrands_CampaignsVideoReport
Purpose: Retrieves video performance report for Campaigns
ReportName in Seller Central: Campaigns Video
Source API Documentation: Amazon Sponsored Brand Ads - Reports
Replication Type: Key Based Replication
Replication Key: Date
SponsoredBrands_PlacementCampaignsVideoReport
Purpose: Retrieves video performance report for Campaigns with 'placement' segmentation
ReportName in Seller Central: Campaigns placement video
Source API Documentation: Amazon Sponsored Brand Ads - Reports
Replication Type: Key Based Replication
Replication Key: Date
SponsoredBrands_SearchTermKeywordsVideoReport
Purpose: Retrieves video performance report for Keywords with 'query' segmentation
ReportName in Seller Central: Search term video
Source API Documentation: Amazon Sponsored Brand Ads - Reports
Replication Type: Key Based Replication
Replication Key: Date
SponsoredBrands_PlacementKeywordsVideoReport
Purpose: Retrieves video performance report for Keywords with 'placement' segmentation
ReportName in Seller Central: None
Source API Documentation: Amazon Sponsored Brand Ads - Reports
Replication Type: Key Based Replication
Replication Key: Date
SponsoredBrands_TargetVideoReport
Purpose: Retrieves video performance report for Targets
ReportName in Seller Central: None
Source API Documentation: Amazon Sponsored Brand Ads - Reports
Replication Type: Key Based Replication
Replication Key: Date
Last modified 3mo ago