Magento: Most-used fields

Magento: Most-used fields#

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

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

API name

Adverity UI name

Description

Use in Adverity

addresses.{NUM}.city

addresses.{NUM}.city

The city of the customer’s address.

dimension

addresses.{NUM}.company

addresses.{NUM}.company

The company name associated with the customer’s address.

dimension

addresses.{NUM}.country_id

addresses.{NUM}.country_id

The ID of the country associated with the customer’s address.

dimension

addresses.{NUM}.customer_id

addresses.{NUM}.customer_id

The ID of the customer to whom the address belongs.

dimension

addresses.{NUM}.default_billing

addresses.{NUM}.default_billing

A flag indicating if this is the customer’s default billing address.

dimension

addresses.{NUM}.default_shipping

addresses.{NUM}.default_shipping

A flag indicating if this is the customer’s default shipping address.

dimension

addresses.{NUM}.firstname

addresses.{NUM}.firstname

The first name of the person associated with the address.

dimension

addresses.{NUM}.id

addresses.{NUM}.id

The unique identifier for the address record.

metric

addresses.{NUM}.lastname

addresses.{NUM}.lastname

The last name of the person associated with the address.

dimension

addresses.{NUM}.postcode

addresses.{NUM}.postcode

The postal code or ZIP code of the address.

dimension

addresses.{NUM}.region.region

addresses.{NUM}.region.region

The full name of the region or state associated with the address.

dimension

addresses.{NUM}.region.region_code

addresses.{NUM}.region.region_code

The code for the region or state associated with the address.

dimension

addresses.{NUM}.region.region_id

addresses.{NUM}.region.region_id

The ID of the region or state associated with the address.

dimension

addresses.{NUM}.region_id

addresses.{NUM}.region_id

The ID of the region or state associated with the address.

dimension

addresses.{NUM}.street.{NUM}

addresses.{NUM}.street.{NUM}

A line of the street address. Multiple lines can exist for a single address.

dimension

addresses.{NUM}.telephone

addresses.{NUM}.telephone

The telephone number associated with the address.

dimension

addresses.{NUM}.vat_id

addresses.{NUM}.vat_id

The Value Added Tax (VAT) identification number for the customer’s address.

dimension

adjustment_negative

adjustment_negative

The negative adjustment amount applied to the order or invoice.

metric

adjustment_positive

adjustment_positive

The positive adjustment amount applied to the order or invoice.

metric

amount_refunded

amount_refunded

The total amount refunded for the order.

metric

applied_rule_ids

applied_rule_ids

A comma-separated list of IDs of the shopping cart price rules that were applied to the order item or the entire order.

dimension

attribute_set_id

attribute_set_id

The unique identifier for the attribute set assigned to a product, used for organizing product attributes.

dimension

base_adjustment_negative

base_adjustment_negative

The negative adjustment amount in base currency applied to the order or invoice.

metric

base_adjustment_positive

base_adjustment_positive

The positive adjustment amount in base currency applied to the order or invoice.

metric

base_amount_refunded

base_amount_refunded

The total amount refunded for the order in base currency.

metric

base_currency_code

base_currency_code

The base currency code of the store.

dimension

base_discount_amount

base_discount_amount

The discount amount applied to the order in base currency.

metric

base_discount_canceled

base_discount_canceled

The canceled discount amount in base currency.

metric

base_discount_invoiced

base_discount_invoiced

The invoiced discount amount in base currency.

metric

base_discount_refunded

base_discount_refunded

The refunded discount amount in base currency.

metric

base_discount_tax_compensation_amount

base_discount_tax_compensation_amount

The discount tax compensation amount in base currency.

metric

base_discount_tax_compensation_invoiced

base_discount_tax_compensation_invoiced

The invoiced discount tax compensation amount in base currency.

metric

base_discount_tax_compensation_refunded

base_discount_tax_compensation_refunded

The refunded discount tax compensation amount in base currency.

metric

base_grand_total

base_grand_total

The grand total amount of the order in base currency.

metric

base_original_price

base_original_price

The original price of the product in base currency.

metric

base_price

base_price

The price of the product in base currency.

metric

base_price_incl_tax

base_price_incl_tax

The price of the product including tax in base currency.

metric

base_row_invoiced

base_row_invoiced

The total invoiced amount for the row (e.g., order item) in base currency.

metric

base_row_total

base_row_total

The total amount for the row (e.g., order item) in base currency.

metric

base_row_total_incl_tax

base_row_total_incl_tax

The total amount for the row (e.g., order item) including tax in base currency.

metric

base_shipping_amount

base_shipping_amount

The shipping amount for the order in base currency.

metric

base_shipping_canceled

base_shipping_canceled

The canceled shipping amount in base currency.

metric

base_shipping_discount_amount

base_shipping_discount_amount

The shipping discount amount in base currency.

metric

base_shipping_discount_tax_compensation_amnt

base_shipping_discount_tax_compensation_amnt

The shipping discount tax compensation amount in base currency.

metric

base_shipping_incl_tax

base_shipping_incl_tax

The shipping amount including tax in base currency.

metric

base_shipping_invoiced

base_shipping_invoiced

The invoiced shipping amount in base currency.

metric

base_shipping_refunded

base_shipping_refunded

The refunded shipping amount in base currency.

metric

base_shipping_tax_amount

base_shipping_tax_amount

The shipping tax amount in base currency.

metric

base_shipping_tax_refunded

base_shipping_tax_refunded

The refunded shipping tax amount in base currency.

metric

base_subtotal

base_subtotal

The subtotal amount of the order in base currency.

metric

base_subtotal_canceled

base_subtotal_canceled

The canceled subtotal amount in base currency.

metric

base_subtotal_incl_tax

base_subtotal_incl_tax

The subtotal amount including tax in base currency.

metric

base_subtotal_invoiced

base_subtotal_invoiced

The invoiced subtotal amount in base currency.

metric

base_subtotal_refunded

base_subtotal_refunded

The refunded subtotal amount in base currency.

metric

base_tax_amount

base_tax_amount

The total tax amount for the order in base currency.

metric

base_tax_canceled

base_tax_canceled

The canceled tax amount in base currency.

metric

base_tax_invoiced

base_tax_invoiced

The invoiced tax amount in base currency.

metric

base_tax_refunded

base_tax_refunded

The refunded tax amount in base currency.

metric

base_to_global_rate

base_to_global_rate

The currency conversion rate from base currency to global currency.

metric

base_to_order_rate

base_to_order_rate

The currency conversion rate from base currency to order currency.

metric

base_total_canceled

base_total_canceled

The total canceled amount in base currency.

metric

base_total_due

base_total_due

The total amount still due on the order in base currency.

metric

base_total_invoiced

base_total_invoiced

The total invoiced amount in base currency.

metric

base_total_invoiced_cost

base_total_invoiced_cost

The total invoiced cost of the items in base currency.

metric

base_total_offline_refunded

base_total_offline_refunded

The total amount refunded offline in base currency.

metric

base_total_paid

base_total_paid

The total amount paid in base currency.

metric

base_total_refunded

base_total_refunded

The total amount refunded in base currency.

metric

base_weee_tax_applied_amount

base_weee_tax_applied_amount

The applied WEEE (Waste Electrical and Electronic Equipment) tax amount in base currency.

metric

base_weee_tax_applied_row_amnt

base_weee_tax_applied_row_amnt

The base amount of WEEE (Waste Electrical and Electronic Equipment) tax applied to a row in a credit memo item.

metric

base_weee_tax_disposition

base_weee_tax_disposition

The WEEE tax disposition amount in base currency.

metric

base_weee_tax_row_disposition

base_weee_tax_row_disposition

The WEEE tax row disposition amount in base currency.

metric

billing_address.address_type

billing_address.address_type

The type of the billing address (e.g., ‘billing’).

dimension

billing_address.city

billing_address.city

The city of the billing address.

dimension

billing_address.company

billing_address.company

The company name associated with the billing address.

dimension

billing_address.country_id

billing_address.country_id

The country ID of the billing address (e.g., ‘US’).

dimension

billing_address.customer_address_id

billing_address.customer_address_id

The ID of the customer’s address if it’s a registered address.

dimension

billing_address.customer_id

billing_address.customer_id

The ID of the customer associated with the billing address.

dimension

billing_address.email

billing_address.email

The email address associated with the billing address.

dimension

billing_address.entity_id

billing_address.entity_id

The unique identifier for the billing address entity.

dimension

billing_address.fax

billing_address.fax

The fax number for the billing address.

dimension

billing_address.firstname

billing_address.firstname

The first name for the billing address.

dimension

billing_address.lastname

billing_address.lastname

The last name for the billing address.

dimension

billing_address.middlename

billing_address.middlename

The middle name of the person associated with the billing address.

dimension

billing_address.parent_id

billing_address.parent_id

The ID of the parent entity (e.g., order) to which this billing address belongs.

dimension

billing_address.postcode

billing_address.postcode

The postcode/zip code of the billing address.

metric

billing_address.prefix

billing_address.prefix

The prefix for the customer’s name (e.g., ‘Mr.’, ‘Ms.’).

dimension

billing_address.region

billing_address.region

The region/state of the billing address.

dimension

billing_address.region_code

billing_address.region_code

The region code of the billing address (e.g., ‘NY’).

dimension

billing_address.region_id

billing_address.region_id

The region ID of the billing address.

dimension

billing_address.street.{NUM}

billing_address.street.{NUM}

A specific line of the street address for the billing address.

dimension

billing_address.suffix

billing_address.suffix

The suffix of the person’s name associated with the billing address (e.g., Jr., Sr., III).

dimension

billing_address.telephone

billing_address.telephone

The telephone number for the billing address.

dimension

billing_address.vat_id

billing_address.vat_id

The VAT ID associated with the billing address for business customers.

dimension

billing_address.vat_is_valid

billing_address.vat_is_valid

A flag indicating if the VAT ID provided for the billing address is valid.

metric

billing_address.vat_request_date

billing_address.vat_request_date

The date when the VAT ID validation request for the billing address was submitted.

dimension

billing_address.vat_request_success

billing_address.vat_request_success

Indicates if the VAT ID validation request for the billing address was successful.

metric

billing_address_id

billing_address_id

The ID of the billing address.

dimension

can_void_flag

can_void_flag

Indicates whether the invoice can be voided.

metric

coupon_code

coupon_code

The coupon code applied to the order.

dimension

created_at

created_at

The timestamp when the entity (e.g., order, invoice, customer) was created.

dimension

created_in

created_in

The store view code or name where the entity (e.g., customer, order) was created.

dimension

custom_attributes.{NUM}.attribute_code

custom_attributes.{NUM}.attribute_code

The code for a custom attribute.

dimension

custom_attributes.{NUM}.value

custom_attributes.{NUM}.value

The value of the custom attribute.

metric

customer_dob

customer_dob

The customer’s date of birth.

dimension

customer_email

customer_email

The customer’s email address.

dimension

customer_firstname

customer_firstname

The customer’s first name.

dimension

customer_gender

customer_gender

The customer’s gender.

metric

customer_group_id

customer_group_id

The ID of the customer group to which the customer belongs.

dimension

customer_id

customer_id

The unique identifier for the customer.

dimension

customer_is_guest

customer_is_guest

A flag indicating if the customer is a guest (not a registered user).

metric

customer_lastname

customer_lastname

The customer’s last name.

dimension

customer_middlename

customer_middlename

The customer’s middle name.

dimension

customer_note

customer_note

A note added by the customer to the order.

dimension

customer_note_notify

customer_note_notify

A flag indicating if the customer should be notified about the customer note.

metric

customer_prefix

customer_prefix

The prefix for the customer’s name (e.g., ‘Mr.’, ‘Ms.’).

dimension

customer_suffix

customer_suffix

The suffix of the customer’s name.

dimension

customer_taxvat

customer_taxvat

The customer’s TAX/VAT number.

dimension

date

date

