Amazon Ads data warehouse table groups

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

Table: BRAND_KEYWORD

accountID
Display name Account ID
Description ID of the account
Field type dimension
Data type string.text.value
accountName
Display name Account name
Description Name of the account
Field type dimension
Data type string.text.value
adGroupId
Display name Ad group ID
Description Unique ad group ID
Field type dimension
Data type string.text.value
adGroupName
Display name Ad group name
Description Name of the ad group
Field type dimension
Data type string.text.value
attributedConversions14d
Display name 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
attributedConversions14dSameSKU
Display name 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
attributedOrdersNewToBrand14d
Display name 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
attributedSales14d
Display name 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
attributedSales14dSameSKU
Display name 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
attributedUnitsOrderedNewToBrand14d
Display name 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
campaignBudgetType
Display name Campaign budget type
Description One of ‘daily’ or ‘lifetime’
Field type dimension
Data type string.text.value
campaignId
Display name Campaign ID
Description Unique campaign ID
Field type dimension
Data type string.text.value
campaignName
Display name Campaign name
Description Advertiser created campaign name
Field type dimension
Data type string.text.value
campaignStatus
Display name Campaign status
Description Campaign’s current status represents user action
Field type dimension
Data type string.text.value
campaignType
Display name 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
clicks
Display name Clicks
Description The number of times your ads were clicked
Field type metric
Data type int.number.value
cost
Display name Spend
Description Total cost of all clicks. Can be divided by clicks to obtain average CPC
Field type metric
Data type float.currency.value
dataSourceName
Display name 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
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
impressions
Display name Impressions
Description The number of times ads were displayed
Field type metric
Data type int.number.value
keywordId
Display name Keyword ID
Description ID of the keyword used in bid
Field type dimension
Data type string.text.value
keywordText
Display name Keyword text
Description Text of the keyword or phrase used in bid
Field type dimension
Data type string.text.value
matchType
Display name 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
unitsSold14d
Display name 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

Table: BRAND_CAMPAIGN

accountID
Display name Account ID
Description ID of the account
Field type dimension
Data type string.text.value
accountName
Display name Account name
Description Name of the account
Field type dimension
Data type string.text.value
attributedConversions14d
Display name 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
attributedConversions14dSameSKU
Display name 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
attributedOrdersNewToBrand14d
Display name 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
attributedSales14d
Display name 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
attributedSales14dSameSKU
Display name 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
attributedUnitsOrderedNewToBrand14d
Display name 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
campaignBudgetType
Display name Campaign budget type
Description One of ‘daily’ or ‘lifetime’
Field type dimension
Data type string.text.value
campaignId
Display name Campaign ID
Description Unique campaign ID
Field type dimension
Data type string.text.value
campaignName
Display name Campaign name
Description Advertiser created campaign name
Field type dimension
Data type string.text.value
campaignStatus
Display name Campaign status
Description Campaign’s current status represents user action
Field type dimension
Data type string.text.value
campaignType
Display name 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
clicks
Display name Clicks
Description The number of times your ads were clicked
Field type metric
Data type int.number.value
cost
Display name Spend
Description Total cost of all clicks. Can be divided by clicks to obtain average CPC
Field type metric
Data type float.currency.value
dataSourceName
Display name 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
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
impressions
Display name Impressions
Description The number of times ads were displayed
Field type metric
Data type int.number.value
unitsSold14d
Display name 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

Table: PRODUCT_SEARCH

accountID
Display name Account ID
Description ID of the account
Field type dimension
Data type string.text.value
accountName
Display name Account name
Description Name of the account
Field type dimension
Data type string.text.value
attributedConversions7d
Display name 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
attributedConversions7dSameSKU
Display name 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
attributedSales7d
Display name 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
attributedSales7dSameSKU
Display name 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
attributedUnitsOrdered7d
Display name 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
attributedUnitsOrdered7dSameSKU
Display name 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
campaignId
Display name Campaign ID
Description Unique campaign ID
Field type dimension
Data type string.text.value
campaignName
Display name Campaign name
Description Advertiser created campaign name
Field type dimension
Data type string.text.value
campaignStatus
Display name Campaign status
Description Campaign’s current status represents user action
Field type dimension
Data type string.text.value
campaignType
Display name 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
clicks
Display name Clicks
Description The number of times your ads were clicked
Field type metric
Data type int.number.value
cost
Display name Spend
Description Total cost of all clicks. Can be divided by clicks to obtain average CPC
Field type metric
Data type float.currency.value
dataSourceName
Display name 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
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
impressions
Display name Impressions
Description The number of times ads were displayed
Field type metric
Data type int.number.value
keywordId
Display name Keyword ID
Description ID of the keyword used in bid
Field type dimension
Data type string.text.value
keywordText
Display name Keyword text
Description Text of the keyword or phrase used in bid
Field type dimension
Data type string.text.value
matchType
Display name 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

