Skip to main content
Last updated: December 18, 2025
260 dimensions
138 metrics
This reference covers all available dimensions and metrics for Shopify data through Detrics. Use this guide to understand what data you can extract and how to structure your queries.
Supported destinations:
Google Sheets
Looker Studio

Dimensions

Dimensions are the attributes you can use to segment and group your Shopify data.

Store

Store ID
A globally-unique ID for the shop.

Field Name: storeId
Type: dimension
Store Domain
The domain name of the shop.

Field Name: storeDomain
Type: dimension
Store Name
The name of the shop.

Field Name: storeName
Type: dimension
Store Address 1
The first line of the address. Typically the street address or PO Box number.

Field Name: storeAddress1
Type: dimension
Store Address 2
The second line of the address. Typically the number of the apartment, suite, or unit.

Field Name: storeAddress2
Type: dimension
Store Checkout API Supported
Specifies whether the shop supports checkouts via Checkout API.

Field Name: storeCheckoutApiSupported
Type: dimension
Store City
The name of the city, district, village, or town.

Field Name: storeCity
Type: dimension
Store Country
The shop’s country.

Field Name: storeCountry
Type: dimension
Store Country Code
The two-letter code for the country of the address.

Field Name: storeCountryCode
Type: dimension
Store Created At
The date and time when the shop was created.

Field Name: storeCreatedAt
Type: dimension
Store Contact Email
The public-facing contact email address for the shop. Customers will use this email to communicate with the shop owner.

Field Name: storeContactEmail
Type: dimension
Store Currency Code
The three-letter code for the shop’s default currency.

Field Name: storeCurrencyCode
Type: dimension
Store Enabled Presentment Currencies
The presentment currencies enabled for the shop.

Field Name: storeEnabledPresentmentCurrencies
Type: dimension
Store Email
The shop owner’s email address. Shopify will use this email address to communicate with the shop owner.

Field Name: storeEmail
Type: dimension
Store IANA Timezone
The shop’s time zone as defined by the IANA

Field Name: storeIanaTimezone
Type: dimension
Store Latitude
The latitude coordinate of the address.

Field Name: storeLatitude
Type: dimension
Store Longitude
The longitude coordinate of the address.

Field Name: storeLongitude
Type: dimension
Store Money Format
A string representing the way currency is formatted when the currency isn’t specified.

Field Name: storeMoneyFormat
Type: dimension
Store Money With Currency Format
How currencies are displayed on your store.

Field Name: storeMoneyWithCurrencyFormat
Type: dimension
Store Myshopify Domain
The shop’s .myshopify.com domain.

Field Name: storeMyshopifyDomain
Type: dimension
Store Password Enabled
Whether the password protection page is enabled on the shop’s online store.

Field Name: storePasswordEnabled
Type: dimension
Store Phone
A phone number associated with the address.

Field Name: storePhone
Type: dimension
Store Shop Locales
The shop’s primary locale.

Field Name: storeShopLocales
Type: dimension
Store Province
The region of the address, such as the province, state, or district.

Field Name: storeProvince
Type: dimension
Store Province Code
The two- or three-letter code for the shop’s province or state.

Field Name: storeProvinceCode
Type: dimension
Store Setup Required
Whether the shop has any outstanding setup steps.

Field Name: storeSetupRequired
Type: dimension
Store Shop Owner
The name of the shop owner.

Field Name: storeShopOwner
Type: dimension
Store Taxes Included
Whether applicable taxes are included in product prices.

Field Name: storeTaxesIncluded
Type: dimension
Store Tax Shipping
Whether taxes are charged for shipping.

Field Name: storeTaxShipping
Type: dimension
Store Timezone
The name of the timezone the shop is in.

Field Name: storeTimezoneAbbreviation
Type: dimension
Store Transactional SMS Disabled
Whether transactional SMS sent by Shopify are disabled on the shop’s online store.

Field Name: storeTransactionalSmsDisabled
Type: dimension
Store Updated At
The date and time when the shop was last updated.

Field Name: storeUpdatedAt
Type: dimension
Store Weight Unit
The default unit of weight measurement for the shop.

Field Name: storeWeightUnit
Type: dimension
Store Zip
The shop’s zip or postal code.

Field Name: storeZip
Type: dimension

Order

Order ID
A globally-unique ID

Field Name: orderId
Type: dimension
Order Name
The unique identifier for the order that appears on the order page in the Shopify admin and the Order status page. For example, ‘#1001’, ‘EN1001’, or ‘1001-A’. This value isn’t unique across multiple stores

Field Name: orderName
Type: dimension
Order Note
The contents of the note associated with the order

Field Name: orderNote
Type: dimension
Order Tags
A comma separated list of tags associated with the order. Updating tags overwrites any existing tags that were previously added to the order

Field Name: orderTags
Type: dimension
Order Created At
Date and time when the order was created in Shopify. This field is used to filter Orders based on the timeframe selected in your request.

Field Name: orderCreatedAt
Type: dimension
Order Closed At
The date and time when the order was closed. Returns null if the order isn’t closed.

Field Name: orderClosedAt
Type: dimension
Order Cancelled At
The date and time when the order was canceled. Returns null if the order wasn’t canceled.

Field Name: orderCancelledAt
Type: dimension
Order Currency Code
The shop currency when the order was placed

Field Name: orderCurrencyCode
Type: dimension
Order Email
The email address associated with the customer

Field Name: orderEmail
Type: dimension
Order Fully Paid
Whether the order has been paid in full

Field Name: orderFullyPaid
Type: dimension
Order Discount Codes
The discount codes used for the order.

Field Name: orderDiscountCodes
Type: dimension
Order Fulfillment Status


Field Name: orderFulfillmentStatus
Type: dimension
Order Payment Status
The display financial status of the order.

Field Name: orderDisplayFinancialStatus
Type: dimension
Order Fulfillment Date


