Magento Advanced Reporting: Most-used fields

The table below gives information about most-used fields that you can import from Magento Advanced Reporting. 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
Month	Month	The month when the event occurred, derived from date fields for reporting.	dimension
Year	Year	The year when the event occurred, derived from date fields for reporting.	metric
added_at	added_at	The timestamp indicating when an item was added, e.g., to a wishlist or cart.	dimension
addresses.{NUM}.city	addresses.{NUM}.city	The city component of a 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 ISO 2-letter country code for the customer’s address.	dimension
addresses.{NUM}.customer_id	addresses.{NUM}.customer_id	The unique identifier of the customer to whom this address belongs.	dimension
addresses.{NUM}.default_billing	addresses.{NUM}.default_billing	Indicates whether this is the customer’s default billing address.	dimension
addresses.{NUM}.default_shipping	addresses.{NUM}.default_shipping	Indicates whether this is the customer’s default shipping address.	dimension
addresses.{NUM}.firstname	addresses.{NUM}.firstname	The first name associated with the customer’s address.	dimension
addresses.{NUM}.id	addresses.{NUM}.id	The unique identifier for this specific customer address entry.	metric
addresses.{NUM}.lastname	addresses.{NUM}.lastname	The last name associated with the customer’s address.	dimension
addresses.{NUM}.postcode	addresses.{NUM}.postcode	The postal code or ZIP code for the customer’s address.	dimension
addresses.{NUM}.region.region	addresses.{NUM}.region.region	The full name of the region or state for the customer’s address.	dimension
addresses.{NUM}.region.region_code	addresses.{NUM}.region.region_code	The short code for the region or state of the customer’s address.	dimension
addresses.{NUM}.region.region_id	addresses.{NUM}.region.region_id	The unique identifier for the region or state of the customer’s address.	dimension
addresses.{NUM}.region_id	addresses.{NUM}.region_id	The unique identifier for the region or state of the customer’s address. This is a direct reference to the region ID.	dimension
addresses.{NUM}.street.{NUM}	addresses.{NUM}.street.{NUM}	A specific line of the street address for the customer. Addresses can have multiple street lines.	dimension
addresses.{NUM}.telephone	addresses.{NUM}.telephone	The telephone number associated with the customer’s address.	dimension
addresses.{NUM}.vat_id	addresses.{NUM}.vat_id	The Value Added Tax (VAT) identification number associated with the customer’s address, often used for business customers.	dimension
amount_refunded	amount_refunded	The total amount refunded for an order item in the store’s current currency.	metric
attribute_set_id	attribute_set_id	The unique identifier for the attribute set assigned to a product, which defines its available attributes.	dimension
base_amount_refunded	base_amount_refunded	The total amount refunded for an order item in the store’s base currency.	metric
base_cost	base_cost	The cost of an item or order in the store’s base currency.	metric
base_currency_code	base_currency_code	The ISO 4217 currency code of the store’s base currency.	dimension
base_discount_amount	base_discount_amount	The total discount amount applied to an item or order in the store’s base currency.	metric
base_discount_canceled	base_discount_canceled	The amount of discount that was canceled for an item or order, in the store’s base currency.	metric
base_discount_invoiced	base_discount_invoiced	The amount of discount that has been invoiced for an item or order, in the store’s base currency.	metric
base_discount_tax_compensation_amount	base_discount_tax_compensation_amount	The amount of tax compensation for discounts applied to an item or order, in the store’s base currency.	metric
base_discount_tax_compensation_invoiced	base_discount_tax_compensation_invoiced	The amount of tax compensation for discounts that has been invoiced for an item or order, in the store’s base currency.	metric
base_grand_total	base_grand_total	The grand total amount of an order, including tax and shipping, in the store’s base currency.	metric
base_original_price	base_original_price	The original price of a product or item before any discounts, in the store’s base currency.	metric
base_price	base_price	The unit price of a product or item in the store’s base currency.	metric
base_price_incl_tax	base_price_incl_tax	The unit price of a product or item including tax, in the store’s base currency.	metric
base_row_invoiced	base_row_invoiced	The total amount of an order item’s row that has been invoiced, in the store’s base currency.	metric
base_row_total	base_row_total	The total amount of an order item’s row (quantity multiplied by price), excluding tax and discounts, in the store’s base currency.	metric
base_row_total_incl_tax	base_row_total_incl_tax	The total amount of an order item’s row (quantity multiplied by price) including tax, in the store’s base currency.	metric
base_shipping_amount	base_shipping_amount	The shipping amount for an order in the store’s base currency.	metric
base_shipping_canceled	base_shipping_canceled	The amount of shipping costs that were canceled for an order, in the store’s base currency.	metric
base_shipping_discount_amount	base_shipping_discount_amount	The shipping discount amount for an order in the store’s base currency.	metric
base_shipping_discount_tax_compensation_amnt	base_shipping_discount_tax_compensation_amnt	The amount of tax compensation for shipping discounts applied to an order, in the store’s base currency.	metric
base_shipping_incl_tax	base_shipping_incl_tax	The shipping amount for an order including tax, in the store’s base currency.	metric
base_shipping_invoiced	base_shipping_invoiced	The amount of shipping costs that have been invoiced for an order, in the store’s base currency.	metric
base_shipping_tax_amount	base_shipping_tax_amount	The tax amount applied to shipping costs for an order in the store’s base currency.	metric
base_subtotal	base_subtotal	The subtotal amount of an order before shipping and tax, in the store’s base currency.	metric
base_subtotal_canceled	base_subtotal_canceled	The subtotal amount that was canceled for an order, in the store’s base currency.	metric
base_subtotal_incl_tax	base_subtotal_incl_tax	The subtotal amount of an order including tax, before shipping, in the store’s base currency.	metric
base_subtotal_invoiced	base_subtotal_invoiced	The subtotal amount that has been invoiced for an order, in the store’s base currency.	metric
base_tax_amount	base_tax_amount	The total tax amount for an order in the store’s base currency.	metric
base_tax_canceled	base_tax_canceled	The tax amount that was canceled for an order, in the store’s base currency.	metric
base_tax_invoiced	base_tax_invoiced	The tax amount that has been invoiced for an order, in the store’s base currency.	metric
base_to_global_rate	base_to_global_rate	The currency conversion rate from the store’s base currency to the global currency.	metric
base_to_order_rate	base_to_order_rate	The currency conversion rate from the store’s base currency to the order’s currency.	metric
base_total_canceled	base_total_canceled	The total amount of an order that was canceled, in the store’s base currency.	metric
base_total_due	base_total_due	The remaining total amount due for an order, in the store’s base currency.	metric
base_total_invoiced	base_total_invoiced	The total amount that has been invoiced for an order, in the store’s base currency.	metric
base_total_invoiced_cost	base_total_invoiced_cost	The total cost of the items that have been invoiced, expressed in the store’s base currency. This field is related to sales and order data.	metric
base_total_offline_refunded	base_total_offline_refunded	The total monetary amount refunded for an order through an offline payment method.	metric
base_total_online_refunded	base_total_online_refunded	The total monetary amount refunded for an order processed through an online payment system.	metric
base_total_paid	base_total_paid	The total amount that has been paid for an order, in the store’s base currency.	metric
base_total_refunded	base_total_refunded	The aggregated total monetary amount refunded for an order, including both online and offline transactions.	metric
billing_address.address_type	billing_address.address_type	The type of address, for example, ‘billing’ or ‘shipping’.	dimension
billing_address.city	billing_address.city	The city component of the billing address for the order.	dimension
billing_address.company	billing_address.company	The company name associated with the billing address for the order.	dimension
billing_address.country_id	billing_address.country_id	The ISO 2-letter country code for the billing address of the order.	dimension
billing_address.customer_address_id	billing_address.customer_address_id	The unique identifier of the customer’s address record if this billing address is linked to a stored customer 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 this specific billing address entry.	dimension
billing_address.firstname	billing_address.firstname	The first name on the billing address for the order.	dimension
billing_address.lastname	billing_address.lastname	The last name on the billing address for the order.	dimension
billing_address.parent_id	billing_address.parent_id	The identifier of the entity (e.g., order or quote) that the billing address is associated with.	dimension
billing_address.postcode	billing_address.postcode	The postal code or ZIP code for the billing address of the order.	dimension
billing_address.region	billing_address.region	The full name of the region or state for the billing address of the order.	dimension
billing_address.region_code	billing_address.region_code	The short code for the region or state of the billing address of the order.	dimension
billing_address.region_id	billing_address.region_id	The unique identifier for the region or state of the billing address of the order.	dimension
billing_address.street.{NUM}	billing_address.street.{NUM}	A specific line of the street address for the billing address. Addresses can have multiple street lines.	dimension
billing_address.telephone	billing_address.telephone	The telephone number associated with the billing address.	dimension
billing_address.vat_id	billing_address.vat_id	The Value Added Tax (VAT) identification number associated with the billing address.	dimension
billing_address.vat_is_valid	billing_address.vat_is_valid	Indicates whether the Value Added Tax (VAT) identification number provided in the billing address has been validated successfully.	metric
billing_address.vat_request_date	billing_address.vat_request_date	The date when the VAT identification number validation request for the billing address was made.	dimension
billing_address.vat_request_id	billing_address.vat_request_id	The identifier for the VAT identification number validation request made for the billing address.	dimension
billing_address.vat_request_success	billing_address.vat_request_success	Indicates the success status of the VAT identification number validation request for the billing address.	metric
billing_address_id	billing_address_id	The unique identifier of the billing address associated with an order or customer.	dimension
can_void_flag	can_void_flag	A boolean flag indicating whether an authorized payment transaction can be voided before the funds are captured.	metric
converted_at	converted_at	The timestamp indicating when a quote or wishlist was converted into an order.	dimension
coupon_code	coupon_code	The specific code applied to an order or cart to provide a discount, typically linked to a cart price rule.	dimension
created_at	created_at	The timestamp indicating when the record (e.g., order, customer, product) was created. Format: YYYY-MM-DD HH:MM:SS.	dimension
created_in	created_in	The name of the store view or system where the record was created.	dimension
custom_attributes.{NUM}.attribute_code	custom_attributes.{NUM}.attribute_code	The unique code identifying a custom attribute. Custom attributes allow merchants to extend standard Magento entities with additional data fields.	dimension
custom_attributes.{NUM}.value	custom_attributes.{NUM}.value	The value associated with the custom attribute. The data type and format depend on the custom attribute’s definition.	dimension
custom_attributes.{NUM}.value.{NUM}	custom_attributes.{NUM}.value.{NUM}	The value of a custom attribute, which allows for extending Magento entities with additional, user-defined data fields.	metric
customer_dob	customer_dob	The customer’s date of birth.	dimension
customer_email	customer_email	The email address of the customer.	dimension
customer_firstname	customer_firstname	The first name of the customer.	dimension
customer_group_id	customer_group_id	The unique identifier 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	Indicates whether the customer placed the order as a guest (true) or a registered user (false).	metric
customer_lastname	customer_lastname	The last name of the customer.	dimension
customer_note_notify	customer_note_notify	A flag indicating whether the customer will receive an email notification regarding a new note or comment added to their order.	metric
date	date	The date and time when a specific record or entity, such as an order or a report entry, was created or last updated.	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	A flag that, when active, prevents the automatic reassignment of a customer to a different customer group.	metric
discount_amount	discount_amount	The total discount amount applied to an item or order in the store’s current currency.	metric
discount_canceled	discount_canceled	The amount of discount that was canceled for an item or order, in the store’s current currency.	metric
discount_invoiced	discount_invoiced	The amount of discount that has been invoiced for an item or order, in the store’s current currency.	metric
discount_percent	discount_percent	The percentage of discount applied to an item or order.	metric
discount_tax_compensation_amount	discount_tax_compensation_amount	The amount of tax compensation for discounts applied to an item or order, in the store’s current currency.	metric
discount_tax_compensation_canceled	discount_tax_compensation_canceled	The amount of tax compensation for discounts that was canceled for an item or order, in the store’s current currency.	metric
discount_tax_compensation_invoiced	discount_tax_compensation_invoiced	The amount of tax compensation for discounts that has been invoiced for an item or order, in the store’s current currency.	metric
dob	dob	The customer’s date of birth.	dimension
email	email	The email address of the customer.	dimension
email_sent	email_sent	Indicates whether an email notification related to the order or customer was sent.	metric
entity_id	entity_id	The unique identifier for the entity (e.g., customer, order, product).	dimension
extension_attributes.applied_taxes.{NUM}.amount	extension_attributes.applied_taxes.{NUM}.amount	The amount of a specific tax applied to an item or order, in the store’s current currency.	metric
extension_attributes.applied_taxes.{NUM}.base_amount	extension_attributes.applied_taxes.{NUM}.base_amount	The amount of a specific tax applied to an item or order, in the store’s base currency.	metric
extension_attributes.applied_taxes.{NUM}.code	extension_attributes.applied_taxes.{NUM}.code	The code identifying a specific tax applied.	dimension
extension_attributes.applied_taxes.{NUM}.percent	extension_attributes.applied_taxes.{NUM}.percent	The percentage rate of a specific tax applied.	metric
extension_attributes.applied_taxes.{NUM}.title	extension_attributes.applied_taxes.{NUM}.title	The display title or name of a specific tax applied.	dimension
extension_attributes.category_links.{NUM}.category_id	extension_attributes.category_links.{NUM}.category_id	The unique identifier of a category linked to a product.	dimension
extension_attributes.category_links.{NUM}.position	extension_attributes.category_links.{NUM}.position	The position of a product within a linked category.	metric
extension_attributes.configurable_product_links.{NUM}	extension_attributes.configurable_product_links.{NUM}	A unique identifier for a simple product linked to a configurable product.	metric
extension_attributes.configurable_product_options.{NUM}.attribute_id	extension_attributes.configurable_product_options.{NUM}.attribute_id	The unique identifier of the attribute used for a configurable product option.	dimension
extension_attributes.configurable_product_options.{NUM}.id	extension_attributes.configurable_product_options.{NUM}.id	The unique identifier for a specific configurable product option.	metric
extension_attributes.configurable_product_options.{NUM}.label	extension_attributes.configurable_product_options.{NUM}.label	The display label for a configurable product option, e.g., ‘Color’ or ‘Size’.	dimension
extension_attributes.configurable_product_options.{NUM}.position	extension_attributes.configurable_product_options.{NUM}.position	The display order or position of a configurable product option.	metric
extension_attributes.configurable_product_options.{NUM}.product_id	extension_attributes.configurable_product_options.{NUM}.product_id	The unique identifier of the configurable product to which this option belongs.	dimension
extension_attributes.configurable_product_options.{NUM}.values.{NUM}.value_index	extension_attributes.configurable_product_options.{NUM}.values.{NUM}.value_index	The index or ID of a specific value for a configurable product option.	metric
extension_attributes.converting_from_quote	extension_attributes.converting_from_quote	An extension attribute indicating if an order originated from the conversion of a customer’s shopping cart (quote).	dimension
extension_attributes.is_subscribed	extension_attributes.is_subscribed	Indicates whether the customer is subscribed to newsletters or marketing communications.	dimension
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.amount	extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.amount	The amount of a specific tax applied to an individual item, in the store’s current currency.	metric
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.base_amount	extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.base_amount	The amount of a specific tax applied to an individual item, in the store’s base currency.	metric
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.code	extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.code	The code identifying a specific tax applied to an individual item.	dimension
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.percent	extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.percent	The percentage rate of a specific tax applied to an individual item.	metric
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.title	extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.title	The display title or name of a specific tax applied to an individual item.	dimension
extension_attributes.item_applied_taxes.{NUM}.item_id	extension_attributes.item_applied_taxes.{NUM}.item_id	The unique identifier of the order item to which these taxes are applied.	dimension
extension_attributes.item_applied_taxes.{NUM}.type	extension_attributes.item_applied_taxes.{NUM}.type	The type of tax applied to a specific item within the order, found in extension attributes.	dimension
extension_attributes.payment_additional_info.{NUM}.key	extension_attributes.payment_additional_info.{NUM}.key	A key for additional information provided by the payment method.	dimension
extension_attributes.payment_additional_info.{NUM}.value	extension_attributes.payment_additional_info.{NUM}.value	The value associated with a key for additional payment method information.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.amount_refunded	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.amount_refunded	The amount refunded for a specific item within a shipping assignment, in the store’s current currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_amount_refunded	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_amount_refunded	The amount refunded for a specific item within a shipping assignment, 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 product for this order item.	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 a specific item within a shipping assignment, 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 invoiced discount amount for a specific item within a shipping assignment, 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 tax compensation amount for discounts on a specific item within a shipping assignment, 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 invoiced tax compensation amount for discounts on a specific item within a shipping assignment, 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 a specific item within a shipping assignment, 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 price of a specific item within a shipping assignment, in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_price_incl_tax	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_price_incl_tax	The price of a specific item including tax within a shipping assignment, in the store’s base currency.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_invoiced	The invoiced row total for a specific item within a shipping assignment, 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 row total for a specific item within a shipping assignment, 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 row total including tax for a specific item within a shipping assignment, 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 tax amount for a specific item within a shipping assignment, 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 invoiced tax amount for a specific item within a shipping assignment, 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 timestamp indicating when a specific item within a shipping assignment was created. Format: YYYY-MM-DD HH:MM:SS.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_amount	The discount amount applied to a specific item within a shipping assignment, in the store’s current 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 specific order item.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_percent	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_percent	The discount percentage applied to this order 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 tax amount compensated for the discount applied to this order item.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_canceled	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_canceled	The tax compensation amount for discounts that has been canceled for this order item.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_invoiced	The tax compensation amount for discounts that has been invoiced for this order item.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.free_shipping	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.free_shipping	Indicates whether free shipping is applied to this order item (0 for no, 1 for yes).	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_qty_decimal	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_qty_decimal	Indicates if the item quantity can be a decimal value.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_virtual	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_virtual	Indicates whether the order item is a virtual product (e.g., service, downloadable product).	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.item_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.item_id	The unique identifier of the order item.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.name	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.name	The name of the product associated with this order item.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.no_discount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.no_discount	Indicates whether discounts are not applicable to this order item.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.order_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.order_id	The unique identifier of the order to which this item belongs.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.original_price	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.original_price	The original price of the product before any discounts or special pricing.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.amount_refunded	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.amount_refunded	The total amount refunded for the parent item in the order currency.	metric
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 total amount refunded for the parent item in the 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 base currency discount amount applied to the parent item.	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 base currency discount amount that has been invoiced for the parent item.	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 base currency tax compensation amount for discounts applied to the parent item.	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 base currency tax compensation amount for discounts that has been invoiced for the parent item.	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 base currency original price of the parent product before any discounts.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_price	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_price	The base currency unit price of the parent product after any discounts.	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 base currency unit price of the parent product including tax.	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 base currency total row amount that has been invoiced for the parent item.	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 base currency total row amount for the parent item, including quantity and unit price, before tax.	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 base currency total row amount for the parent item, including quantity, unit price, and tax.	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 base currency tax amount for the parent item.	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 base currency tax amount that has been invoiced for the parent item.	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 in the order 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 discount amount that has been invoiced for the parent item.	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 tax amount compensated for the discount applied to the parent item.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_canceled	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_canceled	The tax compensation amount for discounts that has been canceled for the parent item.	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 tax compensation amount for discounts that has been invoiced for the parent item.	metric
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 is applied to the parent item.	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 parent item quantity 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 whether the parent item is a virtual product.	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 of 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 product associated with the parent item.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.no_discount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.no_discount	Indicates whether discounts are not applicable 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 unique identifier 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 product before any discounts or special pricing.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.price	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.price	The unit price of the parent product for this order item after any discounts.	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 unit price of the parent product for this order item including tax.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_id	The unique identifier of the parent product in the catalog.	dimension
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 identifier for a specific option within a configurable product that is part of a parent item in a shipping assignment.	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 selected value for a configurable product option associated with the parent item.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.custom_options.{NUM}.option_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.custom_options.{NUM}.option_id	The identifier of a custom option chosen for the parent product.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.custom_options.{NUM}.option_value	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.custom_options.{NUM}.option_value	The value selected for a custom option of the parent product.	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 the parent product, such as ‘simple’ or ‘configurable’.	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 product that has been canceled from the order.	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 product that has been included in an invoice.	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 product originally placed in the order.	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 product that has been refunded.	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 product 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 identifier of the quote item that corresponds to this parent product in the order.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_invoiced	The total price of the parent product row that has been invoiced.	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 price of the parent product row, calculated as quantity multiplied by its price.	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 price of the parent product row, inclusive of applicable taxes.	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 product for this order item row.	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) identifier for 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 identifier of the store where the parent product was purchased.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_amount	The amount of tax applied to the parent product.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_canceled	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_canceled	The amount of tax that was canceled for the parent product.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_invoiced	The amount of tax for the parent product that has been included in an invoice.	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 rate applied to the parent product.	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 product 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	Details regarding the Waste Electrical and Electronic Equipment (WEEE) tax applied to the parent product.	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 product.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item_id	The identifier of the parent order item if the current item is part of a configurable or bundle product.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price	The unit price of the product for this order item after any discounts.	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 product for this order item 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 in the catalog.	dimension
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 ID of a selected configurable product option for this item.	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 of a selected configurable product option for this item.	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 selected custom product option for this item.	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 value of a selected custom product option for this item.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_type	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_type	The type of product (e.g., simple, configurable, virtual, bundle).	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_backordered	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_backordered	The quantity of the order item that is currently on backorder.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_canceled	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_canceled	The quantity of this order item that has been canceled.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_invoiced	The quantity of this order 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 quantity of this order item that was originally ordered.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_refunded	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_refunded	The quantity of this order item that has been refunded.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_shipped	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_shipped	The quantity of this order 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 ID of the quote item from which this order item originated.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_invoiced	The total row amount that has been invoiced for this order item.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_total	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_total	The total row amount for this order item, including quantity and unit price, before tax.	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 row amount for this order item, including quantity, unit price, and tax.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_weight	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_weight	The total weight of this order item, calculated as unit weight multiplied by quantity.	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.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.store_id	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.store_id	The ID of the store where the order was placed.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_amount	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_amount	The tax amount for this order item.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_canceled	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_canceled	The tax amount that has been canceled for this order item.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_invoiced	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_invoiced	The tax amount that has been invoiced for this order item.	metric
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_percent	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_percent	The tax percentage applied to this order 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 the 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 WEEE (Waste Electrical and Electronic Equipment) tax applied to this order item.	dimension
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.weight	extension_attributes.shipping_assignments.{NUM}.items.{NUM}.weight	The unit weight of the product for 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’) associated with a shipping assignment.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.city	extension_attributes.shipping_assignments.{NUM}.shipping.address.city	The city component of the shipping address.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.company	extension_attributes.shipping_assignments.{NUM}.shipping.address.company	The name of the company for 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.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.customer_address_id	extension_attributes.shipping_assignments.{NUM}.shipping.address.customer_address_id	The identifier of the address as stored in the customer’s address book.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.email	extension_attributes.shipping_assignments.{NUM}.shipping.address.email	The email contact for the shipping address.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.entity_id	extension_attributes.shipping_assignments.{NUM}.shipping.address.entity_id	The unique identifier for the specific shipping address record.	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 at the shipping address.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.parent_id	extension_attributes.shipping_assignments.{NUM}.shipping.address.parent_id	The identifier of the entity (e.g., order or shipping assignment) that the shipping address is associated with.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.postcode	extension_attributes.shipping_assignments.{NUM}.shipping.address.postcode	The postal code for the shipping address.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.region	extension_attributes.shipping_assignments.{NUM}.shipping.address.region	The full name of the region or state for the shipping address.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.region_code	extension_attributes.shipping_assignments.{NUM}.shipping.address.region_code	The abbreviated code for the region or state for the shipping address.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.region_id	extension_attributes.shipping_assignments.{NUM}.shipping.address.region_id	The identifier for the region or state of the shipping address.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.street.{NUM}	extension_attributes.shipping_assignments.{NUM}.shipping.address.street.{NUM}	An individual line of the street address.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.telephone	extension_attributes.shipping_assignments.{NUM}.shipping.address.telephone	The contact telephone number for 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.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_is_valid	extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_is_valid	A boolean indicator showing whether the provided VAT ID is considered valid.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_request_date	extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_request_date	The date on which the validation for the VAT ID was requested.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_request_id	extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_request_id	The identifier for the VAT ID validation request.	dimension
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_request_success	extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_request_success	A boolean indicator showing whether the VAT ID validation request was successful.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.method	extension_attributes.shipping_assignments.{NUM}.shipping.method	The chosen shipping method for this 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 cost in the base currency of the store before taxes and discounts.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_canceled	extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_canceled	The amount of shipping cost in base currency that has been canceled.	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 shipping in the 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 in base currency to compensate for tax on shipping discounts.	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 cost in base currency, including tax.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_invoiced	extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_invoiced	The shipping cost in base currency that has been included in an invoice.	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 shipping in the base currency.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_amount	extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_amount	The shipping cost in the order’s transactional currency before taxes and discounts.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_canceled	extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_canceled	The amount of shipping cost in the order’s transactional currency that has been canceled.	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 shipping in the order’s transactional 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 in the order’s transactional currency to compensate for tax on shipping discounts.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_incl_tax	extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_incl_tax	The total shipping cost in the order’s transactional currency, including tax.	metric
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_invoiced	extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_invoiced	The shipping cost in the order’s transactional currency that has been included in an invoice.	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 shipping in the order’s transactional currency.	metric
extension_attributes.website_ids.{NUM}	extension_attributes.website_ids.{NUM}	An identifier for a website associated with the entity.	dimension
firstname	firstname	The first name of the customer or recipient.	dimension
free_shipping	free_shipping	A flag indicating whether free shipping was applied to the order.	metric
global_currency_code	global_currency_code	The global currency code configured for the store (e.g., USD, EUR).	dimension
grand_total	grand_total	The final total amount of the order, including all taxes, shipping, and discounts.	metric
group_id	group_id	The identifier for the customer group to which the customer belongs.	dimension
hold_before_state	hold_before_state	The state of the order prior to being placed on hold.	dimension
hold_before_status	hold_before_status	The status of the order prior to being placed on hold.	dimension
id	id	The unique identifier for the entity.	dimension
increment_id	increment_id	A unique, human-readable identifier for the order, often used as an order number.	dimension
is_active	is_active	Indicates whether the entity (e.g., quote, wishlist) is currently active (true/false).	metric
is_qty_decimal	is_qty_decimal	A flag indicating whether the product quantity can be expressed as a decimal number.	metric
is_virtual	is_virtual	A flag indicating whether the product is virtual (e.g., a downloadable product or service) and does not require shipping.	metric
item_id	item_id	The unique identifier for the specific item within the order.	dimension
items.{NUM}.amount_refunded	items.{NUM}.amount_refunded	The total amount that has been refunded for this specific order item.	metric
items.{NUM}.base_amount_refunded	items.{NUM}.base_amount_refunded	The total amount that has been refunded for this order item in the base currency.	metric
items.{NUM}.base_cost	items.{NUM}.base_cost	The cost of the item in the base currency.	metric
items.{NUM}.base_discount_amount	items.{NUM}.base_discount_amount	The amount of discount applied to this order item in the base currency.	metric
items.{NUM}.base_discount_invoiced	items.{NUM}.base_discount_invoiced	The discount amount for this order item in the base currency that has been included in an invoice.	metric
items.{NUM}.base_discount_tax_compensation_amount	items.{NUM}.base_discount_tax_compensation_amount	The amount in base currency to compensate for tax on discounts applied to this order item.	metric
items.{NUM}.base_discount_tax_compensation_invoiced	items.{NUM}.base_discount_tax_compensation_invoiced	The amount in base currency to compensate for tax on discounts for this order item that has been included in an invoice.	metric
items.{NUM}.base_original_price	items.{NUM}.base_original_price	The original selling price of the order item in the base currency before any discounts.	metric
items.{NUM}.base_price	items.{NUM}.base_price	The unit price of the order item in the base currency, after product-specific discounts but before order-level discounts.	metric
items.{NUM}.base_price_incl_tax	items.{NUM}.base_price_incl_tax	The unit price of the order item in the base currency, inclusive of tax.	metric
items.{NUM}.base_row_invoiced	items.{NUM}.base_row_invoiced	The total price of the order item row in base currency that has been included in an invoice.	metric
items.{NUM}.base_row_total	items.{NUM}.base_row_total	The total price of the order item row in base currency, calculated as quantity multiplied by its unit price.	metric
items.{NUM}.base_row_total_incl_tax	items.{NUM}.base_row_total_incl_tax	The total price of the order item row in base currency, inclusive of applicable taxes.	metric
items.{NUM}.base_tax_amount	items.{NUM}.base_tax_amount	The amount of tax applied to this order item in the base currency.	metric
items.{NUM}.base_tax_invoiced	items.{NUM}.base_tax_invoiced	The amount of tax for this order item in the base currency that has been included in an invoice.	metric
items.{NUM}.created_at	items.{NUM}.created_at	The date and time when the order item was created.	dimension
items.{NUM}.discount_amount	items.{NUM}.discount_amount	The amount of discount applied to this order item in the order’s transactional currency.	metric
items.{NUM}.discount_invoiced	items.{NUM}.discount_invoiced	The discount amount for this order item in the order’s transactional currency that has been included in an invoice.	metric
items.{NUM}.discount_percent	items.{NUM}.discount_percent	The percentage of discount applied to this order item.	metric
items.{NUM}.discount_tax_compensation_amount	items.{NUM}.discount_tax_compensation_amount	The amount in the order’s transactional currency to compensate for tax on discounts applied to this order item.	metric
items.{NUM}.discount_tax_compensation_canceled	items.{NUM}.discount_tax_compensation_canceled	The amount of tax compensation for discount that was canceled for this item.	metric
items.{NUM}.discount_tax_compensation_invoiced	items.{NUM}.discount_tax_compensation_invoiced	The amount of tax compensation for discount that was invoiced for this item.	metric
items.{NUM}.entity_id	items.{NUM}.entity_id	A unique identifier for the order item.	dimension
items.{NUM}.free_shipping	items.{NUM}.free_shipping	Indicates if the order item qualified for free shipping (0 for no, 1 for yes).	metric
items.{NUM}.is_qty_decimal	items.{NUM}.is_qty_decimal	Indicates if the quantity for this item can be a decimal value.	metric
items.{NUM}.is_virtual	items.{NUM}.is_virtual	Indicates if the order item represents a virtual product (e.g., a service or digital download).	metric
items.{NUM}.item_id	items.{NUM}.item_id	The unique identifier for a specific item within an order or other collection of items.	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	Indicates if the order item is excluded from discounts (0 for no, 1 for yes).	metric
items.{NUM}.order_id	items.{NUM}.order_id	The unique identifier of the order to which this item belongs.	dimension
items.{NUM}.order_item_id	items.{NUM}.order_item_id	The unique identifier for the order item.	dimension
items.{NUM}.original_price	items.{NUM}.original_price	The original price of a single unit of the product before any discounts.	metric
items.{NUM}.parent_id	items.{NUM}.parent_id	The ID of the parent order item if this is a child item (e.g., for configurable products).	dimension
items.{NUM}.parent_item.amount_refunded	items.{NUM}.parent_item.amount_refunded	The total amount refunded for the parent item.	metric
items.{NUM}.parent_item.base_amount_refunded	items.{NUM}.parent_item.base_amount_refunded	The base currency amount refunded for the parent item.	metric
items.{NUM}.parent_item.base_discount_amount	items.{NUM}.parent_item.base_discount_amount	The base currency discount amount applied to the parent item.	metric
items.{NUM}.parent_item.base_discount_invoiced	items.{NUM}.parent_item.base_discount_invoiced	The base currency discount amount invoiced for the parent item.	metric
items.{NUM}.parent_item.base_discount_tax_compensation_amount	items.{NUM}.parent_item.base_discount_tax_compensation_amount	The base currency tax compensation amount for discount applied to the parent item.	metric
items.{NUM}.parent_item.base_discount_tax_compensation_invoiced	items.{NUM}.parent_item.base_discount_tax_compensation_invoiced	The base currency tax compensation amount for discount invoiced for the parent item.	metric
items.{NUM}.parent_item.base_original_price	items.{NUM}.parent_item.base_original_price	The original price of the parent item in base currency before any discounts.	metric
items.{NUM}.parent_item.base_price	items.{NUM}.parent_item.base_price	The price of the parent item in base currency after discounts.	metric
items.{NUM}.parent_item.base_price_incl_tax	items.{NUM}.parent_item.base_price_incl_tax	The price of the parent item in base currency including tax, after discounts.	metric
items.{NUM}.parent_item.base_row_invoiced	items.{NUM}.parent_item.base_row_invoiced	The total amount invoiced for the parent item in base currency.	metric
items.{NUM}.parent_item.base_row_total	items.{NUM}.parent_item.base_row_total	The total price for the parent item in base currency before tax.	metric
items.{NUM}.parent_item.base_row_total_incl_tax	items.{NUM}.parent_item.base_row_total_incl_tax	The total price for the parent item in base currency including tax.	metric
items.{NUM}.parent_item.base_tax_amount	items.{NUM}.parent_item.base_tax_amount	The total tax amount for the parent item in base currency.	metric
items.{NUM}.parent_item.base_tax_invoiced	items.{NUM}.parent_item.base_tax_invoiced	The base currency tax amount invoiced for the parent item.	metric
items.{NUM}.parent_item.created_at	items.{NUM}.parent_item.created_at	The timestamp when the parent item was created.	dimension
items.{NUM}.parent_item.discount_amount	items.{NUM}.parent_item.discount_amount	The discount amount applied to the parent item.	metric
items.{NUM}.parent_item.discount_invoiced	items.{NUM}.parent_item.discount_invoiced	The discount amount invoiced for the parent item.	metric
items.{NUM}.parent_item.discount_percent	items.{NUM}.parent_item.discount_percent	The discount percentage applied to the parent item.	metric
items.{NUM}.parent_item.discount_tax_compensation_amount	items.{NUM}.parent_item.discount_tax_compensation_amount	The tax compensation amount for discount applied to the parent item.	metric
items.{NUM}.parent_item.discount_tax_compensation_canceled	items.{NUM}.parent_item.discount_tax_compensation_canceled	The tax compensation amount for discount that was canceled for the parent item.	metric
items.{NUM}.parent_item.discount_tax_compensation_invoiced	items.{NUM}.parent_item.discount_tax_compensation_invoiced	The tax compensation amount for discount that was invoiced for the parent item.	metric
items.{NUM}.parent_item.free_shipping	items.{NUM}.parent_item.free_shipping	Indicates if the parent item qualified for free shipping (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 for the parent item can be a decimal value.	metric
items.{NUM}.parent_item.is_virtual	items.{NUM}.parent_item.is_virtual	Indicates if the parent item represents a virtual product.	metric
items.{NUM}.parent_item.item_id	items.{NUM}.parent_item.item_id	A unique identifier for the parent item.	dimension
items.{NUM}.parent_item.name	items.{NUM}.parent_item.name	The name of the product associated with the parent item.	dimension
items.{NUM}.parent_item.no_discount	items.{NUM}.parent_item.no_discount	Indicates if 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 unique identifier of the order to which the parent item belongs.	dimension
items.{NUM}.parent_item.original_price	items.{NUM}.parent_item.original_price	The original price of a single unit of the parent product before any discounts.	metric
items.{NUM}.parent_item.price	items.{NUM}.parent_item.price	The price of a single unit of the parent product after discounts.	metric
items.{NUM}.parent_item.price_incl_tax	items.{NUM}.parent_item.price_incl_tax	The price of a single unit of the parent product including tax, after discounts.	metric
items.{NUM}.parent_item.product_id	items.{NUM}.parent_item.product_id	The unique identifier of the product associated with the parent item.	dimension
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 product option chosen 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 value of a configurable product option chosen for the parent item.	metric
items.{NUM}.parent_item.product_option.extension_attributes.custom_options.{NUM}.option_id	items.{NUM}.parent_item.product_option.extension_attributes.custom_options.{NUM}.option_id	The ID of a custom option chosen for the parent item.	dimension
items.{NUM}.parent_item.product_option.extension_attributes.custom_options.{NUM}.option_value	items.{NUM}.parent_item.product_option.extension_attributes.custom_options.{NUM}.option_value	The value of a custom option chosen for the parent item.	metric
items.{NUM}.parent_item.product_type	items.{NUM}.parent_item.product_type	The type of product associated with the parent item.	dimension
items.{NUM}.parent_item.qty_canceled	items.{NUM}.parent_item.qty_canceled	The quantity of the parent product that was canceled.	metric
items.{NUM}.parent_item.qty_invoiced	items.{NUM}.parent_item.qty_invoiced	The quantity of the parent product that has been invoiced.	metric
items.{NUM}.parent_item.qty_ordered	items.{NUM}.parent_item.qty_ordered	The quantity of the parent product that was originally ordered.	metric
items.{NUM}.parent_item.qty_refunded	items.{NUM}.parent_item.qty_refunded	The quantity of the parent product that has been refunded.	metric
items.{NUM}.parent_item.qty_shipped	items.{NUM}.parent_item.qty_shipped	The quantity of the parent product that has been shipped.	metric
items.{NUM}.parent_item.quote_item_id	items.{NUM}.parent_item.quote_item_id	The ID of the corresponding item in the quote (shopping cart) for the parent item.	dimension
items.{NUM}.parent_item.row_invoiced	items.{NUM}.parent_item.row_invoiced	The total amount invoiced for the parent item (price * invoiced quantity).	metric
items.{NUM}.parent_item.row_total	items.{NUM}.parent_item.row_total	The total price for the parent item row (price * quantity ordered) before tax.	metric
items.{NUM}.parent_item.row_total_incl_tax	items.{NUM}.parent_item.row_total_incl_tax	The total price for the parent item row (price * quantity ordered) including tax.	metric
items.{NUM}.parent_item.row_weight	items.{NUM}.parent_item.row_weight	The total weight for the ordered quantity of the parent item.	metric
items.{NUM}.parent_item.sku	items.{NUM}.parent_item.sku	The Stock Keeping Unit (SKU) of the product associated with the parent item.	dimension
items.{NUM}.parent_item.store_id	items.{NUM}.parent_item.store_id	The ID of the store where the order containing the parent item was placed.	dimension
items.{NUM}.parent_item.tax_amount	items.{NUM}.parent_item.tax_amount	The total tax amount for the parent item.	metric
items.{NUM}.parent_item.tax_canceled	items.{NUM}.parent_item.tax_canceled	The tax amount that was canceled for the parent item.	metric
items.{NUM}.parent_item.tax_invoiced	items.{NUM}.parent_item.tax_invoiced	The tax amount that was invoiced for the parent item.	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 timestamp when the parent item was last updated.	dimension
items.{NUM}.parent_item.weee_tax_applied	items.{NUM}.parent_item.weee_tax_applied	Details about the Waste Electrical and Electronic Equipment (WEEE) tax applied to the parent item of a specific item.	dimension
items.{NUM}.parent_item.weight	items.{NUM}.parent_item.weight	The weight of a single unit of the parent product.	metric
items.{NUM}.parent_item_id	items.{NUM}.parent_item_id	The ID of the parent order item if this is a child item.	dimension
items.{NUM}.price	items.{NUM}.price	The price of a single unit of the product after discounts.	metric
items.{NUM}.price_incl_tax	items.{NUM}.price_incl_tax	The price of a single unit of the product including tax, after discounts.	metric
items.{NUM}.product_id	items.{NUM}.product_id	The unique identifier of the product associated with this order item.	dimension
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 ID of a configurable product option chosen for this 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 value of a configurable product option chosen for this 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 chosen for this 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 value of a custom option chosen for this item.	metric
items.{NUM}.product_type	items.{NUM}.product_type	The type of product (e.g., ‘simple’, ‘configurable’, ‘bundle’) associated with this order item.	dimension
items.{NUM}.qty	items.{NUM}.qty	The quantity of the product ordered.	metric
items.{NUM}.qty_backordered	items.{NUM}.qty_backordered	The quantity of the product that is currently backordered.	metric
items.{NUM}.qty_canceled	items.{NUM}.qty_canceled	The quantity of the product that was canceled from the order.	metric
items.{NUM}.qty_invoiced	items.{NUM}.qty_invoiced	The quantity of the product that has been invoiced.	metric
items.{NUM}.qty_ordered	items.{NUM}.qty_ordered	The quantity of the product that was originally ordered.	metric
items.{NUM}.qty_refunded	items.{NUM}.qty_refunded	The quantity of the product that has been refunded.	metric
items.{NUM}.qty_shipped	items.{NUM}.qty_shipped	The quantity of the product that has been shipped.	metric
items.{NUM}.quote_item_id	items.{NUM}.quote_item_id	The ID of the corresponding item in the quote (shopping cart).	dimension
items.{NUM}.row_invoiced	items.{NUM}.row_invoiced	The total amount invoiced for this item (price * invoiced quantity).	metric
items.{NUM}.row_total	items.{NUM}.row_total	The total price for the row (price * quantity ordered) before tax.	metric
items.{NUM}.row_total_incl_tax	items.{NUM}.row_total_incl_tax	The total price for the row (price * quantity ordered) including tax.	metric
items.{NUM}.row_weight	items.{NUM}.row_weight	The total weight for the ordered quantity of this item.	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 ID of the store where the order containing this item was placed.	dimension
items.{NUM}.tax_amount	items.{NUM}.tax_amount	The total tax amount for this item.	metric
items.{NUM}.tax_canceled	items.{NUM}.tax_canceled	The tax amount that was canceled for this item.	metric
items.{NUM}.tax_invoiced	items.{NUM}.tax_invoiced	The tax amount that was invoiced for this item.	metric
items.{NUM}.tax_percent	items.{NUM}.tax_percent	The tax percentage applied to this item.	metric
items.{NUM}.updated_at	items.{NUM}.updated_at	The timestamp when this order item was last updated.	dimension
items.{NUM}.weee_tax_applied	items.{NUM}.weee_tax_applied	Details about the Waste Electrical and Electronic Equipment (WEEE) tax applied to a specific item.	dimension
items.{NUM}.weight	items.{NUM}.weight	The weight of a single unit of the product.	metric
items_count	items_count	The number of different product items in the quote or wishlist.	metric
items_qty	items_qty	The total quantity of all products across all items in the quote or wishlist.	metric
lastname	lastname	The last name of the customer who placed the order.	dimension
media_gallery_entries.{NUM}.disabled	media_gallery_entries.{NUM}.disabled	Indicates whether a specific entry in the media gallery (e.g., an image) is currently disabled.	dimension
media_gallery_entries.{NUM}.file	media_gallery_entries.{NUM}.file	The file path or name of a media asset within a media gallery entry.	dimension
media_gallery_entries.{NUM}.id	media_gallery_entries.{NUM}.id	The unique identifier for a specific entry in the media gallery.	metric
media_gallery_entries.{NUM}.label	media_gallery_entries.{NUM}.label	A descriptive label for a specific entry in the media gallery.	dimension
media_gallery_entries.{NUM}.media_type	media_gallery_entries.{NUM}.media_type	The type of media (e.g., ‘image’, ‘video’) for a specific entry in the media gallery.	dimension
media_gallery_entries.{NUM}.position	media_gallery_entries.{NUM}.position	The display order or position of a specific entry within the media gallery.	metric
media_gallery_entries.{NUM}.types.{NUM}	media_gallery_entries.{NUM}.types.{NUM}	The usage type(s) assigned to a media gallery entry, such as ‘thumbnail’, ‘base_image’, or ‘small_image’.	dimension
name	name	The identifying name of an entity, which could refer to a product name, customer’s first name, or last name, depending on the context.	dimension
no_discount	no_discount	A flag indicating whether an item or entity is excluded from discounts.	metric
order_currency_code	order_currency_code	The three-letter ISO currency code for the order (e.g., USD, EUR).	dimension
order_id	order_id	The unique identifier of the order.	dimension
orig_order_id	orig_order_id	The identifier of the original order, useful for linking related transactions like refunds or returns to the initial purchase.	dimension
original_price	original_price	The original price of an item before any discounts or special pricing are applied.	metric
parent_item.amount_refunded	parent_item.amount_refunded	The amount refunded for the parent item.	metric
parent_item.base_amount_refunded	parent_item.base_amount_refunded	The amount refunded for the parent item, in the store’s base currency.	metric
parent_item.base_discount_amount	parent_item.base_discount_amount	The discount amount applied to the parent item, in the store’s base currency.	metric
parent_item.base_discount_invoiced	parent_item.base_discount_invoiced	The discount amount invoiced for the parent item, in the store’s base currency.	metric
parent_item.base_discount_tax_compensation_amount	parent_item.base_discount_tax_compensation_amount	The tax compensation amount for discounts applied to the parent item, in the store’s base currency.	metric
parent_item.base_discount_tax_compensation_invoiced	parent_item.base_discount_tax_compensation_invoiced	The invoiced tax compensation amount for discounts applied to the parent item, in the store’s base currency.	metric
parent_item.base_original_price	parent_item.base_original_price	The original price of the parent item, in the store’s base currency.	metric
parent_item.base_price	parent_item.base_price	The base price of the parent item, in the store’s base currency.	metric
parent_item.base_price_incl_tax	parent_item.base_price_incl_tax	The base price of the parent item including tax, in the store’s base currency.	metric
parent_item.base_row_invoiced	parent_item.base_row_invoiced	The total amount invoiced for the parent item’s row, in the store’s base currency.	metric
parent_item.base_row_total	parent_item.base_row_total	The total for the parent item’s row, excluding tax, in the store’s base currency.	metric
parent_item.base_row_total_incl_tax	parent_item.base_row_total_incl_tax	The total for the parent item’s row, including tax, in the store’s base currency.	metric
parent_item.base_tax_amount	parent_item.base_tax_amount	The tax amount applied to the parent item, in the store’s base currency.	metric
parent_item.base_tax_invoiced	parent_item.base_tax_invoiced	The tax amount invoiced for the parent item, in the store’s base currency.	metric
parent_item.created_at	parent_item.created_at	The timestamp when the parent item was created.	dimension
parent_item.discount_amount	parent_item.discount_amount	The discount amount applied to the parent item.	metric
parent_item.discount_invoiced	parent_item.discount_invoiced	The discount amount invoiced for the parent item.	metric
parent_item.discount_percent	parent_item.discount_percent	The percentage of discount applied to the parent item.	metric
parent_item.discount_tax_compensation_amount	parent_item.discount_tax_compensation_amount	The tax compensation amount for discounts applied to the parent item.	metric
parent_item.discount_tax_compensation_canceled	parent_item.discount_tax_compensation_canceled	The canceled tax compensation amount for discounts applied to the parent item.	metric
parent_item.discount_tax_compensation_invoiced	parent_item.discount_tax_compensation_invoiced	The invoiced tax compensation amount for discounts applied to the parent item.	metric
parent_item.free_shipping	parent_item.free_shipping	A flag indicating whether the parent item qualifies for free shipping.	metric
parent_item.is_qty_decimal	parent_item.is_qty_decimal	Indicates whether the quantity of the parent item can be a decimal value.	metric
parent_item.is_virtual	parent_item.is_virtual	Indicates whether the parent item is a virtual product (e.g., a service or digital download).	metric
parent_item.item_id	parent_item.item_id	The unique identifier for the parent item.	dimension
parent_item.name	parent_item.name	The name of the parent item.	dimension
parent_item.no_discount	parent_item.no_discount	A flag indicating whether the parent item is excluded from discounts.	metric
parent_item.order_id	parent_item.order_id	The identifier of the order that the parent item belongs to.	dimension
parent_item.original_price	parent_item.original_price	The original price of the parent item before any discounts.	metric
parent_item.price	parent_item.price	The current selling price of the parent item.	metric
parent_item.price_incl_tax	parent_item.price_incl_tax	The price of the parent item including tax.	metric
parent_item.product_id	parent_item.product_id	The identifier of the product associated with the parent item.	dimension
parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_id	parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_id	The identifier for a specific option chosen for a configurable product within the parent item’s product options.	dimension
parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value	parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value	The value of a specific option chosen for a configurable product within the parent item’s product options.	metric
parent_item.product_option.extension_attributes.custom_options.{NUM}.option_id	parent_item.product_option.extension_attributes.custom_options.{NUM}.option_id	The identifier for a specific custom option chosen for the parent item’s product.	dimension
parent_item.product_option.extension_attributes.custom_options.{NUM}.option_value	parent_item.product_option.extension_attributes.custom_options.{NUM}.option_value	The value of a specific custom option chosen for the parent item’s product.	metric
parent_item.product_type	parent_item.product_type	The type of product for the parent item (e.g., ‘simple’, ‘configurable’, ‘bundle’).	dimension
parent_item.qty_canceled	parent_item.qty_canceled	The quantity of the parent item that has been canceled.	metric
parent_item.qty_invoiced	parent_item.qty_invoiced	The quantity of the parent item that has been invoiced.	metric
parent_item.qty_ordered	parent_item.qty_ordered	The quantity of the parent item that was originally ordered.	metric
parent_item.qty_refunded	parent_item.qty_refunded	The quantity of the parent item that has been refunded.	metric
parent_item.qty_shipped	parent_item.qty_shipped	The quantity of the parent item that has been shipped.	metric
parent_item.quote_item_id	parent_item.quote_item_id	The identifier of the quote item from which the parent item originated.	dimension
parent_item.row_invoiced	parent_item.row_invoiced	The total amount invoiced for the parent item’s row.	metric
parent_item.row_total	parent_item.row_total	The total for the parent item’s row, excluding tax.	metric
parent_item.row_total_incl_tax	parent_item.row_total_incl_tax	The total for the parent item’s row, including tax.	metric
parent_item.row_weight	parent_item.row_weight	The total weight of the parent item’s row.	metric
parent_item.sku	parent_item.sku	The Stock Keeping Unit (SKU) of the parent item.	dimension
parent_item.store_id	parent_item.store_id	The identifier of the store where the parent item was ordered.	dimension
parent_item.tax_amount	parent_item.tax_amount	The tax amount applied to the parent item.	metric
parent_item.tax_canceled	parent_item.tax_canceled	The tax amount canceled for the parent item.	metric
parent_item.tax_invoiced	parent_item.tax_invoiced	The tax amount invoiced for the parent item.	metric
parent_item.tax_percent	parent_item.tax_percent	The tax percentage applied to the parent item.	metric
parent_item.updated_at	parent_item.updated_at	The timestamp when the parent item was last updated.	dimension
parent_item.weee_tax_applied	parent_item.weee_tax_applied	Details about the Waste Electrical and Electronic Equipment (WEEE) tax applied to the parent item.	dimension
parent_item.weight	parent_item.weight	The weight of the parent item.	metric
parent_item_id	parent_item_id	The identifier of the parent item, used to link sub-items or configurable options to their main product.	dimension
payment.account_status	payment.account_status	The status of the customer’s payment account for the transaction.	dimension
payment.additional_information.{NUM}	payment.additional_information.{NUM}	Additional information related to the payment, which can vary depending on the payment method used. This field is an array to hold multiple pieces of information.	dimension
payment.amount_authorized	payment.amount_authorized	The amount authorized for the payment in the order’s currency.	metric
payment.amount_ordered	payment.amount_ordered	The total amount of the order in the order’s currency that was ordered for payment.	metric
payment.amount_paid	payment.amount_paid	The amount that has been paid for the order in the order’s currency.	metric
payment.base_amount_authorized	payment.base_amount_authorized	The amount authorized for the payment in the store’s base currency.	metric
payment.base_amount_ordered	payment.base_amount_ordered	The total amount of the order in the store’s base currency that was ordered for payment.	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 shipping amount for the order in the store’s base currency.	metric
payment.base_shipping_captured	payment.base_shipping_captured	The shipping amount 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.	metric
payment.cc_last4	payment.cc_last4	The last four digits of the credit card number used for payment.	dimension
payment.cc_ss_start_month	payment.cc_ss_start_month	The start month of a credit card used for payment.	metric
payment.cc_ss_start_year	payment.cc_ss_start_year	The start year of a credit card used for payment.	metric
payment.entity_id	payment.entity_id	The unique identifier for the payment record.	dimension
payment.last_trans_id	payment.last_trans_id	The ID of the last transaction associated with this payment.	dimension
payment.method	payment.method	The payment method used for the order (e.g., ‘checkmo’, ‘paypal_express’, ‘cashondelivery’).	dimension
payment.parent_id	payment.parent_id	The identifier of the entity (e.g., order or invoice) that the payment record is associated with.	dimension
payment.shipping_amount	payment.shipping_amount	The shipping amount for the order in the order’s currency.	metric
payment.shipping_captured	payment.shipping_captured	The shipping amount that has been captured for the order in the order’s currency.	metric
price	price	The unit price of the product or item, excluding tax.	metric
price_incl_tax	price_incl_tax	The unit price of the product or item, including tax.	metric
product_id	product_id	The unique identifier of the product.	dimension
product_links.{NUM}.link_type	product_links.{NUM}.link_type	The type of product relationship, such as ‘related’, ‘upsell’, or ‘crosssell’.	dimension
product_links.{NUM}.linked_product_sku	product_links.{NUM}.linked_product_sku	The SKU of the product that is linked to the current product.	dimension
product_links.{NUM}.linked_product_type	product_links.{NUM}.linked_product_type	The type of the product that is linked to the current product (e.g., ‘simple’, ‘configurable’).	dimension
product_links.{NUM}.position	product_links.{NUM}.position	The display order or position of the linked product within its type.	metric
product_links.{NUM}.sku	product_links.{NUM}.sku	The SKU of the product to which another product is linked.	dimension
product_option.extension_attributes.configurable_item_options.{NUM}.option_id	product_option.extension_attributes.configurable_item_options.{NUM}.option_id	The unique identifier of a selected configurable option for the product.	dimension
product_option.extension_attributes.configurable_item_options.{NUM}.option_value	product_option.extension_attributes.configurable_item_options.{NUM}.option_value	The selected value for a configurable option of the product, such as a specific size or color.	metric
product_option.extension_attributes.custom_options.{NUM}.option_id	product_option.extension_attributes.custom_options.{NUM}.option_id	The unique identifier of a custom option chosen for the product.	dimension
product_option.extension_attributes.custom_options.{NUM}.option_value	product_option.extension_attributes.custom_options.{NUM}.option_value	The value provided by the customer for a custom option of the product, such as engraved text or a selected date.	metric
product_type	product_type	The type of the product, e.g., ‘simple’, ‘configurable’, ‘bundle’, ‘virtual’, ‘downloadable’.	dimension
protect_code	protect_code	A unique, system-generated code associated with an order, often used to secure access to order details for guest customers.	dimension
qty	qty	The quantity of a specific item.	metric
qty_backordered	qty_backordered	The quantity of an item that is currently on backorder.	metric
qty_canceled	qty_canceled	The quantity of the item that was canceled from the order.	metric
qty_invoiced	qty_invoiced	The quantity of the item that has been invoiced.	metric
qty_ordered	qty_ordered	The quantity of the item that was originally ordered.	metric
qty_refunded	qty_refunded	The quantity of the item that was refunded.	metric
qty_shipped	qty_shipped	The quantity of the item that has been shipped.	metric
quote_id	quote_id	The unique identifier of the quote (shopping cart) associated with the order.	dimension
quote_item_id	quote_item_id	The unique identifier of the item within a quote (shopping cart).	dimension
remote_ip	remote_ip	The IP address of the customer who placed the order or interacted with the quote.	dimension
row_invoiced	row_invoiced	The total invoiced amount for the row of items in the order.	metric
row_total	row_total	The total price for the row of items in the order, excluding tax.	metric
row_total_incl_tax	row_total_incl_tax	The total price for the row of items in the order, including tax.	metric
row_weight	row_weight	The combined weight of the items in the order row.	metric
shipping_address_id	shipping_address_id	The unique identifier of the shipping address used for the order.	dimension
shipping_amount	shipping_amount	The shipping cost for the order, excluding tax.	metric
shipping_canceled	shipping_canceled	The shipping amount that was canceled for the order.	metric
shipping_description	shipping_description	A description of the shipping method used for the order.	dimension
shipping_discount_amount	shipping_discount_amount	The discount amount applied to shipping.	metric
shipping_discount_tax_compensation_amount	shipping_discount_tax_compensation_amount	The tax compensation amount for discounts applied to shipping.	metric
shipping_incl_tax	shipping_incl_tax	The shipping cost for the order, including tax.	metric
shipping_invoiced	shipping_invoiced	The shipping amount that has been invoiced for the order.	metric
shipping_method	shipping_method	The chosen method for shipping an order, encompassing both the carrier (e.g., ‘flatrate’) and the specific service (e.g., ‘fixed’).	dimension
shipping_tax_amount	shipping_tax_amount	The tax amount applied to shipping.	metric
sku	sku	The Stock Keeping Unit (SKU) of the product.	dimension
state	state	The current state of the order within its workflow (e.g., ‘new’, ‘processing’, ‘complete’).	dimension
status	status	The current status of the order (e.g., ‘pending’, ‘processing’, ‘complete’).	metric
status_histories.{NUM}.comment	status_histories.{NUM}.comment	A comment associated with a specific entry in the order’s status history.	dimension
status_histories.{NUM}.created_at	status_histories.{NUM}.created_at	The timestamp when a specific status history entry was created.	dimension
status_histories.{NUM}.entity_id	status_histories.{NUM}.entity_id	The unique identifier of the status history entry.	dimension
status_histories.{NUM}.entity_name	status_histories.{NUM}.entity_name	The type of entity the 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 history update (true/false).	metric
status_histories.{NUM}.is_visible_on_front	status_histories.{NUM}.is_visible_on_front	Indicates whether this status history entry is visible to the customer on the storefront (true/false).	metric
status_histories.{NUM}.parent_id	status_histories.{NUM}.parent_id	The identifier of the entity (e.g., order) that a specific status history entry belongs to.	dimension
status_histories.{NUM}.status	status_histories.{NUM}.status	The status associated with this specific status history entry.	dimension
store_currency_code	store_currency_code	The currency code of the store where the order was placed (e.g., ‘USD’, ‘EUR’).	dimension
store_id	store_id	The unique identifier 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 currency to the base currency.	metric
store_to_order_rate	store_to_order_rate	The currency conversion rate from the store’s currency to the order’s currency.	metric
subtotal	subtotal	The subtotal of the order, excluding tax.	metric
subtotal_canceled	subtotal_canceled	The subtotal amount that was canceled from the order.	metric
subtotal_incl_tax	subtotal_incl_tax	The subtotal of the order, including tax.	metric
subtotal_invoiced	subtotal_invoiced	The subtotal amount that has been invoiced.	metric
tax_amount	tax_amount	The total tax amount applied to the order.	metric
tax_canceled	tax_canceled	The total tax amount that was canceled from the order.	metric
tax_invoiced	tax_invoiced	The total tax amount that has been invoiced.	metric
tax_percent	tax_percent	The tax percentage applied to the item or order.	metric
total_canceled	total_canceled	The total amount of the order that was canceled.	metric
total_due	total_due	The remaining total amount due for the order.	metric
total_invoiced	total_invoiced	The total amount that has been invoiced for the order.	metric
total_item_count	total_item_count	The total number of distinct items in the order.	metric
total_paid	total_paid	The total amount that has been paid for the order.	metric
total_qty	total_qty	The total quantity of all items in the quote or order.	metric
total_qty_ordered	total_qty_ordered	The total quantity of all items originally ordered.	metric
transaction_id	transaction_id	The unique identifier for the payment transaction.	dimension
type_id	type_id	The type identifier of the product or entity.	dimension
updated_at	updated_at	The timestamp indicating when the record was last updated.	dimension
visibility	visibility	The visibility setting of a product in the catalog and search results (e.g., ‘Not Visible Individually’, ‘Catalog’, ‘Search’, ‘Catalog, Search’).	metric
website_id	website_id	The unique identifier of the website where the entity belongs.	dimension
weee_tax_applied	weee_tax_applied	Details about the Waste Electrical and Electronic Equipment (WEEE) tax applied to an item.	dimension
weight	weight	The weight of a single unit of the product.	metric
wishlist_id	wishlist_id	The unique identifier for a customer’s wishlist.	dimension
wishlist_item_id	wishlist_item_id	The unique identifier for an item within a customer’s wishlist.	dimension