Amazon Vendor Central metrics and dimensions

Early Access7 metrics39 dimensions

Search fields

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

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

PRODUCT

asin

Field label	ASIN
Description	ASIN, or Amazon Standard Identification Number, is the main Amazon identifier of a product and its product detail page
Field type	dimension
Data type	string.text.value

product_title

Field label	Product title
Description	The name of the product displayed on the product detail page
Field type	dimension
Data type	string.text.value

brand_code

Field label	Brand code
Description	The identifier code of the brand
Field type	dimension
Data type	string.text.value

brand

Field label	Brand
Description	The brand name of the product
Field type	dimension
Data type	string.text.value

category

Field label	Category
Description	The product category and its identifier number within this product family
Field type	dimension
Data type	string.text.value

subcategory

Field label	Subcategory
Description	The product subcategory and its identifier number within this product category
Field type	dimension
Data type	string.text.value

parent_asin

Field label	Parent ASIN
Description	The variation parent, an internal-only identifier to bind a variation family together
Field type	dimension
Data type	string.text.value

upc

Field label	UPC
Description	UPC is a barcode identifier standard of each individual product
Field type	dimension
Data type	string.text.value

ean

Field label	EAN
Description	EAN is a barcode identifier standard of each individual product
Field type	dimension
Data type	string.text.value

isbn

Field label	ISBN
Description	ISBN-13 is a barcode identifier standard limited to Books products
Field type	dimension
Data type	string.text.value

model_number

Field label	Model number
Description	The model number of the product, assigned by the manufacturer. Note that this is distinct from other catalogue fields such as 'Model Name' and 'Manufacturer Part Number'
Field type	dimension
Data type	string.text.value

manufacturer_code

Field label	Manufacturer code
Description	The code used to identify the manufacturer, an entity who makes the products that are sold on Amazon
Field type	dimension
Data type	string.text.value

colour

Field label	Colour
Description	The colour of the item, if the attribute is relevant and filled out for that product
Field type	dimension
Data type	string.text.value

release_date

Field label	Release date
Description	The day that an item is available for purchase by the public
Field type	dimension
Data type	string.time.date

release_datetime

Field label	Release datetime
Description	The day and time that an item is available for purchase by the public
Field type	dimension
Data type	string.time.datetime

replenishment_code

Field label	Replenishment code
Description	Code indicating product replenishment status: BR (basic replenishment), NP (new product), PR (planned/automatic replenishment), LR (limited replenishment), NS (non-stockupable/dropship), OS (manufacturer out of stock), NR (non-replenishable), OB (obsolete)
Field type	dimension
Data type	string.text.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

system_metadata.query_excluded_accounts

Field label	Excluded invalid accounts
Description	A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting
Field type	dimension
Data type	string.text.json

SALES

ordered_revenue

Field label	Ordered revenue
Description	The total revenue generated by customer orders within the selected filters and timeframes, with adjustments made for prior sales, like returns/cancellations. Ordered Revenue = Price * Ordered Units
Field type	metric
Data type	float.currency.value

ordered_units

Field label	Ordered units
Description	The total number of ordered units generated by customer orders, with adjustments made for prior sales, like returns/cancellations
Field type	metric
Data type	int.number.value

shipped_revenue

Field label	Shipped revenue
Description	The total revenue generated by customer orders at the time of shipment. Shipped Revenue = Price * Shipped Units
Field type	metric
Data type	float.currency.value

shipped_cogs

Field label	Shipped COGS
Description	The total cost of goods sold
Field type	metric
Data type	float.currency.value

shipped_units

Field label	Shipped units
Description	The quantity of units shipped to customers
Field type	metric
Data type	int.number.value

customer_returns

Field label	Customer returns
Description	The number of units returned by customers
Field type	metric
Data type	int.number.value

SELLER

seller_id

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

account_name

Field label	Account name
Description	Amazon account name
Field type	dimension
Data type	string.text.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
Description	Report data aggregated by year. Your date range must align to complete year boundaries (January 1st to December 31st) and span at most 2 years
Field type	dimension
Data type	string.time.year

year_of_week

Field label	Year of week (Sun-Sat)
Description	The year of the week (Sunday to Saturday) the data belongs to. Use with Week (Sun-Sat) to uniquely identify a week across years
Field type	dimension
Data type	string.time.year

year_month

Field label	Year & month
Description	Year and month the data belongs to, in YYYY-MM format
Field type	dimension
Data type	string.time.yearmonth

month

Field label	Month
Description	Report data aggregated by month. Your date range must align to complete month boundaries (1st to last day of a month) and span at most 15 months
Field type	dimension
Data type	string.time.month

year_week

Field label	Year & week (Sun-Sat)
Description	Year and week number (Sunday to Saturday) the data belongs to, in YYYY-WW format
Field type	dimension
Data type	string.time.yearweek

week

Field label	Week (Sun-Sat)
Description	Report data aggregated by week (Sunday to Saturday). Your date range must start on a Sunday and end on a Saturday, span at most 7 weeks, and fall within the last 7 weeks. Note: weekly data is available from the end of Monday following the close of each week (48-hour SLA)
Field type	dimension
Data type	string.time.week

TRAFFIC

featured_offer_page_views

Field label	Featured offer page views
Description	The number of views the product detail page for this ASIN receives from our customers on the website (if Retail is the featured merchant) during the specified time frame
Field type	metric
Data type	int.number.value