Skip to main content

Amazon DSP Historical Data Requirements

  • Updated
 
Before getting started: Prior to submitting Amazon DSP Historical Data, please ensure that the Advertiser ID(s) contained in the report has an existing channel connection in the Incremental platform.

Amazon limits historical API data for DSP to the last 95 days. In order to ensure the best results from incrementality 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
  1. Open the side navigation > "Measurement & Reporting" and click “Amazon DSP Reports”
  1. Once on the Report center page, click “New custom report”
  1. Set up the Campaign Report (see configuration)
  2. Set up the Products Report (see configuration)
  3. Once you have completed the setup of the listed reports, please submit a support ticket with the Brand(s) used in report names

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
    • Send To: data@incremental.com
    • Request Time: Now

Products Report Configuration

 
Important Note: The Products Report is only available for certain Amazon DSP accounts. If you do not have the product-level metrics (Total Purchases, Total Units Sold, Total Products Sales) as an option, you will need to reach out to Amazon to inquire as to why this is the case. 
  • 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
    • Send To: data@incremental.com
    • Request Time: Now

Related to