Amazon Seller Central fields

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

Supermetrics brings all your Amazon Seller Central data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

49 metrics58 dimensions

DATASOURCE

dataSourceName
Field label 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
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

FEEDBACK

feedback_received
Field label Feedback received
Description Total number of feedback ratings received
Field type metric
Data type int.number.value
negative_feedback_received
Field label Negative feedback received
Description Total number of negative feedback ratings received
Field type metric
Data type int.number.value
received_negative_feedback_rate
Field label Received negative feedback rate
Description Percentage of feedback ratings that were negative, calculated by dividing negativeFeedbackReceived by feedbackReceived
Field type metric
Data type float.number.ratio

MARKETPLACE

marketplace_id
Field label Marketplace ID
Description Amazon marketplace identifier
Field type dimension
Data type string.text.value
marketplace_name
Field label Marketplace name
Description Amazon marketplace name
Field type dimension
Data type string.text.value

ORDER

amazon_order_id
Field label Amazon order ID
Description Unique identifier for the order assigned by Amazon
Field type dimension
Data type string.text.value
merchant_order_id
Field label Merchant order ID
Description Merchant-defined identifier for the order
Field type dimension
Data type string.text.value
purchase_date
Field label Purchase date
Description Date the order was placed
Field type dimension
Data type string.time.date
purchase_datetime
Field label Purchase datetime
Description Date and time the order was placed
Field type dimension
Data type string.time.datetime
last_updated_date
Field label Last updated date
Description Date the order was last updated
Field type dimension
Data type string.time.date
last_updated_datetime
Field label Last updated datetime
Description Date and time the order was last updated
Field type dimension
Data type string.time.datetime
order_status
Field label Order status
Description Current status of the order (e.g., New, Pending, Shipped, Delivered, Closed)
Field type dimension
Data type string.text.value
order_channel
Field label Order channel
Description Channel through which the order was initiated (e.g., website, mobile app, third-party marketplace)
Field type dimension
Data type string.text.value
sales_channel
Field label Sales channel
Description Channel through which the order was placed (e.g., Amazon.com, Amazon App, Amazon Marketplace)
Field type dimension
Data type string.text.value

PRODUCT

product_name
Field label Product name
Description Title of the product being ordered
Field type dimension
Data type string.text.value
parent_asin
Field label (Parent) ASIN
Description Identifiers (ASINs) of the related items that are parents of this item
Field type dimension
Data type string.text.value
child_asin
Field label (Child) ASIN
Description Identifiers (ASINs) of the related items that are children of this item
Field type dimension
Data type string.text.value
sku
Field label SKU
Description Stock Keeping Unit, a seller-specified identifier for an Amazon listing
Field type dimension
Data type string.text.value
asin
Field label ASIN
Field type dimension
Data type string.text.value
brand
Field label Brand
Description Name of the brand associated with an Amazon catalog item
Field type dimension
Data type string.text.value
title
Field label Title
Description Name, or title, associated with an Amazon catalog item
Field type dimension
Data type string.text.value
item_status
Field label Item status
Description Status of the individual items in the order (e.g., Ordered, In Stock, Shipped, Delivered, Canceled)
Field type dimension
Data type string.text.value
currency
Field label Currency
Description Currency in which the order was placed
Field type dimension
Data type string.currency.code
promotion_ids
Field label Promotion IDs
Description IDs of any promotions applied to the order
Field type dimension
Data type string.text.value
is_business_order
Field label Is business order
Description Indicates whether the order is a business order
Field type dimension
Data type bool
purchase_order_number
Field label Purchase order number
Description Purchase order number associated with the order, if applicable
Field type dimension
Data type string.text.value
price_designation
Field label Price designation
Description Indicates the method used to determine the price of the order (e.g., Standard Price, Configurable Price)
Field type dimension
Data type string.text.value
signature_confirmation_recommended
Field label Signature confirmation recommended
Description Indicates whether signature confirmation is recommended for the shipping address
Field type dimension
Data type bool
item_quantity
Field label Item quantity
Description The quantity of the item ordered
Field type metric
Data type int.number.value
item_price
Field label Item price
Description Price of each individual item
Field type metric
Data type float.currency.value
item_tax
Field label Item tax
Description Sales tax applicable to each item
Field type metric
Data type float.currency.value
gift_wrap_price
Field label Gift wrap price
Description Cost of any gift wrapping selected by the customer
Field type metric
Data type float.currency.value
gift_wrap_tax
Field label Gift wrap tax
Description Sales tax applicable to the gift wrapping cost
Field type metric
Data type float.currency.value
item_promotion_discount
Field label Item promotion discount
Description Discount applied to the total price of the items
Field type metric
Data type float.currency.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

