Search fields×Table: ORDER billing_city Display name Billing city Description City of the billing address Field type dimension Data type string.geo.city billing_company Display name Billing company Description Company name of the billing address Field type dimension Data type string.text.value billing_country Display name Billing country Description Country of the billing address Field type dimension Data type string.geo.country billing_country_iso2 Display name Billing country (ISO2) Description ISO 2-letter code for the billing country Field type dimension Data type string.geo.country.twolettercode billing_email Display name Billing email Description Email address of the billing address Field type dimension Data type string.text.email billing_first_name Display name Billing first name Description First name of the billing address Field type dimension Data type string.text.value billing_last_name Display name Billing last name Description Last name of the billing address Field type dimension Data type string.text.value billing_phone Display name Billing phone Description Phone number of the billing address Field type dimension Data type string.text.phone billing_state Display name Billing state Description State/province of the billing address Field type dimension Data type string.geo.region billing_street_1 Display name Billing street 1 Description Street address of the billing address Field type dimension Data type string.geo.street billing_street_2 Display name Billing street 2 Description Additional street address of the billing address Field type dimension Data type string.geo.street billing_zip Display name Billing zip Description Zip/postal code of the billing address Field type dimension Data type string.geo.zip channel_id Display name Channel ID Description Shows where the order originated Field type dimension Data type string.text.value coupon Display name Coupon Description The coupon amount that the shopper has redeemed on this individual order Field type metric Data type float.currency.value created_date Display name Created date Description Date the order was created Field type dimension Data type string.time.date created_datetime Display name Created datetime Description Date and time the order was created Field type dimension Data type string.time.datetime currency_code Display name Currency code Description The currency code associated with the price record being acted upon Field type dimension Data type string.currency.code currency_id Display name Currency ID Description The active currency ID Field type dimension Data type string.text.value custom_status Display name Custom status Description Custom status of the order Field type dimension Data type string.text.value customer_id Display name Customer ID Description Unique identifier for the customer Field type dimension Data type string.text.value customer_message Display name Customer message Description Message that the customer entered 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 discount_amount Display name Discount Description Amount of discount for this transaction Field type metric Data type float.currency.value external_id Display name External ID Description The order ID in another system, such as the Amazon order ID if this is an Amazon order Field type dimension Data type string.text.value geoip_country Display name GeoIP country Description The full name of the country where the customer made the purchase, based on the IP Field type dimension Data type string.geo.country geoip_country_iso2 Display name GeoIP country (ISO2) Description The country where the customer made the purchase, in ISO2 format, based on the IP Field type dimension Data type string.geo.country.twolettercode gift_certificate Display name Gift certificate Description The gift certificate that the shopper has redeemed on this individual order Field type metric Data type float.currency.value handling Display name Handling Description The value of the handling cost, including tax Field type metric Data type float.currency.value ip_address Display name IP address Description IPv4 Address of the customer, if known Field type dimension Data type string.text.value ip_address_v6 Display name IP address v6 Description IPv6 Address of the customer, if known Field type dimension Data type string.text.value items_shipped Display name Items shipped Description The number of items that have been shipped Field type metric Data type int.number.value items_total Display name Items total Description The total number of items in the order Field type metric Data type int.number.value modified_date Display name Modified date Description Date the order was last modified Field type dimension Data type string.time.date modified_datetime Display name Modified datetime Description Date and time the order was last modified Field type dimension Data type string.time.datetime order_id Display name Order ID Description Unique identifier for the order Field type dimension Data type string.text.value order_is_digital Display name Order is digital Description Whether this is an order for digital products Field type dimension Data type bool order_source Display name Order source Description Reflects the origin of the order. It can affect the order’s icon and source as defined in the control panel listing Field type dimension Data type string.text.value payment_method Display name Payment method Description The payment method for this order Field type dimension Data type string.text.value payment_provider_id Display name Payment provider ID Description The external transaction ID/payment ID within this order’s payment provider Field type dimension Data type string.text.value payment_status Display name Payment status Description Status of the payment Field type dimension Data type string.text.value refunded_amount Display name Refunded amount Description The amount refunded from this transaction Field type metric Data type float.currency.value shipped_date Display name Shipped date Description Date the order was shipped Field type dimension Data type string.time.date shipped_datetime Display name Shipped datetime Description Date and time the order was shipped Field type dimension Data type string.time.datetime shipping Display name Shipping Description The value of shipping cost, including tax Field type metric Data type float.currency.value status Display name Status Description Current status of the order Field type dimension Data type string.text.value status_id Display name Status ID Description The status ID of the order Field type dimension Data type string.text.value store_credit Display name Store credit Description The store credit that the shopper has redeemed on this individual order Field type metric Data type float.currency.value store_hash Display name Store hash Description The name of the store Field type dimension Data type string.text.value subtotal Display name Subtotal Description The value of subtotal including tax Field type metric Data type float.currency.value total Display name Total Description Total value of the order including tax Field type metric Data type float.currency.value wrapping Display name Wrapping Description The value of the wrapping cost, including tax Field type metric Data type float.currency.valueTable: ORDER_ITEM billing_city Display name Billing city Description City of the billing address Field type dimension Data type string.geo.city billing_company Display name Billing company Description Company name of the billing address Field type dimension Data type string.text.value billing_country Display name Billing country Description Country of the billing address Field type dimension Data type string.geo.country billing_country_iso2 Display name Billing country (ISO2) Description ISO 2-letter code for the billing country Field type dimension Data type string.geo.country.twolettercode billing_email Display name Billing email Description Email address of the billing address Field type dimension Data type string.text.email billing_first_name Display name Billing first name Description First name of the billing address Field type dimension Data type string.text.value billing_last_name Display name Billing last name Description Last name of the billing address Field type dimension Data type string.text.value billing_phone Display name Billing phone Description Phone number of the billing address Field type dimension Data type string.text.phone billing_state Display name Billing state Description State/province of the billing address Field type dimension Data type string.geo.region billing_street_1 Display name Billing street 1 Description Street address of the billing address Field type dimension Data type string.geo.street billing_street_2 Display name Billing street 2 Description Additional street address of the billing address Field type dimension Data type string.geo.street billing_zip Display name Billing zip Description Zip/postal code of the billing address Field type dimension Data type string.geo.zip brand Display name Brand Description The products brand Field type dimension Data type string.text.value channel_id Display name Channel ID Description Shows where the order originated Field type dimension Data type string.text.value created_date Display name Created date Description Date the order was created Field type dimension Data type string.time.date created_datetime Display name Created datetime Description Date and time the order was created Field type dimension Data type string.time.datetime currency_code Display name Currency code Description The currency code associated with the price record being acted upon Field type dimension Data type string.currency.code currency_id Display name Currency ID Description The active currency ID Field type dimension Data type string.text.value custom_status Display name Custom status Description Custom status of the order Field type dimension Data type string.text.value customer_id Display name Customer ID Description Unique identifier for the customer Field type dimension Data type string.text.value customer_message Display name Customer message Description Message that the customer entered 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 external_id Display name External ID Description The order ID in another system, such as the Amazon order ID if this is an Amazon order Field type dimension Data type string.text.value geoip_country Display name GeoIP country Description The full name of the country where the customer made the purchase, based on the IP Field type dimension Data type string.geo.country geoip_country_iso2 Display name GeoIP country (ISO2) Description The country where the customer made the purchase, in ISO2 format, based on the IP Field type dimension Data type string.geo.country.twolettercode ip_address Display name IP address Description IPv4 Address of the customer, if known Field type dimension Data type string.text.value ip_address_v6 Display name IP address v6 Description IPv6 Address of the customer, if known Field type dimension Data type string.text.value modified_date Display name Modified date Description Date the order was last modified Field type dimension Data type string.time.date modified_datetime Display name Modified datetime Description Date and time the order was last modified Field type dimension Data type string.time.datetime order_id Display name Order ID Description Unique identifier for the order Field type dimension Data type string.text.value order_is_digital Display name Order is digital Description Whether this is an order for digital products Field type dimension Data type bool order_source Display name Order source Description Reflects the origin of the order. It can affect the order’s icon and source as defined in the control panel listing Field type dimension Data type string.text.value payment_method Display name Payment method Description The payment method for this order Field type dimension Data type string.text.value payment_provider_id Display name Payment provider ID Description The external transaction ID/payment ID within this order’s payment provider Field type dimension Data type string.text.value payment_status Display name Payment status Description Status of the payment Field type dimension Data type string.text.value price_base Display name Price (base) Description The product’s cost price Field type metric Data type float.currency.value price_inc_tax Display name Price (inc tax) Description The product’s cost price including tax Field type metric Data type float.currency.value product_id Display name Product ID Description Numeric ID of the product Field type dimension Data type string.text.value product_name Display name Product name Description Name of the product Field type dimension Data type string.text.value quantity Display name Quantity Description Quantity of the product ordered Field type metric Data type int.number.value quantity_refunded Display name Quantity refunded Description The total quantity of product refunded from this transaction Field type metric Data type int.number.value shipped_date Display name Shipped date Description Date the order was shipped Field type dimension Data type string.time.date shipped_datetime Display name Shipped datetime Description Date and time the order was shipped Field type dimension Data type string.time.datetime sku Display name SKU Description User-defined product code/stock keeping unit (SKU) Field type dimension Data type string.text.value status Display name Status Description Current status of the order Field type dimension Data type string.text.value status_id Display name Status ID Description The status ID of the order Field type dimension Data type string.text.value store_hash Display name Store hash Description The name of the store Field type dimension Data type string.text.value total_base Display name Total (base) Description Total base price Field type metric Data type float.currency.value total_inc_tax Display name Total (inc tax) Description Total base price including tax Field type metric Data type float.currency.value type Display name Type Description Type of product Field type dimension Data type string.text.value upc Display name UPC Description Universal product code. Can be written to for custom products and catalog products Field type dimension Data type string.text.value