Shopify Fields List

Field Name	Label	Type	Description	Group
Customer47 fields
`average_orders_per_customer`	Average Orders per Customer	Metric	Average number of orders per customer.	Customer
`cogs_minus_returns`	COGS (Minus Refunds)	Metric	COGS (Minus Refunds) metric from Shopify. This field provides data for reporting and analysis in your marketing dashboards.	Customer
`cost_per_order`	Cost Per Order	Metric	The monetary amount spent on per order. Reported in the account’s configured currency.	Customer
`customer_accepts_marketing`	Customer Accepts Marketing	Metric	Whether the customer agreed to receive marketing materials.	Customer
`customer_creation_date`	Customer Creation Date	Dimension	The date when the customer was added to the store.	Customer
`customer_display_name`	Customer Display Name	Dimension	The full name of the customer, based on the values for first_name and last_name. If the first_name and last_name are not available, then this falls back to the customer’s email address, and if that is not available, the customer’s phone number.	Customer
`customer_email`	Customer Email	Metric	Customer Email metric from Shopify. This field provides data for reporting and analysis in your marketing dashboards.	Customer
`customer_first_name`	Customer First Name	Dimension	The display name of the customer first as configured in Shopify.	Customer
`customer_id`	Customer ID	Dimension	Globally unique identifier for the customer.	Customer
`customer_image`	Customer Image	Metric	The image associated with the customer.	Customer
`customer_image_url`	Customer Image URL	Dimension	The image associated with the customer.	Customer
`customer_last_name`	Customer Last Name	Dimension	The display name of the customer last as configured in Shopify.	Customer
`customer_last_order_date`	Customer Last Order Date	Dimension	The customer’s last order creation date.	Customer
`customer_orders_count`	Customer Orders Count	Metric	The number of orders that the customer has made at the store in their lifetime.	Customer
`customer_phone`	Customer Phone	Metric	Customer Phone metric from Shopify. This field provides data for reporting and analysis in your marketing dashboards.	Customer
`customer_state`	Customer State	Metric	The state of the customer’s account with the shop.	Customer
`customer_tags`	Customer Tags	Metric	A comma separated list of tags that have been added to the customer.	Customer
`customer_tax_exempt`	Customer Tax Exempt	Metric	Whether the customer is exempt from being charged taxes on their orders.	Customer
`customer_total_spent`	Customer Total Spent	Metric	The total amount that the customer has spent on orders in their lifetime.	Customer
`customer_type`	Customer Type	Dimension	Whether the customer is placing their first order (First-time) or is a returning customer (Returning).	Customer
`customer_verified_email`	Customer Verified Email	Metric	Whether the customer has verified their email address. Defaults to true if the customer is created through the Shopify admin or API.	Customer
`gross_profit`	Gross Profit	Metric	Gross Profit metric from Shopify. This field provides data for reporting and analysis in your marketing dashboards.	Customer
`new_customers`	New Customers	Metric	Count of customers placing their first order (First-time).	Customer
`new_customers_aov`	New Customers AOV	Metric	Average order value of customers placing their first order (First-time).	Customer
`new_customers_cost_of_goods_sold`	New Customers COGS	Metric	Cost of goods sold of customers placing their first order (First-time).	Customer
`new_customers_gross_sales`	New Customers Gross Sales	Metric	Gross sales of customers placing their first order (First-time).	Customer
`new_customers_gross_sales_percent`	New Customers Gross Sales %	Metric	Gross sales of customers placing their first order (First-time) over total gross sales.	Customer
`new_customers_net_sales`	New Customers Net Sales	Metric	Net sales of customers placing their first order (First-time).	Customer
`new_customers_net_sales_percent`	New Customers Net Sales %	Metric	Net sales of customers placing their first order (First-time) over total gross sales.	Customer
`new_customers_orders`	New Customer Orders	Metric	Count of orders from customers placing their first order (First-time).	Customer
`new_customers_ratio`	New Customers %	Metric	Ratio of new customers to total customers.	Customer
`new_customers_total_sales`	New Customers Total Sales	Metric	Total sales of customers placing their first order (First-time).	Customer
`new_customers_total_sales_percent`	New Customers Total Sales %	Metric	Total sales of customers placing their first order (First-time) over total sales.	Customer
`purchase_frequency`	Purchase Frequency	Metric	Purchase-related metric tracking completed transactions. Key indicator of advertising effectiveness.	Customer
`returning_customers`	Repeat Customers	Metric	Repeat Customers metric from Shopify. This field provides data for reporting and analysis in your marketing dashboards.	Customer
`returning_customers_aov`	Repeat Customers AOV	Metric	Average order value of returning customers.	Customer
`returning_customers_cost_of_goods_sold`	Repeat Customers COGS	Metric	Cost of goods sold of returning customers.	Customer
`returning_customers_gross_profit`	Repeat Customers Gross Profit	Metric	Gross profit of returning customers.	Customer
`returning_customers_gross_sales`	Repeat Customers Gross Sales	Metric	Gross sales of returning customers.	Customer
`returning_customers_gross_sales_percent`	Repeat Customers Gross Sales %	Metric	Gross sales of returning customers over total gross sales.	Customer
`returning_customers_net_sales`	Repeat Customers Net Sales	Metric	Net sales of returning customers.	Customer
`returning_customers_net_sales_percent`	Repeat Customers Net Sales %	Metric	Net sales of returning customers over total net sales.	Customer
`returning_customers_orders`	Repeat Customer Orders	Metric	Count of orders from returning customers.	Customer
`returning_customers_ratio`	Repeat Customers %	Metric	Ratio of returning customers to total customers.	Customer
`returning_customers_total_sales`	Repeat Customers Total Sales	Metric	Total sales of returning customers.	Customer
`returning_customers_total_sales_percent`	Repeat Customers Total Sales %	Metric	Total sales of returning customers over total sales.	Customer
`zero_dollar_orders`	0$ Orders	Metric	Count of orders with a zero dollar value.	Customer
Line Item1 fields
`line_item_id`	Line Item ID	Dimension	Unique identifier of the line item	Line Item
Orders57 fields
`average_order_value`	Average order value	Metric	The average value of a staff’s sales.	Orders
`customers`	Total Customers	Metric	The total count of customers recorded during the reporting period.	Orders
`discount_code`	Discount Code	Metric	Discount code provided by the customer.	Orders
`financial_status`	Financial Status	Dimension	Financial status of the order that can be shown to the merchant. This field does not capture all the possible details of an order’s financial state and should only be used for display summary purposes.	Orders
`fulfillment_status`	Fulfillment Status	Dimension	Fulfillment status for the order that can be shown to the merchant. This field does not capture all the possible details of an order’s fulfillment state. It should only be used for display summary purposes.	Orders
`landing_page_url`	Landing Page URL	Dimension	URL of the first page the customer landed on for the session before an order is made.	Orders
`order_canceled_date`	Order Canceled Date	Dimension	The date when the order was canceled in format. This fields returns null if the order wasn’t canceled.	Orders
`order_channel`	Channel	Metric	Name of the channel that this sub channel belongs to.	Orders
`order_channel_app_name`	Channel app name	Dimension	The display name of the channel app as configured in Shopify.	Orders
`order_closed_date`	Order Closed Date	Dimension	Date time when the order closed. If the order is not closed, then this field returns null.	Orders
`order_creation_date`	Order Creation Date	Dimension	The date the order was created.	Orders
`order_current_total_weight`	Order Current Total Weight	Metric	The total weight of the order after returns, in grams.	Orders
`order_id`	Order ID	Dimension	Globally unique identifier of an order	Orders
`order_is_closed`	Order Is Closed	Metric	Order-related is closed. Represents completed purchase transactions.	Orders
`order_is_confirmed`	Order Is Confirmed	Metric	Whether inventory has been reserved for the order	Orders
`order_is_edited`	Order Is Edited	Metric	Whether the order has had any edits applied.	Orders
`order_is_fully_paid`	Order is Fully Paid	Dimension	Whether the order has been paid in full.	Orders
`order_is_refundable`	Order is Refundable	Metric	Whether the order can be refunded.	Orders
`order_is_test`	Is Test	Metric	Whether the order is a test order.	Orders
`order_name`	Order Name	Dimension	Unique identifier for the order that appears on the order. For example, #1000 or _Store1001. This value is not unique across multiple stores.	Orders
`order_note`	Order Note	Metric	Contents of the note associated with the order.	Orders
`order_payment_gateway_names`	Order Payment Gateway Names	Dimension	A list of the names of all payment gateways used for the order.	Orders
`order_processed_date`	Order Processed Date	Dimension	The date when the order was processed.	Orders
`order_requires_shipping`	Order Requires Shipping	Metric	Whether any line item on the order requires physical shipping.	Orders
`order_tags`	Order Tags	Metric	A comma separated list of tags associated with the order.	Orders
`order_taxes_estimated`	Order Taxes Estimated	Metric	Whether taxes on the order are estimated. Many factors can change between the time a customer places an order and the time the order is shipped, which could affect the calculation of taxes. This field returns false when taxes on the order are finalized and aren’t subject to any changes.	Orders
`order_total_weight`	Order Total Weight	Metric	The total weight of the order before returns, in grams.	Orders
`order_updated_date`	Order Updated Date	Dimension	The date the order was last updated.	Orders
`orders`	Orders	Metric	Order-related orders. Represents completed purchase transactions.	Orders
`physical_location_name`	Physical Location Name	Dimension	The name of the physical location.	Orders
`referral_code`	Referral Code	Metric	Marketing referral code from the link that the customer clicked to visit the store. Supports the following URL attributes: ref, source, or r. For example, if the URL is myshopifystore.com/products/slide?ref=j2tj1tn2, then this value is j2tj1tn2.	Orders
`referrer_url`	Referrer URL	Dimension	Webpage where the customer clicked a link that sent them to the online store. For example, https://randomblog.com/page1 or android-app://com.google.android.gm.	Orders
`sale_action_type`	Sale action type	Dimension	The type of order action that the sale represents.	Orders
`sale_agreement_reason`	Sale agreement reason	Metric	The reason the agreement was created.	Orders
`sale_line_type`	Sale line type	Dimension	The line type assocated with the sale.	Orders
`sale_quantity`	Number Of Sold Items	Metric	The number of units either ordered or intended to be returned.	Orders
`shipping_address_1`	Shipping Address 1	Metric	The first line of the address. Typically the street address or PO Box number.	Orders
`shipping_address_2`	Shipping Address 2	Metric	The second line of the address. Typically the number of the apartment, suite, or unit.	Orders
`shipping_city`	Shipping City	Metric	The name of the city, district, village, or town.	Orders
`shipping_coordinates`	Shipping Coordinates	Metric	The latitude and longitude coordinates of the customer address.	Orders
`shipping_country`	Shipping Country	Metric	Geographic dimension showing shipping country. Enables location-based performance analysis.	Orders
`shipping_country_code`	Shipping Country Code	Metric	The two-letter code for the country of the address. For example, US.	Orders
`shipping_country_icon`	Shipping Country Icon	Metric	The total count of shipping ry icon recorded during the reporting period.	Orders
`shipping_country_icon_url`	Shipping Country Icon Url	Dimension	The total count of shipping ry icon url recorded during the reporting period.	Orders
`shipping_latitude`	Shipping Latitude	Metric	The latitude coordinate of the customer address.	Orders
`shipping_longitude`	Shipping Longitude	Metric	The longitude coordinate of the customer address.	Orders
`shipping_province`	Shipping Province	Metric	The region of the address, such as the province, state, or district.	Orders
`shipping_province_code`	Shipping Province Code	Metric	The two-letter code for the region. For example, ON.	Orders
`shipping_title`	Shipping title	Dimension	The title of the shipping line.	Orders
`shipping_zip_code`	Shipping ZIP Code	Metric	The zip or postal code of the address.	Orders
`utm_campaign`	UTM Campaign	Dimension	The name of a marketing campaign.	Orders
`utm_content`	UTM Content	Dimension	Identifies specific content in a marketing campaign. Used to differentiate between similar content or links in a marketing campaign to determine which is the most effective.	Orders
`utm_medium`	UTM Medium	Dimension	The medium of a marketing campaign, such as a banner or email newsletter.	Orders
`utm_source`	UTM Source	Dimension	Source from which the customer visited the store, such as a platform (Facebook, Google), email, direct, a website domain, QR code, or unknown.	Orders
`utm_source_description`	UTM Source Description	Dimension	Describes the source explicitly.	Orders
`utm_source_type`	UTM Source Type	Dimension	Describes the source explicitly for first or last session.	Orders
`utm_term`	UTM Term	Dimension	Paid search terms used by a marketing campaign.	Orders
Product25 fields
`product_creation_date`	Product Creation Date	Dimension	The date when the product was created.	Product
`product_description`	Product Description	Dimension	A stripped description of the product, single line with HTML tags removed.	Product
`product_id`	Product ID	Dimension	Globally unique identifier of the product.	Product
`product_image`	Product Image	Metric	The Image object associated to the line item’s variant.	Product
`product_image_url`	Product Image Url	Dimension	The Image object associated to the line item’s variant.	Product
`product_price_range`	Product Price Range	Metric	The price range of the product with prices formatted as decimals.	Product
`product_seo_description`	Product SEO description	Dimension	Product-level seo description. Used for product performance analysis.	Product
`product_seo_title`	Product SEO title	Dimension	Product-level seo title. Used for product performance analysis.	Product
`product_status`	Product Status	Dimension	The product status. This controls visibility across all channels.	Product
`product_tags`	Product Tags	Metric	A comma separated list of tags associated with the product.	Product
`product_title`	Product Title	Dimension	Product-level title. Used for product performance analysis.	Product
`product_type`	Product Type	Dimension	The product type specified by the merchant.	Product
`product_vendor`	Product Vendor	Metric	Name of the vendor who made the variant.	Product
`sku`	SKU	Metric	SKU metric from Shopify. This field provides data for reporting and analysis in your marketing dashboards.	Product
`variant_creation_date`	Variant creation date	Dimension	The date and time when the variant was created.	Product
`variant_id`	Variant ID	Dimension	A globally-unique identifier of the product variant.	Product
`variant_image`	Variant image	Metric	The featured image for the variant.	Product
`variant_image_url`	Variant image URL	Dimension	The featured image for the variant.	Product
`variant_inventory_policy`	Variant inventory policy	Metric	Whether customers are allowed to place an order for the product variant when it’s out of stock.	Product
`variant_inventory_quantity`	Inventory Quantity	Metric	The quantity of inventory in stock.	Product
`variant_price`	Variant Price	Metric	The price of the product variant in the default shop currency.	Product
`variant_tax_code`	Variant Tax Code	Metric	The tax code for the product variant.	Product
`variant_title`	Variant Title	Dimension	Variant Title metric from Shopify. This field provides data for reporting and analysis in your marketing dashboards.	Product
`variant_unit_cost`	Unit Cost	Metric	Unit cost associated with the inventory item. Note: the user must have ‘View product costs’ permission granted in order to access this field once product granular permissions are enabled.	Product
`variant_unit_cost_currency_code`	Unit Cost Currency Code	Metric	Unit cost currency code associated with the inventory item. Note: the user must have ‘View product costs’ permission granted in order to access this field once product granular permissions are enabled.	Product
Sales9 fields
`cost_of_good_solds`	COGS	Metric	Cost of good solds. Equates to product unit cost x quantity.	Sales
`discounts_order`	Discounts	Metric	The sum of all applied discounts on this line item.	Sales
`gross_sales_order`	Gross Sales	Metric	Equates to product price x quantity (before taxes, shipping, discounts, and returns) for a collection of sales. Canceled, pending, and unpaid orders are included. Test and deleted orders are not included.	Sales
`net_sales_order`	Net Sales	Metric	Equates to gross sales – discounts – returns.	Sales
`returns_order`	Returns	Metric	The total amount refunded for each line item.	Sales
`shipping_order`	Shipping	Metric	The total amount charged for shipping the order.	Sales
`tax_order`	Tax	Metric	The total of all taxes applied to the order at the time it was created.	Sales
`total_sales_order`	Total Sales	Metric	Equates to gross sales – discounts – returns + taxes + shipping charges.	Sales
`unknown_fees`	Unknown Fees	Metric	An unknown sale line. Represents new types that may be added in future versions.	Sales
Shop Info2 fields
`shop_id`	Shop ID	Dimension	Unique identifier for the shop in Shopify.	Shop Info
`shop_name`	Shop Name	Dimension	The display name of the shop as configured in Shopify.	Shop Info
Time12 fields
`date`	Date	Dimension	Timestamp or date value for date. Used for time-series analysis and filtering.	Time
`date_time`	Date and Time	Dimension	The date and time of the order.	Time
`day_of_week`	Day of week (Mon – Sun)	Metric	Day of week (Mon – Sun) metric from Shopify. This field provides data for reporting and analysis in your marketing dashboards.	Time
`hour`	Hour	Metric	Hour metric from Shopify. This field provides data for reporting and analysis in your marketing dashboards.	Time
`month`	Month	Metric	Month metric from Shopify. This field provides data for reporting and analysis in your marketing dashboards.	Time
`month_day`	Month Day	Metric	Month Day of the creation of the order.	Time
`quarter`	Quarter	Metric	Quarter metric from Shopify. This field provides data for reporting and analysis in your marketing dashboards.	Time
`week`	Week	Metric	Week metric from Shopify. This field provides data for reporting and analysis in your marketing dashboards.	Time
`year`	Year	Metric	Year metric from Shopify. This field provides data for reporting and analysis in your marketing dashboards.	Time
`year_month`	Month and year	Metric	Month and year metric from Shopify. This field provides data for reporting and analysis in your marketing dashboards.	Time
`year_quarter`	Quarter and year	Metric	Quarter and year metric from Shopify. This field provides data for reporting and analysis in your marketing dashboards.	Time
`year_week`	Week and year	Metric	Week and year metric from Shopify. This field provides data for reporting and analysis in your marketing dashboards.	Time