Skip to main content
Skip table of contents

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

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

(error)

Getting Started

  1. In the Required Authorizations section, click on "Request AmazonAds Access" button to redirect to the Amazon Sign-In page.

  2. 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

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

Metrics

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.