Skip to content
Book a demo

Connect documentation

All documentation
Documentation

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.

FieldAdverity UI nameType
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.

audience_feeMetric
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).

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