Amazon Ads fields

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Amazon Ads data into Excel, BigQuery, Snowflake, Redshift, Azure

108 metrics57 dimensions

ACCOUNT

accountName
Field label Account name
Description Name of the account
Field type dimension
Data type string.text.value
accountID
Field label Account ID
Description ID of the account
Field type dimension
Data type string.text.value
currency
Field label Currency
Description Currency code of the account
Field type dimension
Data type string.currency.code

AD GROUP

adGroupId
Field label Ad group ID
Description Unique ad group ID
Field type dimension
Data type string.text.value
adGroupName
Field label Ad group name
Description Name of the ad group
Field type dimension
Data type string.text.value
adGroupState
Field label Ad group state
Description State of the ad group
Field type dimension
Data type string.text.value

ASINS

otherAsin
Field label Other ASIN
Description A non-dimensional metric for ASINs other than the one advertised
Field type dimension
Data type string.text.value
unitsOrderedOtherSKU
Field label Units ordered other SKU
Description Total number of units ordered within of a click on an ad where the purchased SKU was different from the SKU advertised. Attribution varies by campaign type. Sponsored Products - 7 day. Sponsored Display - 14 day
Field type metric
Data type int.number.value
attributedUnitsOrdered1dOtherSKU
Field label Units ordered other SKU (1 day)
Description Total number of units ordered within 1 day of an ad click where the purchased SKU was different from the SKU advertised
Field type metric
Data type float.currency.value
attributedUnitsOrdered7dOtherSKU
Field label Units ordered other SKU (7 day)
Description Total number of units ordered within 7 days of an ad click where the purchased SKU was different from the SKU advertised
Field type metric
Data type float.currency.value
attributedUnitsOrdered14dOtherSKU
Field label Units ordered other SKU (14 day)
Description Total number of units ordered within 14 days of an ad click where the purchased SKU was different from the SKU advertised
Field type metric
Data type float.currency.value
attributedUnitsOrdered30dOtherSKU
Field label Units ordered other SKU (30 day)
Description Total number of units ordered within 30 days of an ad click where the purchased SKU was different from the SKU advertised
Field type metric
Data type float.currency.value
salesOtherSKU
Field label Sales other SKU
Description Total value of sales occurring within a period of an ad click where the purchased SKU was different from the SKU advertised. Attribution varies by campaign type. Sponsored Products - 7 day. Sponsored Display - 14 day
Field type metric
Data type float.currency.value
attributedSales1dOtherSKU
Field label Sales other SKU (1 day)
Description Total value of sales occurring within 1 day of an ad click where the purchased SKU was different from the SKU advertised
Field type metric
Data type float.currency.value
attributedSales7dOtherSKU
Field label Sales other SKU (7 day)
Description Total value of sales occurring within 7 days of an ad click where the purchased SKU was different from the SKU advertised
Field type metric
Data type float.currency.value
attributedSales14dOtherSKU
Field label Sales other SKU (14 day)
Description Total value of sales occurring within 14 days of an ad click where the purchased SKU was different from the SKU advertised
Field type metric
Data type float.currency.value
attributedSales30dOtherSKU
Field label Sales other SKU (30 day)
Description Total value of sales occurring within 30 days of an ad click where the purchased SKU was different from the SKU advertised
Field type metric
Data type float.currency.value

BASIC

