---
title: "Amazon Ads data warehouse table groups"
slug: "amazon-ads-data-warehouse-table-groups"
description: "Explore the complete Supermetrics data warehouse table groups for Amazon Ads. See all the tables and the fields included in them."
updated: 2026-03-05T14:00:08Z
published: 2026-03-05T14:00:08Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Amazon Ads data warehouse table groups

Search fields<input type="text" id="field-search" placeholder="Search by field name, label, or description…" aria-label="Search fields by name, label, or description" autocomplete="off">

### Table: BRAND_KEYWORD

| \| accountID** \| \| --- \| \| \\| Display name \\| Account ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account ID \| \| Description \| ID of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| accountID** |
| \| Display name \| Account ID \| \| --- \| --- \| \| Description \| ID of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account ID |
| Description | ID of the account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| accountName** \| \| --- \| \| \\| Display name \\| Account name \\| \\| --- \\| --- \\| \\| Description \\| Name of the account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account name \| \| Description \| Name of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| accountName** |
| \| Display name \| Account name \| \| --- \| --- \| \| Description \| Name of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account name |
| Description | Name of the account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| adGroupId** \| \| --- \| \| \\| Display name \\| Ad group ID \\| \\| --- \\| --- \\| \\| Description \\| Unique ad group ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Ad group ID \| \| Description \| Unique ad group ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| adGroupId** |
| \| Display name \| Ad group ID \| \| --- \| --- \| \| Description \| Unique ad group ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Ad group ID |
| Description | Unique ad group ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| adGroupName** \| \| --- \| \| \\| Display name \\| Ad group name \\| \\| --- \\| --- \\| \\| Description \\| Name of the ad group \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Ad group name \| \| Description \| Name of the ad group \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| adGroupName** |
| \| Display name \| Ad group name \| \| --- \| --- \| \| Description \| Name of the ad group \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Ad group name |
| Description | Name of the ad group |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| campaignBudgetType** \| \| --- \| \| \\| Display name \\| Campaign budget type \\| \\| --- \\| --- \\| \\| Description \\| One of ‘daily’ or ‘lifetime’ \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign budget type \| \| Description \| One of ‘daily’ or ‘lifetime’ \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignBudgetType** |
| \| Display name \| Campaign budget type \| \| --- \| --- \| \| Description \| One of ‘daily’ or ‘lifetime’ \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign budget type |
| Description | One of ‘daily’ or ‘lifetime’ |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaignId** \| \| --- \| \| \\| Display name \\| Campaign ID \\| \\| --- \\| --- \\| \\| Description \\| Unique campaign ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign ID \| \| Description \| Unique campaign ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignId** |
| \| Display name \| Campaign ID \| \| --- \| --- \| \| Description \| Unique campaign ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign ID |
| Description | Unique campaign ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaignName** \| \| --- \| \| \\| Display name \\| Campaign name \\| \\| --- \\| --- \\| \\| Description \\| Advertiser created campaign name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign name \| \| Description \| Advertiser created campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignName** |
| \| Display name \| Campaign name \| \| --- \| --- \| \| Description \| Advertiser created campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign name |
| Description | Advertiser created campaign name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaignStatus** \| \| --- \| \| \\| Display name \\| Campaign status \\| \\| --- \\| --- \\| \\| Description \\| Campaign’s current status represents user action \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign status \| \| Description \| Campaign’s current status represents user action \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignStatus** |
| \| Display name \| Campaign status \| \| --- \| --- \| \| Description \| Campaign’s current status represents user action \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign status |
| Description | Campaign’s current status represents user action |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |
| \| clicks** \| \| --- \| \| \\| Display name \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| The number of times your ads were clicked \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks \| \| Description \| The number of times your ads were clicked \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| clicks** |
| \| Display name \| Clicks \| \| --- \| --- \| \| Description \| The number of times your ads were clicked \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Clicks |
| Description | The number of times your ads were clicked |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |
| \| date** \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Description \\| Date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| date** |
| \| Display name \| Date \| \| --- \| --- \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Date |
| Description | Date, e.g. 2017-01-31 |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| impressions** \| \| --- \| \| \\| Display name \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| The number of times ads were displayed \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions \| \| Description \| The number of times ads were displayed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| impressions** |
| \| Display name \| Impressions \| \| --- \| --- \| \| Description \| The number of times ads were displayed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Impressions |
| Description | The number of times ads were displayed |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| keywordId** \| \| --- \| \| \\| Display name \\| Keyword ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the keyword used in bid \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Keyword ID \| \| Description \| ID of the keyword used in bid \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| keywordId** |
| \| Display name \| Keyword ID \| \| --- \| --- \| \| Description \| ID of the keyword used in bid \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Keyword ID |
| Description | ID of the keyword used in bid |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| keywordText** \| \| --- \| \| \\| Display name \\| Keyword text \\| \\| --- \\| --- \\| \\| Description \\| Text of the keyword or phrase used in bid \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Keyword text \| \| Description \| Text of the keyword or phrase used in bid \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| keywordText** |
| \| Display name \| Keyword text \| \| --- \| --- \| \| Description \| Text of the keyword or phrase used in bid \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Keyword text |
| Description | Text of the keyword or phrase used in bid |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#number) \\| \| \| 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](/apidocs/field-data-types#number) \| |
| 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](/apidocs/field-data-types#number) \| |
| 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](/apidocs/field-data-types#number) |

### Table: BRAND_CAMPAIGN

| \| accountID** \| \| --- \| \| \\| Display name \\| Account ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account ID \| \| Description \| ID of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| accountID** |
| \| Display name \| Account ID \| \| --- \| --- \| \| Description \| ID of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account ID |
| Description | ID of the account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| accountName** \| \| --- \| \| \\| Display name \\| Account name \\| \\| --- \\| --- \\| \\| Description \\| Name of the account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account name \| \| Description \| Name of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| accountName** |
| \| Display name \| Account name \| \| --- \| --- \| \| Description \| Name of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account name |
| Description | Name of the account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| campaignBudgetType** \| \| --- \| \| \\| Display name \\| Campaign budget type \\| \\| --- \\| --- \\| \\| Description \\| One of ‘daily’ or ‘lifetime’ \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign budget type \| \| Description \| One of ‘daily’ or ‘lifetime’ \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignBudgetType** |
| \| Display name \| Campaign budget type \| \| --- \| --- \| \| Description \| One of ‘daily’ or ‘lifetime’ \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign budget type |
| Description | One of ‘daily’ or ‘lifetime’ |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaignId** \| \| --- \| \| \\| Display name \\| Campaign ID \\| \\| --- \\| --- \\| \\| Description \\| Unique campaign ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign ID \| \| Description \| Unique campaign ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignId** |
| \| Display name \| Campaign ID \| \| --- \| --- \| \| Description \| Unique campaign ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign ID |
| Description | Unique campaign ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaignName** \| \| --- \| \| \\| Display name \\| Campaign name \\| \\| --- \\| --- \\| \\| Description \\| Advertiser created campaign name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign name \| \| Description \| Advertiser created campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignName** |
| \| Display name \| Campaign name \| \| --- \| --- \| \| Description \| Advertiser created campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign name |
| Description | Advertiser created campaign name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaignStatus** \| \| --- \| \| \\| Display name \\| Campaign status \\| \\| --- \\| --- \\| \\| Description \\| Campaign’s current status represents user action \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign status \| \| Description \| Campaign’s current status represents user action \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignStatus** |
| \| Display name \| Campaign status \| \| --- \| --- \| \| Description \| Campaign’s current status represents user action \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign status |
| Description | Campaign’s current status represents user action |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |
| \| clicks** \| \| --- \| \| \\| Display name \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| The number of times your ads were clicked \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks \| \| Description \| The number of times your ads were clicked \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| clicks** |
| \| Display name \| Clicks \| \| --- \| --- \| \| Description \| The number of times your ads were clicked \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Clicks |
| Description | The number of times your ads were clicked |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |
| \| date** \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Description \\| Date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| date** |
| \| Display name \| Date \| \| --- \| --- \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Date |
| Description | Date, e.g. 2017-01-31 |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| impressions** \| \| --- \| \| \\| Display name \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| The number of times ads were displayed \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions \| \| Description \| The number of times ads were displayed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| impressions** |
| \| Display name \| Impressions \| \| --- \| --- \| \| Description \| The number of times ads were displayed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Impressions |
| Description | The number of times ads were displayed |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| 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](/apidocs/field-data-types#number) \\| \| \| 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](/apidocs/field-data-types#number) \| |
| 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](/apidocs/field-data-types#number) \| |
| 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](/apidocs/field-data-types#number) |

### Table: PRODUCT_SEARCH

| \| accountID** \| \| --- \| \| \\| Display name \\| Account ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account ID \| \| Description \| ID of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| accountID** |
| \| Display name \| Account ID \| \| --- \| --- \| \| Description \| ID of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account ID |
| Description | ID of the account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| accountName** \| \| --- \| \| \\| Display name \\| Account name \\| \\| --- \\| --- \\| \\| Description \\| Name of the account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account name \| \| Description \| Name of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| accountName** |
| \| Display name \| Account name \| \| --- \| --- \| \| Description \| Name of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account name |
| Description | Name of the account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| campaignId** \| \| --- \| \| \\| Display name \\| Campaign ID \\| \\| --- \\| --- \\| \\| Description \\| Unique campaign ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign ID \| \| Description \| Unique campaign ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignId** |
| \| Display name \| Campaign ID \| \| --- \| --- \| \| Description \| Unique campaign ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign ID |
| Description | Unique campaign ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaignName** \| \| --- \| \| \\| Display name \\| Campaign name \\| \\| --- \\| --- \\| \\| Description \\| Advertiser created campaign name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign name \| \| Description \| Advertiser created campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignName** |
| \| Display name \| Campaign name \| \| --- \| --- \| \| Description \| Advertiser created campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign name |
| Description | Advertiser created campaign name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaignStatus** \| \| --- \| \| \\| Display name \\| Campaign status \\| \\| --- \\| --- \\| \\| Description \\| Campaign’s current status represents user action \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign status \| \| Description \| Campaign’s current status represents user action \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignStatus** |
| \| Display name \| Campaign status \| \| --- \| --- \| \| Description \| Campaign’s current status represents user action \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign status |
| Description | Campaign’s current status represents user action |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |
| \| clicks** \| \| --- \| \| \\| Display name \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| The number of times your ads were clicked \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks \| \| Description \| The number of times your ads were clicked \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| clicks** |
| \| Display name \| Clicks \| \| --- \| --- \| \| Description \| The number of times your ads were clicked \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Clicks |
| Description | The number of times your ads were clicked |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |
| \| date** \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Description \\| Date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| date** |
| \| Display name \| Date \| \| --- \| --- \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Date |
| Description | Date, e.g. 2017-01-31 |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| impressions** \| \| --- \| \| \\| Display name \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| The number of times ads were displayed \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions \| \| Description \| The number of times ads were displayed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| impressions** |
| \| Display name \| Impressions \| \| --- \| --- \| \| Description \| The number of times ads were displayed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Impressions |
| Description | The number of times ads were displayed |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| keywordId** \| \| --- \| \| \\| Display name \\| Keyword ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the keyword used in bid \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Keyword ID \| \| Description \| ID of the keyword used in bid \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| keywordId** |
| \| Display name \| Keyword ID \| \| --- \| --- \| \| Description \| ID of the keyword used in bid \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Keyword ID |
| Description | ID of the keyword used in bid |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| keywordText** \| \| --- \| \| \\| Display name \\| Keyword text \\| \\| --- \\| --- \\| \\| Description \\| Text of the keyword or phrase used in bid \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Keyword text \| \| Description \| Text of the keyword or phrase used in bid \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| keywordText** |
| \| Display name \| Keyword text \| \| --- \| --- \| \| Description \| Text of the keyword or phrase used in bid \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Keyword text |
| Description | Text of the keyword or phrase used in bid |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |

### Table: PRODUCT_AD

| \| accountID** \| \| --- \| \| \\| Display name \\| Account ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account ID \| \| Description \| ID of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| accountID** |
| \| Display name \| Account ID \| \| --- \| --- \| \| Description \| ID of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account ID |
| Description | ID of the account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| accountName** \| \| --- \| \| \\| Display name \\| Account name \\| \\| --- \\| --- \\| \\| Description \\| Name of the account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account name \| \| Description \| Name of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| accountName** |
| \| Display name \| Account name \| \| --- \| --- \| \| Description \| Name of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account name |
| Description | Name of the account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| adGroupId** \| \| --- \| \| \\| Display name \\| Ad group ID \\| \\| --- \\| --- \\| \\| Description \\| Unique ad group ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Ad group ID \| \| Description \| Unique ad group ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| adGroupId** |
| \| Display name \| Ad group ID \| \| --- \| --- \| \| Description \| Unique ad group ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Ad group ID |
| Description | Unique ad group ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| adGroupName** \| \| --- \| \| \\| Display name \\| Ad group name \\| \\| --- \\| --- \\| \\| Description \\| Name of the ad group \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Ad group name \| \| Description \| Name of the ad group \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| adGroupName** |
| \| Display name \| Ad group name \| \| --- \| --- \| \| Description \| Name of the ad group \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Ad group name |
| Description | Name of the ad group |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| asin** \| \| --- \| \| \\| Display name \\| ASIN \\| \\| --- \\| --- \\| \\| Description \\| The unique Amazon Standard Identification Number (ASIN) advertised \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| ASIN \| \| Description \| The unique Amazon Standard Identification Number (ASIN) advertised \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| asin** |
| \| Display name \| ASIN \| \| --- \| --- \| \| Description \| The unique Amazon Standard Identification Number (ASIN) advertised \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | ASIN |
| Description | The unique Amazon Standard Identification Number (ASIN) advertised |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| campaignId** \| \| --- \| \| \\| Display name \\| Campaign ID \\| \\| --- \\| --- \\| \\| Description \\| Unique campaign ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign ID \| \| Description \| Unique campaign ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignId** |
| \| Display name \| Campaign ID \| \| --- \| --- \| \| Description \| Unique campaign ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign ID |
| Description | Unique campaign ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaignName** \| \| --- \| \| \\| Display name \\| Campaign name \\| \\| --- \\| --- \\| \\| Description \\| Advertiser created campaign name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign name \| \| Description \| Advertiser created campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignName** |
| \| Display name \| Campaign name \| \| --- \| --- \| \| Description \| Advertiser created campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign name |
| Description | Advertiser created campaign name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| clicks** \| \| --- \| \| \\| Display name \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| The number of times your ads were clicked \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks \| \| Description \| The number of times your ads were clicked \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| clicks** |
| \| Display name \| Clicks \| \| --- \| --- \| \| Description \| The number of times your ads were clicked \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Clicks |
| Description | The number of times your ads were clicked |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |
| \| date** \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Description \\| Date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| date** |
| \| Display name \| Date \| \| --- \| --- \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Date |
| Description | Date, e.g. 2017-01-31 |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| impressions** \| \| --- \| \| \\| Display name \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| The number of times ads were displayed \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions \| \| Description \| The number of times ads were displayed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| impressions** |
| \| Display name \| Impressions \| \| --- \| --- \| \| Description \| The number of times ads were displayed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Impressions |
| Description | The number of times ads were displayed |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| targetingType** \| \| --- \| \| \\| Display name \\| Targeting type \\| \\| --- \\| --- \\| \\| Description \\| Campaign targeting type \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Targeting type \| \| Description \| Campaign targeting type \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| targetingType** |
| \| Display name \| Targeting type \| \| --- \| --- \| \| Description \| Campaign targeting type \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Targeting type |
| Description | Campaign targeting type |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### Table: PRODUCT_ASINS

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

### Table: PRODUCT_KEYWORD

| \| accountID** \| \| --- \| \| \\| Display name \\| Account ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account ID \| \| Description \| ID of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| accountID** |
| \| Display name \| Account ID \| \| --- \| --- \| \| Description \| ID of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account ID |
| Description | ID of the account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| accountName** \| \| --- \| \| \\| Display name \\| Account name \\| \\| --- \\| --- \\| \\| Description \\| Name of the account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account name \| \| Description \| Name of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| accountName** |
| \| Display name \| Account name \| \| --- \| --- \| \| Description \| Name of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account name |
| Description | Name of the account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| campaignId** \| \| --- \| \| \\| Display name \\| Campaign ID \\| \\| --- \\| --- \\| \\| Description \\| Unique campaign ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign ID \| \| Description \| Unique campaign ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignId** |
| \| Display name \| Campaign ID \| \| --- \| --- \| \| Description \| Unique campaign ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign ID |
| Description | Unique campaign ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaignName** \| \| --- \| \| \\| Display name \\| Campaign name \\| \\| --- \\| --- \\| \\| Description \\| Advertiser created campaign name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign name \| \| Description \| Advertiser created campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignName** |
| \| Display name \| Campaign name \| \| --- \| --- \| \| Description \| Advertiser created campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign name |
| Description | Advertiser created campaign name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaignStatus** \| \| --- \| \| \\| Display name \\| Campaign status \\| \\| --- \\| --- \\| \\| Description \\| Campaign’s current status represents user action \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign status \| \| Description \| Campaign’s current status represents user action \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignStatus** |
| \| Display name \| Campaign status \| \| --- \| --- \| \| Description \| Campaign’s current status represents user action \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign status |
| Description | Campaign’s current status represents user action |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |
| \| clicks** \| \| --- \| \| \\| Display name \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| The number of times your ads were clicked \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks \| \| Description \| The number of times your ads were clicked \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| clicks** |
| \| Display name \| Clicks \| \| --- \| --- \| \| Description \| The number of times your ads were clicked \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Clicks |
| Description | The number of times your ads were clicked |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |
| \| date** \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Description \\| Date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| date** |
| \| Display name \| Date \| \| --- \| --- \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Date |
| Description | Date, e.g. 2017-01-31 |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| impressions** \| \| --- \| \| \\| Display name \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| The number of times ads were displayed \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions \| \| Description \| The number of times ads were displayed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| impressions** |
| \| Display name \| Impressions \| \| --- \| --- \| \| Description \| The number of times ads were displayed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Impressions |
| Description | The number of times ads were displayed |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| keywordId** \| \| --- \| \| \\| Display name \\| Keyword ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the keyword used in bid \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Keyword ID \| \| Description \| ID of the keyword used in bid \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| keywordId** |
| \| Display name \| Keyword ID \| \| --- \| --- \| \| Description \| ID of the keyword used in bid \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Keyword ID |
| Description | ID of the keyword used in bid |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| keywordText** \| \| --- \| \| \\| Display name \\| Keyword text \\| \\| --- \\| --- \\| \\| Description \\| Text of the keyword or phrase used in bid \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Keyword text \| \| Description \| Text of the keyword or phrase used in bid \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| keywordText** |
| \| Display name \| Keyword text \| \| --- \| --- \| \| Description \| Text of the keyword or phrase used in bid \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Keyword text |
| Description | Text of the keyword or phrase used in bid |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |

### Table: PRODUCT_CAMPAIGN

| \| accountID** \| \| --- \| \| \\| Display name \\| Account ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account ID \| \| Description \| ID of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| accountID** |
| \| Display name \| Account ID \| \| --- \| --- \| \| Description \| ID of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account ID |
| Description | ID of the account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| accountName** \| \| --- \| \| \\| Display name \\| Account name \\| \\| --- \\| --- \\| \\| Description \\| Name of the account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account name \| \| Description \| Name of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| accountName** |
| \| Display name \| Account name \| \| --- \| --- \| \| Description \| Name of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account name |
| Description | Name of the account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| campaignBudget** \| \| --- \| \| \\| Display name \\| Campaign budget \\| \\| --- \\| --- \\| \\| Description \\| The campaign budget \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign budget \| \| Description \| The campaign budget \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignBudget** |
| \| Display name \| Campaign budget \| \| --- \| --- \| \| Description \| The campaign budget \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign budget |
| Description | The campaign budget |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaignBudgetType** \| \| --- \| \| \\| Display name \\| Campaign budget type \\| \\| --- \\| --- \\| \\| Description \\| One of ‘daily’ or ‘lifetime’ \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign budget type \| \| Description \| One of ‘daily’ or ‘lifetime’ \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignBudgetType** |
| \| Display name \| Campaign budget type \| \| --- \| --- \| \| Description \| One of ‘daily’ or ‘lifetime’ \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign budget type |
| Description | One of ‘daily’ or ‘lifetime’ |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaignId** \| \| --- \| \| \\| Display name \\| Campaign ID \\| \\| --- \\| --- \\| \\| Description \\| Unique campaign ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign ID \| \| Description \| Unique campaign ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignId** |
| \| Display name \| Campaign ID \| \| --- \| --- \| \| Description \| Unique campaign ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign ID |
| Description | Unique campaign ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaignName** \| \| --- \| \| \\| Display name \\| Campaign name \\| \\| --- \\| --- \\| \\| Description \\| Advertiser created campaign name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign name \| \| Description \| Advertiser created campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignName** |
| \| Display name \| Campaign name \| \| --- \| --- \| \| Description \| Advertiser created campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign name |
| Description | Advertiser created campaign name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaignStatus** \| \| --- \| \| \\| Display name \\| Campaign status \\| \\| --- \\| --- \\| \\| Description \\| Campaign’s current status represents user action \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign status \| \| Description \| Campaign’s current status represents user action \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignStatus** |
| \| Display name \| Campaign status \| \| --- \| --- \| \| Description \| Campaign’s current status represents user action \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign status |
| Description | Campaign’s current status represents user action |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |
| \| clicks** \| \| --- \| \| \\| Display name \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| The number of times your ads were clicked \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks \| \| Description \| The number of times your ads were clicked \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| clicks** |
| \| Display name \| Clicks \| \| --- \| --- \| \| Description \| The number of times your ads were clicked \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Clicks |
| Description | The number of times your ads were clicked |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |
| \| date** \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Description \\| Date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| date** |
| \| Display name \| Date \| \| --- \| --- \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Date |
| Description | Date, e.g. 2017-01-31 |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| impressions** \| \| --- \| \| \\| Display name \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| The number of times ads were displayed \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions \| \| Description \| The number of times ads were displayed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| impressions** |
| \| Display name \| Impressions \| \| --- \| --- \| \| Description \| The number of times ads were displayed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Impressions |
| Description | The number of times ads were displayed |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |

### Table: PRODUCT_SEARCHTARGET

| \| accountID** \| \| --- \| \| \\| Display name \\| Account ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account ID \| \| Description \| ID of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| accountID** |
| \| Display name \| Account ID \| \| --- \| --- \| \| Description \| ID of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account ID |
| Description | ID of the account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| accountName** \| \| --- \| \| \\| Display name \\| Account name \\| \\| --- \\| --- \\| \\| Description \\| Name of the account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account name \| \| Description \| Name of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| accountName** |
| \| Display name \| Account name \| \| --- \| --- \| \| Description \| Name of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account name |
| Description | Name of the account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| campaignId** \| \| --- \| \| \\| Display name \\| Campaign ID \\| \\| --- \\| --- \\| \\| Description \\| Unique campaign ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign ID \| \| Description \| Unique campaign ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignId** |
| \| Display name \| Campaign ID \| \| --- \| --- \| \| Description \| Unique campaign ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign ID |
| Description | Unique campaign ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaignName** \| \| --- \| \| \\| Display name \\| Campaign name \\| \\| --- \\| --- \\| \\| Description \\| Advertiser created campaign name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign name \| \| Description \| Advertiser created campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignName** |
| \| Display name \| Campaign name \| \| --- \| --- \| \| Description \| Advertiser created campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign name |
| Description | Advertiser created campaign name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaignStatus** \| \| --- \| \| \\| Display name \\| Campaign status \\| \\| --- \\| --- \\| \\| Description \\| Campaign’s current status represents user action \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign status \| \| Description \| Campaign’s current status represents user action \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignStatus** |
| \| Display name \| Campaign status \| \| --- \| --- \| \| Description \| Campaign’s current status represents user action \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign status |
| Description | Campaign’s current status represents user action |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |
| \| clicks** \| \| --- \| \| \\| Display name \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| The number of times your ads were clicked \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks \| \| Description \| The number of times your ads were clicked \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| clicks** |
| \| Display name \| Clicks \| \| --- \| --- \| \| Description \| The number of times your ads were clicked \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Clicks |
| Description | The number of times your ads were clicked |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |
| \| date** \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Description \\| Date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| date** |
| \| Display name \| Date \| \| --- \| --- \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Date |
| Description | Date, e.g. 2017-01-31 |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| impressions** \| \| --- \| \| \\| Display name \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| The number of times ads were displayed \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions \| \| Description \| The number of times ads were displayed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| impressions** |
| \| Display name \| Impressions \| \| --- \| --- \| \| Description \| The number of times ads were displayed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Impressions |
| Description | The number of times ads were displayed |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| targetId** \| \| --- \| \| \\| Display name \\| Target ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the targeting expression used in a bid \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Target ID \| \| Description \| ID of the targeting expression used in a bid \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| targetId** |
| \| Display name \| Target ID \| \| --- \| --- \| \| Description \| ID of the targeting expression used in a bid \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Target ID |
| Description | ID of the targeting expression used in a bid |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| targetingExpression** \| \| --- \| \| \\| Display name \\| Targeting expression \\| \\| --- \\| --- \\| \\| Description \\| A string representation of your expression object in targeting clauses \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Targeting expression \| \| Description \| A string representation of your expression object in targeting clauses \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| targetingExpression** |
| \| Display name \| Targeting expression \| \| --- \| --- \| \| Description \| A string representation of your expression object in targeting clauses \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Targeting expression |
| Description | A string representation of your expression object in targeting clauses |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| Targeting text \| \| Description \| A resolved string representation of your expression object in targeting clauses \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| Display name | Targeting text |
| Description | A resolved string representation of your expression object in targeting clauses |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| targetingType** \| \| --- \| \| \\| Display name \\| Targeting type \\| \\| --- \\| --- \\| \\| Description \\| Campaign targeting type \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Targeting type \| \| Description \| Campaign targeting type \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| targetingType** |
| \| Display name \| Targeting type \| \| --- \| --- \| \| Description \| Campaign targeting type \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Targeting type |
| Description | Campaign targeting type |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### Table: DISPLAY_CAMPAIGN

| \| accountID** \| \| --- \| \| \\| Display name \\| Account ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account ID \| \| Description \| ID of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| accountID** |
| \| Display name \| Account ID \| \| --- \| --- \| \| Description \| ID of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account ID |
| Description | ID of the account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| accountName** \| \| --- \| \| \\| Display name \\| Account name \\| \\| --- \\| --- \\| \\| Description \\| Name of the account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account name \| \| Description \| Name of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| accountName** |
| \| Display name \| Account name \| \| --- \| --- \| \| Description \| Name of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account name |
| Description | Name of the account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| adGroupId** \| \| --- \| \| \\| Display name \\| Ad group ID \\| \\| --- \\| --- \\| \\| Description \\| Unique ad group ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Ad group ID \| \| Description \| Unique ad group ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| adGroupId** |
| \| Display name \| Ad group ID \| \| --- \| --- \| \| Description \| Unique ad group ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Ad group ID |
| Description | Unique ad group ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| adGroupName** \| \| --- \| \| \\| Display name \\| Ad group name \\| \\| --- \\| --- \\| \\| Description \\| Name of the ad group \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Ad group name \| \| Description \| Name of the ad group \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| adGroupName** |
| \| Display name \| Ad group name \| \| --- \| --- \| \| Description \| Name of the ad group \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Ad group name |
| Description | Name of the ad group |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| campaignId** \| \| --- \| \| \\| Display name \\| Campaign ID \\| \\| --- \\| --- \\| \\| Description \\| Unique campaign ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign ID \| \| Description \| Unique campaign ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignId** |
| \| Display name \| Campaign ID \| \| --- \| --- \| \| Description \| Unique campaign ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign ID |
| Description | Unique campaign ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaignName** \| \| --- \| \| \\| Display name \\| Campaign name \\| \\| --- \\| --- \\| \\| Description \\| Advertiser created campaign name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign name \| \| Description \| Advertiser created campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignName** |
| \| Display name \| Campaign name \| \| --- \| --- \| \| Description \| Advertiser created campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign name |
| Description | Advertiser created campaign name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |
| \| clicks** \| \| --- \| \| \\| Display name \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| The number of times your ads were clicked \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks \| \| Description \| The number of times your ads were clicked \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| clicks** |
| \| Display name \| Clicks \| \| --- \| --- \| \| Description \| The number of times your ads were clicked \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Clicks |
| Description | The number of times your ads were clicked |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |
| \| date** \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Description \\| Date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| date** |
| \| Display name \| Date \| \| --- \| --- \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Date |
| Description | Date, e.g. 2017-01-31 |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| impressions** \| \| --- \| \| \\| Display name \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| The number of times ads were displayed \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions \| \| Description \| The number of times ads were displayed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| impressions** |
| \| Display name \| Impressions \| \| --- \| --- \| \| Description \| The number of times ads were displayed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Impressions |
| Description | The number of times ads were displayed |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| targetId** \| \| --- \| \| \\| Display name \\| Target ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the targeting expression used in a bid \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Target ID \| \| Description \| ID of the targeting expression used in a bid \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| targetId** |
| \| Display name \| Target ID \| \| --- \| --- \| \| Description \| ID of the targeting expression used in a bid \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Target ID |
| Description | ID of the targeting expression used in a bid |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| targetingExpression** \| \| --- \| \| \\| Display name \\| Targeting expression \\| \\| --- \\| --- \\| \\| Description \\| A string representation of your expression object in targeting clauses \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Targeting expression \| \| Description \| A string representation of your expression object in targeting clauses \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| targetingExpression** |
| \| Display name \| Targeting expression \| \| --- \| --- \| \| Description \| A string representation of your expression object in targeting clauses \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Targeting expression |
| Description | A string representation of your expression object in targeting clauses |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| Targeting text \| \| Description \| A resolved string representation of your expression object in targeting clauses \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| Display name | Targeting text |
| Description | A resolved string representation of your expression object in targeting clauses |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| targetingType** \| \| --- \| \| \\| Display name \\| Targeting type \\| \\| --- \\| --- \\| \\| Description \\| Campaign targeting type \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Targeting type \| \| Description \| Campaign targeting type \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| targetingType** |
| \| Display name \| Targeting type \| \| --- \| --- \| \| Description \| Campaign targeting type \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Targeting type |
| Description | Campaign targeting type |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |

### Table: DISPLAY_PRODUCT

| \| accountID** \| \| --- \| \| \\| Display name \\| Account ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account ID \| \| Description \| ID of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| accountID** |
| \| Display name \| Account ID \| \| --- \| --- \| \| Description \| ID of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account ID |
| Description | ID of the account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| accountName** \| \| --- \| \| \\| Display name \\| Account name \\| \\| --- \\| --- \\| \\| Description \\| Name of the account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account name \| \| Description \| Name of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| accountName** |
| \| Display name \| Account name \| \| --- \| --- \| \| Description \| Name of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account name |
| Description | Name of the account |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| adGroupId** \| \| --- \| \| \\| Display name \\| Ad group ID \\| \\| --- \\| --- \\| \\| Description \\| Unique ad group ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Ad group ID \| \| Description \| Unique ad group ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| adGroupId** |
| \| Display name \| Ad group ID \| \| --- \| --- \| \| Description \| Unique ad group ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Ad group ID |
| Description | Unique ad group ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| adGroupName** \| \| --- \| \| \\| Display name \\| Ad group name \\| \\| --- \\| --- \\| \\| Description \\| Name of the ad group \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Ad group name \| \| Description \| Name of the ad group \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| adGroupName** |
| \| Display name \| Ad group name \| \| --- \| --- \| \| Description \| Name of the ad group \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Ad group name |
| Description | Name of the ad group |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| asin** \| \| --- \| \| \\| Display name \\| ASIN \\| \\| --- \\| --- \\| \\| Description \\| The unique Amazon Standard Identification Number (ASIN) advertised \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| ASIN \| \| Description \| The unique Amazon Standard Identification Number (ASIN) advertised \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| asin** |
| \| Display name \| ASIN \| \| --- \| --- \| \| Description \| The unique Amazon Standard Identification Number (ASIN) advertised \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | ASIN |
| Description | The unique Amazon Standard Identification Number (ASIN) advertised |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| campaignId** \| \| --- \| \| \\| Display name \\| Campaign ID \\| \\| --- \\| --- \\| \\| Description \\| Unique campaign ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign ID \| \| Description \| Unique campaign ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignId** |
| \| Display name \| Campaign ID \| \| --- \| --- \| \| Description \| Unique campaign ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign ID |
| Description | Unique campaign ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaignName** \| \| --- \| \| \\| Display name \\| Campaign name \\| \\| --- \\| --- \\| \\| Description \\| Advertiser created campaign name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign name \| \| Description \| Advertiser created campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaignName** |
| \| Display name \| Campaign name \| \| --- \| --- \| \| Description \| Advertiser created campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign name |
| Description | Advertiser created campaign name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| clicks** \| \| --- \| \| \\| Display name \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| The number of times your ads were clicked \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks \| \| Description \| The number of times your ads were clicked \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| clicks** |
| \| Display name \| Clicks \| \| --- \| --- \| \| Description \| The number of times your ads were clicked \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Clicks |
| Description | The number of times your ads were clicked |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |
| \| date** \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Description \\| Date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| date** |
| \| Display name \| Date \| \| --- \| --- \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Date |
| Description | Date, e.g. 2017-01-31 |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| impressions** \| \| --- \| \| \\| Display name \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| The number of times ads were displayed \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions \| \| Description \| The number of times ads were displayed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| impressions** |
| \| Display name \| Impressions \| \| --- \| --- \| \| Description \| The number of times ads were displayed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Impressions |
| Description | The number of times ads were displayed |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| sku** \| \| --- \| \| \\| Display name \\| Advertised SKU \\| \\| --- \\| --- \\| \\| Description \\| The SKU that is being advertised. Not available for vendors \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Advertised SKU \| \| Description \| The SKU that is being advertised. Not available for vendors \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| sku** |
| \| Display name \| Advertised SKU \| \| --- \| --- \| \| Description \| The SKU that is being advertised. Not available for vendors \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Advertised SKU |
| Description | The SKU that is being advertised. Not available for vendors |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |
| \| 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](/apidocs/field-data-types#currency) \\| \| \| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) \| |
| 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](/apidocs/field-data-types#currency) |

### Table: DISPLAY_ASINS

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