Field Name: orderFulfillmentDate
Type: dimension
Order Phone
The phone number associated with the customer

Field Name: orderPhone
Type: dimension
Order Closed
Whether the order is closed

Field Name: orderClosed
Type: dimension
Order Cancel Reason
The reason provided when the order was canceled. Returns null if the order wasn’t canceled

Field Name: orderCancelReason
Type: dimension
Order PO Number
The purchase order number associated with the order. Used for B2B orders.

Field Name: orderPoNumber
Type: dimension
Order Source Identifier
A unique identifier for the order that comes from an external source (e.g., from a third-party checkout).

Field Name: orderSourceIdentifier
Type: dimension
Order Confirmation Number
The confirmation number displayed to the customer after completing checkout. Starts with a letter.

Field Name: orderConfirmationNumber
Type: dimension
Order Processed At
The date and time when the order was processed. This can differ from created_at for draft orders or pre-orders.

Field Name: orderProcessedAt
Type: dimension
Order Source Name
The source of the order, such as “web”, “shopify_draft_order”, “pos”, or a third-party app name.

Field Name: orderSourceName
Type: dimension
Order Is Test
Whether the order is a test order. Test orders are created using the Shopify Bogus Gateway.

Field Name: orderTest
Type: dimension
Order Risk Level
The fraud risk level of the order: HIGH, MEDIUM, LOW, NONE, or PENDING.

Field Name: orderRiskLevel
Type: dimension
Order Fraud Protection Level
The fraud protection level for the order: FULLY_PROTECTED, PARTIALLY_PROTECTED, NOT_PROTECTED, or PENDING.

Field Name: orderFraudProtectionLevel
Type: dimension
Order Payment Gateway
The name of the payment gateway used to process the order (e.g., “shopify_payments”, “paypal”).

Field Name: orderPaymentGateway
Type: dimension
Order Location ID
The ID of the retail location where the order was placed (for POS orders). Returns empty for online orders.

Field Name: orderLocationId
Type: dimension
Order Location Name
The name of the retail location where the order was placed (for POS orders). Returns empty for online orders.

Field Name: orderLocationName
Type: dimension
Order Client IP
The IP address of the API client that created the order

Field Name: orderClientIp
Type: dimension
Order Presentment Money Currency
The presentment money currency for the order

Field Name: orderTotalPriceSetPresentmentMoneyCurrency
Type: dimension
Order Updated At
The date and time when the order was modified last.

Field Name: orderUpdatedAt
Type: dimension
Order Discount Code
The discount code used for the order.

Field Name: orderDiscountCode
Type: dimension
Order Sales Channel
Name of the channel that this sub-channel belongs to. Identifies the parent sales channel.

Field Name: orderSalesChannelName
Type: dimension
Order Sales Sub Channel
Name of the sub-channel (e.g., “Online Store”, “Instagram Shopping”, “TikTok Live”). More specific than the parent channel.

Field Name: orderSubChannelName
Type: dimension
Order Sales Channel Handle
Unique string identifier used as a public identifier for the channel definition.

Field Name: orderChannelHandle
Type: dimension
Order Sales Channel Is Marketplace
Whether this channel definition represents a marketplace (true/false). Marketplaces are third-party platforms like Amazon, eBay, etc.

Field Name: orderChannelIsMarketplace
Type: dimension
Order Shipping Address 1
The shipping address line 1 of the customer

Field Name: orderShippingAddress1
Type: dimension
Order Shipping Address 2
The shipping address line 2 of the customer

Field Name: orderShippingAddress2
Type: dimension
Order Shipping Country
The shipping address country of the customer

Field Name: orderShippingCountry
Type: dimension
Order Shipping City
The shipping address city of the customer

Field Name: orderShippingCity
Type: dimension
Order Shipping Post Code
The shipping address postal code of the customer

Field Name: orderShippingPostCode
Type: dimension
Order Shipping Phone
The shipping address phone number of the customer

Field Name: orderShippingPhone
Type: dimension
Order Shipping Company
The shipping address company name of the customer

Field Name: orderShippingCompany
Type: dimension
Order Shipping Method
The title of the shipping method selected for the order (e.g., “Standard Shipping”, “Express Delivery”).

Field Name: orderShippingLineTitle
Type: dimension
Order Shipping Method Code
A unique identifier code for the shipping rate selected for the order.

Field Name: orderShippingLineCode
Type: dimension
Order Billing Address 1
The billing address line 1 of the customer

Field Name: orderBillingAddress1
Type: dimension
Order Billing Address 2
The billing address line 2 of the customer

Field Name: orderBillingAddress2
Type: dimension
Order Billing Country
The billing address country

Field Name: orderBillingCountry
Type: dimension
Order Billing City
The billing address city

Field Name: orderBillingCity
Type: dimension
Order Billing Phone
The billing address phone number

Field Name: orderBillingPhone
Type: dimension

Order Customer

Order Customer ID
A globally-unique ID for the customer.

Field Name: orderCustomerId
Type: dimension
Order Customer Name
The full name of the customer

Field Name: orderCustomerName
Type: dimension
Order Customer Email
The customer’s email address.

Field Name: orderCustomerEmail
Type: dimension
Order Customer Phone
The customer’s phone number.

Field Name: orderCustomerPhone
Type: dimension
Order Customer Image Url
The image url associated with the customer

Field Name: orderCustomerImage
Type: dimension
Order Customer Locale
The customer’s locale

Field Name: orderCustomerLocale
Type: dimension
Order Customer Note
A note about the customer.

Field Name: orderCustomerNote
Type: dimension
Order Customer Predicted Spend Tier
The predicted spend tier of a customer with a shop.HIGH:The customer’s spending is predicted to be in the top spending range for the shop in the following year. LOW: The customer’s spending is predicted to be zero, or in the lowest spending range for the shop in the following year. MEDIUM : The customer’s spending is predicted to be in the normal spending range for the shop in the following year.

