Release Notes

Amazon Sponsored Brand Ads ETL Connector

February 2023

  • Sponsored Brands Unified Campaigns report & Unified Search term keyword report: Multi-ad accounts were not supported in the current Campaigns report table but Amazon has added support for multi-ad accounts which should properly load data for the respective tables.

  • Fixed a bug with the profiles table- previously used to load selected profileIDs on Daton with all the other profiles names as well now it will push all the available profile data to your warehouses.

December 2022

The connector has been overhauled to provide faster replication of data, fewer errors, and enhanced handling of rate limits. These connectors will use the feature for the time being while we expand the usage of this service gradually over the next couple of quarters.

June 2022

  • Enhanced report status display on Daton UI Canceled, Fatal, Success, In Progress, and Skipped jobs can all be verified on Daton UI. The definitions of the various job statuses can be found in the connector documentation.

  • The RequestTime column has been added to all the tables. Customers interested in this data can edit and add this column to their integrations.

April 2022

  • Support for intraday processing Before this release, Daton was replicating data for the current day-1. Amazon APIs now support extracting current-day data and these changes have been implemented in Daton Amazon Ads connectors.

  • Processing logic improvements for Ads to handle attribution We've improved the mechanism used to control attribution for Amazon Ads. With this change, we expect a reduction in delays of data caused due to timing out of data extracts when large attribution time windows are selected.

  • Added support for up to 60 days of lookback Daton now supports a loopback window of 60 days which allows for a complete re-extract of data that is available from the Ads API. This change was needed as, in some rare cases, Amazon data was getting updated even after 30 days.

  • Added market availability check to Sponsored Display Bid Recommendation table

List of new tables

  1. SponsoredProducts_SearchTermTargetingReport (Equivalent to Targets report from Ad console)

  2. Deprecated SponsoredProducts_ProductTargetingReport

  3. SponsoredProducts_SearchTermProductTargetingReport


  • Edit your integrations and change processing to intraday, only if you need hourly data for the present date. Please note that the number of records replicated by Daton will increase with this change and can have an impact on your billing.

  • Edit your integrations and select SponsoredProductsSearchTermTargetingReport and deselect SponsoredProductsProductTargetingReport, SponsoredProducts_SearchTermProductTargetingReport.

July 2021

The report statuses has been fixed on the job details page.

February 2021

Fixed the null values for some of the records.

Read more about the Amazon Sponsored Brand Ads connector here.

Last updated