The date associated with the entity’s creation or a relevant event.

dimension

default_billing

default_billing

The ID of the customer’s default billing address.

metric

default_shipping

default_shipping

The ID of the customer’s default shipping address.

metric

disable_auto_group_change

disable_auto_group_change

metric

discount_amount

discount_amount

The total discount amount applied to the order.

metric

discount_canceled

discount_canceled

The amount of discount that was canceled.

metric

discount_description

discount_description

A description of the discount applied to the order.

dimension

discount_invoiced

discount_invoiced

The amount of discount that has been invoiced.

metric

discount_percent

discount_percent

The percentage of discount applied to the item.

metric

discount_refunded

discount_refunded

The amount of discount that has been refunded.

metric

discount_tax_compensation_amount

discount_tax_compensation_amount

The tax compensation amount for the discount.

metric

discount_tax_compensation_canceled

discount_tax_compensation_canceled

The canceled tax compensation amount for the discount.

metric

discount_tax_compensation_invoiced

discount_tax_compensation_invoiced

The invoiced tax compensation amount for the discount.

metric

discount_tax_compensation_refunded

discount_tax_compensation_refunded

The refunded tax compensation amount for the discount.

metric

edit_increment

edit_increment

metric

email

email

The email address of the customer.

dimension

email_sent

email_sent

Indicates whether an email notification for the entity (e.g., order confirmation, invoice) has been sent.

metric

entity_id

entity_id

The unique identifier for the entity.

dimension

extension_attributes.additional_itemized_taxes.{NUM}.amount

extension_attributes.additional_itemized_taxes.{NUM}.amount

The amount of an additional itemized tax.

metric

extension_attributes.additional_itemized_taxes.{NUM}.base_amount

extension_attributes.additional_itemized_taxes.{NUM}.base_amount

The base currency amount of an additional itemized tax.

metric

extension_attributes.additional_itemized_taxes.{NUM}.real_amount

extension_attributes.additional_itemized_taxes.{NUM}.real_amount

The real (realized) amount of an additional itemized tax.

metric

extension_attributes.additional_itemized_taxes.{NUM}.real_base_amount

extension_attributes.additional_itemized_taxes.{NUM}.real_base_amount

The real (realized) base currency amount of an additional itemized tax.

metric

extension_attributes.additional_itemized_taxes.{NUM}.tax_code

extension_attributes.additional_itemized_taxes.{NUM}.tax_code

The tax code for an additional itemized tax.

dimension

extension_attributes.additional_itemized_taxes.{NUM}.tax_id

extension_attributes.additional_itemized_taxes.{NUM}.tax_id

The ID of an additional itemized tax.

dimension

extension_attributes.additional_itemized_taxes.{NUM}.tax_item_id

extension_attributes.additional_itemized_taxes.{NUM}.tax_item_id

The ID of the item to which an additional itemized tax applies.

dimension

extension_attributes.additional_itemized_taxes.{NUM}.tax_percent

extension_attributes.additional_itemized_taxes.{NUM}.tax_percent

The percentage of an additional itemized tax.

metric

extension_attributes.additional_itemized_taxes.{NUM}.taxable_item_type

extension_attributes.additional_itemized_taxes.{NUM}.taxable_item_type

The type of the taxable item for an additional itemized tax.

dimension

extension_attributes.applied_taxes.{NUM}.amount

extension_attributes.applied_taxes.{NUM}.amount

The amount of an applied tax.

metric

extension_attributes.applied_taxes.{NUM}.base_amount

extension_attributes.applied_taxes.{NUM}.base_amount

The base currency amount of an applied tax.

metric

extension_attributes.applied_taxes.{NUM}.code

extension_attributes.applied_taxes.{NUM}.code

The code of an applied tax.

dimension

extension_attributes.applied_taxes.{NUM}.percent

extension_attributes.applied_taxes.{NUM}.percent

The percentage of an applied tax.

metric

extension_attributes.applied_taxes.{NUM}.title

extension_attributes.applied_taxes.{NUM}.title

The title or name of an applied tax.

dimension

extension_attributes.base_gift_cards_amount

extension_attributes.base_gift_cards_amount

The total amount of gift cards applied to the order in the store’s base currency.

metric

extension_attributes.base_gift_cards_invoiced

extension_attributes.base_gift_cards_invoiced

The base amount of gift card value that has been invoiced for the order.

metric

extension_attributes.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 its linked category.

metric

extension_attributes.company_order_attributes.company_id

extension_attributes.company_order_attributes.company_id

The ID of the company associated with the order (relevant for B2B orders).

dimension

extension_attributes.company_order_attributes.company_name

extension_attributes.company_order_attributes.company_name

The name of the company associated with the order (relevant for B2B orders).

dimension

extension_attributes.configurable_product_links.{NUM}

extension_attributes.configurable_product_links.{NUM}

A linked product ID that is part of a configurable product.

metric

extension_attributes.configurable_product_options.{NUM}.attribute_id

extension_attributes.configurable_product_options.{NUM}.attribute_id

The attribute ID 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 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.

dimension

extension_attributes.configurable_product_options.{NUM}.position

extension_attributes.configurable_product_options.{NUM}.position

The display position of a configurable product option.

metric

extension_attributes.configurable_product_options.{NUM}.product_id

extension_attributes.configurable_product_options.{NUM}.product_id

The product ID associated with a configurable product option.

dimension

extension_attributes.configurable_product_options.{NUM}.values.{NUM}.value_index

extension_attributes.configurable_product_options.{NUM}.values.{NUM}.value_index

The index of a specific value within a configurable product option.

metric

extension_attributes.converting_from_quote

extension_attributes.converting_from_quote

A flag indicating whether the order was converted from a customer quote.

dimension

extension_attributes.gift_cards.{NUM}.amount

extension_attributes.gift_cards.{NUM}.amount

The amount of a specific gift card applied to the order.

metric

extension_attributes.gift_cards.{NUM}.base_amount

extension_attributes.gift_cards.{NUM}.base_amount

The base currency amount of a specific gift card applied to the order.

metric

extension_attributes.gift_cards.{NUM}.code

extension_attributes.gift_cards.{NUM}.code

The unique code of the gift card used for the order.

dimension

extension_attributes.gift_cards.{NUM}.id

extension_attributes.gift_cards.{NUM}.id

The unique identifier for a specific gift card used on the order.

metric

extension_attributes.gift_cards_amount

extension_attributes.gift_cards_amount

The total amount of gift cards applied to the order in the order’s currency.

metric

extension_attributes.gift_cards_invoiced

extension_attributes.gift_cards_invoiced

The amount of gift card value in the order’s currency that has been invoiced.

metric

extension_attributes.gift_message.customer_id

extension_attributes.gift_message.customer_id

The unique identifier of the customer who sent the gift message.

dimension

extension_attributes.gift_message.gift_message_id

extension_attributes.gift_message.gift_message_id

The unique identifier for the gift message.

dimension

extension_attributes.gift_message.message

extension_attributes.gift_message.message

The actual text content of the gift message.

dimension

extension_attributes.gift_message.recipient

extension_attributes.gift_message.recipient

The name of the recipient for the gift message.

dimension

extension_attributes.gift_message.sender

extension_attributes.gift_message.sender

The name of the sender of the gift message.

dimension

extension_attributes.gw_base_price

extension_attributes.gw_base_price

The base currency price of the gift wrap service.

metric

extension_attributes.gw_card_base_price

extension_attributes.gw_card_base_price

The base currency price of a gift card included with the gift wrap.

metric

extension_attributes.gw_card_price

extension_attributes.gw_card_price

The price of a gift card included with the gift wrap.

metric

extension_attributes.gw_items_base_price

extension_attributes.gw_items_base_price

The base currency price of gift wrap applied to individual items.

metric

extension_attributes.gw_items_price

extension_attributes.gw_items_price

The price of gift wrap applied to individual items.

metric

extension_attributes.gw_price

extension_attributes.gw_price

The price of the gift wrap service.

metric

extension_attributes.is_subscribed

extension_attributes.is_subscribed

Indicates whether the customer is subscribed to the newsletter.

dimension

extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.amount

extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.amount

The amount of an applied tax for a specific item.

metric

extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.base_amount

extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.base_amount

The base currency amount of an applied tax for a specific item.

metric

extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.code

extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.code

The code of an applied tax for a specific item.

dimension

extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.percent

extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.percent

The percentage of an applied tax for a specific item.

metric

extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.title

extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.title

The title or name of an applied tax for a specific item.

dimension

extension_attributes.item_applied_taxes.{NUM}.item_id

extension_attributes.item_applied_taxes.{NUM}.item_id

The ID of the item to which the taxes are applied.

dimension

extension_attributes.item_applied_taxes.{NUM}.type

extension_attributes.item_applied_taxes.{NUM}.type

The type of tax applied to the item.

dimension

extension_attributes.order_session_id

extension_attributes.order_session_id

A unique identifier for the customer’s session during which the order was placed, stored as an extension attribute.

dimension

extension_attributes.payment_additional_info.{NUM}.key

extension_attributes.payment_additional_info.{NUM}.key

The key for an additional piece of payment information associated with the order.

dimension

extension_attributes.payment_additional_info.{NUM}.value

extension_attributes.payment_additional_info.{NUM}.value

The value corresponding to a key in the additional payment information associated with the order.

dimension

extension_attributes.pickup_location_code

extension_attributes.pickup_location_code

The unique identifier for the in-store pickup location selected for an order.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.amount_refunded

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.amount_refunded

The amount refunded for this specific item within the shipping assignment.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.applied_rule_ids

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.applied_rule_ids

A comma-separated list of IDs for cart price rules or promotions that were applied to this item.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_amount_refunded

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_amount_refunded

The amount refunded for this specific item in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_cost

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_cost

The base cost of the item within a specific shipping assignment.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_amount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_amount

The discount amount applied to this item in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_invoiced

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_invoiced

The amount of discount that has been invoiced for this item in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_refunded

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_refunded

The amount of discount that has been refunded for this item in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_tax_compensation_amount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_tax_compensation_amount

The amount of tax compensation applied due to discounts for this item, in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_tax_compensation_invoiced

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_tax_compensation_invoiced

The amount of tax compensation for discounts that has been invoiced for this item, in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_tax_compensation_refunded

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_tax_compensation_refunded

The amount of tax compensation for discounts that has been refunded for this item, in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_original_price

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_original_price

The original price of the item, before any discounts or special pricing, in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_price

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_price

The unit price of the item in the store’s base currency, excluding tax.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_price_incl_tax

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_price_incl_tax

The unit price of the item in the store’s base currency, including tax.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_invoiced

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_invoiced

The total invoiced amount for this item’s row, in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_total

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_total

The total price for this item’s row (quantity * price), excluding tax, in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_total_incl_tax

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_total_incl_tax

The total price for this item’s row (quantity * price), including tax, in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_tax_amount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_tax_amount

The total tax amount applied to this item in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_tax_invoiced

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_tax_invoiced

The amount of tax that has been invoiced for this item, in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_tax_refunded

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_tax_refunded

The amount of tax that has been refunded for this item, in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.created_at

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.created_at

The date and time when this order item was created.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_amount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_amount

The discount amount applied to this item in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_invoiced

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_invoiced

The amount of discount that has been invoiced for this item.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_percent

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_percent

The percentage of the discount applied to this item.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_refunded

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_refunded

The amount of discount that has been refunded for this item.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_amount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_amount

The amount of tax compensation applied due to discounts for this item, in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_canceled

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_canceled

The amount of tax compensation for discounts that has been canceled for this 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 amount of tax compensation for discounts that has been invoiced for this item.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_refunded

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_refunded

The amount of tax compensation for discounts that has been refunded for this item.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.amount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.amount

The total tax amount for a specific itemized tax applied to an item within a shipping assignment.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.base_amount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.base_amount

The tax amount in the store’s base currency for a specific itemized tax applied to an item within a shipping assignment.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.item_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.item_id