Field Name: orderCustomerPredictedSpendTier
Type: dimension
Order Customer Tags
A comma separated list of tags that have been added to the customer.

Field Name: orderCustomerTags
Type: dimension
Order Customer Unsubscribe URL
The URL to unsubscribe the customer from the mailing list.

Field Name: orderCustomerUnsubscribeUrl
Type: dimension
Order Customer Tax Exempt
Whether the customer is exempt from being charged taxes on their orders.

Field Name: orderCustomerTaxExempt
Type: dimension
Order Customer Created At
Date and time when the customer was created in Shopify.

Field Name: orderCustomerCreatedAt
Type: dimension
Order Customer Country
Country of the customer

Field Name: orderCustomerCountry
Type: dimension
Order Customer City
City of the customer

Field Name: orderCustomerCity
Type: dimension
Order Customer Country Code
Country Code of the customer

Field Name: orderCustomerCountryCode
Type: dimension
Order Customer Is Returning
True if the customer has placed more than one order.

Field Name: orderCustomerIsReturning
Type: dimension

Traffic Source First Visit

Customer Journey First Visit Source
Identifies a search engine, a newsletter name, or other source

Field Name: customerJourneyFirstVisitSource
Type: dimension
Customer Journey First Visit Page URL
URL of the first page the customer landed on for their first session

Field Name: customerJourneyFirstVisitLandingPageUrl
Type: dimension
Customer Journey First Visit Occurred At
The date and time when the customer’s first session occurred in the shop.

Field Name: customerJourneyFirstVisitOccurredAt
Type: dimension
First Visit UTM Source
The UTM source parameter from the first visit

Field Name: firstVisitUTMSource
Type: dimension
First Visit UTM Medium
The UTM medium parameter from the first visit

Field Name: firstVisitUTMMedium
Type: dimension
First Visit UTM Campaign
The UTM campaign parameter from the first visit

Field Name: firstVisitUTMCampaign
Type: dimension
First Visit UTM Term
The UTM term parameter from the first visit

Field Name: firstVisitUTMTerm
Type: dimension
First Visit UTM Content
The UTM content parameter from the first visit

Field Name: firstVisitUTMContent
Type: dimension

Traffic Source Last Visit

Customer Journey Last Visit Occurred At
The date and time when the customer’s last session occurred before making the order.

Field Name: customerJourneyLastVisitOccurredAt
Type: dimension
Customer Journey Last Visit Source
Source from which the customer last visited the store before making the order

Field Name: customerJourneyLastVisitSource
Type: dimension
Customer Journey Last Visit Page URL
URL of the first page the customer landed on for their last session before making the order

Field Name: customerJourneyLastVisitLandingPageUrl
Type: dimension
Last Visit UTM Source
The UTM source parameter from the last visit

Field Name: lastVisitUTMSource
Type: dimension
Last Visit UTM Medium
The UTM medium parameter from the last visit

Field Name: lastVisitUTMMedium
Type: dimension
Last Visit UTM Campaign
The UTM campain parameter from the last visit

Field Name: lastVisitUTMCampaign
Type: dimension
Last Visit UTM Term
The UTM term parameter from the last visit

Field Name: lastVisitUTMTerm
Type: dimension
Last Visit UTM Content
The UTM content parameter from the last visit

Field Name: lastVisitUTMContent
Type: dimension

Line Item

Line Item ID
A globally-unique ID of the Line Item.

Field Name: lineItemId
Type: dimension
Line Item Product ID
A globally-unique ID of the Product.

Field Name: lineItemProductId
Type: dimension
Line Item Type
The product type that merchants define

Field Name: lineItemProductType
Type: dimension
Line Item SKU
The variant SKU number.

Field Name: lineItemSku
Type: dimension
Line Item Is Gift Card
Whether the product is a gift card

Field Name: lineItemProductIsGiftCard
Type: dimension
Line Item Title
The title of the product at time of order creation

Field Name: lineItemTitle
Type: dimension
Line Item Image
Image of the Line Item at the time of order creation.

Field Name: lineItemImage
Type: dimension
Line Item Vendor
The name of the vendor who made the variant

Field Name: lineItemVendor
Type: dimension
Line Item Description
The description of the product, with HTML tags removed

Field Name: lineItemProductDescription
Type: dimension
Line Item Restockable
Whether the Line Item can be restocked

Field Name: lineItemRestockable
Type: dimension
Line Item Product Title
The name for the product that displays to customers

Field Name: lineItemProductTitle
Type: dimension
Line Item Requires Shipping
Whether physical shipping is required for the variant

Field Name: lineItemRequiresShipping
Type: dimension
Line Item Taxable
Whether the variant is taxable

Field Name: lineItemTaxable
Type: dimension
Line Item Collections
Names of the collections associated with the product

Field Name: lineItemProductCollectionsTitle
Type: dimension
Line Item Tags
A comma-separated list of searchable keywords that are associated with the product.

Field Name: lineItemProductTags
Type: dimension
Line Item Handle
A unique, human-readable string of the product’s title

Field Name: lineItemProductHandle
Type: dimension
Line Item Online Store URL
The product’s URL on the online store

Field Name: lineItemProductOnlineStoreUrl
Type: dimension
Line Item Online Store Preview URL
The preview URL for the online store

Field Name: lineItemProductOnlineStorePreviewUrl
Type: dimension
Line Item Status
The product status, which controls visibility across all sales channels

Field Name: lineItemProductStatus
Type: dimension
Line Item Has Only Default Variant
Whether the product has only a single variant with the default option and value

Field Name: lineItemProductHasOnlyDefaultVariant
Type: dimension
Line Item Has Out Of Stock Variants
Whether the product has variants that are out of stock

