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}.city Dimension
The city of the customer's address.
addresses.{NUM}.company Dimension
The company name associated with the customer's address.
addresses.{NUM}.country_id Dimension
The ID of the country associated with the customer's address.
addresses.{NUM}.customer_id Dimension
The ID of the customer to whom the address belongs.
addresses.{NUM}.default_billing Dimension
A flag indicating if this is the customer's default billing address.
addresses.{NUM}.default_shipping Dimension
A flag indicating if this is the customer's default shipping address.
addresses.{NUM}.firstname Dimension
The first name of the person associated with the address.
addresses.{NUM}.id Metric
The unique identifier for the address record.
addresses.{NUM}.lastname Dimension
The last name of the person associated with the address.
addresses.{NUM}.postcode Dimension
The postal code or ZIP code of the address.
addresses.{NUM}.region.region Dimension
The full name of the region or state associated with the address.
addresses.{NUM}.region.region_code Dimension
The code for the region or state associated with the address.
addresses.{NUM}.region.region_id Dimension
The ID of the region or state associated with the address.
addresses.{NUM}.region_id Dimension
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}.telephone Dimension
The telephone number associated with the address.
addresses.{NUM}.vat_id Dimension
The Value Added Tax (VAT) identification number for the customer's address.
applied_rule_ids Dimension
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_code Dimension
The base currency code of the store.
base_discount_amount Metric
The discount amount applied to the order in base currency.
base_discount_invoiced Metric
The invoiced discount amount in base currency.
base_discount_tax_compensation_amount Metric
The discount tax compensation amount in base currency.
base_discount_tax_compensation_invoiced Metric
The invoiced discount tax compensation amount in base currency.
base_grand_total Metric
The grand total amount of the order in base currency.
base_shipping_amount Metric
The shipping amount for the order in base currency.
base_shipping_discount_amount Metric
The shipping discount amount in base currency.
base_shipping_discount_tax_compensation_amnt Metric
The shipping discount tax compensation amount in base currency.
base_shipping_incl_tax Metric
The shipping amount including tax in base currency.
base_shipping_invoiced Metric
The invoiced shipping amount in base currency.
base_shipping_tax_amount Metric
The shipping tax amount in base currency.
base_subtotal Metric
The subtotal amount of the order in base currency.
base_subtotal_incl_tax Metric
The subtotal amount including tax in base currency.
base_subtotal_invoiced Metric
The invoiced subtotal amount in base currency.
base_tax_amount Metric
The total tax amount for the order in base currency.
base_tax_invoiced Metric
The invoiced tax amount in base currency.
base_to_global_rate Metric
The currency conversion rate from base currency to global currency.
base_to_order_rate Metric
The currency conversion rate from base currency to order currency.
base_total_due Metric
The total amount still due on the order in base currency.
base_total_invoiced Metric
The total invoiced amount in base currency.
base_total_invoiced_cost Metric
The total invoiced cost of the items in base currency.
base_total_paid Metric
The total amount paid in base currency.
billing_address.address_type Dimension
The type of the billing address (e.g., 'billing').
billing_address.city Dimension
The city of the billing address.
billing_address.company Dimension
The company name associated with the billing address.
billing_address.country_id Dimension
The country ID of the billing address (e.g., 'US').
billing_address.customer_address_id Dimension
The ID of the customer's address if it's a registered address.
billing_address.customer_id Dimension
The ID of the customer associated with the billing address.
billing_address.email Dimension
The email address associated with the billing address.
billing_address.entity_id Dimension
The unique identifier for the billing address entity.
billing_address.firstname Dimension
The first name for the billing address.
billing_address.lastname Dimension
The last name for the billing address.
billing_address.parent_id Dimension
The ID of the parent entity (e.g., order) to which this billing address belongs.
billing_address.postcode Dimension
The postcode/zip code of the billing address.
billing_address.region_id Dimension
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.telephone Dimension
The telephone number for the billing address.
billing_address.vat_id Dimension
The VAT ID associated with the billing address for business customers.
billing_address.vat_is_valid Metric
A flag indicating if the VAT ID provided for the billing address is valid.
billing_address.vat_request_success Metric
Indicates if the VAT ID validation request for the billing address was successful.
billing_address_id Dimension
The ID of the billing address.
created_at Dimension
The timestamp when the entity (e.g., order, invoice, customer) was created.
created_in Dimension
The store view code or name where the entity (e.g., customer, order) was created.
custom_attributes.{NUM}.attribute_code Dimension
The code for a custom attribute.
custom_attributes.{NUM}.value Metric
The value of the custom attribute.
customer_email Dimension
The customer's email address.
customer_firstname Dimension
The customer's first name.
customer_gender Metric
The customer's gender.
customer_group_id Dimension
The ID of the customer group to which the customer belongs.
customer_id Dimension
The unique identifier for the customer.
customer_is_guest Metric
A flag indicating if the customer is a guest (not a registered user).
customer_lastname Dimension
The customer's last name.
customer_note_notify Metric
A flag indicating if the customer should be notified about the customer note.
date Dimension
The date associated with the entity's creation or a relevant event.
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
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_amount Metric
The total discount amount applied to the order.
discount_description Dimension
A description of the discount applied to the order.
discount_invoiced Metric
The amount of discount that has been invoiced.
discount_tax_compensation_amount Metric
The tax compensation amount for the discount.
discount_tax_compensation_invoiced Metric
The invoiced tax compensation amount for the discount.
email Dimension
The email address of the customer.
email_sent Metric
Indicates whether an email notification for the entity (e.g., order confirmation, invoice) has been sent.
entity_id Dimension
The unique identifier for the entity.
extension_attributes.applied_taxes.{NUM}.amount Metric
The amount of an applied tax.
extension_attributes.applied_taxes.{NUM}.base_amount Metric
The base currency amount of an applied tax.
extension_attributes.applied_taxes.{NUM}.code Metric
The code of an applied tax.
extension_attributes.applied_taxes.{NUM}.percent Metric
The percentage of an applied tax.
extension_attributes.applied_taxes.{NUM}.title Metric
The title or name of an applied tax.
extension_attributes.converting_from_quote Dimension
A flag indicating whether the order was converted from a customer quote.
extension_attributes.is_subscribed Dimension
Indicates whether the customer is subscribed to the newsletter.
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.amount Metric
The amount of an applied tax for a specific item.
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.base_amount Metric
The base currency amount of an applied tax for a specific item.
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.code Metric
The code of an applied tax for a specific item.
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.percent Metric
The percentage of an applied tax for a specific item.
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.title Metric
The title or name of an applied tax for a specific item.
extension_attributes.item_applied_taxes.{NUM}.item_id Dimension
The ID of the item to which the taxes are applied.
extension_attributes.item_applied_taxes.{NUM}.type Dimension
The type of tax applied to the item.
extension_attributes.payment_additional_info.{NUM}.key Dimension
The key for an additional piece of payment information associated with the order.
extension_attributes.payment_additional_info.{NUM}.value Dimension
The value corresponding to a key in the additional payment information associated with the order.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.amount_refunded Metric
The amount refunded for this specific item within the shipping assignment.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.applied_rule_ids Dimension
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_refunded Metric
The amount refunded for this specific item in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_cost Metric
The base cost of the item within a specific shipping assignment.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_amount Metric
The discount amount applied to this item in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_invoiced Metric
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_amount Metric
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_invoiced Metric
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_price Metric
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_price Metric
The unit price of the item in the store's base currency, excluding tax.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_price_incl_tax Metric
The unit price of the item in the store's base currency, including tax.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_invoiced Metric
The total invoiced amount for this item's row, in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_total Metric
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_tax Metric
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_amount Metric
The total tax amount applied to this item in the store's base currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_tax_invoiced Metric
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_at Dimension
The date and time when this order item was created.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_amount Metric
The discount amount applied to this item in the order's currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_invoiced Metric
The amount of discount that has been invoiced for this item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_percent Metric
The percentage of the discount applied to this item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_amount Metric
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_invoiced Metric
The amount of tax compensation for discounts that has been invoiced for this item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.free_shipping Metric
Indicates whether free shipping was applied to this item (1 for yes, 0 for no).
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_qty_decimal Metric
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_virtual Metric
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_id Dimension
The unique identifier for this specific item within the order.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.name Dimension
The name of the product in the order item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.no_discount Metric
Indicates if this item is excluded from discount calculations.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.order_id Dimension
The unique identifier for the order this item belongs to.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.original_price Metric
The original unit price of the item in the order's currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price Metric
The unit price of the item in the order's currency, excluding tax.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price_incl_tax Metric
The unit price of the item in the order's currency, including tax.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_id Dimension
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_id Dimension
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_value Metric
The selected value for a custom option of a product within a shipping assignment.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_type Dimension
The type of product, such as simple, configurable, virtual, or bundle.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_backordered Metric
The quantity of the item that is currently on backorder within a specific shipping assignment.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_canceled Metric
The quantity of this item that has been canceled from the order.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_invoiced Metric
The quantity of this item that has been invoiced.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_ordered Metric
The original quantity of this item placed in the order.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_refunded Metric
The quantity of this item that has been refunded.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_shipped Metric
The quantity of this item that has been shipped.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.quote_item_id Dimension
The identifier for the corresponding item in the customer's quote or shopping cart.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_invoiced Metric
The total invoiced amount for this item's row, in the order's currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_total Metric
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_tax Metric
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_weight Metric
The total weight of the quantity of this item in the order row.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.sku Dimension
The Stock Keeping Unit (SKU) of the product associated with this order item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.store_id Dimension
The identifier of the store where the order containing this item was placed.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_amount Metric
The total tax amount applied to this item in the order's currency.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_invoiced Metric
The amount of tax that has been invoiced for this item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_percent Metric
The percentage rate of the tax applied to this item.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.updated_at Dimension
The date and time when this order item was last updated.
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.weee_tax_applied Dimension
Information about any WEEE (Waste Electrical and Electronic Equipment) tax applied to this item.
extension_attributes.shipping_assignments.{NUM}.shipping.address.address_type Dimension
The type of address (e.g., 'shipping' or 'billing').
extension_attributes.shipping_assignments.{NUM}.shipping.address.city Dimension
The city of the shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.company Dimension
The company name associated with the shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.country_id Dimension
The two-letter ISO country code for the shipping address (e.g., 'US', 'GB').
extension_attributes.shipping_assignments.{NUM}.shipping.address.customer_address_id Dimension
The ID of the customer's address book entry used for this shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.customer_id Dimension
The ID of the customer associated with this shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.email Dimension
The email address associated with the shipping address.
extension_attributes.shipping_assignments.{NUM}.shipping.address.entity_id Dimension
A unique identifier for the address entity.
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 for a specific shipping address within a shipping assignment.
extension_attributes.shipping_assignments.{NUM}.shipping.address.parent_id Dimension
The ID of the parent entity associated with the shipping address within a shipping assignment.
extension_attributes.shipping_assignments.{NUM}.shipping.address.postcode Dimension
The postal code for a specific shipping address within a shipping assignment.
extension_attributes.shipping_assignments.{NUM}.shipping.address.region_id Dimension
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.telephone Dimension
The telephone number associated with 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, used for tax calculation and compliance.
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_is_valid Metric
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_success Metric
Indicates if the VAT ID validation request for the shipping address within a shipping assignment was successful.
extension_attributes.shipping_assignments.{NUM}.shipping.method Dimension
The selected shipping method (e.g., 'flatrate_flatrate', 'ups_ground') for a particular shipping assignment.
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_amount Metric
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_amount Metric
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_amnt Metric
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_tax Metric
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_invoiced Metric
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_amount Metric
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_amount Metric
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_amount Metric
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_amount Metric
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_tax Metric
The total shipping amount for a specific shipping assignment, including taxes, in the display currency.
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_invoiced Metric
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_amount Metric
The amount of tax applied to the shipping cost for a specific shipping assignment, in the display currency.
firstname Dimension
The first name of the customer.
gender Metric
The gender of the customer.
global_currency_code Dimension
The ISO 4217 currency code for the global base currency configured for the store.
grand_total Metric
The final total amount of the order, including all items, shipping, taxes, and discounts.
group_id Dimension
The ID of the customer group to which the customer belongs.
id Dimension
The unique identifier for the entity (e.g., customer, order, product).
increment_id Dimension
The human-readable increment ID (order number) of the order.
is_virtual Metric
A boolean indicator specifying whether the product or item is virtual and does not require shipping.
items.{NUM}.amount_refunded Metric
The total amount refunded for this specific order item in the display currency.
items.{NUM}.applied_rule_ids Dimension
A comma-separated list of IDs of the promotional rules that were applied to this order item.
items.{NUM}.base_amount_refunded Metric
The total amount refunded for this specific order item in the store's base currency.
items.{NUM}.base_cost Metric
The base cost of an individual item in the order.
items.{NUM}.base_discount_amount Metric
The discount amount applied to this order item in the store's base currency.
items.{NUM}.base_discount_invoiced Metric
The amount of discount for this order item that has been invoiced, in the store's base currency.
items.{NUM}.base_discount_tax_compensation_amount Metric
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_invoiced Metric
The invoiced amount of tax compensation for an item's discount in the store's base currency.
items.{NUM}.base_original_price Metric
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_price Metric
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_tax Metric
The price of the product associated with this order item, including taxes, in the store's base currency.
items.{NUM}.base_row_invoiced Metric
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_total Metric
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_tax Metric
The total amount of the row (quantity * price) for this order item, including taxes, in the store's base currency.
items.{NUM}.base_tax_amount Metric
The amount of tax applied to this order item, in the store's base currency.
items.{NUM}.base_tax_invoiced Metric
The amount of tax for this order item that has been invoiced, in the store's base currency.
items.{NUM}.created_at Dimension
The timestamp indicating when this order item was created.
items.{NUM}.discount_amount Metric
The discount amount applied to this order item in the display currency.
items.{NUM}.discount_invoiced Metric
The amount of discount for this order item that has been invoiced, in the display currency.
items.{NUM}.discount_percent Metric
The discount rate applied to this order item, expressed as a percentage.
items.{NUM}.discount_tax_compensation_amount Metric
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_invoiced Metric
The invoiced amount of tax compensation for an item's discount.
items.{NUM}.free_shipping Metric
A boolean indicator specifying if free shipping was applied specifically to this order item.
items.{NUM}.is_qty_decimal Metric
A boolean indicator specifying whether the quantity for this particular order item can be a decimal value.
items.{NUM}.is_virtual Metric
A boolean indicator specifying whether this order item is virtual and does not require shipping.
items.{NUM}.item_id Dimension
The unique identifier for this specific order item.
items.{NUM}.name Dimension
The name of the product associated with this order item.
items.{NUM}.no_discount Metric
A flag indicating whether a specific item is excluded from discount calculations.
items.{NUM}.order_id Dimension
The unique identifier of the order to which this item belongs.
items.{NUM}.original_price Metric
The original price of the product associated with this order item, in the display currency, before any special pricing or discounts.
items.{NUM}.price Metric
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_tax Metric
The price of the product associated with this order item, including taxes, in the display currency.
items.{NUM}.product_id Dimension
The unique identifier of the product from the catalog that this order item represents.
items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_id Dimension
The ID of a custom option selected for a product within an order item.
items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_value Metric
The selected value for a custom option of a product within an order item.
items.{NUM}.product_type Dimension
The type of product (e.g., simple, configurable, virtual, bundle) that this order item represents.
items.{NUM}.qty_backordered Metric
The quantity of the individual item that is currently on backorder.
items.{NUM}.qty_canceled Metric
The quantity of this order item that has been canceled.
items.{NUM}.qty_invoiced Metric
The quantity of this order item that has been invoiced.
items.{NUM}.qty_ordered Metric
The original quantity of this product ordered as part of the order item.
items.{NUM}.qty_refunded Metric
The quantity of this order item that has been refunded.
items.{NUM}.qty_shipped Metric
The quantity of this order item that has been shipped.
items.{NUM}.quote_item_id Dimension
The unique identifier for the original quote item from which this order item was created.
items.{NUM}.row_invoiced Metric
The total amount of the row (quantity * price) for this order item that has been invoiced, in the display currency.
items.{NUM}.row_total Metric
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_tax Metric
The total amount of the row (quantity * price) for this order item, including taxes, in the display currency.
items.{NUM}.row_weight Metric
The total weight of this order item, calculated as unit weight multiplied by the ordered quantity.
items.{NUM}.sku Dimension
The Stock Keeping Unit (SKU) of the product associated with this order item.
items.{NUM}.store_id Dimension
The unique identifier of the store from which this order item was purchased.
items.{NUM}.tax_amount Metric
The amount of tax applied to this order item, in the display currency.
items.{NUM}.tax_invoiced Metric
The amount of tax for this order item that has been invoiced, in the display currency.
items.{NUM}.tax_percent Metric
The tax rate applied to this order item, expressed as a percentage.
items.{NUM}.updated_at Dimension
The date and time when this specific order item was last updated.
items.{NUM}.weee_tax_applied Dimension
Details of any WEEE (Waste Electrical and Electronic Equipment) tax applied to this order item.
lastname Dimension
The last name of the customer.
order_currency_code Dimension
The currency code used for the order.
original_increment_id Dimension
The customer-facing identifier for the original order or entity.
payment.account_status Dimension
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_ordered Metric
The total amount of the order in the order currency.
payment.amount_paid Metric
The amount that has been paid for the order in the order currency.
payment.base_amount_ordered Metric
The total amount of the order in the store's base currency.
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 base shipping amount for the order in the store's base currency.
payment.base_shipping_captured Metric
The base shipping amount that has been 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 (if applicable and available).
payment.cc_last4 Dimension
The last four digits of the credit card number used for payment (if applicable and available).
payment.cc_ss_start_year Metric
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_id Dimension
The unique identifier for the payment record.
payment.method Dimension
The payment method used for the order (e.g., 'checkmo', 'paypal_express').
payment.parent_id Dimension
The ID of the order entity associated with this payment record.
payment.shipping_amount Metric
The shipping amount for the order in the order currency.
payment.shipping_captured Metric
The shipping amount that has been captured for the order in the order currency.
quote_id Dimension
The ID of the quote (shopping cart) from which this order was created.
shipping_amount Metric
The shipping amount for the order in the order currency.
shipping_description Dimension
A description of the shipping method used for the order (e.g., 'Flat Rate - Fixed').
shipping_discount_amount Metric
The discount amount applied to shipping for the order.
shipping_discount_tax_compensation_amount Metric
The amount of tax compensation for shipping discounts applied to the order.
shipping_incl_tax Metric
The shipping amount for the order, including tax, in the order currency.
shipping_invoiced Metric
The shipping amount that has been invoiced for the order.
shipping_tax_amount Metric
The tax amount applied to shipping for the order.
state Dimension
The current state of the order (e.g., 'new', 'pending_payment', 'processing', 'complete').
status Dimension
The current status of the order (e.g., 'pending', 'processing', 'complete', 'closed').
status_histories.{NUM}.comment Dimension
A comment associated with a specific status update in the order history.
status_histories.{NUM}.created_at Dimension
The date and time when this status history entry was created.
status_histories.{NUM}.entity_id Dimension
The ID of the status history entry.
status_histories.{NUM}.entity_name Dimension
The type of entity this status history entry belongs to (e.g., 'order').
status_histories.{NUM}.is_customer_notified Metric
Indicates whether the customer was notified about this status update (0 for no, 1 for yes).
status_histories.{NUM}.is_visible_on_front Metric
Indicates whether this status update is visible on the storefront to the customer (0 for no, 1 for yes).
status_histories.{NUM}.parent_id Dimension
The ID of the parent entity (e.g., the order ID) for this status history entry.
status_histories.{NUM}.status Dimension
The status associated with this history entry.
store_currency_code Dimension
The default currency code of the store.
store_id Dimension
The ID 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 display currency to its base currency.
store_to_order_rate Metric
The currency conversion rate from the store's display currency to the order's currency.
subtotal Metric
The subtotal of the order before shipping and tax, in the order currency.
subtotal_incl_tax Metric
The subtotal of the order, including tax, before shipping, in the order currency.
subtotal_invoiced Metric
The subtotal amount that has been invoiced for the order.
tax_amount Metric
The amount of tax applied to an item or the entire order/invoice.
tax_invoiced Metric
The amount of tax that has been invoiced for the order or an item.
total_due Metric
The remaining amount due for the order.
total_invoiced Metric
The total monetary amount of the order that has been invoiced.
total_item_count Metric
The total count of unique items in the order.
total_paid Metric
The total monetary amount that has been paid by the customer for the order.
total_qty_ordered Metric
The total quantity of all products ordered.
updated_at Dimension
The date and time when the entity (e.g., customer, order, product) was last updated.
website_id Dimension
The ID of the website where the entity (e.g., customer, order) was created or belongs.
weight Metric
The weight of the item or product.