Amazon limits historical API data for DSP to the last 95 days. In order to ensure the best results from measurement, we require DSP advertisers to provide supplemental historical reporting. This can be pulled directly from the Amazon console.
Important: Amazon DSP data must come directly from
the Amazon DSP console and should not be altered at any point. This must
also
be delivered in a CSV format.
In this guide, you will generate a historical Campaign report and a historical Product report.
Amazon DSP 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 Reporting page, click “Create Report”
- Set up the Historical Campaign Report
- Set up the Historical Product Report
- Upload and submit your data to the Incremental platform using one of the following methods:
- As you are setting up the Amazon DSP channel in the platform, there will be a step in which you can directly upload your historical data
- Or you can also upload your data by navigating to the Brand > Click Settings > Click Import Data > Click Upload, then follow the steps in the Import Data Wizard
Historical Campaign Report Configuration
-
Report Name
- "{Your_Brand_Name} DSP Campaign Historical"
-
Filters
- Accounts: Add All DSP Accounts (or filter to specific accounts as needed)
- Campaigns: All Campaigns
- Country: All countries
- Ad Product: Amazon DSP only
-
Customize Columns
-
Dimensions (13 total)
- Date (be sure to uncheck "Date Range", then select "Date")
- Budget currency
- Advertiser account ID
- Advertiser account name
- Campaign ID
- Campaign name
- Campaign country
- Ad group ID
- Ad group name
- Advertised product marketplace
- Ad ID
- Ad Name
- Ad Format
-
Metrics (10 total)
- Impressions
- Clicks
- Total cost
- Total fees
- Purchases
- Sales
- Units Sold
- Purchases (combined)
- Sales (combined)
- Units Solds (combined)
-
Dimensions (13 total)
-
Report Period
- Amazon limits daily grain reports to 120-day segments, so you will need to generate multiple reports to cover all data for at least the last 2 years
-
Delivery Settings
- Send to: Yourself
- Report frequency: Once
- Date: Today
- File format: CSV
Historical Product Report Configuration
-
Report Name
- “{Your_Brand_Name} DSP Product Historical”
-
Filters
- Accounts: Add All DSP Accounts (or filter to specific accounts as needed)
- Campaigns: All campaigns
- Country: All countries
- Ad Product: Amazon DSP only
-
Customize Columns
-
Dimensions (15 total)
- Date (be sure to uncheck "Date Range", then select "Date")
- Budget currency
- Advertiser account ID
- Advertiser account name
- Campaign ID
- Campaign name
- Campaign country
- Ad group ID
- Ad group name
- Advertised product ID
- Advertised product name
- Advertised product marketplace
- Ad ID
- Ad Name
- Ad Format
-
Metrics (10 total)
- Impressions
- Clicks
- Total cost
- Total fees
- Purchases
- Sales
- Units Sold
- Purchases (combined)
- Sales (combined)
- Units Solds (combined)
-
Dimensions (15 total)
-
Report Period
- 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)
-
Delivery Settings
- Send to: Yourself
- Report frequency: Once
- Date: Today
- File format: CSV
For Amazon DSP (Managed Service) accounts, continue
along with the
Amazon DSP (Managed Service) Integration Guide
to set up daily recurring Campaign, Product, and Inventory reports