REFUNDS

units_refunded
Field label Units refunded
Description Total number of units refunded
Field type metric
Data type int.number.value
refund_rate
Field label Refund rate
Description Percentage of units refunded, calculated by dividing unitsRefunded by unitsOrdered
Field type metric
Data type float.number.ratio
claims_granted
Field label A-to-z claims granted
Description Total number of claims granted
Field type metric
Data type int.number.value
claims_amount
Field label Claims amount
Description Total amount of money paid out in claims
Field type metric
Data type float.currency.value

SALES

ordered_product_sales
Field label Ordered product sales
Description Total revenue from products ordered, excluding taxes and shipping costs
Field type metric
Data type float.currency.value
ordered_product_sales_b2b
Field label Ordered product sales - B2B
Description Total revenue from products ordered by business-to-business B2B customers, excluding taxes and shipping costs
Field type metric
Data type float.currency.value
units_ordered
Field label Units ordered
Description Total number of units ordered, regardless of whether they were fulfilled or refunded
Field type metric
Data type int.number.value
units_ordered_b2b
Field label Units ordered - B2B
Description Total number of units ordered by B2B customers
Field type metric
Data type int.number.value
total_order_items
Field label Total order items
Description Total number of items ordered, including multiple quantities of the same product
Field type metric
Data type int.number.value
total_order_items_b2b
Field label Total order items - B2B
Description Total number of items ordered by B2B customers
Field type metric
Data type int.number.value
average_units_per_order_item
Field label Average units per order item
Description Average number of units per order item, calculated by dividing unitsOrdered by totalOrderItems
Field type metric
Data type float.number.ratio
average_units_per_order_item_b2b
Field label Average units per order item - B2B
Description Average number of units per order item for B2B orders, calculated by dividing unitsOrderedB2B by totalOrderItemsB2B
Field type metric
Data type float.number.ratio
average_selling_price
Field label Average selling price
Description Average selling price per unit, calculated by dividing orderedProductSales by unitsOrdered
Field type metric
Data type float.currency.value
average_selling_price_b2b
Field label Average selling price - B2B
Description Average selling price per unit for B2B orders, calculated by dividing orderedProductSalesB2B by unitsOrderedB2B
Field type metric
Data type float.currency.value
average_offer_count
Field label Average offer count
Description The average number of offers listed for sale created on the particular day
Field type metric
Data type float.number.value
average_parent_items
Field label Average parent items
Description The average number of parent items listed for sale created on the particular day
Field type metric
Data type float.number.value

SELLER

seller_id
Field label Seller ID
Description Amazon seller ID, it is unique to a given seller
Field type dimension
Data type string.text.value

SHIPPING