impressions
Field label Impressions
Description The number of times ads were displayed
Field type metric
Data type int.number.value
clicks
Field label Clicks
Description The number of times your ads were clicked
Field type metric
Data type int.number.value
cost
Field label Spend
Description Total cost of all clicks. Can be divided by clicks to obtain average CPC
Field type metric
Data type float.currency.value
cost_eur
Field label Spend (EUR)
Description Advertising cost converted to euros
Field type metric
Data type float.currency.value
Services Currency conversion
cost_gbp
Field label Spend (GBP)
Description Advertising cost converted to British pound sterling
Field type metric
Data type float.currency.value
Services Currency conversion
cost_usd
Field label Spend (USD)
Description Advertising cost converted to US dollars
Field type metric
Data type float.currency.value
Services Currency conversion
cpc
Field label CPC
Description Cost per click, spend divided by the number of clicks. CPC = Spend / Clicks
Field type metric
Data type float.currency.value
ctr
Field label CTR (%)
Description Click through rate, clicks divided by the number of impressions. CTR = Clicks / Impressions
Field type metric
Data type float.number.percentage
viewImpressions
Field label Viewable Impressions
Description Estimated number of impressions that meet the Media Rating Council's (MRC) standard for viewability
Field type metric
Data type float.currency.value
avgImpressionsFrequency
Field label Frequency
Description Average number of times unique users were exposed to an ad over the lifetime of the campaign. Only works with daily breakdowns
Field type metric
Data type float.number.value
Aggregation Non-aggregatable metric
cumulativeReach
Field label Reach
Description Total number of unique users exposed to an ad from either a campaign, ad group, or product ad over the lifetime of the campaign or the past six months, whichever is shorter. This metric is updated daily and only works with daily breakdowns
Field type metric
Data type int.number.value
Aggregation Non-aggregatable metric
acos
Field label ACOS
Description The percentage of your sales that you spend on advertising. This is calculated by dividing your spend by sales attributed to your ads. Attribution varies by campaign type. Sponsored Products - 7 day. Sponsored Brands - 14 day. Sponsored Display - 14 day
Field type metric
Data type float.number.percentage
ACOS1day
Field label ACOS (1 day)
Description The percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (1 day) * 100
Field type metric
Data type float.number.percentage
ACOS7day
Field label ACOS (7 day)
Description The percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (7 day) * 100
Field type metric
Data type float.number.percentage
ACOS14day
Field label ACOS (14 day)
Description The percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (14 day) * 100
Field type metric
Data type float.number.percentage
ACOS30day
Field label ACOS (30 day)
Description The percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (30 day) * 100
Field type metric
Data type float.number.percentage
roas
Field label ROAS
Description The revenue you receive from your advertising investment. This is calculated by dividing sales attributed to your ads by your spend. Attribution varies by campaign type. Sponsored Products - 7 day. Sponsored Brands - 14 day. Sponsored Display - 14 day
Field type metric
Data type float.number.ratio
ROAS1day
Field label ROAS (1 day)
Description The revenue you receive from your advertising investment. This is calculated by Sales (1 day) / Spend
Field type metric
Data type float.number.ratio
ROAS7day
Field label ROAS (7 day)
Description The revenue you receive from your advertising investment. This is calculated by Sales (7 day) / Spend
Field type metric
Data type float.number.ratio
ROAS14day
Field label ROAS (14 day)
Description The revenue you receive from your advertising investment. This is calculated by Sales (14 day) / Spend
Field type metric
Data type float.number.ratio
ROAS30day
Field label ROAS (30 day)
Description The revenue you receive from your advertising investment. This is calculated by Sales (30 day) / Spend
Field type metric
Data type float.number.ratio

CAMPAIGN

campaignId
Field label Campaign ID
Description Unique campaign ID
Field type dimension
Data type string.text.value
campaignName
Field label Campaign name
Description Advertiser created campaign name
Field type dimension
Data type string.text.value
campaignType
Field label Campaign type
Description Type value is based on the selected report type. Possible values include 'Sponsored Products', 'Sponsored Brands', or 'Sponsored Display'
Field type dimension
Data type string.text.value
targetingType
Field label Targeting type
Description Campaign targeting type
Field type dimension
Data type string.text.value
campaignBudgetType
Field label Campaign budget type
Description One of ‘daily’ or ‘lifetime’
Field type dimension
Data type string.text.value
campaignStatus
Field label Campaign status
Description Campaign’s current status represents user action
Field type dimension
Data type string.text.value
campaignServingStatus
Field label Campaign serving status
Description Campaign’s serving state of the campaign
Field type dimension
Data type string.text.value
campaignBudget
Field label Campaign budget
Description The campaign budget
Field type dimension
Data type string.text.value
startDate
Field label Start date
Description Start date of the campaign
Field type dimension
Data type string.time.date
endDate
Field label End date
Description End date of the campaign
Field type dimension
Data type string.time.date
campaigncosttype
Field label Campaign cost type
Description Determines how the campaign will bid and charge. Possible values include vCPM or CPC
Field type dimension
Data type string.text.value
placement
Field label Campaign placement
Description Campaign placement on website
Field type dimension
Data type string.text.value

CONVERSIONS