Table: PRODUCT_AD

accountID
Display name Account ID
Description ID of the account
Field type dimension
Data type string.text.value
accountName
Display name Account name
Description Name of the account
Field type dimension
Data type string.text.value
adGroupId
Display name Ad group ID
Description Unique ad group ID
Field type dimension
Data type string.text.value
adGroupName
Display name Ad group name
Description Name of the ad group
Field type dimension
Data type string.text.value
asin
Display name ASIN
Description The unique Amazon Standard Identification Number (ASIN) advertised
Field type dimension
Data type string.text.value
attributedConversions7d
Display name 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
attributedConversions7dSameSKU
Display name 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
attributedSales7d
Display name 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
attributedSales7dSameSKU
Display name 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
attributedUnitsOrdered7d
Display name 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
attributedUnitsOrdered7dSameSKU
Display name 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
campaignId
Display name Campaign ID
Description Unique campaign ID
Field type dimension
Data type string.text.value
campaignName
Display name Campaign name
Description Advertiser created campaign name
Field type dimension
Data type string.text.value
clicks
Display name Clicks
Description The number of times your ads were clicked
Field type metric
Data type int.number.value
cost
Display name Spend
Description Total cost of all clicks. Can be divided by clicks to obtain average CPC
Field type metric
Data type float.currency.value
dataSourceName
Display name 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
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
impressions
Display name Impressions
Description The number of times ads were displayed
Field type metric
Data type int.number.value
targetingType
Display name Targeting type
Description Campaign targeting type
Field type dimension
Data type string.text.value

Table: PRODUCT_ASINS

accountID
Display name Account ID
Description ID of the account
Field type dimension
Data type string.text.value
accountName
Display name Account name
Description Name of the account
Field type dimension
Data type string.text.value
adGroupId
Display name Ad group ID
Description Unique ad group ID
Field type dimension
Data type string.text.value
adGroupName
Display name Ad group name
Description Name of the ad group
Field type dimension
Data type string.text.value
asin
Display name ASIN
Description The unique Amazon Standard Identification Number (ASIN) advertised
Field type dimension
Data type string.text.value
attributedSales7dOtherSKU
Display name 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
attributedUnitsOrdered7dOtherSKU
Display name 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
campaignId
Display name Campaign ID
Description Unique campaign ID
Field type dimension
Data type string.text.value
campaignName
Display name Campaign name
Description Advertiser created campaign name
Field type dimension
Data type string.text.value
dataSourceName
Display name 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
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
keywordId
Display name Keyword ID
Description ID of the keyword used in bid
Field type dimension
Data type string.text.value
keywordText
Display name Keyword text
Description Text of the keyword or phrase used in bid
Field type dimension
Data type string.text.value
matchType
Display name 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
otherAsin
Display name Other ASIN
Description A non-dimensional metric for ASINs other than the one advertised
Field type dimension
Data type string.text.value
targetingType
Display name Targeting type
Description Campaign targeting type
Field type dimension
Data type string.text.value

Table: PRODUCT_KEYWORD

accountID
Display name Account ID
Description ID of the account
Field type dimension
Data type string.text.value
accountName
Display name Account name
Description Name of the account
Field type dimension
Data type string.text.value
attributedConversions7d
Display name 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
attributedConversions7dSameSKU
Display name 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
attributedSales7d
Display name 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
attributedSales7dSameSKU
Display name 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
attributedUnitsOrdered7d
Display name 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
attributedUnitsOrdered7dSameSKU
Display name 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
campaignId
Display name Campaign ID
Description Unique campaign ID
Field type dimension
Data type string.text.value
campaignName
Display name Campaign name
Description Advertiser created campaign name
Field type dimension
Data type string.text.value
campaignStatus
Display name Campaign status
Description Campaign’s current status represents user action
Field type dimension
Data type string.text.value
campaignType
Display name 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
clicks
Display name Clicks
Description The number of times your ads were clicked
Field type metric
Data type int.number.value
cost
Display name Spend
Description Total cost of all clicks. Can be divided by clicks to obtain average CPC
Field type metric
Data type float.currency.value
dataSourceName
Display name 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
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
impressions
Display name Impressions
Description The number of times ads were displayed
Field type metric
Data type int.number.value
keywordId
Display name Keyword ID
Description ID of the keyword used in bid
Field type dimension
Data type string.text.value
keywordText
Display name Keyword text
Description Text of the keyword or phrase used in bid
Field type dimension
Data type string.text.value
matchType
Display name 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