The ID of the item to which the specific itemized tax applies within a shipping assignment.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_amount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_amount

The actual tax amount, after any adjustments, for a specific itemized tax applied to an item within a shipping assignment.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_base_amount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_base_amount

The actual tax amount in the store’s base currency, after any adjustments, for a specific itemized tax applied to an item within a shipping assignment.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_code

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_code

The code assigned to this specific itemized tax component.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_id

The identifier for the specific tax rule or rate applied as part of this itemized tax component.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_item_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_item_id

A unique identifier for the specific itemized tax entry on an item within a shipping assignment.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_percent

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_percent

The percentage rate of this specific itemized tax component.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.taxable_item_type

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.taxable_item_type

The type of item (e.g., product, shipping) that the specific itemized tax applies to within a shipping assignment.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.free_shipping

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.free_shipping

Indicates whether free shipping was applied to this item (1 for yes, 0 for no).

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_qty_decimal

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_qty_decimal

Indicates if the quantity for this item can be expressed as a decimal value (e.g., for products sold by weight).

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_virtual

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_virtual

Indicates if the item is a virtual product, such as a service or digital download (1 for virtual, 0 for physical).

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.item_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.item_id

The unique identifier for this specific item within the order.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.name

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.name

The name of the product in the order item.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.no_discount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.no_discount

Indicates if this item is excluded from discount calculations.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.order_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.order_id

The unique identifier for the order this item belongs to.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.original_price

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.original_price

The original unit price of the item in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.amount_refunded

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.amount_refunded

The amount refunded for the parent item, if this item is part of a configurable or bundle product.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.applied_rule_ids

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.applied_rule_ids

A list of rule IDs applied to the parent item associated with a product in a shipping assignment.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_amount_refunded

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_amount_refunded

The amount refunded for the parent item, expressed in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_amount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_amount

The discount amount applied to the parent item, expressed in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_invoiced

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_invoiced

The amount of discount invoiced for the parent item, expressed in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_refunded

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_refunded

The amount of discount refunded for the parent item, expressed in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_tax_compensation_amount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_tax_compensation_amount

The discount tax compensation amount for the parent item, expressed in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_tax_compensation_invoiced

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_tax_compensation_invoiced

The discount tax compensation amount invoiced for the parent item, expressed in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_tax_compensation_refunded

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_tax_compensation_refunded

The discount tax compensation amount refunded for the parent item, expressed in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_original_price

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_original_price

The original price of the parent item, expressed in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_price

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_price

The price of the parent item before discounts and taxes, expressed in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_price_incl_tax

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_price_incl_tax

The price of the parent item including tax, expressed in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_invoiced

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_invoiced

The invoiced row total for the parent item, expressed in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_total

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_total

The total row price for the parent item (quantity * base price), expressed in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_total_incl_tax

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_total_incl_tax

The total row price for the parent item including tax, expressed in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_tax_amount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_tax_amount

The tax amount for the parent item, expressed in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_tax_invoiced

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_tax_invoiced

The tax amount invoiced for the parent item, expressed in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_tax_refunded

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_tax_refunded

The tax amount refunded for the parent item, expressed in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.created_at

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.created_at

The date and time when the parent item was created.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_amount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_amount

The discount amount applied to the parent item, expressed in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_invoiced

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_invoiced

The amount of discount invoiced for the parent item, expressed in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_percent

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_percent

The discount percentage applied to the parent item.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_refunded

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_refunded

The amount of discount refunded for the parent item, expressed in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_amount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_amount

The discount tax compensation amount for the parent item, expressed in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_canceled

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_canceled

The discount tax compensation amount canceled for the parent item, expressed in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_invoiced

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_invoiced

The discount tax compensation amount invoiced for the parent item, expressed in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_refunded

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_refunded

The discount tax compensation amount refunded for the parent item, expressed in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.amount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.amount

The amount of an itemized tax applied to a parent item within a shipping assignment.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.base_amount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.base_amount

The base currency amount of an itemized tax applied to a parent item within a shipping assignment.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.item_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.item_id

The ID of the item to which this specific itemized tax applies, within a shipping assignment.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_amount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_amount

The actual amount of an itemized tax applied to a parent item within a shipping assignment.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_base_amount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_base_amount

The actual base currency amount of an itemized tax applied to a parent item within a shipping assignment.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_code

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_code

The tax code associated with this itemized tax on a parent item within a shipping assignment.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_id

The unique identifier for this itemized tax on a parent item within a shipping assignment.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_item_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_item_id

The unique identifier for the tax item record associated with a parent item within a shipping assignment.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_percent

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_percent

The tax rate percentage for this itemized tax on a parent item within a shipping assignment.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.taxable_item_type

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.taxable_item_type

The type of item that this itemized tax applies to (e.g., product, shipping), for a parent item within a shipping assignment.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.free_shipping

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.free_shipping

Indicates whether free shipping was applied to the parent item (0 for no, 1 for yes).

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.is_qty_decimal

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.is_qty_decimal

Indicates if the quantity of the parent item can be a decimal value.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.is_virtual

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.is_virtual

Indicates if the parent item is a virtual product (e.g., a service or digital download).

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.item_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.item_id

The unique identifier for the parent order item.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.name

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.name

The name of the parent product.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.no_discount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.no_discount

Indicates if no discount is applied to the parent item.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.order_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.order_id

The ID of the order to which the parent item belongs.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.original_price

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.original_price

The original price of the parent item, expressed in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.price

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.price

The price of the parent item before discounts and taxes, expressed in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.price_incl_tax

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.price_incl_tax

The price of the parent item including tax, expressed in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_id

The ID of the product associated with this parent item.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_id

The identifier for a selected option within a bundle product, associated with a parent item in a shipping assignment.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_qty

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_qty

The quantity of a selected option within a bundle product, associated with a parent item in a shipping assignment.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM}

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM}

A specific selection made for an option within a bundle product, associated with a parent item in a shipping assignment.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_id

The ID of a configurable option selected for the parent item. This indicates a specific attribute chosen by the customer (e.g., ‘color’ option ID).

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value

The value of a configurable option selected for the parent item. This represents the specific choice made by the customer (e.g., ‘red’ for color).

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_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 ID of a custom option chosen for a parent product within an item in a shipping assignment.

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 selected value for a custom option of a parent product within an item in a shipping assignment.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_type

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_type

The type of product for the parent item (e.g., ‘configurable’, ‘bundle’).

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_canceled

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_canceled

The quantity of the parent item that has been canceled.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_invoiced

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_invoiced

The quantity of the parent item that has been invoiced.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_ordered

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_ordered

The quantity of the parent item that was originally ordered.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_refunded

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_refunded

The quantity of the parent item that has been refunded.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_returned

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_returned

The quantity of the parent item that has been returned.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_shipped

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_shipped

The quantity of the parent item that has been shipped.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.quote_item_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.quote_item_id

The ID of the quote item from which this parent item originated.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_invoiced

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_invoiced

The invoiced row total for the parent item, expressed in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_total

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_total

The total row price for the parent item (quantity * price), expressed in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_total_incl_tax

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_total_incl_tax

The total row price for the parent item including tax, expressed in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_weight

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_weight

The total weight of the parent item for the current row, based on quantity.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.sku

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.sku

The Stock Keeping Unit (SKU) of the parent product.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.store_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.store_id

The ID of the store where the order containing this parent item was placed.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_amount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_amount

The tax amount for the parent item, expressed in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_canceled

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_canceled

The tax amount canceled for the parent item, expressed in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_invoiced

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_invoiced

The tax amount invoiced for the parent item, expressed in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_percent

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_percent

The tax percentage applied to the parent item.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_refunded

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_refunded

The tax amount refunded for the parent item, expressed in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.updated_at

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.updated_at

The date and time when the parent item was last updated.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.weee_tax_applied

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.weee_tax_applied

Information about WEEE (Waste Electrical and Electronic Equipment) tax applied to the parent item, if any.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.weight

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.weight

The weight of a single unit of the parent item.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item_id

The ID of the parent item for a product within a shipping assignment, typically used for configurable or bundled products.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price

The unit price of the item in the order’s currency, excluding tax.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price_incl_tax

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price_incl_tax

The unit price of the item in the order’s currency, including tax.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_id

The unique identifier of the product that this order item represents.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_id

The identifier for a selected option within a bundle product, associated with an item in a shipping assignment.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_qty

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_qty

The quantity of a selected option within a bundle product, associated with an item in a shipping assignment.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM}

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM}

A specific selection made for an option within a bundle product, associated with an item in a shipping assignment.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_id

The identifier for a specific configurable option chosen for this product.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_value

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_value

The value selected for a specific configurable option for this product.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_id

The ID of a custom option chosen for a product within a shipping assignment.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_value

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_value

The selected value for a custom option of a product within a shipping assignment.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_type

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_type

The type of product, such as simple, configurable, virtual, or bundle.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_backordered

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_backordered

The quantity of the item that is currently on backorder within a specific shipping assignment.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_canceled

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_canceled

The quantity of this item that has been canceled from the order.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_invoiced

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_invoiced

The quantity of this item that has been invoiced.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_ordered

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_ordered

The original quantity of this item placed in the order.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_refunded

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_refunded

The quantity of this item that has been refunded.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_returned

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_returned

The quantity of this item that has been returned by the customer.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_shipped

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_shipped

The quantity of this item that has been shipped.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.quote_item_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.quote_item_id

The identifier for the corresponding item in the customer’s quote or shopping cart.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_invoiced

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_invoiced

The total invoiced amount for this item’s row, in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_total

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_total

The total price for this item’s row (quantity * price), excluding tax, in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_total_incl_tax

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_total_incl_tax

The total price for this item’s row (quantity * price), including tax, in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_weight

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_weight

The total weight of the quantity of this item in the order row.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.sku

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.sku

The Stock Keeping Unit (SKU) of the product associated with this order item.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.store_id

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.store_id

The identifier of the store where the order containing this item was placed.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_amount

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_amount

The total tax amount applied to this item in the order’s currency.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_canceled

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_canceled

The amount of tax that has been canceled for this item.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_invoiced

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_invoiced

The amount of tax that has been invoiced for this item.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_percent

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_percent

The percentage rate of the tax applied to this item.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_refunded

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_refunded

The amount of tax that has been refunded for this item.

metric

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.updated_at

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.updated_at

The date and time when this order item was last updated.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.weee_tax_applied

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.weee_tax_applied

Information about any WEEE (Waste Electrical and Electronic Equipment) tax applied to this item.

dimension

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.weight

extension_attributes.shipping_assignments.{NUM}.items.{NUM}.weight

The unit weight of the product associated with this order item.

metric

extension_attributes.shipping_assignments.{NUM}.shipping.address.address_type

extension_attributes.shipping_assignments.{NUM}.shipping.address.address_type

The type of address (e.g., ‘shipping’ or ‘billing’).

dimension

extension_attributes.shipping_assignments.{NUM}.shipping.address.city

extension_attributes.shipping_assignments.{NUM}.shipping.address.city

The city of the shipping address.

dimension

extension_attributes.shipping_assignments.{NUM}.shipping.address.company

extension_attributes.shipping_assignments.{NUM}.shipping.address.company

The company name associated with the shipping address.

dimension

extension_attributes.shipping_assignments.{NUM}.shipping.address.country_id

extension_attributes.shipping_assignments.{NUM}.shipping.address.country_id

The two-letter ISO country code for the shipping address (e.g., ‘US’, ‘GB’).

dimension

extension_attributes.shipping_assignments.{NUM}.shipping.address.customer_address_id

extension_attributes.shipping_assignments.{NUM}.shipping.address.customer_address_id

The ID of the customer’s address book entry used for this shipping address.

dimension

extension_attributes.shipping_assignments.{NUM}.shipping.address.customer_id

extension_attributes.shipping_assignments.{NUM}.shipping.address.customer_id

The ID of the customer associated with this shipping address.

