Shopify fields

Every Shopify field, documented

All 91 metrics and dimensions you can pull into Data Studio and into Claude, ChatGPT or Gemini with the Data Bloo connector, grouped, searchable, and free to use.

Available inData Studio Claude ChatGPT Gemini

36Metrics

55Dimensions

16Categories

91 fields

All fields91Metrics36Dimensions55

Sales & revenue

7 fields

FieldDescriptionType

Total Salestotal_salesGross sales minus discounts and refunds, plus tax and shipping.Metric

Gross Salesgross_salesProduct price multiplied by quantity, before any deductions.Metric

Net Salesnet_salesGross sales minus discounts and refunds.Metric

Net Revenuenet_revenueRevenue recognised after discounts and refunds.Metric

Total Pricetotal_priceThe total amount charged on the order.Metric

Subtotal Pricesubtotal_priceThe order total before tax and shipping.Metric

Total Spenttotal_spentThe lifetime amount a customer has spent with you.Metric

Orders

5 fields

FieldDescriptionType

OrdersordersThe number of orders placed.Metric

Orders Countorders_countThe count of orders in the reporting period.Metric

Average Order Valueaverage_order_valueThe average value of each order.Metric

Average Orders per Customeraverage_orders_per_customerThe average number of orders each customer places.Metric

Total Line Items Quantitytotal_line_items_quantityThe total number of item units across orders.Metric

Discounts, tax & shipping

4 fields

FieldDescriptionType

Total Discountstotal_discountsThe total value of discounts applied.Metric

Total Taxtotal_taxThe total tax collected on orders.Metric

Total Shipping Pricetotal_shipping_priceThe total shipping charges collected.Metric

Refund Amountrefund_amountThe total value refunded to customers.Metric

Order Insights totals

6 fields

FieldDescriptionType

Total Sales (Order Insights)total_sales_order_insightsTotal sales as reported by the Order Insights dataset.Metric

Net Sales (Order Insights)net_sales_order_insightsNet sales as reported by the Order Insights dataset.Metric

Total Discounts (Order Insights)total_discounts_order_insightsDiscounts as reported by the Order Insights dataset.Metric

Total Tax (Order Insights)total_tax_order_insightsTax as reported by the Order Insights dataset.Metric

Shipping (Order Insights)total_shipping_price_order_insightsShipping charges as reported by the Order Insights dataset.Metric

Refund Amount (Order Insights)refund_amount_order_insightsRefunds as reported by the Order Insights dataset.Metric

Line items

4 fields

FieldDescriptionType

Line Item Totalline_item_totalThe total value of the line item.Metric

Line Item Priceline_item_priceThe unit price of the line item.Metric

Line Item Quantityline_item_quantityThe number of units in the line item.Metric

Line Item Discountline_item_discountThe discount applied to the line item.Metric

Customers

5 fields

FieldDescriptionType

New Customer Ordersnew_customers_ordersOrders placed by first-time customers.Metric

New Customer Revenuenew_customers_revenueRevenue from first-time customers.Metric

Repeat Customer Ordersrepeat_customers_ordersOrders placed by returning customers.Metric

Repeat Customer Revenuerepeat_customers_revenueRevenue from returning customers.Metric

Repeat Customer Raterepeat_customers_rateThe share of customers who ordered more than once.Metric

Sessions & funnel

5 fields

FieldDescriptionType

SessionssessionsThe number of visits to your store.Metric

Conversion Rateconversion_rateOrders divided by sessions, as a percentage.Metric

Sessions with Cart Additionssessions_with_cart_additionsSessions where an item was added to the cart.Metric

Sessions That Reached Checkoutsessions_that_reached_checkoutSessions that entered the checkout flow.Metric

Sessions That Completed Checkoutsessions_that_completed_checkoutSessions that finished checkout with an order.Metric

Order details

12 fields

FieldDescriptionType

Order IDorder_idThe unique identifier of the order.Dimension

Order Nameorder_nameThe order number shown to customers.Dimension

Financial Statusfinancial_statusWhether the order is paid, pending, refunded or voided.Dimension

Fulfillment Statusfulfillment_statusWhether the order is fulfilled, partial or unfulfilled.Dimension

