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 |
A negative adjustment amount applied to the refund total. |
metric |
adjustment_positive |
adjustment_positive |
A positive adjustment amount applied to the refund total. |
metric |
amount_refunded |
amount_refunded |
The total amount refunded for an item in the transaction currency. |
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 |
base_adjustment_negative |
base_adjustment_negative |
A negative adjustment amount applied to the refund total in the store’s base currency. |
metric |
base_adjustment_positive |
base_adjustment_positive |
A positive adjustment amount applied to the refund total in the store’s base currency. |
metric |
base_amount_refunded |
base_amount_refunded |
The total amount refunded for an item in the store’s 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 amount of discount that was canceled in the store’s base currency. |
metric |
base_discount_invoiced |
base_discount_invoiced |
The invoiced discount amount in base currency. |
metric |
base_discount_refunded |
base_discount_refunded |
The base discount amount refunded for an item in the store’s 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 |
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 item in the store’s base currency. |
metric |
base_price |
base_price |
The unit price of the item in the store’s base currency. |
metric |
base_price_incl_tax |
base_price_incl_tax |
The unit price of the item, including tax, in the store’s base currency. |
metric |
base_row_invoiced |
base_row_invoiced |
The total row amount that has been invoiced for the item in the store’s base currency. |
metric |
base_row_total |
base_row_total |
The total row amount for the item in the store’s base currency. |
metric |
base_row_total_incl_tax |
base_row_total_incl_tax |
The total row amount for the item, including tax, in the store’s 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 amount of shipping costs that was canceled in the store’s 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 shipping amount refunded in the store’s 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 tax amount on shipping that was refunded in the store’s base currency. |
metric |
base_subtotal |
base_subtotal |
The subtotal amount of the order in base currency. |
metric |
base_subtotal_canceled |
base_subtotal_canceled |
The subtotal amount of the order that was canceled in the store’s 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 subtotal amount refunded in the store’s 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 amount of tax that was canceled in the store’s base currency. |
metric |
base_tax_invoiced |
base_tax_invoiced |
The invoiced tax amount in base currency. |
metric |
base_tax_refunded |
base_tax_refunded |
The tax amount refunded for an item in the store’s 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 amount of the order that was canceled in the store’s 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 (e.g., manually processed) in the store’s base currency. |
metric |
base_total_online_refunded |
base_total_online_refunded |
The total amount refunded online (e.g., via payment gateway) in the store’s 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 the store’s 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 specified for the billing address. |
metric |
billing_address.firstname |
billing_address.firstname |
The first name for the billing address. |
dimension |
billing_address.lastname |
billing_address.lastname |
The last name for the billing address. |
dimension |
billing_address.middlename |
billing_address.middlename |
The middle name of the person associated with the billing address. |
dimension |
billing_address.parent_id |
billing_address.parent_id |
The ID of the parent entity (e.g., order) to which this billing address belongs. |
dimension |
billing_address.postcode |
billing_address.postcode |
The postcode/zip code of the billing address. |
dimension |
billing_address.prefix |
billing_address.prefix |
The prefix for the billing address name (e.g., Mr., Dr.). |
dimension |
billing_address.region |
billing_address.region |
The region or state for the billing address. |
dimension |
billing_address.region_code |
billing_address.region_code |
The region code for the billing address. |
dimension |
billing_address.region_id |
billing_address.region_id |
The region ID of the billing address. |
dimension |
billing_address.street.{NUM} |
billing_address.street.{NUM} |
A specific line of the street address for the billing address. |
dimension |
billing_address.suffix |
billing_address.suffix |
The suffix for the billing address name (e.g., Jr., 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_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 |
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_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 left by the customer for 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., Dr.). |
dimension |
customer_suffix |
customer_suffix |
The suffix for the customer’s name (e.g., Jr., III). |
dimension |
customer_taxvat |
customer_taxvat |
The customer’s TAX/VAT number. |
metric |
date |
date |
The date associated with the entity’s creation or a relevant event. |
dimension |
default_billing |
default_billing |
The ID of the customer’s default billing address. |
metric |
default_shipping |
default_shipping |
The ID of the customer’s default shipping address. |
metric |
disable_auto_group_change |
disable_auto_group_change |
Indicates whether the automatic change of a customer’s group based on their VAT ID is disabled. When set, the customer’s group will not be automatically updated even if VAT ID rules apply. |
metric |
discount_amount |
discount_amount |
The total discount amount applied to the order. |
metric |
discount_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 discount amount refunded for an item in the transaction currency. |
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 |
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 |
metric |
|
edit_increment |
edit_increment |
A value used to track incremental changes or versions of an order during editing. |
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 amount of an additional itemized tax in the store’s base currency. |
metric |
extension_attributes.additional_itemized_taxes.{NUM}.real_amount |
extension_attributes.additional_itemized_taxes.{NUM}.real_amount |
The real (actual) 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 (actual) base amount of an additional itemized tax in the store’s base currency. |
metric |
extension_attributes.additional_itemized_taxes.{NUM}.tax_code |
extension_attributes.additional_itemized_taxes.{NUM}.tax_code |
The tax code associated with 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 item ID 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 item that is subject to 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. |
metric |
extension_attributes.applied_taxes.{NUM}.percent |
extension_attributes.applied_taxes.{NUM}.percent |
The percentage of an applied tax. |
metric |
extension_attributes.applied_taxes.{NUM}.title |
extension_attributes.applied_taxes.{NUM}.title |
The title or name of an applied tax. |
metric |
extension_attributes.base_gift_cards_amount |
extension_attributes.base_gift_cards_amount |
The total amount of gift cards applied to the order in the store’s base currency. |
metric |
extension_attributes.base_gift_cards_invoiced |
extension_attributes.base_gift_cards_invoiced |
The base amount of gift card value that has been invoiced for the order. |
metric |
extension_attributes.company_order_attributes.company_id |
extension_attributes.company_order_attributes.company_id |
The unique identifier for the company associated with an order, stored as an extension attribute. |
dimension |
extension_attributes.company_order_attributes.company_name |
extension_attributes.company_order_attributes.company_name |
The name of the company associated with a B2B order, if applicable. |
dimension |
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 a gift card applied to the order, accessible within the order’s extension attributes. |
dimension |
extension_attributes.gift_cards.{NUM}.id |
extension_attributes.gift_cards.{NUM}.id |
The internal identifier of a gift card applied to the order, accessible within the order’s extension attributes. |
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.gw_base_price |
extension_attributes.gw_base_price |
The base price of gift wrapping in the store’s base currency. |
metric |
extension_attributes.gw_card_base_price |
extension_attributes.gw_card_base_price |
The base price of a gift card in the store’s base currency. |
metric |
extension_attributes.gw_card_price |
extension_attributes.gw_card_price |
The price of a gift card in the transaction currency. |
metric |
extension_attributes.gw_items_base_price |
extension_attributes.gw_items_base_price |
The base price of gift wrapping for items in the store’s base currency. |
metric |
extension_attributes.gw_items_price |
extension_attributes.gw_items_price |
The price of gift wrapping for items in the transaction currency. |
metric |
extension_attributes.gw_price |
extension_attributes.gw_price |
The total price of gift wrapping in the transaction currency. |
metric |
extension_attributes.is_subscribed |
extension_attributes.is_subscribed |
Indicates whether the customer is subscribed to the newsletter. |
dimension |
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.amount |
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.amount |
The amount of an applied tax for a specific item. |
metric |
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.base_amount |
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.base_amount |
The base currency amount of an applied tax for a specific item. |
metric |
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.code |
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.code |
The code of an applied tax for a specific item. |
metric |
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.percent |
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.percent |
The percentage of an applied tax for a specific item. |
metric |
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.title |
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.title |
The title or name of an applied tax for a specific item. |
metric |
extension_attributes.item_applied_taxes.{NUM}.item_id |
extension_attributes.item_applied_taxes.{NUM}.item_id |
The ID of the item to which the taxes are applied. |
dimension |
extension_attributes.item_applied_taxes.{NUM}.type |
extension_attributes.item_applied_taxes.{NUM}.type |
The type of tax applied to the item. |
dimension |
extension_attributes.payment_additional_info.{NUM}.key |
extension_attributes.payment_additional_info.{NUM}.key |
The key for an additional piece of payment information associated with the order. |
dimension |
extension_attributes.payment_additional_info.{NUM}.value |
extension_attributes.payment_additional_info.{NUM}.value |
The value corresponding to a key in the additional payment information associated with the order. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.amount_refunded |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.amount_refunded |
The amount refunded for this specific item within the shipping assignment. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.applied_rule_ids |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.applied_rule_ids |
A comma-separated list of IDs for cart price rules or promotions that were applied to this item. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_amount_refunded |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_amount_refunded |
The amount refunded for this specific item in the store’s base currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_cost |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_cost |
The base cost of the item within a specific shipping assignment. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_amount |
The discount amount applied to this item in the store’s base currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_invoiced |
The amount of discount that has been invoiced for this item in the store’s base currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_refunded |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_refunded |
The base discount amount refunded for an item within a specific shipping assignment, in the store’s base currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_tax_compensation_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_tax_compensation_amount |
The 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 |
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 base tax amount refunded for an item within a specific shipping assignment, in the store’s base currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.created_at |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.created_at |
The 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 discount amount refunded for an item within a specific shipping assignment, in the transaction currency. |
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 was canceled for a specific item within a shipping assignment. |
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 |
metric |
|
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.amount |
The total tax amount for a specific itemized tax applied to an item within a shipping assignment. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.base_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.base_amount |
The tax amount in the store’s base currency for a specific itemized tax applied to an item within a shipping assignment. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.item_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.item_id |
The ID of the item to which the specific itemized tax applies within a shipping assignment. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_amount |
The actual tax amount, after any adjustments, for a specific itemized tax applied to an item within a shipping assignment. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_base_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_base_amount |
The actual tax amount in the store’s base currency, after any adjustments, for a specific itemized tax applied to an item within a shipping assignment. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_code |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_code |
The code assigned to this specific itemized tax component. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_id |
The identifier for the specific tax rule or rate applied as part of this itemized tax component. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_item_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_item_id |
A unique identifier for the specific itemized tax entry on an item within a shipping assignment. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_percent |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_percent |
The percentage rate of this specific itemized tax component. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.taxable_item_type |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.extension_attributes.itemized_taxes.{NUM}.taxable_item_type |
The type of item (e.g., product, shipping) that the specific itemized tax applies to within a shipping assignment. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.free_shipping |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.free_shipping |
Indicates whether free shipping was applied to this item (1 for yes, 0 for no). |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_qty_decimal |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_qty_decimal |
Indicates if the quantity for this item can be expressed as a decimal value (e.g., for products sold by weight). |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_virtual |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_virtual |
Indicates if the item is a virtual product, such as a service or digital download (1 for virtual, 0 for physical). |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.item_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.item_id |
The unique identifier for this specific item within the order. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.name |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.name |
The name of the product in the order item. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.no_discount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.no_discount |
Indicates if this item is excluded from discount calculations. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.order_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.order_id |
The unique identifier for the order this item belongs to. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.original_price |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.original_price |
The original unit price of the item in the order’s currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.amount_refunded |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.amount_refunded |
The amount refunded for the parent item, if this item is part of a configurable or bundle product. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.applied_rule_ids |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.applied_rule_ids |
A list of rule IDs applied to the parent item associated with a product in a shipping assignment. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_amount_refunded |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_amount_refunded |
The amount refunded for the parent item, expressed in the store’s base currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_amount |
The discount amount applied to the parent item, expressed in the store’s base currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_invoiced |
The amount of discount invoiced for the parent item, expressed in the store’s base currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_tax_compensation_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_tax_compensation_amount |
The discount tax compensation amount for the parent item, expressed in the store’s base currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_tax_compensation_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_tax_compensation_invoiced |
The discount tax compensation amount invoiced for the parent item, expressed in the store’s base currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_original_price |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_original_price |
The original price of the parent item, expressed in the store’s base currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_price |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_price |
The price of the parent item before discounts and taxes, expressed in the store’s base currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_price_incl_tax |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_price_incl_tax |
The price of the parent item including tax, expressed in the store’s base currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_invoiced |
The invoiced row total for the parent item, expressed in the store’s base currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_total |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_total |
The total row price for the parent item (quantity * base price), expressed in the store’s base currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_total_incl_tax |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_total_incl_tax |
The total row price for the parent item including tax, expressed in the store’s base currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_tax_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_tax_amount |
The tax amount for the parent item, expressed in the store’s base currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_tax_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_tax_invoiced |
The tax amount invoiced for the parent item, expressed in the store’s base currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.created_at |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.created_at |
The date and time when the parent item was created. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_amount |
The discount amount applied to the parent item, expressed in the order’s currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_invoiced |
The amount of discount invoiced for the parent item, expressed in the order’s currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_percent |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_percent |
The discount percentage applied to the parent item. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_amount |
The discount tax compensation amount for the parent item, expressed in the order’s currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_canceled |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_canceled |
metric |
|
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_invoiced |
The discount tax compensation amount invoiced for the parent item, expressed in the order’s currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.amount |
The amount of an itemized tax applied to a parent item within a shipping assignment. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.base_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.base_amount |
The base currency amount of an itemized tax applied to a parent item within a shipping assignment. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.item_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.item_id |
The ID of the item to which this specific itemized tax applies, within a shipping assignment. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_amount |
The actual amount of an itemized tax applied to a parent item within a shipping assignment. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_base_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_base_amount |
The actual base currency amount of an itemized tax applied to a parent item within a shipping assignment. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_code |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_code |
The tax code associated with this itemized tax on a parent item within a shipping assignment. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_id |
The unique identifier for this itemized tax on a parent item within a shipping assignment. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_item_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_item_id |
The unique identifier for the tax item record associated with a parent item within a shipping assignment. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_percent |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_percent |
The tax rate percentage for this itemized tax on a parent item within a shipping assignment. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.taxable_item_type |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.taxable_item_type |
The type of item that this itemized tax applies to (e.g., product, shipping), for a parent item within a shipping assignment. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.free_shipping |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.free_shipping |
Indicates whether free shipping was applied to the parent item (0 for no, 1 for yes). |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.is_qty_decimal |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.is_qty_decimal |
Indicates if the quantity of the parent item can be a decimal value. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.is_virtual |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.is_virtual |
Indicates if the parent item is a virtual product (e.g., a service or digital download). |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.item_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.item_id |
The unique identifier for the parent order item. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.name |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.name |
The name of the parent product. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.no_discount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.no_discount |
Indicates if no discount is applied to the parent item. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.order_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.order_id |
The ID of the order to which the parent item belongs. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.original_price |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.original_price |
The original price of the parent item, expressed in the order’s currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.price |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.price |
The price of the parent item before discounts and taxes, expressed in the order’s currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.price_incl_tax |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.price_incl_tax |
The price of the parent item including tax, expressed in the order’s currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_id |
The ID of the product associated with this parent item. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_id |
The identifier for a selected option within a bundle product, associated with a parent item in a shipping assignment. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_qty |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_qty |
The quantity of a selected option within a bundle product, associated with a parent item in a shipping assignment. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM} |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM} |
A specific selection made for an option within a bundle product, associated with a parent item in a shipping assignment. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_id |
The ID of a configurable option selected for the parent item. This indicates a specific attribute chosen by the customer (e.g., ‘color’ option ID). |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
The value of a configurable option selected for the parent item. This represents the specific choice made by the customer (e.g., ‘red’ for color). |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_type |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_type |
The type of product for the parent item (e.g., ‘configurable’, ‘bundle’). |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_canceled |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_canceled |
The quantity of the parent item that has been canceled. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_invoiced |
The quantity of the parent item that has been invoiced. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_ordered |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_ordered |
The quantity of the parent item that was originally ordered. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_refunded |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_refunded |
The quantity of the parent item that has been refunded. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_returned |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_returned |
The quantity of the parent item that has been returned. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_shipped |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_shipped |
The quantity of the parent item that has been shipped. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.quote_item_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.quote_item_id |
The ID of the quote item from which this parent item originated. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_invoiced |
The invoiced row total for the parent item, expressed in the order’s currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_total |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_total |
The total row price for the parent item (quantity * price), expressed in the order’s currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_total_incl_tax |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_total_incl_tax |
The total row price for the parent item including tax, expressed in the order’s currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_weight |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_weight |
The total weight of the parent item for the current row, based on quantity. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.sku |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.sku |
The Stock Keeping Unit (SKU) of the parent product. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.store_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.store_id |
The ID of the store where the order containing this parent item was placed. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_amount |
The tax amount for the parent item, expressed in the order’s currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_canceled |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_canceled |
metric |
|
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_invoiced |
The tax amount invoiced for the parent item, expressed in the order’s currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_percent |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_percent |
The tax percentage applied to the parent item. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.updated_at |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.updated_at |
The date and time when the parent item was last updated. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.weee_tax_applied |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.weee_tax_applied |
Information about WEEE (Waste Electrical and Electronic Equipment) tax applied to the parent item, if any. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.weight |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.weight |
The weight of a single unit of the parent item. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item_id |
The ID of the parent item for a specific line item within a shipping assignment. This is part of the extension_attributes on an order and is used to link a child product (e.g., a simple product) to its main parent product (e.g., a configurable product) within a shipment. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price |
The unit price of the item in the order’s currency, excluding tax. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price_incl_tax |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price_incl_tax |
The unit price of the item in the order’s currency, including tax. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_id |
The unique identifier of the product that this order item represents. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_id |
The identifier for a selected option within a bundle product, associated with an item in a shipping assignment. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_qty |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_qty |
The quantity of a selected option within a bundle product, associated with an item in a shipping assignment. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM} |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM} |
A specific selection made for an option within a bundle product, associated with an item in a shipping assignment. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_id |
The identifier for a specific configurable option chosen for this product. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
The value selected for a specific configurable option for this product. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_id |
The ID of a custom option chosen for a product within a shipping assignment. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_value |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_value |
The selected value for a custom option of a product within a shipping assignment. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_type |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_type |
The type of product, such as simple, configurable, virtual, or bundle. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_backordered |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_backordered |
The quantity of the item that is currently on backorder within a specific shipping assignment. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_canceled |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_canceled |
The quantity of this item that has been canceled from the order. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_invoiced |
The quantity of this item that has been invoiced. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_ordered |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_ordered |
The original quantity of this item placed in the order. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_refunded |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_refunded |
The quantity of this item that has been refunded. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_returned |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_returned |
The quantity of this item that has been returned by the customer. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_shipped |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_shipped |
The quantity of this item that has been shipped. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.quote_item_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.quote_item_id |
The identifier for the corresponding item in the customer’s quote or shopping cart. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_invoiced |
The total invoiced amount for this item’s row, in the order’s currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_total |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_total |
The total price for this item’s row (quantity * price), excluding tax, in the order’s currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_total_incl_tax |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_total_incl_tax |
The total price for this item’s row (quantity * price), including tax, in the order’s currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_weight |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_weight |
The total weight of the quantity of this item in the order row. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.sku |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.sku |
The Stock Keeping Unit (SKU) of the product associated with this order item. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.store_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.store_id |
The identifier of the store where the order containing this item was placed. |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_amount |
The total tax amount applied to this item in the order’s currency. |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_canceled |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_canceled |
The amount of tax that was canceled for a specific item within a shipping assignment. |
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 tax amount refunded for an item within a specific shipping assignment, in the transaction currency. |
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 within a specific shipping assignment. |
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 a specific shipping address assignment within an order. |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.parent_id |
extension_attributes.shipping_assignments.{NUM}.shipping.address.parent_id |
The ID of the parent entity associated with the shipping address within a shipping assignment. |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.postcode |
extension_attributes.shipping_assignments.{NUM}.shipping.address.postcode |
The postal code for a specific shipping address within a shipping assignment. |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.prefix |
extension_attributes.shipping_assignments.{NUM}.shipping.address.prefix |
The prefix for the shipping address name within a specific shipping assignment (e.g., Mr., Dr.). |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.region |
extension_attributes.shipping_assignments.{NUM}.shipping.address.region |
The administrative region or state associated with the shipping address for a particular shipping assignment. |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.region_code |
extension_attributes.shipping_assignments.{NUM}.shipping.address.region_code |
The abbreviated code for the administrative region or state in the shipping address for a particular shipping assignment. |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.region_id |
extension_attributes.shipping_assignments.{NUM}.shipping.address.region_id |
The internal identifier for the region (state or province) for a specific shipping address. |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.street.{NUM} |
extension_attributes.shipping_assignments.{NUM}.shipping.address.street.{NUM} |
A specific line of the street address for the shipping location. |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.suffix |
extension_attributes.shipping_assignments.{NUM}.shipping.address.suffix |
Additional descriptive text for the shipping address, such as an apartment or suite number, for a particular 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 shipping costs that was 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 refunded shipping amount for a specific shipping assignment, expressed 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 refunded shipping tax amount for a specific shipping assignment, expressed 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 shipping costs that was canceled for a specific shipping assignment. |
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 refunded shipping amount for a specific shipping assignment, expressed in the order’s 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 refunded shipping tax amount for a specific shipping assignment, expressed in the order’s currency. |
metric |
extension_attributes.taxes.{NUM}.amount |
extension_attributes.taxes.{NUM}.amount |
The calculated tax amount for a specific tax entry, in the display currency. |
metric |
extension_attributes.taxes.{NUM}.base_amount |
extension_attributes.taxes.{NUM}.base_amount |
The calculated tax amount for a specific tax entry, in the store’s base currency. |
metric |
extension_attributes.taxes.{NUM}.base_real_amount |
extension_attributes.taxes.{NUM}.base_real_amount |
The actual tax amount for a tax entry in the store’s base currency, after all adjustments. |
metric |
extension_attributes.taxes.{NUM}.code |
extension_attributes.taxes.{NUM}.code |
The code or identifier for a specific tax rule or class applied. |
metric |
extension_attributes.taxes.{NUM}.order_id |
extension_attributes.taxes.{NUM}.order_id |
The ID of the order to which this tax entry applies. |
dimension |
extension_attributes.taxes.{NUM}.percent |
extension_attributes.taxes.{NUM}.percent |
The tax rate applied, expressed as a percentage. |
metric |
extension_attributes.taxes.{NUM}.position |
extension_attributes.taxes.{NUM}.position |
The display position or order for a tax entry. |
metric |
extension_attributes.taxes.{NUM}.priority |
extension_attributes.taxes.{NUM}.priority |
The priority level of the tax rule applied for a tax entry. |
metric |
extension_attributes.taxes.{NUM}.process |
extension_attributes.taxes.{NUM}.process |
Indicates the tax processing method or status for a tax entry. |
metric |
extension_attributes.taxes.{NUM}.tax_id |
extension_attributes.taxes.{NUM}.tax_id |
The unique identifier for the specific tax entry or tax rule applied. |
dimension |
extension_attributes.taxes.{NUM}.title |
extension_attributes.taxes.{NUM}.title |
The descriptive title or label for the tax applied (e.g., ‘Sales Tax’, ‘VAT’). |
dimension |
firstname |
firstname |
The first name of the customer. |
dimension |
free_shipping |
free_shipping |
Indicates if free shipping was applied to the 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 before it was placed on hold. |
dimension |
hold_before_status |
hold_before_status |
The status of the order 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 |
Indicates if the quantity of the item can be a decimal value. |
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 |
The unique identifier for the specific order item. |
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 refunded discount amount for a specific order item, expressed 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 for tax compensation on a discount for a specific order item, expressed 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 refunded tax amount for a specific order item, expressed 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 refunded discount amount for a specific order item, expressed in the order’s 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 amount of tax compensation for discounts that was canceled for a specific item. |
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 for tax compensation on a discount for a specific order item, expressed in the order’s currency. |
metric |
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.amount |
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.amount |
The amount for a specific itemized tax component applied to this order item, in the display currency. |
metric |
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.base_amount |
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.base_amount |
The amount for a specific itemized tax component applied to this order item, in the store’s base currency. |
metric |
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.item_id |
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.item_id |
The unique identifier of the order item to which this itemized tax component applies. |
dimension |
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_amount |
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_amount |
The actual tax amount, after any adjustments, for a specific itemized tax applied to an order item. |
metric |
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_base_amount |
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.real_base_amount |
The actual tax amount in the store’s base currency, after any adjustments, for a specific itemized tax applied to an order item. |
metric |
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_code |
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_code |
The code or identifier for this specific itemized tax component. |
metric |
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_id |
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_id |
The unique identifier for this specific itemized tax component. |
dimension |
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_item_id |
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_item_id |
A unique identifier for the specific itemized tax entry on an order item. |
dimension |
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_percent |
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.tax_percent |
The tax rate applied for this specific itemized tax component, expressed as a percentage. |
metric |
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.taxable_item_type |
items.{NUM}.extension_attributes.itemized_taxes.{NUM}.taxable_item_type |
The type of item that is subject to this specific tax component (e.g., ‘product’, ‘shipping’). |
dimension |
items.{NUM}.free_shipping |
items.{NUM}.free_shipping |
A boolean indicator specifying if free shipping was applied specifically to this order item. |
metric |
items.{NUM}.is_qty_decimal |
items.{NUM}.is_qty_decimal |
A boolean indicator specifying whether the quantity for this particular order item can be a decimal value. |
metric |
items.{NUM}.is_virtual |
items.{NUM}.is_virtual |
A boolean indicator specifying whether this order item is virtual and does not require shipping. |
metric |
items.{NUM}.item_id |
items.{NUM}.item_id |
The unique identifier for this specific order item. |
dimension |
items.{NUM}.name |
items.{NUM}.name |
The name of the product associated with this order item. |
dimension |
items.{NUM}.no_discount |
items.{NUM}.no_discount |
A flag indicating whether a specific item is excluded from discount calculations. |
metric |
items.{NUM}.order_id |
items.{NUM}.order_id |
The unique identifier of the order to which this item belongs. |
dimension |
items.{NUM}.original_price |
items.{NUM}.original_price |
The original price of the product associated with this order item, in the display currency, before any special pricing or discounts. |
metric |
items.{NUM}.parent_item.amount_refunded |
items.{NUM}.parent_item.amount_refunded |
The total amount refunded for the parent item in the order currency. |
metric |
items.{NUM}.parent_item.applied_rule_ids |
items.{NUM}.parent_item.applied_rule_ids |
A comma-separated list of IDs of the pricing rules (e.g., cart price rules) applied to the parent item. |
dimension |
items.{NUM}.parent_item.base_amount_refunded |
items.{NUM}.parent_item.base_amount_refunded |
The total amount refunded for the parent item in the store’s base currency. |
metric |
items.{NUM}.parent_item.base_discount_amount |
items.{NUM}.parent_item.base_discount_amount |
The total discount amount applied to the parent item in the store’s base currency. |
metric |
items.{NUM}.parent_item.base_discount_invoiced |
items.{NUM}.parent_item.base_discount_invoiced |
The discounted amount that has been invoiced for the parent item in the store’s base currency. |
metric |
items.{NUM}.parent_item.base_discount_tax_compensation_amount |
items.{NUM}.parent_item.base_discount_tax_compensation_amount |
The amount of tax compensation for discounts applied to the parent item, in the store’s base currency. |
metric |
items.{NUM}.parent_item.base_discount_tax_compensation_invoiced |
items.{NUM}.parent_item.base_discount_tax_compensation_invoiced |
The amount of invoiced tax compensation for discounts applied to the parent item, in the store’s base currency. |
metric |
items.{NUM}.parent_item.base_original_price |
items.{NUM}.parent_item.base_original_price |
The original price of the parent item before any discounts, in the store’s base currency. |
metric |
items.{NUM}.parent_item.base_price |
items.{NUM}.parent_item.base_price |
The price of the parent item per unit, in the store’s base currency. |
metric |
items.{NUM}.parent_item.base_price_incl_tax |
items.{NUM}.parent_item.base_price_incl_tax |
The price of the parent item per unit, including tax, in the store’s base currency. |
metric |
items.{NUM}.parent_item.base_row_invoiced |
items.{NUM}.parent_item.base_row_invoiced |
The total invoiced amount for the parent item row (price * quantity) in the store’s base currency. |
metric |
items.{NUM}.parent_item.base_row_total |
items.{NUM}.parent_item.base_row_total |
The total amount for the parent item row (price * quantity) in the store’s base currency. |
metric |
items.{NUM}.parent_item.base_row_total_incl_tax |
items.{NUM}.parent_item.base_row_total_incl_tax |
The total amount for the parent item row (price * quantity), including tax, in the store’s base currency. |
metric |
items.{NUM}.parent_item.base_tax_amount |
items.{NUM}.parent_item.base_tax_amount |
The total tax amount applied to the parent item in the store’s base currency. |
metric |
items.{NUM}.parent_item.base_tax_invoiced |
items.{NUM}.parent_item.base_tax_invoiced |
The tax amount that has been invoiced for the parent item in the store’s base currency. |
metric |
items.{NUM}.parent_item.created_at |
items.{NUM}.parent_item.created_at |
The date and time when the parent item was created in the order. |
dimension |
items.{NUM}.parent_item.discount_amount |
items.{NUM}.parent_item.discount_amount |
The total discount amount applied to the parent item in the order currency. |
metric |
items.{NUM}.parent_item.discount_invoiced |
items.{NUM}.parent_item.discount_invoiced |
The discounted amount that has been invoiced for the parent item in the order currency. |
metric |
items.{NUM}.parent_item.discount_percent |
items.{NUM}.parent_item.discount_percent |
The percentage of discount applied to the parent item. |
metric |
items.{NUM}.parent_item.discount_tax_compensation_amount |
items.{NUM}.parent_item.discount_tax_compensation_amount |
The amount of tax compensation for discounts applied to the parent item, in the order currency. |
metric |
items.{NUM}.parent_item.discount_tax_compensation_canceled |
items.{NUM}.parent_item.discount_tax_compensation_canceled |
The canceled amount for tax compensation on a discount for a specific parent order item, typically for configurable or bundled products. |
metric |
items.{NUM}.parent_item.discount_tax_compensation_invoiced |
items.{NUM}.parent_item.discount_tax_compensation_invoiced |
The amount of invoiced tax compensation for discounts applied to the parent item, in the order currency. |
metric |
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.amount |
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.amount |
The amount of an itemized tax applied to a parent item within an order item. |
metric |
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.base_amount |
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.base_amount |
The base currency amount of an itemized tax applied to a parent item within an order item. |
metric |
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.item_id |
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.item_id |
The ID of the item to which this specific itemized tax applies, for a parent item within an order item. |
dimension |
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_amount |
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_amount |
The actual amount of an itemized tax applied to a parent item within an order item. |
metric |
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_base_amount |
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.real_base_amount |
The actual base currency amount of an itemized tax applied to a parent item within an order item. |
metric |
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_code |
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_code |
The tax code associated with this itemized tax on a parent item within an order item. |
metric |
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_id |
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_id |
The unique identifier for this itemized tax on a parent item within an order item. |
dimension |
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_item_id |
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_item_id |
The unique identifier for the tax item record associated with a parent item within an order item. |
dimension |
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_percent |
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.tax_percent |
The tax rate percentage for this itemized tax on a parent item within an order item. |
metric |
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.taxable_item_type |
items.{NUM}.parent_item.extension_attributes.itemized_taxes.{NUM}.taxable_item_type |
The type of item that this itemized tax applies to (e.g., product, shipping), for a parent item within an order item. |
dimension |
items.{NUM}.parent_item.free_shipping |
items.{NUM}.parent_item.free_shipping |
Indicates whether free shipping was applied to the parent item (0 for no, 1 for yes). |
metric |
items.{NUM}.parent_item.is_qty_decimal |
items.{NUM}.parent_item.is_qty_decimal |
Indicates if the quantity of the parent item can be expressed as a decimal (0 for no, 1 for yes). |
metric |
items.{NUM}.parent_item.is_virtual |
items.{NUM}.parent_item.is_virtual |
Indicates if the parent item is a virtual product (0 for no, 1 for yes). |
metric |
items.{NUM}.parent_item.item_id |
items.{NUM}.parent_item.item_id |
The unique identifier of the parent item within the order. |
dimension |
items.{NUM}.parent_item.name |
items.{NUM}.parent_item.name |
The name of the parent item. |
dimension |
items.{NUM}.parent_item.no_discount |
items.{NUM}.parent_item.no_discount |
Indicates whether the parent item is excluded from discounts (0 for no, 1 for yes). |
metric |
items.{NUM}.parent_item.order_id |
items.{NUM}.parent_item.order_id |
The ID of the order to which this parent item belongs. |
dimension |
items.{NUM}.parent_item.original_price |
items.{NUM}.parent_item.original_price |
The original price of the parent item before any discounts, in the order currency. |
metric |
items.{NUM}.parent_item.price |
items.{NUM}.parent_item.price |
The price of the parent item per unit, in the order currency. |
metric |
items.{NUM}.parent_item.price_incl_tax |
items.{NUM}.parent_item.price_incl_tax |
The price of the parent item per unit, including tax, in the order currency. |
metric |
items.{NUM}.parent_item.product_id |
items.{NUM}.parent_item.product_id |
The unique identifier of the product associated with this parent item. |
dimension |
items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_id |
items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_id |
The identifier for a selected option within a bundle product, associated with a parent item in the order. |
dimension |
items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_qty |
items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_qty |
The quantity of a selected option within a bundle product, associated with a parent item in the order. |
metric |
items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM} |
items.{NUM}.parent_item.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM} |
A specific selection made for an option within a bundle product, associated with a parent item in the order. |
metric |
items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_id |
items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_id |
The ID of a configurable option selected for the parent item. |
dimension |
items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
The selected value for a configurable option of the parent item. |
metric |
items.{NUM}.parent_item.product_type |
items.{NUM}.parent_item.product_type |
The type of product for the parent item (e.g., ‘simple’, ‘configurable’, ‘bundle’). |
dimension |
items.{NUM}.parent_item.qty_canceled |
items.{NUM}.parent_item.qty_canceled |
The quantity of the parent item that has been canceled. |
metric |
items.{NUM}.parent_item.qty_invoiced |
items.{NUM}.parent_item.qty_invoiced |
The quantity of the parent item that has been invoiced. |
metric |
items.{NUM}.parent_item.qty_ordered |
items.{NUM}.parent_item.qty_ordered |
The quantity of the parent item that was originally ordered. |
metric |
items.{NUM}.parent_item.qty_refunded |
items.{NUM}.parent_item.qty_refunded |
The quantity of the parent item that has been refunded. |
metric |
items.{NUM}.parent_item.qty_returned |
items.{NUM}.parent_item.qty_returned |
The quantity of the parent item that has been returned. |
metric |
items.{NUM}.parent_item.qty_shipped |
items.{NUM}.parent_item.qty_shipped |
The quantity of the parent item that has been shipped. |
metric |
items.{NUM}.parent_item.quote_item_id |
items.{NUM}.parent_item.quote_item_id |
The ID of the quote item from which this parent item originated. |
dimension |
items.{NUM}.parent_item.row_invoiced |
items.{NUM}.parent_item.row_invoiced |
The total invoiced amount for the parent item row (price * quantity) in the order currency. |
metric |
items.{NUM}.parent_item.row_total |
items.{NUM}.parent_item.row_total |
The total amount for the parent item row (price * quantity) in the order currency. |
metric |
items.{NUM}.parent_item.row_total_incl_tax |
items.{NUM}.parent_item.row_total_incl_tax |
The total amount for the parent item row (price * quantity), including tax, in the order currency. |
metric |
items.{NUM}.parent_item.row_weight |
items.{NUM}.parent_item.row_weight |
The total weight of the parent item row (weight * quantity). |
metric |
items.{NUM}.parent_item.sku |
items.{NUM}.parent_item.sku |
The Stock Keeping Unit (SKU) of the parent product. |
dimension |
items.{NUM}.parent_item.store_id |
items.{NUM}.parent_item.store_id |
The ID of the store where the parent item was ordered. |
dimension |
items.{NUM}.parent_item.tax_amount |
items.{NUM}.parent_item.tax_amount |
The total tax amount applied to the parent item in the order currency. |
metric |
items.{NUM}.parent_item.tax_canceled |
items.{NUM}.parent_item.tax_canceled |
The canceled tax amount for a specific parent order item, typically for configurable or bundled products. |
metric |
items.{NUM}.parent_item.tax_invoiced |
items.{NUM}.parent_item.tax_invoiced |
The tax amount that has been invoiced for the parent item in the order currency. |
metric |
items.{NUM}.parent_item.tax_percent |
items.{NUM}.parent_item.tax_percent |
The tax percentage applied to the parent item. |
metric |
items.{NUM}.parent_item.updated_at |
items.{NUM}.parent_item.updated_at |
The date and time when this parent item was last updated. |
dimension |
items.{NUM}.parent_item.weee_tax_applied |
items.{NUM}.parent_item.weee_tax_applied |
Details of any WEEE (Waste Electrical and Electronic Equipment) tax applied to the parent order item. |
dimension |
items.{NUM}.parent_item.weight |
items.{NUM}.parent_item.weight |
The weight of the individual parent item. |
metric |
items.{NUM}.parent_item_id |
items.{NUM}.parent_item_id |
The ID of the parent item if this is a child item in a configurable or bundle product. |
dimension |
items.{NUM}.price |
items.{NUM}.price |
The price of the product associated with this order item, in the display currency, after any special pricing but before item-level discounts. |
metric |
items.{NUM}.price_incl_tax |
items.{NUM}.price_incl_tax |
The price of the product associated with this order item, including taxes, in the display currency. |
metric |
items.{NUM}.product_id |
items.{NUM}.product_id |
The unique identifier of the product from the catalog that this order item represents. |
dimension |
items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_id |
items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_id |
The identifier for a selected option within a bundle product, associated with an item in the order. |
dimension |
items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_qty |
items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_qty |
The quantity of a selected option within a bundle product, associated with an item in the order. |
metric |
items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM} |
items.{NUM}.product_option.extension_attributes.bundle_options.{NUM}.option_selections.{NUM} |
A specific selection made for an option within a bundle product, associated with an item in the order. |
metric |
items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_id |
items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_id |
The unique identifier for a specific configurable product option selected for this order item. |
dimension |
items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
The selected value for a specific configurable product option applied to this order item. |
metric |
items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_id |
items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_id |
The ID of a custom option selected for a product within an order item. |
dimension |
items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_value |
items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_value |
The selected value for a custom option of a product within an order item. |
metric |
items.{NUM}.product_type |
items.{NUM}.product_type |
The type of product (e.g., simple, configurable, virtual, bundle) that this order item represents. |
dimension |
items.{NUM}.qty_backordered |
items.{NUM}.qty_backordered |
The quantity of the individual item that is currently on backorder. |
metric |
items.{NUM}.qty_canceled |
items.{NUM}.qty_canceled |
The quantity of this order item that has been canceled. |
metric |
items.{NUM}.qty_invoiced |
items.{NUM}.qty_invoiced |
The quantity of this order item that has been invoiced. |
metric |
items.{NUM}.qty_ordered |
items.{NUM}.qty_ordered |
The original quantity of this product ordered as part of the order item. |
metric |
items.{NUM}.qty_refunded |
items.{NUM}.qty_refunded |
The quantity of this order item that has been refunded. |
metric |
items.{NUM}.qty_returned |
items.{NUM}.qty_returned |
The quantity of this order item that has been returned by the customer. |
metric |
items.{NUM}.qty_shipped |
items.{NUM}.qty_shipped |
The quantity of this order item that has been shipped. |
metric |
items.{NUM}.quote_item_id |
items.{NUM}.quote_item_id |
The unique identifier for the original quote item from which this order item was created. |
dimension |
items.{NUM}.row_invoiced |
items.{NUM}.row_invoiced |
The total amount of the row (quantity * price) for this order item that has been invoiced, in the display currency. |
metric |
items.{NUM}.row_total |
items.{NUM}.row_total |
The total amount of the row (quantity * price) for this order item, in the display currency, before taxes and discounts. |
metric |
items.{NUM}.row_total_incl_tax |
items.{NUM}.row_total_incl_tax |
The total amount of the row (quantity * price) for this order item, including taxes, in the display currency. |
metric |
items.{NUM}.row_weight |
items.{NUM}.row_weight |
The total weight of this order item, calculated as unit weight multiplied by the ordered quantity. |
metric |
items.{NUM}.sku |
items.{NUM}.sku |
The Stock Keeping Unit (SKU) of the product associated with this order item. |
dimension |
items.{NUM}.store_id |
items.{NUM}.store_id |
The unique identifier of the store from which this order item was purchased. |
dimension |
items.{NUM}.tax_amount |
items.{NUM}.tax_amount |
The amount of tax applied to this order item, in the display currency. |
metric |
items.{NUM}.tax_canceled |
items.{NUM}.tax_canceled |
The amount of tax that was canceled for a specific item. |
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 refunded tax amount for a specific order item, expressed in the order’s 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 |
name |
name |
The name of the product associated with the order item. |
dimension |
no_discount |
no_discount |
Indicates if no discount was applied to the item. |
metric |
order_currency_code |
order_currency_code |
The currency code used for the order. |
dimension |
order_id |
order_id |
The identifier of the order to which this item belongs. |
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 in the transaction currency. |
metric |
parent_item.amount_refunded |
parent_item.amount_refunded |
The total amount refunded for the parent item in the transaction currency. |
metric |
parent_item.applied_rule_ids |
parent_item.applied_rule_ids |
A comma-separated list of rule IDs applied to the parent item. |
dimension |
parent_item.base_amount_refunded |
parent_item.base_amount_refunded |
The total amount refunded for the parent item in the store’s base currency. |
metric |
parent_item.base_discount_amount |
parent_item.base_discount_amount |
The base discount amount applied to the parent item in the store’s base currency. |
metric |
parent_item.base_discount_invoiced |
parent_item.base_discount_invoiced |
The base discount amount invoiced for the parent item in the store’s base currency. |
metric |
parent_item.base_discount_refunded |
parent_item.base_discount_refunded |
The base discount amount refunded for the parent item in the store’s base currency. |
metric |
parent_item.base_discount_tax_compensation_amount |
parent_item.base_discount_tax_compensation_amount |
The 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 |
metric |
|
parent_item.base_original_price |
parent_item.base_original_price |
The original price of the parent item in the store’s base currency. |
metric |
parent_item.base_price |
parent_item.base_price |
The unit price of the parent item in the store’s base currency. |
metric |
parent_item.base_price_incl_tax |
parent_item.base_price_incl_tax |
The unit price of the parent item, including tax, in the store’s base currency. |
metric |
parent_item.base_row_invoiced |
parent_item.base_row_invoiced |
The total row amount invoiced for the parent item in the store’s base currency. |
metric |
parent_item.base_row_total |
parent_item.base_row_total |
The total row amount for the parent item in the store’s base currency. |
metric |
parent_item.base_row_total_incl_tax |
parent_item.base_row_total_incl_tax |
The total row amount for the parent item, including tax, in the store’s base currency. |
metric |
parent_item.base_tax_amount |
parent_item.base_tax_amount |
The base tax amount applied to the parent item in the store’s base currency. |
metric |
parent_item.base_tax_invoiced |
parent_item.base_tax_invoiced |
The base tax amount invoiced for the parent item in the store’s base currency. |
metric |
parent_item.base_tax_refunded |
parent_item.base_tax_refunded |
The base tax amount refunded for the parent item in the store’s base currency. |
metric |
parent_item.created_at |
parent_item.created_at |
The timestamp when the parent item was created. |
dimension |
parent_item.discount_amount |
parent_item.discount_amount |
The discount amount applied to the parent item in the transaction currency. |
metric |
parent_item.discount_invoiced |
parent_item.discount_invoiced |
The discount amount invoiced for the parent item in the transaction currency. |
metric |
parent_item.discount_percent |
parent_item.discount_percent |
The percentage of discount applied to the parent item. |
metric |
parent_item.discount_refunded |
parent_item.discount_refunded |
The discount amount refunded for the parent item in the transaction currency. |
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 |
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 |
metric |
|
parent_item.free_shipping |
parent_item.free_shipping |
Indicates if free shipping was applied to the parent item. |
metric |
parent_item.is_qty_decimal |
parent_item.is_qty_decimal |
Indicates if the quantity of the parent item can be a decimal value. |
metric |
parent_item.is_virtual |
parent_item.is_virtual |
Indicates if the parent item is a virtual product. |
metric |
parent_item.item_id |
parent_item.item_id |
The unique identifier for the parent order item. |
dimension |
parent_item.name |
parent_item.name |
The name of the product associated with the parent order item. |
dimension |
parent_item.no_discount |
parent_item.no_discount |
Indicates if no discount was applied to the parent item. |
metric |
parent_item.order_id |
parent_item.order_id |
The identifier of the order to which the parent item belongs. |
dimension |
parent_item.original_price |
parent_item.original_price |
The original price of the parent item in the transaction currency. |
metric |
parent_item.price |
parent_item.price |
The unit price of the parent item in the transaction currency. |
metric |
parent_item.price_incl_tax |
parent_item.price_incl_tax |
The unit price of the parent item, including tax, in the transaction currency. |
metric |
parent_item.product_id |
parent_item.product_id |
The unique identifier for 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 selected for the parent product. |
dimension |
parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
The value of a configurable option selected for the parent product. |
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 option selected for the parent product. |
dimension |
parent_item.product_option.extension_attributes.custom_options.{NUM}.option_value |
parent_item.product_option.extension_attributes.custom_options.{NUM}.option_value |
The value of a custom option selected for the parent product. |
metric |
parent_item.product_type |
parent_item.product_type |
The type of product for the parent item (e.g., ‘simple’, ‘configurable’, ‘bundle’). |
dimension |
parent_item.qty_canceled |
parent_item.qty_canceled |
The quantity of the parent item that has been canceled. |
metric |
parent_item.qty_invoiced |
parent_item.qty_invoiced |
The quantity of the parent item that has been invoiced. |
metric |
parent_item.qty_ordered |
parent_item.qty_ordered |
The quantity of the parent item originally ordered. |
metric |
parent_item.qty_refunded |
parent_item.qty_refunded |
The quantity of the parent item that has been refunded. |
metric |
parent_item.qty_returned |
parent_item.qty_returned |
metric |
|
parent_item.qty_shipped |
parent_item.qty_shipped |
The quantity of the parent item that has been shipped. |
metric |
parent_item.quote_item_id |
parent_item.quote_item_id |
The identifier of the quote item from which the parent order item originated. |
dimension |
parent_item.row_invoiced |
parent_item.row_invoiced |
The total row amount invoiced for the parent item in the transaction currency. |
metric |
parent_item.row_total |
parent_item.row_total |
The total row amount for the parent item in the transaction currency. |
metric |
parent_item.row_total_incl_tax |
parent_item.row_total_incl_tax |
The total row amount for the parent item, including tax, in the transaction currency. |
metric |
parent_item.row_weight |
parent_item.row_weight |
The total weight of the parent item row. |
metric |
parent_item.sku |
parent_item.sku |
The Stock Keeping Unit (SKU) of the parent product. |
dimension |
parent_item.store_id |
parent_item.store_id |
The ID of the store where the parent item was ordered. |
dimension |
parent_item.tax_amount |
parent_item.tax_amount |
The tax amount applied to the parent item in the transaction currency. |
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 tax amount invoiced for the parent item in the transaction currency. |
metric |
parent_item.tax_percent |
parent_item.tax_percent |
The tax percentage applied to the parent item. |
metric |
parent_item.tax_refunded |
parent_item.tax_refunded |
The tax amount refunded for the parent item in the transaction currency. |
metric |
parent_item.updated_at |
parent_item.updated_at |
The timestamp when the parent item was last updated. |
dimension |
parent_item.weee_tax_applied |
parent_item.weee_tax_applied |
Indicates if Waste Electrical and Electronic Equipment (WEEE) tax was applied to the parent item. |
dimension |
parent_item.weight |
parent_item.weight |
The weight of the parent item. |
metric |
parent_item_id |
parent_item_id |
The unique identifier for the parent order item. |
dimension |
payment.account_status |
payment.account_status |
The status of the payment account used for the order (e.g., ‘verified’). |
dimension |
payment.additional_information.{NUM} |
payment.additional_information.{NUM} |
Additional information related to the payment method, which can vary by payment gateway. |
dimension |
payment.amount_authorized |
payment.amount_authorized |
The amount of the payment authorized by the payment gateway, in the order’s 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 total amount of the payment that has been refunded to the customer, in the order’s currency. |
metric |
payment.base_amount_authorized |
payment.base_amount_authorized |
The amount of the payment authorized by the payment gateway, 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 total amount of the payment that has been refunded to the customer, in the store’s base currency. |
metric |
payment.base_amount_refunded_online |
payment.base_amount_refunded_online |
The amount of the payment that was refunded online, 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 shipping amount that has been refunded, in the store’s base currency. |
metric |
payment.cc_exp_month |
payment.cc_exp_month |
The expiration month of the credit card used for the payment. |
metric |
payment.cc_exp_year |
payment.cc_exp_year |
The expiration year of the credit card used for payment (if applicable and available). |
metric |
payment.cc_last4 |
payment.cc_last4 |
The last four digits of the credit card number used for payment (if applicable and available). |
dimension |
payment.cc_ss_start_month |
payment.cc_ss_start_month |
Represents the start month of a credit card’s ‘Switch/Solo’ issue number. This field is deprecated and no longer actively used in Magento’s API. |
metric |
payment.cc_ss_start_year |
payment.cc_ss_start_year |
The starting year of the credit card’s validity period. This field is part of the payment information and is used for validating the credit card’s issue date, often for specific credit card types or payment processing requirements. |
metric |
payment.cc_trans_id |
payment.cc_trans_id |
The transaction ID provided by the credit card processor for the payment. |
dimension |
payment.cc_type |
payment.cc_type |
The type of credit card used for the 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 timestamp 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 timestamp of the vaulted payment token. |
dimension |
payment.extension_attributes.vault_payment_token.gateway_token |
payment.extension_attributes.vault_payment_token.gateway_token |
A secure token reference returned by the payment gateway, used for tokenized payments, recurring transactions, or securely reusing payment methods. |
metric |
payment.extension_attributes.vault_payment_token.is_active |
payment.extension_attributes.vault_payment_token.is_active |
Indicates whether the vaulted payment token is currently active. |
dimension |
payment.extension_attributes.vault_payment_token.is_visible |
payment.extension_attributes.vault_payment_token.is_visible |
Indicates whether 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 token. |
dimension |
payment.extension_attributes.vault_payment_token.public_hash |
payment.extension_attributes.vault_payment_token.public_hash |
A public hash of the vaulted payment token, used for identification. |
dimension |
payment.extension_attributes.vault_payment_token.token_details |
payment.extension_attributes.vault_payment_token.token_details |
Detailed information about the vaulted payment token, often including masked card numbers or other relevant data. |
dimension |
payment.extension_attributes.vault_payment_token.type |
payment.extension_attributes.vault_payment_token.type |
The type of the vaulted payment token. |
dimension |
payment.extension_attributes.vault_payment_token.website_id |
payment.extension_attributes.vault_payment_token.website_id |
The ID of the website where the vaulted payment token was created. |
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 as part of the payment, in the order’s currency. |
metric |
price |
price |
The unit price of the item in the transaction currency. |
metric |
price_incl_tax |
price_incl_tax |
The unit price of the item, including tax, in the transaction currency. |
metric |
product_id |
product_id |
The unique identifier for the product associated with the order item. |
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 option selected for the product. |
dimension |
product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
The value of a configurable option selected for the product. |
metric |
product_option.extension_attributes.custom_options.{NUM}.option_id |
product_option.extension_attributes.custom_options.{NUM}.option_id |
The ID of a custom option selected for the product. |
dimension |
product_option.extension_attributes.custom_options.{NUM}.option_value |
product_option.extension_attributes.custom_options.{NUM}.option_value |
The value of a custom option selected for the product. |
metric |
product_type |
product_type |
The type of product (e.g., ‘simple’, ‘configurable’, ‘bundle’). |
dimension |
qty_backordered |
qty_backordered |
The quantity of the item that is currently backordered. |
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 originally ordered. |
metric |
qty_refunded |
qty_refunded |
The quantity of the item that has been refunded. |
metric |
qty_returned |
qty_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 identifier of the quote item from which this order item originated. |
dimension |
relation_child_id |
relation_child_id |
The identifier of a child entity in a hierarchical relationship, such as a child order item within a configurable product. |
dimension |
relation_child_real_id |
relation_child_real_id |
The system-generated, unique identifier for a child entity in a hierarchical relationship. |
dimension |
relation_parent_id |
relation_parent_id |
The identifier of a parent entity in a hierarchical relationship, such as a parent order item for a configurable product. |
dimension |
relation_parent_real_id |
relation_parent_real_id |
The system-generated, unique identifier for a parent entity in a hierarchical relationship. |
dimension |
remote_ip |
remote_ip |
The IP address of the customer or client that placed the order or initiated the transaction. |
dimension |
row_invoiced |
row_invoiced |
The total row amount that has been invoiced for the item in the transaction currency. |
metric |
row_total |
row_total |
The total row amount for the item in the transaction currency. |
metric |
row_total_incl_tax |
row_total_incl_tax |
The total row amount for the item, including tax, in the transaction currency. |
metric |
row_weight |
row_weight |
The total weight of the item row. |
metric |
shipping_amount |
shipping_amount |
The shipping amount for the order in the order currency. |
metric |
shipping_canceled |
shipping_canceled |
The amount of shipping costs that was canceled. |
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 total shipping amount that has been refunded for the order, in the order’s currency. |
metric |
shipping_tax_amount |
shipping_tax_amount |
The tax amount applied to shipping for the order. |
metric |
shipping_tax_refunded |
shipping_tax_refunded |
The total shipping tax amount that has been refunded for the order, in the order’s currency. |
metric |
sku |
sku |
The Stock Keeping Unit (SKU) of the product. |
dimension |
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 of the order that was canceled. |
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, excluding shipping and taxes, in the order’s currency. |
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 percentage applied to the item. |
metric |
tax_refunded |
tax_refunded |
The tax amount refunded for an item in the transaction currency. |
metric |
total_canceled |
total_canceled |
The total amount of the order that was 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 refunded offline for the order, in the order’s currency. |
metric |
total_online_refunded |
total_online_refunded |
The total amount refunded online for the order, in the order’s currency. |
metric |
total_paid |
total_paid |
The total monetary amount that has been paid by the customer for the order. |
metric |
total_qty_ordered |
total_qty_ordered |
The total quantity of all products ordered. |
metric |
total_refunded |
total_refunded |
The grand total amount that has been refunded for the order, in the order’s currency. |
metric |
updated_at |
updated_at |
The date and time when the entity (e.g., customer, order, product) was last updated. |
dimension |
website_id |
website_id |
The ID of the website where the entity (e.g., customer, order) was created or belongs. |
dimension |
weee_tax_applied |
weee_tax_applied |
Indicates if Waste Electrical and Electronic Equipment (WEEE) tax was applied to the item. |
dimension |
weight |
weight |
The weight of the item or product. |
metric |