Adobe Commerce (Magento 2) fields

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

Supermetrics brings all your Adobe Commerce (Magento 2) data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

25 metrics93 dimensions

BILLING

billing_first_name
Field label Billing first name
Description The first name of the billing customer
Field type dimension
Data type string.text.value
billing_middle_name
Field label Billing middle name
Description The middle name of the billing customer
Field type dimension
Data type string.text.value
billing_last_name
Field label Billing last name
Description The last name of the billing customer
Field type dimension
Data type string.text.value
billing_company
Field label Billing company
Description The company name of the billing customer
Field type dimension
Data type string.text.value
billing_address_type
Field label Billing address type
Description The type of address associated with the billing customer
Field type dimension
Data type string.text.value
billing_street
Field label Billing street
Description The street address of the billing customer
Field type dimension
Data type string.geo.street
billing_city
Field label Billing city
Description The city of the billing address
Field type dimension
Data type string.geo.city
billing_region
Field label Billing region
Description The region or state of the billing address
Field type dimension
Data type string.geo.region
billing_region_id
Field label Billing region ID
Description The unique identifier for the region of the billing address
Field type dimension
Data type string.geo.region
billing_region_code
Field label Billing region code
Description The code representing the region of the billing address
Field type dimension
Data type string.geo.region
billing_postal_code
Field label Billing postal code
Description The postal code of the billing address
Field type dimension
Data type string.text.value
billing_country_id
Field label Billing country ID
Description The unique identifier for the country of the billing address
Field type dimension
Data type string.geo.country.twolettercode
billing_email
Field label Billing email
Description The email address of the billing customer
Field type dimension
Data type string.text.email
billing_telephone
Field label Billing telephone
Description The telephone number of the billing customer
Field type dimension
Data type string.text.phone
billing_fax
Field label Billing fax
Description The fax number of the billing customer
Field type dimension
Data type string.text.value

CUSTOMER

customer_id
Field label Customer ID
Description The unique identifier of the customer
Field type dimension
Data type string.text.value
customer_group_id
Field label Customer group ID
Description The unique identifier of the customer group
Field type dimension
Data type string.text.value
customer_prefix
Field label Customer prefix
Description The prefix for the customer's name (e.g., Mr., Ms.)
Field type dimension
Data type string.text.value
customer_first_name
Field label Customer first name
Description The first name of the customer
Field type dimension
Data type string.text.value
customer_middle_name
Field label Customer middle name
Description The middle name of the customer
Field type dimension
Data type string.text.value
customer_last_name
Field label Customer last name
Description The last name of the customer
Field type dimension
Data type string.text.value
customer_name_suffix
Field label Customer name suffix
Description The suffix for the customer's name (e.g., Jr., Sr., III)
Field type dimension
Data type string.text.value
customer_gender
Field label Customer gender
Description The gender of the customer
Field type dimension
Data type string.person.gender
customer_dob
Field label Customer date of birth
Description The date of birth of the customer
Field type dimension
Data type string.time.date
customer_email
Field label Customer email
Description The email address of the customer
Field type dimension
Data type string.text.email
customer_is_guest
Field label Customer is guest
Description Indicates whether the customer is a guest or a registered customer
Field type dimension
Data type string.text.value
customer_tax_vat_number
Field label Customer tax/VAT number
Description The tax or VAT number of the customer
Field type dimension
Data type string.text.value
customer_created_in
Field label Customer created in
Description The store in which the customer was created
Field type dimension
Data type string.text.value
customer_created_date
Field label Customer created date
Description The date the customer was created
Field type dimension
Data type string.time.date
customer_created_datetime
Field label Customer created datetime
Description The date and time the customer was created
Field type dimension
Data type string.time.datetime
customer_updated_date
Field label Customer updated date
Description The date the customer was last updated
Field type dimension
Data type string.time.date
customer_updated_datetime
Field label Customer updated datetime
Description The date and time the customer was last updated
Field type dimension
Data type string.time.datetime
customers
Field label Customers
Description The number of customers
Field type metric
Data type int.number.value

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

ITEM

product_name
Field label Product name
Description The name of the product
Field type dimension
Data type string.text.value
product_type
Field label Product type
Description The type or category of the product (e.g., simple, configurable, virtual)
Field type dimension
Data type string.text.value
product_id
Field label Product ID
Description A unique identifier for each product
Field type dimension
Data type string.text.value
item_order_id
Field label Item order ID
Description The unique identifier of the order associated with the ordered item
Field type dimension
Data type string.text.value
item_id
Field label Item ID
Description A unique identifier for each item in the order
Field type dimension
Data type string.text.value
item_sku
Field label Item SKU
Description The Stock Keeping Unit (SKU) associated with the product in the item
Field type dimension
Data type string.text.value
item_created_date
Field label Item created date
Description The date when the item was created
Field type dimension
Data type string.time.date
item_created_datetime
Field label Item created datetime
Description The date and time when the item was created
Field type dimension
Data type string.time.datetime
item_updated_date
Field label Item updated date
Description The date when the item was last updated
Field type dimension
Data type string.time.date
item_updated_datetime
Field label Item updated datetime
Description The date and time when the item was last updated
Field type dimension
Data type string.time.datetime
item_original_price
Field label Item original price
Description The original price of the item before any discounts or adjustments
Field type metric
Data type float.currency.value
item_price
Field label Item price
Description The final price of the item after any discounts or adjustments
Field type metric
Data type float.currency.value
item_quantity_ordered
Field label Item quantity ordered
Description The total quantity of the item ordered
Field type metric
Data type int.number.value
item_quantity_invoiced
Field label Item quantity invoiced
Description The quantity of the item that has been invoiced
Field type metric
Data type int.number.value
item_quantity_shipped
Field label Item quantity shipped
Description The quantity of the item that has been shipped
Field type metric
Data type int.number.value
item_quantity_refunded
Field label Item quantity refunded
Description The quantity of the item that has been refunded
Field type metric
Data type int.number.value
item_quantity_returned
Field label Item quantity returned
Description The quantity of the item that has been returned
Field type metric
Data type int.number.value
item_quantity_canceled
Field label Item quantity canceled
Description The quantity of the item that has been canceled
Field type metric
Data type int.number.value
item_subtotal
Field label Item subtotal
Description The subtotal amount for the item before tax and discounts
Field type metric
Data type float.currency.value
item_tax_amount
Field label Item tax amount
Description The tax amount applied to the item
Field type metric
Data type float.currency.value
item_tax_percent
Field label Item tax percent
Description The tax percentage rate applied to the item
Field type metric
Data type float.number.percentage
item_discount_amount
Field label Item discount amount
Description The discount amount applied to the item
Field type metric
Data type float.currency.value
item_total
Field label Item total
Description The total amount for the item after all adjustments
Field type metric
Data type float.currency.value
item_refund_amount
Field label Item refund amount
Description The amount refunded for the item
Field type metric
Data type float.currency.value

