Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure

Field list for Amazon Ads

189 metrics and 115 dimensions available

CategoryFieldCodeTypeDescription
TIMEYearyeardimYear, e.g. 2017
Year of week (Sun-Sat)yearOfWeekdim
Year of week (Mon-Sun)yearOfWeekIsodim
Year & monthyearMonthdimYear and month, e.g. 2017|06
MonthmonthdimMonth, e.g. 6
Year & week (Sun-Sat)yearWeekdimYear and week for US weeks, e.g. 2017|08
Year & week (Mon-Sun)yearWeekIsodimYear and week for ISO weeks, e.g. 2017|08
Week (Sun-Sat)weekdimUS week number, e.g. 51
Week (Mon-Sun)weekIsodimISO week number, e.g. 51
Day of monthdayOfMonthdimDay of the month without leading zeros, e.g. 1 to 31
Day of week (Sun-Sat)dayOfWeekNamedimNumber and written name of the week, e.g. 0 Sunday
Day of week (Mon-Sun)dayOfWeekNameIsodimNumber and written name of the week, e.g. 0 Monday
DatedatedimDate, e.g. 2017-01-31
ACCOUNTAccount nameaccountNamedimName of the account
Account IDaccountIDdimID of the account
CurrencycurrencydimCurrency code of the account
CAMPAIGNCampaign IDcampaignIddimUnique campaign ID
Campaign namecampaignNamedimAdvertiser created campaign name
Campaign typecampaignTypedimType value is based on the selected report type. Possible values include 'Sponsored Products', 'Sponsored Brands', or 'Sponsored Display'
Targeting typetargetingTypedimCampaign targeting type
Campaign budget typecampaignBudgetTypedimOne of ‘daily’ or ‘lifetime’
Campaign statuscampaignStatusdimCampaign’s current status represents user action
Campaign serving statuscampaignServingStatusdimCampaign’s serving state of the campaign
Campaign budgetcampaignBudgetdimThe campaign budget
Start datestartDatedimStart date of the campaign
End dateendDatedimEnd date of the campaign
Campaign placementplacementdimCampaign placement on website
AD GROUPAd group IDadGroupIddimUnique ad group ID
Ad group nameadGroupNamedimName of the ad group
Ad group stateadGroupStatedimState of the ad group
KEYWORDSKeyword IDkeywordIddimID of the keyword used in bid
Keyword textkeywordTextdimText of the keyword or phrase used in bid
Keyword match typematchTypedimType of matching for the keyword or phrase used in bid. Must be one of: broad, phrase, or exact
Customer search termquerydimQuery text
Target IDtargetIddimID of the targeting expression used in a bid
Targeting expressiontargetingExpressiondimA string representation of your expression object in targeting clauses
Targeting texttargetingTextdimA resolved string representation of your expression object in targeting clauses
PRODUCTAdvertised SKUskudimThe SKU that is being advertised. Not available for vendors
ASINasindimThe unique Amazon Standard Identification Number (ASIN) advertised
ASINSOther ASINotherAsindimA non-dimensional metric for ASINs other than the one advertised
DEPRECATEDBid plusbidPlusdimBid Plus. Please note that this field will be removed on 2023-02-20
Day of week (Mon-Sun)dayOfWeekdimPlease note that this field will be removed on 2024-01-10
BASICImpressionsimpressionsmetThe number of times ads were displayed
ClicksclicksmetThe number of times your ads were clicked
SpendcostmetTotal cost of all clicks. Can be divided by clicks to obtain average CPC
Spend (EUR)cost_eurmetAdvertising cost converted to euros
Spend (GBP)cost_gbpmetAdvertising cost converted to British pound sterling
Spend (USD)cost_usdmetAdvertising cost converted to US dollars
CPCcpcmetCost per click, spend divided by the number of clicks. CPC = Spend / Clicks
CTR (%)ctrmetClick through rate, clicks divided by the number of impressions. CTR = Clicks / Impressions
ACOSacosmetThe 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
ACOS (1 day)ACOS1daymetThe percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (1 day) * 100
ACOS (7 day)ACOS7daymetThe percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (7 day) * 100
ACOS (14 day)ACOS14daymetThe percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (14 day) * 100
ACOS (30 day)ACOS30daymetThe percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (30 day) * 100
ROASroasmetThe 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
ROAS (1 day)ROAS1daymetThe revenue you receive from your advertising investment. This is calculated by Sales (1 day) / Spend
ROAS (7 day)ROAS7daymetThe revenue you receive from your advertising investment. This is calculated by Sales (7 day) / Spend
ROAS (14 day)ROAS14daymetThe revenue you receive from your advertising investment. This is calculated by Sales (14 day) / Spend
ROAS (30 day)ROAS30daymetThe revenue you receive from your advertising investment. This is calculated by Sales (30 day) / Spend
CONVERSIONSOrdersordersmetOrders 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
Orders (1 day)attributedConversions1dmetThe number of Amazon orders placed by shoppers attributed to your ads within 1 day of clicking
Orders (7 day)attributedConversions7dmetThe number of Amazon orders placed by shoppers attributed to your ads within 7 days of clicking
Orders (14 day)attributedConversions14dmetThe number of Amazon orders placed by shoppers attributed to your ads within 14 days of clicking
Orders (30 day)attributedConversions30dmetThe number of Amazon orders placed by shoppers attributed to your ads within 30 days of clicking
Orders same SKUordersSameSKUmetNumber 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
Orders same SKU (1 day)attributedConversions1dSameSKUmetNumber of attributed conversion events occurring within 1 day of click on ad where the purchased SKU was the same as the one advertised
Orders same SKU (7 day)attributedConversions7dSameSKUmetNumber of attributed conversion events occurring within 7 days of click on ad where the purchased SKU was the same as the one advertised
Orders same SKU (14 day)attributedConversions14dSameSKUmetNumber of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
Orders same SKU (30 day)attributedConversions30dSameSKUmetNumber of attributed conversion events occurring within 30 days of click on ad where the purchased SKU was the same as the one advertised
Conversion rate (%)conversionRatemetThe conversion rate is Orders / Clicks * 100. Attribution varies by campaign type. Sponsored Products - 7 day. Sponsored Brands - 14 day. Sponsored Display - 14 day
Conversion rate (1 day)CTCrate1daymetThe conversion rate is Orders (1 day) / Clicks * 100
Conversion rate (7 day)CTCrate7daymetThe conversion rate is Orders (7 day) / Clicks * 100
Conversion rate (14 day)CTCrate14daymetThe conversion rate is Orders (14 day) / Clicks * 100
Conversion rate (30 day)CTCrate30daymetThe conversion rate is Orders (30 day) / Clicks * 100
SALESSalessalesmetSales 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
Sales (1 day)attributedSales1dmetThe total value of products sold to shoppers attributed to your ads within 1 day of clicking
Sales (7 day)attributedSales7dmetThe total value of products sold to shoppers attributed to your ads within 7 days of clicking
Sales (14 day)attributedSales14dmetThe total value of products sold to shoppers attributed to your ads within 14 days of clicking
Sales (30 day)attributedSales30dmetThe total value of products sold to shoppers attributed to your ads within 30 days of clicking
Sales same SKUsalesSameSKUmetTotal 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
Sales same SKU (1 day)attributedSales1dSameSKUmetTotal value of sales occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised
Sales same SKU (7 day)attributedSales7dSameSKUmetTotal value of sales occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised
Sales same SKU (14 day)attributedSales14dSameSKUmetTotal value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised
Sales same SKU (30 day)attributedSales30dSameSKUmetTotal value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised
ORDERSUnits orderedunitsOrderedmetNumber of attributed units ordered within a period of a click on an ad. Attribution varies by campaign type. Sponsored Products - 7 day
Units ordered (1 day)attributedUnitsOrdered1dmetTotal number of units ordered within 1 day of an ad click
Units ordered (7 day)attributedUnitsOrdered7dmetTotal number of units ordered within 7 days of an ad click
Units ordered (14 day)attributedUnitsOrdered14dmetTotal number of units ordered within 14 days of an ad click
Units ordered (30 day)attributedUnitsOrdered30dmetTotal number of units ordered within 30 days of an ad click
Units ordered same SKUunitsOrderedSameSKUmetTotal 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
Units ordered same SKU (1 day)attributedUnitsOrdered1dSameSKUmetTotal number of units ordered within 1 day of ad click where the purchased SKU was the same as the SKU advertised
Units ordered same SKU (7 day)attributedUnitsOrdered7dSameSKUmetTotal number of units ordered within 7 days of ad click where the purchased SKU was the same as the SKU advertised
Units ordered same SKU (14 day)attributedUnitsOrdered14dSameSKUmetTotal number of units ordered within 14 days of ad click where the purchased SKU was the same as the SKU advertised
Units ordered same SKU (30 day)attributedUnitsOrdered30dSameSKUmetTotal number of units ordered within 30 days of ad click where the purchased SKU was the same as the SKU advertised
ASINSUnits ordered other SKUunitsOrderedOtherSKUmetTotal 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
Units ordered other SKU (1 day)attributedUnitsOrdered1dOtherSKUmetTotal number of units ordered within 1 day of an ad click where the purchased SKU was different from the SKU advertised
Units ordered other SKU (7 day)attributedUnitsOrdered7dOtherSKUmetTotal number of units ordered within 7 days of an ad click where the purchased SKU was different from the SKU advertised
Units ordered other SKU (14 day)attributedUnitsOrdered14dOtherSKUmetTotal number of units ordered within 14 days of an ad click where the purchased SKU was different from the SKU advertised
Units ordered other SKU (30 day)attributedUnitsOrdered30dOtherSKUmetTotal number of units ordered within 30 days of an ad click where the purchased SKU was different from the SKU advertised
Sales other SKUsalesOtherSKUmetTotal 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
Sales other SKU (1 day)attributedSales1dOtherSKUmetTotal value of sales occurring within 1 day of an ad click where the purchased SKU was different from the SKU advertised
Sales other SKU (7 day)attributedSales7dOtherSKUmetTotal value of sales occurring within 7 days of an ad click where the purchased SKU was different from the SKU advertised
Sales other SKU (14 day)attributedSales14dOtherSKUmetTotal value of sales occurring within 14 days of an ad click where the purchased SKU was different from the SKU advertised
Sales other SKU (30 day)attributedSales30dOtherSKUmetTotal value of sales occurring within 30 days of an ad click where the purchased SKU was different from the SKU advertised
DEPRECATED30 days RoAS 30daysRoASmetThe revenue you receive from your advertising investment. This is calculated by Sales (30 day) / Spend. Please note that this field will be removed on 2024-01-10
7 days conversion rate(%)7dayCtcRatemetThe conversion rate is Orders (7 day) / Clicks * 100. Please note that this field will be removed on 2024-01-10
1 day conversion rate(%)1dayCtcRatemetThe conversion rate is Orders (1 day) / Clicks * 100. Please note that this field will be removed on 2024-01-10
30 days conversion rate(%)30dayCtcRatemetThe conversion rate is Orders (30 day) / Clicks * 100. Please note that this field will be removed on 2024-01-10
14 days conversion rate(%)14dayCtcRatemetThe conversion rate is Orders (14 day) / Clicks * 100. Please note that this field will be removed on 2024-01-10
7 days ACoS 7daysACoSmetThe percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (7 day) * 100. Please note that this field will be removed on 2024-01-10
1 day ACoS 1daysACoSmetThe percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (1 day) * 100. Please note that this field will be removed on 2024-01-10
30 days ACoS 30daysACoSmetThe percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (30 day) * 100. Please note that this field will be removed on 2024-01-10
14 days ACoS 14daysACoSmetThe percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (14 day) * 100. Please note that this field will be removed on 2024-01-10
1 day RoAS 1daysRoASmetThe revenue you receive from your advertising investment. This is calculated by Sales (1 day) / Spend. Please note that this field will be removed on 2024-01-10
7 days RoAS 7daysRoASmetThe revenue you receive from your advertising investment. This is calculated by Sales (7 day) / Spend. Please note that this field will be removed on 2024-01-10
14 days RoAS 14daysRoASmetThe revenue you receive from your advertising investment. This is calculated by Sales (14 day) / Spend. Please note that this field will be removed on 2024-01-10
14 days Kindle edition normalized pages readkindleEditionNormalizedPagesRead14dmetNumber of attributed Kindle edition normalized pages read within 14 days of ad click. Please note that this field will be removed on 2024-01-10
14 days Kindle edition normalized pages royaltieskindleEditionNormalizedPagesRoyalties14dmetThe estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click. Please note that this field will be removed on 2024-01-10
TIMEYearyeardimYear, e.g. 2017
Year of week (Sun-Sat)yearOfWeekdim
Year of week (Mon-Sun)yearOfWeekIsodim
Year & monthyearMonthdimYear and month, e.g. 2017|06
MonthmonthdimMonth, e.g. 6
Year & week (Sun-Sat)yearWeekdimYear and week for US weeks, e.g. 2017|08
Year & week (Mon-Sun)yearWeekIsodimYear and week for ISO weeks, e.g. 2017|08
Week (Sun-Sat)weekdimUS week number, e.g. 51
Week (Mon-Sun)weekIsodimISO week number, e.g. 51
Day of monthdayOfMonthdimDay of the month without leading zeros, e.g. 1 to 31
Day of week (Sun-Sat)dayOfWeekNamedimNumber and written name of the week, e.g. 0 Sunday
Day of week (Mon-Sun)dayOfWeekNameIsodimNumber and written name of the week, e.g. 0 Monday
DatedatedimDate, e.g. 2017-01-31
ACCOUNTAccount nameaccountNamedimName of the account
Account IDaccountIDdimID of the account
CAMPAIGNCampaign IDcampaignIddimUnique campaign ID
Campaign namecampaignNamedimAdvertiser created campaign name
Campaign typecampaignTypedimType value is based on the selected report type. Possible values include 'Sponsored Products', 'Sponsored Brands', or 'Sponsored Display'
Targeting typetargetingTypedimCampaign targeting type
Campaign budget typecampaignBudgetTypedimOne of ‘daily’ or ‘lifetime’
Campaign statuscampaignStatusdimCampaign’s current status represents user action
Campaign serving statuscampaignServingStatusdimCampaign’s serving state of the campaign
Campaign budgetcampaignBudgetdimThe campaign budget
Start datestartDatedimStart date of the campaign
End dateendDatedimEnd date of the campaign
Campaign placementplacementdimCampaign placement on website
AD GROUPAd group IDadGroupIddimUnique ad group ID
Ad group nameadGroupNamedimName of the ad group
Ad group stateadGroupStatedimState of the ad group
KEYWORDSKeyword IDkeywordIddimID of the keyword used in bid
Keyword textkeywordTextdimText of the keyword or phrase used in bid
Keyword match typematchTypedimType of matching for the keyword or phrase used in bid. Must be one of: broad, phrase, or exact
Keyword bidkeywordBiddimAdvertiser-set bid value for keyword
Keyword statuskeywordStatusdimThe status of the keyword
Target IDtargetIddimID of the targeting expression used in a bid
Targeting expressiontargetingExpressiondimA string representation of your expression object in targeting clauses
Targeting texttargetingTextdimA resolved string representation of your expression object in targeting clauses
DEPRECATEDDay of week (Mon-Sun)dayOfWeekdimPlease note that this field will be removed on 2024-01-10
BASICImpressionsimpressionsmetThe number of times ads were displayed
ClicksclicksmetThe number of times your ads were clicked
SpendcostmetTotal cost of all clicks. Can be divided by clicks to obtain average CPC
CPCcpcmetCost per click, spend divided by the number of clicks. CPC = Spend / Clicks
CTR (%)ctrmetClick through rate, clicks divided by the number of impressions. CTR = Clicks / Impressions
ACOSacosmetThe 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
ACOS (14 day)ACOS14daymetThe percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (14 day) * 100
ROASroasmetThe 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
ROAS (14 day)ROAS14daymetThe revenue you receive from your advertising investment. This is calculated by Sales (14 day) / Spend
CONVERSIONSOrdersordersmetOrders 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
Orders (14 day)attributedConversions14dmetThe number of Amazon orders placed by shoppers attributed to your ads within 14 days of clicking
Orders same SKUordersSameSKUmetNumber 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
Orders same SKU (14 day)attributedConversions14dSameSKUmetNumber of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
Conversion rate (%)conversionRatemetThe conversion rate is Orders / Clicks * 100. Attribution varies by campaign type. Sponsored Products - 7 day. Sponsored Brands - 14 day. Sponsored Display - 14 day
Conversion rate (14 day)CTCrate14daymetThe conversion rate is Orders (14 day) / Clicks * 100
NTB ordersattributedOrdersNewToBrand14dmetThe number of first-time orders for products within the brand over a 1-year period. Has 14 day attribution
SALESSalessalesmetSales 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
Sales (14 day)attributedSales14dmetThe total value of products sold to shoppers attributed to your ads within 14 days of clicking
Sales same SKUsalesSameSKUmetTotal 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
Sales same SKU (14 day)attributedSales14dSameSKUmetTotal value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised
NTB salesattributedSalesNewToBrand14dmetThe total sales (in local currency) of new-to-brand orders. Has 14 day attribution
ORDERSNTB units orderedattributedUnitsOrderedNewToBrand14dmetNumber of attributed new-to-brand units ordered within 14 days of view on ad
Units sold (vendor)unitsSold14dmetNumber of attributed units sold within 14 days of click on an ad. Vendor-only field
KEYWORDSSearch term impression ranksearchTermImpressionRankmetAccount-level ad-attributed impression rank for search terms
Search term impression sharesearchTermImpressionSharemetAccount-level ad-attributed impression share for search terms
VIDEOvCTRvctrmetClick-through rate for views (clicks divided by views)
VTRvtrmetView-through rate (vtr). Views divided by impressions
Video views (5 sec)video5SecondViewsmetThe number of impressions where the customer watched the complete video or 5 seconds (whichever is shorter)
Video view 5 sec ratevideo5SecondViewRatemetThe percentage of impressions where the customer watched the complete video or 5 seconds of the video (whichever is shorter)
Video views (100%)videoCompleteViewsmetThe number of impressions where the video was viewed to 100%
Video views (25%)videoFirstQuartileViewsmetThe number of impressions where the video was viewed to 25%
Video views (50%)videoMidpointViewsmetThe number of impressions where the video was viewed to 50%
Video views (75%)videoThirdQuartileViewsmetThe number of impressions where the video was viewed to 75%
Video unmutesvideoUnmutesmetThe number of impressions where a customer unmuted the video
Video viewable impressionsvideoViewableImpressionsmetNumber of impressions that met the Media Ratings Council (MRC) viewability standard (50 percent of the ad viewable with two seconds playback completed)
DEPRECATED14 days conversion rate(%)14dayCtcRatemetThe conversion rate is Orders (14 day) / Clicks * 100. Please note that this field will be removed on 2024-01-10
14 days ACoS 14daysACoSmetThe percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (14 day) * 100. Please note that this field will be removed on 2024-01-10
14 days RoAS 14daysRoASmetThe revenue you receive from your advertising investment. This is calculated by Sales (14 day) / Spend. Please note that this field will be removed on 2024-01-10
TIMEYearyeardimYear, e.g. 2017
Year of week (Sun-Sat)yearOfWeekdim
Year of week (Mon-Sun)yearOfWeekIsodim
Year & monthyearMonthdimYear and month, e.g. 2017|06
MonthmonthdimMonth, e.g. 6
Year & week (Sun-Sat)yearWeekdimYear and week for US weeks, e.g. 2017|08
Year & week (Mon-Sun)yearWeekIsodimYear and week for ISO weeks, e.g. 2017|08
Week (Sun-Sat)weekdimUS week number, e.g. 51
Week (Mon-Sun)weekIsodimISO week number, e.g. 51
Day of monthdayOfMonthdimDay of the month without leading zeros, e.g. 1 to 31
Day of week (Sun-Sat)dayOfWeekNamedimNumber and written name of the week, e.g. 0 Sunday
Day of week (Mon-Sun)dayOfWeekNameIsodimNumber and written name of the week, e.g. 0 Monday
DatedatedimDate, e.g. 2017-01-31
ACCOUNTAccount nameaccountNamedimName of the account
Account IDaccountIDdimID of the account
CurrencycurrencydimCurrency code of the account
CAMPAIGNCampaign IDcampaignIddimUnique campaign ID
Campaign namecampaignNamedimAdvertiser created campaign name
Campaign typecampaignTypedimType value is based on the selected report type. Possible values include 'Sponsored Products', 'Sponsored Brands', or 'Sponsored Display'
Targeting typetargetingTypedimCampaign targeting type
Campaign budget typecampaignBudgetTypedimOne of ‘daily’ or ‘lifetime’
Campaign statuscampaignStatusdimCampaign’s current status represents user action
Campaign budgetcampaignBudgetdimThe campaign budget
Start datestartDatedimStart date of the campaign
End dateendDatedimEnd date of the campaign
AD GROUPAd group IDadGroupIddimUnique ad group ID
Ad group nameadGroupNamedimName of the ad group
Ad group stateadGroupStatedimState of the ad group
KEYWORDSTarget IDtargetIddimID of the targeting expression used in a bid
Targeting expressiontargetingExpressiondimA string representation of your expression object in targeting clauses
Targeting texttargetingTextdimA resolved string representation of your expression object in targeting clauses
PRODUCTAdvertised SKUskudimThe SKU that is being advertised. Not available for vendors
ASINasindimThe unique Amazon Standard Identification Number (ASIN) advertised
ASINSOther ASINotherAsindimA non-dimensional metric for ASINs other than the one advertised
DEPRECATEDDay of week (Mon-Sun)dayOfWeekdimPlease note that this field will be removed on 2024-01-10
BASICImpressionsimpressionsmetThe number of times ads were displayed
ClicksclicksmetThe number of times your ads were clicked
SpendcostmetTotal cost of all clicks. Can be divided by clicks to obtain average CPC
Spend (EUR)cost_eurmetAdvertising cost converted to euros
Spend (GBP)cost_gbpmetAdvertising cost converted to British pound sterling
Spend (USD)cost_usdmetAdvertising cost converted to US dollars
CPCcpcmetCost per click, spend divided by the number of clicks. CPC = Spend / Clicks
CTR (%)ctrmetClick through rate, clicks divided by the number of impressions. CTR = Clicks / Impressions
Viewable ImpressionsviewImpressionsmetEstimated number of impressions that meet the Media Rating Council's (MRC) standard for viewability
FrequencyavgImpressionsFrequencymetAverage number of times unique users were exposed to an ad over the lifetime of the campaign. Only works with daily breakdowns
ReachcumulativeReachmetTotal 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
ACOSacosmetThe 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
ACOS (1 day)ACOS1daymetThe percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (1 day) * 100
ACOS (7 day)ACOS7daymetThe percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (7 day) * 100
ACOS (14 day)ACOS14daymetThe percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (14 day) * 100
ACOS (30 day)ACOS30daymetThe percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (30 day) * 100
ROASroasmetThe 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
ROAS (1 day)ROAS1daymetThe revenue you receive from your advertising investment. This is calculated by Sales (1 day) / Spend
ROAS (7 day)ROAS7daymetThe revenue you receive from your advertising investment. This is calculated by Sales (7 day) / Spend
ROAS (14 day)ROAS14daymetThe revenue you receive from your advertising investment. This is calculated by Sales (14 day) / Spend
ROAS (30 day)ROAS30daymetThe revenue you receive from your advertising investment. This is calculated by Sales (30 day) / Spend
CONVERSIONSOrdersordersmetOrders 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
Orders (1 day)attributedConversions1dmetThe number of Amazon orders placed by shoppers attributed to your ads within 1 day of clicking
Orders (7 day)attributedConversions7dmetThe number of Amazon orders placed by shoppers attributed to your ads within 7 days of clicking
Orders (14 day)attributedConversions14dmetThe number of Amazon orders placed by shoppers attributed to your ads within 14 days of clicking
Orders (30 day)attributedConversions30dmetThe number of Amazon orders placed by shoppers attributed to your ads within 30 days of clicking
Orders same SKUordersSameSKUmetNumber 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
Orders same SKU (1 day)attributedConversions1dSameSKUmetNumber of attributed conversion events occurring within 1 day of click on ad where the purchased SKU was the same as the one advertised
Orders same SKU (7 day)attributedConversions7dSameSKUmetNumber of attributed conversion events occurring within 7 days of click on ad where the purchased SKU was the same as the one advertised
Orders same SKU (14 day)attributedConversions14dSameSKUmetNumber of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
Orders same SKU (30 day)attributedConversions30dSameSKUmetNumber of attributed conversion events occurring within 30 days of click on ad where the purchased SKU was the same as the one advertised
Conversion rate (%)conversionRatemetThe conversion rate is Orders / Clicks * 100. Attribution varies by campaign type. Sponsored Products - 7 day. Sponsored Brands - 14 day. Sponsored Display - 14 day
Conversion rate (1 day)CTCrate1daymetThe conversion rate is Orders (1 day) / Clicks * 100
Conversion rate (7 day)CTCrate7daymetThe conversion rate is Orders (7 day) / Clicks * 100
Conversion rate (14 day)CTCrate14daymetThe conversion rate is Orders (14 day) / Clicks * 100
Conversion rate (30 day)CTCrate30daymetThe conversion rate is Orders (30 day) / Clicks * 100
NTB ordersattributedOrdersNewToBrand14dmetThe number of first-time orders for products within the brand over a 1-year period. Has 14 day attribution
Orders (view-attributed)viewAttributedConversions14dmetNumber of attributed conversion events occurring within 14 days of view on ad
SALESSalessalesmetSales 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
Sales (1 day)attributedSales1dmetThe total value of products sold to shoppers attributed to your ads within 1 day of clicking
Sales (7 day)attributedSales7dmetThe total value of products sold to shoppers attributed to your ads within 7 days of clicking
Sales (14 day)attributedSales14dmetThe total value of products sold to shoppers attributed to your ads within 14 days of clicking
Sales (30 day)attributedSales30dmetThe total value of products sold to shoppers attributed to your ads within 30 days of clicking
Sales same SKUsalesSameSKUmetTotal 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
Sales same SKU (1 day)attributedSales1dSameSKUmetTotal value of sales occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised
Sales same SKU (7 day)attributedSales7dSameSKUmetTotal value of sales occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised
Sales same SKU (14 day)attributedSales14dSameSKUmetTotal value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised
Sales same SKU (30 day)attributedSales30dSameSKUmetTotal value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised
NTB salesattributedSalesNewToBrand14dmetThe total sales (in local currency) of new-to-brand orders. Has 14 day attribution
Sales (view-attributed)viewAttributedSales14dmetNumber of attributed sales occurring within 14 days of view on ad
ORDERSNTB units orderedattributedUnitsOrderedNewToBrand14dmetNumber of attributed new-to-brand units ordered within 14 days of view on ad
Units ordered (view-attributed)viewAttributedUnitsOrdered14dmetNumber of attributed units ordered within 14 days of view on ad
ASINSUnits ordered other SKUunitsOrderedOtherSKUmetTotal 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
Units ordered other SKU (1 day)attributedUnitsOrdered1dOtherSKUmetTotal number of units ordered within 1 day of an ad click where the purchased SKU was different from the SKU advertised
Units ordered other SKU (7 day)attributedUnitsOrdered7dOtherSKUmetTotal number of units ordered within 7 days of an ad click where the purchased SKU was different from the SKU advertised
Units ordered other SKU (14 day)attributedUnitsOrdered14dOtherSKUmetTotal number of units ordered within 14 days of an ad click where the purchased SKU was different from the SKU advertised
Units ordered other SKU (30 day)attributedUnitsOrdered30dOtherSKUmetTotal number of units ordered within 30 days of an ad click where the purchased SKU was different from the SKU advertised
Sales other SKUsalesOtherSKUmetTotal 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
Sales other SKU (1 day)attributedSales1dOtherSKUmetTotal value of sales occurring within 1 day of an ad click where the purchased SKU was different from the SKU advertised
Sales other SKU (7 day)attributedSales7dOtherSKUmetTotal value of sales occurring within 7 days of an ad click where the purchased SKU was different from the SKU advertised
Sales other SKU (14 day)attributedSales14dOtherSKUmetTotal value of sales occurring within 14 days of an ad click where the purchased SKU was different from the SKU advertised
Sales other SKU (30 day)attributedSales30dOtherSKUmetTotal value of sales occurring within 30 days of an ad click where the purchased SKU was different from the SKU advertised
DEPRECATED30 days RoAS 30daysRoASmetThe revenue you receive from your advertising investment. This is calculated by Sales (30 day) / Spend. Please note that this field will be removed on 2024-01-10
7 days conversion rate(%)7dayCtcRatemetThe conversion rate is Orders (7 day) / Clicks * 100. Please note that this field will be removed on 2024-01-10
1 day conversion rate(%)1dayCtcRatemetThe conversion rate is Orders (1 day) / Clicks * 100. Please note that this field will be removed on 2024-01-10
30 days conversion rate(%)30dayCtcRatemetThe conversion rate is Orders (30 day) / Clicks * 100. Please note that this field will be removed on 2024-01-10
14 days conversion rate(%)14dayCtcRatemetThe conversion rate is Orders (14 day) / Clicks * 100. Please note that this field will be removed on 2024-01-10
7 days ACoS 7daysACoSmetThe percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (7 day) * 100. Please note that this field will be removed on 2024-01-10
1 day ACoS 1daysACoSmetThe percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (1 day) * 100. Please note that this field will be removed on 2024-01-10
30 days ACoS 30daysACoSmetThe percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (30 day) * 100. Please note that this field will be removed on 2024-01-10
14 days ACoS 14daysACoSmetThe percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (14 day) * 100. Please note that this field will be removed on 2024-01-10
1 day RoAS 1daysRoASmetThe revenue you receive from your advertising investment. This is calculated by Sales (1 day) / Spend. Please note that this field will be removed on 2024-01-10
7 days RoAS 7daysRoASmetThe revenue you receive from your advertising investment. This is calculated by Sales (7 day) / Spend. Please note that this field will be removed on 2024-01-10
14 days RoAS 14daysRoASmetThe revenue you receive from your advertising investment. This is calculated by Sales (14 day) / Spend. Please note that this field will be removed on 2024-01-10