dimension

extension_attributes.shipping_assignments.{NUM}.shipping.address.email

extension_attributes.shipping_assignments.{NUM}.shipping.address.email

The email address associated with the shipping address.

dimension

extension_attributes.shipping_assignments.{NUM}.shipping.address.entity_id

extension_attributes.shipping_assignments.{NUM}.shipping.address.entity_id

A unique identifier for the address entity.

dimension

extension_attributes.shipping_assignments.{NUM}.shipping.address.fax

extension_attributes.shipping_assignments.{NUM}.shipping.address.fax

The fax number for the shipping address.

dimension

extension_attributes.shipping_assignments.{NUM}.shipping.address.firstname

extension_attributes.shipping_assignments.{NUM}.shipping.address.firstname

The first name of the recipient at the shipping address.

dimension

extension_attributes.shipping_assignments.{NUM}.shipping.address.lastname

extension_attributes.shipping_assignments.{NUM}.shipping.address.lastname

The last name of the recipient for a specific shipping address within a shipping assignment.

dimension

extension_attributes.shipping_assignments.{NUM}.shipping.address.middlename

extension_attributes.shipping_assignments.{NUM}.shipping.address.middlename

The middle name of the recipient for the shipping address within a shipping assignment.

dimension

extension_attributes.shipping_assignments.{NUM}.shipping.address.parent_id

extension_attributes.shipping_assignments.{NUM}.shipping.address.parent_id

The ID of the parent entity associated with the shipping address within a shipping assignment.

dimension

extension_attributes.shipping_assignments.{NUM}.shipping.address.postcode

extension_attributes.shipping_assignments.{NUM}.shipping.address.postcode

The postal code for a specific shipping address within a shipping assignment.

metric

extension_attributes.shipping_assignments.{NUM}.shipping.address.prefix

extension_attributes.shipping_assignments.{NUM}.shipping.address.prefix

A salutation or title (e.g., ‘Mr.’, ‘Ms.’, ‘Dr.’) associated with the recipient’s name 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 (state or province) for a specific 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 (state or province) for a specific shipping address.

dimension

extension_attributes.shipping_assignments.{NUM}.shipping.address.region_id

extension_attributes.shipping_assignments.{NUM}.shipping.address.region_id

The internal identifier for the region (state or province) for a specific shipping address.

dimension

extension_attributes.shipping_assignments.{NUM}.shipping.address.street.{NUM}

extension_attributes.shipping_assignments.{NUM}.shipping.address.street.{NUM}

A specific line of the street address for the shipping location.

dimension

extension_attributes.shipping_assignments.{NUM}.shipping.address.suffix

extension_attributes.shipping_assignments.{NUM}.shipping.address.suffix

The suffix of the recipient’s name for the shipping address within a shipping assignment.

dimension

extension_attributes.shipping_assignments.{NUM}.shipping.address.telephone

extension_attributes.shipping_assignments.{NUM}.shipping.address.telephone

The telephone number associated with the shipping address.

dimension

extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_id

extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_id

The Value Added Tax (VAT) identification number associated with the shipping address, used for tax calculation and compliance.

dimension

extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_is_valid

extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_is_valid

A flag indicating if the VAT ID provided for the shipping address within a shipping assignment is valid.

metric

extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_request_success

extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_request_success

Indicates if the VAT ID validation request for the shipping address within a shipping assignment was successful.

metric

extension_attributes.shipping_assignments.{NUM}.shipping.method

extension_attributes.shipping_assignments.{NUM}.shipping.method

The selected shipping method (e.g., ‘flatrate_flatrate’, ‘ups_ground’) for a particular shipping assignment.

dimension

extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_amount

extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_amount

The shipping amount for a specific shipping assignment in the store’s base currency, before any discounts or taxes.

metric

extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_canceled

extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_canceled

The amount of the shipping cost that has been canceled for a specific shipping assignment, in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_discount_amount

extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_discount_amount

The amount of discount applied to the shipping cost for a specific shipping assignment, in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_discount_tax_compensation_amnt

extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_discount_tax_compensation_amnt

The amount of tax compensation for shipping discounts in the store’s base currency. This adjusts tax calculation when discounts are applied.

metric

extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_incl_tax

extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_incl_tax

The total shipping amount for a specific shipping assignment, including taxes, in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_invoiced

extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_invoiced

The amount of shipping cost that has been invoiced for a specific shipping assignment, in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_refunded

extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_refunded

The amount of shipping cost that has been refunded for a specific shipping assignment, in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_tax_amount

extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_tax_amount

The amount of tax applied to the shipping cost for a specific shipping assignment, in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_tax_refunded

extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_tax_refunded

The amount of tax on the shipping cost that has been refunded for a specific shipping assignment, in the store’s base currency.

metric

extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_amount

extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_amount

The shipping amount for a specific shipping assignment in the display currency, before any discounts or taxes.

metric

extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_canceled

extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_canceled

The amount of the shipping cost that has been canceled for a specific shipping assignment, in the display currency.

metric

extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_discount_amount

extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_discount_amount

The amount of discount applied to the shipping cost for a specific shipping assignment, in the display currency.

metric

extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_discount_tax_compensation_amount

extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_discount_tax_compensation_amount

The amount of tax compensation for shipping discounts in the order’s currency. This adjusts tax calculation when discounts are applied.

metric

extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_incl_tax

extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_incl_tax

The total shipping amount for a specific shipping assignment, including taxes, in the display currency.

metric

extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_invoiced

extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_invoiced

The amount of shipping cost that has been invoiced for a specific shipping assignment, in the display currency.

metric

extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_refunded

extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_refunded

The amount of shipping cost that has been refunded for a specific shipping assignment, in the display currency.

metric

extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_tax_amount

extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_tax_amount

The amount of tax applied to the shipping cost for a specific shipping assignment, in the display currency.

metric

extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_tax_refunded

extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_tax_refunded

The amount of tax on the shipping cost that has been refunded for a specific shipping assignment, in the display currency.

metric

extension_attributes.source_code

extension_attributes.source_code

The code of the inventory source associated with a shipment item, relevant for Multi-Source Inventory (MSI).

dimension

extension_attributes.sources.{NUM}.qty_available

extension_attributes.sources.{NUM}.qty_available

The quantity of a specific product currently available in a particular inventory source.

metric

extension_attributes.sources.{NUM}.qty_to_deduct

extension_attributes.sources.{NUM}.qty_to_deduct

The quantity of a product to be deducted from a specific inventory source.

metric

extension_attributes.sources.{NUM}.sku

extension_attributes.sources.{NUM}.sku

The Stock Keeping Unit (SKU) of the product associated with a specific inventory source.

dimension

extension_attributes.sources.{NUM}.source_code

extension_attributes.sources.{NUM}.source_code

The unique code identifying a specific inventory source from which products are managed or shipped.

dimension

extension_attributes.taxes.{NUM}.amount

extension_attributes.taxes.{NUM}.amount

The calculated tax amount for a specific tax entry, in the display currency.

metric

extension_attributes.taxes.{NUM}.base_amount

extension_attributes.taxes.{NUM}.base_amount

The calculated tax amount for a specific tax entry, in the store’s base currency.

metric

extension_attributes.taxes.{NUM}.base_real_amount

extension_attributes.taxes.{NUM}.base_real_amount

The actual tax amount for a tax entry in the store’s base currency, after all adjustments.

metric

extension_attributes.taxes.{NUM}.code

extension_attributes.taxes.{NUM}.code

The code or identifier for a specific tax rule or class applied.

dimension

extension_attributes.taxes.{NUM}.order_id

extension_attributes.taxes.{NUM}.order_id

The ID of the order to which this tax entry applies.

dimension

extension_attributes.taxes.{NUM}.percent

extension_attributes.taxes.{NUM}.percent

The tax rate applied, expressed as a percentage.

metric

extension_attributes.taxes.{NUM}.position

extension_attributes.taxes.{NUM}.position

The display position or order for a tax entry.

metric

extension_attributes.taxes.{NUM}.priority

extension_attributes.taxes.{NUM}.priority

The priority level of the tax rule applied for a tax entry.

metric

extension_attributes.taxes.{NUM}.process

extension_attributes.taxes.{NUM}.process

Indicates the tax processing method or status for a tax entry.

metric

extension_attributes.taxes.{NUM}.tax_id

extension_attributes.taxes.{NUM}.tax_id

The unique identifier for the specific tax entry or tax rule applied.

dimension

extension_attributes.taxes.{NUM}.title

extension_attributes.taxes.{NUM}.title

The descriptive title or label for the tax applied (e.g., ‘Sales Tax’, ‘VAT’).

dimension

extension_attributes.website_ids.{NUM}

extension_attributes.website_ids.{NUM}

An ID of a website associated with the entity, typically indicating where it is available or configured.

dimension

firstname

firstname

The first name of the customer.

dimension

free_shipping

free_shipping

A boolean indicator specifying if free shipping was applied to the order or item.

metric

gender

gender

The gender of the customer.

metric

global_currency_code

global_currency_code

The ISO 4217 currency code for the global base currency configured for the store.

dimension

grand_total

grand_total

The final total amount of the order, including all items, shipping, taxes, and discounts.

metric

group_id

group_id

The ID of the customer group to which the customer belongs.

dimension

hold_before_state

hold_before_state

The state of the order or entity before it was placed on hold.

dimension

hold_before_status

hold_before_status

The status of the order or entity before it was placed on hold.

dimension

id

id

The unique identifier for the entity (e.g., customer, order, product).

dimension

increment_id

increment_id

The human-readable increment ID (order number) of the order.

dimension

is_qty_decimal

is_qty_decimal

A boolean indicator specifying whether the quantity for the product or item can be a decimal value.

metric

is_used_for_refund

is_used_for_refund

Indicates if an invoice has been used for a refund.

metric

is_virtual

is_virtual

A boolean indicator specifying whether the product or item is virtual and does not require shipping.

metric

item_id

item_id

A unique identifier for an individual item, typically within an order.

dimension

items.{NUM}.amount_refunded

items.{NUM}.amount_refunded

The total amount refunded for this specific order item in the display currency.

metric

items.{NUM}.applied_rule_ids

items.{NUM}.applied_rule_ids

A comma-separated list of IDs of the promotional rules that were applied to this order item.

dimension

items.{NUM}.base_amount_refunded

items.{NUM}.base_amount_refunded

The total amount refunded for this specific order item in the store’s base currency.

metric

items.{NUM}.base_cost

items.{NUM}.base_cost

The base cost of an individual item in the order.

metric

items.{NUM}.base_discount_amount

items.{NUM}.base_discount_amount

The discount amount applied to this order item in the store’s base currency.

metric

items.{NUM}.base_discount_invoiced

items.{NUM}.base_discount_invoiced

The amount of discount for this order item that has been invoiced, in the store’s base currency.

metric

items.{NUM}.base_discount_refunded

items.{NUM}.base_discount_refunded

The amount of discount for this order item that has been refunded, in the store’s base currency.

metric

items.{NUM}.base_discount_tax_compensation_amount

items.{NUM}.base_discount_tax_compensation_amount

The amount of tax compensation for an item’s discount in the store’s base currency. This adjusts tax calculation when discounts are applied.

metric

items.{NUM}.base_discount_tax_compensation_invoiced

items.{NUM}.base_discount_tax_compensation_invoiced

The invoiced amount of tax compensation for an item’s discount in the store’s base currency.

metric

items.{NUM}.base_discount_tax_compensation_refunded

items.{NUM}.base_discount_tax_compensation_refunded

The refunded amount of tax compensation for an item’s discount in the store’s base currency.

metric

items.{NUM}.base_original_price

items.{NUM}.base_original_price

The original price of the product associated with this order item, in the store’s base currency, before any special pricing or discounts.

metric

items.{NUM}.base_price

