Amazon DSP Historical Data Requirements

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.

In this guide, you will generate a historical Campaign Report and a historical Products Report.

Amazon DSP Historical Report Guide

1. Log into Amazon Ads: https://advertising.amazon.com/sign-in 
2. Ensure the desired account is selected in the top right account selector
   
3. Open the side navigation > "Measurement & Reporting" and click “Amazon DSP Reports”
   

4. Once on the Report center page, click “New custom report”

   

5. Set up the Historic Campaign Report
6. Set up the Historic Products Report
7. Upload and submit your data to the Incremental platform using one of the following methods:
   • As you're 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

Historic Campaign Report Configuration

• Filter
  • Advertisers: All advertisers (or filter to specific advertisers as needed)
  • Orders: All Orders
     
• Configuration
  • Dimension: Campaign
  • Breakdown: Advertiser, Order, Line Item, Creative
  • Time Unit: Daily
     
• Required Columns
  • Date
  • Advertiser account name
  • Advertiser account ID
  • Campaign name
  • Campaign ID
  • Ad group name
  • Ad group ID
  • Ad name
  • Ad ID
  • Total cost
  • Impressions
  • Click-throughs
  • Combined purchases
  • Combined product sales
  • Combined units sold
     
• Report Settings
  • Report Period: All Time
  • Report Name: "{Your_Brand_Name} DSP Campaign Historical"
    • Please update report name to include the appropriate brand name 
      (i.e. “Tamagotchi DSP Campaign Historical”)
  • File Type: CSV
  • Request Time: Now

Historic Products Report Configuration

• Filter
  • Advertisers: All advertisers (or filter to specific advertisers as needed)
  • Orders: All orders
     
• Configuration
  • Dimension: Products
  • Breakdown: Advertiser, Order, Line Item
  • Time Unit: Daily
     
• Required Columns
  • Date
  • Report granularity
  • Amazon Standard Identification Number (ASIN)
  • Parent ASIN
  • Marketplace
  • Brand name
  • ASIN conversion type
  • Featured ASIN
  • Advertiser account name
  • Advertiser account ID
  • Campaign name
  • Campaign ID
  • Ad group name
  • Ad group ID
  • Total purchases
  • Total units sold
  • Total product sales
     
• Report Settings
  • Report Period: All Time
  • Report Name: “{Your_Brand_Name} DSP Product Historical”
  • File Type: CSV
  • Request Time: Now