Amazon Ads: Portfolio Report

Description

• Each record in this table represents the daily performance at the portfolio 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.
INTEGER	budget_amount	The budget amount associated with the portfolio. Cannot be null.
INTEGER	budget_currency_code	The currency used for all monetary values for entities under this profile. Cannot be null.
INTEGER	budget_start_date	The starting date in YYYYMMDD format to which the budget is applied. Required if policy is set to dateRange. Not specified if policy is set to monthlyRecurring. Note that the starting date for monthlyRecurring is the date when the policy is set.
INTEGER	budget_end_date	The end date after which the budget is no longer applied. Optional if policy is set to dateRange or monthlyRecurring.
INTEGER	budget_policy	The budget policy. Set to dateRange to specify a budget for a specific period of time. Set to monthlyRecurring to specify a budget that is automatically renewed at the beginning of each month. Cannot be null.
BOOLEAN	in_budget	Indicates the current budget status of the portfolio. Set to true if the portfolio is in budget, set to false if the portfolio is out of budget.
STRING	serving_status	The current serving status of the record.
STRING	state	The state of the record (enabled, paused, or archived).
DECIMAL	cost	Total cost of ad clicks.
INTEGER	clicks	Total number of ad clicks.
INTEGER	impressions	Total number of ad impressions.