Field Name: lineItemProductHasOutOfStockVariants
Type: dimension
Line Item Requires Selling Plan
Whether the product can only be purchased with a selling plan

Field Name: lineItemProductRequiresSellingPlan
Type: dimension
Line Item Presentment Currency
The presentment currency code of the Line Item.

Field Name: lineItemOriginalUnitPriceSetPresentmentMoneyCurrency
Type: dimension
Line Item Created At
The date and time when the product was created.

Field Name: lineItemProductCreatedAt
Type: dimension

Line Item Variant

Line Item Variant ID
A globally-unique ID of the variant

Field Name: lineItemVariantId
Type: dimension
Line Item Variant SKU
A case-sensitive identifier for the product variant in the shop

Field Name: lineItemVariantSku
Type: dimension
Line Item Variant Name
Display name of the variant, based on product’s title + variant’s title

Field Name: lineItemVariantDisplayName
Type: dimension
Line Item Variant Title
The title of the variant at time of order creation

Field Name: lineItemVariantTitle
Type: dimension
Line Item Variant Image
The featured image for the variant

Field Name: lineItemVariantImage
Type: dimension
Line Item Variant Barcode
The value of the barcode associated with the product variant

Field Name: lineItemVariantBarcode
Type: dimension
Line Item Variant Available For Sale
Whether the product variant is available for sale

Field Name: lineItemVariantAvailableForSale
Type: dimension
Line Item Variant Policy
Whether customers are allowed to place an order for the product variant when it’s out of stock

Field Name: lineItemVariantInventoryPolicy
Type: dimension
Line Item Variant Legacy Resource ID
The ID of the corresponding resource in the REST Admin API

Field Name: lineItemVariantLegacyResourceId
Type: dimension
Line Item Variant Position
The order of the product variant in the list of product variants

Field Name: lineItemVariantPosition
Type: dimension
Line Item Variant Requires Components
Whether a product variant requires components

Field Name: lineItemVariantRequiresComponents
Type: dimension
Line Item Variant Sellable Online Quantity
The total sellable quantity of the variant for online channels

Field Name: lineItemVariantSellableOnlineQuantity
Type: dimension
Line Item Variant Taxable
Whether a tax is charged when the product variant is sold

Field Name: lineItemVariantTaxable
Type: dimension
Line Item Variant Tax Code
The tax code for the product variant

Field Name: lineItemVariantTaxCode
Type: dimension
Line Item Variant Updated At
The date and time when the product variant was last modified

Field Name: lineItemVariantUpdatedAt
Type: dimension
Line Item Variant Created At
The date and time when the variant was created

Field Name: lineItemVariantCreatedAt
Type: dimension

Product

Product ID
A globally-unique ID.

Field Name: productId
Type: dimension
Product Variant SKU
The SKU (Stock Keeping Unit) of the product variant

Field Name: productVariantSku
Type: dimension
Product Variant ID
The unique identifier of the product variant

Field Name: productVariantId
Type: dimension
Product Title
The name for the product that displays to customers

Field Name: productTitle
Type: dimension
Product Variant Title
The title of the product variant

Field Name: productVariantTitle
Type: dimension
Product Tags
A comma-separated list of searchable keywords that are associated with the product.

Field Name: productTags
Type: dimension
Product Description
A single-line description of the product, with HTML tags removed

Field Name: productDescription
Type: dimension
Product Vendor
The name of the product’s vendor

Field Name: productVendor
Type: dimension
Product Type
The product type that merchants define

Field Name: productType
Type: dimension
Product Created At
The date and time when the product was created.

Field Name: productCreatedAt
Type: dimension
Product Category Name
The category of a product from Shopify’s Standard Product Taxonomy

Field Name: productCategoryFullName
Type: dimension
Product Is Gift Card
Whether the product is a gift card

Field Name: productIsGiftCard
Type: dimension
Product Online Store URL
The product’s URL on the online store. If null, then the product isn’t published to the online store sales channel

Field Name: productOnlineStoreUrl
Type: dimension
Product Published At
The date and time when the product was published to the online store.

Field Name: productPublishedAt
Type: dimension
Product SEO Description
The SEO description that is associated with the product

Field Name: productSeoDescription
Type: dimension
Product SEO Title
The SEO title that is associated with the product

Field Name: productSeoTitle
Type: dimension
Product Status
The product status, which controls visibility across all sales channels

Field Name: productStatus
Type: dimension
Product Updated At
The date and time when the product was last modified.

Field Name: productUpdatedAt
Type: dimension
Product Collections
Names of the collections associated with the product

Field Name: productCollectionsTitle
Type: dimension

Line Item Refund

Line Item Refund Restocked
Whether the refunded Line Item was restocked

Field Name: lineItemRefundRestocked
Type: dimension
Line Item Refund Location
The restock location

Field Name: lineItemRefundLocation
Type: dimension
Line Item Refund Restocked Type
The type of restock for the refunded Line Item

Field Name: lineItemRefundRestockedType
Type: dimension

Refund

Refund ID
A globally-unique ID

Field Name: refundId
Type: dimension
Refund Created At
The date and time when the refund was created.

Field Name: refundCreatedAt
Type: dimension
Refund Note
The optional note associated with the refund

Field Name: refundNote
Type: dimension
Refund Order Adjustment Reason
The reason for the order adjustment

Field Name: refundOrderAdjustmentReason
Type: dimension

Attribution

UTM Campaign
UTM Campaign parameter from the order

Field Name: salesUtmCampaign
Type: dimension
UTM Source
UTM Source parameter from the order

Field Name: salesUtmSource
Type: dimension
UTM Medium
UTM Medium parameter from the order

Field Name: salesUtmMedium
Type: dimension
UTM Content
UTM Content parameter from the order

Field Name: salesUtmContent
Type: dimension
UTM Term
UTM Term parameter from the order

