Skip to main content

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.

Last updated: May 9, 2026
68 dimensions
31 metrics
This reference covers all available dimensions and metrics for Magento Orders data through Detrics. Use this guide to understand what data you can extract and how to structure your queries.
Supported destinations:
Google Sheets

​
Dimensions

Dimensions are the attributes you can use to segment and group your Magento Orders 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 Orders 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

Fields Catalog

Browse all platforms

shopify-store Fields

shopify-store metrics & dimensions

WooCommerce Fields

WooCommerce metrics & dimensions

vtex-store Fields

vtex-store metrics & dimensions