Amazon Sponsored Ads Historical Data Requirements

Amazon limits historical API data for Sponsored Ads to the last 60-90 days depending on the ad type. In order to ensure the best results from measurement, we require Sponsored Ads advertisers to provide supplemental historical reporting. This can be pulled directly from the Amazon console. In this guide, you will generate a historical Products Report and a historical Keywords Report.

Prior to generating these files, please ensure the following:

All included ad accounts are already connected in the Incremental platform
No files are altered or opened/saved in Excel at any point

Amazon Sponsored Ads Historical Report Guide

Log into Amazon Ads: https://advertising.amazon.com/sign-in .
Ensure the desired account is selected in the top right account selector.
Open the side navigation > "Measurement & Reporting" and click “Reporting”.
Once on the Report center page, click “Create report”.
Set up the Historical Products Report. Amazon limits daily grain reports to 120-day segments, so you will need to generate multiple reports to cover all data dating back to 2025-02-13 (this is the earliest date of ASIN-level historical data that Amazon provides).
Set up the Historical Keywords Report. Amazon limits daily grain reports to 120-day segments, so you will need to generate multiple reports to cover all data for the last 2 years.
Once all reports are generated, submit a Support ticket and attach both files. Missing required fields will delay processing.

Historical Products Report Configuration

Report name
- {Your Brand Name} AMZ Sponsored Ads Products Historical {Date Range}
Filters
- Accounts: All accounts (or filter to specific advertisers as needed)
- Country: United States
- Ad product: Remove Amazon DSP and click "Save"
Customize columns

Note: Click both "Remove all" buttons to remove any pre-selected dimensions and metrics. If you do not remove the pre-selected fields, the report builder may prevent you from selecting all necessary fields.
- Dimensions (14 total):
  - Date
  - Budget currency
  - Advertiser account ID
  - Advertiser account name
  - Ad product
  - Campaign ID
  - Campaign name
  - Ad group ID
  - Ad group name
  - Advertised product ID
  - Advertised product name
  - Advertised product marketplace
  - Country
  - Country code
- Metrics (6 total):
  - Impressions
  - Clicks
  - Total cost
  - Purchases
  - Sales
  - Units sold
Report period
- Date range:
  - Due to limitations in Amazon's report builder, each report can only contain 120 days of data. You will need to generate multiple reports to cover all data dating back to 2025-02-13 (this is the earliest date of historical data that Amazon supports).
Delivery settings
- Send to: Your email
- Report frequency: Once
- Date: Today

Historical Keywords Report Configuration

Report name
- {Your Brand Name} AMZ Sponsored Ads Keywords Historical {Date Range}
Filters
- Accounts: All accounts (or filter to specific advertisers as needed)
- Country: United States
- Ad product: Remove Amazon DSP and click "Save"
Customize columns

Note: Click both "Remove all" buttons to remove any pre-selected dimensions and metrics. If you do not remove the pre-selected fields, the report builder may prevent you from selecting all necessary fields.
- Dimensions (13 total):
  - Date
  - Budget currency
  - Advertiser account ID
  - Advertiser account name
  - Ad product
  - Campaign ID
  - Campaign name
  - Ad group ID
  - Ad group name
  - Targeting
  - Targeting match type
  - Search term
  - Country
  - Country code
- Metrics (6 total):
  - Impressions
  - Clicks
  - Total cost
  - Purchases
  - Sales
  - Units sold
Report period
- Date range:
  - Due to limitations in Amazon's report builder, each report can only contain 120 days of data. You will need to generate multiple reports to cover all data for the last 2 years.
Delivery settings
- Send to: Your email
- Report frequency: Once
- Date: Today

Related to

Amazon