> ## Documentation Index > Fetch the complete documentation index at: https://support.detrics.io/llms.txt > Use this file to discover all available pages before exploring further. # Magento Metrics & Dimensions > Complete reference for Magento dimensions and metrics **Last updated:** August 6, 2026
68 dimensions
31 metrics
This reference covers all available dimensions and metrics for Magento data through Detrics. Use this guide to understand what data you can extract and how to structure your queries.
Supported destinations:
Google Sheets
Claude
BigQuery
## Dimensions Dimensions are the attributes you can use to segment and group your Magento data. ### Order | | | | ---------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------- | |
Order Increment ID
| Human-readable incrementing identifier for each order

**Field Name:** `orderIncrementId`
**Type:** dimension | |
Order Status
| Current status of the order (e.g., pending, processing, complete, canceled, closed)

**Field Name:** `orderStatus`
**Type:** dimension | |
Order State
| High-level state of the order (new, processing, complete, canceled, holded, closed)

**Field Name:** `orderState`
**Type:** dimension | |
Order Currency
| ISO code of the currency the customer paid in

**Field Name:** `orderCurrency`
**Type:** dimension | |
Order Base Currency
| ISO code of the store base currency used for base\_\* totals

**Field Name:** `orderBaseCurrency`
**Type:** dimension | |
Order Created Date
| Date the order was created (YYYY-MM-DD, UTC)

**Field Name:** `orderCreatedDate`
**Type:** dimension | |
Order Created Datetime
| Timestamp the order was created (UTC)

**Field Name:** `orderCreatedDatetime`
**Type:** dimension | |
Order Updated Date
| Date of the last order update (YYYY-MM-DD, UTC)

**Field Name:** `orderUpdatedDate`
**Type:** dimension | |
Order Updated Datetime
| Timestamp of the last order update (UTC)

**Field Name:** `orderUpdatedDatetime`
**Type:** dimension | |
Payment Method
| Identifier of the payment method used for the order

**Field Name:** `paymentMethod`
**Type:** dimension | |
Shipping Method
| Human-readable description of the shipping method

**Field Name:** `shippingMethod`
**Type:** dimension | |
Coupon Code
| Coupon or promo code applied to the order, if any

**Field Name:** `couponCode`
**Type:** dimension | ### Customer | | | | ----------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | |
Customer ID
| Unique identifier of the customer (empty for guest checkouts)

**Field Name:** `customerId`
**Type:** dimension | |
Customer Group ID
| Identifier of the customer group the customer belongs to

**Field Name:** `customerGroupId`
**Type:** dimension | |
Customer Prefix
| Prefix for the customer's name (e.g., Mr., Ms.)

**Field Name:** `customerPrefix`
**Type:** dimension | |
Customer First Name
| First name of the customer

**Field Name:** `customerFirstName`
**Type:** dimension | |
Customer Middle Name
| Middle name of the customer

**Field Name:** `customerMiddleName`
**Type:** dimension | |
Customer Last Name
| Last name of the customer

**Field Name:** `customerLastName`
**Type:** dimension | |
Customer Name Suffix
| Suffix for the customer's name (e.g., Jr., Sr., III)

**Field Name:** `customerNameSuffix`
**Type:** dimension | |
Customer Gender
| Gender of the customer (Male, Female, Not Specified)

**Field Name:** `customerGender`
**Type:** dimension | |
Customer Date of Birth
| Date of birth of the customer

**Field Name:** `customerDob`
**Type:** dimension | |
Customer Email
| Email address of the customer

**Field Name:** `customerEmail`
**Type:** dimension | |
Customer Is Guest
| Whether the order was placed as a guest checkout

**Field Name:** `customerIsGuest`
**Type:** dimension | |
Customer Tax/VAT Number
| Tax or VAT identification number of the customer

**Field Name:** `customerTaxVatNumber`
**Type:** dimension | ### Billing Address | | | | -------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------- | |
Billing First Name
| First name on the billing address

**Field Name:** `billingFirstName`
**Type:** dimension | |
Billing Middle Name
| Middle name on the billing address

**Field Name:** `billingMiddleName`
**Type:** dimension | |
Billing Last Name
| Last name on the billing address

**Field Name:** `billingLastName`
**Type:** dimension | |
Billing Company
| Company on the billing address

**Field Name:** `billingCompany`
**Type:** dimension | |
Billing Address Type
| Type of the billing address (usually "billing")

**Field Name:** `billingAddressType`
**Type:** dimension | |
Billing Street
| Street address on the billing address (multiple lines joined)