items.{NUM}.base_price

The price of the product associated with this order item, in the store’s base currency, after any special pricing but before item-level discounts.

metric

items.{NUM}.base_price_incl_tax

items.{NUM}.base_price_incl_tax

The price of the product associated with this order item, including taxes, in the store’s base currency.

metric

items.{NUM}.base_row_invoiced

items.{NUM}.base_row_invoiced

The total amount of the row (quantity * price) for this order item that has been invoiced, in the store’s base currency.

metric

items.{NUM}.base_row_total

items.{NUM}.base_row_total

The total amount of the row (quantity * price) for this order item, in the store’s base currency, before taxes and discounts.

metric

items.{NUM}.base_row_total_incl_tax

items.{NUM}.base_row_total_incl_tax

The total amount of the row (quantity * price) for this order item, including taxes, in the store’s base currency.

metric

items.{NUM}.base_tax_amount

items.{NUM}.base_tax_amount

The amount of tax applied to this order item, in the store’s base currency.

metric

items.{NUM}.base_tax_invoiced

items.{NUM}.base_tax_invoiced

The amount of tax for this order item that has been invoiced, in the store’s base currency.

metric

items.{NUM}.base_tax_refunded

items.{NUM}.base_tax_refunded

The amount of tax for this order item that has been refunded, in the store’s base currency.

metric

items.{NUM}.created_at

items.{NUM}.created_at

The timestamp indicating when this order item was created.

dimension

items.{NUM}.discount_amount

items.{NUM}.discount_amount

The discount amount applied to this order item in the display currency.

metric

items.{NUM}.discount_invoiced

items.{NUM}.discount_invoiced

The amount of discount for this order item that has been invoiced, in the display currency.

metric

items.{NUM}.discount_percent

items.{NUM}.discount_percent

The discount rate applied to this order item, expressed as a percentage.

metric

items.{NUM}.discount_refunded

items.{NUM}.discount_refunded

The amount of discount for this order item that has been refunded, in the display currency.

metric

items.{NUM}.discount_tax_compensation_amount

items.{NUM}.discount_tax_compensation_amount

The amount of tax compensation for an item’s discount in the order’s currency. This adjusts tax calculation when discounts are applied.

metric

items.{NUM}.discount_tax_compensation_canceled

items.{NUM}.discount_tax_compensation_canceled

The canceled amount of tax compensation for an item’s discount.

metric

items.{NUM}.discount_tax_compensation_invoiced

items.{NUM}.discount_tax_compensation_invoiced

The invoiced amount of tax compensation for an item’s discount.

metric

items.{NUM}.discount_tax_compensation_refunded

items.{NUM}.discount_tax_compensation_refunded

The refunded amount of tax compensation for an item’s discount.

metric

items.{NUM}.entity_id

items.{NUM}.entity_id

The unique identifier for an item within an entity like an invoice or shipment.

dimension

items.{NUM}.extension_attributes.itemized_taxes.{NUM}.amount

items.{NUM}.extension_attributes.itemized_taxes.{NUM}.amount

The amount for a specific itemized tax component applied to this order item, in the display currency.

metric

items.{NUM}.extension_attributes.itemized_taxes.{NUM}.base_amount

items.{NUM}.extension_attributes.itemized_taxes.{NUM}.base_amount

The amount for a specific itemized tax component applied to this order item, in the store’s base currency.

metric

items.{NUM}.extension_attributes.itemized_taxes.{NUM}.item_id

items.{NUM}.extension_attributes.itemized_taxes.{NUM}.item_id

The unique identifier of the order item to which this itemized tax component applies.

dimension

items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_amount

items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_amount

The actual tax amount, after any adjustments, for a specific itemized tax applied to an order item.

metric

items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_base_amount

items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_base_amount

The actual tax amount in the store’s base currency, after any adjustments, for a specific itemized tax applied to an order item.

metric

items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_code

items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_code

The code or identifier for this specific itemized tax component.

dimension

items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_id

items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_id

The unique identifier for this specific itemized tax component.

dimension

items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_item_id

items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_item_id

A unique identifier for the specific itemized tax entry on an order item.

dimension

items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_percent

items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_percent

The tax rate applied for this specific itemized tax component, expressed as a percentage.

metric

items.{NUM}.extension_attributes.itemized_taxes.{NUM}.taxable_item_type

items.{NUM}.extension_attributes.itemized_taxes.{NUM}.taxable_item_type

The type of item that is subject to this specific tax component (e.g., ‘product’, ‘shipping’).

dimension

items.{NUM}.free_shipping

items.{NUM}.free_shipping

A boolean indicator specifying if free shipping was applied specifically to this order item.

metric

items.{NUM}.is_qty_decimal

items.{NUM}.is_qty_decimal

A boolean indicator specifying whether the quantity for this particular order item can be a decimal value.

metric

items.{NUM}.is_virtual

items.{NUM}.is_virtual

A boolean indicator specifying whether this order item is virtual and does not require shipping.

metric

items.{NUM}.item_id

items.{NUM}.item_id

The unique identifier for this specific order item.

dimension

items.{NUM}.name

items.{NUM}.name

The name of the product associated with this order item.

dimension

items.{NUM}.no_discount

items.{NUM}.no_discount

A flag indicating whether a specific item is excluded from discount calculations.

metric

items.{NUM}.order_id

items.{NUM}.order_id

The unique identifier of the order to which this item belongs.

dimension

items.{NUM}.order_item_id

items.{NUM}.order_item_id

The unique identifier of the original order item associated with this invoice or shipment item.

dimension

items.{NUM}.original_price

items.{NUM}.original_price

The original price of the product associated with this order item, in the display currency, before any special pricing or discounts.

metric

items.{NUM}.parent_id

items.{NUM}.parent_id

The unique identifier of the parent entity (e.g., invoice, shipment) to which this item belongs.

dimension

items.{NUM}.parent_item.amount_refunded

items.{NUM}.parent_item.amount_refunded

The total amount refunded for the parent item in the order currency.

metric

items.{NUM}.parent_item.applied_rule_ids

items.{NUM}.parent_item.applied_rule_ids

A comma-separated list of IDs of the pricing rules (e.g., cart price rules) applied to the parent item.

dimension

items.{NUM}.parent_item.base_amount_refunded

items.{NUM}.parent_item.base_amount_refunded

The total amount refunded for the parent item in the store’s base currency.

metric

items.{NUM}.parent_item.base_discount_amount

items.{NUM}.parent_item.base_discount_amount

The total discount amount applied to the parent item in the store’s base currency.

metric

items.{NUM}.parent_item.base_discount_invoiced

items.{NUM}.parent_item.base_discount_invoiced

The discounted amount that has been invoiced for the parent item in the store’s base currency.

metric

items.{NUM}.parent_item.base_discount_refunded

items.{NUM}.parent_item.base_discount_refunded

The discounted amount that has been refunded for the parent item in the store’s base currency.

metric

items.{NUM}.parent_item.base_discount_tax_compensation_amount

items.{NUM}.parent_item.base_discount_tax_compensation_amount

The amount of tax compensation for discounts applied to the parent item, in the store’s base currency.

metric

items.{NUM}.parent_item.base_discount_tax_compensation_invoiced

items.{NUM}.parent_item.base_discount_tax_compensation_invoiced

The amount of invoiced tax compensation for discounts applied to the parent item, in the store’s base currency.

metric

items.{NUM}.parent_item.base_discount_tax_compensation_refunded

items.{NUM}.parent_item.base_discount_tax_compensation_refunded

The amount of refunded tax compensation for discounts applied to the parent item, in the store’s base currency.

metric

items.{NUM}.parent_item.base_original_price

items.{NUM}.parent_item.base_original_price

The original price of the parent item before any discounts, in the store’s base currency.

metric

items.{NUM}.parent_item.base_price

items.{NUM}.parent_item.base_price

The price of the parent item per unit, in the store’s base currency.

metric

items.{NUM}.parent_item.base_price_incl_tax

items.{NUM}.parent_item.base_price_incl_tax

The price of the parent item per unit, including tax, in the store’s base currency.

metric

items.{NUM}.parent_item.base_row_invoiced

items.{NUM}.parent_item.base_row_invoiced

The total invoiced amount for the parent item row (price * quantity) in the store’s base currency.

metric

items.{NUM}.parent_item.base_row_total

items.{NUM}.parent_item.base_row_total

The total amount for the parent item row (price * quantity) in the store’s base currency.

metric

items.{NUM}.parent_item.base_row_total_incl_tax

items.{NUM}.parent_item.base_row_total_incl_tax

The total amount for the parent item row (price * quantity), including tax, in the store’s base currency.

metric

items.{NUM}.parent_item.base_tax_amount

items.{NUM}.parent_item.base_tax_amount

The total tax amount applied to the parent item in the store’s base currency.

metric

items.{NUM}.parent_item.base_tax_invoiced

items.{NUM}.parent_item.base_tax_invoiced

The tax amount that has been invoiced for the parent item in the store’s base currency.

metric

items.{NUM}.parent_item.base_tax_refunded

items.{NUM}.parent_item.base_tax_refunded

The tax amount that has been refunded for the parent item in the store’s base currency.

metric

items.{NUM}.parent_item.created_at

items.{NUM}.parent_item.created_at

The date and time when the parent item was created in the order.

dimension

items.{NUM}.parent_item.discount_amount

items.{NUM}.parent_item.discount_amount

The total discount amount applied to the parent item in the order currency.

metric

items.{NUM}.parent_item.discount_invoiced

items.{NUM}.parent_item.discount_invoiced

The discounted amount that has been invoiced for the parent item in the order currency.

metric

items.{NUM}.parent_item.discount_percent

items.{NUM}.parent_item.discount_percent

The percentage of discount applied to the parent item.

metric

items.{NUM}.parent_item.discount_refunded

items.{NUM}.parent_item.discount_refunded

The discounted amount that has been refunded for the parent item in the order currency.

metric

items.{NUM}.parent_item.discount_tax_compensation_amount

items.{NUM}.parent_item.discount_tax_compensation_amount

The amount of tax compensation for discounts applied to the parent item, in the order currency.

metric

items.{NUM}.parent_item.discount_tax_compensation_canceled

items.{NUM}.parent_item.discount_tax_compensation_canceled

The amount of canceled tax compensation for discounts applied to the parent item.

metric

items.{NUM}.parent_item.discount_tax_compensation_invoiced

items.{NUM}.parent_item.discount_tax_compensation_invoiced

The amount of invoiced tax compensation for discounts applied to the parent item, in the order currency.

metric

items.{NUM}.parent_item.discount_tax_compensation_refunded

items.{NUM}.parent_item.discount_tax_compensation_refunded

The amount of refunded tax compensation for discounts applied to the parent item, in the order currency.

metric

items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.amount

items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.amount

The amount of an itemized tax applied to a parent item within an order item.

metric

items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.base_amount

items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.base_amount

The base currency amount of an itemized tax applied to a parent item within an order item.

metric

items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.item_id

items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.item_id

The ID of the item to which this specific itemized tax applies, for a parent item within an order item.

dimension

items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_amount

items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_amount

The actual amount of an itemized tax applied to a parent item within an order item.

metric

items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_base_amount

items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_base_amount

The actual base currency amount of an itemized tax applied to a parent item within an order item.

metric

items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_code

items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_code

The tax code associated with this itemized tax on a parent item within an order item.

dimension

items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_id

items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_id

The unique identifier for this itemized tax on a parent item within an order item.

dimension

items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_item_id

items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_item_id

The unique identifier for the tax item record associated with a parent item within an order item.

dimension

items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_percent

items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_percent

The tax rate percentage for this itemized tax on a parent item within an order item.

metric

items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.taxable_item_type

items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.taxable_item_type

The type of item that this itemized tax applies to (e.g., product, shipping), for a parent item within an order item.

dimension

items.{NUM}.parent_item.free_shipping

items.{NUM}.parent_item.free_shipping

