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.
ad_groupDimension
The name assigned to an ad group, which is a structural component within a campaign used to organize creatives, budgets, and targeting.
ad_group_idDimension
A unique identifier for an ad group, which organizes creatives, budgets, targeting, and other settings within a campaign.
ad_product_typeDimension
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).
add_to_cartMetric
The number of times a product was added to a shopping cart after an ad interaction.
advertiserDimension
The name of the business entity running advertising campaigns on Amazon.
advertiser_idDimension
A unique identifier for the advertiser account. AMC APIs can manage AMC instances and accounts.
advertiser_timezoneDimension
The time zone configured for the advertiser's account, used for timestamp conversions and reporting.
browser_familyDimension
The family or type of web browser used by the user who interacted with the ad.
campaignDimension
The name of the advertising campaign.
campaign_end_dateDimension
The calendar date when a marketing campaign is scheduled to conclude.
campaign_end_date_utcDimension
The end date of the campaign, represented in Coordinated Universal Time (UTC).
campaign_idDimension
The unique identifier for an advertising campaign.
campaign_start_dateDimension
The calendar date when a marketing campaign is scheduled to begin.
campaign_start_date_utcDimension
The start date of the campaign, represented in Coordinated Universal Time (UTC).
campaign_typeDimension
The classification or type of the advertising campaign, such as Sponsored Products, Sponsored Brands, or Sponsored Display.
channelDimension
The advertising or sales platform (e.g., Amazon DSP, Sponsored Ads, Amazon Live, social media, advertiser's website) through which an ad event or conversion is attributed.
clicksMetric
The number of times an ad was clicked. AMC reports over event-level Amazon Ads inputs such as clicks.
conversion_rate_perc_allMetric
The percentage of ad interactions that resulted in a conversion.
conversionsMetric
The total number of successful user actions (conversions) attributed to advertising efforts.
creativeDimension
Information pertaining to the advertisement's creative content, which can include its name, ID, or type.
creative_idDimension
The unique identifier for a specific advertising creative.
creative_sizeDimension
The dimensions (width x height) of an ad creative, which can vary based on the ad format and placement (e.g., 300x250 for a medium rectangle or 320x50 for a mobile banner).
creative_typeDimension
The classification of the advertisement's creative format or style.
currency_iso_codeDimension
The ISO 4217 code for the currency used in financial metrics (e.g., 'USD', 'EUR').
customer_search_termDimension
The actual search query entered by a customer that led to an ad impression or click.
dateDimension
The date associated with the reported marketing or conversion event. This could refer to a traffic event date or a conversion event date within Amazon Marketing Cloud analyses.
date_utcDimension
The date in Coordinated Universal Time (UTC) for which the data is reported.
daysMetric
The number of days in the reporting period or a duration.
detail_page_viewMetric
The number of times a product's detail page was viewed after an ad interaction.
detail_page_view_clicksMetric
The number of detail page views that resulted from a click on an ad.
detail_page_view_viewsMetric
The number of detail page views that resulted from an impression (view-through) rather than a click.
detail_page_viewsMetric
The number of times a product's detail page was viewed.
device_typeDimension
The type of device used by the customer (e.g., mobile, desktop, tablet).
distinctusercountMetric
The count of unique users, or the minimum required user count, used to determine if a row passes Amazon Marketing Cloud's aggregation threshold rules for privacy-safe reporting.
dpvMetric
The number of detail page views.
end_dateDimension
The end date for the reporting period.
entity_idDimension
A unique identifier for an entity within the Amazon Marketing Cloud, such as an account, campaign, or creative. This ID is used to reference specific advertising components.
filteredmetricsdiscriminatorDimension
This field specifies a column to indicate whether data rows have been adjusted due to not meeting minimum distinct user count requirements. If this field is provided, rows that do not meet these requirements will have values in sensitive columns removed, and the output will be re-aggregated. Otherwise, such rows are completely filtered out of the workflow output.
frequencyMetric
The average number of times a unique user is exposed to an advertisement within a given period.
frequency_bucketDimension
A categorized range representing the number of times a user was exposed to an ad.
hourMetric
The hour of the day when a specific event or activity occurred, useful for granular time analysis.
hour_of_dayMetric
Represents the hour of the day when an event occurred, derived from event timestamps.
id_typeDimension
This field indicates the type of identifier used for audience resolution and data matching, such as adUserId, hashed personally identifiable information (PII), Mobile Ad IDs (IDFA and AAID), or external IDs provided by identity onboarding partners.
imp_total_costMetric
The total cost associated with impressions.
impression_dateDimension
The date on which an advertisement impression occurred.
impression_month_utcMetric
The month in Coordinated Universal Time (UTC) when the impression occurred.
impression_year_utcMetric
The year in Coordinated Universal Time (UTC) when the impression occurred.
impressionsMetric
The number of times an ad or product was displayed to a customer.
keywordDimension
The keyword targeted by an advertising campaign.
line_itemDimension
A granular component within an advertising campaign that defines specific targeting, bidding, and creative assignments. It serves as a dimension to aggregate report data.
line_item_end_dateDimension
The scheduled end date for a specific line item within an advertising campaign.
line_item_end_date_utcDimension
The end date of the line item, represented in Coordinated Universal Time (UTC).
line_item_idDimension
A unique identifier for the line item.
line_item_start_dateDimension
The scheduled start date for a specific line item within an advertising campaign.
line_item_start_date_utcDimension
The start date of the line item, represented in Coordinated Universal Time (UTC).
line_item_typeDimension
The classification or category of an advertising line item, such as display, video, or sponsored ads.
match_typeDimension
The type of match used for keywords in a campaign (e.g., exact, phrase, broad).
new_to_brand_product_salesMetric
Product sales attributed to new-to-brand customers.
new_to_brand_purchasesMetric
The number of purchases made by new-to-brand customers.
new_to_brand_total_product_salesMetric
The aggregated total product sales attributed to new-to-brand customers.
new_to_brand_total_purchasesMetric
The aggregated total number of purchases made by new-to-brand customers.
non_new_to_brand_product_salesMetric
Product sales attributed to existing customers (not new-to-brand).
non_new_to_brand_purchasesMetric
The number of purchases made by existing customers (not new-to-brand).
non_new_to_brand_total_product_salesMetric
The aggregated total product sales attributed to existing customers (not new-to-brand).
non_new_to_brand_total_purchasesMetric
The aggregated total number of purchases made by existing customers (not new-to-brand).
ntb_percentageMetric
The percentage of sales or customers that are identified as new-to-brand (NTB), indicating the effectiveness of advertising in attracting new customers.
ntb_product_salesMetric
Product sales attributed to new-to-brand customers, meaning customers who had not purchased from the brand on Amazon in the past 12 months.
ntb_purchasesMetric
The number of purchases made by customers identified as new to the brand.
ntb_sales_amountMetric
The total sales revenue generated from customers who are new-to-brand (NTB).
ntb_units_soldMetric
The number of units sold to new-to-brand customers.
ntb_users_that_purchasedMetric
The number of unique users identified as new-to-brand (NTB) who made a purchase.
operating_systemDimension
The operating system of the device used by the user who interacted with the ad.
pathDimension
The S3 bucket path where the generated report file is stored, including prefixes for the AMC instance name, workflow ID, and schedule type (daily, weekly, or adhoc).
product_salesMetric
The sales (in local currency) of promoted ASINs and brand halo ASINs purchased on Amazon, attributed to an ad view or click.
purchase_rateMetric
The rate at which ad interactions lead to a purchase.
purchasesMetric
The number of customer purchases, often attributed to traffic events.
reach_percentageMetric
The percentage of the target audience that was reached by the campaign.
roasMetric
Return on Ad Spend, a metric calculating the revenue generated for every dollar spent on advertising.
roas_sales_amountMetric
The sales revenue used to calculate Return on Ad Spend (ROAS).
roas_sales_amount_brandMetric
The brand-specific sales revenue used to calculate Return on Ad Spend (ROAS).
sales_amountMetric
The total sales revenue generated.
sales_amount_brandMetric
The total sales revenue specifically for the brand.
siteDimension
The website or placement where the ad was displayed.
spendMetric
The total cost incurred for an advertising campaign or specific ad activity.
start_dateMetric
The start date for the reporting period.
supply_costMetric
The cost associated with acquiring advertising inventory or media supply.
supply_sourceDimension
This field describes the inventory where a campaign ran, which can include real-time bidding exchanges or Amazon-owned sites.
time_window_endDimension
The end of the time period for which data is reported.
time_window_startDimension
The start of the time period for which data is reported.
total_clicksMetric
The overall total number of clicks on ads.
total_costMetric
The overall total cost incurred for the advertising activity.
total_detail_page_viewMetric
The total number of times a product's detail page was viewed.
total_detail_page_view_clicksMetric
The total number of detail page views driven by ad clicks.
total_detail_page_view_viewsMetric
The total number of detail page views driven by ad impressions (view-through).
total_dpvMetric
The overall total number of detail page views.
total_impressionsMetric
The total number of times an ad was displayed. AMC reports over event-level Amazon Ads inputs such as impressions.
total_product_salesMetric
The aggregate monetary value of all product sales.
total_purchasesMetric
The aggregate count of all purchases.
total_sales_amountMetric
The aggregated monetary value of all sales generated.
tracked_asinDimension
The Amazon Standard Identification Number (ASIN) of the product that is being tracked for advertising performance.
traffic_dateDimension
The date on which a specific traffic event, such as an impression or click, occurred.
traffic_event_dateDimension
The specific date on which an advertising traffic event, such as an ad impression or click, was recorded.
traffic_event_subtypeDimension
The specific classification of a traffic event, such as an impression, click, or video view, as reported within Amazon Ads.
unique_reachMetric
The number of unique users who were exposed to an ad or campaign.
units_soldMetric
The number of individual units of a product that were sold.
user_purchase_rateMetric
The conversion rate indicating the proportion of users who complete a purchase.
users_that_convertedMetric
The number of unique users who completed a conversion event.
users_that_purchasedMetric
The total number of unique users who completed one or more purchases within the analyzed time frame. This can be derived using distinct user counts on purchase events.
week_of_conversion_event_date_utcDimension
The week in Coordinated Universal Time (UTC) when the conversion event occurred.