Payment Gatewaypayment_gatewayThe payment provider used for the order.Dimension

CurrencycurrencyThe currency the order was placed in.Dimension

Discount Codediscount_codeThe discount code applied to the order.Dimension

NotenoteThe note attached to the order.Dimension

TagstagsTags applied to the order or customer.Dimension

Source Namesource_nameThe channel the order came through, such as web or POS.Dimension

Line Item IDline_item_idThe unique identifier of the line item.Dimension

Refund IDrefund_idThe unique identifier of the refund.Dimension

Order dates

5 fields

FieldDescriptionType

Created Atcreated_atThe date and time the order was created.Dimension

Processed Atprocessed_atThe date and time the order was processed.Dimension

Fulfilled Atfulfilled_atThe date and time the order was fulfilled.Dimension

Cancelled Atcancelled_atThe date and time the order was cancelled.Dimension

Refund Created Atrefund_created_atThe date and time the refund was issued.Dimension

Products

10 fields

FieldDescriptionType

Product IDproduct_idThe unique identifier of the product.Dimension

Product Titleproduct_titleThe name of the product.Dimension

Product Typeproduct_typeThe product category you assigned in Shopify.Dimension

Product Descriptionproduct_descriptionThe description text of the product.Dimension

VendorvendorThe vendor or supplier of the product.Dimension

SKUskuThe stock keeping unit code of the variant.Dimension

Variant IDvariant_idThe unique identifier of the product variant.Dimension

Variant Titlevariant_titleThe name of the variant, such as size or colour.Dimension

Product Imageproduct_imageThe product image, for display in your report.Dimension

Product Image URLproduct_image_urlThe URL of the product image.Dimension

Customer details

8 fields

FieldDescriptionType

Customer IDcustomer_idThe unique identifier of the customer.Dimension

First Namefirst_nameThe first name of the customer.Dimension

Last Namelast_nameThe last name of the customer.Dimension

EmailemailThe email address of the customer.Dimension

PhonephoneThe phone number of the customer.Dimension

Customer Created Atcustomer_created_atThe date the customer account was created.Dimension

Last Order Datelast_order_dateThe date of the customer’s most recent order.Dimension

New or Returningnew_or_returning_customerWhether the customer is buying for the first time.Dimension

Shipping address

4 fields

FieldDescriptionType

Shipping Countryshipping_countryThe country the order shipped to.Dimension

Shipping Provinceshipping_provinceThe province or state the order shipped to.Dimension

Shipping Cityshipping_cityThe city the order shipped to.Dimension

Shipping ZIP Codeshipping_zip_codeThe postal code the order shipped to.Dimension

Billing address

3 fields

FieldDescriptionType

Billing Countrybilling_countryThe country on the billing address.Dimension

Billing Provincebilling_provinceThe province or state on the billing address.Dimension

Billing Citybilling_cityThe city on the billing address.Dimension

Traffic attribution

7 fields

FieldDescriptionType

Landing Sitelanding_siteThe first page the customer visited before ordering.Dimension

Referring Sitereferring_siteThe site that referred the customer to your store.Dimension

UTM Sourceutm_sourceThe utm_source value on the visit.Dimension

UTM Mediumutm_mediumThe utm_medium value on the visit.Dimension

UTM Campaignutm_campaignThe utm_campaign value on the visit.Dimension

UTM Contentutm_contentThe utm_content value on the visit.Dimension

UTM Termutm_termThe utm_term value on the visit.Dimension

Shop

2 fields

FieldDescriptionType

Shop IDshop_idThe unique identifier of the Shopify store.Dimension

Shop Nameshop_nameThe name of the Shopify store.Dimension

Time

4 fields

FieldDescriptionType

DatedateThe date the data was recorded.Dimension

WeekweekThe week the data was recorded.Dimension

MonthmonthThe calendar month the data was recorded.Dimension

YearyearThe calendar year the data was recorded.Dimension

Missing a field you need?

Tell us which metric or dimension you're after and we'll look at adding it to the connector.

Request a field

Ready to pull these into your report?

Connect Shopify free and send every field above to Data Studio, Claude, ChatGPT or Gemini.

+ Connect for free