**Field Name:** `billingStreet`
**Type:** dimension | |
Billing City
| City on the billing address

**Field Name:** `billingCity`
**Type:** dimension | |
Billing Region
| Region / state on the billing address

**Field Name:** `billingRegion`
**Type:** dimension | |
Billing Region ID
| Magento numeric region identifier for the billing address

**Field Name:** `billingRegionId`
**Type:** dimension | |
Billing Region Code
| Region code on the billing address (e.g., CO-BOG)

**Field Name:** `billingRegionCode`
**Type:** dimension | |
Billing Postal Code
| Postal code on the billing address

**Field Name:** `billingPostalCode`
**Type:** dimension | |
Billing Country ID
| ISO two-letter country code on the billing address

**Field Name:** `billingCountryId`
**Type:** dimension | |
Billing Email
| Email address on the billing address

**Field Name:** `billingEmail`
**Type:** dimension | |
Billing Telephone
| Telephone number on the billing address

**Field Name:** `billingTelephone`
**Type:** dimension | |
Billing Fax
| Fax number on the billing address

**Field Name:** `billingFax`
**Type:** dimension | ### Shipping Address | | | | --------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------- | |
Shipping First Name
| First name on the shipping address

**Field Name:** `shippingFirstName`
**Type:** dimension | |
Shipping Middle Name
| Middle name on the shipping address

**Field Name:** `shippingMiddleName`
**Type:** dimension | |
Shipping Last Name
| Last name on the shipping address

**Field Name:** `shippingLastName`
**Type:** dimension | |
Shipping Company
| Company on the shipping address

**Field Name:** `shippingCompany`
**Type:** dimension | |
Shipping Address Type
| Type of the shipping address (usually "shipping")

**Field Name:** `shippingAddressType`
**Type:** dimension | |
Shipping Street
| Street address on the shipping address (multiple lines joined)

**Field Name:** `shippingStreet`
**Type:** dimension | |
Shipping City
| City on the shipping address

**Field Name:** `shippingCity`
**Type:** dimension | |
Shipping Region
| Region / state on the shipping address

**Field Name:** `shippingRegion`
**Type:** dimension | |
Shipping Region ID
| Magento numeric region identifier for the shipping address

**Field Name:** `shippingRegionId`
**Type:** dimension | |
Shipping Region Code
| Region code on the shipping address (e.g., CO-BOG)

**Field Name:** `shippingRegionCode`
**Type:** dimension | |
Shipping Postal Code
| Postal code on the shipping address

**Field Name:** `shippingPostalCode`
**Type:** dimension | |
Shipping Country ID
| ISO two-letter country code on the shipping address

**Field Name:** `shippingCountryId`
**Type:** dimension | |
Shipping Email
| Email address on the shipping address

**Field Name:** `shippingEmail`
**Type:** dimension | |
Shipping Telephone
| Telephone number on the shipping address

**Field Name:** `shippingTelephone`
**Type:** dimension | |
Shipping Fax
| Fax number on the shipping address

**Field Name:** `shippingFax`
**Type:** dimension | ### Store | | | | ------------------------------------------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------ | |
Store Domain
| Hostname of the Magento store the order was placed on

**Field Name:** `storeDomain`
**Type:** dimension | |
Store ID
| Magento numeric identifier of the store view

**Field Name:** `storeId`
**Type:** dimension | |
Store Name
| Website > Store > Store View hierarchy name as configured in Magento Admin

**Field Name:** `storeName`
**Type:** dimension | ### Items | | | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- | |
Item ID
| Unique identifier of the order line item

**Field Name:** `itemId`
**Type:** dimension | |
Item Order ID
| Identifier of the order the line item belongs to

**Field Name:** `itemOrderId`
**Type:** dimension | |
Item Quote Item ID
| Identifier of the cart line item that this order item was converted from

**Field Name:** `itemQuoteItemId`
**Type:** dimension | |
Item SKU
| SKU of the product on the line item

**Field Name:** `itemSku`
**Type:** dimension | |
Product ID
| Magento product ID

**Field Name:** `productId`
**Type:** dimension | |
Product Name
| Display name of the product

**Field Name:** `productName`
**Type:** dimension | |
Product Type
| Type of the product (simple, configurable, bundle, grouped, virtual, downloadable)

**Field Name:** `productType`
**Type:** dimension | |
Item Created Date
| Date the order line item was created

**Field Name:** `itemCreatedDate`
**Type:** dimension | |
Item Created Datetime
| Timestamp the order line item was created

**Field Name:** `itemCreatedDatetime`
**Type:** dimension | |
Item Updated Date
| Date of the last line item update

