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.
API name |
Adverity UI name |
Use in Adverity |
|---|---|---|
Month |
Month |
dimension |
Year |
Year |
metric |
added_at |
added_at |
dimension |
addresses.{NUM}.city |
addresses.{NUM}.city |
dimension |
addresses.{NUM}.company |
addresses.{NUM}.company |
dimension |
addresses.{NUM}.country_id |
addresses.{NUM}.country_id |
dimension |
addresses.{NUM}.customer_id |
addresses.{NUM}.customer_id |
dimension |
addresses.{NUM}.default_billing |
addresses.{NUM}.default_billing |
dimension |
addresses.{NUM}.default_shipping |
addresses.{NUM}.default_shipping |
dimension |
addresses.{NUM}.firstname |
addresses.{NUM}.firstname |
dimension |
addresses.{NUM}.id |
addresses.{NUM}.id |
metric |
addresses.{NUM}.lastname |
addresses.{NUM}.lastname |
dimension |
addresses.{NUM}.postcode |
addresses.{NUM}.postcode |
dimension |
addresses.{NUM}.region.region |
addresses.{NUM}.region.region |
dimension |
addresses.{NUM}.region.region_code |
addresses.{NUM}.region.region_code |
dimension |
addresses.{NUM}.region.region_id |
addresses.{NUM}.region.region_id |
dimension |
addresses.{NUM}.region_id |
addresses.{NUM}.region_id |
dimension |
addresses.{NUM}.street.{NUM} |
addresses.{NUM}.street.{NUM} |
dimension |
addresses.{NUM}.telephone |
addresses.{NUM}.telephone |
dimension |
addresses.{NUM}.vat_id |
addresses.{NUM}.vat_id |
dimension |
amount_refunded |
amount_refunded |
metric |
attribute_set_id |
attribute_set_id |
dimension |
base_amount_refunded |
base_amount_refunded |
metric |
base_cost |
base_cost |
metric |
base_currency_code |
base_currency_code |
dimension |
base_discount_amount |
base_discount_amount |
metric |
base_discount_canceled |
base_discount_canceled |
metric |
base_discount_invoiced |
base_discount_invoiced |
metric |
base_discount_tax_compensation_amount |
base_discount_tax_compensation_amount |
metric |
base_discount_tax_compensation_invoiced |
base_discount_tax_compensation_invoiced |
metric |
base_grand_total |
base_grand_total |
metric |
base_original_price |
base_original_price |
metric |
base_price |
base_price |
metric |
base_price_incl_tax |
base_price_incl_tax |
metric |
base_row_invoiced |
base_row_invoiced |
metric |
base_row_total |
base_row_total |
metric |
base_row_total_incl_tax |
base_row_total_incl_tax |
metric |
base_shipping_amount |
base_shipping_amount |
metric |
base_shipping_canceled |
base_shipping_canceled |
metric |
base_shipping_discount_amount |
base_shipping_discount_amount |
metric |
base_shipping_discount_tax_compensation_amnt |
base_shipping_discount_tax_compensation_amnt |
metric |
base_shipping_incl_tax |
base_shipping_incl_tax |
metric |
base_shipping_invoiced |
base_shipping_invoiced |
metric |
base_shipping_tax_amount |
base_shipping_tax_amount |
metric |
base_subtotal |
base_subtotal |
metric |
base_subtotal_canceled |
base_subtotal_canceled |
metric |
base_subtotal_incl_tax |
base_subtotal_incl_tax |
metric |
base_subtotal_invoiced |
base_subtotal_invoiced |
metric |
base_tax_amount |
base_tax_amount |
metric |
base_tax_canceled |
base_tax_canceled |
metric |
base_tax_invoiced |
base_tax_invoiced |
metric |
base_to_global_rate |
base_to_global_rate |
metric |
base_to_order_rate |
base_to_order_rate |
metric |
base_total_canceled |
base_total_canceled |
metric |
base_total_due |
base_total_due |
metric |
base_total_invoiced |
base_total_invoiced |
metric |
base_total_invoiced_cost |
base_total_invoiced_cost |
metric |
base_total_paid |
base_total_paid |
metric |
billing_address.address_type |
billing_address.address_type |
dimension |
billing_address.city |
billing_address.city |
dimension |
billing_address.company |
billing_address.company |
dimension |
billing_address.country_id |
billing_address.country_id |
dimension |
billing_address.customer_address_id |
billing_address.customer_address_id |
dimension |
billing_address.email |
billing_address.email |
dimension |
billing_address.entity_id |
billing_address.entity_id |
dimension |
billing_address.firstname |
billing_address.firstname |
dimension |
billing_address.lastname |
billing_address.lastname |
dimension |
billing_address.parent_id |
billing_address.parent_id |
dimension |
billing_address.postcode |
billing_address.postcode |
dimension |
billing_address.region |
billing_address.region |
dimension |
billing_address.region_code |
billing_address.region_code |
dimension |
billing_address.region_id |
billing_address.region_id |
dimension |
billing_address.street.{NUM} |
billing_address.street.{NUM} |
dimension |
billing_address.telephone |
billing_address.telephone |
dimension |
billing_address.vat_id |
billing_address.vat_id |
dimension |
billing_address.vat_is_valid |
billing_address.vat_is_valid |
metric |
billing_address.vat_request_date |
billing_address.vat_request_date |
dimension |
billing_address.vat_request_id |
billing_address.vat_request_id |
dimension |
billing_address.vat_request_success |
billing_address.vat_request_success |
metric |
billing_address_id |
billing_address_id |
dimension |
campaign_referrer |
campaign_referrer |
dimension |
can_void_flag |
can_void_flag |
metric |
converted_at |
converted_at |
dimension |
created_at |
created_at |
dimension |
created_in |
created_in |
dimension |
custom_attributes.{NUM}.attribute_code |
custom_attributes.{NUM}.attribute_code |
dimension |
custom_attributes.{NUM}.value |
custom_attributes.{NUM}.value |
dimension |
custom_attributes.{NUM}.value.{NUM} |
custom_attributes.{NUM}.value.{NUM} |
metric |
customer_dob |
customer_dob |
dimension |
customer_email |
customer_email |
dimension |
customer_firstname |
customer_firstname |
dimension |
customer_group_id |
customer_group_id |
dimension |
customer_id |
customer_id |
dimension |
customer_is_guest |
customer_is_guest |
metric |
customer_lastname |
customer_lastname |
dimension |
customer_note_notify |
customer_note_notify |
metric |
date |
date |
dimension |
default_billing |
default_billing |
metric |
default_shipping |
default_shipping |
metric |
disable_auto_group_change |
disable_auto_group_change |
metric |
discount_amount |
discount_amount |
metric |
discount_canceled |
discount_canceled |
metric |
discount_invoiced |
discount_invoiced |
metric |
discount_percent |
discount_percent |
metric |
discount_tax_compensation_amount |
discount_tax_compensation_amount |
metric |
discount_tax_compensation_canceled |
discount_tax_compensation_canceled |
metric |
discount_tax_compensation_invoiced |
discount_tax_compensation_invoiced |
metric |
dob |
dob |
dimension |
dimension |
||
email_sent |
email_sent |
metric |
entity_id |
entity_id |
dimension |
extension_attributes.applied_taxes.{NUM}.amount |
extension_attributes.applied_taxes.{NUM}.amount |
metric |
extension_attributes.applied_taxes.{NUM}.base_amount |
extension_attributes.applied_taxes.{NUM}.base_amount |
metric |
extension_attributes.applied_taxes.{NUM}.code |
extension_attributes.applied_taxes.{NUM}.code |
dimension |
extension_attributes.applied_taxes.{NUM}.percent |
extension_attributes.applied_taxes.{NUM}.percent |
metric |
extension_attributes.applied_taxes.{NUM}.title |
extension_attributes.applied_taxes.{NUM}.title |
dimension |
extension_attributes.category_links.{NUM}.category_id |
extension_attributes.category_links.{NUM}.category_id |
dimension |
extension_attributes.category_links.{NUM}.position |
extension_attributes.category_links.{NUM}.position |
metric |
extension_attributes.configurable_product_links.{NUM} |
extension_attributes.configurable_product_links.{NUM} |
metric |
extension_attributes.configurable_product_options.{NUM}.attribute_id |
extension_attributes.configurable_product_options.{NUM}.attribute_id |
dimension |
extension_attributes.configurable_product_options.{NUM}.id |
extension_attributes.configurable_product_options.{NUM}.id |
metric |
extension_attributes.configurable_product_options.{NUM}.label |
extension_attributes.configurable_product_options.{NUM}.label |
dimension |
extension_attributes.configurable_product_options.{NUM}.position |
extension_attributes.configurable_product_options.{NUM}.position |
metric |
extension_attributes.configurable_product_options.{NUM}.product_id |
extension_attributes.configurable_product_options.{NUM}.product_id |
dimension |
extension_attributes.configurable_product_options.{NUM}.values.{NUM}.value_index |
extension_attributes.configurable_product_options.{NUM}.values.{NUM}.value_index |
metric |
extension_attributes.converting_from_quote |
extension_attributes.converting_from_quote |
dimension |
extension_attributes.is_subscribed |
extension_attributes.is_subscribed |
dimension |
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.amount |
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.amount |
metric |
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.base_amount |
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.base_amount |
metric |
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.code |
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.code |
dimension |
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.percent |
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.percent |
metric |
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.title |
extension_attributes.item_applied_taxes.{NUM}.applied_taxes.{NUM}.title |
dimension |
extension_attributes.item_applied_taxes.{NUM}.item_id |
extension_attributes.item_applied_taxes.{NUM}.item_id |
dimension |
extension_attributes.item_applied_taxes.{NUM}.type |
extension_attributes.item_applied_taxes.{NUM}.type |
dimension |
extension_attributes.payment_additional_info.{NUM}.key |
extension_attributes.payment_additional_info.{NUM}.key |
dimension |
extension_attributes.payment_additional_info.{NUM}.value |
extension_attributes.payment_additional_info.{NUM}.value |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.amount_refunded |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.amount_refunded |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_amount_refunded |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_amount_refunded |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_cost |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_cost |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_amount |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_invoiced |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_tax_compensation_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_tax_compensation_amount |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_tax_compensation_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_discount_tax_compensation_invoiced |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_original_price |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_original_price |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_price |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_price |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_price_incl_tax |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_price_incl_tax |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_invoiced |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_total |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_total |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_total_incl_tax |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_row_total_incl_tax |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_tax_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_tax_amount |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_tax_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.base_tax_invoiced |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.created_at |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.created_at |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_amount |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_invoiced |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_percent |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_percent |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_amount |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_canceled |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_canceled |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.discount_tax_compensation_invoiced |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.free_shipping |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.free_shipping |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_qty_decimal |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_qty_decimal |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_virtual |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.is_virtual |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.item_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.item_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.name |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.name |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.no_discount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.no_discount |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.order_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.order_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.original_price |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.original_price |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.amount_refunded |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.amount_refunded |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_amount_refunded |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_amount_refunded |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_amount |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_invoiced |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_tax_compensation_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_tax_compensation_amount |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_tax_compensation_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_discount_tax_compensation_invoiced |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_original_price |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_original_price |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_price |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_price |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_price_incl_tax |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_price_incl_tax |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_invoiced |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_total |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_total |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_total_incl_tax |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_row_total_incl_tax |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_tax_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_tax_amount |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_tax_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.base_tax_invoiced |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.created_at |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.created_at |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_amount |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_invoiced |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_percent |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_percent |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_amount |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_canceled |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_canceled |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.discount_tax_compensation_invoiced |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.free_shipping |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.free_shipping |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.is_qty_decimal |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.is_qty_decimal |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.is_virtual |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.is_virtual |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.item_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.item_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.name |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.name |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.no_discount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.no_discount |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.order_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.order_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.original_price |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.original_price |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.price |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.price |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.price_incl_tax |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.price_incl_tax |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.custom_options.{NUM}.option_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.custom_options.{NUM}.option_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.custom_options.{NUM}.option_value |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_option.extension_attributes.custom_options.{NUM}.option_value |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_type |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.product_type |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_canceled |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_canceled |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_invoiced |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_ordered |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_ordered |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_refunded |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_refunded |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_shipped |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.qty_shipped |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.quote_item_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.quote_item_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_invoiced |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_total |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_total |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_total_incl_tax |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_total_incl_tax |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_weight |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.row_weight |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.sku |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.sku |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.store_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.store_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_amount |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_canceled |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_canceled |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_invoiced |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_percent |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.tax_percent |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.updated_at |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.updated_at |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.weee_tax_applied |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.weee_tax_applied |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.weight |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item.weight |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.parent_item_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price_incl_tax |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.price_incl_tax |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_value |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_value |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_type |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.product_type |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_backordered |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_backordered |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_canceled |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_canceled |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_invoiced |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_ordered |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_ordered |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_refunded |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_refunded |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_shipped |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.qty_shipped |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.quote_item_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.quote_item_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_invoiced |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_total |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_total |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_total_incl_tax |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_total_incl_tax |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_weight |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.row_weight |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.sku |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.sku |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.store_id |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.store_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_amount |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_amount |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_canceled |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_canceled |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_invoiced |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_invoiced |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_percent |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.tax_percent |
metric |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.updated_at |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.updated_at |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.weee_tax_applied |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.weee_tax_applied |
dimension |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.weight |
extension_attributes.shipping_assignments.{NUM}.items.{NUM}.weight |
metric |
extension_attributes.shipping_assignments.{NUM}.shipping.address.address_type |
extension_attributes.shipping_assignments.{NUM}.shipping.address.address_type |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.city |
extension_attributes.shipping_assignments.{NUM}.shipping.address.city |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.company |
extension_attributes.shipping_assignments.{NUM}.shipping.address.company |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.country_id |
extension_attributes.shipping_assignments.{NUM}.shipping.address.country_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.customer_address_id |
extension_attributes.shipping_assignments.{NUM}.shipping.address.customer_address_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.email |
extension_attributes.shipping_assignments.{NUM}.shipping.address.email |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.entity_id |
extension_attributes.shipping_assignments.{NUM}.shipping.address.entity_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.firstname |
extension_attributes.shipping_assignments.{NUM}.shipping.address.firstname |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.lastname |
extension_attributes.shipping_assignments.{NUM}.shipping.address.lastname |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.parent_id |
extension_attributes.shipping_assignments.{NUM}.shipping.address.parent_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.postcode |
extension_attributes.shipping_assignments.{NUM}.shipping.address.postcode |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.region |
extension_attributes.shipping_assignments.{NUM}.shipping.address.region |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.region_code |
extension_attributes.shipping_assignments.{NUM}.shipping.address.region_code |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.region_id |
extension_attributes.shipping_assignments.{NUM}.shipping.address.region_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.street.{NUM} |
extension_attributes.shipping_assignments.{NUM}.shipping.address.street.{NUM} |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.telephone |
extension_attributes.shipping_assignments.{NUM}.shipping.address.telephone |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_id |
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_is_valid |
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_is_valid |
metric |
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_request_date |
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_request_date |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_request_id |
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_request_id |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_request_success |
extension_attributes.shipping_assignments.{NUM}.shipping.address.vat_request_success |
metric |
extension_attributes.shipping_assignments.{NUM}.shipping.method |
extension_attributes.shipping_assignments.{NUM}.shipping.method |
dimension |
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_amount |
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_amount |
metric |
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_canceled |
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_canceled |
metric |
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_discount_amount |
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_discount_amount |
metric |
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_discount_tax_compensation_amnt |
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_discount_tax_compensation_amnt |
metric |
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_incl_tax |
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_incl_tax |
metric |
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_invoiced |
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_invoiced |
metric |
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_tax_amount |
extension_attributes.shipping_assignments.{NUM}.shipping.total.base_shipping_tax_amount |
metric |
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_amount |
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_amount |
metric |
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_canceled |
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_canceled |
metric |
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_discount_amount |
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_discount_amount |
metric |
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_discount_tax_compensation_amount |
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_discount_tax_compensation_amount |
metric |
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_incl_tax |
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_incl_tax |
metric |
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_invoiced |
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_invoiced |
metric |
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_tax_amount |
extension_attributes.shipping_assignments.{NUM}.shipping.total.shipping_tax_amount |
metric |
extension_attributes.website_ids.{NUM} |
extension_attributes.website_ids.{NUM} |
dimension |
firstname |
firstname |
dimension |
free_shipping |
free_shipping |
metric |
global_currency_code |
global_currency_code |
dimension |
grand_total |
grand_total |
metric |
group_id |
group_id |
dimension |
hold_before_state |
hold_before_state |
dimension |
hold_before_status |
hold_before_status |
dimension |
id |
id |
dimension |
increment_id |
increment_id |
dimension |
is_active |
is_active |
metric |
is_qty_decimal |
is_qty_decimal |
metric |
is_virtual |
is_virtual |
metric |
item_id |
item_id |
dimension |
items.{NUM}.amount_refunded |
items.{NUM}.amount_refunded |
metric |
items.{NUM}.base_amount_refunded |
items.{NUM}.base_amount_refunded |
metric |
items.{NUM}.base_cost |
items.{NUM}.base_cost |
metric |
items.{NUM}.base_discount_amount |
items.{NUM}.base_discount_amount |
metric |
items.{NUM}.base_discount_invoiced |
items.{NUM}.base_discount_invoiced |
metric |
items.{NUM}.base_discount_tax_compensation_amount |
items.{NUM}.base_discount_tax_compensation_amount |
metric |
items.{NUM}.base_discount_tax_compensation_invoiced |
items.{NUM}.base_discount_tax_compensation_invoiced |
metric |
items.{NUM}.base_original_price |
items.{NUM}.base_original_price |
metric |
items.{NUM}.base_price |
items.{NUM}.base_price |
metric |
items.{NUM}.base_price_incl_tax |
items.{NUM}.base_price_incl_tax |
metric |
items.{NUM}.base_row_invoiced |
items.{NUM}.base_row_invoiced |
metric |
items.{NUM}.base_row_total |
items.{NUM}.base_row_total |
metric |
items.{NUM}.base_row_total_incl_tax |
items.{NUM}.base_row_total_incl_tax |
metric |
items.{NUM}.base_tax_amount |
items.{NUM}.base_tax_amount |
metric |
items.{NUM}.base_tax_invoiced |
items.{NUM}.base_tax_invoiced |
metric |
items.{NUM}.created_at |
items.{NUM}.created_at |
dimension |
items.{NUM}.discount_amount |
items.{NUM}.discount_amount |
metric |
items.{NUM}.discount_invoiced |
items.{NUM}.discount_invoiced |
metric |
items.{NUM}.discount_percent |
items.{NUM}.discount_percent |
metric |
items.{NUM}.discount_tax_compensation_amount |
items.{NUM}.discount_tax_compensation_amount |
metric |
items.{NUM}.discount_tax_compensation_canceled |
items.{NUM}.discount_tax_compensation_canceled |
metric |
items.{NUM}.discount_tax_compensation_invoiced |
items.{NUM}.discount_tax_compensation_invoiced |
metric |
items.{NUM}.entity_id |
items.{NUM}.entity_id |
dimension |
items.{NUM}.free_shipping |
items.{NUM}.free_shipping |
metric |
items.{NUM}.is_qty_decimal |
items.{NUM}.is_qty_decimal |
metric |
items.{NUM}.is_virtual |
items.{NUM}.is_virtual |
metric |
items.{NUM}.item_id |
items.{NUM}.item_id |
dimension |
items.{NUM}.name |
items.{NUM}.name |
dimension |
items.{NUM}.no_discount |
items.{NUM}.no_discount |
metric |
items.{NUM}.order_id |
items.{NUM}.order_id |
dimension |
items.{NUM}.order_item_id |
items.{NUM}.order_item_id |
dimension |
items.{NUM}.original_price |
items.{NUM}.original_price |
metric |
items.{NUM}.parent_id |
items.{NUM}.parent_id |
dimension |
items.{NUM}.parent_item.amount_refunded |
items.{NUM}.parent_item.amount_refunded |
metric |
items.{NUM}.parent_item.base_amount_refunded |
items.{NUM}.parent_item.base_amount_refunded |
metric |
items.{NUM}.parent_item.base_discount_amount |
items.{NUM}.parent_item.base_discount_amount |
metric |
items.{NUM}.parent_item.base_discount_invoiced |
items.{NUM}.parent_item.base_discount_invoiced |
metric |
items.{NUM}.parent_item.base_discount_tax_compensation_amount |
items.{NUM}.parent_item.base_discount_tax_compensation_amount |
metric |
items.{NUM}.parent_item.base_discount_tax_compensation_invoiced |
items.{NUM}.parent_item.base_discount_tax_compensation_invoiced |
metric |
items.{NUM}.parent_item.base_original_price |
items.{NUM}.parent_item.base_original_price |
metric |
items.{NUM}.parent_item.base_price |
items.{NUM}.parent_item.base_price |
metric |
items.{NUM}.parent_item.base_price_incl_tax |
items.{NUM}.parent_item.base_price_incl_tax |
metric |
items.{NUM}.parent_item.base_row_invoiced |
items.{NUM}.parent_item.base_row_invoiced |
metric |
items.{NUM}.parent_item.base_row_total |
items.{NUM}.parent_item.base_row_total |
metric |
items.{NUM}.parent_item.base_row_total_incl_tax |
items.{NUM}.parent_item.base_row_total_incl_tax |
metric |
items.{NUM}.parent_item.base_tax_amount |
items.{NUM}.parent_item.base_tax_amount |
metric |
items.{NUM}.parent_item.base_tax_invoiced |
items.{NUM}.parent_item.base_tax_invoiced |
metric |
items.{NUM}.parent_item.created_at |
items.{NUM}.parent_item.created_at |
dimension |
items.{NUM}.parent_item.discount_amount |
items.{NUM}.parent_item.discount_amount |
metric |
items.{NUM}.parent_item.discount_invoiced |
items.{NUM}.parent_item.discount_invoiced |
metric |
items.{NUM}.parent_item.discount_percent |
items.{NUM}.parent_item.discount_percent |
metric |
items.{NUM}.parent_item.discount_tax_compensation_amount |
items.{NUM}.parent_item.discount_tax_compensation_amount |
metric |
items.{NUM}.parent_item.discount_tax_compensation_canceled |
items.{NUM}.parent_item.discount_tax_compensation_canceled |
metric |
items.{NUM}.parent_item.discount_tax_compensation_invoiced |
items.{NUM}.parent_item.discount_tax_compensation_invoiced |
metric |
items.{NUM}.parent_item.free_shipping |
items.{NUM}.parent_item.free_shipping |
metric |
items.{NUM}.parent_item.is_qty_decimal |
items.{NUM}.parent_item.is_qty_decimal |
metric |
items.{NUM}.parent_item.is_virtual |
items.{NUM}.parent_item.is_virtual |
metric |
items.{NUM}.parent_item.item_id |
items.{NUM}.parent_item.item_id |
dimension |
items.{NUM}.parent_item.name |
items.{NUM}.parent_item.name |
dimension |
items.{NUM}.parent_item.no_discount |
items.{NUM}.parent_item.no_discount |
metric |
items.{NUM}.parent_item.order_id |
items.{NUM}.parent_item.order_id |
dimension |
items.{NUM}.parent_item.original_price |
items.{NUM}.parent_item.original_price |
metric |
items.{NUM}.parent_item.price |
items.{NUM}.parent_item.price |
metric |
items.{NUM}.parent_item.price_incl_tax |
items.{NUM}.parent_item.price_incl_tax |
metric |
items.{NUM}.parent_item.product_id |
items.{NUM}.parent_item.product_id |
dimension |
items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_id |
items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_id |
dimension |
items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
items.{NUM}.parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
metric |
items.{NUM}.parent_item.product_option.extension_attributes.custom_options.{NUM}.option_id |
items.{NUM}.parent_item.product_option.extension_attributes.custom_options.{NUM}.option_id |
dimension |
items.{NUM}.parent_item.product_option.extension_attributes.custom_options.{NUM}.option_value |
items.{NUM}.parent_item.product_option.extension_attributes.custom_options.{NUM}.option_value |
metric |
items.{NUM}.parent_item.product_type |
items.{NUM}.parent_item.product_type |
dimension |
items.{NUM}.parent_item.qty_canceled |
items.{NUM}.parent_item.qty_canceled |
metric |
items.{NUM}.parent_item.qty_invoiced |
items.{NUM}.parent_item.qty_invoiced |
metric |
items.{NUM}.parent_item.qty_ordered |
items.{NUM}.parent_item.qty_ordered |
metric |
items.{NUM}.parent_item.qty_refunded |
items.{NUM}.parent_item.qty_refunded |
metric |
items.{NUM}.parent_item.qty_shipped |
items.{NUM}.parent_item.qty_shipped |
metric |
items.{NUM}.parent_item.quote_item_id |
items.{NUM}.parent_item.quote_item_id |
dimension |
items.{NUM}.parent_item.row_invoiced |
items.{NUM}.parent_item.row_invoiced |
metric |
items.{NUM}.parent_item.row_total |
items.{NUM}.parent_item.row_total |
metric |
items.{NUM}.parent_item.row_total_incl_tax |
items.{NUM}.parent_item.row_total_incl_tax |
metric |
items.{NUM}.parent_item.row_weight |
items.{NUM}.parent_item.row_weight |
metric |
items.{NUM}.parent_item.sku |
items.{NUM}.parent_item.sku |
dimension |
items.{NUM}.parent_item.store_id |
items.{NUM}.parent_item.store_id |
dimension |
items.{NUM}.parent_item.tax_amount |
items.{NUM}.parent_item.tax_amount |
metric |
items.{NUM}.parent_item.tax_canceled |
items.{NUM}.parent_item.tax_canceled |
metric |
items.{NUM}.parent_item.tax_invoiced |
items.{NUM}.parent_item.tax_invoiced |
metric |
items.{NUM}.parent_item.tax_percent |
items.{NUM}.parent_item.tax_percent |
metric |
items.{NUM}.parent_item.updated_at |
items.{NUM}.parent_item.updated_at |
dimension |
items.{NUM}.parent_item.weee_tax_applied |
items.{NUM}.parent_item.weee_tax_applied |
dimension |
items.{NUM}.parent_item.weight |
items.{NUM}.parent_item.weight |
metric |
items.{NUM}.parent_item_id |
items.{NUM}.parent_item_id |
dimension |
items.{NUM}.price |
items.{NUM}.price |
metric |
items.{NUM}.price_incl_tax |
items.{NUM}.price_incl_tax |
metric |
items.{NUM}.product_id |
items.{NUM}.product_id |
dimension |
items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_id |
items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_id |
dimension |
items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
items.{NUM}.product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
metric |
items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_id |
items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_id |
dimension |
items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_value |
items.{NUM}.product_option.extension_attributes.custom_options.{NUM}.option_value |
metric |
items.{NUM}.product_type |
items.{NUM}.product_type |
dimension |
items.{NUM}.qty |
items.{NUM}.qty |
metric |
items.{NUM}.qty_backordered |
items.{NUM}.qty_backordered |
metric |
items.{NUM}.qty_canceled |
items.{NUM}.qty_canceled |
metric |
items.{NUM}.qty_invoiced |
items.{NUM}.qty_invoiced |
metric |
items.{NUM}.qty_ordered |
items.{NUM}.qty_ordered |
metric |
items.{NUM}.qty_refunded |
items.{NUM}.qty_refunded |
metric |
items.{NUM}.qty_shipped |
items.{NUM}.qty_shipped |
metric |
items.{NUM}.quote_item_id |
items.{NUM}.quote_item_id |
dimension |
items.{NUM}.row_invoiced |
items.{NUM}.row_invoiced |
metric |
items.{NUM}.row_total |
items.{NUM}.row_total |
metric |
items.{NUM}.row_total_incl_tax |
items.{NUM}.row_total_incl_tax |
metric |
items.{NUM}.row_weight |
items.{NUM}.row_weight |
metric |
items.{NUM}.sku |
items.{NUM}.sku |
dimension |
items.{NUM}.store_id |
items.{NUM}.store_id |
dimension |
items.{NUM}.tax_amount |
items.{NUM}.tax_amount |
metric |
items.{NUM}.tax_canceled |
items.{NUM}.tax_canceled |
metric |
items.{NUM}.tax_invoiced |
items.{NUM}.tax_invoiced |
metric |
items.{NUM}.tax_percent |
items.{NUM}.tax_percent |
metric |
items.{NUM}.updated_at |
items.{NUM}.updated_at |
dimension |
items.{NUM}.weee_tax_applied |
items.{NUM}.weee_tax_applied |
dimension |
items.{NUM}.weight |
items.{NUM}.weight |
metric |
items_count |
items_count |
metric |
items_qty |
items_qty |
metric |
lastname |
lastname |
dimension |
media_gallery_entries.{NUM}.disabled |
media_gallery_entries.{NUM}.disabled |
dimension |
media_gallery_entries.{NUM}.file |
media_gallery_entries.{NUM}.file |
dimension |
media_gallery_entries.{NUM}.id |
media_gallery_entries.{NUM}.id |
metric |
media_gallery_entries.{NUM}.label |
media_gallery_entries.{NUM}.label |
dimension |
media_gallery_entries.{NUM}.media_type |
media_gallery_entries.{NUM}.media_type |
dimension |
media_gallery_entries.{NUM}.position |
media_gallery_entries.{NUM}.position |
metric |
media_gallery_entries.{NUM}.types.{NUM} |
media_gallery_entries.{NUM}.types.{NUM} |
dimension |
name |
name |
dimension |
no_discount |
no_discount |
metric |
order_currency_code |
order_currency_code |
dimension |
order_id |
order_id |
dimension |
orig_order_id |
orig_order_id |
dimension |
original_price |
original_price |
metric |
parent_item.amount_refunded |
parent_item.amount_refunded |
metric |
parent_item.base_amount_refunded |
parent_item.base_amount_refunded |
metric |
parent_item.base_discount_amount |
parent_item.base_discount_amount |
metric |
parent_item.base_discount_invoiced |
parent_item.base_discount_invoiced |
metric |
parent_item.base_discount_tax_compensation_amount |
parent_item.base_discount_tax_compensation_amount |
metric |
parent_item.base_discount_tax_compensation_invoiced |
parent_item.base_discount_tax_compensation_invoiced |
metric |
parent_item.base_original_price |
parent_item.base_original_price |
metric |
parent_item.base_price |
parent_item.base_price |
metric |
parent_item.base_price_incl_tax |
parent_item.base_price_incl_tax |
metric |
parent_item.base_row_invoiced |
parent_item.base_row_invoiced |
metric |
parent_item.base_row_total |
parent_item.base_row_total |
metric |
parent_item.base_row_total_incl_tax |
parent_item.base_row_total_incl_tax |
metric |
parent_item.base_tax_amount |
parent_item.base_tax_amount |
metric |
parent_item.base_tax_invoiced |
parent_item.base_tax_invoiced |
metric |
parent_item.created_at |
parent_item.created_at |
dimension |
parent_item.discount_amount |
parent_item.discount_amount |
metric |
parent_item.discount_invoiced |
parent_item.discount_invoiced |
metric |
parent_item.discount_percent |
parent_item.discount_percent |
metric |
parent_item.discount_tax_compensation_amount |
parent_item.discount_tax_compensation_amount |
metric |
parent_item.discount_tax_compensation_canceled |
parent_item.discount_tax_compensation_canceled |
metric |
parent_item.discount_tax_compensation_invoiced |
parent_item.discount_tax_compensation_invoiced |
metric |
parent_item.free_shipping |
parent_item.free_shipping |
metric |
parent_item.is_qty_decimal |
parent_item.is_qty_decimal |
metric |
parent_item.is_virtual |
parent_item.is_virtual |
metric |
parent_item.item_id |
parent_item.item_id |
dimension |
parent_item.name |
parent_item.name |
dimension |
parent_item.no_discount |
parent_item.no_discount |
metric |
parent_item.order_id |
parent_item.order_id |
dimension |
parent_item.original_price |
parent_item.original_price |
metric |
parent_item.price |
parent_item.price |
metric |
parent_item.price_incl_tax |
parent_item.price_incl_tax |
metric |
parent_item.product_id |
parent_item.product_id |
dimension |
parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_id |
parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_id |
dimension |
parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
parent_item.product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
metric |
parent_item.product_option.extension_attributes.custom_options.{NUM}.option_id |
parent_item.product_option.extension_attributes.custom_options.{NUM}.option_id |
dimension |
parent_item.product_option.extension_attributes.custom_options.{NUM}.option_value |
parent_item.product_option.extension_attributes.custom_options.{NUM}.option_value |
metric |
parent_item.product_type |
parent_item.product_type |
dimension |
parent_item.qty_canceled |
parent_item.qty_canceled |
metric |
parent_item.qty_invoiced |
parent_item.qty_invoiced |
metric |
parent_item.qty_ordered |
parent_item.qty_ordered |
metric |
parent_item.qty_refunded |
parent_item.qty_refunded |
metric |
parent_item.qty_shipped |
parent_item.qty_shipped |
metric |
parent_item.quote_item_id |
parent_item.quote_item_id |
dimension |
parent_item.row_invoiced |
parent_item.row_invoiced |
metric |
parent_item.row_total |
parent_item.row_total |
metric |
parent_item.row_total_incl_tax |
parent_item.row_total_incl_tax |
metric |
parent_item.row_weight |
parent_item.row_weight |
metric |
parent_item.sku |
parent_item.sku |
dimension |
parent_item.store_id |
parent_item.store_id |
dimension |
parent_item.tax_amount |
parent_item.tax_amount |
metric |
parent_item.tax_canceled |
parent_item.tax_canceled |
metric |
parent_item.tax_invoiced |
parent_item.tax_invoiced |
metric |
parent_item.tax_percent |
parent_item.tax_percent |
metric |
parent_item.updated_at |
parent_item.updated_at |
dimension |
parent_item.weee_tax_applied |
parent_item.weee_tax_applied |
dimension |
parent_item.weight |
parent_item.weight |
metric |
parent_item_id |
parent_item_id |
dimension |
payment.account_status |
payment.account_status |
dimension |
payment.additional_information.{NUM} |
payment.additional_information.{NUM} |
dimension |
payment.amount_authorized |
payment.amount_authorized |
metric |
payment.amount_ordered |
payment.amount_ordered |
metric |
payment.amount_paid |
payment.amount_paid |
metric |
payment.base_amount_authorized |
payment.base_amount_authorized |
metric |
payment.base_amount_ordered |
payment.base_amount_ordered |
metric |
payment.base_amount_paid |
payment.base_amount_paid |
metric |
payment.base_shipping_amount |
payment.base_shipping_amount |
metric |
payment.base_shipping_captured |
payment.base_shipping_captured |
metric |
payment.cc_exp_year |
payment.cc_exp_year |
metric |
payment.cc_last4 |
payment.cc_last4 |
dimension |
payment.cc_ss_start_month |
payment.cc_ss_start_month |
metric |
payment.cc_ss_start_year |
payment.cc_ss_start_year |
metric |
payment.entity_id |
payment.entity_id |
dimension |
payment.last_trans_id |
payment.last_trans_id |
dimension |
payment.method |
payment.method |
dimension |
payment.parent_id |
payment.parent_id |
dimension |
payment.shipping_amount |
payment.shipping_amount |
metric |
payment.shipping_captured |
payment.shipping_captured |
metric |
price |
price |
metric |
price_incl_tax |
price_incl_tax |
metric |
product_id |
product_id |
dimension |
product_links.{NUM}.link_type |
product_links.{NUM}.link_type |
dimension |
product_links.{NUM}.linked_product_sku |
product_links.{NUM}.linked_product_sku |
dimension |
product_links.{NUM}.linked_product_type |
product_links.{NUM}.linked_product_type |
dimension |
product_links.{NUM}.position |
product_links.{NUM}.position |
metric |
product_links.{NUM}.sku |
product_links.{NUM}.sku |
dimension |
product_option.extension_attributes.configurable_item_options.{NUM}.option_id |
product_option.extension_attributes.configurable_item_options.{NUM}.option_id |
dimension |
product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
product_option.extension_attributes.configurable_item_options.{NUM}.option_value |
metric |
product_option.extension_attributes.custom_options.{NUM}.option_id |
product_option.extension_attributes.custom_options.{NUM}.option_id |
dimension |
product_option.extension_attributes.custom_options.{NUM}.option_value |
product_option.extension_attributes.custom_options.{NUM}.option_value |
metric |
product_type |
product_type |
dimension |
protect_code |
protect_code |
dimension |
qty |
qty |
metric |
qty_backordered |
qty_backordered |
metric |
qty_canceled |
qty_canceled |
metric |
qty_invoiced |
qty_invoiced |
metric |
qty_ordered |
qty_ordered |
metric |
qty_refunded |
qty_refunded |
metric |
qty_shipped |
qty_shipped |
metric |
quote_id |
quote_id |
dimension |
quote_item_id |
quote_item_id |
dimension |
remote_ip |
remote_ip |
dimension |
row_invoiced |
row_invoiced |
metric |
row_total |
row_total |
metric |
row_total_incl_tax |
row_total_incl_tax |
metric |
row_weight |
row_weight |
metric |
shipping_address_id |
shipping_address_id |
dimension |
shipping_amount |
shipping_amount |
metric |
shipping_canceled |
shipping_canceled |
metric |
shipping_description |
shipping_description |
dimension |
shipping_discount_amount |
shipping_discount_amount |
metric |
shipping_discount_tax_compensation_amount |
shipping_discount_tax_compensation_amount |
metric |
shipping_incl_tax |
shipping_incl_tax |
metric |
shipping_invoiced |
shipping_invoiced |
metric |
shipping_tax_amount |
shipping_tax_amount |
metric |
sku |
sku |
dimension |
state |
state |
dimension |
status |
status |
metric |
status_histories.{NUM}.comment |
status_histories.{NUM}.comment |
dimension |
status_histories.{NUM}.created_at |
status_histories.{NUM}.created_at |
dimension |
status_histories.{NUM}.entity_id |
status_histories.{NUM}.entity_id |
dimension |
status_histories.{NUM}.entity_name |
status_histories.{NUM}.entity_name |
dimension |
status_histories.{NUM}.is_customer_notified |
status_histories.{NUM}.is_customer_notified |
metric |
status_histories.{NUM}.is_visible_on_front |
status_histories.{NUM}.is_visible_on_front |
metric |
status_histories.{NUM}.parent_id |
status_histories.{NUM}.parent_id |
dimension |
status_histories.{NUM}.status |
status_histories.{NUM}.status |
dimension |
store_currency_code |
store_currency_code |
dimension |
store_id |
store_id |
dimension |
store_name |
store_name |
dimension |
store_to_base_rate |
store_to_base_rate |
metric |
store_to_order_rate |
store_to_order_rate |
metric |
subtotal |
subtotal |
metric |
subtotal_canceled |
subtotal_canceled |
metric |
subtotal_incl_tax |
subtotal_incl_tax |
metric |
subtotal_invoiced |
subtotal_invoiced |
metric |
tax_amount |
tax_amount |
metric |
tax_canceled |
tax_canceled |
metric |
tax_invoiced |
tax_invoiced |
metric |
tax_percent |
tax_percent |
metric |
total_canceled |
total_canceled |
metric |
total_due |
total_due |
metric |
total_invoiced |
total_invoiced |
metric |
total_item_count |
total_item_count |
metric |
total_paid |
total_paid |
metric |
total_qty |
total_qty |
metric |
total_qty_ordered |
total_qty_ordered |
metric |
transaction_id |
transaction_id |
dimension |
type_id |
type_id |
dimension |
updated_at |
updated_at |
dimension |
visibility |
visibility |
metric |
website_id |
website_id |
dimension |
weee_tax_applied |
weee_tax_applied |
dimension |
weight |
weight |
metric |
wishlist_id |
wishlist_id |
dimension |
wishlist_item_id |
wishlist_item_id |
dimension |