fulfillment_channel
Field label Fulfillment channel
Description Channel through which the order will be fulfilled (e.g., Seller Fulfilled Prime, Amazon Fulfilled)
Field type dimension
Data type string.text.value
ship_service_level
Field label Ship service level
Description Shipping service level chosen by the customer
Field type dimension
Data type string.text.value
ship_city
Field label Ship city
Description City where the order should be shipped
Field type dimension
Data type string.geo.city
ship_state
Field label Ship state
Description State or province where the order should be shipped
Field type dimension
Data type string.geo.region
ship_postal_code
Field label Ship postal code
Description Postal code where the order should be shipped
Field type dimension
Data type string.geo.zip
ship_country
Field label Ship country
Description Country where the order should be shipped
Field type dimension
Data type string.geo.country
shipped_product_sales
Field label Shipped product sales
Description Total revenue from products shipped, excluding taxes and shipping costs
Field type metric
Data type float.currency.value
units_shipped
Field label Units shipped
Description Total number of units shipped
Field type metric
Data type int.number.value
orders_shipped
Field label Orders shipped
Description Total number of orders shipped
Field type metric
Data type int.number.value
shipping_price
Field label Shipping price
Description Total shipping cost for the order
Field type metric
Data type float.currency.value
shipping_tax
Field label Shipping tax
Description Sales tax applicable to the shipping cost
Field type metric
Data type float.currency.value
ship_promotion_discount
Field label Ship promotion discount
Description Discount applied to the shipping cost
Field type metric
Data type float.currency.value

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
year
Field label Year
Field type dimension
Data type string.time.year
year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Field type dimension
Data type string.time.month
year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Field type dimension
Data type string.time.date
atom
Field label Datetime
Field type dimension
Data type string.time.datetime

TRAFFIC

mobile_app_page_views
Field label Page views - mobile app
Description Number of page views from mobile apps
Field type metric
Data type int.number.value
mobile_app_page_views_b2b
Field label Page views - mobile app - B2B
Description Number of page views from mobile apps for B2B customers
Field type metric
Data type int.number.value
browser_page_views
Field label Page views - browser
Description Number of page views from desktop browsers
Field type metric
Data type int.number.value
browser_page_views_b2b
Field label Page views - browser - B2B
Description Number of page views from desktop browsers for B2B customers
Field type metric
Data type int.number.value
page_views
Field label Page views - total
Description Total number of page views
Field type metric
Data type int.number.value
page_views_b2b
Field label Page views - total - B2B
Description Total number of page views for B2B customers
Field type metric
Data type int.number.value
mobile_app_sessions
Field label Sessions - mobile app
Description Number of sessions from mobile apps
Field type metric
Data type int.number.value
mobile_app_sessions_b2b
Field label Sessions - mobile app - B2B
Description Number of sessions from mobile apps for B2B customers
Field type metric
Data type int.number.value
browser_sessions
Field label Sessions - browser
Description Number of sessions from desktop browsers
Field type metric
Data type int.number.value
browser_sessions_b2b
Field label Sessions - browser - B2B
Description Number of sessions from desktop browsers for B2B customers
Field type metric
Data type int.number.value
sessions
Field label Sessions - total
Description Total number of sessions
Field type metric
Data type int.number.value
sessions_b2b
Field label Sessions - total - B2B
Description Total number of sessions for B2B customers
Field type metric
Data type int.number.value
unit_session_percentage
Field label Unit session percentage
Description Percentage of sessions that resulted in a unit sale
Field type metric
Data type float.number.percentage
unit_session_percentage_b2b
Field label Unit session percentage - B2B
Description Percentage of sessions that resulted in a unit sale for B2B customers
Field type metric
Data type float.number.percentage
order_item_session_percentage
Field label Order item session percentage
Description Percentage of sessions that resulted in an order
Field type metric
Data type float.number.percentage
order_item_session_percentage_b2b
Field label Order item session percentage - B2B
Description Percentage of sessions that resulted in an order for B2B customers
Field type metric
Data type float.number.percentage
buy_box_percentage
Field label Featured offer (buy box) percentage
Description Percentage of time your products were displayed in the Buy Box
Field type metric
Data type float.number.percentage
buy_box_percentage_b2b
Field label Featured offer (buy box) percentage - B2B
Description Percentage of time your products were displayed in the Buy Box for B2B customers
Field type metric
Data type float.number.percentage