**Field Name:** `itemUpdatedDate`
**Type:** dimension | |
Item Updated Datetime
| Timestamp of the last line item update

**Field Name:** `itemUpdatedDatetime`
**Type:** dimension | ## Metrics Metrics are the numerical values you can measure and analyze from your Magento campaigns. ### Order | | | | --------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------- | |
Orders
| Total number of orders

**Field Name:** `orders`
**Type:** metric | |
Order Quantity
| Total quantity of items in the orders

**Field Name:** `orderQuantity`
**Type:** metric | |
Order Subtotal
| Order subtotal before tax and discounts (order currency)

**Field Name:** `orderSubtotal`
**Type:** metric | |
Order Subtotal (Incl. Tax)
| Order subtotal including tax (order currency)

**Field Name:** `orderSubtotalInclTax`
**Type:** metric | |
Order Discount
| Total discount amount applied to the order (order currency)

**Field Name:** `orderDiscount`
**Type:** metric | |
Order Tax
| Total tax amount on the order (order currency)

**Field Name:** `orderTax`
**Type:** metric | |
Order Shipping & Handling
| Total shipping and handling charges (order currency)

**Field Name:** `orderShippingAndHandling`
**Type:** metric | |
Order Grand Total
| Final order total after adjustments (order currency)

**Field Name:** `orderGrandTotal`
**Type:** metric | |
Order Grand Total (Base Currency)
| Final order total converted to store base currency

**Field Name:** `orderBaseGrandTotal`
**Type:** metric | |
Order Total Paid
| Total amount paid on the order (order currency)

**Field Name:** `orderTotalPaid`
**Type:** metric | |
Order Total Refunded
| Total amount refunded on the order (order currency)

**Field Name:** `orderTotalRefunded`
**Type:** metric | |
Order Total Due
| Amount still due on the order (order currency)

**Field Name:** `orderTotalDue`
**Type:** metric | |
Order Weight
| Total weight of the order

**Field Name:** `orderWeight`
**Type:** metric | ### Customer | | | | --------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------- | |
Customers
| Count of customers on returned orders

**Field Name:** `customers`
**Type:** metric | ### Items | | | | --------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
Item Original Price
| Original unit price before discounts (order currency)

**Field Name:** `itemOriginalPrice`
**Type:** metric | |
Item Price
| Unit price of the item after discounts (order currency)

**Field Name:** `itemPrice`
**Type:** metric | |
Item Quantity Ordered
| Quantity of the item ordered

**Field Name:** `itemQuantityOrdered`
**Type:** metric | |
Item Quantity Invoiced
| Quantity of the item invoiced

**Field Name:** `itemQuantityInvoiced`
**Type:** metric | |
Item Quantity Shipped
| Quantity of the item shipped

**Field Name:** `itemQuantityShipped`
**Type:** metric | |
Item Quantity Refunded
| Quantity of the item refunded

**Field Name:** `itemQuantityRefunded`
**Type:** metric | |
Item Quantity Returned
| Quantity of the item physically returned by the customer

**Field Name:** `itemQuantityReturned`
**Type:** metric | |
Item Quantity Canceled
| Quantity of the item canceled

**Field Name:** `itemQuantityCanceled`
**Type:** metric | |
Item Subtotal
| Row subtotal for the item before tax and discounts

**Field Name:** `itemSubtotal`
**Type:** metric | |
Item Tax Amount
| Tax amount applied to the item row

**Field Name:** `itemTaxAmount`
**Type:** metric | |
Item Tax Percent
| Tax percentage applied to the item

**Field Name:** `itemTaxPercent`
**Type:** metric | |
Item Tax Canceled
| Tax amount canceled on the item (when parts of the order are canceled)

**Field Name:** `itemTaxCanceled`
**Type:** metric | |
Item Discount Amount
| Discount amount applied to the item row

**Field Name:** `itemDiscountAmount`
**Type:** metric | |
Item Discount Tax Compensation Canceled
| Discount tax compensation amount canceled on the item (Magento tax rollback)

**Field Name:** `itemDiscountTaxCompensationCanceled`
**Type:** metric | |
Item Total
| Final total for the item row after tax and discounts

**Field Name:** `itemTotal`
**Type:** metric | |
Item Refund Amount
| Amount refunded on the item row

**Field Name:** `itemRefundAmount`
**Type:** metric | |
Item Weight
| Weight of a single unit of the item

**Field Name:** `itemWeight`
**Type:** metric | *** ## Related Browse all platforms shopify-store metrics & dimensions WooCommerce metrics & dimensions vtex-store metrics & dimensions