Field Name: salesUtmTerm
Type: dimension
Order Referrer Domain
The referring domain for the order

Field Name: orderReferrerDomain
Type: dimension
Order Referrer Source
The referrer source type for the order

Field Name: orderReferrerSource
Type: dimension
Order Referrer Name
The referrer name for the order

Field Name: orderReferrerName
Type: dimension
Order Landing Page Path
The landing page path for the order

Field Name: orderLandingPagePath
Type: dimension
First Order Referring Channel
The referring channel of the first order

Field Name: firstOrderReferringChannel
Type: dimension
First Order Sales Channel
The sales channel of the first order

Field Name: firstOrderSalesChannel
Type: dimension
First Order Traffic Type
The traffic type of the first order

Field Name: firstOrderTrafficType
Type: dimension
Marketing Event Type
The type of marketing event that drove the order

Field Name: orderMarketingEventType
Type: dimension

Channel

Sales Channel
The sales channel where the sale occurred

Field Name: salesChannel
Type: dimension
Order Sales Channel
The order-level sales channel

Field Name: orderSalesChannel
Type: dimension
Discount Code
The discount code applied to the order

Field Name: discountCode
Type: dimension
Discount Name
The name of the discount applied

Field Name: discountName
Type: dimension
Discount Type
The type of discount (percentage, fixed, etc.)

Field Name: discountType
Type: dimension
Discount Class
The class of discount applied

Field Name: discountClass
Type: dimension
Market
The market where the sale occurred

Field Name: market
Type: dimension
Subscription or One-Time
Whether the order is subscription or one-time purchase

Field Name: subscriptionOrOneTime
Type: dimension

Product (Analytics)

Product Title
The title of the product sold

Field Name: salesProductTitle
Type: dimension
Product Type
The type/category of the product sold

Field Name: salesProductType
Type: dimension
Product Vendor
The vendor of the product sold

Field Name: salesProductVendor
Type: dimension
Product Variant Title
The variant title of the product sold

Field Name: salesProductVariantTitle
Type: dimension
Product Variant SKU
The SKU of the product variant sold

Field Name: salesProductVariantSku
Type: dimension
Product Collection
The collection the product belongs to

Field Name: salesProductCollection
Type: dimension
Product Tag
Tags associated with the product

Field Name: salesProductTag
Type: dimension
Product ID
The unique identifier of the product

Field Name: salesProductId
Type: dimension
Product Variant ID
The unique identifier of the product variant

Field Name: salesProductVariantId
Type: dimension
Product Variant ABC Grade
ABC inventory grade of the product variant

Field Name: salesProductVariantAbcGrade
Type: dimension
Bundle Title
The title of the bundle

Field Name: salesBundleTitle
Type: dimension

Billing Geography

Billing Country
The billing country of the customer

Field Name: salesBillingCountry
Type: dimension
Billing Region
The billing region/state of the customer

Field Name: salesBillingRegion
Type: dimension
Billing City
The billing city of the customer

Field Name: billingCity
Type: dimension
Billing Postal Code
The billing postal code of the customer

Field Name: billingPostalCode
Type: dimension

Shipping Geography

Shipping Country
The shipping destination country

Field Name: shippingCountry
Type: dimension
Shipping Region
The shipping destination region/state

Field Name: shippingRegion
Type: dimension
Shipping City
The shipping destination city

Field Name: shippingCity
Type: dimension
Shipping Carrier
The shipping carrier used

Field Name: shippingCarrier
Type: dimension

Customer (Analytics)

Customer Country
The country of the customer

Field Name: customerCountry
Type: dimension
Customer Region
The region/state of the customer

Field Name: customerRegion
Type: dimension
Customer City
The city of the customer

Field Name: customerCity
Type: dimension
Customer Email Domain
The email domain of the customer (useful for B2B identification)

Field Name: customerEmailDomain
Type: dimension
Customer Cohort Month
The month when the customer made their first purchase

Field Name: customerCohortMonth
Type: dimension
Customer Cohort Week
The week when the customer made their first purchase

Field Name: customerCohortWeek
Type: dimension
Customer Cohort Quarter
The quarter when the customer made their first purchase

Field Name: customerCohortQuarter
Type: dimension
RFM Group
RFM (Recency, Frequency, Monetary) segmentation group

Field Name: rfmGroup
Type: dimension
Predicted Spend Tier
Predicted spend tier based on customer behavior

Field Name: predictedSpendTier
Type: dimension
Customer Tag
Tags associated with the customer

Field Name: customerTag
Type: dimension
Customer Account Status
The account status of the customer

Field Name: customerAccountStatus
Type: dimension
Customer Email Subscription Status
Email subscription status of the customer

Field Name: customerEmailSubscriptionStatus
Type: dimension
Customer SMS Subscription Status
SMS subscription status of the customer

Field Name: customerSmsSubscriptionStatus
Type: dimension
First Order Has Subscription
Whether the first order included a subscription

Field Name: firstOrderHasSubscription
Type: dimension

Order Status

Order Fulfillment Status
The fulfillment status of the order

Field Name: salesOrderFulfillmentStatus
Type: dimension
Order Payment Status
The payment status of the order

Field Name: salesOrderPaymentStatus
Type: dimension
Is Canceled Order
Whether the order was canceled

Field Name: salesIsCanceledOrder
Type: dimension
Order Tag
Tags associated with the order

Field Name: salesOrderTag
Type: dimension
Order Name
The name/number of the order

Field Name: salesOrderName
Type: dimension
Order Risk Level
The risk level of the order

Field Name: salesOrderRiskLevel
Type: dimension
Return Reason
The reason for the return

Field Name: salesReturnReason
Type: dimension
Order or Return
Whether this is an order or a return

Field Name: salesOrderOrReturn
Type: dimension

Payment

Digital Wallet
The digital wallet used (Apple Pay, Google Pay, etc.)

