Amazon Ads: Ad Report

Description

• Each record in this table represents the daily performance at the ad level.

Supported Data Sources

• Amazon Ads

Columns

Type	Name	Description
DATE	date_day	The date of the report.
STRING	account_name	Account Name. Not currently populated for sellers.
STRING	account_id	Identifier for sellers and vendors. Note that this value is not unique and may be the same across marketplaces.
STRING	country_code	The code for a given country.
STRING	profile_id	The profile ID associated with your Amazon Ads account. Advertisers who operate in more than one marketplace (for example, Amazon.com, Amazon.co.uk, Amazon.co.jp) will have one profile associated with each marketplace.
STRING	portfolio_name	The name of the Portfolio.
STRING	portfolio_id	The ID of the Portfolio.
STRING	campaign_name	The name of the Campaign.
STRING	campaign_id	The ID of the Campaign.
STRING	ad_group_name	The name of the Campaign.
STRING	ad_group_id	The ID of the AdGroup.
STRING	ad_id	The ID of the Ad.
STRING	serving_status	The current serving status of the record.
STRING	state	The state of the record (enabled, paused, or archived).
INTEGER	advertised_asin	The ASIN associated to an advertised product.
INTEGER	advertised_sku	The SKU being advertised.
DECIMAL	campaign_budget_amount	Total budget allocated to the campaign.
STRING	campaign_budget_currency_code	The currency code associated with the campaign.
STRING	campaign_budget_type	One of: daily or lifetime.
DECIMAL	cost	Total cost of ad clicks.
INTEGER	clicks	Total number of ad clicks.
INTEGER	impressions	Total number of ad impressions.