Facebook Ads
Google Ads
Shopify
Google Analytics 4
Tiktok Ads
Linkedin Ads
Amazon Ads
Klaviyo
Microsoft/Bing Ads
Snapchat Ads
Instagram Insights
Google Search Console
Facebook Insights
Amazon Seller
WooCommerce
Pinterest Ads
Google My Business
YouTube Analytics
Google Trends
Apple Search Ads
HubSpot
Twitter AdsAmazon Ads Metrics and Dimensions
Field group | Field | Type | Data type | Description |
|---|---|---|---|---|
| Performance | Impressions | METRIC | INTEGER | Total number of ad impressions |
| Performance | View impressions | METRIC | INTEGER | The total number of viewable impressions. Only relevant for Sponsored Display vCPM campaigns |
| Performance | Clicks | METRIC | INTEGER | Total number of ad clicks |
| Performance | Amount spent | METRIC | CURRENCY | Total cost of ad clicks |
| Performance | CPC | METRIC | CURRENCY | Total cost divided by total number of clicks |
| Performance | Return on ad spend | METRIC | CURRENCY | Return On Ad Spend (ROAS) is 'total ad sales' divided by 'total ad cost' |
| Performance | CTR | METRIC | FLOAT | Click through rate, clicks divided by impressions |
| Performance | Conversion rate (CVR) | METRIC | RATIO | Conversion rate, 'total ad orders' divided by 'total clicks' |
| Performance | ACOS | METRIC | CURRENCY | Advertising cost of sales is 'total ad cost' divided by 'total ad sales' |
| ACOS (Attribution window) | 1 day ACOS | METRIC | CURRENCY | 1 day Advertising cost of sales is 'total ad cost' divided by '1 day total sales' |
| ACOS (Attribution window) | 7 days ACOS | METRIC | CURRENCY | 7 days Advertising cost of sales is 'total ad cost' divided by '7 day total sales' |
| ACOS (Attribution window) | 14 days ACOS | METRIC | CURRENCY | 14 days Advertising cost of sales is 'total ad cost' divided by '14 day total sales' |
| ACOS (Attribution window) | 30 days ACOS | METRIC | CURRENCY | 30 days Advertising cost of sales is 'total ad cost' divided by '30 day total sales' |
| ACOS (Attribution window) | 14 days ACOS (view-attributed) | METRIC | CURRENCY | 14 days Advertising cost of sales (view-attributed) is 'total ad cost' divided by '14 day total sales (view-attributed)' |
| ROAS (Attribution window) | 1 day ROAS | METRIC | CURRENCY | 1 day Return On Ad Spend (ROAS) is '1 day total sales' divided by 'total ad cost' |
| ROAS (Attribution window) | 7 days ROAS | METRIC | CURRENCY | 7 day Return On Ad Spend (ROAS) is '7 day total sales' divided by 'total ad cost' |
| ROAS (Attribution window) | 14 days ROAS | METRIC | CURRENCY | 14 day Return On Ad Spend (ROAS) is '14 day total sales' divided by 'total ad cost' |
| ROAS (Attribution window) | 30 days ROAS | METRIC | CURRENCY | 30 days Return On Ad Spend (ROAS) is '30 day total sales' divided by 'total ad cost' |
| ROAS (Attribution window) | 14 days ROAS (view-attributed) | METRIC | CURRENCY | 14 days Return On Ad Spend (ROAS) (view-attributed) is '14 day total sales (view-attributed)' divided by 'total ad cost' |
| CVR (Attribution window) | 1 day CVR | METRIC | RATIO | 1 day conversion rate, '1 day ad orders' divided by 'total clicks' |
| CVR (Attribution window) | 7 days CVR | METRIC | RATIO | 7 days conversion rate, '7 day ad orders' divided by 'total clicks' |
| CVR (Attribution window) | 14 days CVR | METRIC | RATIO | 14 days conversion rate, '14 days ad orders' divided by 'total clicks' |
| CVR (Attribution window) | 30 days CVR | METRIC | RATIO | 30 days conversion rate, '30 days ad orders' divided by 'total clicks' |
| CVR (Attribution window) | 14 days CVR (view-attributed) | METRIC | RATIO | 14 days conversion rate (view-attributed), '14 days ad orders (view-attributed)' divided by 'total clicks' |
| Conversions | Total ad orders | METRIC | INTEGER | The combined number of attributed conversion events generated from Sponsored Products, Sponsored Brands, and Sponsored Display advertisements |
| Conversions | 1 day total orders | METRIC | INTEGER | Number of attributed conversion events occurring within 1 day of an ad click. Sponsored Products only |
| Conversions | 7 day total orders | METRIC | INTEGER | Number of attributed conversion events occurring within 7 day of an ad click. Sponsored Products only |
| Conversions | 14 day total orders | METRIC | INTEGER | Number of attributed conversion events occurring within 14 day of an ad click |
| Conversions | 30 day total orders | METRIC | INTEGER | Number of attributed conversion events occurring within 30 day of an ad click. Sponsored Products only |
| Conversions | 14 day total orders (view-attributed) | METRIC | INTEGER | For Sponsored Display vCPM campaigns, the total number of attributed conversion events occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedConversions14d |
| Sales | Total ad sales | METRIC | CURRENCY | The combined value of sales generated from Sponsored Products, Sponsored Brands, and Sponsored Display advertisements |
| Sales | 1 day total sales | METRIC | CURRENCY | Total value of sales occurring within 1 day of an ad click. Sponsored Products only |
| Sales | 7 day total sales | METRIC | CURRENCY | Total value of sales occurring within 7 day of an ad click. Sponsored Products only |
| Sales | 14 day total sales | METRIC | CURRENCY | Total value of sales occurring within 14 days of an ad click |
| Sales | 30 day total sales | METRIC | CURRENCY | Total value of sales occurring within 30 days of an ad click. Sponsored Products only |
| Sales | 14 day total sales (view-attributed) | METRIC | CURRENCY | For Sponsored Display vCPM campaigns, the total value of sales occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedSales14d |
| Time | Date | DIMENSION | DATE | Date when the ad activity ocurred in the format YYYY-MM-DD |
| Time | Year | DIMENSION | YEAR | Events are broken down yearly |
| Time | Year month | DIMENSION | YEARMONTH | Events are broken down monthly |
| Time | Year month number | DIMENSION | YEAR_MONTH_NUMBER | Events are broken down monthly |
| Time | Month | DIMENSION | MONTH_NAME | Events are broken down monthly |
| Time | Month Number | DIMENSION | MONTH | Events are broken down monthly |
| Time | Week number(sun-sat) | DIMENSION | WEEK_NUMBER | Events are broken down weekly |
| Time | Week number(mon-sun) | DIMENSION | WEEK_ISO_NUMBER | Events are broken down ISO weekly |
| Time | Week start date(sun - sat) | DIMENSION | WEEK_START_DATE | Start date of the week |
| Time | Week start date(mon - sun) | DIMENSION | WEEK_ISO_START_DATE | Start date of the ISO week |
| Profile | Profile ID | DIMENSION | STRING | The encrypted unique ID of the marketplace profile |
| Profile | Currency code | DIMENSION | STRING | The currency code of the marketplace profile |
| Profile | Country code | DIMENSION | COUNTRY_CODE | The country code of the marketplace profile |
| Profile | Timezone | DIMENSION | STRING | The timezone of the marketplace profile |
| Account | Account name | DIMENSION | STRING | The name of the account |
| Account | Account ID | DIMENSION | STRING | The unique ID of the account |
| Account | Marketplace string ID | DIMENSION | STRING | The marketplace string ID of the account |
| Account | Account type | DIMENSION | STRING | The type of the account |
| Account | Is valid payment method | DIMENSION | BOOLEAN | returns true if the account has valid payment method |
| Sponsored ads | Ad type | DIMENSION | STRING | The ad type associated with sponsored ads (Sponsored Products, Sponsored Brands and Sponsored Display) |
| Sponsored ads | Brands creative type (deprecated) | DIMENSION | STRING | The creative type associated with Sponsored Brands campaigns. one of: NON_VIDEO, VIDEO |
| Portfolio | Portfolio name | DIMENSION | STRING | The portfolio name |
| Portfolio | Portfolio ID | DIMENSION | STRING | The portfolio identifier |
| Portfolio | Portfolio status | DIMENSION | STRING | The current state of the portfolio |
| Campaign | Campaign name | DIMENSION | STRING | The name associated with a campaign |
| Campaign | Campaign ID | DIMENSION | STRING | The ID associated with a campaign |
| Campaign | Campaign status | DIMENSION | STRING | The status of a campaign |
| Campaign | Campaign start date | DIMENSION | DATE | The start date of a campaign |
| Campaign | Campaign end date | DIMENSION | DATE | The end date of a campaign |
| Campaign | Campaign created date | DIMENSION | DATE | The date that the campaign was created |
| Campaign | Campaign updated date | DIMENSION | DATE | The date that the campaign was last updated |
| Campaign | Campaign created datetime | DIMENSION | DATETIME | The date time that the campaign was created |
| Campaign | Campaign updated datetime | DIMENSION | DATETIME | The date time that the campaign was last updated |
| Campaign | Campaign delivery status | DIMENSION | STRING | Overall status if the campaign is delivering or not |
| Campaign | Campaign delivery reasons | DIMENSION | STRING | List of reasons why the campaign is not delivering and the reasons behind the delivery status |
| Campaign | Campaign bid strategy | DIMENSION | STRING | The auto bidding strategy applied to to the campaign. For Sponsored Products and Sponsored Display only |
| Campaign | Campaign budget type | DIMENSION | STRING | The budget type of a campaign |
| Campaign | Campaign budget | DIMENSION | CURRENCY | The budget of a campaign |
| Campaign | Campaign cost type | DIMENSION | STRING | The cost type associated with a campaign. Sponsored Brands and Display only. One of CPC, VCPM |
| Campaign | Campaign targeting type | DIMENSION | STRING | The targeting type of a campaign. For Sponsored Products, one of Manual, Auto. For Sponsored Display, one of Contextual, Audience |
| Ad group | Ad group name | DIMENSION | STRING | The name of the ad group as entered by the advertiser |
| Ad group | Ad group ID | DIMENSION | STRING | Unique numerical ID of the ad group |
| Ad group | Ad group status | DIMENSION | STRING | Status of the ad group |
| Ad group | Ad group created date | DIMENSION | DATE | The date that the ad group was created |
| Ad group | Ad group updated date | DIMENSION | DATE | The date that the ad group was last updated |
| Ad group | Ad group created datetime | DIMENSION | DATETIME | The date time that the ad group was created. |
| Ad group | Ad group updated datetime | DIMENSION | DATETIME | The date time that the ad group was last updated |
| Ad group | Ad group delivery status | DIMENSION | STRING | Overall status if the ad group is delivering or not |
| Ad group | Ad group delivery reasons | DIMENSION | STRING | List of reasons why the ad group is not delivering and the reasons behind the delivery status |
| Ad group | Bid optimization | DIMENSION | STRING | Bid optimization for Sponsored Display ad groups. For vCPM campaigns, the value is always reach. For CPC campaigns, value is either clicks or conversions |
| Ad group | Ad group creative type | DIMENSION | STRING | The creative type of the ad group. Sponsored Display only |
| Placement | Placement | DIMENSION | STRING | The page location where an ad appeared |
| Ad | Ad ID | DIMENSION | STRING | Unique numerical ID of the ad. (Only Applicable to 'Advertised product' group) |
| Advertised product | Advertised product title | DIMENSION | STRING | The title of the advertised product |
| Advertised product | Advertised ASIN | DIMENSION | STRING | The ASIN associated to an advertised product |
| Advertised product | Advertised SKU | DIMENSION | STRING | The SKU being advertised. Not available for vendors |
| Advertised product | Product availability | DIMENSION | STRING | Stock availability of the advertised product |
| Advertised product | Advertised product brand | DIMENSION | STRING | Brand name of the advertised product |
| Advertised product | Advertised product category | DIMENSION | STRING | Category (browse node) name of the advertised product |
| Advertised product | Advertised product price | DIMENSION | CURRENCY | The price customer would pay for the buying option |
| Advertised product | Best seller rank | DIMENSION | STRING | Best seller rank position in the category |
| Advertised product | Product image URL | DIMENSION | IMAGE_URL | Url to the product image |
| Keywords | Keyword | DIMENSION | STRING | Text of the keyword |
| Keywords | Keyword ID | DIMENSION | STRING | ID associated with a keyword |
| Keywords | Keyword status | DIMENSION | STRING | Current status of a keyword |
| Keywords | Keyword type | DIMENSION | STRING | Type of matching for the keyword used in bid. For keywords, one of: BROAD, PHRASE, or EXACT |
| Keywords | Keyword bid | DIMENSION | CURRENCY | Bid associated with a keyword or targeting expression |
| Targeting | Targeting Expression | DIMENSION | STRING | A string representation of the expression object used in the targeting clause |
| Targeting | Target ID | DIMENSION | STRING | The identifier of the targeting expression |
| Targeting | Targeting type | DIMENSION | STRING | The type of targeting used in the expression. For targeting expressions, one of TARGETING_EXPRESSION or TARGETING_EXPRESSION_PREDEFINED |
| Search term | Search term | DIMENSION | STRING | The search term used by the customer |