Field Name: digitalWallet
Type: dimension
Transaction Currency
The currency of the transaction

Field Name: transactionCurrency
Type: dimension
Is Shop Pay Transaction
Whether Shop Pay was used for the transaction

Field Name: isShopPayTransaction
Type: dimension
Payment Source
The source of the payment

Field Name: paymentSource
Type: dimension

Session

Session Country
The country where the session originated

Field Name: sessionCountry
Type: dimension
Session Region
The region/state where the session originated

Field Name: sessionRegion
Type: dimension
Session City
The city where the session originated

Field Name: sessionCity
Type: dimension
Referrer Domain
The referring domain of the session

Field Name: referrerDomain
Type: dimension
Referrer Source
The referrer source type

Field Name: referrerSource
Type: dimension
Referrer Name
The name of the referrer

Field Name: referrerName
Type: dimension
Landing Page Path
The landing page path of the session

Field Name: landingPagePath
Type: dimension
Landing Page Type
The type of landing page

Field Name: landingPageType
Type: dimension
Session Bounced
Whether the session bounced

Field Name: sessionBounced
Type: dimension

B2B

Is B2B Order
Whether this is a B2B order

Field Name: isB2bOrder
Type: dimension
Company Name
The name of the company (B2B)

Field Name: companyName
Type: dimension
Company Location Name
The location name of the company (B2B)

Field Name: companyLocationName
Type: dimension

Metrics

Metrics are the numerical values you can measure and analyze from your Shopify campaigns.

Sales

Gross Sales
Total gross sales before any deductions

Field Name: grossSales
Type: metric
Net Sales
Net sales after discounts and returns

Field Name: netSales
Type: metric
Total Sales
Total sales including all fees and taxes

Field Name: totalSales
Type: metric
Total Sales (First Time)
Total sales from first-time customers

Field Name: totalSalesFirstTime
Type: metric
Total Sales (Returning)
Total sales from returning customers

Field Name: totalSalesReturning
Type: metric
Average Order Value
Average order value

Field Name: averageOrderValue
Type: metric
Gross Profit
Gross profit (revenue minus cost of goods sold)

Field Name: grossProfit
Type: metric
Gross Margin
Gross margin percentage

Field Name: grossMargin
Type: metric
Cost of Goods Sold
Total cost of goods sold

Field Name: costOfGoodsSold
Type: metric
Total Duties
Total import duties and taxes

Field Name: totalDuties
Type: metric
Additional Fees
Additional fees charged

Field Name: additionalFees
Type: metric
Tips
Total tips received

Field Name: tips
Type: metric
Gift Card Gross Sales
Gross sales from gift cards

Field Name: giftCardGrossSales
Type: metric

Orders (Analytics)

Total Orders
Total number of orders

Field Name: totalOrders
Type: metric
Orders (First Time)
Orders from first-time customers

Field Name: ordersFirstTime
Type: metric
Orders (Returning)
Orders from returning customers

Field Name: ordersReturning
Type: metric
Orders Delivered
Orders that have been delivered

Field Name: ordersDelivered
Type: metric
Orders Shipped
Orders that have been shipped

Field Name: ordersShipped
Type: metric
Orders Fulfilled
Orders that have been fulfilled

Field Name: ordersFulfilled
Type: metric
Bundles Ordered
Bundles ordered

Field Name: bundlesOrdered
Type: metric
Net Items Sold
Net items sold (after returns)

Field Name: netItemsSold
Type: metric
Quantity Ordered
Total quantity ordered

Field Name: quantityOrdered
Type: metric
Quantity Ordered Per Order
Average quantity ordered per order

Field Name: quantityOrderedPerOrder
Type: metric
Number of Orders Per Customer
Average number of orders per customer

Field Name: numberOfOrdersPerCustomer
Type: metric

Customers (Analytics)

Customers
Total number of customers

Field Name: customers
Type: metric
New Customers
New customers acquired

Field Name: newCustomers
Type: metric
Returning Customers
Returning customers

Field Name: returningCustomers
Type: metric
Returning Customer Rate
Percentage of returning customers

Field Name: returningCustomerRate
Type: metric
Amount Spent Per Customer
Average amount spent per customer

Field Name: amountSpentPerCustomer
Type: metric
Total Amount Spent
Total lifetime value spent

Field Name: totalAmountSpent
Type: metric
Total Amount Spent Per Order
Average amount spent per order

Field Name: totalAmountSpentPerOrder
Type: metric
Total Number of Orders
Total number of orders from all customers

Field Name: totalNumberOfOrders
Type: metric
Days Since Last Order
Days since customer last ordered

Field Name: daysSinceLastOrder
Type: metric
Percent of Customers
Percentage of total customers

Field Name: percentOfCustomers
Type: metric

Discounts

Total Discount
Total discount amount

Field Name: totalDiscount
Type: metric
Order Level Discounts
Order-level discounts applied

Field Name: orderLevelDiscounts
Type: metric
Line Item Discounts
Line item-level discounts applied

Field Name: lineItemDiscounts
Type: metric
Gift Card Discounts
Gift card discounts applied

Field Name: giftCardDiscounts
Type: metric
Discounts Returned
Discounts returned with refunds

Field Name: discountsReturned
Type: metric
Shipping Charge Discounts
Shipping charge discounts

Field Name: shippingChargeDiscounts
Type: metric

Returns

Total Refunds
Total refunds issued

Field Name: totalRefunds
Type: metric
Gross Returns
Gross return value

Field Name: grossReturns
Type: metric
Net Returns
Net return value

Field Name: netReturns
Type: metric
Total Returns
Total returns value

Field Name: totalReturns
Type: metric
Quantity Returned
Quantity of items returned

Field Name: quantityReturned
Type: metric
Returned Quantity Rate
Return rate percentage

