Search fields×Table: ORDER billing_address_type Display name Billing address type Description The type of address associated with the billing customer Field type dimension Data type string.text.value billing_city Display name Billing city Description The city of the billing address Field type dimension Data type string.geo.city billing_company Display name Billing company Description The company name of the billing customer Field type dimension Data type string.text.value billing_country_id Display name Billing country ID Description The unique identifier for the country of the billing address Field type dimension Data type string.geo.country.twolettercode billing_email Display name Billing email Description The email address of the billing customer Field type dimension Data type string.text.email billing_fax Display name Billing fax Description The fax number of the billing customer Field type dimension Data type string.text.value billing_first_name Display name Billing first name Description The first name of the billing customer Field type dimension Data type string.text.value billing_last_name Display name Billing last name Description The last name of the billing customer Field type dimension Data type string.text.value billing_middle_name Display name Billing middle name Description The middle name of the billing customer Field type dimension Data type string.text.value billing_postal_code Display name Billing postal code Description The postal code of the billing address Field type dimension Data type string.text.value billing_region Display name Billing region Description The region or state of the billing address Field type dimension Data type string.geo.region billing_region_code Display name Billing region code Description The code representing the region of the billing address Field type dimension Data type string.geo.region billing_region_id Display name Billing region ID Description The unique identifier for the region of the billing address Field type dimension Data type string.geo.region billing_street Display name Billing street Description The street address of the billing customer Field type dimension Data type string.geo.street billing_telephone Display name Billing telephone Description The telephone number of the billing customer Field type dimension Data type string.text.phone customer_dob Display name Customer date of birth Description The date of birth of the customer Field type dimension Data type string.time.date customer_email Display name Customer email Description The email address of the customer Field type dimension Data type string.text.email customer_first_name Display name Customer first name Description The first name of the customer Field type dimension Data type string.text.value customer_gender Display name Customer gender Description The gender of the customer Field type dimension Data type string.person.gender customer_group_id Display name Customer group ID Description The unique identifier of the customer group Field type dimension Data type string.text.value customer_id Display name Customer ID Description The unique identifier of the customer Field type dimension Data type string.text.value customer_is_guest Display name Customer is guest Description Indicates whether the customer is a guest or a registered customer Field type dimension Data type string.text.value customer_last_name Display name Customer last name Description The last name of the customer Field type dimension Data type string.text.value customer_middle_name Display name Customer middle name Description The middle name of the customer Field type dimension Data type string.text.value customer_prefix Display name Customer prefix Description The prefix for the customer's name (e.g., Mr., Ms.) Field type dimension Data type string.text.value dataSourceName Display name Data source Description The name of the source for this data, as listed on supermetrics.com/docs Field type dimension Data type string.text.value date Display name Date Field type dimension Data type string.time.date order_created_date Display name Order created date Description The date when the order was created Field type dimension Data type string.time.date order_created_datetime Display name Order created datetime Description The date and time when the order was created Field type dimension Data type string.time.datetime order_currency Display name Order currency Description The currency used for the order transaction Field type dimension Data type string.currency.code order_discount Display name Order discount Description The total discount amount applied to the order Field type metric Data type float.currency.value order_grand_total Display name Order grand total Description The grand total amount for the order after all adjustments Field type metric Data type float.currency.value order_increment_id Display name Order increment ID Description The incrementing identifier for each order Field type dimension Data type string.text.value order_quantity Display name Order quantity Description The total quantity of items in the order Field type metric Data type int.number.value order_shipping_and_handling Display name Order shipping & handling Description The total shipping and handling charges for the order Field type metric Data type float.currency.value order_status Display name Order status Description The current status of the order (e.g., pending, processing, completed) Field type dimension Data type string.text.value order_subtotal Display name Order subtotal Description The subtotal amount for the order before tax and discounts Field type metric Data type float.currency.value order_tax Display name Order tax Description The total tax amount applied to the order Field type metric Data type float.currency.value order_total_due Display name Order total due Description The total amount due for the order Field type metric Data type float.currency.value order_total_paid Display name Order total paid Description The total amount paid for the order Field type metric Data type float.currency.value order_total_refunded Display name Order total refunded Description The total amount refunded for the order Field type metric Data type float.currency.value order_updated_date Display name Order updated date Description The date when the order was last updated Field type dimension Data type string.time.date order_updated_datetime Display name Order updated datetime Description The date and time when the order was last updated Field type dimension Data type string.time.datetime orders Display name Orders Description The total number of orders placed Field type metric Data type int.number.value shipping_address_type Display name Shipping address type Description The type of address associated with the shipping customer Field type dimension Data type string.text.value shipping_city Display name Shipping city Description The city of the shipping address Field type dimension Data type string.geo.city shipping_company Display name Shipping company Description The company name of the shipping customer Field type dimension Data type string.text.value shipping_country_id Display name Shipping country ID Description The unique identifier for the country of the shipping address Field type dimension Data type string.geo.country.twolettercode shipping_email Display name Shipping email Description The email address of the shipping customer Field type dimension Data type string.text.email shipping_fax Display name Shipping fax Description The fax number of the shipping customer Field type dimension Data type string.text.value shipping_first_name Display name Shipping first name Description The first name of the shipping customer Field type dimension Data type string.text.value shipping_last_name Display name Shipping last name Description The last name of the shipping customer Field type dimension Data type string.text.value shipping_middle_name Display name Shipping middle name Description The middle name of the shipping customer Field type dimension Data type string.text.value shipping_postal_code Display name Shipping postal code Description The postal code of the shipping address Field type dimension Data type string.text.value shipping_region Display name Shipping region Description The region or state of the shipping address Field type dimension Data type string.geo.region shipping_region_code Display name Shipping region code Description The code representing the region of the shipping address Field type dimension Data type string.geo.region shipping_region_id Display name Shipping region ID Description The unique identifier for the region of the shipping address Field type dimension Data type string.geo.region shipping_street Display name Shipping street Description The street address of the shipping customer Field type dimension Data type string.geo.street shipping_telephone Display name Shipping telephone Description The telephone number of the shipping customer Field type dimension Data type string.text.phone store_domain Display name Store domain Description The domain associated with the store from which the order was placed Field type dimension Data type string.text.url store_id Display name Store ID Description A unique identifier for the store within the Magento system Field type dimension Data type string.text.value store_name Display name Store name Description The name of the store from which the order was placed Field type dimension Data type string.text.valueTable: ORDER_ITEM billing_address_type Display name Billing address type Description The type of address associated with the billing customer Field type dimension Data type string.text.value billing_city Display name Billing city Description The city of the billing address Field type dimension Data type string.geo.city billing_company Display name Billing company Description The company name of the billing customer Field type dimension Data type string.text.value billing_country_id Display name Billing country ID Description The unique identifier for the country of the billing address Field type dimension Data type string.geo.country.twolettercode billing_email Display name Billing email Description The email address of the billing customer Field type dimension Data type string.text.email billing_fax Display name Billing fax Description The fax number of the billing customer Field type dimension Data type string.text.value billing_first_name Display name Billing first name Description The first name of the billing customer Field type dimension Data type string.text.value billing_last_name Display name Billing last name Description The last name of the billing customer Field type dimension Data type string.text.value billing_middle_name Display name Billing middle name Description The middle name of the billing customer Field type dimension Data type string.text.value billing_postal_code Display name Billing postal code Description The postal code of the billing address Field type dimension Data type string.text.value billing_region Display name Billing region Description The region or state of the billing address Field type dimension Data type string.geo.region billing_region_code Display name Billing region code Description The code representing the region of the billing address Field type dimension Data type string.geo.region billing_region_id Display name Billing region ID Description The unique identifier for the region of the billing address Field type dimension Data type string.geo.region billing_street Display name Billing street Description The street address of the billing customer Field type dimension Data type string.geo.street billing_telephone Display name Billing telephone Description The telephone number of the billing customer Field type dimension Data type string.text.phone customer_dob Display name Customer date of birth Description The date of birth of the customer Field type dimension Data type string.time.date customer_email Display name Customer email Description The email address of the customer Field type dimension Data type string.text.email customer_first_name Display name Customer first name Description The first name of the customer Field type dimension Data type string.text.value customer_gender Display name Customer gender Description The gender of the customer Field type dimension Data type string.person.gender customer_group_id Display name Customer group ID Description The unique identifier of the customer group Field type dimension Data type string.text.value customer_id Display name Customer ID Description The unique identifier of the customer Field type dimension Data type string.text.value customer_is_guest Display name Customer is guest Description Indicates whether the customer is a guest or a registered customer Field type dimension Data type string.text.value customer_last_name Display name Customer last name Description The last name of the customer Field type dimension Data type string.text.value customer_middle_name Display name Customer middle name Description The middle name of the customer Field type dimension Data type string.text.value customer_prefix Display name Customer prefix Description The prefix for the customer's name (e.g., Mr., Ms.) Field type dimension Data type string.text.value dataSourceName Display name Data source Description The name of the source for this data, as listed on supermetrics.com/docs Field type dimension Data type string.text.value date Display name Date Field type dimension Data type string.time.date item_created_date Display name Item created date Description The date when the item was created Field type dimension Data type string.time.date item_created_datetime Display name Item created datetime Description The date and time when the item was created Field type dimension Data type string.time.datetime item_discount_amount Display name Item discount amount Description The discount amount applied to the item Field type metric Data type float.currency.value item_id Display name Item ID Description A unique identifier for each item in the order Field type dimension Data type string.text.value item_order_id Display name Item order ID Description The unique identifier of the order associated with the ordered item Field type dimension Data type string.text.value item_original_price Display name Item original price Description The original price of the item before any discounts or adjustments Field type metric Data type float.currency.value item_price Display name Item price Description The final price of the item after any discounts or adjustments Field type metric Data type float.currency.value item_quantity_canceled Display name Item quantity canceled Description The quantity of the item that has been canceled Field type metric Data type int.number.value item_quantity_invoiced Display name Item quantity invoiced Description The quantity of the item that has been invoiced Field type metric Data type int.number.value item_quantity_ordered Display name Item quantity ordered Description The total quantity of the item ordered Field type metric Data type int.number.value item_quantity_refunded Display name Item quantity refunded Description The quantity of the item that has been refunded Field type metric Data type int.number.value item_quantity_returned Display name Item quantity returned Description The quantity of the item that has been returned Field type metric Data type int.number.value item_quantity_shipped Display name Item quantity shipped Description The quantity of the item that has been shipped Field type metric Data type int.number.value item_refund_amount Display name Item refund amount Description The amount refunded for the item Field type metric Data type float.currency.value item_sku Display name Item SKU Description The Stock Keeping Unit (SKU) associated with the product in the item Field type dimension Data type string.text.value item_subtotal Display name Item subtotal Description The subtotal amount for the item before tax and discounts Field type metric Data type float.currency.value item_tax_amount Display name Item tax amount Description The tax amount applied to the item Field type metric Data type float.currency.value item_tax_percent Display name Item tax percent Description The tax percentage rate applied to the item Field type metric Data type float.number.percentage item_total Display name Item total Description The total amount for the item after all adjustments Field type metric Data type float.currency.value item_updated_date Display name Item updated date Description The date when the item was last updated Field type dimension Data type string.time.date item_updated_datetime Display name Item updated datetime Description The date and time when the item was last updated Field type dimension Data type string.time.datetime order_created_date Display name Order created date Description The date when the order was created Field type dimension Data type string.time.date order_created_datetime Display name Order created datetime Description The date and time when the order was created Field type dimension Data type string.time.datetime order_currency Display name Order currency Description The currency used for the order transaction Field type dimension Data type string.currency.code order_increment_id Display name Order increment ID Description The incrementing identifier for each order Field type dimension Data type string.text.value order_status Display name Order status Description The current status of the order (e.g., pending, processing, completed) Field type dimension Data type string.text.value order_updated_date Display name Order updated date Description The date when the order was last updated Field type dimension Data type string.time.date order_updated_datetime Display name Order updated datetime Description The date and time when the order was last updated Field type dimension Data type string.time.datetime product_id Display name Product ID Description A unique identifier for each product Field type dimension Data type string.text.value product_name Display name Product name Description The name of the product Field type dimension Data type string.text.value product_type Display name Product type Description The type or category of the product (e.g., simple, configurable, virtual) Field type dimension Data type string.text.value shipping_address_type Display name Shipping address type Description The type of address associated with the shipping customer Field type dimension Data type string.text.value shipping_city Display name Shipping city Description The city of the shipping address Field type dimension Data type string.geo.city shipping_company Display name Shipping company Description The company name of the shipping customer Field type dimension Data type string.text.value shipping_country_id Display name Shipping country ID Description The unique identifier for the country of the shipping address Field type dimension Data type string.geo.country.twolettercode shipping_email Display name Shipping email Description The email address of the shipping customer Field type dimension Data type string.text.email shipping_fax Display name Shipping fax Description The fax number of the shipping customer Field type dimension Data type string.text.value shipping_first_name Display name Shipping first name Description The first name of the shipping customer Field type dimension Data type string.text.value shipping_last_name Display name Shipping last name Description The last name of the shipping customer Field type dimension Data type string.text.value shipping_middle_name Display name Shipping middle name Description The middle name of the shipping customer Field type dimension Data type string.text.value shipping_postal_code Display name Shipping postal code Description The postal code of the shipping address Field type dimension Data type string.text.value shipping_region Display name Shipping region Description The region or state of the shipping address Field type dimension Data type string.geo.region shipping_region_code Display name Shipping region code Description The code representing the region of the shipping address Field type dimension Data type string.geo.region shipping_region_id Display name Shipping region ID Description The unique identifier for the region of the shipping address Field type dimension Data type string.geo.region shipping_street Display name Shipping street Description The street address of the shipping customer Field type dimension Data type string.geo.street shipping_telephone Display name Shipping telephone Description The telephone number of the shipping customer Field type dimension Data type string.text.phone store_domain Display name Store domain Description The domain associated with the store from which the order was placed Field type dimension Data type string.text.url store_id Display name Store ID Description A unique identifier for the store within the Magento system Field type dimension Data type string.text.value store_name Display name Store name Description The name of the store from which the order was placed Field type dimension Data type string.text.valueTable: CUSTOMER billing_city Display name Billing city Description The city of the billing address Field type dimension Data type string.geo.city billing_company Display name Billing company Description The company name of the billing customer Field type dimension Data type string.text.value billing_country_id Display name Billing country ID Description The unique identifier for the country of the billing address Field type dimension Data type string.geo.country.twolettercode billing_fax Display name Billing fax Description The fax number of the billing customer Field type dimension Data type string.text.value billing_first_name Display name Billing first name Description The first name of the billing customer Field type dimension Data type string.text.value billing_last_name Display name Billing last name Description The last name of the billing customer Field type dimension Data type string.text.value billing_middle_name Display name Billing middle name Description The middle name of the billing customer Field type dimension Data type string.text.value billing_postal_code Display name Billing postal code Description The postal code of the billing address Field type dimension Data type string.text.value billing_region Display name Billing region Description The region or state of the billing address Field type dimension Data type string.geo.region billing_region_code Display name Billing region code Description The code representing the region of the billing address Field type dimension Data type string.geo.region billing_region_id Display name Billing region ID Description The unique identifier for the region of the billing address Field type dimension Data type string.geo.region billing_street Display name Billing street Description The street address of the billing customer Field type dimension Data type string.geo.street billing_telephone Display name Billing telephone Description The telephone number of the billing customer Field type dimension Data type string.text.phone customer_created_date Display name Customer created date Description The date the customer was created Field type dimension Data type string.time.date customer_created_datetime Display name Customer created datetime Description The date and time the customer was created Field type dimension Data type string.time.datetime customer_created_in Display name Customer created in Description The store in which the customer was created Field type dimension Data type string.text.value customer_dob Display name Customer date of birth Description The date of birth of the customer Field type dimension Data type string.time.date customer_email Display name Customer email Description The email address of the customer Field type dimension Data type string.text.email customer_first_name Display name Customer first name Description The first name of the customer Field type dimension Data type string.text.value customer_gender Display name Customer gender Description The gender of the customer Field type dimension Data type string.person.gender customer_group_id Display name Customer group ID Description The unique identifier of the customer group Field type dimension Data type string.text.value customer_id Display name Customer ID Description The unique identifier of the customer Field type dimension Data type string.text.value customer_last_name Display name Customer last name Description The last name of the customer Field type dimension Data type string.text.value customer_middle_name Display name Customer middle name Description The middle name of the customer Field type dimension Data type string.text.value customer_name_suffix Display name Customer name suffix Description The suffix for the customer's name (e.g., Jr., Sr., III) Field type dimension Data type string.text.value customer_prefix Display name Customer prefix Description The prefix for the customer's name (e.g., Mr., Ms.) Field type dimension Data type string.text.value customer_tax_vat_number Display name Customer tax/VAT number Description The tax or VAT number of the customer Field type dimension Data type string.text.value customer_updated_date Display name Customer updated date Description The date the customer was last updated Field type dimension Data type string.time.date customer_updated_datetime Display name Customer updated datetime Description The date and time the customer was last updated Field type dimension Data type string.time.datetime customers Display name Customers Description The number of customers Field type metric Data type int.number.value dataSourceName Display name Data source Description The name of the source for this data, as listed on supermetrics.com/docs Field type dimension Data type string.text.value date Display name Date Field type dimension Data type string.time.date shipping_city Display name Shipping city Description The city of the shipping address Field type dimension Data type string.geo.city shipping_company Display name Shipping company Description The company name of the shipping customer Field type dimension Data type string.text.value shipping_country_id Display name Shipping country ID Description The unique identifier for the country of the shipping address Field type dimension Data type string.geo.country.twolettercode shipping_fax Display name Shipping fax Description The fax number of the shipping customer Field type dimension Data type string.text.value shipping_first_name Display name Shipping first name Description The first name of the shipping customer Field type dimension Data type string.text.value shipping_last_name Display name Shipping last name Description The last name of the shipping customer Field type dimension Data type string.text.value shipping_middle_name Display name Shipping middle name Description The middle name of the shipping customer Field type dimension Data type string.text.value shipping_postal_code Display name Shipping postal code Description The postal code of the shipping address Field type dimension Data type string.text.value shipping_region Display name Shipping region Description The region or state of the shipping address Field type dimension Data type string.geo.region shipping_region_code Display name Shipping region code Description The code representing the region of the shipping address Field type dimension Data type string.geo.region shipping_region_id Display name Shipping region ID Description The unique identifier for the region of the shipping address Field type dimension Data type string.geo.region shipping_street Display name Shipping street Description The street address of the shipping customer Field type dimension Data type string.geo.street shipping_telephone Display name Shipping telephone Description The telephone number of the shipping customer Field type dimension Data type string.text.phone store_domain Display name Store domain Description The domain associated with the store from which the order was placed Field type dimension Data type string.text.url store_id Display name Store ID Description A unique identifier for the store within the Magento system Field type dimension Data type string.text.value store_name Display name Store name Description The name of the store from which the order was placed Field type dimension Data type string.text.value