Amazon Ads

Overview

This datasource pulls Sponsored Display, Sponsored Brand and Sponsored Product campaign reports at varying levels (campaign, ad groups, keyword, product ads, targets and ASINs) from Amazon using their API.

Vendor/Partner	Amazon
Version	v2, sponsored products is on v3
API Documentation	Vendor UI Seller UI Amazon Ads API v2 Deprecations Documentation
Sunset Date	None use by Alli Data as of 07.03.2024
Channel(s)	Programmatic
Refresh Time (CST)	6am
Default backfill	14 Days
Alli Data Library

Getting Started

In the Required Authorizations section, click on "Request AmazonAds Access" button to redirect to the Amazon Sign-In page.
Input the account credentials that have reporting access, and allow access to PMG Datawarehouse.

Limitations

Data Delay

Initial impression and click data is available using the API within 12 hours. Note that small changes to impression and click data may happen up to three days after the initial click date due to the traffic validation process. We recommend retrieving click and impression data again after three days to ensure you have the latest data.

Initial conversion data is available within 24 hours, but may change as part of the restatement process. Restatements of conversion data occur 1, 7, and 28 days after the conversion event. Because conversions are reported on the date of the ad interaction, restatement includes all dates in your attribution window. For example, if your attribution window is 14 days, restatement can update attribution up to 42 days (14 plus 28) after the report date.

More Information here: Timing & Reporting Periods

API Data vs. Advertising Console Data

Small data discrepancies between advertising console and API reports may occur and are expected due to differences in the traffic validation and data refresh processes. If you experience a data discrepancy of greater than 5% escalate to a support team member.

More information here: Reporting differences between the advertising console and API

Quotas

No quotas explicitly stated, however, the API will return a 429 error code when rate limits are hit. As suggested in the documentation, we have implemented retry logic with exponential back-off to avoid this rate limiting, but it is not completely avoidable as it is based on Amazon’s current system load.

More information here: Avoiding Rate Limits for All Other API Calls

FAQ

Amazon provides an FAQ section for common errors when using their API for reporting. You can find these common issues here.

Dimensions

Campaign Report

Name	Type	Description
`date`	`date`	`The date for the report`
`profileName`	`string`	`The name of the profile for this report`
`campaignType`	`string`	`Type of campaign`
`campaignName`	`string`	`Unique name of the campaig`
`campaignId`	`number`	`Unique numerical ID of the campaign`
`campaignStatus`	`string`	`Status of the campaign`
`campaignBudget`	`number`	`Total budget allotted to the campaign`
`campaignBudgetType`	`string`	`The type of budget allotted to the campaign`
`bidPlus`	`boolean`	`A dimensional metric. See Premium bid adjustment in the developer notes`

Ad Groups Report

…includes all dimensions from Campaigns Report

Name	Type	Description
`adGroupName`	`string`	`Unique name of the ad grou`
`adGroupId`	`number`	`Unique numerical ID of the ad group`

Keyword Report

…includes all dimensions from Ad Groups Report

Name	Type	Description
`keywordId`	`number`	`ID of the keyword used in bid`
`keywordText`	`string`	`Text of the keyword or phrase used in bid`
`matchType`	`string`	`Type of matching for the keyword or phrase used in bid. Must be one of: broad, phrase, or exact`

Product Ads Report

Name	Type	Description
`date`	`date`	`The date for the report`
`profileName`	`string`	`The name of the profile for this report`
`campaignType`	`string`	`Type of campaign`
`campaignName`	`string`	`Unique name of the campaig`
`campaignId`	`number`	`Unique numerical ID of the campaign`
`adGroupName`	`string`	`Unique name of the ad group`
`adGroupId`	`number`	`Unique numerical ID of the ad group`
`currency`	`string`	`A dimensional metric`
`asin`	`string`	`The ASIN that is being advertised. This is available for both merchants and vendors`

ASINs Report

…include all dimensions in Product Ads Report

Name	Type	Description

Name	Type	Description
`keywordId`	`string`	`Unique numerical ID of the keyword`
`keywordText`	`number`	`Keyword or phrase used in bid`
`otherAsin`	`string`	`A non-dimensional metric for ASINs other than the one advertised`
`matchType`	`string`	`One of: broad, phrase, or exact`