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