Magento: Most-used fields

The table below gives information about most-used fields that you can import from Magento. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name	Adverity UI name	Description	Use in Adverity
addresses.{NUM}.city	addresses.{NUM}.city	The city of the customer’s address.	dimension
addresses.{NUM}.company	addresses.{NUM}.company	The company name associated with the customer’s address.	dimension
addresses.{NUM}.country_id	addresses.{NUM}.country_id	The ID of the country associated with the customer’s address.	dimension
addresses.{NUM}.customer_id	addresses.{NUM}.customer_id	The ID of the customer to whom the address belongs.	dimension
addresses.{NUM}.default_billing	addresses.{NUM}.default_billing	A flag indicating if this is the customer’s default billing address.	dimension
addresses.{NUM}.default_shipping	addresses.{NUM}.default_shipping	A flag indicating if this is the customer’s default shipping address.	dimension
addresses.{NUM}.firstname	addresses.{NUM}.firstname	The first name of the person associated with the address.	dimension
addresses.{NUM}.id	addresses.{NUM}.id	The unique identifier for the address record.	metric
addresses.{NUM}.lastname	addresses.{NUM}.lastname	The last name of the person associated with the address.	dimension
addresses.{NUM}.postcode	addresses.{NUM}.postcode	The postal code or ZIP code of the address.	dimension
addresses.{NUM}.region.region	addresses.{NUM}.region.region	The full name of the region or state associated with the address.	dimension
addresses.{NUM}.region.region_code	addresses.{NUM}.region.region_code	The code for the region or state associated with the address.	dimension
addresses.{NUM}.region.region_id	addresses.{NUM}.region.region_id	The ID of the region or state associated with the address.	dimension
addresses.{NUM}.region_id	addresses.{NUM}.region_id	The ID of the region or state associated with the address.	dimension
addresses.{NUM}.street.{NUM}	addresses.{NUM}.street.{NUM}	A line of the street address. Multiple lines can exist for a single address.	dimension
addresses.{NUM}.telephone	addresses.{NUM}.telephone	The telephone number associated with the address.	dimension
addresses.{NUM}.vat_id	addresses.{NUM}.vat_id	The Value Added Tax (VAT) identification number for the customer’s address.	dimension
applied_rule_ids	applied_rule_ids	A comma-separated list of IDs of the shopping cart price rules that were applied to the order item or the entire order.	dimension
base_currency_code	base_currency_code	The base currency code of the store.	dimension
base_discount_amount	base_discount_amount	The discount amount applied to the order in base currency.	metric
base_discount_invoiced	base_discount_invoiced	The invoiced discount amount in base currency.	metric
base_discount_tax_compensation_amount	base_discount_tax_compensation_amount	The discount tax compensation amount in base currency.	metric
base_discount_tax_compensation_invoiced	base_discount_tax_compensation_invoiced	The invoiced discount tax compensation amount in base currency.	metric
base_grand_total	base_grand_total	The grand total amount of the order in base currency.	metric
base_shipping_amount	base_shipping_amount	The shipping amount for the order in base currency.	metric
base_shipping_discount_amount	base_shipping_discount_amount	The shipping discount amount in base currency.	metric
base_shipping_discount_tax_compensation_amnt	base_shipping_discount_tax_compensation_amnt	The shipping discount tax compensation amount in base currency.	metric
base_shipping_incl_tax	base_shipping_incl_tax	The shipping amount including tax in base currency.	metric
base_shipping_invoiced	base_shipping_invoiced	The invoiced shipping amount in base currency.	metric
base_shipping_tax_amount	base_shipping_tax_amount	The shipping tax amount in base currency.	metric
base_subtotal	base_subtotal	The subtotal amount of the order in base currency.	metric
base_subtotal_incl_tax	base_subtotal_incl_tax	The subtotal amount including tax in base currency.	metric
base_subtotal_invoiced	base_subtotal_invoiced	The invoiced subtotal amount in base currency.	metric
base_tax_amount	base_tax_amount	The total tax amount for the order in base currency.	metric
base_tax_invoiced	base_tax_invoiced	The invoiced tax amount in base currency.	metric
base_to_global_rate	base_to_global_rate	The currency conversion rate from base currency to global currency.	metric
base_to_order_rate	base_to_order_rate	The currency conversion rate from base currency to order currency.	metric
base_total_due	base_total_due	The total amount still due on the order in base currency.	metric
base_total_invoiced	base_total_invoiced	The total invoiced amount in base currency.	metric
base_total_invoiced_cost	base_total_invoiced_cost	The total invoiced cost of the items in base currency.	metric
base_total_paid	base_total_paid	The total amount paid in base currency.	metric
billing_address.address_type	billing_address.address_type	The type of the billing address (e.g., ‘billing’).	dimension
billing_address.city	billing_address.city	The city of the billing address.	dimension
billing_address.company	billing_address.company	The company name associated with the billing address.	dimension
billing_address.country_id	billing_address.country_id	The country ID of the billing address (e.g., ‘US’).	dimension
billing_address.customer_address_id	billing_address.customer_address_id	The ID of the customer’s address if it’s a registered address.	dimension
billing_address.customer_id	billing_address.customer_id	The ID of the customer associated with the billing address.	dimension
billing_address.email	billing_address.email	The email address associated with the billing address.	dimension
billing_address.entity_id	billing_address.entity_id	The unique identifier for the billing address entity.	dimension
billing_address.firstname	billing_address.firstname	The first name for the billing address.	dimension
billing_address.lastname	billing_address.lastname	The last name for the billing address.	dimension
billing_address.middlename	billing_address.middlename	The middle name of the person associated with the billing address.	dimension
billing_address.parent_id	billing_address.parent_id	The ID of the parent entity (e.g., order) to which this billing address belongs.	dimension
billing_address.postcode	billing_address.postcode	The postcode/zip code of the billing address.	dimension
billing_address.region_id	billing_address.region_id	The region ID of the billing address.	dimension
billing_address.street.{NUM}	billing_address.street.{NUM}	A specific line of the street address for the billing address.	dimension
billing_address.telephone	billing_address.telephone	The telephone number for the billing address.	dimension
billing_address.vat_id	billing_address.vat_id	The VAT ID associated with the billing address for business customers.	dimension
billing_address.vat_is_valid	billing_address.vat_is_valid	A flag indicating if the VAT ID provided for the billing address is valid.	metric
billing_address.vat_request_success	billing_address.vat_request_success	Indicates if the VAT ID validation request for the billing address was successful.	metric
billing_address_id	billing_address_id	The ID of the billing address.	dimension
created_at	created_at	The timestamp when the entity (e.g., order, invoice, customer) was created.	dimension
created_in	created_in	The store view code or name where the entity (e.g., customer, order) was created.	dimension
custom_attributes.{NUM}.attribute_code	custom_attributes.{NUM}.attribute_code	The code for a custom attribute.	dimension
custom_attributes.{NUM}.value	custom_attributes.{NUM}.value	The value of the custom attribute.	metric
customer_email	customer_email	The customer’s email address.	dimension
customer_firstname	customer_firstname	The customer’s first name.	dimension
customer_gender	customer_gender	The customer’s gender.	metric
customer_group_id	customer_group_id	The ID of the customer group to which the customer belongs.	dimension
customer_id	customer_id	The unique identifier for the customer.	dimension
customer_is_guest	customer_is_guest	A flag indicating if the customer is a guest (not a registered user).	metric
customer_lastname	customer_lastname	The customer’s last name.	dimension
customer_middlename	customer_middlename	The customer’s middle name.	dimension
customer_note_notify	customer_note_notify	A flag indicating if the customer should be notified about the customer note.	metric
customer_suffix	customer_suffix	This field stores a suffix associated with a customer’s name, such as “Jr.”, “Sr.”, or “III”, typically found within customer address information.	dimension
customer_taxvat	customer_taxvat	The customer’s TAX/VAT number.	metric
date	date	The date associated with the entity’s creation or a relevant event.	dimension
default_billing	default_billing	The ID of the customer’s default billing address.	metric
default_shipping	default_shipping	The ID of the customer’s default shipping address.	metric
disable_auto_group_change	disable_auto_group_change	Indicates whether the automatic change of a customer’s group based on their VAT ID is disabled. When set, the customer’s group will not be automatically updated even if VAT ID rules apply.	metric
discount_amount	discount_amount	The total discount amount applied to the order.	metric
discount_description	discount_description	A description of the discount applied to the order.	dimension
discount_invoiced	discount_invoiced	The amount of discount that has been invoiced.	metric
discount_tax_compensation_amount	discount_tax_compensation_amount	The tax compensation amount for the discount.	metric
discount_tax_compensation_canceled	discount_tax_compensation_canceled	This field represents the tax amount compensated or adjusted due to discounts on a canceled order or order item.	metric
discount_tax_compensation_invoiced	discount_tax_compensation_invoiced	The invoiced tax compensation amount for the discount.	metric
email	email	The email address of the customer.	dimension
email_sent	email_sent	Indicates whether an email notification for the entity (e.g., order confirmation, invoice) has been sent.	metric
entity_id	entity_id	The unique identifier for the entity.	dimension
extension_attributes.applied_taxes.{NUM}.amount	extension_attributes.applied_taxes.{NUM}.amount	The amount of an applied tax.	metric
extension_attributes.applied_taxes.{NUM}.base_amount	extension_attributes.applied_taxes.{NUM}.base_amount	The base currency amount of an applied tax.	metric
extension_attributes.applied_taxes.{NUM}.code	extension_attributes.applied_taxes.{NUM}.code	The code of an applied tax.	metric
extension_attributes.applied_taxes.{NUM}.percent	extension_attributes.applied_taxes.{NUM}.percent	The percentage of an applied tax.	metric
extension_attributes.applied_taxes.{NUM}.title	extension_attributes.applied_taxes.{NUM}.title	The title or name of an applied tax.	metric
extension_attributes.base_gift_cards_amount	extension_attributes.base_gift_cards_amount	The total amount of gift cards applied to the order in the store’s base currency.	metric
extension_attributes.base_gift_cards_invoiced	extension_attributes.base_gift_cards_invoiced	The base amount of gift card value that has been invoiced for the order.	metric
extension_attributes.converting_from_quote	extension_attributes.converting_from_quote	A flag indicating whether the order was converted from a customer quote.	dimension
extension_attributes.gift_cards.{NUM}.amount	extension_attributes.gift_cards.{NUM}.amount	The amount of a specific gift card applied to the order.	metric
extension_attributes.gift_cards.{NUM}.base_amount	extension_attributes.gift_cards.{NUM}.base_amount	The base currency amount of a specific gift card applied to the order.	metric
extension_attributes.gift_cards.{NUM}.code	extension_attributes.gift_cards.{NUM}.code	The unique code of the gift card used for the order.	dimension
extension_attributes.gift_cards.{NUM}.id	extension_attributes.gift_cards.{NUM}.id	The unique identifier for a specific gift card used on the order.	metric
extension_attributes.gift_cards_amount	extension_attributes.gift_cards_amount	The total amount of gift cards applied to the order in the order’s currency.	metric
extension_attributes.gift_cards_invoiced	extension_attributes.gift_cards_invoiced	The amount of gift card value in the order’s currency that has been invoiced.	metric
extension_attributes.is_subscribed	extension_attributes.is_subscribed	Indicates whether the customer is subscribed to the newsletter.	dimension
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.amount	extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.amount	The amount of an applied tax for a specific item.	metric
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.base_amount	extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.base_amount	The base currency amount of an applied tax for a specific item.	metric
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.code	extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.code	The code of an applied tax for a specific item.	metric
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.percent	extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.percent	The percentage of an applied tax for a specific item.	metric
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.title	extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.title	The title or name of an applied tax for a specific item.	metric
extension_attributes.item_applied_taxes.{NUM}.item_id	extension_attributes.item_applied_taxes.{NUM}.item_id	The ID of the item to which the taxes are applied.	dimension
extension_attributes.item_applied_taxes.{NUM}.type	extension_attributes.item_applied_taxes.{NUM}.type	The type of tax applied to the item.	dimension
extension_attributes.payment_additional_info.{NUM}.key	extension_attributes.payment_additional_info.{NUM}.key	The key for an additional piece of payment information associated with the order.	dimension
extension_attributes.payment_additional_info.{NUM}.value	extension_attributes.payment_additional_info.{NUM}.value	The value corresponding to a key in the additional payment information associated with the order.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.amount_refunded	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.amount_refunded	The amount refunded for this specific item within the shipping assignment.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.applied_rule_ids	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.applied_rule_ids	A comma-separated list of IDs for cart price rules or promotions that were applied to this item.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_amount_refunded	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_amount_refunded	The amount refunded for this specific item in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_cost	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_cost	The base cost of the item within a specific shipping assignment.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_amount	The discount amount applied to this item in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_invoiced	The amount of discount that has been invoiced for this item in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_tax_compensation_amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_tax_compensation_amount	The amount of tax compensation applied due to discounts for this item, in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_tax_compensation_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_tax_compensation_invoiced	The amount of tax compensation for discounts that has been invoiced for this item, in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_original_price	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_original_price	The original price of the item, before any discounts or special pricing, in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_price	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_price	The unit price of the item in the store’s base currency, excluding tax.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_price_incl_tax	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_price_incl_tax	The unit price of the item in the store’s base currency, including tax.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_invoiced	The total invoiced amount for this item’s row, in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_total	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_total	The total price for this item’s row (quantity * price), excluding tax, in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_total_incl_tax	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_total_incl_tax	The total price for this item’s row (quantity * price), including tax, in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_tax_amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_tax_amount	The total tax amount applied to this item in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_tax_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_tax_invoiced	The amount of tax that has been invoiced for this item, in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.created_at	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.created_at	The date and time when this order item was created.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_amount	The discount amount applied to this item in the order’s currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_invoiced	The amount of discount that has been invoiced for this item.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_percent	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_percent	The percentage of the discount applied to this item.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_amount	The amount of tax compensation applied due to discounts for this item, in the order’s currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_invoiced	The amount of tax compensation for discounts that has been invoiced for this item.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.amount	The total tax amount for a specific itemized tax applied to an item within a shipping assignment.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.base_amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.base_amount	The tax amount in the store’s base currency for a specific itemized tax applied to an item within a shipping assignment.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.item_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.item_id	The ID of the item to which the specific itemized tax applies within a shipping assignment.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_amount	The actual tax amount, after any adjustments, for a specific itemized tax applied to an item within a shipping assignment.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_base_amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_base_amount	The actual tax amount in the store’s base currency, after any adjustments, for a specific itemized tax applied to an item within a shipping assignment.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_code	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_code	The code assigned to this specific itemized tax component.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_id	The identifier for the specific tax rule or rate applied as part of this itemized tax component.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_item_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_item_id	A unique identifier for the specific itemized tax entry on an item within a shipping assignment.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_percent	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_percent	The percentage rate of this specific itemized tax component.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.taxable_item_type	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.taxable_item_type	The type of item (e.g., product, shipping) that the specific itemized tax applies to within a shipping assignment.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.free_shipping	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.free_shipping	Indicates whether free shipping was applied to this item (1 for yes, 0 for no).	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_qty_decimal	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_qty_decimal	Indicates if the quantity for this item can be expressed as a decimal value (e.g., for products sold by weight).	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_virtual	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_virtual	Indicates if the item is a virtual product, such as a service or digital download (1 for virtual, 0 for physical).	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.item_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.item_id	The unique identifier for this specific item within the order.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.name	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.name	The name of the product in the order item.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.no_discount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.no_discount	Indicates if this item is excluded from discount calculations.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.order_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.order_id	The unique identifier for the order this item belongs to.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.original_price	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.original_price	The original unit price of the item in the order’s currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.amount_refunded	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.amount_refunded	The amount refunded for the parent item, if this item is part of a configurable or bundle product.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.applied_rule_ids	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.applied_rule_ids	A list of rule IDs applied to the parent item associated with a product in a shipping assignment.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_amount_refunded	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_amount_refunded	The amount refunded for the parent item, expressed in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_amount	The discount amount applied to the parent item, expressed in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_invoiced	The amount of discount invoiced for the parent item, expressed in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_tax_compensation_amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_tax_compensation_amount	The discount tax compensation amount for the parent item, expressed in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_tax_compensation_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_tax_compensation_invoiced	The discount tax compensation amount invoiced for the parent item, expressed in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_original_price	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_original_price	The original price of the parent item, expressed in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_price	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_price	The price of the parent item before discounts and taxes, expressed in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_price_incl_tax	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_price_incl_tax	The price of the parent item including tax, expressed in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_invoiced	The invoiced row total for the parent item, expressed in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_total	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_total	The total row price for the parent item (quantity * base price), expressed in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_total_incl_tax	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_total_incl_tax	The total row price for the parent item including tax, expressed in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_tax_amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_tax_amount	The tax amount for the parent item, expressed in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_tax_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_tax_invoiced	The tax amount invoiced for the parent item, expressed in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.created_at	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.created_at	The date and time when the parent item was created.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_amount	The discount amount applied to the parent item, expressed in the order’s currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_invoiced	The amount of discount invoiced for the parent item, expressed in the order’s currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_percent	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_percent	The discount percentage applied to the parent item.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_amount	The discount tax compensation amount for the parent item, expressed in the order’s currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_invoiced	The discount tax compensation amount invoiced for the parent item, expressed in the order’s currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.amount	The amount of an itemized tax applied to a parent item within a shipping assignment.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.base_amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.base_amount	The base currency amount of an itemized tax applied to a parent item within a shipping assignment.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.item_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.item_id	The ID of the item to which this specific itemized tax applies, within a shipping assignment.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_amount	The actual amount of an itemized tax applied to a parent item within a shipping assignment.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_base_amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_base_amount	The actual base currency amount of an itemized tax applied to a parent item within a shipping assignment.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_code	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_code	The tax code associated with this itemized tax on a parent item within a shipping assignment.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_id	The unique identifier for this itemized tax on a parent item within a shipping assignment.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_item_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_item_id	The unique identifier for the tax item record associated with a parent item within a shipping assignment.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_percent	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_percent	The tax rate percentage for this itemized tax on a parent item within a shipping assignment.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.taxable_item_type	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.taxable_item_type	The type of item that this itemized tax applies to (e.g., product, shipping), for a parent item within a shipping assignment.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.free_shipping	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.free_shipping	Indicates whether free shipping was applied to the parent item (0 for no, 1 for yes).	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.is_qty_decimal	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.is_qty_decimal	Indicates if the quantity of the parent item can be a decimal value.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.is_virtual	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.is_virtual	Indicates if the parent item is a virtual product (e.g., a service or digital download).	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.item_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.item_id	The unique identifier for the parent order item.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.name	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.name	The name of the parent product.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.no_discount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.no_discount	Indicates if no discount is applied to the parent item.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.order_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.order_id	The ID of the order to which the parent item belongs.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.original_price	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.original_price	The original price of the parent item, expressed in the order’s currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.price	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.price	The price of the parent item before discounts and taxes, expressed in the order’s currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.price_incl_tax	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.price_incl_tax	The price of the parent item including tax, expressed in the order’s currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_id	The ID of the product associated with this parent item.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_id	The identifier for a selected option within a bundle product, associated with a parent item in a shipping assignment.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_qty	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_qty	The quantity of a selected option within a bundle product, associated with a parent item in a shipping assignment.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM}	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM}	A specific selection made for an option within a bundle product, associated with a parent item in a shipping assignment.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_id	The ID of a configurable option selected for the parent item. This indicates a specific attribute chosen by the customer (e.g., ‘color’ option ID).	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value	The value of a configurable option selected for the parent item. This represents the specific choice made by the customer (e.g., ‘red’ for color).	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_type	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_type	The type of product for the parent item (e.g., ‘configurable’, ‘bundle’).	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_canceled	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_canceled	The quantity of the parent item that has been canceled.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_invoiced	The quantity of the parent item that has been invoiced.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_ordered	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_ordered	The quantity of the parent item that was originally ordered.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_refunded	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_refunded	The quantity of the parent item that has been refunded.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_returned	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_returned	The quantity of the parent item that has been returned.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_shipped	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_shipped	The quantity of the parent item that has been shipped.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.quote_item_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.quote_item_id	The ID of the quote item from which this parent item originated.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_invoiced	The invoiced row total for the parent item, expressed in the order’s currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_total	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_total	The total row price for the parent item (quantity * price), expressed in the order’s currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_total_incl_tax	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_total_incl_tax	The total row price for the parent item including tax, expressed in the order’s currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_weight	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_weight	The total weight of the parent item for the current row, based on quantity.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.sku	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.sku	The Stock Keeping Unit (SKU) of the parent product.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.store_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.store_id	The ID of the store where the order containing this parent item was placed.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_amount	The tax amount for the parent item, expressed in the order’s currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_invoiced	The tax amount invoiced for the parent item, expressed in the order’s currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_percent	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_percent	The tax percentage applied to the parent item.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.updated_at	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.updated_at	The date and time when the parent item was last updated.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.weee_tax_applied	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.weee_tax_applied	Information about WEEE (Waste Electrical and Electronic Equipment) tax applied to the parent item, if any.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.weight	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.weight	The weight of a single unit of the parent item.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item_id	The ID of the parent item for a specific line item within a shipping assignment. This is part of the extension_attributes on an order and is used to link a child product (e.g., a simple product) to its main parent product (e.g., a configurable product) within a shipment.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price	The unit price of the item in the order’s currency, excluding tax.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price_incl_tax	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price_incl_tax	The unit price of the item in the order’s currency, including tax.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_id	The unique identifier of the product that this order item represents.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_id	The identifier for a selected option within a bundle product, associated with an item in a shipping assignment.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_qty	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_qty	The quantity of a selected option within a bundle product, associated with an item in a shipping assignment.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM}	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM}	A specific selection made for an option within a bundle product, associated with an item in a shipping assignment.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_id	The identifier for a specific configurable option chosen for this product.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_value	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_value	The value selected for a specific configurable option for this product.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_id	The ID of a custom option chosen for a product within a shipping assignment.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_value	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_value	The selected value for a custom option of a product within a shipping assignment.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_type	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_type	The type of product, such as simple, configurable, virtual, or bundle.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_backordered	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_backordered	The quantity of the item that is currently on backorder within a specific shipping assignment.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_canceled	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_canceled	The quantity of this item that has been canceled from the order.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_invoiced	The quantity of this item that has been invoiced.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_ordered	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_ordered	The original quantity of this item placed in the order.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_refunded	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_refunded	The quantity of this item that has been refunded.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_returned	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_returned	The quantity of this item that has been returned by the customer.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_shipped	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_shipped	The quantity of this item that has been shipped.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.quote_item_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.quote_item_id	The identifier for the corresponding item in the customer’s quote or shopping cart.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_invoiced	The total invoiced amount for this item’s row, in the order’s currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_total	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_total	The total price for this item’s row (quantity * price), excluding tax, in the order’s currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_total_incl_tax	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_total_incl_tax	The total price for this item’s row (quantity * price), including tax, in the order’s currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_weight	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_weight	The total weight of the quantity of this item in the order row.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.sku	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.sku	The Stock Keeping Unit (SKU) of the product associated with this order item.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.store_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.store_id	The identifier of the store where the order containing this item was placed.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_amount	The total tax amount applied to this item in the order’s currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_invoiced	The amount of tax that has been invoiced for this item.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_percent	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_percent	The percentage rate of the tax applied to this item.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.updated_at	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.updated_at	The date and time when this order item was last updated.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.weee_tax_applied	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.weee_tax_applied	Information about any WEEE (Waste Electrical and Electronic Equipment) tax applied to this item.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.weight	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.weight	The unit weight of the product associated with this order item.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.address.address_type	extension_attributes.shipping_assignments.{NUM}.shipping.address.address_type	The type of address (e.g., ‘shipping’ or ‘billing’).	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.city	extension_attributes.shipping_assignments.{NUM}.shipping.address.city	The city of the shipping address.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.company	extension_attributes.shipping_assignments.{NUM}.shipping.address.company	The company name associated with the shipping address.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.country_id	extension_attributes.shipping_assignments.{NUM}.shipping.address.country_id	The two-letter ISO country code for the shipping address (e.g., ‘US’, ‘GB’).	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.customer_address_id	extension_attributes.shipping_assignments.{NUM}.shipping.address.customer_address_id	The ID of the customer’s address book entry used for this shipping address.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.customer_id	extension_attributes.shipping_assignments.{NUM}.shipping.address.customer_id	The ID of the customer associated with this shipping address.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.email	extension_attributes.shipping_assignments.{NUM}.shipping.address.email	The email address associated with the shipping address.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.entity_id	extension_attributes.shipping_assignments.{NUM}.shipping.address.entity_id	A unique identifier for the address entity.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.firstname	extension_attributes.shipping_assignments.{NUM}.shipping.address.firstname	The first name of the recipient at the shipping address.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.lastname	extension_attributes.shipping_assignments.{NUM}.shipping.address.lastname	The last name of the recipient for a specific shipping address within a shipping assignment.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.middlename	extension_attributes.shipping_assignments.{NUM}.shipping.address.middlename	The middle name of the recipient for the shipping address within a shipping assignment.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.parent_id	extension_attributes.shipping_assignments.{NUM}.shipping.address.parent_id	The ID of the parent entity associated with the shipping address within a shipping assignment.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.postcode	extension_attributes.shipping_assignments.{NUM}.shipping.address.postcode	The postal code for a specific shipping address within a shipping assignment.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.region_id	extension_attributes.shipping_assignments.{NUM}.shipping.address.region_id	The internal identifier for the region (state or province) for a specific shipping address.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.street.{NUM}	extension_attributes.shipping_assignments.{NUM}.shipping.address.street.{NUM}	A specific line of the street address for the shipping location.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.telephone	extension_attributes.shipping_assignments.{NUM}.shipping.address.telephone	The telephone number associated with the shipping address.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_id	extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_id	The Value Added Tax (VAT) identification number associated with the shipping address, used for tax calculation and compliance.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_is_valid	extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_is_valid	A flag indicating if the VAT ID provided for the shipping address within a shipping assignment is valid.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_request_success	extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_request_success	Indicates if the VAT ID validation request for the shipping address within a shipping assignment was successful.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.method	extension_attributes.shipping_assignments.{NUM}.shipping.method	The selected shipping method (e.g., ‘flatrate_flatrate’, ‘ups_ground’) for a particular shipping assignment.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_amount	extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_amount	The shipping amount for a specific shipping assignment in the store’s base currency, before any discounts or taxes.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_discount_amount	extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_discount_amount	The amount of discount applied to the shipping cost for a specific shipping assignment, in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_discount_tax_compensation_amnt	extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_discount_tax_compensation_amnt	The amount of tax compensation for shipping discounts in the store’s base currency. This adjusts tax calculation when discounts are applied.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_incl_tax	extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_incl_tax	The total shipping amount for a specific shipping assignment, including taxes, in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_invoiced	extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_invoiced	The amount of shipping cost that has been invoiced for a specific shipping assignment, in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_tax_amount	extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_tax_amount	The amount of tax applied to the shipping cost for a specific shipping assignment, in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_amount	extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_amount	The shipping amount for a specific shipping assignment in the display currency, before any discounts or taxes.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_discount_amount	extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_discount_amount	The amount of discount applied to the shipping cost for a specific shipping assignment, in the display currency.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_discount_tax_compensation_amount	extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_discount_tax_compensation_amount	The amount of tax compensation for shipping discounts in the order’s currency. This adjusts tax calculation when discounts are applied.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_incl_tax	extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_incl_tax	The total shipping amount for a specific shipping assignment, including taxes, in the display currency.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_invoiced	extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_invoiced	The amount of shipping cost that has been invoiced for a specific shipping assignment, in the display currency.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_tax_amount	extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_tax_amount	The amount of tax applied to the shipping cost for a specific shipping assignment, in the display currency.	metric
extension_attributes.taxes.{NUM}.amount	extension_attributes.taxes.{NUM}.amount	The calculated tax amount for a specific tax entry, in the display currency.	metric
extension_attributes.taxes.{NUM}.base_amount	extension_attributes.taxes.{NUM}.base_amount	The calculated tax amount for a specific tax entry, in the store’s base currency.	metric
extension_attributes.taxes.{NUM}.base_real_amount	extension_attributes.taxes.{NUM}.base_real_amount	The actual tax amount for a tax entry in the store’s base currency, after all adjustments.	metric
extension_attributes.taxes.{NUM}.code	extension_attributes.taxes.{NUM}.code	The code or identifier for a specific tax rule or class applied.	dimension
extension_attributes.taxes.{NUM}.order_id	extension_attributes.taxes.{NUM}.order_id	The ID of the order to which this tax entry applies.	dimension
extension_attributes.taxes.{NUM}.percent	extension_attributes.taxes.{NUM}.percent	The tax rate applied, expressed as a percentage.	metric
extension_attributes.taxes.{NUM}.position	extension_attributes.taxes.{NUM}.position	The display position or order for a tax entry.	metric
extension_attributes.taxes.{NUM}.priority	extension_attributes.taxes.{NUM}.priority	The priority level of the tax rule applied for a tax entry.	metric
extension_attributes.taxes.{NUM}.process	extension_attributes.taxes.{NUM}.process	Indicates the tax processing method or status for a tax entry.	metric
extension_attributes.taxes.{NUM}.tax_id	extension_attributes.taxes.{NUM}.tax_id	The unique identifier for the specific tax entry or tax rule applied.	dimension
extension_attributes.taxes.{NUM}.title	extension_attributes.taxes.{NUM}.title	The descriptive title or label for the tax applied (e.g., ‘Sales Tax’, ‘VAT’).	dimension
firstname	firstname	The first name of the customer.	dimension
gender	gender	The gender of the customer.	metric
global_currency_code	global_currency_code	The ISO 4217 currency code for the global base currency configured for the store.	dimension
grand_total	grand_total	The final total amount of the order, including all items, shipping, taxes, and discounts.	metric
group_id	group_id	The ID of the customer group to which the customer belongs.	dimension
id	id	The unique identifier for the entity (e.g., customer, order, product).	dimension
increment_id	increment_id	The human-readable increment ID (order number) of the order.	dimension
is_virtual	is_virtual	A boolean indicator specifying whether the product or item is virtual and does not require shipping.	metric
items.{NUM}.amount_refunded	items.{NUM}.amount_refunded	The total amount refunded for this specific order item in the display currency.	metric
items.{NUM}.applied_rule_ids	items.{NUM}.applied_rule_ids	A comma-separated list of IDs of the promotional rules that were applied to this order item.	dimension
items.{NUM}.base_amount_refunded	items.{NUM}.base_amount_refunded	The total amount refunded for this specific order item in the store’s base currency.	metric
items.{NUM}.base_cost	items.{NUM}.base_cost	The base cost of an individual item in the order.	metric
items.{NUM}.base_discount_amount	items.{NUM}.base_discount_amount	The discount amount applied to this order item in the store’s base currency.	metric
items.{NUM}.base_discount_invoiced	items.{NUM}.base_discount_invoiced	The amount of discount for this order item that has been invoiced, in the store’s base currency.	metric
items.{NUM}.base_discount_tax_compensation_amount	items.{NUM}.base_discount_tax_compensation_amount	The amount of tax compensation for an item’s discount in the store’s base currency. This adjusts tax calculation when discounts are applied.	metric
items.{NUM}.base_discount_tax_compensation_invoiced	items.{NUM}.base_discount_tax_compensation_invoiced	The invoiced amount of tax compensation for an item’s discount in the store’s base currency.	metric
items.{NUM}.base_original_price	items.{NUM}.base_original_price	The original price of the product associated with this order item, in the store’s base currency, before any special pricing or discounts.	metric
items.{NUM}.base_price	items.{NUM}.base_price	The price of the product associated with this order item, in the store’s base currency, after any special pricing but before item-level discounts.	metric
items.{NUM}.base_price_incl_tax	items.{NUM}.base_price_incl_tax	The price of the product associated with this order item, including taxes, in the store’s base currency.	metric
items.{NUM}.base_row_invoiced	items.{NUM}.base_row_invoiced	The total amount of the row (quantity * price) for this order item that has been invoiced, in the store’s base currency.	metric
items.{NUM}.base_row_total	items.{NUM}.base_row_total	The total amount of the row (quantity * price) for this order item, in the store’s base currency, before taxes and discounts.	metric
items.{NUM}.base_row_total_incl_tax	items.{NUM}.base_row_total_incl_tax	The total amount of the row (quantity * price) for this order item, including taxes, in the store’s base currency.	metric
items.{NUM}.base_tax_amount	items.{NUM}.base_tax_amount	The amount of tax applied to this order item, in the store’s base currency.	metric
items.{NUM}.base_tax_invoiced	items.{NUM}.base_tax_invoiced	The amount of tax for this order item that has been invoiced, in the store’s base currency.	metric
items.{NUM}.created_at	items.{NUM}.created_at	The timestamp indicating when this order item was created.	dimension
items.{NUM}.discount_amount	items.{NUM}.discount_amount	The discount amount applied to this order item in the display currency.	metric
items.{NUM}.discount_invoiced	items.{NUM}.discount_invoiced	The amount of discount for this order item that has been invoiced, in the display currency.	metric
items.{NUM}.discount_percent	items.{NUM}.discount_percent	The discount rate applied to this order item, expressed as a percentage.	metric
items.{NUM}.discount_tax_compensation_amount	items.{NUM}.discount_tax_compensation_amount	The amount of tax compensation for an item’s discount in the order’s currency. This adjusts tax calculation when discounts are applied.	metric
items.{NUM}.discount_tax_compensation_invoiced	items.{NUM}.discount_tax_compensation_invoiced	The invoiced amount of tax compensation for an item’s discount.	metric
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.amount	items.{NUM}.extension_attributes.itemized_taxes.{NUM}.amount	The amount for a specific itemized tax component applied to this order item, in the display currency.	metric
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.base_amount	items.{NUM}.extension_attributes.itemized_taxes.{NUM}.base_amount	The amount for a specific itemized tax component applied to this order item, in the store’s base currency.	metric
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.item_id	items.{NUM}.extension_attributes.itemized_taxes.{NUM}.item_id	The unique identifier of the order item to which this itemized tax component applies.	dimension
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_amount	items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_amount	The actual tax amount, after any adjustments, for a specific itemized tax applied to an order item.	metric
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_base_amount	items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_base_amount	The actual tax amount in the store’s base currency, after any adjustments, for a specific itemized tax applied to an order item.	metric
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_code	items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_code	The code or identifier for this specific itemized tax component.	metric
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_id	items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_id	The unique identifier for this specific itemized tax component.	dimension
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_item_id	items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_item_id	A unique identifier for the specific itemized tax entry on an order item.	dimension
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_percent	items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_percent	The tax rate applied for this specific itemized tax component, expressed as a percentage.	metric
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.taxable_item_type	items.{NUM}.extension_attributes.itemized_taxes.{NUM}.taxable_item_type	The type of item that is subject to this specific tax component (e.g., ‘product’, ‘shipping’).	dimension
items.{NUM}.free_shipping	items.{NUM}.free_shipping	A boolean indicator specifying if free shipping was applied specifically to this order item.	metric
items.{NUM}.is_qty_decimal	items.{NUM}.is_qty_decimal	A boolean indicator specifying whether the quantity for this particular order item can be a decimal value.	metric
items.{NUM}.is_virtual	items.{NUM}.is_virtual	A boolean indicator specifying whether this order item is virtual and does not require shipping.	metric
items.{NUM}.item_id	items.{NUM}.item_id	The unique identifier for this specific order item.	dimension
items.{NUM}.name	items.{NUM}.name	The name of the product associated with this order item.	dimension
items.{NUM}.no_discount	items.{NUM}.no_discount	A flag indicating whether a specific item is excluded from discount calculations.	metric
items.{NUM}.order_id	items.{NUM}.order_id	The unique identifier of the order to which this item belongs.	dimension
items.{NUM}.original_price	items.{NUM}.original_price	The original price of the product associated with this order item, in the display currency, before any special pricing or discounts.	metric
items.{NUM}.parent_item.amount_refunded	items.{NUM}.parent_item.amount_refunded	The total amount refunded for the parent item in the order currency.	metric
items.{NUM}.parent_item.applied_rule_ids	items.{NUM}.parent_item.applied_rule_ids	A comma-separated list of IDs of the pricing rules (e.g., cart price rules) applied to the parent item.	dimension
items.{NUM}.parent_item.base_amount_refunded	items.{NUM}.parent_item.base_amount_refunded	The total amount refunded for the parent item in the store’s base currency.	metric
items.{NUM}.parent_item.base_discount_amount	items.{NUM}.parent_item.base_discount_amount	The total discount amount applied to the parent item in the store’s base currency.	metric
items.{NUM}.parent_item.base_discount_invoiced	items.{NUM}.parent_item.base_discount_invoiced	The discounted amount that has been invoiced for the parent item in the store’s base currency.	metric
items.{NUM}.parent_item.base_discount_tax_compensation_amount	items.{NUM}.parent_item.base_discount_tax_compensation_amount	The amount of tax compensation for discounts applied to the parent item, in the store’s base currency.	metric
items.{NUM}.parent_item.base_discount_tax_compensation_invoiced	items.{NUM}.parent_item.base_discount_tax_compensation_invoiced	The amount of invoiced tax compensation for discounts applied to the parent item, in the store’s base currency.	metric
items.{NUM}.parent_item.base_original_price	items.{NUM}.parent_item.base_original_price	The original price of the parent item before any discounts, in the store’s base currency.	metric
items.{NUM}.parent_item.base_price	items.{NUM}.parent_item.base_price	The price of the parent item per unit, in the store’s base currency.	metric
items.{NUM}.parent_item.base_price_incl_tax	items.{NUM}.parent_item.base_price_incl_tax	The price of the parent item per unit, including tax, in the store’s base currency.	metric
items.{NUM}.parent_item.base_row_invoiced	items.{NUM}.parent_item.base_row_invoiced	The total invoiced amount for the parent item row (price * quantity) in the store’s base currency.	metric
items.{NUM}.parent_item.base_row_total	items.{NUM}.parent_item.base_row_total	The total amount for the parent item row (price * quantity) in the store’s base currency.	metric
items.{NUM}.parent_item.base_row_total_incl_tax	items.{NUM}.parent_item.base_row_total_incl_tax	The total amount for the parent item row (price * quantity), including tax, in the store’s base currency.	metric
items.{NUM}.parent_item.base_tax_amount	items.{NUM}.parent_item.base_tax_amount	The total tax amount applied to the parent item in the store’s base currency.	metric
items.{NUM}.parent_item.base_tax_invoiced	items.{NUM}.parent_item.base_tax_invoiced	The tax amount that has been invoiced for the parent item in the store’s base currency.	metric
items.{NUM}.parent_item.created_at	items.{NUM}.parent_item.created_at	The date and time when the parent item was created in the order.	dimension
items.{NUM}.parent_item.discount_amount	items.{NUM}.parent_item.discount_amount	The total discount amount applied to the parent item in the order currency.	metric
items.{NUM}.parent_item.discount_invoiced	items.{NUM}.parent_item.discount_invoiced	The discounted amount that has been invoiced for the parent item in the order currency.	metric
items.{NUM}.parent_item.discount_percent	items.{NUM}.parent_item.discount_percent	The percentage of discount applied to the parent item.	metric
items.{NUM}.parent_item.discount_tax_compensation_amount	items.{NUM}.parent_item.discount_tax_compensation_amount	The amount of tax compensation for discounts applied to the parent item, in the order currency.	metric
items.{NUM}.parent_item.discount_tax_compensation_invoiced	items.{NUM}.parent_item.discount_tax_compensation_invoiced	The amount of invoiced tax compensation for discounts applied to the parent item, in the order currency.	metric
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.amount	items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.amount	The amount of an itemized tax applied to a parent item within an order item.	metric
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.base_amount	items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.base_amount	The base currency amount of an itemized tax applied to a parent item within an order item.	metric
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.item_id	items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.item_id	The ID of the item to which this specific itemized tax applies, for a parent item within an order item.	dimension
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_amount	items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_amount	The actual amount of an itemized tax applied to a parent item within an order item.	metric
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_base_amount	items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_base_amount	The actual base currency amount of an itemized tax applied to a parent item within an order item.	metric
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_code	items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_code	The tax code associated with this itemized tax on a parent item within an order item.	metric
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_id	items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_id	The unique identifier for this itemized tax on a parent item within an order item.	dimension
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_item_id	items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_item_id	The unique identifier for the tax item record associated with a parent item within an order item.	dimension
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_percent	items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_percent	The tax rate percentage for this itemized tax on a parent item within an order item.	metric
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.taxable_item_type	items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.taxable_item_type	The type of item that this itemized tax applies to (e.g., product, shipping), for a parent item within an order item.	dimension
items.{NUM}.parent_item.free_shipping	items.{NUM}.parent_item.free_shipping	Indicates whether free shipping was applied to the parent item (0 for no, 1 for yes).	metric
items.{NUM}.parent_item.is_qty_decimal	items.{NUM}.parent_item.is_qty_decimal	Indicates if the quantity of the parent item can be expressed as a decimal (0 for no, 1 for yes).	metric
items.{NUM}.parent_item.is_virtual	items.{NUM}.parent_item.is_virtual	Indicates if the parent item is a virtual product (0 for no, 1 for yes).	metric
items.{NUM}.parent_item.item_id	items.{NUM}.parent_item.item_id	The unique identifier of the parent item within the order.	dimension
items.{NUM}.parent_item.name	items.{NUM}.parent_item.name	The name of the parent item.	dimension
items.{NUM}.parent_item.no_discount	items.{NUM}.parent_item.no_discount	Indicates whether the parent item is excluded from discounts (0 for no, 1 for yes).	metric
items.{NUM}.parent_item.order_id	items.{NUM}.parent_item.order_id	The ID of the order to which this parent item belongs.	dimension
items.{NUM}.parent_item.original_price	items.{NUM}.parent_item.original_price	The original price of the parent item before any discounts, in the order currency.	metric
items.{NUM}.parent_item.price	items.{NUM}.parent_item.price	The price of the parent item per unit, in the order currency.	metric
items.{NUM}.parent_item.price_incl_tax	items.{NUM}.parent_item.price_incl_tax	The price of the parent item per unit, including tax, in the order currency.	metric
items.{NUM}.parent_item.product_id	items.{NUM}.parent_item.product_id	The unique identifier of the product associated with this parent item.	dimension
items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_id	items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_id	The identifier for a selected option within a bundle product, associated with a parent item in the order.	dimension
items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_qty	items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_qty	The quantity of a selected option within a bundle product, associated with a parent item in the order.	metric
items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM}	items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM}	A specific selection made for an option within a bundle product, associated with a parent item in the order.	metric
items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_id	items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_id	The ID of a configurable option selected for the parent item.	dimension
items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value	items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value	The selected value for a configurable option of the parent item.	metric
items.{NUM}.parent_item.product_type	items.{NUM}.parent_item.product_type	The type of product for the parent item (e.g., ‘simple’, ‘configurable’, ‘bundle’).	dimension
items.{NUM}.parent_item.qty_canceled	items.{NUM}.parent_item.qty_canceled	The quantity of the parent item that has been canceled.	metric
items.{NUM}.parent_item.qty_invoiced	items.{NUM}.parent_item.qty_invoiced	The quantity of the parent item that has been invoiced.	metric
items.{NUM}.parent_item.qty_ordered	items.{NUM}.parent_item.qty_ordered	The quantity of the parent item that was originally ordered.	metric
items.{NUM}.parent_item.qty_refunded	items.{NUM}.parent_item.qty_refunded	The quantity of the parent item that has been refunded.	metric
items.{NUM}.parent_item.qty_returned	items.{NUM}.parent_item.qty_returned	The quantity of the parent item that has been returned.	metric
items.{NUM}.parent_item.qty_shipped	items.{NUM}.parent_item.qty_shipped	The quantity of the parent item that has been shipped.	metric
items.{NUM}.parent_item.quote_item_id	items.{NUM}.parent_item.quote_item_id	The ID of the quote item from which this parent item originated.	dimension
items.{NUM}.parent_item.row_invoiced	items.{NUM}.parent_item.row_invoiced	The total invoiced amount for the parent item row (price * quantity) in the order currency.	metric
items.{NUM}.parent_item.row_total	items.{NUM}.parent_item.row_total	The total amount for the parent item row (price * quantity) in the order currency.	metric
items.{NUM}.parent_item.row_total_incl_tax	items.{NUM}.parent_item.row_total_incl_tax	The total amount for the parent item row (price * quantity), including tax, in the order currency.	metric
items.{NUM}.parent_item.row_weight	items.{NUM}.parent_item.row_weight	The total weight of the parent item row (weight * quantity).	metric
items.{NUM}.parent_item.sku	items.{NUM}.parent_item.sku	The Stock Keeping Unit (SKU) of the parent product.	dimension
items.{NUM}.parent_item.store_id	items.{NUM}.parent_item.store_id	The ID of the store where the parent item was ordered.	dimension
items.{NUM}.parent_item.tax_amount	items.{NUM}.parent_item.tax_amount	The total tax amount applied to the parent item in the order currency.	metric
items.{NUM}.parent_item.tax_invoiced	items.{NUM}.parent_item.tax_invoiced	The tax amount that has been invoiced for the parent item in the order currency.	metric
items.{NUM}.parent_item.tax_percent	items.{NUM}.parent_item.tax_percent	The tax percentage applied to the parent item.	metric
items.{NUM}.parent_item.updated_at	items.{NUM}.parent_item.updated_at	The date and time when this parent item was last updated.	dimension
items.{NUM}.parent_item.weee_tax_applied	items.{NUM}.parent_item.weee_tax_applied	Details of any WEEE (Waste Electrical and Electronic Equipment) tax applied to the parent order item.	dimension
items.{NUM}.parent_item.weight	items.{NUM}.parent_item.weight	The weight of the individual parent item.	metric
items.{NUM}.parent_item_id	items.{NUM}.parent_item_id	The ID of the parent item if this is a child item in a configurable or bundle product.	dimension
items.{NUM}.price	items.{NUM}.price	The price of the product associated with this order item, in the display currency, after any special pricing but before item-level discounts.	metric
items.{NUM}.price_incl_tax	items.{NUM}.price_incl_tax	The price of the product associated with this order item, including taxes, in the display currency.	metric
items.{NUM}.product_id	items.{NUM}.product_id	The unique identifier of the product from the catalog that this order item represents.	dimension
items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_id	items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_id	The identifier for a selected option within a bundle product, associated with an item in the order.	dimension
items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_qty	items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_qty	The quantity of a selected option within a bundle product, associated with an item in the order.	metric
items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM}	items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM}	A specific selection made for an option within a bundle product, associated with an item in the order.	metric
items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_id	items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_id	The unique identifier for a specific configurable product option selected for this order item.	dimension
items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_value	items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_value	The selected value for a specific configurable product option applied to this order item.	metric
items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_id	items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_id	The ID of a custom option selected for a product within an order item.	dimension
items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_value	items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_value	The selected value for a custom option of a product within an order item.	metric
items.{NUM}.product_type	items.{NUM}.product_type	The type of product (e.g., simple, configurable, virtual, bundle) that this order item represents.	dimension
items.{NUM}.qty_backordered	items.{NUM}.qty_backordered	The quantity of the individual item that is currently on backorder.	metric
items.{NUM}.qty_canceled	items.{NUM}.qty_canceled	The quantity of this order item that has been canceled.	metric
items.{NUM}.qty_invoiced	items.{NUM}.qty_invoiced	The quantity of this order item that has been invoiced.	metric
items.{NUM}.qty_ordered	items.{NUM}.qty_ordered	The original quantity of this product ordered as part of the order item.	metric
items.{NUM}.qty_refunded	items.{NUM}.qty_refunded	The quantity of this order item that has been refunded.	metric
items.{NUM}.qty_returned	items.{NUM}.qty_returned	The quantity of this order item that has been returned by the customer.	metric
items.{NUM}.qty_shipped	items.{NUM}.qty_shipped	The quantity of this order item that has been shipped.	metric
items.{NUM}.quote_item_id	items.{NUM}.quote_item_id	The unique identifier for the original quote item from which this order item was created.	dimension
items.{NUM}.row_invoiced	items.{NUM}.row_invoiced	The total amount of the row (quantity * price) for this order item that has been invoiced, in the display currency.	metric
items.{NUM}.row_total	items.{NUM}.row_total	The total amount of the row (quantity * price) for this order item, in the display currency, before taxes and discounts.	metric
items.{NUM}.row_total_incl_tax	items.{NUM}.row_total_incl_tax	The total amount of the row (quantity * price) for this order item, including taxes, in the display currency.	metric
items.{NUM}.row_weight	items.{NUM}.row_weight	The total weight of this order item, calculated as unit weight multiplied by the ordered quantity.	metric
items.{NUM}.sku	items.{NUM}.sku	The Stock Keeping Unit (SKU) of the product associated with this order item.	dimension
items.{NUM}.store_id	items.{NUM}.store_id	The unique identifier of the store from which this order item was purchased.	dimension
items.{NUM}.tax_amount	items.{NUM}.tax_amount	The amount of tax applied to this order item, in the display currency.	metric
items.{NUM}.tax_invoiced	items.{NUM}.tax_invoiced	The amount of tax for this order item that has been invoiced, in the display currency.	metric
items.{NUM}.tax_percent	items.{NUM}.tax_percent	The tax rate applied to this order item, expressed as a percentage.	metric
items.{NUM}.updated_at	items.{NUM}.updated_at	The date and time when this specific order item was last updated.	dimension
items.{NUM}.weee_tax_applied	items.{NUM}.weee_tax_applied	Details of any WEEE (Waste Electrical and Electronic Equipment) tax applied to this order item.	dimension
items.{NUM}.weight	items.{NUM}.weight	The weight of the individual order item.	metric
lastname	lastname	The last name of the customer.	dimension
order_currency_code	order_currency_code	The currency code used for the order.	dimension
original_increment_id	original_increment_id	The customer-facing identifier for the original order or entity.	dimension
parent_item.base_discount_tax_compensation_amount	parent_item.base_discount_tax_compensation_amount	The base currency amount of tax compensation applied due to discount for a parent item.	metric
parent_item.base_discount_tax_compensation_invoiced	parent_item.base_discount_tax_compensation_invoiced	The invoiced base currency amount of tax compensation for a parent item’s discount.	metric
parent_item.discount_tax_compensation_amount	parent_item.discount_tax_compensation_amount	The tax compensation amount for the discount applied to the parent order item.	metric
parent_item.discount_tax_compensation_canceled	parent_item.discount_tax_compensation_canceled	This field indicates the tax amount compensated or adjusted due to discounts specifically for a parent item of a product (e.g., in a configurable or grouped product) that was part of a canceled order or item.	metric
parent_item.discount_tax_compensation_invoiced	parent_item.discount_tax_compensation_invoiced	The invoiced amount of tax compensation for a parent item’s discount.	metric
parent_item.tax_canceled	parent_item.tax_canceled	The canceled tax amount for a parent item.	metric
parent_item.tax_percent	parent_item.tax_percent	The tax percentage applied to the parent order item.	metric
payment.account_status	payment.account_status	The status of the payment account used for the order (e.g., ‘verified’).	dimension
payment.additional_information.{NUM}	payment.additional_information.{NUM}	Additional information related to the payment method, which can vary by payment gateway.	dimension
payment.amount_ordered	payment.amount_ordered	The total amount of the order in the order currency.	metric
payment.amount_paid	payment.amount_paid	The amount that has been paid for the order in the order currency.	metric
payment.base_amount_ordered	payment.base_amount_ordered	The total amount of the order in the store’s base currency.	metric
payment.base_amount_paid	payment.base_amount_paid	The amount that has been paid for the order in the store’s base currency.	metric
payment.base_shipping_amount	payment.base_shipping_amount	The base shipping amount for the order in the store’s base currency.	metric
payment.base_shipping_captured	payment.base_shipping_captured	The base shipping amount that has been captured for the order in the store’s base currency.	metric
payment.cc_exp_year	payment.cc_exp_year	The expiration year of the credit card used for payment (if applicable and available).	metric
payment.cc_last4	payment.cc_last4	The last four digits of the credit card number used for payment (if applicable and available).	dimension
payment.cc_ss_start_month	payment.cc_ss_start_month	Represents the start month of a credit card’s ‘Switch/Solo’ issue number. This field is deprecated and no longer actively used in Magento’s API.	metric
payment.cc_ss_start_year	payment.cc_ss_start_year	The starting year of the credit card’s validity period. This field is part of the payment information and is used for validating the credit card’s issue date, often for specific credit card types or payment processing requirements.	metric
payment.entity_id	payment.entity_id	The unique identifier for the payment record.	dimension
payment.extension_attributes.vault_payment_token.gateway_token	payment.extension_attributes.vault_payment_token.gateway_token	The token provided by the payment gateway for the vaulted payment method.	metric
payment.method	payment.method	The payment method used for the order (e.g., ‘checkmo’, ‘paypal_express’).	dimension
payment.parent_id	payment.parent_id	The ID of the order entity associated with this payment record.	dimension
payment.po_number	payment.po_number	The Purchase Order (PO) number associated with the payment for the order.	dimension
payment.shipping_amount	payment.shipping_amount	The shipping amount for the order in the order currency.	metric
payment.shipping_captured	payment.shipping_captured	The shipping amount that has been captured for the order in the order currency.	metric
quote_id	quote_id	The ID of the quote (shopping cart) from which this order was created.	dimension
shipping_amount	shipping_amount	The shipping amount for the order in the order currency.	metric
shipping_description	shipping_description	A description of the shipping method used for the order (e.g., ‘Flat Rate - Fixed’).	dimension
shipping_discount_amount	shipping_discount_amount	The discount amount applied to shipping for the order.	metric
shipping_discount_tax_compensation_amount	shipping_discount_tax_compensation_amount	The amount of tax compensation for shipping discounts applied to the order.	metric
shipping_incl_tax	shipping_incl_tax	The shipping amount for the order, including tax, in the order currency.	metric
shipping_invoiced	shipping_invoiced	The shipping amount that has been invoiced for the order.	metric
shipping_tax_amount	shipping_tax_amount	The tax amount applied to shipping for the order.	metric
state	state	The current state of the order (e.g., ‘new’, ‘pending_payment’, ‘processing’, ‘complete’).	dimension
status	status	The current status of the order (e.g., ‘pending’, ‘processing’, ‘complete’, ‘closed’).	dimension
status_histories.{NUM}.comment	status_histories.{NUM}.comment	A comment associated with a specific status update in the order history.	dimension
status_histories.{NUM}.created_at	status_histories.{NUM}.created_at	The date and time when this status history entry was created.	dimension
status_histories.{NUM}.entity_id	status_histories.{NUM}.entity_id	The ID of the status history entry.	dimension
status_histories.{NUM}.entity_name	status_histories.{NUM}.entity_name	The type of entity this status history entry belongs to (e.g., ‘order’).	dimension
status_histories.{NUM}.is_customer_notified	status_histories.{NUM}.is_customer_notified	Indicates whether the customer was notified about this status update (0 for no, 1 for yes).	metric
status_histories.{NUM}.is_visible_on_front	status_histories.{NUM}.is_visible_on_front	Indicates whether this status update is visible on the storefront to the customer (0 for no, 1 for yes).	metric
status_histories.{NUM}.parent_id	status_histories.{NUM}.parent_id	The ID of the parent entity (e.g., the order ID) for this status history entry.	dimension
status_histories.{NUM}.status	status_histories.{NUM}.status	The status associated with this history entry.	dimension
store_currency_code	store_currency_code	The default currency code of the store.	dimension
store_id	store_id	The ID of the store where the order was placed.	dimension
store_name	store_name	The name of the store where the order was placed.	dimension
store_to_base_rate	store_to_base_rate	The currency conversion rate from the store’s display currency to its base currency.	metric
store_to_order_rate	store_to_order_rate	The currency conversion rate from the store’s display currency to the order’s currency.	metric
subtotal	subtotal	The subtotal of the order before shipping and tax, in the order currency.	metric
subtotal_incl_tax	subtotal_incl_tax	The subtotal of the order, including tax, before shipping, in the order currency.	metric
subtotal_invoiced	subtotal_invoiced	The subtotal amount that has been invoiced for the order.	metric
tax_amount	tax_amount	The amount of tax applied to an item or the entire order/invoice.	metric
tax_canceled	tax_canceled	The amount of tax that was canceled for the order or an item.	metric
tax_invoiced	tax_invoiced	The amount of tax that has been invoiced for the order or an item.	metric
tax_percent	tax_percent	The tax rate applied as a percentage for a specific item.	metric
total_due	total_due	The remaining amount due for the order.	metric
total_invoiced	total_invoiced	The total monetary amount of the order that has been invoiced.	metric
total_item_count	total_item_count	The total count of unique items in the order.	metric
total_paid	total_paid	The total monetary amount that has been paid by the customer for the order.	metric
total_qty_ordered	total_qty_ordered	The total quantity of all products ordered.	metric
updated_at	updated_at	The date and time when the entity (e.g., customer, order, product) was last updated.	dimension
website_id	website_id	The ID of the website where the entity (e.g., customer, order) was created or belongs.	dimension
weight	weight	The weight of the item or product.	metric