ORDER

order_increment_id
Field label Order increment ID
Description The incrementing identifier for each order
Field type dimension
Data type string.text.value
order_status
Field label Order status
Description The current status of the order (e.g., pending, processing, completed)
Field type dimension
Data type string.text.value
order_currency
Field label Order currency
Description The currency used for the order transaction
Field type dimension
Data type string.currency.code
order_created_date
Field label Order created date
Description The date when the order was created
Field type dimension
Data type string.time.date
order_created_datetime
Field label Order created datetime
Description The date and time when the order was created
Field type dimension
Data type string.time.datetime
order_updated_date
Field label Order updated date
Description The date when the order was last updated
Field type dimension
Data type string.time.date
order_updated_datetime
Field label Order updated datetime
Description The date and time when the order was last updated
Field type dimension
Data type string.time.datetime
orders
Field label Orders
Description The total number of orders placed
Field type metric
Data type int.number.value
order_quantity
Field label Order quantity
Description The total quantity of items in the order
Field type metric
Data type int.number.value
order_subtotal
Field label Order subtotal
Description The subtotal amount for the order before tax and discounts
Field type metric
Data type float.currency.value
order_discount
Field label Order discount
Description The total discount amount applied to the order
Field type metric
Data type float.currency.value
order_tax
Field label Order tax
Description The total tax amount applied to the order
Field type metric
Data type float.currency.value
order_shipping_and_handling
Field label Order shipping & handling
Description The total shipping and handling charges for the order
Field type metric
Data type float.currency.value
order_grand_total
Field label Order grand total
Description The grand total amount for the order after all adjustments
Field type metric
Data type float.currency.value
order_total_paid
Field label Order total paid
Description The total amount paid for the order
Field type metric
Data type float.currency.value
order_total_refunded
Field label Order total refunded
Description The total amount refunded for the order
Field type metric
Data type float.currency.value
order_total_due
Field label Order total due
Description The total amount due for the order
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

SHIPPING

shipping_first_name
Field label Shipping first name
Description The first name of the shipping customer
Field type dimension
Data type string.text.value
shipping_middle_name
Field label Shipping middle name
Description The middle name of the shipping customer
Field type dimension
Data type string.text.value
shipping_last_name
Field label Shipping last name
Description The last name of the shipping customer
Field type dimension
Data type string.text.value
shipping_company
Field label Shipping company
Description The company name of the shipping customer
Field type dimension
Data type string.text.value
shipping_address_type
Field label Shipping address type
Description The type of address associated with the shipping customer
Field type dimension
Data type string.text.value
shipping_street
Field label Shipping street
Description The street address of the shipping customer
Field type dimension
Data type string.geo.street
shipping_city
Field label Shipping city
Description The city of the shipping address
Field type dimension
Data type string.geo.city
shipping_region
Field label Shipping region
Description The region or state of the shipping address
Field type dimension
Data type string.geo.region
shipping_region_id
Field label Shipping region ID
Description The unique identifier for the region of the shipping address
Field type dimension
Data type string.geo.region
shipping_region_code
Field label Shipping region code
Description The code representing the region of the shipping address
Field type dimension
Data type string.geo.region
shipping_postal_code
Field label Shipping postal code
Description The postal code of the shipping address
Field type dimension
Data type string.text.value
shipping_country_id
Field label Shipping country ID
Description The unique identifier for the country of the shipping address
Field type dimension
Data type string.geo.country.twolettercode
shipping_email
Field label Shipping email
Description The email address of the shipping customer
Field type dimension
Data type string.text.email
shipping_telephone
Field label Shipping telephone
Description The telephone number of the shipping customer
Field type dimension
Data type string.text.phone
shipping_fax
Field label Shipping fax
Description The fax number of the shipping customer
Field type dimension
Data type string.text.value

STORE

store_domain
Field label Store domain
Description The domain associated with the store from which the order was placed
Field type dimension
Data type string.text.url
store_id
Field label Store ID
Description A unique identifier for the store within the Magento system
Field type dimension
Data type string.text.value
store_name
Field label Store name
Description The name of the store from which the order was placed
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
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