Last updated: August 6, 2026
68 dimensions
31 metrics
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: orderIncrementIdType: dimension |
Order Status | Current status of the order (e.g., pending, processing, complete, canceled, closed) Field Name: orderStatusType: dimension |
Order State | High-level state of the order (new, processing, complete, canceled, holded, closed) Field Name: orderStateType: dimension |
Order Currency | ISO code of the currency the customer paid in Field Name: orderCurrencyType: dimension |
Order Base Currency | ISO code of the store base currency used for base_* totals Field Name: orderBaseCurrencyType: dimension |
Order Created Date | Date the order was created (YYYY-MM-DD, UTC) Field Name: orderCreatedDateType: dimension |
Order Created Datetime | Timestamp the order was created (UTC) Field Name: orderCreatedDatetimeType: dimension |
Order Updated Date | Date of the last order update (YYYY-MM-DD, UTC) Field Name: orderUpdatedDateType: dimension |
Order Updated Datetime | Timestamp of the last order update (UTC) Field Name: orderUpdatedDatetimeType: dimension |
Payment Method | Identifier of the payment method used for the order Field Name: paymentMethodType: dimension |
Shipping Method | Human-readable description of the shipping method Field Name: shippingMethodType: dimension |
Coupon Code | Coupon or promo code applied to the order, if any Field Name: couponCodeType: dimension |
Customer
Customer ID | Unique identifier of the customer (empty for guest checkouts) Field Name: customerIdType: dimension |
Customer Group ID | Identifier of the customer group the customer belongs to Field Name: customerGroupIdType: dimension |
Customer Prefix | Prefix for the customer’s name (e.g., Mr., Ms.) Field Name: customerPrefixType: dimension |
Customer First Name | First name of the customer Field Name: customerFirstNameType: dimension |
Customer Middle Name | Middle name of the customer Field Name: customerMiddleNameType: dimension |
Customer Last Name | Last name of the customer Field Name: customerLastNameType: dimension |
Customer Name Suffix | Suffix for the customer’s name (e.g., Jr., Sr., III) Field Name: customerNameSuffixType: dimension |
Customer Gender | Gender of the customer (Male, Female, Not Specified) Field Name: customerGenderType: dimension |
Customer Date of Birth | Date of birth of the customer Field Name: customerDobType: dimension |
Customer Email | Email address of the customer Field Name: customerEmailType: dimension |
Customer Is Guest | Whether the order was placed as a guest checkout Field Name: customerIsGuestType: dimension |
Customer Tax/VAT Number | Tax or VAT identification number of the customer Field Name: customerTaxVatNumberType: dimension |
Billing Address
Billing First Name | First name on the billing address Field Name: billingFirstNameType: dimension |
Billing Middle Name | Middle name on the billing address Field Name: billingMiddleNameType: dimension |
Billing Last Name | Last name on the billing address Field Name: billingLastNameType: dimension |
Billing Company | Company on the billing address Field Name: billingCompanyType: dimension |
Billing Address Type | Type of the billing address (usually “billing”) Field Name: billingAddressTypeType: dimension |
Billing Street | Street address on the billing address (multiple lines joined) Field Name: billingStreetType: dimension |
Billing City | City on the billing address Field Name: billingCityType: dimension |
Billing Region | Region / state on the billing address Field Name: billingRegionType: dimension |
Billing Region ID | Magento numeric region identifier for the billing address Field Name: billingRegionIdType: dimension |
Billing Region Code | Region code on the billing address (e.g., CO-BOG) Field Name: billingRegionCodeType: dimension |
Billing Postal Code | Postal code on the billing address Field Name: billingPostalCodeType: dimension |
Billing Country ID | ISO two-letter country code on the billing address Field Name: billingCountryIdType: dimension |
Billing Email | Email address on the billing address Field Name: billingEmailType: dimension |
Billing Telephone | Telephone number on the billing address Field Name: billingTelephoneType: dimension |
Billing Fax | Fax number on the billing address Field Name: billingFaxType: dimension |
Shipping Address
Shipping First Name | First name on the shipping address Field Name: shippingFirstNameType: dimension |
Shipping Middle Name | Middle name on the shipping address Field Name: shippingMiddleNameType: dimension |
Shipping Last Name | Last name on the shipping address Field Name: shippingLastNameType: dimension |
Shipping Company | Company on the shipping address Field Name: shippingCompanyType: dimension |
Shipping Address Type | Type of the shipping address (usually “shipping”) Field Name: shippingAddressTypeType: dimension |
Shipping Street | Street address on the shipping address (multiple lines joined) Field Name: shippingStreetType: dimension |
Shipping City | City on the shipping address Field Name: shippingCityType: dimension |
Shipping Region | Region / state on the shipping address Field Name: shippingRegionType: dimension |
Shipping Region ID | Magento numeric region identifier for the shipping address Field Name: shippingRegionIdType: dimension |
Shipping Region Code | Region code on the shipping address (e.g., CO-BOG) Field Name: shippingRegionCodeType: dimension |
Shipping Postal Code | Postal code on the shipping address Field Name: shippingPostalCodeType: dimension |
Shipping Country ID | ISO two-letter country code on the shipping address Field Name: shippingCountryIdType: dimension |
Shipping Email | Email address on the shipping address Field Name: shippingEmailType: dimension |
Shipping Telephone | Telephone number on the shipping address Field Name: shippingTelephoneType: dimension |
Shipping Fax | Fax number on the shipping address Field Name: shippingFaxType: dimension |
Store
Store Domain | Hostname of the Magento store the order was placed on Field Name: storeDomainType: dimension |
Store ID | Magento numeric identifier of the store view Field Name: storeIdType: dimension |
Store Name | Website > Store > Store View hierarchy name as configured in Magento Admin Field Name: storeNameType: dimension |
Items
Item ID | Unique identifier of the order line item Field Name: itemIdType: dimension |
Item Order ID | Identifier of the order the line item belongs to Field Name: itemOrderIdType: dimension |
Item Quote Item ID | Identifier of the cart line item that this order item was converted from Field Name: itemQuoteItemIdType: dimension |
Item SKU | SKU of the product on the line item Field Name: itemSkuType: dimension |
Product ID | Magento product ID Field Name: productIdType: dimension |
Product Name | Display name of the product Field Name: productNameType: dimension |
Product Type | Type of the product (simple, configurable, bundle, grouped, virtual, downloadable) Field Name: productTypeType: dimension |
Item Created Date | Date the order line item was created Field Name: itemCreatedDateType: dimension |
Item Created Datetime | Timestamp the order line item was created Field Name: itemCreatedDatetimeType: dimension |
Item Updated Date | Date of the last line item update Field Name: itemUpdatedDateType: dimension |
Item Updated Datetime | Timestamp of the last line item update Field Name: itemUpdatedDatetimeType: dimension |
Metrics
Metrics are the numerical values you can measure and analyze from your Magento campaigns.Order
Orders | Total number of orders Field Name: ordersType: metric |
Order Quantity | Total quantity of items in the orders Field Name: orderQuantityType: metric |
Order Subtotal | Order subtotal before tax and discounts (order currency) Field Name: orderSubtotalType: metric |
Order Subtotal (Incl. Tax) | Order subtotal including tax (order currency) Field Name: orderSubtotalInclTaxType: metric |
Order Discount | Total discount amount applied to the order (order currency) Field Name: orderDiscountType: metric |
Order Tax | Total tax amount on the order (order currency) Field Name: orderTaxType: metric |
Order Shipping & Handling | Total shipping and handling charges (order currency) Field Name: orderShippingAndHandlingType: metric |
Order Grand Total | Final order total after adjustments (order currency) Field Name: orderGrandTotalType: metric |
Order Grand Total (Base Currency) | Final order total converted to store base currency Field Name: orderBaseGrandTotalType: metric |
Order Total Paid | Total amount paid on the order (order currency) Field Name: orderTotalPaidType: metric |
Order Total Refunded | Total amount refunded on the order (order currency) Field Name: orderTotalRefundedType: metric |
Order Total Due | Amount still due on the order (order currency) Field Name: orderTotalDueType: metric |
Order Weight | Total weight of the order Field Name: orderWeightType: metric |
Customer
Customers | Count of customers on returned orders Field Name: customersType: metric |
Items
Item Original Price | Original unit price before discounts (order currency) Field Name: itemOriginalPriceType: metric |
Item Price | Unit price of the item after discounts (order currency) Field Name: itemPriceType: metric |
Item Quantity Ordered | Quantity of the item ordered Field Name: itemQuantityOrderedType: metric |
Item Quantity Invoiced | Quantity of the item invoiced Field Name: itemQuantityInvoicedType: metric |
Item Quantity Shipped | Quantity of the item shipped Field Name: itemQuantityShippedType: metric |
Item Quantity Refunded | Quantity of the item refunded Field Name: itemQuantityRefundedType: metric |
Item Quantity Returned | Quantity of the item physically returned by the customer Field Name: itemQuantityReturnedType: metric |
Item Quantity Canceled | Quantity of the item canceled Field Name: itemQuantityCanceledType: metric |
Item Subtotal | Row subtotal for the item before tax and discounts Field Name: itemSubtotalType: metric |
Item Tax Amount | Tax amount applied to the item row Field Name: itemTaxAmountType: metric |
Item Tax Percent | Tax percentage applied to the item Field Name: itemTaxPercentType: metric |
Item Tax Canceled | Tax amount canceled on the item (when parts of the order are canceled) Field Name: itemTaxCanceledType: metric |
Item Discount Amount | Discount amount applied to the item row Field Name: itemDiscountAmountType: metric |
Item Discount Tax Compensation Canceled | Discount tax compensation amount canceled on the item (Magento tax rollback) Field Name: itemDiscountTaxCompensationCanceledType: metric |
Item Total | Final total for the item row after tax and discounts Field Name: itemTotalType: metric |
Item Refund Amount | Amount refunded on the item row Field Name: itemRefundAmountType: metric |
Item Weight | Weight of a single unit of the item Field Name: itemWeightType: metric |
Related
Fields Catalog
Browse all platforms
shopify-store Fields
shopify-store metrics & dimensions
WooCommerce Fields
WooCommerce metrics & dimensions
vtex-store Fields
vtex-store metrics & dimensions