orders
Field label Orders
Description Orders is the number of Amazon orders placed by shoppers attributed to your ads. Attribution depends on campaign type. Sponsored Products - 7 day. Sponsored Brands - 14 day. Sponsored Display - 14 day
Field type metric
Data type int.number.value
attributedConversions1d
Field label Orders (1 day)
Description The number of Amazon orders placed by shoppers attributed to your ads within 1 day of clicking
Field type metric
Data type float.currency.value
attributedConversions7d
Field label Orders (7 day)
Description The number of Amazon orders placed by shoppers attributed to your ads within 7 days of clicking
Field type metric
Data type float.currency.value
attributedConversions14d
Field label Orders (14 day)
Description The number of Amazon orders placed by shoppers attributed to your ads within 14 days of clicking
Field type metric
Data type float.currency.value
attributedConversions30d
Field label Orders (30 day)
Description The number of Amazon orders placed by shoppers attributed to your ads within 30 days of clicking
Field type metric
Data type float.currency.value
ordersSameSKU
Field label Orders same SKU
Description Number of attributed conversion events occurring within a click on ad where the purchased SKU was the same as the one advertised. Attribution varies by campaign type. Sponsored Products - 7 day. Sponsored Brands - 14 day. Sponsored Display - 14 day
Field type metric
Data type int.number.value
attributedConversions1dSameSKU
Field label Orders same SKU (1 day)
Description Number of attributed conversion events occurring within 1 day of click on ad where the purchased SKU was the same as the one advertised
Field type metric
Data type float.currency.value
attributedConversions7dSameSKU
Field label Orders same SKU (7 day)
Description Number of attributed conversion events occurring within 7 days of click on ad where the purchased SKU was the same as the one advertised
Field type metric
Data type float.currency.value
attributedConversions14dSameSKU
Field label Orders same SKU (14 day)
Description Number of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
Field type metric
Data type float.currency.value
attributedConversions30dSameSKU
Field label Orders same SKU (30 day)
Description Number of attributed conversion events occurring within 30 days of click on ad where the purchased SKU was the same as the one advertised
Field type metric
Data type float.currency.value
conversionRate
Field label Conversion rate (%)
Description The conversion rate is Orders / Clicks * 100. Attribution varies by campaign type. Sponsored Products - 7 day. Sponsored Brands - 14 day. Sponsored Display - 14 day
Field type metric
Data type float.number.percentage
CTCrate1day
Field label Conversion rate (1 day)
Description The conversion rate is Orders (1 day) / Clicks * 100
Field type metric
Data type float.number.percentage
CTCrate7day
Field label Conversion rate (7 day)
Description The conversion rate is Orders (7 day) / Clicks * 100
Field type metric
Data type float.number.percentage
CTCrate14day
Field label Conversion rate (14 day)
Description The conversion rate is Orders (14 day) / Clicks * 100
Field type metric
Data type float.number.percentage
CTCrate30day
Field label Conversion rate (30 day)
Description The conversion rate is Orders (30 day) / Clicks * 100
Field type metric
Data type float.number.percentage
attributedOrdersNewToBrand14d
Field label NTB orders
Description The number of first-time orders for products within the brand over a 1-year period. Has 14 day attribution
Field type metric
Data type float.currency.value
viewAttributedConversions14d
Field label Orders (view-attributed)
Description Number of attributed conversion events occurring within 14 days of view on ad
Field type metric
Data type float.currency.value
detailpageviews
Field label Detail page views
Description Number of detail page views occurring within 14 days of an ad click or view
Field type metric
Data type int.number.value
addtocart
Field label Add to cart
Description Number of times shoppers added a brand's products to their cart, attributed to an ad view or click
Field type metric
Data type int.number.value
addtocartrate
Field label Add to cart rate
Description Number of times shoppers added a brand's products to their cart, attributed to an ad view or click
Field type metric
Data type float.number.ratio
addtocartclicks
Field label Add to cart clicks
Description Number of times shoppers added a brand's products to their cart, attributed to an ad click
Field type metric
Data type int.number.value
newtobranddetailpageviews
Field label NTB detail page views
Description The number of new detail page views from shoppers who have not previously viewed a detail page with an ASIN of the same brand in past 365 days and who either clicked or viewed an ad
Field type metric
Data type int.number.value
newtobranddetailpageviewclicks
Field label NTB detail page view clicks
Description Number of new-to-brand detail page views for all the brands' products, attributed to an ad click
Field type metric
Data type int.number.value

DATASOURCE

dataSourceName
Field label Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

DEPRECATED

