Amazon Marketing Cloud: Most-used fields

The table below gives information about most-used fields that you can import from Amazon Marketing Cloud. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name	Adverity UI name	Description	Use in Adverity
ad_product_type	ad_product_type	The type of Amazon Ads product responsible for the traffic event attributed to a conversion (e.g., ‘sponsored_products’, ‘sponsored_brands’, ‘sponsored_display’, ‘sponsored_television’, or NULL for Amazon DSP events).	dimension
ad_type	ad_type	The classification or format of an advertisement.	dimension
add_to_cart	add_to_cart	The number of times a product was added to a shopping cart after an ad interaction.	metric
advertiser	advertiser	The name of the business entity running advertising campaigns on Amazon.	dimension
advertiser_id	advertiser_id	A unique identifier for the advertiser account. AMC APIs can manage AMC instances and accounts.	dimension
advertiser_timezone	advertiser_timezone	The timezone configured for the advertiser’s account.	dimension
all_purchases	all_purchases	The total count of all purchases attributed to advertising efforts.	metric
amazon_conversion_event	amazon_conversion_event	A specific type of conversion event that occurred on Amazon, such as a purchase or an add-to-cart. AMC can generate reports over purchase events from Amazon stores.	dimension
audience_type	audience_type	The type of audience targeted by an advertising campaign, such as rule-based audiences or lookalike audiences.	dimension
behavior_segment_matched	behavior_segment_matched	An indicator of whether a specific behavior segment was targeted by an Amazon DSP line item and matched to the user at the time of impression. Possible values are ‘1’ (the segment was targeted and matched to the user) or ‘0’ (the user belonged to the segment, but the segment was not targeted).	metric
behavior_segment_name	behavior_segment_name	The name of the audience segment a user belonged to at the time of an impression. This name helps identify and categorize audience segments based on characteristics such as shopping behaviors, demographics, and interests.	dimension
browser_family	browser_family	The family of web browser used by the user (e.g., Chrome, Firefox, Safari).	dimension
campaign	campaign	The name of the advertising campaign.	dimension
campaign_end_date_utc	campaign_end_date_utc	The end date of the campaign in Coordinated Universal Time (UTC). This field defines the end of the reporting period for a campaign.	dimension
campaign_id	campaign_id	The unique identifier for an advertising campaign.	dimension
campaign_start_date_utc	campaign_start_date_utc	The start date of the campaign in Coordinated Universal Time (UTC). This field defines the beginning of the reporting period for a campaign.	dimension
campaign_type	campaign_type	The type of advertising campaign, such as Sponsored Products, Sponsored Brands, or Amazon DSP campaigns.	dimension
clicks	clicks	The number of times an ad was clicked. AMC reports over event-level Amazon Ads inputs such as clicks.	metric
conversion_event_category	conversion_event_category	The category of the conversion event, providing a classification for different types of conversions.	dimension
conversion_event_name	conversion_event_name	The specific name of the conversion event, such as ‘Purchase’ or ‘Add to Cart’.	dimension
conversion_rate_perc_all	conversion_rate_perc_all	The percentage of ad interactions that resulted in a conversion.	metric
conversions	conversions	The total number of successful user actions (conversions) attributed to advertising efforts.	metric
cost	cost	The expenditure incurred for advertising or other activities.	metric
creative	creative	The name or description of the advertising creative.	dimension
creative_id	creative_id	A unique identifier for the advertising creative.	dimension
creative_size	creative_size	The dimensions (e.g., width x height) of the advertising creative.	dimension
creative_type	creative_type	The type of advertising creative (e.g., image, video, custom native).	dimension
currency_iso_code	currency_iso_code	The ISO 4217 code for the currency used in financial metrics (e.g., ‘USD’, ‘EUR’).	dimension
customer_search_term	customer_search_term	The actual search query entered by a customer that led to an ad impression or click.	dimension
date_end	date_end	The end date of the reporting period.	dimension
date_start	date_start	The start date of the reporting period.	dimension
date_utc	date_utc	The date in Coordinated Universal Time (UTC) for which the data is reported.	dimension
days	days	The number of days in the reporting period or a duration.	metric
detail_page_view	detail_page_view	The number of times a product’s detail page was viewed after an ad interaction.	metric
detail_page_view_clicks	detail_page_view_clicks	The number of detail page views that resulted from a click on an ad.	metric
detail_page_view_views	detail_page_view_views	The number of detail page views that resulted from an impression (view-through) rather than a click.	metric
detail_page_views	detail_page_views	The number of times a product’s detail page was viewed.	metric
device_type	device_type	The type of device used by the customer (e.g., mobile, desktop, tablet).	dimension
dpv	dpv	The number of detail page views.	metric
dpv_rate	dpv_rate	The rate of detail page views, indicating how often users view product detail pages.	metric
end_date	end_date	The end date for the reporting period.	dimension
entity_id	entity_id	A general identifier for an entity, which could represent a campaign, ad group, creative, or other resource.	dimension
event_date	event_date	The date on which a specific event occurred.	dimension
event_month	event_month	The month in which the event occurred.	metric
event_year	event_year	The year in which the event occurred.	metric
frequency_bucket	frequency_bucket	A categorized range representing the number of times a user was exposed to an ad.	dimension
id_type	id_type	The type of identifier used in the report, for example, ASIN for products.	dimension
imp_total_cost	imp_total_cost	The total cost associated with impressions.	metric
impression_date	impression_date	The date of the impression event in the advertiser’s timezone.	dimension
impression_month_utc	impression_month_utc	The month in Coordinated Universal Time (UTC) when the impression occurred.	metric
impression_reach	impression_reach	The number of unique users who were exposed to an ad or received an impression.	metric
impression_year_utc	impression_year_utc	The year in Coordinated Universal Time (UTC) when the impression occurred.	metric
impressions	impressions	The number of times an ad or product was displayed to a customer.	metric
keyword	keyword	The keyword targeted by an advertising campaign.	dimension
line_item	line_item	The name or identifier of the line item within a campaign.	dimension
line_item_end_date_utc	line_item_end_date_utc	The end date of the line item in Coordinated Universal Time (UTC). This field specifies the conclusion of the reporting period for a particular line item within a campaign.	dimension
line_item_id	line_item_id	A unique identifier for the line item.	dimension
line_item_start_date_utc	line_item_start_date_utc	The start date of the line item in Coordinated Universal Time (UTC). This field specifies the beginning of the reporting period for a particular line item within a campaign.	dimension
marketplace_name	marketplace_name	The Amazon marketplace where the advertising activity or sales occurred (e.g., ‘US’, ‘UK’, ‘DE’).	dimension
match_type	match_type	The type of match used for keywords in a campaign (e.g., exact, phrase, broad).	dimension
new_to_brand_product_sales	new_to_brand_product_sales	Product sales attributed to new-to-brand customers.	metric
new_to_brand_purchases	new_to_brand_purchases	The number of purchases made by new-to-brand customers.	metric
new_to_brand_total_product_sales	new_to_brand_total_product_sales	The aggregated total product sales attributed to new-to-brand customers.	metric
new_to_brand_total_purchases	new_to_brand_total_purchases	The aggregated total number of purchases made by new-to-brand customers.	metric
non_new_to_brand_product_sales	non_new_to_brand_product_sales	Product sales attributed to existing customers (not new-to-brand).	metric
non_new_to_brand_purchases	non_new_to_brand_purchases	The number of purchases made by existing customers (not new-to-brand).	metric
non_new_to_brand_total_product_sales	non_new_to_brand_total_product_sales	The aggregated total product sales attributed to existing customers (not new-to-brand).	metric
non_new_to_brand_total_purchases	non_new_to_brand_total_purchases	The aggregated total number of purchases made by existing customers (not new-to-brand).	metric
non_ntb_purchases	non_ntb_purchases	The number of purchases made by existing customers (not new to brand).	metric
ntb_percentage	ntb_percentage	The percentage of sales or purchases that are new-to-brand.	metric
ntb_product_sales	ntb_product_sales	Product sales attributed to new-to-brand customers, meaning customers who had not purchased from the brand on Amazon in the past 12 months.	metric
ntb_purchases	ntb_purchases	The number of purchases made by customers identified as new to the brand.	metric
ntb_sales_amount	ntb_sales_amount	The sales amount attributed to new-to-brand customers.	metric
ntb_units_sold	ntb_units_sold	The number of units sold to new-to-brand customers.	metric
ntb_users_that_purchased	ntb_users_that_purchased	The number of unique new-to-brand users who made a purchase.	metric
off_amazon_conversion_value	off_amazon_conversion_value	The value of conversions that occurred off Amazon, potentially tracked through integrated data sources. AMC allows custom analysis across Amazon Ads and DSP data.	metric
off_amazon_product_sales	off_amazon_product_sales	Product sales that occurred off Amazon, potentially tracked through integrated data sources. AMC allows custom analysis across Amazon Ads and DSP data.	dimension
operating_system	operating_system	The operating system used by the customer (e.g., iOS, Android, Windows).	dimension
order_month	order_month	The month in which the order was placed.	metric
order_year	order_year	The year in which the order was placed.	metric
path	path		dimension
product_sales	product_sales	The sales (in local currency) of promoted ASINs and brand halo ASINs purchased on Amazon, attributed to an ad view or click.	metric
product_type	product_type	The general category or type of the product being advertised.	dimension
purchase_amount	purchase_amount	The monetary value of a purchase.	metric
purchase_rate	purchase_rate	The rate at which ad interactions lead to a purchase.	metric
purchase_uniques	purchase_uniques	The number of unique customers who made a purchase attributed to advertising.	metric
purchase_units_sold	purchase_units_sold	The number of units sold within a purchase event.	metric
purchases	purchases	The number of customer purchases, often attributed to traffic events.	metric
purchases_count	purchases_count	The total count of purchases.	metric
reach_percentage	reach_percentage	The percentage of the target audience that was reached by the campaign.	metric
report_dt	report_dt	The date the report data was generated or recorded.	dimension
roas	roas	Return on Ad Spend, calculated as total sales revenue divided by advertising spend.	metric
roas_sales_amount	roas_sales_amount	The sales revenue used to calculate Return on Ad Spend (ROAS).	metric
roas_sales_amount_brand	roas_sales_amount_brand	The brand-specific sales revenue used to calculate Return on Ad Spend (ROAS).	metric
sales_amount	sales_amount	The total sales revenue generated.	metric
sales_amount_brand	sales_amount_brand	The total sales revenue specifically for the brand.	metric
site	site	The website or placement where the ad was displayed.	dimension
spend	spend	The total amount of money spent on advertising.	metric
start_date	start_date	The start date for the reporting period.	dimension
supply_source	supply_source	The source of the ad inventory (e.g., Amazon O&O, third-party exchanges).	dimension
time_to_conversion	time_to_conversion	The duration between an ad interaction (e.g., click or impression) and a conversion event.	dimension
time_window_end	time_window_end	The end of the time period for which data is reported.	dimension
time_window_start	time_window_start	The start of the time period for which data is reported.	dimension
total_add_to_cart	total_add_to_cart	The total number of times a product was added to a shopping cart across all tracked activity.	metric
total_brand_purchases	total_brand_purchases	The total number of purchases for the brand.	metric
total_clicks	total_clicks	The overall total number of clicks on ads.	metric
total_cost	total_cost	The overall total cost incurred for the advertising activity.	metric
total_detail_page_view	total_detail_page_view	The total number of times a product’s detail page was viewed.	metric
total_detail_page_view_clicks	total_detail_page_view_clicks	The total number of detail page views driven by ad clicks.	metric
total_detail_page_view_views	total_detail_page_view_views	The total number of detail page views driven by ad impressions (view-through).	metric
total_dpv	total_dpv	The overall total number of detail page views.	metric
total_impressions	total_impressions	The total number of times an ad was displayed. AMC reports over event-level Amazon Ads inputs such as impressions.	metric
total_ntb_product_sales	total_ntb_product_sales	The aggregated product sales attributed to new-to-brand customers.	metric
total_ntb_purchases	total_ntb_purchases	The aggregated number of purchases made by new-to-brand customers.	metric
total_ntb_units_sold	total_ntb_units_sold	The aggregated number of units sold to new-to-brand customers.	metric
total_product_sales	total_product_sales	The aggregate monetary value of all product sales.	metric
total_purchases	total_purchases	The aggregate count of all purchases.	metric
total_reach	total_reach	The total number of unique users who saw an ad at least once.	metric
total_sales_amount	total_sales_amount	The overall total sales revenue generated.	metric
total_units_sold	total_units_sold	The overall total number of units sold.	metric
tracked_asin	tracked_asin	The Amazon Standard Identification Number (ASIN) for the product being tracked or advertised.	dimension
unique_reach	unique_reach	The number of unique users who were exposed to an ad or campaign.	metric
units_sold	units_sold	The number of individual units of a product that were sold.	metric
user_purchase_rate	user_purchase_rate	The rate at which users make a purchase after interacting with an ad.	metric
users_count	users_count	The total number of unique users.	metric
users_dpv	users_dpv	The number of unique users who viewed a product’s detail page.	metric
users_ntb	users_ntb	The number of unique users identified as new-to-brand customers who interacted with the brand.	metric
users_purchased	users_purchased	The number of unique users who made a purchase.	metric
users_reached	users_reached	The number of unique users who were reached by an advertisement.	metric
users_that_converted	users_that_converted	The number of unique users who completed a conversion event.	metric
users_that_purchased	users_that_purchased	The number of unique users who made a purchase.	metric
video_complete	video_complete	The number of times a video ad was played to completion.	metric
video_impressions	video_impressions	The number of times a video ad was displayed.	metric
video_spend	video_spend	The amount of money spent specifically on video advertising.	metric
week_of_conversion_event_date_utc	week_of_conversion_event_date_utc	The week in Coordinated Universal Time (UTC) when the conversion event occurred.	dimension