Indicates whether free shipping was applied to the parent item (0 for no, 1 for yes).

metric

items.{NUM}.parent_item.is_qty_decimal

items.{NUM}.parent_item.is_qty_decimal

Indicates if the quantity of the parent item can be expressed as a decimal (0 for no, 1 for yes).

metric

items.{NUM}.parent_item.is_virtual

items.{NUM}.parent_item.is_virtual

Indicates if the parent item is a virtual product (0 for no, 1 for yes).

metric

items.{NUM}.parent_item.item_id

items.{NUM}.parent_item.item_id

The unique identifier of the parent item within the order.

dimension

items.{NUM}.parent_item.name

items.{NUM}.parent_item.name

The name of the parent item.

dimension

items.{NUM}.parent_item.no_discount

items.{NUM}.parent_item.no_discount

Indicates whether the parent item is excluded from discounts (0 for no, 1 for yes).

metric

items.{NUM}.parent_item.order_id

items.{NUM}.parent_item.order_id

The ID of the order to which this parent item belongs.

dimension

items.{NUM}.parent_item.original_price

items.{NUM}.parent_item.original_price

The original price of the parent item before any discounts, in the order currency.

metric

items.{NUM}.parent_item.price

items.{NUM}.parent_item.price

The price of the parent item per unit, in the order currency.

metric

items.{NUM}.parent_item.price_incl_tax

items.{NUM}.parent_item.price_incl_tax

The price of the parent item per unit, including tax, in the order currency.

metric

items.{NUM}.parent_item.product_id

items.{NUM}.parent_item.product_id

The unique identifier of the product associated with this parent item.

dimension

items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_id

items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_id

The identifier for a selected option within a bundle product, associated with a parent item in the order.

dimension

items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_qty

items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_qty

The quantity of a selected option within a bundle product, associated with a parent item in the order.

metric

items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM}

items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM}

A specific selection made for an option within a bundle product, associated with a parent item in the order.

metric

items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_id

items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_id

The ID of a configurable option selected for the parent item.

dimension

items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value

items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value

The selected value for a configurable option of the parent item.

metric

items.{NUM}.parent_item.product_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 a parent product within an order 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 selected value for a custom option of a parent product within an order item.

metric

items.{NUM}.parent_item.product_type

items.{NUM}.parent_item.product_type

The type of product for the parent item (e.g., ‘simple’, ‘configurable’, ‘bundle’).

dimension

items.{NUM}.parent_item.qty_canceled

items.{NUM}.parent_item.qty_canceled

The quantity of the parent item that has been canceled.

metric

items.{NUM}.parent_item.qty_invoiced

items.{NUM}.parent_item.qty_invoiced

The quantity of the parent item that has been invoiced.

metric

items.{NUM}.parent_item.qty_ordered

items.{NUM}.parent_item.qty_ordered

The quantity of the parent item that was originally ordered.

metric

items.{NUM}.parent_item.qty_refunded

items.{NUM}.parent_item.qty_refunded

The quantity of the parent item that has been refunded.

metric

items.{NUM}.parent_item.qty_returned

items.{NUM}.parent_item.qty_returned

The quantity of the parent item that has been returned.

metric

items.{NUM}.parent_item.qty_shipped

items.{NUM}.parent_item.qty_shipped

The quantity of the parent item that has been shipped.

metric

items.{NUM}.parent_item.quote_item_id

items.{NUM}.parent_item.quote_item_id

The ID of the quote item from which this parent item originated.

dimension

items.{NUM}.parent_item.row_invoiced

items.{NUM}.parent_item.row_invoiced

The total invoiced amount for the parent item row (price * quantity) in the order currency.

metric

items.{NUM}.parent_item.row_total

items.{NUM}.parent_item.row_total

The total amount for the parent item row (price * quantity) in the order currency.

metric

items.{NUM}.parent_item.row_total_incl_tax

items.{NUM}.parent_item.row_total_incl_tax

The total amount for the parent item row (price * quantity), including tax, in the order currency.

metric

items.{NUM}.parent_item.row_weight

items.{NUM}.parent_item.row_weight

The total weight of the parent item row (weight * quantity).

metric

items.{NUM}.parent_item.sku

items.{NUM}.parent_item.sku

The Stock Keeping Unit (SKU) of the parent product.

dimension

items.{NUM}.parent_item.store_id

items.{NUM}.parent_item.store_id

The ID of the store where the parent item was ordered.

dimension

items.{NUM}.parent_item.tax_amount

items.{NUM}.parent_item.tax_amount

The total tax amount applied to the parent item in the order currency.

metric

items.{NUM}.parent_item.tax_canceled

items.{NUM}.parent_item.tax_canceled

The tax amount that has been canceled for the parent item.

metric

items.{NUM}.parent_item.tax_invoiced

items.{NUM}.parent_item.tax_invoiced

The tax amount that has been invoiced for the parent item in the order currency.

metric

items.{NUM}.parent_item.tax_percent

items.{NUM}.parent_item.tax_percent

The tax percentage applied to the parent item.

metric

items.{NUM}.parent_item.tax_refunded

items.{NUM}.parent_item.tax_refunded

The tax amount that has been refunded for the parent item in the order currency.

metric

items.{NUM}.parent_item.updated_at

items.{NUM}.parent_item.updated_at

The date and time when this parent item was last updated.

dimension

items.{NUM}.parent_item.weee_tax_applied

items.{NUM}.parent_item.weee_tax_applied

Details of any WEEE (Waste Electrical and Electronic Equipment) tax applied to the parent order item.

dimension

items.{NUM}.parent_item.weight

items.{NUM}.parent_item.weight

The weight of the individual parent item.

metric

items.{NUM}.parent_item_id

items.{NUM}.parent_item_id

The ID of the parent item if this is a child item in a configurable or bundle product.

dimension

items.{NUM}.price

items.{NUM}.price

The price of the product associated with this order item, in the display currency, after any special pricing but before item-level discounts.

metric

items.{NUM}.price_incl_tax

items.{NUM}.price_incl_tax

The price of the product associated with this order item, including taxes, in the display currency.

metric

items.{NUM}.product_id

items.{NUM}.product_id

The unique identifier of the product from the catalog that this order item represents.

dimension

items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_id

items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_id

The identifier for a selected option within a bundle product, associated with an item in the order.

dimension

items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_qty

items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_qty

The quantity of a selected option within a bundle product, associated with an item in the order.

metric

items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM}

items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM}

A specific selection made for an option within a bundle product, associated with an item in the order.

metric

items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_id

items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_id

The unique identifier for a specific configurable product option selected for this order item.

dimension

items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_value

items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_value

The selected value for a specific configurable product option applied to this order item.

metric

items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_id

items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_id

The ID of a custom option selected for a product within an order item.

dimension

items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_value

items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_value

The selected value for a custom option of a product within an order item.

metric

items.{NUM}.product_type

items.{NUM}.product_type

The type of product (e.g., simple, configurable, virtual, bundle) that this order item represents.

dimension

items.{NUM}.qty

items.{NUM}.qty

The quantity of the item.

metric

items.{NUM}.qty_backordered

items.{NUM}.qty_backordered

The quantity of the individual item that is currently on backorder.

metric

items.{NUM}.qty_canceled

items.{NUM}.qty_canceled

The quantity of this order item that has been canceled.

metric

items.{NUM}.qty_invoiced

items.{NUM}.qty_invoiced

The quantity of this order item that has been invoiced.

metric

items.{NUM}.qty_ordered

items.{NUM}.qty_ordered

The original quantity of this product ordered as part of the order item.

metric

items.{NUM}.qty_refunded

items.{NUM}.qty_refunded

The quantity of this order item that has been refunded.

metric

items.{NUM}.qty_returned

items.{NUM}.qty_returned

The quantity of this order item that has been returned by the customer.

metric

items.{NUM}.qty_shipped

items.{NUM}.qty_shipped

The quantity of this order item that has been shipped.

metric

items.{NUM}.quote_item_id

items.{NUM}.quote_item_id

The unique identifier for the original quote item from which this order item was created.

dimension

items.{NUM}.row_invoiced

items.{NUM}.row_invoiced

The total amount of the row (quantity * price) for this order item that has been invoiced, in the display currency.

metric

items.{NUM}.row_total

items.{NUM}.row_total

The total amount of the row (quantity * price) for this order item, in the display currency, before taxes and discounts.

metric

items.{NUM}.row_total_incl_tax

items.{NUM}.row_total_incl_tax

The total amount of the row (quantity * price) for this order item, including taxes, in the display currency.

metric

items.{NUM}.row_weight

items.{NUM}.row_weight

The total weight of this order item, calculated as unit weight multiplied by the ordered quantity.

metric

items.{NUM}.sku

items.{NUM}.sku

The Stock Keeping Unit (SKU) of the product associated with this order item.

dimension

items.{NUM}.store_id

items.{NUM}.store_id

The unique identifier of the store from which this order item was purchased.

dimension

items.{NUM}.tax_amount

items.{NUM}.tax_amount

The amount of tax applied to this order item, in the display currency.

metric

items.{NUM}.tax_canceled

items.{NUM}.tax_canceled

The amount of tax for this order item that has been canceled, in the display currency.

metric

items.{NUM}.tax_invoiced

items.{NUM}.tax_invoiced

The amount of tax for this order item that has been invoiced, in the display currency.

metric

items.{NUM}.tax_percent

items.{NUM}.tax_percent

The tax rate applied to this order item, expressed as a percentage.

metric

items.{NUM}.tax_refunded

items.{NUM}.tax_refunded

The amount of tax for this order item that has been refunded, in the display currency.

metric

items.{NUM}.updated_at

items.{NUM}.updated_at

The date and time when this specific order item was last updated.

dimension

items.{NUM}.weee_tax_applied

items.{NUM}.weee_tax_applied

Details of any WEEE (Waste Electrical and Electronic Equipment) tax applied to this order item.

dimension

items.{NUM}.weight

items.{NUM}.weight

The weight of the individual order item.

metric

lastname

lastname

The last name of the customer.

dimension

media_gallery_entries.{NUM}.disabled

media_gallery_entries.{NUM}.disabled

Indicates if a media gallery entry (e.g., an image) is disabled for display.

dimension

media_gallery_entries.{NUM}.file

media_gallery_entries.{NUM}.file

The file path or URL for a media gallery entry.

dimension

media_gallery_entries.{NUM}.id

media_gallery_entries.{NUM}.id

The unique identifier for a media gallery entry.

metric

media_gallery_entries.{NUM}.label

media_gallery_entries.{NUM}.label

The label or alt text for a media gallery entry.

dimension

media_gallery_entries.{NUM}.media_type

media_gallery_entries.{NUM}.media_type

The type of media (e.g., image, video) for a gallery entry.

dimension

media_gallery_entries.{NUM}.position

media_gallery_entries.{NUM}.position

The display position of a media gallery entry.

metric

media_gallery_entries.{NUM}.types.{NUM}

media_gallery_entries.{NUM}.types.{NUM}

A type associated with the media gallery entry (e.g., ‘image’, ‘thumbnail’).

dimension

name

name

The name of the entity, such as a product name or a person’s name.

dimension

no_discount

no_discount

Indicates whether the item or order is excluded from discounts (0 for no, 1 for yes).

metric

options.{NUM}.image_size_x

options.{NUM}.image_size_x

The width in pixels for an image associated with a product option.

metric

options.{NUM}.image_size_y

options.{NUM}.image_size_y

The height in pixels for an image associated with a product option.

metric

options.{NUM}.is_require

options.{NUM}.is_require

Indicates if the product option is mandatory.

dimension

options.{NUM}.max_characters

options.{NUM}.max_characters

The maximum number of characters allowed for a text-based product option.

metric

options.{NUM}.option_id

options.{NUM}.option_id

The unique identifier for a product option.

dimension

options.{NUM}.price

options.{NUM}.price

The price associated with a product option.

metric

