Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
Category | Field | Code | Type | Description |
---|---|---|---|---|
TIME | Year | year | dim | Year, e.g. 2017 |
Year of week (Sun-Sat) | yearOfWeek | dim | ||
Year of week (Mon-Sun) | yearOfWeekIso | dim | ||
Year & month | yearMonth | dim | Year and month, e.g. 2017|06 | |
Month | month | dim | Month, e.g. 6 | |
Year & week (Sun-Sat) | yearWeek | dim | Year and week for US weeks, e.g. 2017|08 | |
Year & week (Mon-Sun) | yearWeekIso | dim | Year and week for ISO weeks, e.g. 2017|08 | |
Week (Sun-Sat) | week | dim | US week number, e.g. 51 | |
Week (Mon-Sun) | weekIso | dim | ISO week number, e.g. 51 | |
Day of month | dayOfMonth | dim | Day of the month without leading zeros, e.g. 1 to 31 | |
Day of week (Sun-Sat) | dayOfWeekName | dim | Number and written name of the week, e.g. 0 Sunday | |
Day of week (Mon-Sun) | dayOfWeekNameIso | dim | Number and written name of the week, e.g. 0 Monday | |
Date | date | dim | Date, e.g. 2017-01-31 | |
ACCOUNT | Account name | accountName | dim | Name of the account |
Account ID | accountID | dim | ID of the account | |
Currency | currency | dim | Currency code of the account | |
CAMPAIGN | Campaign ID | campaignId | dim | Unique campaign ID |
Campaign name | campaignName | dim | Advertiser created campaign name | |
Campaign type | campaignType | dim | Type value is based on the selected report type. Possible values include 'Sponsored Products', 'Sponsored Brands', or 'Sponsored Display' | |
Targeting type | targetingType | dim | Campaign targeting type | |
Campaign budget type | campaignBudgetType | dim | One of ‘daily’ or ‘lifetime’ | |
Campaign status | campaignStatus | dim | Campaign’s current status represents user action | |
Campaign serving status | campaignServingStatus | dim | Campaign’s serving state of the campaign | |
Campaign budget | campaignBudget | dim | The campaign budget | |
Start date | startDate | dim | Start date of the campaign | |
End date | endDate | dim | End date of the campaign | |
Campaign placement | placement | dim | Campaign placement on website | |
AD GROUP | Ad group ID | adGroupId | dim | Unique ad group ID |
Ad group name | adGroupName | dim | Name of the ad group | |
Ad group state | adGroupState | dim | State of the ad group | |
KEYWORDS | Keyword ID | keywordId | dim | ID of the keyword used in bid |
Keyword text | keywordText | dim | Text of the keyword or phrase used in bid | |
Keyword match type | matchType | dim | Type of matching for the keyword or phrase used in bid. Must be one of: broad, phrase, or exact | |
Customer search term | query | dim | Query text | |
Target ID | targetId | dim | ID of the targeting expression used in a bid | |
Targeting expression | targetingExpression | dim | A string representation of your expression object in targeting clauses | |
Targeting text | targetingText | dim | A resolved string representation of your expression object in targeting clauses | |
PRODUCT | Advertised SKU | sku | dim | The SKU that is being advertised. Not available for vendors |
ASIN | asin | dim | The unique Amazon Standard Identification Number (ASIN) advertised | |
ASINS | Other ASIN | otherAsin | dim | A non-dimensional metric for ASINs other than the one advertised |
DEPRECATED | Bid plus | bidPlus | dim | Bid Plus. Please note that this field will be removed on 2023-02-20 |
Day of week (Mon-Sun) | dayOfWeek | dim | Please note that this field will be removed on 2024-01-10 | |
BASIC | Impressions | impressions | met | The number of times ads were displayed |
Clicks | clicks | met | The number of times your ads were clicked | |
Spend | cost | met | Total cost of all clicks. Can be divided by clicks to obtain average CPC | |
Spend (EUR) | cost_eur | met | Advertising cost converted to euros | |
Spend (GBP) | cost_gbp | met | Advertising cost converted to British pound sterling | |
Spend (USD) | cost_usd | met | Advertising cost converted to US dollars | |
CPC | cpc | met | Cost per click, spend divided by the number of clicks. CPC = Spend / Clicks | |
CTR (%) | ctr | met | Click through rate, clicks divided by the number of impressions. CTR = Clicks / Impressions | |
ACOS | acos | met | 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 | |
ACOS (1 day) | ACOS1day | met | The percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (1 day) * 100 | |
ACOS (7 day) | ACOS7day | met | The percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (7 day) * 100 | |
ACOS (14 day) | ACOS14day | met | The percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (14 day) * 100 | |
ACOS (30 day) | ACOS30day | met | The percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (30 day) * 100 | |
ROAS | roas | met | 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 | |
ROAS (1 day) | ROAS1day | met | The revenue you receive from your advertising investment. This is calculated by Sales (1 day) / Spend | |
ROAS (7 day) | ROAS7day | met | The revenue you receive from your advertising investment. This is calculated by Sales (7 day) / Spend | |
ROAS (14 day) | ROAS14day | met | The revenue you receive from your advertising investment. This is calculated by Sales (14 day) / Spend | |
ROAS (30 day) | ROAS30day | met | The revenue you receive from your advertising investment. This is calculated by Sales (30 day) / Spend | |
CONVERSIONS | Orders | orders | met | 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 |
Orders (1 day) | attributedConversions1d | met | The number of Amazon orders placed by shoppers attributed to your ads within 1 day of clicking | |
Orders (7 day) | attributedConversions7d | met | The number of Amazon orders placed by shoppers attributed to your ads within 7 days of clicking | |
Orders (14 day) | attributedConversions14d | met | The number of Amazon orders placed by shoppers attributed to your ads within 14 days of clicking | |
Orders (30 day) | attributedConversions30d | met | The number of Amazon orders placed by shoppers attributed to your ads within 30 days of clicking | |
Orders same SKU | ordersSameSKU | met | 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 | |
Orders same SKU (1 day) | attributedConversions1dSameSKU | met | Number 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) | attributedConversions7dSameSKU | met | Number 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) | attributedConversions14dSameSKU | met | Number 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) | attributedConversions30dSameSKU | met | Number 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 (%) | conversionRate | met | The 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) | CTCrate1day | met | The conversion rate is Orders (1 day) / Clicks * 100 | |
Conversion rate (7 day) | CTCrate7day | met | The conversion rate is Orders (7 day) / Clicks * 100 | |
Conversion rate (14 day) | CTCrate14day | met | The conversion rate is Orders (14 day) / Clicks * 100 | |
Conversion rate (30 day) | CTCrate30day | met | The conversion rate is Orders (30 day) / Clicks * 100 | |
SALES | Sales | sales | met | 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 |
Sales (1 day) | attributedSales1d | met | The total value of products sold to shoppers attributed to your ads within 1 day of clicking | |
Sales (7 day) | attributedSales7d | met | The total value of products sold to shoppers attributed to your ads within 7 days of clicking | |
Sales (14 day) | attributedSales14d | met | The total value of products sold to shoppers attributed to your ads within 14 days of clicking | |
Sales (30 day) | attributedSales30d | met | The total value of products sold to shoppers attributed to your ads within 30 days of clicking | |
Sales same SKU | salesSameSKU | met | 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 | |
Sales same SKU (1 day) | attributedSales1dSameSKU | met | Total 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) | attributedSales7dSameSKU | met | Total 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) | attributedSales14dSameSKU | met | Total 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) | attributedSales30dSameSKU | met | Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised | |
ORDERS | Units ordered | unitsOrdered | met | Number 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) | attributedUnitsOrdered1d | met | Total number of units ordered within 1 day of an ad click | |
Units ordered (7 day) | attributedUnitsOrdered7d | met | Total number of units ordered within 7 days of an ad click | |
Units ordered (14 day) | attributedUnitsOrdered14d | met | Total number of units ordered within 14 days of an ad click | |
Units ordered (30 day) | attributedUnitsOrdered30d | met | Total number of units ordered within 30 days of an ad click | |
Units ordered same SKU | unitsOrderedSameSKU | met | 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 | |
Units ordered same SKU (1 day) | attributedUnitsOrdered1dSameSKU | met | Total 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) | attributedUnitsOrdered7dSameSKU | met | Total 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) | attributedUnitsOrdered14dSameSKU | met | Total 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) | attributedUnitsOrdered30dSameSKU | met | Total number of units ordered within 30 days of ad click where the purchased SKU was the same as the SKU advertised | |
ASINS | Units ordered other SKU | unitsOrderedOtherSKU | met | 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 |
Units ordered other SKU (1 day) | attributedUnitsOrdered1dOtherSKU | met | Total 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) | attributedUnitsOrdered7dOtherSKU | met | Total 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) | attributedUnitsOrdered14dOtherSKU | met | Total 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) | attributedUnitsOrdered30dOtherSKU | met | Total number of units ordered within 30 days of an ad click where the purchased SKU was different from the SKU advertised | |
Sales other SKU | salesOtherSKU | met | 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 | |
Sales other SKU (1 day) | attributedSales1dOtherSKU | met | Total 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) | attributedSales7dOtherSKU | met | Total 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) | attributedSales14dOtherSKU | met | Total 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) | attributedSales30dOtherSKU | met | Total value of sales occurring within 30 days of an ad click where the purchased SKU was different from the SKU advertised | |
DEPRECATED | 30 days RoAS | 30daysRoAS | met | The 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(%) | 7dayCtcRate | met | The conversion rate is Orders (7 day) / Clicks * 100. Please note that this field will be removed on 2024-01-10 | |
1 day conversion rate(%) | 1dayCtcRate | met | The conversion rate is Orders (1 day) / Clicks * 100. Please note that this field will be removed on 2024-01-10 | |
30 days conversion rate(%) | 30dayCtcRate | met | The conversion rate is Orders (30 day) / Clicks * 100. Please note that this field will be removed on 2024-01-10 | |
14 days conversion rate(%) | 14dayCtcRate | met | The conversion rate is Orders (14 day) / Clicks * 100. Please note that this field will be removed on 2024-01-10 | |
7 days ACoS | 7daysACoS | met | The 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 | 1daysACoS | met | The 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 | 30daysACoS | met | The 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 | 14daysACoS | met | The 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 | 1daysRoAS | met | The 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 | 7daysRoAS | met | The 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 | 14daysRoAS | met | The 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 read | kindleEditionNormalizedPagesRead14d | met | Number 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 royalties | kindleEditionNormalizedPagesRoyalties14d | met | The 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 | |
TIME | Year | year | dim | Year, e.g. 2017 |
Year of week (Sun-Sat) | yearOfWeek | dim | ||
Year of week (Mon-Sun) | yearOfWeekIso | dim | ||
Year & month | yearMonth | dim | Year and month, e.g. 2017|06 | |
Month | month | dim | Month, e.g. 6 | |
Year & week (Sun-Sat) | yearWeek | dim | Year and week for US weeks, e.g. 2017|08 | |
Year & week (Mon-Sun) | yearWeekIso | dim | Year and week for ISO weeks, e.g. 2017|08 | |
Week (Sun-Sat) | week | dim | US week number, e.g. 51 | |
Week (Mon-Sun) | weekIso | dim | ISO week number, e.g. 51 | |
Day of month | dayOfMonth | dim | Day of the month without leading zeros, e.g. 1 to 31 | |
Day of week (Sun-Sat) | dayOfWeekName | dim | Number and written name of the week, e.g. 0 Sunday | |
Day of week (Mon-Sun) | dayOfWeekNameIso | dim | Number and written name of the week, e.g. 0 Monday | |
Date | date | dim | Date, e.g. 2017-01-31 | |
ACCOUNT | Account name | accountName | dim | Name of the account |
Account ID | accountID | dim | ID of the account | |
CAMPAIGN | Campaign ID | campaignId | dim | Unique campaign ID |
Campaign name | campaignName | dim | Advertiser created campaign name | |
Campaign type | campaignType | dim | Type value is based on the selected report type. Possible values include 'Sponsored Products', 'Sponsored Brands', or 'Sponsored Display' | |
Targeting type | targetingType | dim | Campaign targeting type | |
Campaign budget type | campaignBudgetType | dim | One of ‘daily’ or ‘lifetime’ | |
Campaign status | campaignStatus | dim | Campaign’s current status represents user action | |
Campaign serving status | campaignServingStatus | dim | Campaign’s serving state of the campaign | |
Campaign budget | campaignBudget | dim | The campaign budget | |
Start date | startDate | dim | Start date of the campaign | |
End date | endDate | dim | End date of the campaign | |
Campaign placement | placement | dim | Campaign placement on website | |
AD GROUP | Ad group ID | adGroupId | dim | Unique ad group ID |
Ad group name | adGroupName | dim | Name of the ad group | |
Ad group state | adGroupState | dim | State of the ad group | |
KEYWORDS | Keyword ID | keywordId | dim | ID of the keyword used in bid |
Keyword text | keywordText | dim | Text of the keyword or phrase used in bid | |
Keyword match type | matchType | dim | Type of matching for the keyword or phrase used in bid. Must be one of: broad, phrase, or exact | |
Keyword bid | keywordBid | dim | Advertiser-set bid value for keyword | |
Keyword status | keywordStatus | dim | The status of the keyword | |
Target ID | targetId | dim | ID of the targeting expression used in a bid | |
Targeting expression | targetingExpression | dim | A string representation of your expression object in targeting clauses | |
Targeting text | targetingText | dim | A resolved string representation of your expression object in targeting clauses | |
DEPRECATED | Day of week (Mon-Sun) | dayOfWeek | dim | Please note that this field will be removed on 2024-01-10 |
BASIC | Impressions | impressions | met | The number of times ads were displayed |
Clicks | clicks | met | The number of times your ads were clicked | |
Spend | cost | met | Total cost of all clicks. Can be divided by clicks to obtain average CPC | |
CPC | cpc | met | Cost per click, spend divided by the number of clicks. CPC = Spend / Clicks | |
CTR (%) | ctr | met | Click through rate, clicks divided by the number of impressions. CTR = Clicks / Impressions | |
ACOS | acos | met | 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 | |
ACOS (14 day) | ACOS14day | met | The percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (14 day) * 100 | |
ROAS | roas | met | 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 | |
ROAS (14 day) | ROAS14day | met | The revenue you receive from your advertising investment. This is calculated by Sales (14 day) / Spend | |
CONVERSIONS | Orders | orders | met | 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 |
Orders (14 day) | attributedConversions14d | met | The number of Amazon orders placed by shoppers attributed to your ads within 14 days of clicking | |
Orders same SKU | ordersSameSKU | met | 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 | |
Orders same SKU (14 day) | attributedConversions14dSameSKU | met | Number 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 (%) | conversionRate | met | The 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) | CTCrate14day | met | The conversion rate is Orders (14 day) / Clicks * 100 | |
NTB orders | attributedOrdersNewToBrand14d | met | The number of first-time orders for products within the brand over a 1-year period. Has 14 day attribution | |
SALES | Sales | sales | met | 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 |
Sales (14 day) | attributedSales14d | met | The total value of products sold to shoppers attributed to your ads within 14 days of clicking | |
Sales same SKU | salesSameSKU | met | 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 | |
Sales same SKU (14 day) | attributedSales14dSameSKU | met | Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised | |
NTB sales | attributedSalesNewToBrand14d | met | The total sales (in local currency) of new-to-brand orders. Has 14 day attribution | |
ORDERS | NTB units ordered | attributedUnitsOrderedNewToBrand14d | met | Number of attributed new-to-brand units ordered within 14 days of view on ad |
Units sold (vendor) | unitsSold14d | met | Number of attributed units sold within 14 days of click on an ad. Vendor-only field | |
KEYWORDS | Search term impression rank | searchTermImpressionRank | met | Account-level ad-attributed impression rank for search terms |
Search term impression share | searchTermImpressionShare | met | Account-level ad-attributed impression share for search terms | |
VIDEO | vCTR | vctr | met | Click-through rate for views (clicks divided by views) |
VTR | vtr | met | View-through rate (vtr). Views divided by impressions | |
Video views (5 sec) | video5SecondViews | met | The number of impressions where the customer watched the complete video or 5 seconds (whichever is shorter) | |
Video view 5 sec rate | video5SecondViewRate | met | The percentage of impressions where the customer watched the complete video or 5 seconds of the video (whichever is shorter) | |
Video views (100%) | videoCompleteViews | met | The number of impressions where the video was viewed to 100% | |
Video views (25%) | videoFirstQuartileViews | met | The number of impressions where the video was viewed to 25% | |
Video views (50%) | videoMidpointViews | met | The number of impressions where the video was viewed to 50% | |
Video views (75%) | videoThirdQuartileViews | met | The number of impressions where the video was viewed to 75% | |
Video unmutes | videoUnmutes | met | The number of impressions where a customer unmuted the video | |
Video viewable impressions | videoViewableImpressions | met | Number of impressions that met the Media Ratings Council (MRC) viewability standard (50 percent of the ad viewable with two seconds playback completed) | |
DEPRECATED | 14 days conversion rate(%) | 14dayCtcRate | met | The conversion rate is Orders (14 day) / Clicks * 100. Please note that this field will be removed on 2024-01-10 |
14 days ACoS | 14daysACoS | met | The 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 | 14daysRoAS | met | The 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 | |
TIME | Year | year | dim | Year, e.g. 2017 |
Year of week (Sun-Sat) | yearOfWeek | dim | ||
Year of week (Mon-Sun) | yearOfWeekIso | dim | ||
Year & month | yearMonth | dim | Year and month, e.g. 2017|06 | |
Month | month | dim | Month, e.g. 6 | |
Year & week (Sun-Sat) | yearWeek | dim | Year and week for US weeks, e.g. 2017|08 | |
Year & week (Mon-Sun) | yearWeekIso | dim | Year and week for ISO weeks, e.g. 2017|08 | |
Week (Sun-Sat) | week | dim | US week number, e.g. 51 | |
Week (Mon-Sun) | weekIso | dim | ISO week number, e.g. 51 | |
Day of month | dayOfMonth | dim | Day of the month without leading zeros, e.g. 1 to 31 | |
Day of week (Sun-Sat) | dayOfWeekName | dim | Number and written name of the week, e.g. 0 Sunday | |
Day of week (Mon-Sun) | dayOfWeekNameIso | dim | Number and written name of the week, e.g. 0 Monday | |
Date | date | dim | Date, e.g. 2017-01-31 | |
ACCOUNT | Account name | accountName | dim | Name of the account |
Account ID | accountID | dim | ID of the account | |
Currency | currency | dim | Currency code of the account | |
CAMPAIGN | Campaign ID | campaignId | dim | Unique campaign ID |
Campaign name | campaignName | dim | Advertiser created campaign name | |
Campaign type | campaignType | dim | Type value is based on the selected report type. Possible values include 'Sponsored Products', 'Sponsored Brands', or 'Sponsored Display' | |
Targeting type | targetingType | dim | Campaign targeting type | |
Campaign budget type | campaignBudgetType | dim | One of ‘daily’ or ‘lifetime’ | |
Campaign status | campaignStatus | dim | Campaign’s current status represents user action | |
Campaign budget | campaignBudget | dim | The campaign budget | |
Start date | startDate | dim | Start date of the campaign | |
End date | endDate | dim | End date of the campaign | |
AD GROUP | Ad group ID | adGroupId | dim | Unique ad group ID |
Ad group name | adGroupName | dim | Name of the ad group | |
Ad group state | adGroupState | dim | State of the ad group | |
KEYWORDS | Target ID | targetId | dim | ID of the targeting expression used in a bid |
Targeting expression | targetingExpression | dim | A string representation of your expression object in targeting clauses | |
Targeting text | targetingText | dim | A resolved string representation of your expression object in targeting clauses | |
PRODUCT | Advertised SKU | sku | dim | The SKU that is being advertised. Not available for vendors |
ASIN | asin | dim | The unique Amazon Standard Identification Number (ASIN) advertised | |
ASINS | Other ASIN | otherAsin | dim | A non-dimensional metric for ASINs other than the one advertised |
DEPRECATED | Day of week (Mon-Sun) | dayOfWeek | dim | Please note that this field will be removed on 2024-01-10 |
BASIC | Impressions | impressions | met | The number of times ads were displayed |
Clicks | clicks | met | The number of times your ads were clicked | |
Spend | cost | met | Total cost of all clicks. Can be divided by clicks to obtain average CPC | |
Spend (EUR) | cost_eur | met | Advertising cost converted to euros | |
Spend (GBP) | cost_gbp | met | Advertising cost converted to British pound sterling | |
Spend (USD) | cost_usd | met | Advertising cost converted to US dollars | |
CPC | cpc | met | Cost per click, spend divided by the number of clicks. CPC = Spend / Clicks | |
CTR (%) | ctr | met | Click through rate, clicks divided by the number of impressions. CTR = Clicks / Impressions | |
Viewable Impressions | viewImpressions | met | Estimated number of impressions that meet the Media Rating Council's (MRC) standard for viewability | |
Frequency | avgImpressionsFrequency | met | Average number of times unique users were exposed to an ad over the lifetime of the campaign. Only works with daily breakdowns | |
Reach | cumulativeReach | met | 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 | |
ACOS | acos | met | 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 | |
ACOS (1 day) | ACOS1day | met | The percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (1 day) * 100 | |
ACOS (7 day) | ACOS7day | met | The percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (7 day) * 100 | |
ACOS (14 day) | ACOS14day | met | The percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (14 day) * 100 | |
ACOS (30 day) | ACOS30day | met | The percentage of your sales that you spend on advertising. This is calculated by Spend / Sales (30 day) * 100 | |
ROAS | roas | met | 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 | |
ROAS (1 day) | ROAS1day | met | The revenue you receive from your advertising investment. This is calculated by Sales (1 day) / Spend | |
ROAS (7 day) | ROAS7day | met | The revenue you receive from your advertising investment. This is calculated by Sales (7 day) / Spend | |
ROAS (14 day) | ROAS14day | met | The revenue you receive from your advertising investment. This is calculated by Sales (14 day) / Spend | |
ROAS (30 day) | ROAS30day | met | The revenue you receive from your advertising investment. This is calculated by Sales (30 day) / Spend | |
CONVERSIONS | Orders | orders | met | 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 |
Orders (1 day) | attributedConversions1d | met | The number of Amazon orders placed by shoppers attributed to your ads within 1 day of clicking | |
Orders (7 day) | attributedConversions7d | met | The number of Amazon orders placed by shoppers attributed to your ads within 7 days of clicking | |
Orders (14 day) | attributedConversions14d | met | The number of Amazon orders placed by shoppers attributed to your ads within 14 days of clicking | |
Orders (30 day) | attributedConversions30d | met | The number of Amazon orders placed by shoppers attributed to your ads within 30 days of clicking | |
Orders same SKU | ordersSameSKU | met | 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 | |
Orders same SKU (1 day) | attributedConversions1dSameSKU | met | Number 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) | attributedConversions7dSameSKU | met | Number 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) | attributedConversions14dSameSKU | met | Number 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) | attributedConversions30dSameSKU | met | Number 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 (%) | conversionRate | met | The 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) | CTCrate1day | met | The conversion rate is Orders (1 day) / Clicks * 100 | |
Conversion rate (7 day) | CTCrate7day | met | The conversion rate is Orders (7 day) / Clicks * 100 | |
Conversion rate (14 day) | CTCrate14day | met | The conversion rate is Orders (14 day) / Clicks * 100 | |
Conversion rate (30 day) | CTCrate30day | met | The conversion rate is Orders (30 day) / Clicks * 100 | |
NTB orders | attributedOrdersNewToBrand14d | met | The number of first-time orders for products within the brand over a 1-year period. Has 14 day attribution | |
Orders (view-attributed) | viewAttributedConversions14d | met | Number of attributed conversion events occurring within 14 days of view on ad | |
SALES | Sales | sales | met | 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 |
Sales (1 day) | attributedSales1d | met | The total value of products sold to shoppers attributed to your ads within 1 day of clicking | |
Sales (7 day) | attributedSales7d | met | The total value of products sold to shoppers attributed to your ads within 7 days of clicking | |
Sales (14 day) | attributedSales14d | met | The total value of products sold to shoppers attributed to your ads within 14 days of clicking | |
Sales (30 day) | attributedSales30d | met | The total value of products sold to shoppers attributed to your ads within 30 days of clicking | |
Sales same SKU | salesSameSKU | met | 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 | |
Sales same SKU (1 day) | attributedSales1dSameSKU | met | Total 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) | attributedSales7dSameSKU | met | Total 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) | attributedSales14dSameSKU | met | Total 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) | attributedSales30dSameSKU | met | Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised | |
NTB sales | attributedSalesNewToBrand14d | met | The total sales (in local currency) of new-to-brand orders. Has 14 day attribution | |
Sales (view-attributed) | viewAttributedSales14d | met | Number of attributed sales occurring within 14 days of view on ad | |
ORDERS | NTB units ordered | attributedUnitsOrderedNewToBrand14d | met | Number of attributed new-to-brand units ordered within 14 days of view on ad |
Units ordered (view-attributed) | viewAttributedUnitsOrdered14d | met | Number of attributed units ordered within 14 days of view on ad | |
ASINS | Units ordered other SKU | unitsOrderedOtherSKU | met | 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 |
Units ordered other SKU (1 day) | attributedUnitsOrdered1dOtherSKU | met | Total 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) | attributedUnitsOrdered7dOtherSKU | met | Total 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) | attributedUnitsOrdered14dOtherSKU | met | Total 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) | attributedUnitsOrdered30dOtherSKU | met | Total number of units ordered within 30 days of an ad click where the purchased SKU was different from the SKU advertised | |
Sales other SKU | salesOtherSKU | met | 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 | |
Sales other SKU (1 day) | attributedSales1dOtherSKU | met | Total 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) | attributedSales7dOtherSKU | met | Total 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) | attributedSales14dOtherSKU | met | Total 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) | attributedSales30dOtherSKU | met | Total value of sales occurring within 30 days of an ad click where the purchased SKU was different from the SKU advertised | |
DEPRECATED | 30 days RoAS | 30daysRoAS | met | The 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(%) | 7dayCtcRate | met | The conversion rate is Orders (7 day) / Clicks * 100. Please note that this field will be removed on 2024-01-10 | |
1 day conversion rate(%) | 1dayCtcRate | met | The conversion rate is Orders (1 day) / Clicks * 100. Please note that this field will be removed on 2024-01-10 | |
30 days conversion rate(%) | 30dayCtcRate | met | The conversion rate is Orders (30 day) / Clicks * 100. Please note that this field will be removed on 2024-01-10 | |
14 days conversion rate(%) | 14dayCtcRate | met | The conversion rate is Orders (14 day) / Clicks * 100. Please note that this field will be removed on 2024-01-10 | |
7 days ACoS | 7daysACoS | met | The 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 | 1daysACoS | met | The 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 | 30daysACoS | met | The 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 | 14daysACoS | met | The 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 | 1daysRoAS | met | The 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 | 7daysRoAS | met | The 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 | 14daysRoAS | met | The 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 |