Table: PRODUCT_CAMPAIGN

accountID
Display name Account ID
Description ID of the account
Field type dimension
Data type string.text.value
accountName
Display name Account name
Description Name of the account
Field type dimension
Data type string.text.value
attributedConversions7d
Display name 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
attributedConversions7dSameSKU
Display name 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
attributedSales7d
Display name 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
attributedSales7dSameSKU
Display name 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
attributedUnitsOrdered7d
Display name 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
attributedUnitsOrdered7dSameSKU
Display name 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
campaignBudget
Display name Campaign budget
Description The campaign budget
Field type dimension
Data type string.text.value
campaignBudgetType
Display name Campaign budget type
Description One of ‘daily’ or ‘lifetime’
Field type dimension
Data type string.text.value
campaignId
Display name Campaign ID
Description Unique campaign ID
Field type dimension
Data type string.text.value
campaignName
Display name Campaign name
Description Advertiser created campaign name
Field type dimension
Data type string.text.value
campaignStatus
Display name Campaign status
Description Campaign’s current status represents user action
Field type dimension
Data type string.text.value
campaignType
Display name 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
clicks
Display name Clicks
Description The number of times your ads were clicked
Field type metric
Data type int.number.value
cost
Display name Spend
Description Total cost of all clicks. Can be divided by clicks to obtain average CPC
Field type metric
Data type float.currency.value
dataSourceName
Display name 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
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
impressions
Display name Impressions
Description The number of times ads were displayed
Field type metric
Data type int.number.value

Table: PRODUCT_SEARCHTARGET

accountID
Display name Account ID
Description ID of the account
Field type dimension
Data type string.text.value
accountName
Display name Account name
Description Name of the account
Field type dimension
Data type string.text.value
attributedConversions7d
Display name 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
attributedConversions7dSameSKU
Display name 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
attributedSales7d
Display name 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
attributedSales7dSameSKU
Display name 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
attributedUnitsOrdered7d
Display name 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
attributedUnitsOrdered7dSameSKU
Display name 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
campaignId
Display name Campaign ID
Description Unique campaign ID
Field type dimension
Data type string.text.value
campaignName
Display name Campaign name
Description Advertiser created campaign name
Field type dimension
Data type string.text.value
campaignStatus
Display name Campaign status
Description Campaign’s current status represents user action
Field type dimension
Data type string.text.value
campaignType
Display name 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
clicks
Display name Clicks
Description The number of times your ads were clicked
Field type metric
Data type int.number.value
cost
Display name Spend
Description Total cost of all clicks. Can be divided by clicks to obtain average CPC
Field type metric
Data type float.currency.value
dataSourceName
Display name 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
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
impressions
Display name Impressions
Description The number of times ads were displayed
Field type metric
Data type int.number.value
targetId
Display name Target ID
Description ID of the targeting expression used in a bid
Field type dimension
Data type string.text.value
targetingExpression
Display name Targeting expression
Description A string representation of your expression object in targeting clauses
Field type dimension
Data type string.text.value
targetingText
Display name Targeting text
Description A resolved string representation of your expression object in targeting clauses
Field type dimension
Data type string.text.value
targetingType
Display name Targeting type
Description Campaign targeting type
Field type dimension
Data type string.text.value

Table: DISPLAY_CAMPAIGN