options.{NUM}.price_type

options.{NUM}.price_type

The type of price for a product option (e.g., fixed, percent).

dimension

options.{NUM}.product_sku

options.{NUM}.product_sku

The SKU of the product associated with this option.

dimension

options.{NUM}.sort_order

options.{NUM}.sort_order

The sorting order for a product option.

metric

options.{NUM}.title

options.{NUM}.title

The title or label of the product option.

dimension

options.{NUM}.type

options.{NUM}.type

The type of the product option (e.g., drop_down, radio, text).

dimension

order_currency_code

order_currency_code

The currency code used for the order.

dimension

order_id

order_id

The unique identifier for the order. In Magento, this is often referred to as ‘increment_id’ in API calls for searching by order number.

dimension

original_increment_id

original_increment_id

The customer-facing identifier for the original order or entity.

dimension

original_price

original_price

The original price of the item before any discounts, in the order currency.

metric

parent_item.amount_refunded

parent_item.amount_refunded

The amount refunded for a parent item (e.g., for a configurable product, this refers to the parent).

metric

parent_item.applied_rule_ids

parent_item.applied_rule_ids

A comma-separated list of rule IDs applied to a parent item.

dimension

parent_item.base_amount_refunded

parent_item.base_amount_refunded

The base currency amount refunded for a parent item.

metric

parent_item.base_discount_amount

parent_item.base_discount_amount

The base currency discount amount applied to a parent item.

metric

parent_item.base_discount_invoiced

parent_item.base_discount_invoiced

The invoiced discount amount for a parent item in the store’s base currency.

metric

parent_item.base_discount_refunded

parent_item.base_discount_refunded

The refunded discount amount for a parent item in the store’s base currency.

metric

parent_item.base_discount_tax_compensation_amount

parent_item.base_discount_tax_compensation_amount

The base currency amount of tax compensation applied due to discount for a parent item.

metric

parent_item.base_discount_tax_compensation_invoiced

parent_item.base_discount_tax_compensation_invoiced

The invoiced base currency amount of tax compensation for a parent item’s discount.

metric

parent_item.base_discount_tax_compensation_refunded

parent_item.base_discount_tax_compensation_refunded

The refunded base currency amount of tax compensation for a parent item’s discount.

metric

parent_item.base_original_price

parent_item.base_original_price

The original base currency price of a parent item before any discounts or special pricing.

metric

parent_item.base_price

parent_item.base_price

The base currency unit price of a parent item.

metric

parent_item.base_price_incl_tax

parent_item.base_price_incl_tax

The base currency unit price of a parent item, including tax.

metric

parent_item.base_row_invoiced

parent_item.base_row_invoiced

The invoiced row total for a parent item in the store’s base currency.

metric

parent_item.base_row_total

parent_item.base_row_total

The base currency row total (quantity * price) for a parent item.

metric

parent_item.base_row_total_incl_tax

parent_item.base_row_total_incl_tax

The base currency row total (quantity * price) for a parent item, including tax.

metric

parent_item.base_tax_amount

parent_item.base_tax_amount

The base currency tax amount applied to a parent item.

metric

parent_item.base_tax_invoiced

parent_item.base_tax_invoiced

The invoiced tax amount for a parent item in the store’s base currency.

metric

parent_item.base_tax_refunded

parent_item.base_tax_refunded

The refunded tax amount for a parent item in the store’s base currency.

metric

parent_item.created_at

parent_item.created_at

The date and time when the parent item was created.

dimension

parent_item.discount_amount

parent_item.discount_amount

The monetary amount of discount applied to the parent order item.

metric

parent_item.discount_invoiced

parent_item.discount_invoiced

The invoiced discount amount for a parent item in the order’s currency.

metric

parent_item.discount_percent

parent_item.discount_percent

The percentage discount applied to a parent item.

metric

parent_item.discount_refunded

parent_item.discount_refunded

The portion of the discount amount that has been refunded for the parent order item.

metric

parent_item.discount_tax_compensation_amount

parent_item.discount_tax_compensation_amount

The tax compensation amount for the discount applied to the parent order item.

metric

parent_item.discount_tax_compensation_canceled

parent_item.discount_tax_compensation_canceled

The canceled amount of tax compensation for a parent item’s discount.

metric

parent_item.discount_tax_compensation_invoiced

parent_item.discount_tax_compensation_invoiced

The invoiced amount of tax compensation for a parent item’s discount.

metric

parent_item.discount_tax_compensation_refunded

parent_item.discount_tax_compensation_refunded

The refunded amount of tax compensation for a parent item’s discount.

metric

parent_item.free_shipping

parent_item.free_shipping

A flag indicating if the parent item qualifies for free shipping.

metric

parent_item.is_qty_decimal

parent_item.is_qty_decimal

A flag indicating if the quantity of the parent item can be a decimal value.

metric

parent_item.is_virtual

parent_item.is_virtual

A flag indicating if the parent item is a virtual product (e.g., a service or download).

metric

parent_item.item_id

parent_item.item_id

Unique identifier for the parent order item.

dimension

parent_item.name

parent_item.name

The name of the parent order item.

dimension

parent_item.no_discount

parent_item.no_discount

A flag indicating if the parent item is excluded from discount calculations.

metric

parent_item.order_id

parent_item.order_id

The unique identifier of the order associated with the parent item.

dimension

parent_item.original_price

parent_item.original_price

The original price of the parent item before any discounts or special pricing are applied.

metric

parent_item.price

parent_item.price

The price of the parent order item.

metric

parent_item.price_incl_tax

parent_item.price_incl_tax

The price of the parent order item including tax.

metric

parent_item.product_id

parent_item.product_id

The unique identifier of the product associated with the parent order 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 ID of a configurable option chosen for a parent item (e.g., size or color option ID).

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 selected value for a configurable option chosen for a parent item (e.g., ‘Large’ for size).

metric

parent_item.product_option.extension_attributes.custom_options.{NUM}.option_id

parent_item.product_option.extension_attributes.custom_options.{NUM}.option_id

The ID of a custom product option selected for a parent item.

dimension

parent_item.product_option.extension_attributes.custom_options.{NUM}.option_value

parent_item.product_option.extension_attributes.custom_options.{NUM}.option_value

The selected value for a custom product option for a parent item.

metric

parent_item.product_type

parent_item.product_type

The type of the product associated with the parent order item (e.g., simple, configurable, bundle).

dimension

parent_item.qty_canceled

parent_item.qty_canceled

The quantity of the parent order item that has been canceled.

metric

parent_item.qty_invoiced

parent_item.qty_invoiced

The quantity of the parent order item that has been invoiced.

metric

parent_item.qty_ordered

parent_item.qty_ordered

The quantity of the parent order item that was originally ordered.

metric

parent_item.qty_refunded

parent_item.qty_refunded

The quantity of the parent order item that has been refunded.

metric

parent_item.qty_shipped

parent_item.qty_shipped

The quantity of the parent order item that has been shipped.

metric

parent_item.quote_item_id

parent_item.quote_item_id

The ID of the quote item corresponding to the parent item.

dimension

parent_item.row_invoiced

parent_item.row_invoiced

The invoiced row total for a parent item.

metric

parent_item.row_total

parent_item.row_total

The total amount of the row (quantity * price) for the parent order item, excluding tax and discounts.

metric

parent_item.row_total_incl_tax

parent_item.row_total_incl_tax

The total amount of the row (quantity * price) for the parent order item, including tax.

metric

parent_item.row_weight

parent_item.row_weight

The calculated weight of a parent item, considering its quantity.

metric

parent_item.sku

parent_item.sku

The Stock Keeping Unit (SKU) of the parent order item.

dimension

parent_item.store_id

parent_item.store_id

The unique identifier of the store where the parent order item was purchased.

dimension

parent_item.tax_amount

parent_item.tax_amount

The tax amount applied to the parent order item.

metric

parent_item.tax_canceled

parent_item.tax_canceled

The canceled tax amount for a parent item.

metric

parent_item.tax_invoiced

parent_item.tax_invoiced

The invoiced tax amount for a parent item.

metric

parent_item.tax_percent

parent_item.tax_percent

The tax percentage applied to the parent order item.

metric

parent_item.tax_refunded

parent_item.tax_refunded

The refunded tax amount for a parent item.

metric

parent_item.updated_at

parent_item.updated_at

The timestamp when the parent order item was last updated.

dimension

parent_item.weee_tax_applied

parent_item.weee_tax_applied

Information about WEEE (Waste Electrical and Electronic Equipment) tax applied to the parent order item.

dimension

parent_item.weight

parent_item.weight

The individual weight of the parent order item.

metric

parent_item_id

parent_item_id

The unique identifier of the parent item in a product hierarchy, such as a configurable product for a simple product.

dimension

payment.account_status

payment.account_status

The status of the payment account used for the order (e.g., ‘verified’).

dimension

payment.additional_data

payment.additional_data

Additional non-customer-facing data transferred during a payment transaction.

dimension

payment.additional_information.{NUM}

payment.additional_information.{NUM}

Additional information related to the payment method, which can vary by payment gateway.

dimension

payment.amount_authorized

payment.amount_authorized

The amount authorized for payment in the order currency.

metric

payment.amount_ordered

payment.amount_ordered

The total amount of the order in the order currency.

metric

payment.amount_paid

payment.amount_paid

The amount that has been paid for the order in the order currency.

metric

payment.amount_refunded

payment.amount_refunded

The amount that has been refunded for the order in the order currency.

metric

payment.base_amount_authorized

payment.base_amount_authorized

The amount authorized for 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.

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_amount_paid_online

payment.base_amount_paid_online

The amount paid online for the order in the store’s base currency.

metric

payment.base_amount_refunded

payment.base_amount_refunded

The amount that has been refunded for the order in the store’s base currency.

metric

payment.base_shipping_amount

payment.base_shipping_amount

The base shipping amount for the order in the store’s base currency.

metric

payment.base_shipping_captured

payment.base_shipping_captured

The base shipping amount that has been captured for the order in the store’s base currency.

metric

payment.base_shipping_refunded

payment.base_shipping_refunded

The base shipping amount that has been refunded for the order in the store’s base currency.

metric

payment.cc_exp_month

payment.cc_exp_month

The expiration month of the credit card used for payment (if applicable and available).

metric

payment.cc_exp_year

payment.cc_exp_year

The expiration year of the credit card used for payment (if applicable and available).

metric

payment.cc_last4

payment.cc_last4

The last four digits of the credit card number used for payment (if applicable and available).

dimension

payment.cc_ss_start_month

payment.cc_ss_start_month

The start month of the credit card, typically for cards like Switch or Solo.

metric

payment.cc_ss_start_year

payment.cc_ss_start_year

The start year of the credit card, typically for cards like Switch or Solo.

metric

payment.cc_trans_id

payment.cc_trans_id

The transaction ID from the credit card processing gateway.

dimension

payment.cc_type

payment.cc_type

The type of credit card used for payment (e.g., Visa, Mastercard).

dimension

payment.entity_id

payment.entity_id

The unique identifier for the payment record.

dimension

payment.extension_attributes.vault_payment_token.created_at

payment.extension_attributes.vault_payment_token.created_at

The date and time when the vaulted payment token was created.

dimension

payment.extension_attributes.vault_payment_token.customer_id

payment.extension_attributes.vault_payment_token.customer_id

The ID of the customer associated with the vaulted payment token.

dimension

payment.extension_attributes.vault_payment_token.entity_id

payment.extension_attributes.vault_payment_token.entity_id

The unique identifier for the vaulted payment token.

dimension

payment.extension_attributes.vault_payment_token.expires_at

payment.extension_attributes.vault_payment_token.expires_at

The expiration date and time of the vaulted payment token.

dimension

payment.extension_attributes.vault_payment_token.gateway_token

payment.extension_attributes.vault_payment_token.gateway_token

The token provided by the payment gateway for the vaulted payment method.

dimension

payment.extension_attributes.vault_payment_token.is_active