bidPlus
Field label Bid plus
Description Bid Plus.
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2023-02-20
dayOfWeek
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweek
🚫 Deprecated Deprecated on 2024-01-10
7daysRoAS
Field label 7 days RoAS
Description The revenue you receive from your advertising investment. This is calculated by Sales (7 day) / Spend.
Field type metric
Data type float.currency.value
🚫 Deprecated Deprecated on 2024-01-10
7dayCtcRate
Field label 7 days conversion rate(%)
Description The conversion rate is Orders (7 day) / Clicks * 100.
Field type metric
Data type float.number.percentage
🚫 Deprecated Deprecated on 2024-01-10
1dayCtcRate
Field label 1 day conversion rate(%)
Description The conversion rate is Orders (1 day) / Clicks * 100.
Field type metric
Data type float.number.percentage
🚫 Deprecated Deprecated on 2024-01-10
30dayCtcRate
Field label 30 days conversion rate(%)
Description The conversion rate is Orders (30 day) / Clicks * 100.
Field type metric
Data type float.number.percentage
🚫 Deprecated Deprecated on 2024-01-10
14dayCtcRate
Field label 14 days conversion rate(%)
Description The conversion rate is Orders (14 day) / Clicks * 100.
Field type metric
Data type float.number.percentage
🚫 Deprecated Deprecated on 2024-01-10
7daysACoS
Field label 7 days ACoS
Description The percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (7 day) * 100.
Field type metric
Data type float.currency.value
🚫 Deprecated Deprecated on 2024-01-10
1daysACoS
Field label 1 day ACoS
Description The percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (1 day) * 100.
Field type metric
Data type float.currency.value
🚫 Deprecated Deprecated on 2024-01-10
30daysACoS
Field label 30 days ACoS
Description The percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (30 day) * 100.
Field type metric
Data type float.currency.value
🚫 Deprecated Deprecated on 2024-01-10
14daysACoS
Field label 14 days ACoS
Description The percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (14 day) * 100.
Field type metric
Data type float.currency.value
🚫 Deprecated Deprecated on 2024-01-10
1daysRoAS
Field label 1 day RoAS
Description The revenue you receive from your advertising investment. This is calculated by Sales (1 day) / Spend.
Field type metric
Data type float.currency.value
🚫 Deprecated Deprecated on 2024-01-10
14daysRoAS
Field label 14 days RoAS
Description The revenue you receive from your advertising investment. This is calculated by Sales (14 day) / Spend.
Field type metric
Data type float.currency.value
🚫 Deprecated Deprecated on 2024-01-10
30daysRoAS
Field label 30 days RoAS
Description The revenue you receive from your advertising investment. This is calculated by Sales (30 day) / Spend.
Field type metric
Data type float.currency.value
🚫 Deprecated Deprecated on 2024-01-10
kindleEditionNormalizedPagesRead14d
Field label 14 days Kindle edition normalized pages read
Description Number of attributed Kindle edition normalized pages read within 14 days of ad click.
Field type metric
Data type int.number.value
🚫 Deprecated Deprecated on 2024-01-10
kindleEditionNormalizedPagesRoyalties14d
Field label 14 days Kindle edition normalized pages royalties
Description The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click.
Field type metric
Data type float.currency.value
🚫 Deprecated Deprecated on 2024-01-10

KEYWORDS

keywordId
Field label Keyword ID
Description ID of the keyword used in bid
Field type dimension
Data type string.text.value
keywordText
Field label Keyword text
Description Text of the keyword or phrase used in bid
Field type dimension
Data type string.text.value
matchType
Field label Keyword match type
Description Type of matching for the keyword or phrase used in bid. Must be one of: broad, phrase, or exact
Field type dimension
Data type string.text.value
query
Field label Customer search term
Description Query text
Field type dimension
Data type string.text.value
keywordBid
Field label Keyword bid
Description Advertiser-set bid value for keyword
Field type dimension
Data type string.text.value
keywordStatus
Field label Keyword status
Description The status of the keyword
Field type dimension
Data type string.text.value
targetId
Field label Target ID
Description ID of the targeting expression used in a bid
Field type dimension
Data type string.text.value
targetingExpression
Field label Targeting expression
Description A string representation of your expression object in targeting clauses
Field type dimension
Data type string.text.value
targetingText
Field label Targeting text
Description A resolved string representation of your expression object in targeting clauses
Field type dimension
Data type string.text.value
searchTermImpressionRank
Field label Search term impression rank
Description Account-level ad-attributed impression rank for search terms
Field type metric
Data type int.number.value
searchTermImpressionShare
Field label Search term impression share
Description Account-level ad-attributed impression share for search terms
Field type metric
Data type float.number.value
brandedsearches
Field label Branded searches
Description The number of searches that included the name of your brand occurring within 14 days of an ad click or view
Field type metric
Data type int.number.value
brandedsearchesclicks
Field label Branded search clicks
Description The number of searches that included the name of your brand occurring within 14 days of an ad click
Field type metric
Data type int.number.value
topofsearchimpressionshare
Field label Top of search impression share
Description The percentage of top-of-search impressions earned out of all the top-of-search impressions that were eligible for a given date range
Field type metric
Data type float.number.value