accountID
Display name Account ID
Description ID of the account
Field type dimension
Data type string.text.value
accountName
Display name Account name
Description Name of the account
Field type dimension
Data type string.text.value
adGroupId
Display name Ad group ID
Description Unique ad group ID
Field type dimension
Data type string.text.value
adGroupName
Display name Ad group name
Description Name of the ad group
Field type dimension
Data type string.text.value
attributedConversions14d
Display name 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
attributedConversions14dSameSKU
Display name 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
attributedOrdersNewToBrand14d
Display name 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
attributedSales14d
Display name 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
attributedSales14dSameSKU
Display name 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
attributedSalesNewToBrand14d
Display name 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
attributedUnitsOrderedNewToBrand14d
Display name 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
campaignId
Display name Campaign ID
Description Unique campaign ID
Field type dimension
Data type string.text.value
campaignName
Display name Campaign name
Description Advertiser created campaign name
Field type dimension
Data type string.text.value
campaignType
Display name 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
clicks
Display name Clicks
Description The number of times your ads were clicked
Field type metric
Data type int.number.value
cost
Display name Spend
Description Total cost of all clicks. Can be divided by clicks to obtain average CPC
Field type metric
Data type float.currency.value
cpc
Display name CPC
Description Cost per click, spend divided by the number of clicks. CPC = Spend / Clicks
Field type metric
Data type float.currency.value
dataSourceName
Display name 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
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
impressions
Display name Impressions
Description The number of times ads were displayed
Field type metric
Data type int.number.value
targetId
Display name Target ID
Description ID of the targeting expression used in a bid
Field type dimension
Data type string.text.value
targetingExpression
Display name Targeting expression
Description A string representation of your expression object in targeting clauses
Field type dimension
Data type string.text.value
targetingText
Display name Targeting text
Description A resolved string representation of your expression object in targeting clauses
Field type dimension
Data type string.text.value
targetingType
Display name Targeting type
Description Campaign targeting type
Field type dimension
Data type string.text.value
viewAttributedConversions14d
Display name 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
viewAttributedSales14d
Display name Sales (view-attributed)
Description Number of attributed sales occurring within 14 days of view on ad
Field type metric
Data type float.currency.value
viewAttributedUnitsOrdered14d
Display name 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
viewImpressions
Display name 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

Table: DISPLAY_PRODUCT

accountID
Display name Account ID
Description ID of the account
Field type dimension
Data type string.text.value
accountName
Display name Account name
Description Name of the account
Field type dimension
Data type string.text.value
adGroupId
Display name Ad group ID
Description Unique ad group ID
Field type dimension
Data type string.text.value
adGroupName
Display name Ad group name
Description Name of the ad group
Field type dimension
Data type string.text.value
asin
Display name ASIN
Description The unique Amazon Standard Identification Number (ASIN) advertised
Field type dimension
Data type string.text.value
attributedConversions14d
Display name 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
attributedConversions14dSameSKU
Display name 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
attributedOrdersNewToBrand14d
Display name 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
attributedSales14d
Display name 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
attributedSales14dSameSKU
Display name 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
attributedSalesNewToBrand14d
Display name 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
attributedUnitsOrderedNewToBrand14d
Display name 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
campaignId
Display name Campaign ID
Description Unique campaign ID
Field type dimension
Data type string.text.value
campaignName
Display name Campaign name
Description Advertiser created campaign name
Field type dimension
Data type string.text.value
clicks
Display name Clicks
Description The number of times your ads were clicked
Field type metric
Data type int.number.value
cost
Display name Spend
Description Total cost of all clicks. Can be divided by clicks to obtain average CPC
Field type metric
Data type float.currency.value
dataSourceName
Display name 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
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
impressions
Display name Impressions
Description The number of times ads were displayed
Field type metric
Data type int.number.value
sku
Display name Advertised SKU
Description The SKU that is being advertised. Not available for vendors
Field type dimension
Data type string.text.value
viewAttributedConversions14d
Display name 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
viewAttributedSales14d
Display name Sales (view-attributed)
Description Number of attributed sales occurring within 14 days of view on ad
Field type metric
Data type float.currency.value
viewAttributedUnitsOrdered14d
Display name 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
viewImpressions
Display name 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

Table: DISPLAY_ASINS

accountID
Display name Account ID
Description ID of the account
Field type dimension
Data type string.text.value
accountName
Display name Account name
Description Name of the account
Field type dimension
Data type string.text.value
adGroupId
Display name Ad group ID
Description Unique ad group ID
Field type dimension
Data type string.text.value
adGroupName
Display name Ad group name
Description Name of the ad group
Field type dimension
Data type string.text.value
asin
Display name ASIN
Description The unique Amazon Standard Identification Number (ASIN) advertised
Field type dimension
Data type string.text.value
attributedSales14dOtherSKU
Display name 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
attributedUnitsOrdered14dOtherSKU
Display name 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
campaignId
Display name Campaign ID
Description Unique campaign ID
Field type dimension
Data type string.text.value
campaignName
Display name Campaign name
Description Advertiser created campaign name
Field type dimension
Data type string.text.value
dataSourceName
Display name 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
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
otherAsin
Display name Other ASIN
Description A non-dimensional metric for ASINs other than the one advertised
Field type dimension
Data type string.text.value
sku
Display name Advertised SKU
Description The SKU that is being advertised. Not available for vendors
Field type dimension
Data type string.text.value