payment.extension_attributes.vault_payment_token.is_active

Indicates if the vaulted payment token is active.

dimension

payment.extension_attributes.vault_payment_token.is_visible

payment.extension_attributes.vault_payment_token.is_visible

Indicates if the vaulted payment token is visible to the customer.

dimension

payment.extension_attributes.vault_payment_token.payment_method_code

payment.extension_attributes.vault_payment_token.payment_method_code

The code of the payment method associated with the vaulted payment token (e.g., ‘paypal_express_vault’).

dimension

payment.extension_attributes.vault_payment_token.public_hash

payment.extension_attributes.vault_payment_token.public_hash

A public hash of the payment token for display purposes, without revealing sensitive information.

dimension

payment.extension_attributes.vault_payment_token.token_details

payment.extension_attributes.vault_payment_token.token_details

Detailed information about the vaulted payment token.

dimension

payment.extension_attributes.vault_payment_token.type

payment.extension_attributes.vault_payment_token.type

The type of vaulted payment token.

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’).

dimension

payment.parent_id

payment.parent_id

The ID of the order entity associated with this payment record.

dimension

payment.po_number

payment.po_number

The Purchase Order (PO) number associated with the payment for the order.

dimension

payment.shipping_amount

payment.shipping_amount

The shipping amount for the order in the order currency.

metric

payment.shipping_captured

payment.shipping_captured

The shipping amount that has been captured for the order in the order currency.

metric

payment.shipping_refunded

payment.shipping_refunded

The shipping amount that has been refunded for the order in the order currency.

metric

price

price

The price of the item per unit, in the order currency.

metric

price_incl_tax

price_incl_tax

The price of the item per unit, including tax, in the order currency.

metric

product_id

product_id

The unique identifier of the product associated with this order item.

dimension

product_links.{NUM}.link_type

product_links.{NUM}.link_type

The type of relationship between linked products (e.g., related, upsell, cross-sell).

dimension

product_links.{NUM}.linked_product_sku

product_links.{NUM}.linked_product_sku

The SKU of the product being linked.

dimension

product_links.{NUM}.linked_product_type

product_links.{NUM}.linked_product_type

The product type of the linked product.

dimension

product_links.{NUM}.position

product_links.{NUM}.position

The display position of the linked product.

metric

product_links.{NUM}.sku

product_links.{NUM}.sku

The SKU of the primary product to which other products are linked.

dimension

product_option.extension_attributes.configurable_item_options.{NUM}.option_id

product_option.extension_attributes.configurable_item_options.{NUM}.option_id

The ID of a configurable product option, such as a color or size.

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 product option.

metric

product_option.extension_attributes.custom_options.{NUM}.option_id

product_option.extension_attributes.custom_options.{NUM}.option_id

The ID of a specific custom product option selected by a customer.

dimension

product_option.extension_attributes.custom_options.{NUM}.option_value

product_option.extension_attributes.custom_options.{NUM}.option_value

The value selected by a customer for a specific custom product option.

metric

product_type

product_type

The type of product for the order item (e.g., ‘simple’, ‘configurable’, ‘bundle’).

dimension

qty_backordered

qty_backordered

The quantity of an order item that is currently on backorder.

metric

qty_canceled

qty_canceled

The quantity of the item that has been canceled.

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 has been refunded.

metric

qty_returned

qty_returned

The quantity of the item that has been returned.

metric

qty_shipped

qty_shipped

The quantity of the item that has been shipped.

metric

quote_id

quote_id

The ID of the quote (shopping cart) from which this order was created.

dimension

quote_item_id

quote_item_id

The ID of the item within the quote (shopping cart) from which this order item originated.

dimension

remote_ip

remote_ip

The IP address of the customer when the order was placed.

dimension

row_invoiced

row_invoiced

The total invoiced amount for the item row (price * quantity) in the order currency.

metric

row_total

row_total

The total amount for the item row (price * quantity) in the order currency.

metric

row_total_incl_tax

row_total_incl_tax

The total amount for the item row (price * quantity), including tax, in the order currency.

metric

row_weight

row_weight

The total weight of the item row (weight * quantity).

metric

shipping_address_id

shipping_address_id

The unique identifier of the shipping address for an order or shipment.

dimension

shipping_amount

shipping_amount

The shipping amount for the order in the order currency.

metric

shipping_canceled

shipping_canceled

The shipping amount that has been canceled for the order.

metric

shipping_description

shipping_description

A description of the shipping method used for the order (e.g., ‘Flat Rate - Fixed’).

dimension

shipping_discount_amount

shipping_discount_amount

The discount amount applied to shipping for the order.

metric

shipping_discount_tax_compensation_amount

shipping_discount_tax_compensation_amount

The amount of tax compensation for shipping discounts applied to the order.

metric

shipping_incl_tax

shipping_incl_tax

The shipping amount for the order, including tax, in the order currency.

metric

shipping_invoiced

shipping_invoiced

The shipping amount that has been invoiced for the order.

metric

shipping_refunded

shipping_refunded

The shipping amount that has been refunded for the order.

metric

shipping_tax_amount

shipping_tax_amount

The tax amount applied to shipping for the order.

metric

shipping_tax_refunded

shipping_tax_refunded

The shipping tax amount that has been refunded for the order.

metric

sku

sku

The Stock Keeping Unit (SKU) of the product.

metric

state

state

The current state of the order (e.g., ‘new’, ‘pending_payment’, ‘processing’, ‘complete’).

dimension

status

status

The current status of the order (e.g., ‘pending’, ‘processing’, ‘complete’, ‘closed’).

dimension

status_histories.{NUM}.comment

status_histories.{NUM}.comment

A comment associated with a specific status update in the order history.

dimension

status_histories.{NUM}.created_at

status_histories.{NUM}.created_at

The date and time when this status history entry was created.

dimension

status_histories.{NUM}.entity_id

status_histories.{NUM}.entity_id

The ID of the status history entry.

dimension

status_histories.{NUM}.entity_name

status_histories.{NUM}.entity_name

The type of entity this status history entry belongs to (e.g., ‘order’).

dimension

status_histories.{NUM}.is_customer_notified

status_histories.{NUM}.is_customer_notified

Indicates whether the customer was notified about this status update (0 for no, 1 for yes).

metric

status_histories.{NUM}.is_visible_on_front

status_histories.{NUM}.is_visible_on_front

Indicates whether this status update is visible on the storefront to the customer (0 for no, 1 for yes).

metric

status_histories.{NUM}.parent_id

status_histories.{NUM}.parent_id

The ID of the parent entity (e.g., the order ID) for this status history entry.

dimension

status_histories.{NUM}.status

status_histories.{NUM}.status

The status associated with this history entry.

dimension

store_currency_code

store_currency_code

The default currency code of the store.

dimension

store_id

store_id

The ID of the store where the order was placed.

dimension

store_name

store_name

The name of the store where the order was placed.

dimension

store_to_base_rate

store_to_base_rate

The currency conversion rate from the store’s display currency to its base currency.

metric

store_to_order_rate

store_to_order_rate

The currency conversion rate from the store’s display currency to the order’s currency.

metric

subtotal

subtotal

The subtotal of the order before shipping and tax, in the order currency.

metric

subtotal_canceled

subtotal_canceled

The subtotal amount that has been canceled for the order.

metric

subtotal_incl_tax

subtotal_incl_tax

The subtotal of the order, including tax, before shipping, in the order currency.

metric

subtotal_invoiced

subtotal_invoiced

The subtotal amount that has been invoiced for the order.

metric

subtotal_refunded

subtotal_refunded

The subtotal amount that has been refunded for the order.

metric

tax_amount

tax_amount

The amount of tax applied to an item or the entire order/invoice.

metric

tax_canceled

tax_canceled

The amount of tax that was canceled for the order or an item.

metric

tax_invoiced

tax_invoiced

The amount of tax that has been invoiced for the order or an item.

metric

tax_percent

tax_percent

The tax rate applied as a percentage for a specific item.

metric

tax_refunded

tax_refunded

The amount of tax that has been refunded for the order or an item.

metric

tier_prices.{NUM}.customer_group_id

tier_prices.{NUM}.customer_group_id

The unique identifier of the customer group to which a tier price applies.

dimension

tier_prices.{NUM}.extension_attributes.website_id

tier_prices.{NUM}.extension_attributes.website_id

The ID of the website to which a specific tier price applies.

dimension

tier_prices.{NUM}.qty

tier_prices.{NUM}.qty

The minimum quantity required to qualify for a tier price.

metric

tier_prices.{NUM}.value

tier_prices.{NUM}.value

The price value for a product when the tier quantity is met.

metric

total_canceled

total_canceled

The total monetary amount of the order that has been canceled.

metric

total_due

total_due

The remaining amount due for the order.

metric

total_invoiced

total_invoiced

The total monetary amount of the order that has been invoiced.

metric

total_item_count

total_item_count

The total count of unique items in the order.

metric

total_offline_refunded

total_offline_refunded

The total amount that has been refunded offline for the order.

metric

total_paid

total_paid

The total monetary amount that has been paid by the customer for the order.

metric

total_qty

total_qty

The total quantity of items.

metric

total_qty_ordered

total_qty_ordered

The total quantity of all products ordered.

metric

total_refunded

total_refunded

The total monetary amount that has been refunded for the order.

metric

tracks.{NUM}.carrier_code

tracks.{NUM}.carrier_code

The code for the shipping carrier (e.g., ‘ups’, ‘fedex’) for a shipment track.

dimension

tracks.{NUM}.created_at

tracks.{NUM}.created_at

The timestamp when the shipment track was created.

dimension

tracks.{NUM}.description

tracks.{NUM}.description

A description for the shipment track.

dimension

tracks.{NUM}.entity_id

tracks.{NUM}.entity_id

The unique identifier for the shipment track entity.

dimension

tracks.{NUM}.order_id

tracks.{NUM}.order_id

The unique identifier of the order associated with the shipment track.

dimension

tracks.{NUM}.parent_id

tracks.{NUM}.parent_id

The unique identifier of the parent entity (e.g., shipment) for this track.

dimension

tracks.{NUM}.qty

tracks.{NUM}.qty

The quantity of items associated with this shipment track.

dimension

tracks.{NUM}.title

tracks.{NUM}.title

The title of the shipment track.

dimension

tracks.{NUM}.track_number

tracks.{NUM}.track_number

The tracking number provided by the shipping carrier.

dimension

tracks.{NUM}.updated_at

tracks.{NUM}.updated_at

The timestamp when the shipment track was last updated.

dimension

tracks.{NUM}.weight

tracks.{NUM}.weight

The weight of the shipment track.

dimension

transaction_id

transaction_id

The unique identifier for a payment transaction.

dimension

type_id

type_id

The type of the product (e.g., simple, configurable, bundle).

dimension

updated_at

updated_at

The date and time when the entity (e.g., customer, order, product) was last updated.

dimension

visibility

visibility

The visibility setting of a product in the storefront (e.g., Catalog, Search, Hidden).

metric

website_id

website_id

The ID of the website where the entity (e.g., customer, order) was created or belongs.

dimension

weee_tax_applied

weee_tax_applied

A flag indicating whether Waste Electrical and Electronic Equipment (WEEE) tax has been applied.

dimension

weee_tax_applied_amount

weee_tax_applied_amount

The applied WEEE (Waste Electrical and Electronic Equipment) tax amount.

metric

weee_tax_applied_row_amount

weee_tax_applied_row_amount

The applied WEEE (Waste Electrical and Electronic Equipment) tax row amount.

metric

weee_tax_disposition

weee_tax_disposition

The WEEE tax disposition amount.

metric

weee_tax_row_disposition

weee_tax_row_disposition

The WEEE tax row disposition amount.

metric

weight

weight

The weight of the item or product.

metric

x_forwarded_for

x_forwarded_for

The client IP address as reported by a proxy server, indicating the original IP of the client.

dimension