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 |
|
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 |