Field Name: returnedQuantityRate
Type: metric
Shipping Returned
Shipping costs returned

Field Name: shippingReturned
Type: metric
Return Fees
Return processing fees

Field Name: returnFees
Type: metric

Fulfillments

Total Shipping
Total shipping revenue

Field Name: totalShipping
Type: metric
Total Shipping Charges
Total shipping charges collected

Field Name: totalShippingCharges
Type: metric
Median Days Order to Delivery
Median days from order to delivery

Field Name: medianDaysOrderToDelivery
Type: metric
Median Days Order to Shipping
Median days from order to shipping

Field Name: medianDaysOrderToShipping
Type: metric
Median Days Order to Fulfillment
Median days from order to fulfillment

Field Name: medianDaysOrderToFulfillment
Type: metric
Median Days Shipping to Delivery
Median days from shipping to delivery

Field Name: medianDaysShippingToDelivery
Type: metric
Orders Delivered Fast Rate
Rate of orders delivered quickly

Field Name: ordersDeliveredFastRate
Type: metric
Orders Shipped Fast Rate
Rate of orders shipped quickly

Field Name: ordersShippedFastRate
Type: metric
Orders With Tracking Included Rate
Rate of orders with tracking information

Field Name: ordersWithTrackingIncludedRate
Type: metric

Taxes

Total Tax
Total taxes collected

Field Name: totalTax
Type: metric
Shipping Charge Taxes
Taxes on shipping charges

Field Name: shippingChargeTaxes
Type: metric
Taxes Returned
Taxes returned with refunds

Field Name: taxesReturned
Type: metric
Taxes Excluding Gift Cards
Taxes excluding gift card transactions

Field Name: taxesExcludingGiftCards
Type: metric

Sessions

Sessions
Total sessions

Field Name: sessions
Type: metric
Online Store Visitors
Unique store visitors

Field Name: onlineStoreVisitors
Type: metric
Pageviews
Total page views

Field Name: pageviews
Type: metric
Bounces
Sessions that bounced

Field Name: bounces
Type: metric
Bounce Rate
Bounce rate percentage

Field Name: bounceRate
Type: metric
Conversion Rate
Overall conversion rate

Field Name: conversionRate
Type: metric
Checkout Conversion Rate
Checkout conversion rate

Field Name: checkoutConversionRate
Type: metric
Added to Cart Rate
Add to cart rate

Field Name: addedToCartRate
Type: metric
Reached Checkout Rate
Rate of sessions reaching checkout

Field Name: reachedCheckoutRate
Type: metric
Completed Checkout Rate
Rate of sessions completing checkout

Field Name: completedCheckoutRate
Type: metric
Sessions That Completed Checkout
Sessions that completed checkout

Field Name: sessionsThatCompletedCheckout
Type: metric
Sessions That Reached Checkout
Sessions that reached checkout

Field Name: sessionsThatReachedCheckout
Type: metric
Sessions With Cart Additions
Sessions with items added to cart

Field Name: sessionsWithCartAdditions
Type: metric
Average Session Duration
Average session duration

Field Name: averageSessionDuration
Type: metric
Pageviews Per Session
Average pageviews per session

Field Name: pageviewsPerSession
Type: metric

Payments

Gross Payments
Gross payments received

Field Name: grossPayments
Type: metric
Net Payments
Net payments after fees

Field Name: netPayments
Type: metric
Refunded Payments
Refunded payments count

Field Name: refundedPayments
Type: metric
Transactions
Total transaction count

Field Name: transactions
Type: metric
Transaction Amount
Total transaction amount

Field Name: transactionAmount
Type: metric
Orders With Transactions
Orders with successful transactions

Field Name: ordersWithTransactions
Type: metric

Subscriptions

Active Subscriptions
Active subscriptions

Field Name: activeSubscriptions
Type: metric
Subscriptions Added
New subscriptions added

Field Name: subscriptionsAdded
Type: metric
Subscriptions Canceled
Subscriptions canceled

Field Name: subscriptionsCanceled
Type: metric

Gift Cards

Gift Card Net Sales
Net sales from gift cards

Field Name: giftCardNetSales
Type: metric
Gift Cards Issued
Gift cards issued

Field Name: giftCardsIssued
Type: metric
Ending Gift Card Balance
Ending gift card balance

Field Name: endingGiftCardBalance
Type: metric
Credited Store Credit Value
Store credit value added

Field Name: creditedStoreCreditValue
Type: metric
Debited Store Credit Value
Store credit value used

Field Name: debitedStoreCreditValue
Type: metric

Order

Order Original Total Price
The total price of the order at the time of order creation.

Field Name: orderOriginalTotalPriceSetShopMoneyAmount
Type: metric
Order Total Received
The total amount received from the customer before returns.

Field Name: orderTotalReceivedSetShopMoneyAmount
Type: metric
Order Total Price Before Returns
The total price of the order, before returns. This includes taxes and discounts.

Field Name: orderTotalPriceSetShopMoneyAmount
Type: metric
Order Subtotal Price
The sum of the prices for all line items after discounts and returns.

Field Name: orderCurrentSubtotalPriceSetShopMoneyAmount
Type: metric
Order Total Price After Returns
The total price of the order, after returns. This includes taxes and discounts.

Field Name: orderCurrentTotalPriceSetShopMoneyAmount
Type: metric
Order Total Additional Fees After Returns
The total amount of additional fees after returns.

Field Name: orderCurrentTotalAdditionalFeesSetShopMoneyAmount
Type: metric
Order Original Total Additional Fees
The total amount of additional fees at the time of order creation.

Field Name: orderOriginalTotalAdditionalFeesSetShopMoneyAmount
Type: metric
Order Total Duties After Returns
The total amount of duties after returns.

Field Name: orderCurrentTotalDutiesSetShopMoneyAmount
Type: metric
Order Original Total Duties
The total amount of duties at the time of order creation.