ORDERS

unitsOrdered
Field label Units ordered
Description Number of attributed units ordered within a period of a click on an ad. Attribution varies by campaign type. Sponsored Products - 7 day
Field type metric
Data type int.number.value
attributedUnitsOrdered1d
Field label Units ordered (1 day)
Description Total number of units ordered within 1 day of an ad click
Field type metric
Data type float.currency.value
attributedUnitsOrdered7d
Field label Units ordered (7 day)
Description Total number of units ordered within 7 days of an ad click
Field type metric
Data type float.currency.value
attributedUnitsOrdered14d
Field label Units ordered (14 day)
Description Total number of units ordered within 14 days of an ad click
Field type metric
Data type float.currency.value
attributedUnitsOrdered30d
Field label Units ordered (30 day)
Description Total number of units ordered within 30 days of an ad click
Field type metric
Data type float.currency.value
unitsOrderedSameSKU
Field label Units ordered same SKU
Description Total number of units ordered within a period of a click on an ad where the purchased SKU was the same as the SKU advertised. Attribution varies by campaign type. Sponsored Products - 7 day
Field type metric
Data type int.number.value
attributedUnitsOrdered1dSameSKU
Field label Units ordered same SKU (1 day)
Description Total number of units ordered within 1 day of ad click where the purchased SKU was the same as the SKU advertised
Field type metric
Data type float.currency.value
attributedUnitsOrdered7dSameSKU
Field label Units ordered same SKU (7 day)
Description Total number of units ordered within 7 days of ad click where the purchased SKU was the same as the SKU advertised
Field type metric
Data type float.currency.value
attributedUnitsOrdered14dSameSKU
Field label Units ordered same SKU (14 day)
Description Total number of units ordered within 14 days of ad click where the purchased SKU was the same as the SKU advertised
Field type metric
Data type float.currency.value
attributedUnitsOrdered30dSameSKU
Field label Units ordered same SKU (30 day)
Description Total number of units ordered within 30 days of ad click where the purchased SKU was the same as the SKU advertised
Field type metric
Data type float.currency.value
attributedUnitsOrderedNewToBrand14d
Field label NTB units ordered
Description Number of attributed new-to-brand units ordered within 14 days of view on ad
Field type metric
Data type float.currency.value
viewAttributedUnitsOrdered14d
Field label Units ordered (view-attributed)
Description Number of attributed units ordered within 14 days of view on ad
Field type metric
Data type float.currency.value
unitsSold14d
Field label Units sold (vendor)
Description Number of attributed units sold within 14 days of click on an ad. Vendor-only field
Field type metric
Data type int.number.value

PRODUCT

sku
Field label Advertised SKU
Description The SKU that is being advertised. Not available for vendors
Field type dimension
Data type string.text.value
asin
Field label ASIN
Description The unique Amazon Standard Identification Number (ASIN) advertised
Field type dimension
Data type string.text.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

SALES

