Magento Advanced Reporting: Most-used fields
The table below gives information about most-used fields that you can import from Magento Advanced Reporting. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
addresses.{NUM}.cityDimension
The city component of a customer's address.
addresses.{NUM}.companyDimension
The company name associated with the customer's address.
addresses.{NUM}.country_idDimension
The ISO 2-letter country code for the customer's address.
addresses.{NUM}.customer_idDimension
The unique identifier of the customer to whom this address belongs.
addresses.{NUM}.default_billingDimension
Indicates whether this is the customer's default billing address.
addresses.{NUM}.default_shippingDimension
Indicates whether this is the customer's default shipping address.
addresses.{NUM}.firstnameDimension
The first name associated with the customer's address.
addresses.{NUM}.idMetric
The unique identifier for this specific customer address entry.
addresses.{NUM}.lastnameDimension
The last name associated with the customer's address.
addresses.{NUM}.postcodeDimension
The postal code or ZIP code for the customer's address.
addresses.{NUM}.region.regionDimension
The full name of the region or state for the customer's address.
addresses.{NUM}.region.region_codeDimension
The short code for the region or state of the customer's address.
addresses.{NUM}.region.region_idDimension
The unique identifier for the region or state of the customer's address.
addresses.{NUM}.region_idDimension
The unique identifier for the region or state of the customer's address. This is a direct reference to the region ID.
addresses.{NUM}.street.{NUM}Dimension
A specific line of the street address for the customer. Addresses can have multiple street lines.
addresses.{NUM}.telephoneDimension
The telephone number associated with the customer's address.
addresses.{NUM}.vat_idDimension
The Value Added Tax (VAT) identification number associated with the customer's address, often used for business customers.
amount_refundedMetric
The total amount refunded for an order item in the store's current currency.
attribute_set_idDimension
The unique identifier for the attribute set assigned to a product, which defines its available attributes.
base_amount_refundedMetric
The total amount refunded for an order item in the store's base currency.
base_costMetric
The cost of an item or order in the store's base currency.
base_currency_codeDimension
The ISO 4217 currency code of the store's base currency.
base_discount_amountMetric
The total discount amount applied to an item or order in the store's base currency.
base_discount_canceledMetric
The amount of discount that was canceled for an item or order, in the store's base currency.
base_discount_invoicedMetric
The amount of discount that has been invoiced for an item or order, in the store's base currency.
base_discount_tax_compensation_amountMetric
The amount of tax compensation for discounts applied to an item or order, in the store's base currency.
base_discount_tax_compensation_invoicedMetric
The amount of tax compensation for discounts that has been invoiced for an item or order, in the store's base currency.
base_grand_totalMetric
The grand total amount of an order, including tax and shipping, in the store's base currency.
base_original_priceMetric
The original price of a product or item before any discounts, in the store's base currency.
base_priceMetric
The unit price of a product or item in the store's base currency.
base_price_incl_taxMetric
The unit price of a product or item including tax, in the store's base currency.
base_row_invoicedMetric
The total amount of an order item's row that has been invoiced, in the store's base currency.
base_row_totalMetric
The total amount of an order item's row (quantity multiplied by price), excluding tax and discounts, in the store's base currency.
base_row_total_incl_taxMetric
The total amount of an order item's row (quantity multiplied by price) including tax, in the store's base currency.
base_shipping_amountMetric
The shipping amount for an order in the store's base currency.
base_shipping_canceledMetric
The amount of shipping costs that were canceled for an order, in the store's base currency.
base_shipping_discount_amountMetric
The shipping discount amount for an order in the store's base currency.
base_shipping_discount_tax_compensation_amntMetric
The amount of tax compensation for shipping discounts applied to an order, in the store's base currency.
base_shipping_incl_taxMetric
The shipping amount for an order including tax, in the store's base currency.
base_shipping_invoicedMetric
The amount of shipping costs that have been invoiced for an order, in the store's base currency.
base_shipping_tax_amountMetric
The tax amount applied to shipping costs for an order in the store's base currency.
base_subtotalMetric
The subtotal amount of an order before shipping and tax, in the store's base currency.
base_subtotal_canceledMetric
The subtotal amount that was canceled for an order, in the store's base currency.
base_subtotal_incl_taxMetric
The subtotal amount of an order including tax, before shipping, in the store's base currency.
base_subtotal_invoicedMetric
The subtotal amount that has been invoiced for an order, in the store's base currency.
base_tax_amountMetric
The total tax amount for an order in the store's base currency.
base_tax_canceledMetric
The tax amount that was canceled for an order, in the store's base currency.
base_tax_invoicedMetric
The tax amount that has been invoiced for an order, in the store's base currency.
base_to_global_rateMetric
The currency conversion rate from the store's base currency to the global currency.
base_to_order_rateMetric
The currency conversion rate from the store's base currency to the order's currency.
base_total_canceledMetric
The total amount of an order that was canceled, in the store's base currency.
base_total_dueMetric
The remaining total amount due for an order, in the store's base currency.
base_total_invoicedMetric
The total amount that has been invoiced for an order, in the store's base currency.
base_total_invoiced_costMetric
The total cost of the items that have been invoiced, expressed in the store's base currency. This field is related to sales and order data.
base_total_paidMetric
The total amount that has been paid for an order, in the store's base currency.
billing_address.address_typeDimension
The type of address, for example, 'billing' or 'shipping'.
billing_address.cityDimension
The city component of the billing address for the order.
billing_address.companyDimension
The company name associated with the billing address for the order.
billing_address.country_idDimension
The ISO 2-letter country code for the billing address of the order.
billing_address.customer_address_idDimension
The unique identifier of the customer's address record if this billing address is linked to a stored customer address.
billing_address.emailDimension
The email address associated with the billing address.
billing_address.entity_idDimension
The unique identifier for this specific billing address entry.
billing_address.firstnameDimension
The first name on the billing address for the order.
billing_address.lastnameDimension
The last name on the billing address for the order.
billing_address.parent_idDimension
The identifier of the entity (e.g., order or quote) that the billing address is associated with.
billing_address.postcodeDimension
The postal code or ZIP code for the billing address of the order.
billing_address.regionDimension
The full name of the region or state for the billing address of the order.
billing_address.region_codeDimension
The short code for the region or state of the billing address of the order.
billing_address.region_idDimension
The unique identifier for the region or state of the billing address of the order.
billing_address.street.{NUM}Dimension
A specific line of the street address for the billing address. Addresses can have multiple street lines.
billing_address.telephoneDimension
The telephone number associated with the billing address.
billing_address.vat_idDimension
The Value Added Tax (VAT) identification number associated with the billing address.
billing_address.vat_is_validMetric
Indicates whether the Value Added Tax (VAT) identification number provided in the billing address has been validated successfully.
billing_address.vat_request_dateDimension
The date when the VAT identification number validation request for the billing address was made.
billing_address.vat_request_idDimension
The identifier for the VAT identification number validation request made for the billing address.
billing_address.vat_request_successMetric
Indicates the success status of the VAT identification number validation request for the billing address.
billing_address_idDimension
The unique identifier of the billing address associated with an order or customer.
can_void_flagMetric
A boolean flag indicating whether an authorized payment transaction can be voided before the funds are captured.
created_atDimension
The timestamp indicating when the record (e.g., order, customer, product) was created. Format: YYYY-MM-DD HH:MM:SS.
created_inDimension
The name of the store view or system where the record was created.
custom_attributes.{NUM}.attribute_codeDimension
The unique code identifying a custom attribute. Custom attributes allow merchants to extend standard Magento entities with additional data fields.
custom_attributes.{NUM}.valueDimension
The value associated with the custom attribute. The data type and format depend on the custom attribute's definition.
customer_dobDimension
The customer's date of birth.
customer_emailDimension
The email address of the customer.
customer_firstnameDimension
The first name of the customer.
customer_group_idDimension
The unique identifier of the customer group to which the customer belongs.
customer_idDimension
The unique identifier for the customer.
customer_is_guestMetric
Indicates whether the customer placed the order as a guest (true) or a registered user (false).
customer_lastnameDimension
The last name of the customer.
customer_note_notifyMetric
A flag indicating whether the customer will receive an email notification regarding a new note or comment added to their order.
dateDimension
The date and time when a specific record or entity, such as an order or a report entry, was created or last updated.
default_billingMetric
The ID of the customer's default billing address.
default_shippingMetric
The ID of the customer's default shipping address.
disable_auto_group_changeMetric
A flag that, when active, prevents the automatic reassignment of a customer to a different customer group.
discount_amountMetric
The total discount amount applied to an item or order in the store's current currency.
discount_canceledMetric
The amount of discount that was canceled for an item or order, in the store's current currency.
discount_invoicedMetric
The amount of discount that has been invoiced for an item or order, in the store's current currency.
discount_percentMetric
The percentage of discount applied to an item or order.
discount_tax_compensation_amountMetric
The amount of tax compensation for discounts applied to an item or order, in the store's current currency.
discount_tax_compensation_canceledMetric
The amount of tax compensation for discounts that was canceled for an item or order, in the store's current currency.
discount_tax_compensation_invoicedMetric
The amount of tax compensation for discounts that has been invoiced for an item or order, in the store's current currency.
dobDimension
The customer's date of birth.
emailDimension
The email address of the customer.
email_sentMetric
Indicates whether an email notification related to the order or customer was sent.
entity_idDimension
The unique identifier for the entity (e.g., customer, order, product).
extension_attributes.applied_taxes.{NUM}.amountMetric
The amount of a specific tax applied to an item or order, in the store's current currency.
extension_attributes.applied_taxes.{NUM}.base_amountMetric
The amount of a specific tax applied to an item or order, in the store's base currency.
extension_attributes.applied_taxes.{NUM}.codeDimension
The code identifying a specific tax applied.
extension_attributes.applied_taxes.{NUM}.percentMetric
The percentage rate of a specific tax applied.
extension_attributes.applied_taxes.{NUM}.titleDimension
The display title or name of a specific tax applied.
extension_attributes.category_links.{NUM}.category_idDimension
The unique identifier of a category linked to a product.
extension_attributes.category_links.{NUM}.positionMetric
The position of a product within a linked category.
extension_attributes.configurable_product_links.{NUM}Metric
A unique identifier for a simple product linked to a configurable product.
extension_attributes.configurable_product_options.{NUM}.attribute_idDimension
The unique identifier of the attribute used for a configurable product option.
extension_attributes.configurable_product_options.{NUM}.idMetric
The unique identifier for a specific configurable product option.
extension_attributes.configurable_product_options.{NUM}.labelDimension
The display label for a configurable product option, e.g., 'Color' or 'Size'.
extension_attributes.configurable_product_options.{NUM}.positionMetric
The display order or position of a configurable product option.
extension_attributes.configurable_product_options.{NUM}.product_idDimension
The unique identifier of the configurable product to which this option belongs.
extension_attributes.configurable_product_options.{NUM}.values.{NUM}.value_indexMetric
The index or ID of a specific value for a configurable product option.
extension_attributes.converting_from_quoteDimension
An extension attribute indicating if an order originated from the conversion of a customer's shopping cart (quote).
extension_attributes.is_subscribedDimension
Indicates whether the customer is subscribed to newsletters or marketing communications.
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.amountMetric
The amount of a specific tax applied to an individual item, in the store's current currency.
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.base_amountMetric
The amount of a specific tax applied to an individual item, in the store's base currency.
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.codeDimension
The code identifying a specific tax applied to an individual item.
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.percentMetric
The percentage rate of a specific tax applied to an individual item.
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.titleDimension
The display title or name of a specific tax applied to an individual item.
extension_attributes.item_applied_taxes.{NUM}.item_idDimension
The unique identifier of the order item to which these taxes are applied.
extension_attributes.item_applied_taxes.{NUM}.typeDimension
The type of tax applied to a specific item within the order, found in extension attributes.
extension_attributes.payment_additional_info.{NUM}.keyDimension
A key for additional information provided by the payment method.
extension_attributes.payment_additional_info.{NUM}.valueDimension
The value associated with a key for additional payment method information.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.amount_refundedMetric
The amount refunded for a specific item within a shipping assignment, in the store's current currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_amount_refundedMetric
The amount refunded for a specific item within a shipping assignment, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_costMetric
The base cost of the product for this order item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_amountMetric
The discount amount applied to a specific item within a shipping assignment, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_invoicedMetric
The invoiced discount amount for a specific item within a shipping assignment, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_tax_compensation_amountMetric
The tax compensation amount for discounts on a specific item within a shipping assignment, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_tax_compensation_invoicedMetric
The invoiced tax compensation amount for discounts on a specific item within a shipping assignment, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_original_priceMetric
The original price of a specific item within a shipping assignment, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_priceMetric
The price of a specific item within a shipping assignment, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_price_incl_taxMetric
The price of a specific item including tax within a shipping assignment, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_invoicedMetric
The invoiced row total for a specific item within a shipping assignment, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_totalMetric
The row total for a specific item within a shipping assignment, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_total_incl_taxMetric
The row total including tax for a specific item within a shipping assignment, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_tax_amountMetric
The tax amount for a specific item within a shipping assignment, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_tax_invoicedMetric
The invoiced tax amount for a specific item within a shipping assignment, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.created_atDimension
The timestamp indicating when a specific item within a shipping assignment was created. Format: YYYY-MM-DD HH:MM:SS.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_amountMetric
The discount amount applied to a specific item within a shipping assignment, in the store's current currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_invoicedMetric
The amount of discount that has been invoiced for this specific order item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_percentMetric
The discount percentage applied to this order item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_amountMetric
The tax amount compensated for the discount applied to this order item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_canceledMetric
The tax compensation amount for discounts that has been canceled for this order item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_invoicedMetric
The tax compensation amount for discounts that has been invoiced for this order item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.free_shippingMetric
Indicates whether free shipping is applied to this order item (0 for no, 1 for yes).
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_qty_decimalMetric
Indicates if the item quantity can be a decimal value.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_virtualMetric
Indicates whether the order item is a virtual product (e.g., service, downloadable product).
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.item_idDimension
The unique identifier of the order item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.nameDimension
The name of the product associated with this order item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.no_discountMetric
Indicates whether discounts are not applicable to this order item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.order_idDimension
The unique identifier of the order to which this item belongs.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.original_priceMetric
The original price of the product before any discounts or special pricing.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.amount_refundedMetric
The total amount refunded for the parent item in the order currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_amount_refundedMetric
The total amount refunded for the parent item in the base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_amountMetric
The base currency discount amount applied to the parent item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_invoicedMetric
The base currency discount amount that has been invoiced for the parent item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_tax_compensation_amountMetric
The base currency tax compensation amount for discounts applied to the parent item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_tax_compensation_invoicedMetric
The base currency tax compensation amount for discounts that has been invoiced for the parent item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_original_priceMetric
The base currency original price of the parent product before any discounts.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_priceMetric
The base currency unit price of the parent product after any discounts.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_price_incl_taxMetric
The base currency unit price of the parent product including tax.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_invoicedMetric
The base currency total row amount that has been invoiced for the parent item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_totalMetric
The base currency total row amount for the parent item, including quantity and unit price, before tax.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_total_incl_taxMetric
The base currency total row amount for the parent item, including quantity, unit price, and tax.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_tax_amountMetric
The base currency tax amount for the parent item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_tax_invoicedMetric
The base currency tax amount that has been invoiced for the parent item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.created_atDimension
The date and time when the parent item was created.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_amountMetric
The discount amount applied to the parent item in the order currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_invoicedMetric
The discount amount that has been invoiced for the parent item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_percentMetric
The discount percentage applied to the parent item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_amountMetric
The tax amount compensated for the discount applied to the parent item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_canceledMetric
The tax compensation amount for discounts that has been canceled for the parent item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_invoicedMetric
The tax compensation amount for discounts that has been invoiced for the parent item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.free_shippingMetric
Indicates whether free shipping is applied to the parent item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.is_qty_decimalMetric
Indicates if the parent item quantity can be a decimal value.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.is_virtualMetric
Indicates whether the parent item is a virtual product.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.item_idDimension
The unique identifier of the parent order item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.nameDimension
The name of the product associated with the parent item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.no_discountMetric
Indicates whether discounts are not applicable to the parent item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.order_idDimension
The unique identifier of the order to which the parent item belongs.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.original_priceMetric
The original price of the parent product before any discounts or special pricing.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.priceMetric
The unit price of the parent product for this order item after any discounts.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.price_incl_taxMetric
The unit price of the parent product for this order item including tax.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_idDimension
The unique identifier of the parent product in the catalog.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_idDimension
The identifier for a specific option within a configurable product that is part of a parent item in a shipping assignment.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_valueMetric
The selected value for a configurable product option associated with the parent item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.custom_options.{NUM}.option_idDimension
The identifier of a custom option chosen for the parent product.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.custom_options.{NUM}.option_valueMetric
The value selected for a custom option of the parent product.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_typeDimension
The type of the parent product, such as 'simple' or 'configurable'.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_canceledMetric
The quantity of the parent product that has been canceled from the order.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_invoicedMetric
The quantity of the parent product that has been included in an invoice.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_orderedMetric
The quantity of the parent product originally placed in the order.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_refundedMetric
The quantity of the parent product that has been refunded.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_shippedMetric
The quantity of the parent product that has been shipped.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.quote_item_idDimension
The identifier of the quote item that corresponds to this parent product in the order.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_invoicedMetric
The total price of the parent product row that has been invoiced.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_totalMetric
The total price of the parent product row, calculated as quantity multiplied by its price.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_total_incl_taxMetric
The total price of the parent product row, inclusive of applicable taxes.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_weightMetric
The total weight of the parent product for this order item row.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.skuDimension
The Stock Keeping Unit (SKU) identifier for the parent product.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.store_idDimension
The identifier of the store where the parent product was purchased.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_amountMetric
The amount of tax applied to the parent product.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_canceledMetric
The amount of tax that was canceled for the parent product.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_invoicedMetric
The amount of tax for the parent product that has been included in an invoice.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_percentMetric
The tax percentage rate applied to the parent product.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.updated_atDimension
The date and time when the parent product item was last updated.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.weee_tax_appliedDimension
Details regarding the Waste Electrical and Electronic Equipment (WEEE) tax applied to the parent product.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.weightMetric
The weight of a single unit of the parent product.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item_idDimension
The identifier of the parent order item if the current item is part of a configurable or bundle product.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.priceMetric
The unit price of the product for this order item after any discounts.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price_incl_taxMetric
The unit price of the product for this order item including tax.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_idDimension
The unique identifier of the product in the catalog.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_idDimension
The ID of a selected configurable product option for this item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_valueMetric
The value of a selected configurable product option for this item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_idDimension
The ID of a selected custom product option for this item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_valueMetric
The value of a selected custom product option for this item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_typeDimension
The type of product (e.g., simple, configurable, virtual, bundle).
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_backorderedMetric
The quantity of the order item that is currently on backorder.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_canceledMetric
The quantity of this order item that has been canceled.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_invoicedMetric
The quantity of this order item that has been invoiced.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_orderedMetric
The quantity of this order item that was originally ordered.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_refundedMetric
The quantity of this order item that has been refunded.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_shippedMetric
The quantity of this order item that has been shipped.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.quote_item_idDimension
The ID of the quote item from which this order item originated.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_invoicedMetric
The total row amount that has been invoiced for this order item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_totalMetric
The total row amount for this order item, including quantity and unit price, before tax.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_total_incl_taxMetric
The total row amount for this order item, including quantity, unit price, and tax.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_weightMetric
The total weight of this order item, calculated as unit weight multiplied by quantity.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.skuDimension
The Stock Keeping Unit (SKU) of the product.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.store_idDimension
The ID of the store where the order was placed.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_amountMetric
The tax amount for this order item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_canceledMetric
The tax amount that has been canceled for this order item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_invoicedMetric
The tax amount that has been invoiced for this order item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_percentMetric
The tax percentage applied to this order item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.updated_atDimension
The date and time when the order item was last updated.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.weee_tax_appliedDimension
Information about WEEE (Waste Electrical and Electronic Equipment) tax applied to this order item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.weightMetric
The unit weight of the product for this order item.
extension_attributes.shipping_assignments.{NUM}.shipping.address.address_typeDimension
The type of address (e.g., 'shipping' or 'billing') associated with a shipping assignment.
extension_attributes.shipping_assignments.{NUM}.shipping.address.cityDimension
The city component of the shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.companyDimension
The name of the company for the shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.country_idDimension
The two-letter ISO country code for the shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.customer_address_idDimension
The identifier of the address as stored in the customer's address book.
extension_attributes.shipping_assignments.{NUM}.shipping.address.emailDimension
The email contact for the shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.entity_idDimension
The unique identifier for the specific shipping address record.
extension_attributes.shipping_assignments.{NUM}.shipping.address.firstnameDimension
The first name of the recipient at the shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.lastnameDimension
The last name of the recipient at the shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.parent_idDimension
The identifier of the entity (e.g., order or shipping assignment) that the shipping address is associated with.
extension_attributes.shipping_assignments.{NUM}.shipping.address.postcodeDimension
The postal code for the shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.regionDimension
The full name of the region or state for the shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.region_codeDimension
The abbreviated code for the region or state for the shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.region_idDimension
The identifier for the region or state of the shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.street.{NUM}Dimension
An individual line of the street address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.telephoneDimension
The contact telephone number for the shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_idDimension
The Value Added Tax (VAT) identification number associated with the shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_is_validMetric
A boolean indicator showing whether the provided VAT ID is considered valid.
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_request_dateDimension
The date on which the validation for the VAT ID was requested.
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_request_idDimension
The identifier for the VAT ID validation request.
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_request_successMetric
A boolean indicator showing whether the VAT ID validation request was successful.
extension_attributes.shipping_assignments.{NUM}.shipping.methodDimension
The chosen shipping method for this particular shipping assignment.
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_amountMetric
The shipping cost in the base currency of the store before taxes and discounts.
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_canceledMetric
The amount of shipping cost in base currency that has been canceled.
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_discount_amountMetric
The amount of discount applied to shipping in the base currency.
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_discount_tax_compensation_amntMetric
The amount in base currency to compensate for tax on shipping discounts.
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_incl_taxMetric
The total shipping cost in base currency, including tax.
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_invoicedMetric
The shipping cost in base currency that has been included in an invoice.
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_tax_amountMetric
The amount of tax applied to shipping in the base currency.
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_amountMetric
The shipping cost in the order's transactional currency before taxes and discounts.
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_canceledMetric
The amount of shipping cost in the order's transactional currency that has been canceled.
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_discount_amountMetric
The amount of discount applied to shipping in the order's transactional currency.
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_discount_tax_compensation_amountMetric
The amount in the order's transactional currency to compensate for tax on shipping discounts.
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_incl_taxMetric
The total shipping cost in the order's transactional currency, including tax.
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_invoicedMetric
The shipping cost in the order's transactional currency that has been included in an invoice.
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_tax_amountMetric
The amount of tax applied to shipping in the order's transactional currency.
extension_attributes.website_ids.{NUM}Dimension
An identifier for a website associated with the entity.
firstnameDimension
The first name of the customer or recipient.
free_shippingMetric
A flag indicating whether free shipping was applied to the order.
global_currency_codeDimension
The global currency code configured for the store (e.g., USD, EUR).
grand_totalMetric
The final total amount of the order, including all taxes, shipping, and discounts.
group_idDimension
The identifier for the customer group to which the customer belongs.
hold_before_stateDimension
The state of the order prior to being placed on hold.
hold_before_statusDimension
The status of the order prior to being placed on hold.
idDimension
The unique identifier for the entity.
increment_idDimension
A unique, human-readable identifier for the order, often used as an order number.
is_qty_decimalMetric
A flag indicating whether the product quantity can be expressed as a decimal number.
is_virtualMetric
A flag indicating whether the product is virtual (e.g., a downloadable product or service) and does not require shipping.
item_idDimension
The unique identifier for the specific item within the order.
items.{NUM}.amount_refundedMetric
The total amount that has been refunded for this specific order item.
items.{NUM}.base_amount_refundedMetric
The total amount that has been refunded for this order item in the base currency.
items.{NUM}.base_costMetric
The cost of the item in the base currency.
items.{NUM}.base_discount_amountMetric
The amount of discount applied to this order item in the base currency.
items.{NUM}.base_discount_invoicedMetric
The discount amount for this order item in the base currency that has been included in an invoice.
items.{NUM}.base_discount_tax_compensation_amountMetric
The amount in base currency to compensate for tax on discounts applied to this order item.
items.{NUM}.base_discount_tax_compensation_invoicedMetric
The amount in base currency to compensate for tax on discounts for this order item that has been included in an invoice.
items.{NUM}.base_original_priceMetric
The original selling price of the order item in the base currency before any discounts.
items.{NUM}.base_priceMetric
The unit price of the order item in the base currency, after product-specific discounts but before order-level discounts.
items.{NUM}.base_price_incl_taxMetric
The unit price of the order item in the base currency, inclusive of tax.
items.{NUM}.base_row_invoicedMetric
The total price of the order item row in base currency that has been included in an invoice.
items.{NUM}.base_row_totalMetric
The total price of the order item row in base currency, calculated as quantity multiplied by its unit price.
items.{NUM}.base_row_total_incl_taxMetric
The total price of the order item row in base currency, inclusive of applicable taxes.
items.{NUM}.base_tax_amountMetric
The amount of tax applied to this order item in the base currency.
items.{NUM}.base_tax_invoicedMetric
The amount of tax for this order item in the base currency that has been included in an invoice.
items.{NUM}.created_atDimension
The date and time when the order item was created.
items.{NUM}.discount_amountMetric
The amount of discount applied to this order item in the order's transactional currency.
items.{NUM}.discount_invoicedMetric
The discount amount for this order item in the order's transactional currency that has been included in an invoice.
items.{NUM}.discount_percentMetric
The percentage of discount applied to this order item.
items.{NUM}.discount_tax_compensation_amountMetric
The amount in the order's transactional currency to compensate for tax on discounts applied to this order item.
items.{NUM}.discount_tax_compensation_canceledMetric
The amount of tax compensation for discount that was canceled for this item.
items.{NUM}.discount_tax_compensation_invoicedMetric
The amount of tax compensation for discount that was invoiced for this item.
items.{NUM}.entity_idDimension
A unique identifier for the order item.
items.{NUM}.free_shippingMetric
Indicates if the order item qualified for free shipping (0 for no, 1 for yes).
items.{NUM}.is_qty_decimalMetric
Indicates if the quantity for this item can be a decimal value.
items.{NUM}.is_virtualMetric
Indicates if the order item represents a virtual product (e.g., a service or digital download).
items.{NUM}.item_idDimension
The unique identifier for a specific item within an order or other collection of items.
items.{NUM}.nameDimension
The name of the product associated with this order item.
items.{NUM}.no_discountMetric
Indicates if the order item is excluded from discounts (0 for no, 1 for yes).
items.{NUM}.order_idDimension
The unique identifier of the order to which this item belongs.
items.{NUM}.order_item_idDimension
The unique identifier for the order item.
items.{NUM}.original_priceMetric
The original price of a single unit of the product before any discounts.
items.{NUM}.parent_idDimension
The ID of the parent order item if this is a child item (e.g., for configurable products).
items.{NUM}.parent_item.amount_refundedMetric
The total amount refunded for the parent item.
items.{NUM}.parent_item.base_amount_refundedMetric
The base currency amount refunded for the parent item.
items.{NUM}.parent_item.base_discount_amountMetric
The base currency discount amount applied to the parent item.
items.{NUM}.parent_item.base_discount_invoicedMetric
The base currency discount amount invoiced for the parent item.
items.{NUM}.parent_item.base_discount_tax_compensation_amountMetric
The base currency tax compensation amount for discount applied to the parent item.
items.{NUM}.parent_item.base_discount_tax_compensation_invoicedMetric
The base currency tax compensation amount for discount invoiced for the parent item.
items.{NUM}.parent_item.base_original_priceMetric
The original price of the parent item in base currency before any discounts.
items.{NUM}.parent_item.base_priceMetric
The price of the parent item in base currency after discounts.
items.{NUM}.parent_item.base_price_incl_taxMetric
The price of the parent item in base currency including tax, after discounts.
items.{NUM}.parent_item.base_row_invoicedMetric
The total amount invoiced for the parent item in base currency.
items.{NUM}.parent_item.base_row_totalMetric
The total price for the parent item in base currency before tax.
items.{NUM}.parent_item.base_row_total_incl_taxMetric
The total price for the parent item in base currency including tax.
items.{NUM}.parent_item.base_tax_amountMetric
The total tax amount for the parent item in base currency.
items.{NUM}.parent_item.base_tax_invoicedMetric
The base currency tax amount invoiced for the parent item.
items.{NUM}.parent_item.created_atDimension
The timestamp when the parent item was created.
items.{NUM}.parent_item.discount_amountMetric
The discount amount applied to the parent item.
items.{NUM}.parent_item.discount_invoicedMetric
The discount amount invoiced for the parent item.
items.{NUM}.parent_item.discount_percentMetric
The discount percentage applied to the parent item.
items.{NUM}.parent_item.discount_tax_compensation_amountMetric
The tax compensation amount for discount applied to the parent item.
items.{NUM}.parent_item.discount_tax_compensation_canceledMetric
The tax compensation amount for discount that was canceled for the parent item.
items.{NUM}.parent_item.discount_tax_compensation_invoicedMetric
The tax compensation amount for discount that was invoiced for the parent item.
items.{NUM}.parent_item.free_shippingMetric
Indicates if the parent item qualified for free shipping (0 for no, 1 for yes).
items.{NUM}.parent_item.is_qty_decimalMetric
Indicates if the quantity for the parent item can be a decimal value.
items.{NUM}.parent_item.is_virtualMetric
Indicates if the parent item represents a virtual product.
items.{NUM}.parent_item.item_idDimension
A unique identifier for the parent item.
items.{NUM}.parent_item.nameDimension
The name of the product associated with the parent item.
items.{NUM}.parent_item.no_discountMetric
Indicates if the parent item is excluded from discounts (0 for no, 1 for yes).
items.{NUM}.parent_item.order_idDimension
The unique identifier of the order to which the parent item belongs.
items.{NUM}.parent_item.original_priceMetric
The original price of a single unit of the parent product before any discounts.
items.{NUM}.parent_item.priceMetric
The price of a single unit of the parent product after discounts.
items.{NUM}.parent_item.price_incl_taxMetric
The price of a single unit of the parent product including tax, after discounts.
items.{NUM}.parent_item.product_idDimension
The unique identifier of the product associated with the parent item.
items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_idDimension
The ID of a configurable product option chosen for the parent item.
items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_valueMetric
The value of a configurable product option chosen for the parent item.
items.{NUM}.parent_item.product_option.extension_attributes.custom_options.{NUM}.option_idDimension
The ID of a custom option chosen for the parent item.
items.{NUM}.parent_item.product_option.extension_attributes.custom_options.{NUM}.option_valueMetric
The value of a custom option chosen for the parent item.
items.{NUM}.parent_item.product_typeDimension
The type of product associated with the parent item.
items.{NUM}.parent_item.qty_canceledMetric
The quantity of the parent product that was canceled.
items.{NUM}.parent_item.qty_invoicedMetric
The quantity of the parent product that has been invoiced.
items.{NUM}.parent_item.qty_orderedMetric
The quantity of the parent product that was originally ordered.
items.{NUM}.parent_item.qty_refundedMetric
The quantity of the parent product that has been refunded.
items.{NUM}.parent_item.qty_shippedMetric
The quantity of the parent product that has been shipped.
items.{NUM}.parent_item.quote_item_idDimension
The ID of the corresponding item in the quote (shopping cart) for the parent item.
items.{NUM}.parent_item.row_invoicedMetric
The total amount invoiced for the parent item (price * invoiced quantity).
items.{NUM}.parent_item.row_totalMetric
The total price for the parent item row (price * quantity ordered) before tax.
items.{NUM}.parent_item.row_total_incl_taxMetric
The total price for the parent item row (price * quantity ordered) including tax.
items.{NUM}.parent_item.row_weightMetric
The total weight for the ordered quantity of the parent item.
items.{NUM}.parent_item.skuDimension
The Stock Keeping Unit (SKU) of the product associated with the parent item.
items.{NUM}.parent_item.store_idDimension
The ID of the store where the order containing the parent item was placed.
items.{NUM}.parent_item.tax_amountMetric
The total tax amount for the parent item.
items.{NUM}.parent_item.tax_canceledMetric
The tax amount that was canceled for the parent item.
items.{NUM}.parent_item.tax_invoicedMetric
The tax amount that was invoiced for the parent item.
items.{NUM}.parent_item.tax_percentMetric
The tax percentage applied to the parent item.
items.{NUM}.parent_item.updated_atDimension
The timestamp when the parent item was last updated.
items.{NUM}.parent_item.weee_tax_appliedDimension
Details about the Waste Electrical and Electronic Equipment (WEEE) tax applied to the parent item of a specific item.
items.{NUM}.parent_item.weightMetric
The weight of a single unit of the parent product.
items.{NUM}.parent_item_idDimension
The ID of the parent order item if this is a child item.
items.{NUM}.priceMetric
The price of a single unit of the product after discounts.
items.{NUM}.price_incl_taxMetric
The price of a single unit of the product including tax, after discounts.
items.{NUM}.product_idDimension
The unique identifier of the product associated with this order item.
items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_idDimension
The ID of a configurable product option chosen for this item.
items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_valueMetric
The value of a configurable product option chosen for this item.
items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_idDimension
The ID of a custom option chosen for this item.
items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_valueMetric
The value of a custom option chosen for this item.
items.{NUM}.product_typeDimension
The type of product (e.g., 'simple', 'configurable', 'bundle') associated with this order item.
items.{NUM}.qtyMetric
The quantity of the product ordered.
items.{NUM}.qty_backorderedMetric
The quantity of the product that is currently backordered.
items.{NUM}.qty_canceledMetric
The quantity of the product that was canceled from the order.
items.{NUM}.qty_invoicedMetric
The quantity of the product that has been invoiced.
items.{NUM}.qty_orderedMetric
The quantity of the product that was originally ordered.
items.{NUM}.qty_refundedMetric
The quantity of the product that has been refunded.
items.{NUM}.qty_shippedMetric
The quantity of the product that has been shipped.
items.{NUM}.quote_item_idDimension
The ID of the corresponding item in the quote (shopping cart).
items.{NUM}.row_invoicedMetric
The total amount invoiced for this item (price * invoiced quantity).
items.{NUM}.row_totalMetric
The total price for the row (price * quantity ordered) before tax.
items.{NUM}.row_total_incl_taxMetric
The total price for the row (price * quantity ordered) including tax.
items.{NUM}.row_weightMetric
The total weight for the ordered quantity of this item.
items.{NUM}.skuDimension
The Stock Keeping Unit (SKU) of the product associated with this order item.
items.{NUM}.store_idDimension
The ID of the store where the order containing this item was placed.
items.{NUM}.tax_amountMetric
The total tax amount for this item.
items.{NUM}.tax_canceledMetric
The tax amount that was canceled for this item.
items.{NUM}.tax_invoicedMetric
The tax amount that was invoiced for this item.
items.{NUM}.tax_percentMetric
The tax percentage applied to this item.
items.{NUM}.updated_atDimension
The timestamp when this order item was last updated.
items.{NUM}.weee_tax_appliedDimension
Details about the Waste Electrical and Electronic Equipment (WEEE) tax applied to a specific item.
items.{NUM}.weightMetric
The weight of a single unit of the product.
lastnameDimension
The last name of the customer who placed the order.
media_gallery_entries.{NUM}.disabledDimension
Indicates whether a specific entry in the media gallery (e.g., an image) is currently disabled.
media_gallery_entries.{NUM}.fileDimension
The file path or name of a media asset within a media gallery entry.
media_gallery_entries.{NUM}.idMetric
The unique identifier for a specific entry in the media gallery.
media_gallery_entries.{NUM}.labelDimension
A descriptive label for a specific entry in the media gallery.
media_gallery_entries.{NUM}.media_typeDimension
The type of media (e.g., 'image', 'video') for a specific entry in the media gallery.
media_gallery_entries.{NUM}.positionMetric
The display order or position of a specific entry within the media gallery.
media_gallery_entries.{NUM}.types.{NUM}Dimension
The usage type(s) assigned to a media gallery entry, such as 'thumbnail', 'base_image', or 'small_image'.
nameDimension
The descriptive name associated with an entity within a report, such as the name of a product, a customer's full name, or a specific list (e.g., wishlist) name.
no_discountMetric
A flag indicating whether an item or entity is excluded from discounts.
order_currency_codeDimension
The three-letter ISO currency code for the order (e.g., USD, EUR).
order_idDimension
The unique identifier of the order.
original_priceMetric
The original price of an item before any discounts or special pricing are applied.
parent_item.amount_refundedMetric
The amount refunded for the parent item.
parent_item.base_amount_refundedMetric
The amount refunded for the parent item, in the store's base currency.
parent_item.base_discount_amountMetric
The discount amount applied to the parent item, in the store's base currency.
parent_item.base_discount_invoicedMetric
The discount amount invoiced for the parent item, in the store's base currency.
parent_item.base_discount_tax_compensation_amountMetric
The tax compensation amount for discounts applied to the parent item, in the store's base currency.
parent_item.base_discount_tax_compensation_invoicedMetric
The invoiced tax compensation amount for discounts applied to the parent item, in the store's base currency.
parent_item.base_original_priceMetric
The original price of the parent item, in the store's base currency.
parent_item.base_priceMetric
The base price of the parent item, in the store's base currency.
parent_item.base_price_incl_taxMetric
The base price of the parent item including tax, in the store's base currency.
parent_item.base_row_invoicedMetric
The total amount invoiced for the parent item's row, in the store's base currency.
parent_item.base_row_totalMetric
The total for the parent item's row, excluding tax, in the store's base currency.
parent_item.base_row_total_incl_taxMetric
The total for the parent item's row, including tax, in the store's base currency.
parent_item.base_tax_amountMetric
The tax amount applied to the parent item, in the store's base currency.
parent_item.base_tax_invoicedMetric
The tax amount invoiced for the parent item, in the store's base currency.
parent_item.created_atDimension
The timestamp when the parent item was created.
parent_item.discount_amountMetric
The discount amount applied to the parent item.
parent_item.discount_invoicedMetric
The discount amount invoiced for the parent item.
parent_item.discount_percentMetric
The percentage of discount applied to the parent item.
parent_item.discount_tax_compensation_amountMetric
The tax compensation amount for discounts applied to the parent item.
parent_item.discount_tax_compensation_canceledMetric
The canceled tax compensation amount for discounts applied to the parent item.
parent_item.discount_tax_compensation_invoicedMetric
The invoiced tax compensation amount for discounts applied to the parent item.
parent_item.free_shippingMetric
A flag indicating whether the parent item qualifies for free shipping.
parent_item.is_qty_decimalMetric
Indicates whether the quantity of the parent item can be a decimal value.
parent_item.is_virtualMetric
Indicates whether the parent item is a virtual product (e.g., a service or digital download).
parent_item.item_idDimension
The unique identifier for the parent item.
parent_item.nameDimension
The name of the parent item.
parent_item.no_discountMetric
A flag indicating whether the parent item is excluded from discounts.
parent_item.order_idDimension
The identifier of the order that the parent item belongs to.
parent_item.original_priceMetric
The original price of the parent item before any discounts.
parent_item.priceMetric
The current selling price of the parent item.
parent_item.price_incl_taxMetric
The price of the parent item including tax.
parent_item.product_idDimension
The identifier of the product associated with the parent item.
parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_idDimension
The identifier for a specific option chosen for a configurable product within the parent item's product options.
parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_valueMetric
The value of a specific option chosen for a configurable product within the parent item's product options.
parent_item.product_option.extension_attributes.custom_options.{NUM}.option_idDimension
The identifier for a specific custom option chosen for the parent item's product.
parent_item.product_option.extension_attributes.custom_options.{NUM}.option_valueMetric
The value of a specific custom option chosen for the parent item's product.
parent_item.product_typeDimension
The type of product for the parent item (e.g., 'simple', 'configurable', 'bundle').
parent_item.qty_canceledMetric
The quantity of the parent item that has been canceled.
parent_item.qty_invoicedMetric
The quantity of the parent item that has been invoiced.
parent_item.qty_orderedMetric
The quantity of the parent item that was originally ordered.
parent_item.qty_refundedMetric
The quantity of the parent item that has been refunded.
parent_item.qty_shippedMetric
The quantity of the parent item that has been shipped.
parent_item.quote_item_idDimension
The identifier of the quote item from which the parent item originated.
parent_item.row_invoicedMetric
The total amount invoiced for the parent item's row.
parent_item.row_totalMetric
The total for the parent item's row, excluding tax.
parent_item.row_total_incl_taxMetric
The total for the parent item's row, including tax.
parent_item.row_weightMetric
The total weight of the parent item's row.
parent_item.skuDimension
The Stock Keeping Unit (SKU) of the parent item.
parent_item.store_idDimension
The identifier of the store where the parent item was ordered.
parent_item.tax_amountMetric
The tax amount applied to the parent item.
parent_item.tax_canceledMetric
The tax amount canceled for the parent item.
parent_item.tax_invoicedMetric
The tax amount invoiced for the parent item.
parent_item.tax_percentMetric
The tax percentage applied to the parent item.
parent_item.updated_atDimension
The timestamp when the parent item was last updated.
parent_item.weee_tax_appliedDimension
Details about the Waste Electrical and Electronic Equipment (WEEE) tax applied to the parent item.
parent_item.weightMetric
The weight of the parent item.
parent_item_idDimension
The identifier of the parent item, used to link sub-items or configurable options to their main product.
payment.account_statusDimension
The status of the customer's payment account for the transaction.
payment.additional_information.{NUM}Dimension
Additional information related to the payment, which can vary depending on the payment method used. This field is an array to hold multiple pieces of information.
payment.amount_authorizedMetric
The amount authorized for the payment in the order's currency.
payment.amount_orderedMetric
The total amount of the order in the order's currency that was ordered for payment.
payment.amount_paidMetric
The amount that has been paid for the order in the order's currency.
payment.base_amount_authorizedMetric
The amount authorized for the payment in the store's base currency.
payment.base_amount_orderedMetric
The total amount of the order in the store's base currency that was ordered for payment.
payment.base_amount_paidMetric
The amount that has been paid for the order in the store's base currency.
payment.base_shipping_amountMetric
The shipping amount for the order in the store's base currency.
payment.base_shipping_capturedMetric
The shipping amount captured for the order in the store's base currency.
payment.cc_exp_yearMetric
The expiration year of the credit card used for payment.
payment.cc_last4Dimension
The last four digits of the credit card number used for payment.
payment.cc_ss_start_monthMetric
The start month of a credit card used for payment.
payment.cc_ss_start_yearMetric
The start year of a credit card used for payment.
payment.entity_idDimension
The unique identifier for the payment record.
payment.last_trans_idDimension
The ID of the last transaction associated with this payment.
payment.methodDimension
The payment method used for the order (e.g., 'checkmo', 'paypal_express', 'cashondelivery').
payment.parent_idDimension
The identifier of the entity (e.g., order or invoice) that the payment record is associated with.
payment.shipping_amountMetric
The shipping amount for the order in the order's currency.
payment.shipping_capturedMetric
The shipping amount that has been captured for the order in the order's currency.
priceMetric
The unit price of the product or item, excluding tax.
price_incl_taxMetric
The unit price of the product or item, including tax.
product_idDimension
The unique identifier of the product.
product_links.{NUM}.link_typeDimension
The type of product relationship, such as 'related', 'upsell', or 'crosssell'.
product_links.{NUM}.linked_product_skuDimension
The SKU of the product that is linked to the current product.
product_links.{NUM}.linked_product_typeDimension
The type of the product that is linked to the current product (e.g., 'simple', 'configurable').
product_links.{NUM}.positionMetric
The display order or position of the linked product within its type.
product_links.{NUM}.skuDimension
The SKU of the product to which another product is linked.
product_option.extension_attributes.configurable_item_options.{NUM}.option_idDimension
The unique identifier of a selected configurable option for the product.
product_option.extension_attributes.configurable_item_options.{NUM}.option_valueMetric
The selected value for a configurable option of the product, such as a specific size or color.
product_option.extension_attributes.custom_options.{NUM}.option_idDimension
The unique identifier of a custom option chosen for the product.
product_option.extension_attributes.custom_options.{NUM}.option_valueMetric
The value provided by the customer for a custom option of the product, such as engraved text or a selected date.
product_typeDimension
The type of the product, e.g., 'simple', 'configurable', 'bundle', 'virtual', 'downloadable'.
protect_codeDimension
A unique, system-generated code associated with an order, often used to secure access to order details for guest customers.
qty_backorderedMetric
The quantity of an item that is currently on backorder.
qty_canceledMetric
The quantity of the item that was canceled from the order.
qty_invoicedMetric
The quantity of the item that has been invoiced.
qty_orderedMetric
The quantity of the item that was originally ordered.
qty_refundedMetric
The quantity of the item that was refunded.
qty_shippedMetric
The quantity of the item that has been shipped.
quote_idDimension
The unique identifier of the quote (shopping cart) associated with the order.
quote_item_idDimension
The unique identifier of the item within a quote (shopping cart).
remote_ipDimension
The IP address of the customer who placed the order or interacted with the quote.
row_invoicedMetric
The total invoiced amount for the row of items in the order.
row_totalMetric
The total price for the row of items in the order, excluding tax.
row_total_incl_taxMetric
The total price for the row of items in the order, including tax.
row_weightMetric
The combined weight of the items in the order row.
shipping_address_idDimension
The unique identifier of the shipping address used for the order.
shipping_amountMetric
The shipping cost for the order, excluding tax.
shipping_canceledMetric
The shipping amount that was canceled for the order.
shipping_descriptionDimension
A description of the shipping method used for the order.
shipping_discount_amountMetric
The discount amount applied to shipping.
shipping_discount_tax_compensation_amountMetric
The tax compensation amount for discounts applied to shipping.
shipping_incl_taxMetric
The shipping cost for the order, including tax.
shipping_invoicedMetric
The shipping amount that has been invoiced for the order.
shipping_tax_amountMetric
The tax amount applied to shipping.
skuDimension
The Stock Keeping Unit (SKU) of the product.
stateDimension
The current state of the order within its workflow (e.g., 'new', 'processing', 'complete').
statusMetric
The current status of the order (e.g., 'pending', 'processing', 'complete').
status_histories.{NUM}.commentDimension
A comment associated with a specific entry in the order's status history.
status_histories.{NUM}.created_atDimension
The timestamp when a specific status history entry was created.
status_histories.{NUM}.entity_idDimension
The unique identifier of the status history entry.
status_histories.{NUM}.entity_nameDimension
The type of entity the status history entry belongs to (e.g., 'order').
status_histories.{NUM}.is_customer_notifiedMetric
Indicates whether the customer was notified about this status history update (true/false).
status_histories.{NUM}.is_visible_on_frontMetric
Indicates whether this status history entry is visible to the customer on the storefront (true/false).
status_histories.{NUM}.parent_idDimension
The identifier of the entity (e.g., order) that a specific status history entry belongs to.
status_histories.{NUM}.statusDimension
The status associated with this specific status history entry.
store_currency_codeDimension
The currency code of the store where the order was placed (e.g., 'USD', 'EUR').
store_idDimension
The unique identifier of the store where the order was placed.
store_nameDimension
The name of the store where the order was placed.
store_to_base_rateMetric
The currency conversion rate from the store's currency to the base currency.
store_to_order_rateMetric
The currency conversion rate from the store's currency to the order's currency.
subtotalMetric
The subtotal of the order, excluding tax.
subtotal_canceledMetric
The subtotal amount that was canceled from the order.
subtotal_incl_taxMetric
The subtotal of the order, including tax.
subtotal_invoicedMetric
The subtotal amount that has been invoiced.
tax_amountMetric
The total tax amount applied to the order.
tax_canceledMetric
The total tax amount that was canceled from the order.
tax_invoicedMetric
The total tax amount that has been invoiced.
tax_percentMetric
The tax percentage applied to the item or order.
total_canceledMetric
The total amount of the order that was canceled.
total_dueMetric
The remaining total amount due for the order.
total_invoicedMetric
The total amount that has been invoiced for the order.
total_item_countMetric
The total number of distinct items in the order.
total_paidMetric
The total amount that has been paid for the order.
total_qtyMetric
The total quantity of all items in the quote or order.
total_qty_orderedMetric
The total quantity of all items originally ordered.
transaction_idDimension
The unique identifier for the payment transaction.
type_idDimension
The type identifier of the product or entity.
updated_atDimension
The timestamp indicating when the record was last updated.
visibilityMetric
The visibility setting of a product in the catalog and search results (e.g., 'Not Visible Individually', 'Catalog', 'Search', 'Catalog, Search').
website_idDimension
The unique identifier of the website where the entity belongs.
weee_tax_appliedDimension
Details about the Waste Electrical and Electronic Equipment (WEEE) tax applied to an item.
weightMetric
The weight of a single unit of the product.