Amazon Ads

Last updated on Mar 17, 2025

Effective February 28, 2025, Hevo now uses Portfolios API v3 to fetch data from Amazon Ads. To ensure uninterrupted service, Hevo will automatically upgrade your Pipelines.


This upgrade impacts the data ingestion for the following fields in the Portfolios object:

Field Impact
endDate and startDate Changed date format from YYYYMMDD to YYYY-MM-DD.

Note: As these fields are stored as String data types, only their format changes; there are no breaking changes.
statusReasons Added new field.
creationDate and lastUpdatedDate Replaced creationDate and lastUpdatedDate fields with creationDateTime and lastUpdateDateTime, respectively.


To avoid any data loss, we recommend making the necessary adjustments to accommodate these changes. The upgrade process will be seamless, with no downtime for your Pipelines. However, if you need the historical data for any of the impacted fields, you can restart the historical load for the Portfolios object.


This change applies to all new and existing Pipelines created with this Source.

Amazon Ads (formerly known as AMS or Amazon Marketing Services) is an advertising platform that allows you to create product ads. It also provides various advertising performance measurement tools and analytics solutions to help you optimize your marketing strategy.

Hevo ingests data for the Sponsored Products, Sponsored Display, and Sponsored Brands ads from Amazon.

Hevo uses the Amazon Ads API to ingest the data from your Amazon Ads account and replicate it into the desired Destination database or data warehouse for scalable analysis. You must authorize Hevo to access data from your Amazon Ads account.


Source Considerations

  • Amazon Ads retains data of only the last 95 days for all the reports. This is to ensure that the data is up-to-date and relevant for advertisers. However, the Sponsored Brands Purchased Products report is an exception as it retains data for the last 731 days. This allows advertisers to see long-term performance of their ads and the impact of their campaigns on their sales.

  • The impact metrics for the CONVERSION_OPPORTUNITIES bidding theme are weekly clicks and orders received for similar products. This allows advertisers to measure the performance of their ads on a weekly basis and see how many clicks and orders their ads are generating. For other event-based themes, the impact metrics are clicks and orders received for similar products during the event days. This allows advertisers to measure the performance of their ads during a specific event.


Limitations

  • Hevo does not load an Event into the Destination table if its size exceeds 128 MB, which may lead to discrepancies between your Source and Destination data. To avoid such a scenario, ensure that each row in your Source objects contains less than 100 MB of data.

Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Feb-28-2025 2.33.2 Added a warning container in the page overview to mention about API upgrade.
Jan-07-2025 NA Added a limitation about Event size.
Sep-30-2024 2.28.1 Updated section, Data Replication to change the default ingestion frequency to 12 Hrs.
Sep-16-2024 2.27.3 Updated sections, Data Model and Schema and Primary Keys to add information about changes to the Amazon Ads ERD with the Export API update.
Mar-05-2024 2.21 Updated the ingestion frequency table in the Data Replication section.
Jul-19-2023 NA New document.

Tell us what went wrong