sales
Field label Sales
Description Sales is the total value of products sold to shoppers attributed to your ads. Attribution depends on campaign type. Sponsored Products - 7 day. Sponsored Brands - 14 day. Sponsored Display - 14 day
Field type metric
Data type float.currency.value
attributedSales1d
Field label Sales (1 day)
Description The total value of products sold to shoppers attributed to your ads within 1 day of clicking
Field type metric
Data type float.currency.value
attributedSales7d
Field label Sales (7 day)
Description The total value of products sold to shoppers attributed to your ads within 7 days of clicking
Field type metric
Data type float.currency.value
attributedSales14d
Field label Sales (14 day)
Description The total value of products sold to shoppers attributed to your ads within 14 days of clicking
Field type metric
Data type float.currency.value
attributedSales30d
Field label Sales (30 day)
Description The total value of products sold to shoppers attributed to your ads within 30 days of clicking
Field type metric
Data type float.currency.value
salesSameSKU
Field label Sales same SKU
Description Total value of sales occurring within a period of ad click where the purchased SKU was the same as the SKU advertised. Attribution varies by campaign type. Sponsored Products - 7 day. Sponsored Brands - 14 day. Sponsored Display - 14 day
Field type metric
Data type float.currency.value
attributedSales1dSameSKU
Field label Sales same SKU (1 day)
Description Total value of sales occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised
Field type metric
Data type float.currency.value
attributedSales7dSameSKU
Field label Sales same SKU (7 day)
Description Total value of sales occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised
Field type metric
Data type float.currency.value
attributedSales14dSameSKU
Field label Sales same SKU (14 day)
Description Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised
Field type metric
Data type float.currency.value
attributedSales30dSameSKU
Field label Sales same SKU (30 day)
Description Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised
Field type metric
Data type float.currency.value
attributedSalesNewToBrand14d
Field label NTB sales
Description The total sales (in local currency) of new-to-brand orders. Has 14 day attribution
Field type metric
Data type float.currency.value
viewAttributedSales14d
Field label Sales (view-attributed)
Description Number of attributed sales occurring within 14 days of view on ad
Field type metric
Data type float.currency.value

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
year
Field label Year
Description Year, e.g. 2017
Field type dimension
Data type string.time.year
yearOfWeek
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
yearOfWeekIso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
yearMonth
Field label Year & month
Description Year and month, e.g. 2017|06
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Description Month, e.g. 6
Field type dimension
Data type string.time.month
yearWeek
Field label Year & week (Sun-Sat)
Description Year and week for US weeks, e.g. 2017|08
Field type dimension
Data type string.time.yearweek
yearWeekIso
Field label Year & week (Mon-Sun)
Description Year and week for ISO weeks, e.g. 2017|08
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Description US week number, e.g. 51
Field type dimension
Data type string.time.week
weekIso
Field label Week (Mon-Sun)
Description ISO week number, e.g. 51
Field type dimension
Data type string.time.weekiso
dayOfMonth
Field label Day of month
Description Day of the month without leading zeros, e.g. 1 to 31
Field type dimension
Data type string.time.dayofmonth
dayOfWeekName
Field label Day of week (Sun-Sat)
Description Number and written name of the week, e.g. 0 Sunday
Field type dimension
Data type string.time.dayofweek
dayOfWeekNameIso
Field label Day of week (Mon-Sun)
Description Number and written name of the week, e.g. 0 Monday
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date

VIDEO

vctr
Field label vCTR
Description Click-through rate for views (clicks divided by views)
Field type metric
Data type float.number.percentage
vtr
Field label VTR
Description View-through rate (vtr). Views divided by impressions
Field type metric
Data type float.number.percentage
video5SecondViews
Field label Video views (5 sec)
Description The number of impressions where the customer watched the complete video or 5 seconds (whichever is shorter)
Field type metric
Data type int.number.value
video5SecondViewRate
Field label Video view 5 sec rate
Description The percentage of impressions where the customer watched the complete video or 5 seconds of the video (whichever is shorter)
Field type metric
Data type float.number.percentage
videoCompleteViews
Field label Video views (100%)
Description The number of impressions where the video was viewed to 100%
Field type metric
Data type int.number.value
videoFirstQuartileViews
Field label Video views (25%)
Description The number of impressions where the video was viewed to 25%
Field type metric
Data type int.number.value
videoMidpointViews
Field label Video views (50%)
Description The number of impressions where the video was viewed to 50%
Field type metric
Data type int.number.value
videoThirdQuartileViews
Field label Video views (75%)
Description The number of impressions where the video was viewed to 75%
Field type metric
Data type int.number.value
videoUnmutes
Field label Video unmutes
Description The number of impressions where a customer unmuted the video
Field type metric
Data type int.number.value
videoViewableImpressions
Field label Video viewable impressions
Description Number of impressions that met the Media Ratings Council (MRC) viewability standard (50 percent of the ad viewable with two seconds playback completed)
Field type metric
Data type int.number.value