Centra fields

  • Updated on Sep 11, 2025
  • Published on Sep 8, 2025
Prev Next

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

Early Access9 metrics48 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

ORDER

order_id
Field label Order ID
Description The order's ID
Field type dimension
Data type string.text.value
order_market
Field label Order market
Description The order's market
Field type dimension
Data type string.text.value
order_status
Field label Order status
Description The order's status
Field type dimension
Data type string.text.value

PRODUCT

product_name
Field label Product name
Description Name of the product
Field type dimension
Data type string.text.value
product_ean
Field label Product EAN
Description European Article Number / GTIN-13, standardized unique identifier of the product
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

RETURN

return_status
Field label Return status
Description The return's status
Field type dimension
Data type string.text.value
return_shipment_id
Field label Return shipment ID
Description The return's shipment ID
Field type dimension
Data type string.text.value
items_returned
Field label Items returned
Description The quantity of returned items
Field type metric
Data type int.number.value
item_total_returned
Field label Item total returned
Description Line items total returned in base currency
Field type metric
Data type float.currency.value
item_total_returned_ex_tax
Field label Item total returned (excluding tax)
Description Line item total returned excluding tax in base currency
Field type metric
Data type float.currency.value

SALES

item_quantity
Field label Item quantity
Description The current quantity for the order line, excluding cancelled units
Field type metric
Data type int.number.value
item_price
Field label Item price
Description Line items unit price in base currency. This field is only available when line item level dimensions are applied
Field type metric
Data type float.currency.value
Aggregation Non-aggregatable metric
item_original_price
Field label Item original price
Description Original unit price of the product, in base currency. This field is only available when line item level dimensions are applied
Field type metric
Data type float.currency.value
Aggregation Non-aggregatable metric
item_original_price_ex_tax
Field label Item original price (excluding tax)
Description Original unit price of the product, in base currency excluding tax. This field is only available when line item level dimensions are applied
Field type metric
Data type float.currency.value
Aggregation Non-aggregatable metric
item_subtotal
Field label Item subtotal
Description Line items total in base currency
Field type metric
Data type float.currency.value
item_subtotal_ex_tax
Field label Item subtotal (excluding tax)
Description Line item total excluding tax in base currency
Field type metric
Data type float.currency.value

SHIPPING

shipping_country_name
Field label Shipping country name
Description Name of the country where order is shipped to
Field type dimension
Data type string.geo.country
shipping_country_code
Field label Shipping country code
Description Country code of the country where order is shipped to
Field type dimension
Data type string.geo.country.twolettercode

STORE

store_name
Field label Store name
Description The store's name
Field type dimension
Data type string.text.value
store_id
Field label Store ID
Description The store's ID
Field type dimension
Data type string.text.value
store_type
Field label Store type
Description The store's type. Direct to consumer or wholesale
Field type dimension
Data type string.text.value
store_url
Field label Store URL
Description The store's URL
Field type dimension
Data type string.text.url
store_currency
Field label Store currency
Description The base currency code of the store
Field type dimension
Data type string.currency.code

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

TIMESTAMP

order_created_date
Field label Order created date
Description Date when the order was created
Field type dimension
Data type string.time.date
order_created_datetime
Field label Order created datetime
Description Date & time when the order was created
Field type dimension
Data type string.time.datetime
order_updated_date
Field label Order updated date
Description Date when the order was updated
Field type dimension
Data type string.time.date
order_updated_datetime
Field label Order updated datetime
Description Date & time when the order was updated
Field type dimension
Data type string.time.datetime
payment_capture_date
Field label Payment capture date
Description Date when the order payment was captured
Field type dimension
Data type string.time.date
payment_capture_datetime
Field label Payment capture datetime
Description Date & time when the order payment was captured
Field type dimension
Data type string.time.datetime
order_return_date
Field label Order return date
Description Date when a return for the order was created
Field type dimension
Data type string.time.date
order_return_datetime
Field label Order return datetime
Description Date & time when a return for the order was created
Field type dimension
Data type string.time.datetime