Magento: Most-used fields
The table below gives information about most-used fields that you can import from Magento. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
addresses.{NUM}.cityDimension
The city of the customer's address.
addresses.{NUM}.companyDimension
The company name associated with the customer's address.
addresses.{NUM}.country_idDimension
The ID of the country associated with the customer's address.
addresses.{NUM}.customer_idDimension
The ID of the customer to whom the address belongs.
addresses.{NUM}.default_billingDimension
A flag indicating if this is the customer's default billing address.
addresses.{NUM}.default_shippingDimension
A flag indicating if this is the customer's default shipping address.
addresses.{NUM}.firstnameDimension
The first name of the person associated with the address.
addresses.{NUM}.idMetric
The unique identifier for the address record.
addresses.{NUM}.lastnameDimension
The last name of the person associated with the address.
addresses.{NUM}.postcodeDimension
The postal code or ZIP code of the address.
addresses.{NUM}.region.regionDimension
The full name of the region or state associated with the address.
addresses.{NUM}.region.region_codeDimension
The code for the region or state associated with the address.
addresses.{NUM}.region.region_idDimension
The ID of the region or state associated with the address.
addresses.{NUM}.region_idDimension
The ID of the region or state associated with the address.
addresses.{NUM}.street.{NUM}Dimension
A line of the street address. Multiple lines can exist for a single address.
addresses.{NUM}.telephoneDimension
The telephone number associated with the address.
addresses.{NUM}.vat_idDimension
The Value Added Tax (VAT) identification number for the customer's address.
applied_rule_idsDimension
A comma-separated list of IDs of the shopping cart price rules that were applied to the order item or the entire order.
base_currency_codeDimension
The base currency code of the store.
base_discount_amountMetric
The discount amount applied to the order in base currency.
base_discount_invoicedMetric
The invoiced discount amount in base currency.
base_discount_tax_compensation_amountMetric
The discount tax compensation amount in base currency.
base_discount_tax_compensation_invoicedMetric
The invoiced discount tax compensation amount in base currency.
base_grand_totalMetric
The grand total amount of the order in base currency.
base_shipping_amountMetric
The shipping amount for the order in base currency.
base_shipping_discount_amountMetric
The shipping discount amount in base currency.
base_shipping_discount_tax_compensation_amntMetric
The shipping discount tax compensation amount in base currency.
base_shipping_incl_taxMetric
The shipping amount including tax in base currency.
base_shipping_invoicedMetric
The invoiced shipping amount in base currency.
base_shipping_tax_amountMetric
The shipping tax amount in base currency.
base_subtotalMetric
The subtotal amount of the order in base currency.
base_subtotal_incl_taxMetric
The subtotal amount including tax in base currency.
base_subtotal_invoicedMetric
The invoiced subtotal amount in base currency.
base_tax_amountMetric
The total tax amount for the order in base currency.
base_tax_invoicedMetric
The invoiced tax amount in base currency.
base_to_global_rateMetric
The currency conversion rate from base currency to global currency.
base_to_order_rateMetric
The currency conversion rate from base currency to order currency.
base_total_dueMetric
The total amount still due on the order in base currency.
base_total_invoicedMetric
The total invoiced amount in base currency.
base_total_invoiced_costMetric
The total invoiced cost of the items in base currency.
base_total_paidMetric
The total amount paid in base currency.
billing_address.address_typeDimension
The type of the billing address (e.g., 'billing').
billing_address.cityDimension
The city of the billing address.
billing_address.companyDimension
The company name associated with the billing address.
billing_address.country_idDimension
The country ID of the billing address (e.g., 'US').
billing_address.customer_address_idDimension
The ID of the customer's address if it's a registered address.
billing_address.customer_idDimension
The ID of the customer associated with the billing address.
billing_address.emailDimension
The email address associated with the billing address.
billing_address.entity_idDimension
The unique identifier for the billing address entity.
billing_address.firstnameDimension
The first name for the billing address.
billing_address.lastnameDimension
The last name for the billing address.
billing_address.parent_idDimension
The ID of the parent entity (e.g., order) to which this billing address belongs.
billing_address.postcodeDimension
The postcode/zip code of the billing address.
billing_address.region_idDimension
The region ID of the billing address.
billing_address.street.{NUM}Dimension
A specific line of the street address for the billing address.
billing_address.telephoneDimension
The telephone number for the billing address.
billing_address.vat_idDimension
The VAT ID associated with the billing address for business customers.
billing_address.vat_is_validMetric
A flag indicating if the VAT ID provided for the billing address is valid.
billing_address.vat_request_successMetric
Indicates if the VAT ID validation request for the billing address was successful.
billing_address_idDimension
The ID of the billing address.
created_atDimension
The timestamp when the entity (e.g., order, invoice, customer) was created.
created_inDimension
The store view code or name where the entity (e.g., customer, order) was created.
custom_attributes.{NUM}.attribute_codeDimension
The code for a custom attribute.
custom_attributes.{NUM}.valueMetric
The value of the custom attribute.
customer_emailDimension
The customer's email address.
customer_firstnameDimension
The customer's first name.
customer_genderMetric
The customer's gender.
customer_group_idDimension
The ID of the customer group to which the customer belongs.
customer_idDimension
The unique identifier for the customer.
customer_is_guestMetric
A flag indicating if the customer is a guest (not a registered user).
customer_lastnameDimension
The customer's last name.
customer_note_notifyMetric
A flag indicating if the customer should be notified about the customer note.
dateDimension
The date associated with the entity's creation or a relevant event.
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
Indicates whether the automatic change of a customer's group based on their VAT ID is disabled. When set, the customer's group will not be automatically updated even if VAT ID rules apply.
discount_amountMetric
The total discount amount applied to the order.
discount_descriptionDimension
A description of the discount applied to the order.
discount_invoicedMetric
The amount of discount that has been invoiced.
discount_tax_compensation_amountMetric
The tax compensation amount for the discount.
discount_tax_compensation_invoicedMetric
The invoiced tax compensation amount for the discount.
emailDimension
The email address of the customer.
email_sentMetric
Indicates whether an email notification for the entity (e.g., order confirmation, invoice) has been sent.
entity_idDimension
The unique identifier for the entity.
extension_attributes.applied_taxes.{NUM}.amountMetric
The amount of an applied tax.
extension_attributes.applied_taxes.{NUM}.base_amountMetric
The base currency amount of an applied tax.
extension_attributes.applied_taxes.{NUM}.codeMetric
The code of an applied tax.
extension_attributes.applied_taxes.{NUM}.percentMetric
The percentage of an applied tax.
extension_attributes.applied_taxes.{NUM}.titleMetric
The title or name of an applied tax.
extension_attributes.converting_from_quoteDimension
A flag indicating whether the order was converted from a customer quote.
extension_attributes.is_subscribedDimension
Indicates whether the customer is subscribed to the newsletter.
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.amountMetric
The amount of an applied tax for a specific item.
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.base_amountMetric
The base currency amount of an applied tax for a specific item.
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.codeMetric
The code of an applied tax for a specific item.
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.percentMetric
The percentage of an applied tax for a specific item.
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.titleMetric
The title or name of an applied tax for a specific item.
extension_attributes.item_applied_taxes.{NUM}.item_idDimension
The ID of the item to which the taxes are applied.
extension_attributes.item_applied_taxes.{NUM}.typeDimension
The type of tax applied to the item.
extension_attributes.payment_additional_info.{NUM}.keyDimension
The key for an additional piece of payment information associated with the order.
extension_attributes.payment_additional_info.{NUM}.valueDimension
The value corresponding to a key in the additional payment information associated with the order.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.amount_refundedMetric
The amount refunded for this specific item within the shipping assignment.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.applied_rule_idsDimension
A comma-separated list of IDs for cart price rules or promotions that were applied to this item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_amount_refundedMetric
The amount refunded for this specific item in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_costMetric
The base cost of the item within a specific shipping assignment.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_amountMetric
The discount amount applied to this item in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_invoicedMetric
The amount of discount that has been invoiced for this item in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_tax_compensation_amountMetric
The amount of tax compensation applied due to discounts for this item, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_tax_compensation_invoicedMetric
The amount of tax compensation for discounts that has been invoiced for this item, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_original_priceMetric
The original price of the item, before any discounts or special pricing, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_priceMetric
The unit price of the item in the store's base currency, excluding tax.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_price_incl_taxMetric
The unit price of the item in the store's base currency, including tax.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_invoicedMetric
The total invoiced amount for this item's row, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_totalMetric
The total price for this item's row (quantity * price), excluding tax, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_total_incl_taxMetric
The total price for this item's row (quantity * price), including tax, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_tax_amountMetric
The total tax amount applied to this item in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_tax_invoicedMetric
The amount of tax that has been invoiced for this item, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.created_atDimension
The date and time when this order item was created.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_amountMetric
The discount amount applied to this item in the order's currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_invoicedMetric
The amount of discount that has been invoiced for this item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_percentMetric
The percentage of the discount applied to this item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_amountMetric
The amount of tax compensation applied due to discounts for this item, in the order's currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_invoicedMetric
The amount of tax compensation for discounts that has been invoiced for this item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.free_shippingMetric
Indicates whether free shipping was applied to this item (1 for yes, 0 for no).
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_qty_decimalMetric
Indicates if the quantity for this item can be expressed as a decimal value (e.g., for products sold by weight).
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_virtualMetric
Indicates if the item is a virtual product, such as a service or digital download (1 for virtual, 0 for physical).
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.item_idDimension
The unique identifier for this specific item within the order.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.nameDimension
The name of the product in the order item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.no_discountMetric
Indicates if this item is excluded from discount calculations.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.order_idDimension
The unique identifier for the order this item belongs to.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.original_priceMetric
The original unit price of the item in the order's currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.priceMetric
The unit price of the item in the order's currency, excluding tax.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price_incl_taxMetric
The unit price of the item in the order's currency, including tax.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_idDimension
The unique identifier of the product that this order item represents.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_idDimension
The ID of a custom option chosen for a product within a shipping assignment.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_valueMetric
The selected value for a custom option of a product within a shipping assignment.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_typeDimension
The type of product, such as simple, configurable, virtual, or bundle.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_backorderedMetric
The quantity of the item that is currently on backorder within a specific shipping assignment.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_canceledMetric
The quantity of this item that has been canceled from the order.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_invoicedMetric
The quantity of this item that has been invoiced.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_orderedMetric
The original quantity of this item placed in the order.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_refundedMetric
The quantity of this item that has been refunded.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_shippedMetric
The quantity of this item that has been shipped.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.quote_item_idDimension
The identifier for the corresponding item in the customer's quote or shopping cart.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_invoicedMetric
The total invoiced amount for this item's row, in the order's currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_totalMetric
The total price for this item's row (quantity * price), excluding tax, in the order's currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_total_incl_taxMetric
The total price for this item's row (quantity * price), including tax, in the order's currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_weightMetric
The total weight of the quantity of this item in the order row.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.skuDimension
The Stock Keeping Unit (SKU) of the product associated with this order item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.store_idDimension
The identifier of the store where the order containing this item was placed.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_amountMetric
The total tax amount applied to this item in the order's currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_invoicedMetric
The amount of tax that has been invoiced for this item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_percentMetric
The percentage rate of the tax applied to this item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.updated_atDimension
The date and time when this order item was last updated.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.weee_tax_appliedDimension
Information about any WEEE (Waste Electrical and Electronic Equipment) tax applied to this item.
extension_attributes.shipping_assignments.{NUM}.shipping.address.address_typeDimension
The type of address (e.g., 'shipping' or 'billing').
extension_attributes.shipping_assignments.{NUM}.shipping.address.cityDimension
The city of the shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.companyDimension
The company name associated with the shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.country_idDimension
The two-letter ISO country code for the shipping address (e.g., 'US', 'GB').
extension_attributes.shipping_assignments.{NUM}.shipping.address.customer_address_idDimension
The ID of the customer's address book entry used for this shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.customer_idDimension
The ID of the customer associated with this shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.emailDimension
The email address associated with the shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.entity_idDimension
A unique identifier for the address entity.
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 for a specific shipping address within a shipping assignment.
extension_attributes.shipping_assignments.{NUM}.shipping.address.parent_idDimension
The ID of the parent entity associated with the shipping address within a shipping assignment.
extension_attributes.shipping_assignments.{NUM}.shipping.address.postcodeDimension
The postal code for a specific shipping address within a shipping assignment.
extension_attributes.shipping_assignments.{NUM}.shipping.address.region_idDimension
The internal identifier for the region (state or province) for a specific shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.street.{NUM}Dimension
A specific line of the street address for the shipping location.
extension_attributes.shipping_assignments.{NUM}.shipping.address.telephoneDimension
The telephone number associated with the shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_idDimension
The Value Added Tax (VAT) identification number associated with the shipping address, used for tax calculation and compliance.
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_is_validMetric
A flag indicating if the VAT ID provided for the shipping address within a shipping assignment is valid.
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_request_successMetric
Indicates if the VAT ID validation request for the shipping address within a shipping assignment was successful.
extension_attributes.shipping_assignments.{NUM}.shipping.methodDimension
The selected shipping method (e.g., 'flatrate_flatrate', 'ups_ground') for a particular shipping assignment.
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_amountMetric
The shipping amount for a specific shipping assignment in the store's base currency, before any discounts or taxes.
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_discount_amountMetric
The amount of discount applied to the shipping cost for a specific shipping assignment, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_discount_tax_compensation_amntMetric
The amount of tax compensation for shipping discounts in the store's base currency. This adjusts tax calculation when discounts are applied.
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_incl_taxMetric
The total shipping amount for a specific shipping assignment, including taxes, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_invoicedMetric
The amount of shipping cost that has been invoiced for a specific shipping assignment, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_tax_amountMetric
The amount of tax applied to the shipping cost for a specific shipping assignment, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_amountMetric
The shipping amount for a specific shipping assignment in the display currency, before any discounts or taxes.
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_discount_amountMetric
The amount of discount applied to the shipping cost for a specific shipping assignment, in the display currency.
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_discount_tax_compensation_amountMetric
The amount of tax compensation for shipping discounts in the order's currency. This adjusts tax calculation when discounts are applied.
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_incl_taxMetric
The total shipping amount for a specific shipping assignment, including taxes, in the display currency.
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_invoicedMetric
The amount of shipping cost that has been invoiced for a specific shipping assignment, in the display currency.
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_tax_amountMetric
The amount of tax applied to the shipping cost for a specific shipping assignment, in the display currency.
firstnameDimension
The first name of the customer.
genderMetric
The gender of the customer.
global_currency_codeDimension
The ISO 4217 currency code for the global base currency configured for the store.
grand_totalMetric
The final total amount of the order, including all items, shipping, taxes, and discounts.
group_idDimension
The ID of the customer group to which the customer belongs.
idDimension
The unique identifier for the entity (e.g., customer, order, product).
increment_idDimension
The human-readable increment ID (order number) of the order.
is_virtualMetric
A boolean indicator specifying whether the product or item is virtual and does not require shipping.
items.{NUM}.amount_refundedMetric
The total amount refunded for this specific order item in the display currency.
items.{NUM}.applied_rule_idsDimension
A comma-separated list of IDs of the promotional rules that were applied to this order item.
items.{NUM}.base_amount_refundedMetric
The total amount refunded for this specific order item in the store's base currency.
items.{NUM}.base_costMetric
The base cost of an individual item in the order.
items.{NUM}.base_discount_amountMetric
The discount amount applied to this order item in the store's base currency.
items.{NUM}.base_discount_invoicedMetric
The amount of discount for this order item that has been invoiced, in the store's base currency.
items.{NUM}.base_discount_tax_compensation_amountMetric
The amount of tax compensation for an item's discount in the store's base currency. This adjusts tax calculation when discounts are applied.
items.{NUM}.base_discount_tax_compensation_invoicedMetric
The invoiced amount of tax compensation for an item's discount in the store's base currency.
items.{NUM}.base_original_priceMetric
The original price of the product associated with this order item, in the store's base currency, before any special pricing or discounts.
items.{NUM}.base_priceMetric
The price of the product associated with this order item, in the store's base currency, after any special pricing but before item-level discounts.
items.{NUM}.base_price_incl_taxMetric
The price of the product associated with this order item, including taxes, in the store's base currency.
items.{NUM}.base_row_invoicedMetric
The total amount of the row (quantity * price) for this order item that has been invoiced, in the store's base currency.
items.{NUM}.base_row_totalMetric
The total amount of the row (quantity * price) for this order item, in the store's base currency, before taxes and discounts.
items.{NUM}.base_row_total_incl_taxMetric
The total amount of the row (quantity * price) for this order item, including taxes, in the store's base currency.
items.{NUM}.base_tax_amountMetric
The amount of tax applied to this order item, in the store's base currency.
items.{NUM}.base_tax_invoicedMetric
The amount of tax for this order item that has been invoiced, in the store's base currency.
items.{NUM}.created_atDimension
The timestamp indicating when this order item was created.
items.{NUM}.discount_amountMetric
The discount amount applied to this order item in the display currency.
items.{NUM}.discount_invoicedMetric
The amount of discount for this order item that has been invoiced, in the display currency.
items.{NUM}.discount_percentMetric
The discount rate applied to this order item, expressed as a percentage.
items.{NUM}.discount_tax_compensation_amountMetric
The amount of tax compensation for an item's discount in the order's currency. This adjusts tax calculation when discounts are applied.
items.{NUM}.discount_tax_compensation_invoicedMetric
The invoiced amount of tax compensation for an item's discount.
items.{NUM}.free_shippingMetric
A boolean indicator specifying if free shipping was applied specifically to this order item.
items.{NUM}.is_qty_decimalMetric
A boolean indicator specifying whether the quantity for this particular order item can be a decimal value.
items.{NUM}.is_virtualMetric
A boolean indicator specifying whether this order item is virtual and does not require shipping.
items.{NUM}.item_idDimension
The unique identifier for this specific order item.
items.{NUM}.nameDimension
The name of the product associated with this order item.
items.{NUM}.no_discountMetric
A flag indicating whether a specific item is excluded from discount calculations.
items.{NUM}.order_idDimension
The unique identifier of the order to which this item belongs.
items.{NUM}.original_priceMetric
The original price of the product associated with this order item, in the display currency, before any special pricing or discounts.
items.{NUM}.priceMetric
The price of the product associated with this order item, in the display currency, after any special pricing but before item-level discounts.
items.{NUM}.price_incl_taxMetric
The price of the product associated with this order item, including taxes, in the display currency.
items.{NUM}.product_idDimension
The unique identifier of the product from the catalog that this order item represents.
items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_idDimension
The ID of a custom option selected for a product within an order item.
items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_valueMetric
The selected value for a custom option of a product within an order item.
items.{NUM}.product_typeDimension
The type of product (e.g., simple, configurable, virtual, bundle) that this order item represents.
items.{NUM}.qty_backorderedMetric
The quantity of the individual item that is currently on backorder.
items.{NUM}.qty_canceledMetric
The quantity of this order item that has been canceled.
items.{NUM}.qty_invoicedMetric
The quantity of this order item that has been invoiced.
items.{NUM}.qty_orderedMetric
The original quantity of this product ordered as part of the order item.
items.{NUM}.qty_refundedMetric
The quantity of this order item that has been refunded.
items.{NUM}.qty_shippedMetric
The quantity of this order item that has been shipped.
items.{NUM}.quote_item_idDimension
The unique identifier for the original quote item from which this order item was created.
items.{NUM}.row_invoicedMetric
The total amount of the row (quantity * price) for this order item that has been invoiced, in the display currency.
items.{NUM}.row_totalMetric
The total amount of the row (quantity * price) for this order item, in the display currency, before taxes and discounts.
items.{NUM}.row_total_incl_taxMetric
The total amount of the row (quantity * price) for this order item, including taxes, in the display currency.
items.{NUM}.row_weightMetric
The total weight of this order item, calculated as unit weight multiplied by the ordered quantity.
items.{NUM}.skuDimension
The Stock Keeping Unit (SKU) of the product associated with this order item.
items.{NUM}.store_idDimension
The unique identifier of the store from which this order item was purchased.
items.{NUM}.tax_amountMetric
The amount of tax applied to this order item, in the display currency.
items.{NUM}.tax_invoicedMetric
The amount of tax for this order item that has been invoiced, in the display currency.
items.{NUM}.tax_percentMetric
The tax rate applied to this order item, expressed as a percentage.
items.{NUM}.updated_atDimension
The date and time when this specific order item was last updated.
items.{NUM}.weee_tax_appliedDimension
Details of any WEEE (Waste Electrical and Electronic Equipment) tax applied to this order item.
lastnameDimension
The last name of the customer.
order_currency_codeDimension
The currency code used for the order.
original_increment_idDimension
The customer-facing identifier for the original order or entity.
payment.account_statusDimension
The status of the payment account used for the order (e.g., 'verified').
payment.additional_information.{NUM}Dimension
Additional information related to the payment method, which can vary by payment gateway.
payment.amount_orderedMetric
The total amount of the order in the order currency.
payment.amount_paidMetric
The amount that has been paid for the order in the order currency.
payment.base_amount_orderedMetric
The total amount of the order in the store's base currency.
payment.base_amount_paidMetric
The amount that has been paid for the order in the store's base currency.
payment.base_shipping_amountMetric
The base shipping amount for the order in the store's base currency.
payment.base_shipping_capturedMetric
The base shipping amount that has been captured for the order in the store's base currency.
payment.cc_exp_yearMetric
The expiration year of the credit card used for payment (if applicable and available).
payment.cc_last4Dimension
The last four digits of the credit card number used for payment (if applicable and available).
payment.cc_ss_start_yearMetric
The starting year of the credit card's validity period. This field is part of the payment information and is used for validating the credit card's issue date, often for specific credit card types or payment processing requirements.
payment.entity_idDimension
The unique identifier for the payment record.
payment.methodDimension
The payment method used for the order (e.g., 'checkmo', 'paypal_express').
payment.parent_idDimension
The ID of the order entity associated with this payment record.
payment.shipping_amountMetric
The shipping amount for the order in the order currency.
payment.shipping_capturedMetric
The shipping amount that has been captured for the order in the order currency.
quote_idDimension
The ID of the quote (shopping cart) from which this order was created.
shipping_amountMetric
The shipping amount for the order in the order currency.
shipping_descriptionDimension
A description of the shipping method used for the order (e.g., 'Flat Rate - Fixed').
shipping_discount_amountMetric
The discount amount applied to shipping for the order.
shipping_discount_tax_compensation_amountMetric
The amount of tax compensation for shipping discounts applied to the order.
shipping_incl_taxMetric
The shipping amount for the order, including tax, in the order currency.
shipping_invoicedMetric
The shipping amount that has been invoiced for the order.
shipping_tax_amountMetric
The tax amount applied to shipping for the order.
stateDimension
The current state of the order (e.g., 'new', 'pending_payment', 'processing', 'complete').
statusDimension
The current status of the order (e.g., 'pending', 'processing', 'complete', 'closed').
status_histories.{NUM}.commentDimension
A comment associated with a specific status update in the order history.
status_histories.{NUM}.created_atDimension
The date and time when this status history entry was created.
status_histories.{NUM}.entity_idDimension
The ID of the status history entry.
status_histories.{NUM}.entity_nameDimension
The type of entity this status history entry belongs to (e.g., 'order').
status_histories.{NUM}.is_customer_notifiedMetric
Indicates whether the customer was notified about this status update (0 for no, 1 for yes).
status_histories.{NUM}.is_visible_on_frontMetric
Indicates whether this status update is visible on the storefront to the customer (0 for no, 1 for yes).
status_histories.{NUM}.parent_idDimension
The ID of the parent entity (e.g., the order ID) for this status history entry.
status_histories.{NUM}.statusDimension
The status associated with this history entry.
store_currency_codeDimension
The default currency code of the store.
store_idDimension
The ID 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 display currency to its base currency.
store_to_order_rateMetric
The currency conversion rate from the store's display currency to the order's currency.
subtotalMetric
The subtotal of the order before shipping and tax, in the order currency.
subtotal_incl_taxMetric
The subtotal of the order, including tax, before shipping, in the order currency.
subtotal_invoicedMetric
The subtotal amount that has been invoiced for the order.
tax_amountMetric
The amount of tax applied to an item or the entire order/invoice.
tax_invoicedMetric
The amount of tax that has been invoiced for the order or an item.
total_dueMetric
The remaining amount due for the order.
total_invoicedMetric
The total monetary amount of the order that has been invoiced.
total_item_countMetric
The total count of unique items in the order.
total_paidMetric
The total monetary amount that has been paid by the customer for the order.
total_qty_orderedMetric
The total quantity of all products ordered.
updated_atDimension
The date and time when the entity (e.g., customer, order, product) was last updated.
website_idDimension
The ID of the website where the entity (e.g., customer, order) was created or belongs.
weightMetric
The weight of the item or product.