Field Name: orderOriginalTotalDutiesSetShopMoneyAmount
Type: metric
Order Refund Discrepancy
The difference between the suggested and actual refund amount of all refunds that have been applied to the order. A positive value indicates a difference in the merchant’s favor, and a negative value indicates a difference in the customer’s favor.

Field Name: orderRefundDiscrepancySetShopMoneyAmount
Type: metric
Order Total Shipping Price
The total shipping amount before discounts and returns.

Field Name: orderTotalShippingPriceSetShopMoneyAmount
Type: metric
Order Total Refunded Shipping
The total amount of shipping that was refunded.

Field Name: orderTotalRefundedShippingSetShopMoneyAmount
Type: metric
Order Total Tax
The total tax amount before returns.

Field Name: orderTotalTaxSetShopMoneyAmount
Type: metric
Order Total Tip Received
The sum of all tip amounts for the order.

Field Name: orderTotalTipReceivedSetShopMoneyAmount
Type: metric
Order Total Weight
The total weight of the order before returns, in grams.

Field Name: orderTotalWeight
Type: metric
Order Cart Discount
The total order-level discount amount, before returns.

Field Name: orderCartDiscountAmountSetShopMoneyAmount
Type: metric
Order Total Discounts After Returns
The total amount discounted on the order after returns. This includes both order and line level discounts.

Field Name: orderCurrentTotalDiscountsSetShopMoneyAmount
Type: metric
Order Total Discounts
The total amount discounted on the order before returns. This includes both order and line level discounts.

Field Name: orderTotalDiscountsSetShopMoneyAmount
Type: metric
Order Total Refunded
The total amount that was refunded.

Field Name: orderTotalRefundedSetShopMoneyAmount
Type: metric
Order Net Quantity
Net quantity of line items ordered. It shows number of sold items minus the number of returned items

Field Name: orderNetQuantity
Type: metric
Order Ordered Quantity
Total number of items ordered. Calculated by Net quantity + Returned quantity

Field Name: orderOrderedQuantity
Type: metric
Order Refunded Quantity
Total number of items returned

Field Name: orderRefundedQuantity
Type: metric

Order Customer

Order Customer Amount Spent
The total amount that the customer has spent on orders in their lifetime.

Field Name: orderCustomerAmountSpend
Type: metric
Order Customer Number Of Orders
The number of orders that the customer has made at the store in their lifetime.

Field Name: orderCustomerNumberOfOrders
Type: metric

Line Item

Line Item Price
The total price of the Line Item when the order was created in shop currency.

Field Name: lineItemOriginalUnitPriceSetShopMoneyAmount
Type: metric
Line Item Price Range (Min)
The minimum price of the product price range

Field Name: lineItemProductPriceRangeMin
Type: metric
Line Item Price Range (Max)
The maximum price of the product price range

Field Name: lineItemProductPriceRangeMax
Type: metric
Line Item Variant Cost
Unit cost associated with the inventory item. This is the cost of goods sold (COGS) for profit margin calculations. Note: Requires “View product costs” permission in Shopify.

Field Name: lineItemVariantInventoryCostAmount
Type: metric
Line Item Discount
The discount allocation for the line item

Field Name: lineItemDiscountAllocation
Type: metric
Line Item Quantity
The number of units ordered, including refunded and removed units

Field Name: lineItemQuantity
Type: metric
Line Item Total Inventory
The quantity of that’s in stock

Field Name: lineItemProductTotalInventory
Type: metric
Line Item Variant Compare At Price
The compare at price amount of the product variant

Field Name: lineItemVariantCompareAtPriceAmount
Type: metric
Line Item Variant Price
The price of the product variant in the default shop currency

Field Name: lineItemVariantPrice
Type: metric
Line Item Variant Compare At Price
The compare-at price of the variant in the default shop currency

Field Name: lineItemVariantCompareAtPrice
Type: metric
Line Item Inventory Quantity
The total sellable quantity of the variant

Field Name: lineItemVariantInventoryQuantity
Type: metric

Line Item Refund

Line Item Refund Price
The price of a refunded Line Item in shop currency.

Field Name: lineItemRefundPriceShopMoneyAmount
Type: metric
Line Item Refund Total Tax
The total tax charged on a refunded Line Item in shop currency.

Field Name: lineItemRefundTotalTaxShopMoneyAmount
Type: metric
Line Item Refund Subtotal
The subtotal price of a refunded Line Item in shop currency.

Field Name: lineItemRefundSubTotalShopMoneyAmount
Type: metric
Line Item Refund Quantity
The quantity of a refunded Line Item

Field Name: lineItemRefundQuantity
Type: metric

Product

Product Total Inventory
The quantity of that’s in stock

Field Name: productTotalInventory
Type: metric
Product Variant Unit Cost
The unit cost of the product variant

Field Name: productVariantUnitCost
Type: metric
Product Variant Price
The price of the product variant

Field Name: productVariantPrice
Type: metric
Product Price Range (Min)
The minimum price of the product, expressed in decimal numbers

Field Name: productPriceRangeMin
Type: metric
Product Price Range (Max)
The maximum price of the product, expressed in decimal numbers

Field Name: productPriceRangeMax
Type: metric

Refund

Refund Total Refunded
The total refunded amount in shop currency.

Field Name: refundTotalRefundedShopMoneyAmount
Type: metric
Refund Order Adjustment
The order adjustment amount in shop currency.

Field Name: refundOrderAdjustmentShopMoneyAmount
Type: metric
Refund Order Adjustment Tax
The order adjustment tax amount in shop currency.

Field Name: refundOrderAdjustmentTaxShopMoneyAmount
Type: metric

Traffic Source

Traffic Source Days to Conversion
The number of days between first visit and order conversion

Field Name: customerJourneyDaysToConversion
Type: metric