Analytics data points (fields) reference

Fields are the building blocks of analytics in Shopify. They're the individual data points you can select, filter, and group when creating reports. Fields come in 2 types:

  • Metrics are numbers you measure, such as net sales, orders, or sessions. They answer "how much" or "how many."
  • Dimensions are attributes you group by, such as product title, day, or traffic source. They answer "which" or "what kind."

This reference lists all available fields organized by category. Use the description and notes to understand what each field measures and when to use it.

Consider the following information when using this reference:

  • Metrics represent different types of values, such as percentages, counts, or durations, and are listed in the tables on this page in parentheses in the Type column. This is most relevant when you include multiple metrics in a report's visualization, because you can display only 2 types of metric value in a single visualization. Learn more about including multiple metrics in visualizations.
  • Fields that come from your store's apps and custom data aren't listed on this page, because they're specific to your store. Learn more about using app events and metafields in your reports.

Top 30 most helpful fields

Explore your data in new ways with these commonly used fields. These cover the essential metrics and dimensions most merchants need for day-to-day analytics.

Explore your data in new ways with these commonly used fields. These cover the essential metrics and dimensions most merchants need for day-to-day analytics.
NameDescriptionUsesNotesType
Net salesSales revenue, with discounts and sales reversals factored in
Formula: gross sales - discounts - sales reversals
  • Track your revenue after all adjustments and sales reversals.
  • Compare revenue performance across products and time periods after all adjustments.
Best approximation of actual revenue. Preferred over gross_sales for most analyses.Metric (Money total)
Gross salesSales revenue, before discounts and sales reversals are factored in
  • Track your revenue potential before any adjustments.
  • Compare full-price performance across products and time periods.
Full price before any adjustments. Use to understand demand at full price.Metric (Money total)
Total salesAmount customers spent in your store (subtotal, discounts, taxes, fees, shipping, sales reversals)
Formula: net sales + additional fees + checkout fees + duties + shipping charges + taxes
  • Track the complete revenue impact including all fees and adjustments.
  • Compare total customer spending across different products and channels.
The complete amount customers paid, including taxes and shipping. Use for cash flow planning.Metric (Money total)
OrdersNumber of orders placed
  • Track order volume trends to plan inventory and staffing needs.
  • Compare order frequency across different marketing channels and campaigns.
Returns generate order records to maintain accurate inventory and financial tracking. Filter by 'Order status' to exclude returned orders from your analyses.Metric (Count)
Average order valueAverage value of orders placed, excluding any post-order adjustments
Formula: (gross sales - discounts) / orders
  • Increase revenue by focusing on strategies that raise average order value.
  • Set minimum order thresholds for free shipping and promotions.
Revenue ÷ orders. Use to set minimum thresholds for free shipping.Metric (Money average)
Gross profitSales revenue minus the cost of goods sold
Formula: net sales - cost of goods sold
  • Focus marketing and inventory investment on your most profitable products.
  • Set pricing strategies that maximize profit rather than just revenue.
Requires cost of goods sold to be set up in Shopify for accurate calculations.Metric (Money total)
Gross marginPercentage of your sales that is profit (factoring in cost of goods sold)
Formula: gross profit / net sales
  • Focus marketing and inventory investments on higher-margin areas.
  • Set minimum margin requirements for new products and pricing decisions.
Requires cost of goods sold. Use as filter (such as margin < 20%) to find low-margin products.Metric (Percentage & rate)
CustomersNumber of customers who placed an order
  • Track customer acquisition and retention across different time periods.
  • Set customer acquisition goals and budget allocation based on historical performance.
Metric (Count)
New customersNumber of new customers who placed an order
  • Track customer acquisition performance across marketing channels.
  • Set customer acquisition goals and measure marketing campaign success.
First-time purchasers only. Use to measure acquisition effectiveness.Metric (Count)
Returning customersNumber of returning customers who placed an order
  • Track customer retention success and loyalty program effectiveness.
  • Focus retention marketing on bringing back previous customers.
Customers who've purchased before. Key indicator of loyalty.Metric (Count)
Returning customer ratePercentage of returning customers relative to all customers who placed orders
Formula: returning customers / customers
  • Gauge how well you're retaining customers versus attracting new ones.
  • Decide whether to focus marketing efforts on retention or acquisition.
Higher rates reduce acquisition costs. Most stores display 20-40%.Metric (Percentage & rate)
SessionsNumber of online store visits
  • Track how many times visitors browse your online store.
  • Measure the effectiveness of your marketing campaigns.
Only counted when visitors consent to cookies through your cookie banner. If counts seem low, then verify your cookie banner is displaying and functioning correctly. Note: other analytics platforms calculate sessions differently.Metric (Count)
Online store visitorsUnique visitors (one visitor can visit multiple times)
  • Track how many different people discover your online store.
  • Measure your reach versus repeat visits.
Unique visitors - one person visiting 5 times counts as 1 visitor but 5 sessions.Metric (Count)
Conversion ratePercentage of online store visits (sessions) that resulted in a sale
Formula: sessions that completed checkout / sessions
  • Track how well your online store turns browsers into customers.
  • Set benchmarks for converting visitors into customers.
Might appear lower than expected due to bot traffic. Filter by 'Human' traffic for a more accurate view of actual customer behavior.Metric (Percentage & rate)
Bounce ratePercentage of online store visits that ended after a single pageview
Formula: bounces / sessions
  • Measure how well your online store keeps visitors engaged.
  • Fix landing pages with high bounce rates.
High bounce rate isn't always bad - it might mean visitors found what they needed quickly.Metric (Percentage & rate)
Average session durationAverage duration, in seconds, of online store visits
  • Set targets for how long visitors should spend on your online store.
  • Compare visit length across different time periods.
Measured in seconds. Longer isn't always better - depends on your store type.Metric (Avg duration (seconds))
PageviewsTotal pageviews across all online store visits
  • Track how much content visitors view on your online store.
  • Identify which pages attract the most visitor attention.
Metric (Count)
Added to cart rateOnline store visits with items added to cart relative to total visits
Formula: sessions with cart additions / sessions
  • Review what percentage of visitors indicate serious buying interest.
  • Improve product pages if too few visitors add items to cart.
Checkouts can exceed add-to-cart counts when customers purchase directly from channels such as Instagram Shopping or Facebook Shops without visiting your cart page.Metric (Percentage & rate)
Reached checkout rateOnline store visits that reached checkout relative to total visits
Formula: sessions that reached checkout / sessions
  • Track what percentage of visitors make it to checkout.
  • Improve your cart and product pages if too few visitors reach checkout.
Checkouts can exceed add-to-cart counts when customers purchase directly from channels such as Instagram Shopping or Facebook Shops without visiting your cart page.Metric (Percentage & rate)
Sessions with cart additionsOnline store visits in which a visitor added an item to cart
  • Track how many visitors indicate serious buying interest.
  • Send cart abandonment emails to visitors who don't complete their purchase.
Use as filter to analyze only high-intent visitors.Metric (Count)
Sessions that completed checkoutOnline store visits in which a purchase was completed
  • Track successful sales from browsing visits.
  • Compare conversion rates across different time periods.
Metric (Count)
Net items soldNumber of items in the given sale, with reversed quantity factored in
  • Understand your true sales volume by seeing how many ordered items customers kept.
  • Plan inventory replenishment based on net items moving out of stock.
Metric (Count)
Quantity orderedNumber of items ordered, excluding reversed quantity
  • Track initial demand for products before returns impact the data.
  • Plan inventory levels based on ordering patterns before returns.
Total units ordered, excluding reversed quantity. Useful for inventory planning.Metric (Count)
Reversed quantityNumber of items returned for the given sale
  • Account for expected returns during inventory planning.
  • Identify products, customer segments, or order attributes with high return rates.
Metric (Count)
Product titleDisplay name of the product that your customers view
  • Focus your marketing budget on the product names that sell best.
  • Rewrite low-performing product titles to improve click-through rates and conversions.
'Product title' displays the current name in your catalog. 'Product title at time of sale' preserves the historical name when the order was placed, which is useful when product names change over time.Dimension
Product variant titleDisplay name of the product variant
  • Review your most popular variants and use them for your marketing.
  • Refine your product and inventory strategy based on what variants sell best.
Specific size/color/style. Use for granular inventory analysis.Dimension
UTM sourceUTM source of the campaign that led to the online store visit
  • Track which traffic sources from your campaigns perform best.
  • Focus marketing spend on sources that drive quality traffic.
Where traffic came from (google, facebook, newsletter). Requires UTM tagging.Dimension
UTM campaignUTM name of the campaign that led to the online store visit
  • Track which campaigns drive the most traffic to your online store.
  • Compare conversion rates across different campaign types.
Which campaign drove the traffic. Requires consistent UTM naming conventions.Dimension
Referrer sourceReferrer type that led to the online store visit (organic, email, and others)
  • Focus marketing budget on the channels that drive the most traffic.
  • Compare conversion rates across different traffic sources.
Automatically detected traffic source. More reliable than UTM for organic traffic.Dimension
New or returning customerLabel specifying whether an order is from a new or returning customer
  • Segment marketing campaigns based on customer purchase history.
  • Track the balance between customer acquisition and retention efforts.
Use as filter to compare new vs returning customer behavior.Dimension

B2B

Company profiles and wholesale purchasing patterns, including bulk orders and business customer behavior.

Table containing a list of all B2B analytics fields.
NameDescriptionUsesNotesType
Company IDShopify identifier for the company
  • Track business account performance to focus sales efforts on high-value companies.
  • Connect company data across reports for complete B2B customer analysis.
Dimension
Company location IDShopify identifier for the company location
  • Plan territory-based sales strategies for multi-location business customers.
  • Connect location-specific data for comprehensive business account analysis.
Dimension
Company location nameName of the company location
  • Focus B2B sales efforts on the highest-performing business locations.
  • Plan logistics and fulfillment strategies for different business customer sites.
Dimension
Company nameName of the company
  • Develop account-based marketing strategies for your most valuable business customers.
  • Track business customer purchasing patterns to predict reorder timing.
Dimension
Is B2B orderLabel for whether the order is a B2B order
  • Optimize fulfillment workflows for larger B2B orders.
  • Adjust pricing and payment terms for your B2B customers.
Dimension

Customers

Customer segments and purchase history, including cohort analysis and repeat purchase patterns.

Table containing a list of all customer analytics fields.
NameDescriptionUsesNotesType
Amount spent per customerAverage cumulative amount customers in the given cohort have spent at your store
  • Set VIP program thresholds based on typical customer spending levels.
  • Calculate how much you can afford to spend acquiring new customers.
Metric (Money average)
Customers in cohort (cohort period totals)Number of customers in the given cohort
  • Shift marketing budget to acquisition channels that bring higher-spending customers.
  • Plan seasonal inventory based on cohorts that spend more during specific periods.
Metric (Money average)
Amount spent per customer (periods since first purchase totals)Average cumulative amount customers in the given cohort have spent at your store
  • Time upsell campaigns for when customers typically increase their spending.
  • Set loyalty program rewards to trigger during high-spending periods.
Metric (Money average)
Customers in cohort (totals)Number of customers in the given cohort
  • Set sustainable customer acquisition budgets based on lifetime value.
  • Create tiered service levels for customers with different spending patterns.
Metric (Money average)
Average order valueAverage value of orders placed by customers in the given cohort
  • Focus acquisition spending on channels that bring customers who place larger orders.
  • Adjust product bundling strategies for different customer segments.
Metric (Money average)
Average order value (cohort period totals)Average value of orders placed by customers in the given cohort
  • Launch bundle promotions during periods when order values typically decline.
  • Plan inventory mix for cohorts with different purchasing patterns.
Metric (Money average)
Average order value (periods since first purchase totals)Average value of orders placed by customers in the given cohort
  • Time cross-sell offers for when customers typically buy more items.
  • Set free shipping thresholds based on natural order size progression.
Metric (Money average)
Average order value (totals)Average value of orders placed by customers in the given cohort
  • Set minimum order promotions that align with customer spending habits.
  • Design product bundles that match typical purchasing patterns.
Metric (Money average)
Cumulative gross salesCumulative gross sales from customers in the given cohort
  • Forecast future revenue based on how past cohorts performed.
  • Justify marketing spend by showing long-term revenue from each acquisition channel.
Metric (Money total)
Cumulative gross sales (periods since first purchase totals)Cumulative gross sales from customers in the given cohort
  • Plan cash flow based on when cohorts typically generate the most revenue.
  • Invest more in retention for cohorts approaching their peak spending period.
Metric (Money total)
Cumulative net salesCumulative net sales from customers in the given cohort
  • Calculate true ROI on customer acquisition after accounting for discounts and returns.
  • Set realistic revenue targets based on historical net performance.
Metric (Money total)
Cumulative net sales (periods since first purchase totals)Cumulative net sales from customers in the given cohort
  • Determine when customer acquisition costs pay back through net revenue.
  • Plan discount strategies that don't hurt long-term profitability.
Metric (Money total)
Cumulative total salesCumulative total sales from customers in the given cohort
  • Justify acquisition costs by showing complete customer value including fees.
  • Plan business growth based on total revenue potential per cohort.
Metric (Money total)
Cumulative total sales (periods since first purchase totals)Cumulative total sales from customers in the given cohort
  • Design loyalty programs that reward customers at their most valuable periods.
  • Calculate break-even timeframes for customer acquisition investments.
Metric (Money total)
Customer retention ratePercentage of customers in the given cohort who placed an order in the given period
  • Set retention improvement targets and track progress over time.
  • Benchmark your customer loyalty against industry standards.
Metric (Percentage & rate)
Customer retention rate (cohort period totals)Percentage of customers in the given cohort who placed an order in the given period
  • Double down on acquisition strategies that bring customers who stay longer.
  • Launch win-back campaigns for cohorts showing declining retention.
Metric (Percentage & rate)
Customer retention rate (periods since first purchase totals)Percentage of customers in the given cohort who placed an order in the given period
  • Send retention offers before customers typically stop buying.
  • Plan customer service touchpoints during critical churn periods.
Metric (Percentage & rate)
Customer retention rate (totals)Percentage of customers in the given cohort who placed an order in the given period
  • Calculate the revenue impact of improving retention by even small percentages.
  • Prioritize retention investments over acquisition when retention is low.
Metric (Percentage & rate)
CustomersNumber of customers in the given cohort who placed an order
  • Focus acquisition efforts on periods that historically bring the most customers.
  • Plan staffing and inventory for cohorts of different sizes.
Metric (Count)
Customers (cohort period totals)Number of customers in the given cohort who placed an order
  • Launch retention campaigns for cohorts showing unusual growth or decline patterns.
  • Adjust product development priorities based on cohort engagement trends.
Metric (Count)
Customers in cohortNumber of customers in the given cohort
  • Increase marketing spend during periods that historically acquire more customers.
  • Plan operational capacity based on expected cohort sizes.
Metric (Count)
Customers in cohort (periods since first purchase totals)Number of customers in the given cohort
  • Forecast support needs based on how many customers remain active at each stage.
  • Plan retention investments for customer lifecycle stages with high activity.
Metric (Count)
Customers (periods since first purchase totals)Number of customers in the given cohort who placed an order
  • Plan customer service capacity based on active customer lifecycle stages.
  • Optimize communication frequency for customers at different maturity levels.
Metric (Count)
Customers (totals)Number of customers in the given cohort who placed an order
  • Calculate customer acquisition efficiency across different time periods.
  • Plan growth targets based on historical customer acquisition rates.
Metric (Count)
Gross salesSales revenue, before discounts and sales reversals are factored in, from customers in the given cohort
  • Reduce discount dependency for cohorts that buy regularly at full price.
  • Focus premium product marketing on cohorts with strong full-price demand.
Metric (Money total)
Gross sales (cohort period totals)Sales revenue, before discounts and sales reversals are factored in, from customers in the given cohort
  • Launch premium products during periods when cohorts spend more at full price.
  • Plan inventory investment for cohorts that consistently avoid sales and discounts.
Metric (Money total)
Gross sales (periods since first purchase totals)Sales revenue, before discounts and sales reversals are factored in, from customers in the given cohort
  • Time new product launches for when customers typically pay full price.
  • Avoid heavy discounting during customer lifecycle stages with strong full-price demand.
Metric (Money total)
Gross sales (totals)Sales revenue, before discounts and sales reversals are factored in, from customers in the given cohort
  • Focus acquisition on channels that bring customers who avoid discounts.
  • Design pricing strategies based on cohort willingness to pay full price.
Metric (Money total)
Net salesSales revenue, with discounts and sales reversals factored in, from customers in the given cohort
  • Reduce promotional spending for cohorts with healthy net revenue.
  • Improve product quality for cohorts with high return rates.
Metric (Money total)
Net sales (cohort period totals)Sales revenue, with discounts and sales reversals factored in, from customers in the given cohort
  • Adjust discount strategies for cohorts that erode profitability over time.
  • Focus customer service on cohorts with declining net revenue trends.
Metric (Money total)
Net sales (periods since first purchase totals)Sales revenue, with discounts and sales reversals factored in, from customers in the given cohort
  • Plan profitable growth by focusing on high net revenue lifecycle stages.
  • Time retention offers to avoid periods when discounts typically increase.
Metric (Money total)
Net sales (totals)Sales revenue, with discounts and sales reversals factored in, from customers in the given cohort
  • Prioritize acquisition channels that deliver the highest long-term profitability.
  • Set realistic growth targets based on true customer profitability.
Metric (Money total)
Order valueValue of orders placed by customers in the given cohort
  • Create targeted offers for cohorts with different spending capacities.
  • Adjust payment options for cohorts with larger typical order sizes.
Metric (Money total)
Order value (cohort period totals)Value of orders placed by customers in the given cohort
  • Launch upsell campaigns during periods when cohorts increase spending.
  • Plan premium product releases for high-spending cohort periods.
Metric (Money total)
Order value (periods since first purchase totals)Value of orders placed by customers in the given cohort
  • Set volume discount thresholds based on natural order size growth.
  • Plan inventory depth for customer lifecycle stages with larger orders.
Metric (Money total)
Order value (totals)Value of orders placed by customers in the given cohort
  • Design shipping policies that match typical customer order patterns.
  • Set product recommendation thresholds based on spending capacity.
Metric (Money total)
OrdersNumber of orders placed by customers in the given cohort
  • Focus retention efforts on acquisition channels that produce frequent customers.
  • Plan subscription offerings for cohorts with high purchase frequency.
Metric (Count)
Orders (cohort period totals)Number of orders placed by customers in the given cohort
  • Send re-engagement campaigns to cohorts showing declining order rates.
  • Increase inventory turnover planning for high-frequency purchasing cohorts.
Metric (Count)
Orders per customerAverage number of orders placed by customers in the given cohort
  • Set loyalty program rewards that encourage more frequent purchases.
  • Improve product recommendations for customers with low purchase frequency.
Metric (Count ratio)
Orders per customer (cohort period totals)Average number of orders placed by customers in the given cohort
  • Launch frequency-boosting campaigns for cohorts with declining purchase rates.
  • Develop subscription products for cohorts with naturally high order frequency.
Metric (Count ratio)
Orders per customer (periods since first purchase totals)Average number of orders placed by customers in the given cohort
  • Send targeted offers during typical low-frequency periods.
  • Plan customer lifecycle communications around natural purchase rhythms.
Metric (Count ratio)
Orders per customer (totals)Average number of orders placed by customers in the given cohort
  • Design loyalty programs that reward your most frequent customers appropriately.
  • Focus retention spending on customer segments with high lifetime order counts.
Metric (Count ratio)
Orders (periods since first purchase totals)Number of orders placed by customers in the given cohort
  • Plan inventory replenishment based on expected order patterns from maturing cohorts.
  • Send replenishment reminders based on typical purchase intervals.
Metric (Count)
Orders (totals)Number of orders placed by customers in the given cohort
  • Focus acquisition budget on channels that drive the most repeat business.
  • Plan fulfillment capacity based on total order volume from each cohort.
Metric (Count)
Amount spent per customerAverage cumulative amount customers in the given cohort have spent at your storeSet VIP program thresholds based on typical customer spending levels. Calculate how much you can afford to spend acquiring new customers. Metric (Money average)
Amount spent per customer (cohort period totals)Average cumulative amount customers in the given cohort have spent at your storeShift marketing budget to acquisition channels that bring higher-spending customers. Plan seasonal inventory based on cohorts that spend more during specific periods. Metric (Money average)
Amount spent per customer (periods since first purchase totals)Average cumulative amount customers in the given period since first purchase have spent at your storeTime upsell campaigns for when customers typically increase their spending. Set loyalty program rewards to trigger during high-spending periods. Metric (Money average)
Amount spent per customer (totals)Average cumulative amount customers in the given time range have spent at your storeSet sustainable customer acquisition budgets based on lifetime value. Create tiered service levels for customers with different spending patterns. Metric (Money average)
Cumulative total salesCumulative total sales from customers in the given cohortJustify acquisition costs by showing complete customer value including fees. Plan business growth based on total revenue potential per cohort. Metric (Money total)
CustomersNumber of customers in the given cohortTrack customer acquisition and retention across different time periods. Set customer acquisition goals and budget allocation based on historical performance. Metric (Count)
Customers (cohort period totals)Number of customers in the given cohort who placed an orderLaunch retention campaigns for cohorts showing unusual growth or decline patterns. Adjust product development priorities based on cohort engagement trends. Metric (Count)
Customers (totals)Number of customers in the given cohort who placed an orderCalculate customer acquisition efficiency across different time periods. Plan growth targets based on historical customer acquisition rates. Metric (Count)
Is predictiveLabel specifying whether the row contains a predictive valueFocus on data points that help forecast future business performance. Plan business strategies based on predicted versus current performance. Metric (Boolean)
Total salesAmount spent (subtotal, taxes, shipping, sales reversals, discounts, fees, and more), from customers in the given cohort
  • Calculate true customer value including all revenue components for pricing decisions.
  • Plan business growth based on complete revenue potential per customer segment.
Metric (Money total)
Total sales (cohort period totals)Amount spent (subtotal, taxes, shipping, sales reversals, discounts, fees, and more), from customers in the given cohort
  • Time major business investments based on cohort revenue peaks.
  • Plan cash flow around periods when cohorts contribute the most total revenue.
Metric (Money total)
Total sales (periods since first purchase totals)Amount spent (subtotal, taxes, shipping, sales reversals, discounts, fees, and more), from customers in the given cohort
  • Focus customer experience investments on high total revenue lifecycle stages.
  • Plan business expansion based on expected total revenue from customer maturation.
Metric (Money total)
Total sales (totals)Amount spent (subtotal, taxes, shipping, sales reversals, discounts, fees, and more), from customers in the given cohort
  • Set acquisition budgets based on complete lifetime value including all fees.
  • Compare channels based on total customer contribution to business growth.
Metric (Money total)
Amount spent per customerAverage cumulative amount customers in the given cohort have spent at your store
  • Set VIP program thresholds based on typical customer spending levels.
  • Calculate how much you can afford to spend acquiring new customers.
Metric (Money average)
Customers in cohort (cohort period totals)Number of customers in the given cohort
  • Shift marketing budget to acquisition channels that bring higher-spending customers.
  • Plan seasonal inventory based on cohorts that spend more during specific periods.
Metric (Money average)
Amount spent per customer (periods since first purchase totals)Average cumulative amount customers in the given cohort have spent at your store
  • Time upsell campaigns for when customers typically increase their spending.
  • Set loyalty program rewards to trigger during high-spending periods.
Metric (Money average)
Customers in cohort (totals)Number of customers in the given cohort
  • Set sustainable customer acquisition budgets based on lifetime value.
  • Create tiered service levels for customers with different spending patterns.
Metric (Money average)
Average order valueAverage value of orders placed by customers in the given cohort
  • Focus acquisition spending on channels that bring customers who place larger orders.
  • Adjust product bundling strategies for different customer segments.
Metric (Money average)
Average order value (cohort period totals)Average value of orders placed by customers in the given cohort
  • Launch bundle promotions during periods when order values typically decline.
  • Plan inventory mix for cohorts with different purchasing patterns.
Metric (Money average)
Average order value (periods since first purchase totals)Average value of orders placed by customers in the given cohort
  • Time cross-sell offers for when customers typically buy more items.
  • Set free shipping thresholds based on natural order size progression.
Metric (Money average)
Average order value (totals)Average value of orders placed by customers in the given cohort
  • Set minimum order promotions that align with customer spending habits.
  • Design product bundles that match typical purchasing patterns.
Metric (Money average)
Cumulative gross salesCumulative gross sales from customers in the given cohort
  • Forecast future revenue based on how past cohorts performed.
  • Justify marketing spend by showing long-term revenue from each acquisition channel.
Metric (Money total)
Cumulative gross sales (periods since first purchase totals)Cumulative gross sales from customers in the given cohort
  • Plan cash flow based on when cohorts typically generate the most revenue.
  • Invest more in retention for cohorts approaching their peak spending period.
Metric (Money total)
Cumulative net salesCumulative net sales from customers in the given cohort
  • Calculate true ROI on customer acquisition after accounting for discounts and returns.
  • Set realistic revenue targets based on historical net performance.
Metric (Money total)
Cumulative net sales (periods since first purchase totals)Cumulative net sales from customers in the given cohort
  • Determine when customer acquisition costs pay back through net revenue.
  • Plan discount strategies that don't hurt long-term profitability.
Metric (Money total)
Cumulative total salesCumulative total sales from customers in the given cohort
  • Justify acquisition costs by showing complete customer value including fees.
  • Plan business growth based on total revenue potential per cohort.
Metric (Money total)
Cumulative total sales (periods since first purchase totals)Cumulative total sales from customers in the given cohort
  • Design loyalty programs that reward customers at their most valuable periods.
  • Calculate break-even timeframes for customer acquisition investments.
Metric (Money total)
Customer retention ratePercentage of customers in the given cohort who placed an order in the given period
  • Set retention improvement targets and track progress over time.
  • Benchmark your customer loyalty against industry standards.
Metric (Percentage & rate)
Customer retention rate (cohort period totals)Percentage of customers in the given cohort who placed an order in the given period
  • Double down on acquisition strategies that bring customers who stay longer.
  • Launch win-back campaigns for cohorts showing declining retention.
Metric (Percentage & rate)
Customer retention rate (periods since first purchase totals)Percentage of customers in the given cohort who placed an order in the given period
  • Send retention offers before customers typically stop buying.
  • Plan customer service touchpoints during critical churn periods.
Metric (Percentage & rate)
Customer retention rate (totals)Percentage of customers in the given cohort who placed an order in the given period
  • Calculate the revenue impact of improving retention by even small percentages.
  • Prioritize retention investments over acquisition when retention is low.
Metric (Percentage & rate)
CustomersNumber of customers in the given cohort who placed an order
  • Focus acquisition efforts on periods that historically bring the most customers.
  • Plan staffing and inventory for cohorts of different sizes.
Metric (Count)
Customers (cohort period totals)Number of customers in the given cohort who placed an order
  • Launch retention campaigns for cohorts showing unusual growth or decline patterns.
  • Adjust product development priorities based on cohort engagement trends.
Metric (Count)
Customers in cohortNumber of customers in the given cohort
  • Increase marketing spend during periods that historically acquire more customers.
  • Plan operational capacity based on expected cohort sizes.
Metric (Count)
Customers in cohort (periods since first purchase totals)Number of customers in the given cohort
  • Forecast support needs based on how many customers remain active at each stage.
  • Plan retention investments for customer lifecycle stages with high activity.
Metric (Count)
Customers (periods since first purchase totals)Number of customers in the given cohort who placed an order
  • Plan customer service capacity based on active customer lifecycle stages.
  • Optimize communication frequency for customers at different maturity levels.
Metric (Count)
Customers (totals)Number of customers in the given cohort who placed an order
  • Calculate customer acquisition efficiency across different time periods.
  • Plan growth targets based on historical customer acquisition rates.
Metric (Count)
Gross salesSales revenue, before discounts and sales reversals are factored in, from customers in the given cohort
  • Reduce discount dependency for cohorts that buy regularly at full price.
  • Focus premium product marketing on cohorts with strong full-price demand.
Metric (Money total)
Gross sales (cohort period totals)Sales revenue, before discounts and sales reversals are factored in, from customers in the given cohort
  • Launch premium products during periods when cohorts spend more at full price.
  • Plan inventory investment for cohorts that consistently avoid sales and discounts.
Metric (Money total)
Gross sales (periods since first purchase totals)Sales revenue, before discounts and sales reversals are factored in, from customers in the given cohort
  • Time new product launches for when customers typically pay full price.
  • Avoid heavy discounting during customer lifecycle stages with strong full-price demand.
Metric (Money total)
Gross sales (totals)Sales revenue, before discounts and sales reversals are factored in, from customers in the given cohort
  • Focus acquisition on channels that bring customers who avoid discounts.
  • Design pricing strategies based on cohort willingness to pay full price.
Metric (Money total)
Net salesSales revenue, with discounts and sales reversals factored in, from customers in the given cohort
  • Reduce promotional spending for cohorts with healthy net revenue.
  • Improve product quality for cohorts with high return rates.
Metric (Money total)
Net sales (cohort period totals)Sales revenue, with discounts and sales reversals factored in, from customers in the given cohort
  • Adjust discount strategies for cohorts that erode profitability over time.
  • Focus customer service on cohorts with declining net revenue trends.
Metric (Money total)
Net sales (periods since first purchase totals)Sales revenue, with discounts and sales reversals factored in, from customers in the given cohort
  • Plan profitable growth by focusing on high net revenue lifecycle stages.
  • Time retention offers to avoid periods when discounts typically increase.
Metric (Money total)
Net sales (totals)Sales revenue, with discounts and sales reversals factored in, from customers in the given cohort
  • Prioritize acquisition channels that deliver the highest long-term profitability.
  • Set realistic growth targets based on true customer profitability.
Metric (Money total)
Order valueValue of orders placed by customers in the given cohort
  • Create targeted offers for cohorts with different spending capacities.
  • Adjust payment options for cohorts with larger typical order sizes.
Metric (Money total)
Order value (cohort period totals)Value of orders placed by customers in the given cohort
  • Launch upsell campaigns during periods when cohorts increase spending.
  • Plan premium product releases for high-spending cohort periods.
Metric (Money total)
Order value (periods since first purchase totals)Value of orders placed by customers in the given cohort
  • Set volume discount thresholds based on natural order size growth.
  • Plan inventory depth for customer lifecycle stages with larger orders.
Metric (Money total)
Order value (totals)Value of orders placed by customers in the given cohort
  • Design shipping policies that match typical customer order patterns.
  • Set product recommendation thresholds based on spending capacity.
Metric (Money total)
OrdersNumber of orders placed by customers in the given cohort
  • Focus retention efforts on acquisition channels that produce frequent customers.
  • Plan subscription offerings for cohorts with high purchase frequency.
Metric (Count)
Orders (cohort period totals)Number of orders placed by customers in the given cohort
  • Send re-engagement campaigns to cohorts showing declining order rates.
  • Increase inventory turnover planning for high-frequency purchasing cohorts.
Metric (Count)
Orders per customerAverage number of orders placed by customers in the given cohort
  • Set loyalty program rewards that encourage more frequent purchases.
  • Improve product recommendations for customers with low purchase frequency.
Metric (Count ratio)
Orders per customer (cohort period totals)Average number of orders placed by customers in the given cohort
  • Launch frequency-boosting campaigns for cohorts with declining purchase rates.
  • Develop subscription products for cohorts with naturally high order frequency.
Metric (Count ratio)
Orders per customer (periods since first purchase totals)Average number of orders placed by customers in the given cohort
  • Send targeted offers during typical low-frequency periods.
  • Plan customer lifecycle communications around natural purchase rhythms.
Metric (Count ratio)
Orders per customer (totals)Average number of orders placed by customers in the given cohort
  • Design loyalty programs that reward your most frequent customers appropriately.
  • Focus retention spending on customer segments with high lifetime order counts.
Metric (Count ratio)
Orders (periods since first purchase totals)Number of orders placed by customers in the given cohort
  • Plan inventory replenishment based on expected order patterns from maturing cohorts.
  • Send replenishment reminders based on typical purchase intervals.
Metric (Count)
Orders (totals)Number of orders placed by customers in the given cohort
  • Focus acquisition budget on channels that drive the most repeat business.
  • Plan fulfillment capacity based on total order volume from each cohort.
Metric (Count)
Total salesAmount spent (subtotal, taxes, shipping, sales reversals, discounts, fees, and more), from customers in the given cohort
  • Calculate true customer value including all revenue components for pricing decisions.
  • Plan business growth based on complete revenue potential per customer segment.
Metric (Money total)
Total sales (cohort period totals)Amount spent (subtotal, taxes, shipping, sales reversals, discounts, fees, and more), from customers in the given cohort
  • Time major business investments based on cohort revenue peaks.
  • Plan cash flow around periods when cohorts contribute the most total revenue.
Metric (Money total)
Total sales (periods since first purchase totals)Amount spent (subtotal, taxes, shipping, sales reversals, discounts, fees, and more), from customers in the given cohort
  • Focus customer experience investments on high total revenue lifecycle stages.
  • Plan business expansion based on expected total revenue from customer maturation.
Metric (Money total)
Total sales (totals)Amount spent (subtotal, taxes, shipping, sales reversals, discounts, fees, and more), from customers in the given cohort
  • Set acquisition budgets based on complete lifetime value including all fees.
  • Compare channels based on total customer contribution to business growth.
Metric (Money total)
Amount spent per customerAverage cumulative amount customers in the given cohort have spent at your store
  • Set VIP program thresholds based on typical customer spending levels.
  • Calculate how much you can afford to spend acquiring new customers.
Metric (Money average)
Customers in cohort (cohort period totals)Number of customers in the given cohort
  • Shift marketing budget to acquisition channels that bring higher-spending customers.
  • Plan seasonal inventory based on cohorts that spend more during specific periods.
Metric (Money average)
Amount spent per customer (periods since first purchase totals)Average cumulative amount customers in the given cohort have spent at your store
  • Time upsell campaigns for when customers typically increase their spending.
  • Set loyalty program rewards to trigger during high-spending periods.
Metric (Money average)
Customers in cohort (totals)Number of customers in the given cohort
  • Set sustainable customer acquisition budgets based on lifetime value.
  • Create tiered service levels for customers with different spending patterns.
Metric (Money average)
Average order valueAverage value of orders placed by customers in the given cohort
  • Focus acquisition spending on channels that bring customers who place larger orders.
  • Adjust product bundling strategies for different customer segments.
Metric (Money average)
Average order value (cohort period totals)Average value of orders placed by customers in the given cohort
  • Launch bundle promotions during periods when order values typically decline.
  • Plan inventory mix for cohorts with different purchasing patterns.
Metric (Money average)
Average order value (periods since first purchase totals)Average value of orders placed by customers in the given cohort
  • Time cross-sell offers for when customers typically buy more items.
  • Set free shipping thresholds based on natural order size progression.
Metric (Money average)
Average order value (totals)Average value of orders placed by customers in the given cohort
  • Set minimum order promotions that align with customer spending habits.
  • Design product bundles that match typical purchasing patterns.
Metric (Money average)
Cumulative gross salesCumulative gross sales from customers in the given cohort
  • Forecast future revenue based on how past cohorts performed.
  • Justify marketing spend by showing long-term revenue from each acquisition channel.
Metric (Money total)
Cumulative gross sales (periods since first purchase totals)Cumulative gross sales from customers in the given cohort
  • Plan cash flow based on when cohorts typically generate the most revenue.
  • Invest more in retention for cohorts approaching their peak spending period.
Metric (Money total)
Cumulative net salesCumulative net sales from customers in the given cohort
  • Calculate true ROI on customer acquisition after accounting for discounts and returns.
  • Set realistic revenue targets based on historical net performance.
Metric (Money total)
Cumulative net sales (periods since first purchase totals)Cumulative net sales from customers in the given cohort
  • Determine when customer acquisition costs pay back through net revenue.
  • Plan discount strategies that don't hurt long-term profitability.
Metric (Money total)
Cumulative total salesCumulative total sales from customers in the given cohort
  • Justify acquisition costs by showing complete customer value including fees.
  • Plan business growth based on total revenue potential per cohort.
Metric (Money total)
Cumulative total sales (periods since first purchase totals)Cumulative total sales from customers in the given cohort
  • Design loyalty programs that reward customers at their most valuable periods.
  • Calculate break-even timeframes for customer acquisition investments.
Metric (Money total)
Customer retention ratePercentage of customers in the given cohort who placed an order in the given period
  • Set retention improvement targets and track progress over time.
  • Benchmark your customer loyalty against industry standards.
Metric (Percentage & rate)
Customer retention rate (cohort period totals)Percentage of customers in the given cohort who placed an order in the given period
  • Double down on acquisition strategies that bring customers who stay longer.
  • Launch win-back campaigns for cohorts showing declining retention.
Metric (Percentage & rate)
Customer retention rate (periods since first purchase totals)Percentage of customers in the given cohort who placed an order in the given period
  • Send retention offers before customers typically stop buying.
  • Plan customer service touchpoints during critical churn periods.
Metric (Percentage & rate)
Customer retention rate (totals)Percentage of customers in the given cohort who placed an order in the given period
  • Calculate the revenue impact of improving retention by even small percentages.
  • Prioritize retention investments over acquisition when retention is low.
Metric (Percentage & rate)
CustomersNumber of customers in the given cohort who placed an order
  • Focus acquisition efforts on periods that historically bring the most customers.
  • Plan staffing and inventory for cohorts of different sizes.
Metric (Count)
Customers (cohort period totals)Number of customers in the given cohort who placed an order
  • Launch retention campaigns for cohorts showing unusual growth or decline patterns.
  • Adjust product development priorities based on cohort engagement trends.
Metric (Count)
Customers in cohortNumber of customers in the given cohort
  • Increase marketing spend during periods that historically acquire more customers.
  • Plan operational capacity based on expected cohort sizes.
Metric (Count)
Customers in cohort (periods since first purchase totals)Number of customers in the given cohort
  • Forecast support needs based on how many customers remain active at each stage.
  • Plan retention investments for customer lifecycle stages with high activity.
Metric (Count)
Customers (periods since first purchase totals)Number of customers in the given cohort who placed an order
  • Plan customer service capacity based on active customer lifecycle stages.
  • Optimize communication frequency for customers at different maturity levels.
Metric (Count)
Customers (totals)Number of customers in the given cohort who placed an order
  • Calculate customer acquisition efficiency across different time periods.
  • Plan growth targets based on historical customer acquisition rates.
Metric (Count)
Gross salesSales revenue, before discounts and sales reversals are factored in, from customers in the given cohort
  • Reduce discount dependency for cohorts that buy regularly at full price.
  • Focus premium product marketing on cohorts with strong full-price demand.
Metric (Money total)
Gross sales (cohort period totals)Sales revenue, before discounts and sales reversals are factored in, from customers in the given cohort
  • Launch premium products during periods when cohorts spend more at full price.
  • Plan inventory investment for cohorts that consistently avoid sales and discounts.
Metric (Money total)
Gross sales (periods since first purchase totals)Sales revenue, before discounts and sales reversals are factored in, from customers in the given cohort
  • Time new product launches for when customers typically pay full price.
  • Avoid heavy discounting during customer lifecycle stages with strong full-price demand.
Metric (Money total)
Gross sales (totals)Sales revenue, before discounts and sales reversals are factored in, from customers in the given cohort
  • Focus acquisition on channels that bring customers who avoid discounts.
  • Design pricing strategies based on cohort willingness to pay full price.
Metric (Money total)
Net salesSales revenue, with discounts and sales reversals factored in, from customers in the given cohort
  • Reduce promotional spending for cohorts with healthy net revenue.
  • Improve product quality for cohorts with high return rates.
Metric (Money total)
Net sales (cohort period totals)Sales revenue, with discounts and sales reversals factored in, from customers in the given cohort
  • Adjust discount strategies for cohorts that erode profitability over time.
  • Focus customer service on cohorts with declining net revenue trends.
Metric (Money total)
Net sales (periods since first purchase totals)Sales revenue, with discounts and sales reversals factored in, from customers in the given cohort
  • Plan profitable growth by focusing on high net revenue lifecycle stages.
  • Time retention offers to avoid periods when discounts typically increase.
Metric (Money total)
Net sales (totals)Sales revenue, with discounts and sales reversals factored in, from customers in the given cohort
  • Prioritize acquisition channels that deliver the highest long-term profitability.
  • Set realistic growth targets based on true customer profitability.
Metric (Money total)
Order valueValue of orders placed by customers in the given cohort
  • Create targeted offers for cohorts with different spending capacities.
  • Adjust payment options for cohorts with larger typical order sizes.
Metric (Money total)
Order value (cohort period totals)Value of orders placed by customers in the given cohort
  • Launch upsell campaigns during periods when cohorts increase spending.
  • Plan premium product releases for high-spending cohort periods.
Metric (Money total)
Order value (periods since first purchase totals)Value of orders placed by customers in the given cohort
  • Set volume discount thresholds based on natural order size growth.
  • Plan inventory depth for customer lifecycle stages with larger orders.
Metric (Money total)
Order value (totals)Value of orders placed by customers in the given cohort
  • Design shipping policies that match typical customer order patterns.
  • Set product recommendation thresholds based on spending capacity.
Metric (Money total)
OrdersNumber of orders placed by customers in the given cohort
  • Focus retention efforts on acquisition channels that produce frequent customers.
  • Plan subscription offerings for cohorts with high purchase frequency.
Metric (Count)
Orders (cohort period totals)Number of orders placed by customers in the given cohort
  • Send re-engagement campaigns to cohorts showing declining order rates.
  • Increase inventory turnover planning for high-frequency purchasing cohorts.
Metric (Count)
Orders per customerAverage number of orders placed by customers in the given cohort
  • Set loyalty program rewards that encourage more frequent purchases.
  • Improve product recommendations for customers with low purchase frequency.
Metric (Count ratio)
Orders per customer (cohort period totals)Average number of orders placed by customers in the given cohort
  • Launch frequency-boosting campaigns for cohorts with declining purchase rates.
  • Develop subscription products for cohorts with naturally high order frequency.
Metric (Count ratio)
Orders per customer (periods since first purchase totals)Average number of orders placed by customers in the given cohort
  • Send targeted offers during typical low-frequency periods.
  • Plan customer lifecycle communications around natural purchase rhythms.
Metric (Count ratio)
Orders per customer (totals)Average number of orders placed by customers in the given cohort
  • Design loyalty programs that reward your most frequent customers appropriately.
  • Focus retention spending on customer segments with high lifetime order counts.
Metric (Count ratio)
Orders (periods since first purchase totals)Number of orders placed by customers in the given cohort
  • Plan inventory replenishment based on expected order patterns from maturing cohorts.
  • Send replenishment reminders based on typical purchase intervals.
Metric (Count)
Orders (totals)Number of orders placed by customers in the given cohort
  • Focus acquisition budget on channels that drive the most repeat business.
  • Plan fulfillment capacity based on total order volume from each cohort.
Metric (Count)
Total salesAmount spent (subtotal, taxes, shipping, sales reversals, discounts, fees, and more), from customers in the given cohort
  • Calculate true customer value including all revenue components for pricing decisions.
  • Plan business growth based on complete revenue potential per customer segment.
Metric (Money total)
Total sales (cohort period totals)Amount spent (subtotal, taxes, shipping, sales reversals, discounts, fees, and more), from customers in the given cohort
  • Time major business investments based on cohort revenue peaks.
  • Plan cash flow around periods when cohorts contribute the most total revenue.
Metric (Money total)
Total sales (periods since first purchase totals)Amount spent (subtotal, taxes, shipping, sales reversals, discounts, fees, and more), from customers in the given cohort
  • Focus customer experience investments on high total revenue lifecycle stages.
  • Plan business expansion based on expected total revenue from customer maturation.
Metric (Money total)
Total sales (totals)Amount spent (subtotal, taxes, shipping, sales reversals, discounts, fees, and more), from customers in the given cohort
  • Set acquisition budgets based on complete lifetime value including all fees.
  • Compare channels based on total customer contribution to business growth.
Metric (Money total)
Days since last orderNumber of days since the customer's last order
  • Launch automated win-back campaigns before customers churn completely.
  • Focus retention offers on customers showing early signs of disengagement.
Metric (Duration (days))
New customer recordsNumber of customers whose first purchase is within the given time period
  • Plan onboarding capacity based on customer acquisition growth.
  • Track customer acquisition success against your growth targets.
Metric (Count)
Percent of customersPercentage of all your customers who fall into this group
  • Focus marketing efforts on growing your most valuable customer segments.
  • Plan business strategies around your largest customer groups.
Metric (Percentage & rate)
Total amount spentAmount the customer has spent across all time
  • Set VIP program thresholds based on actual customer spending levels.
  • Calculate sustainable customer acquisition costs based on lifetime value.
Metric (Money total)
Total amount spent per orderAverage amount the customer has spent per order
Formula: total amount spent / total customer orders
  • Set free shipping and discount thresholds that match customer spending habits.
  • Plan product bundling strategies based on typical order values.
Metric (Money average)
Total number of ordersNumber of orders the customer has placed across all time
  • Design loyalty programs that reward your most frequent customers appropriately.
  • Focus retention efforts on customer segments with high engagement potential.
Metric (Count)
Abandoned checkout dateDate the customer most recently abandoned a cart
  • Plan cart abandonment email campaigns with optimal timing.
  • Identify customers who need follow-up to complete their purchases.
Dimension
Customer account statusStatus of the customer's account
  • Track customer onboarding progress and account activation rates.
  • Identify customers who need account assistance or re-engagement.
Dimension
Customer added dateDate the customer record was added
  • Analyze customer acquisition trends and growth patterns over time.
  • Plan customer lifecycle marketing based on how long they've been customers.
Dimension
Customer amount spentAmount the customer has spent across all time
  • Identify your highest-value customers for premium service and offers.
  • Guide marketing investment decisions based on customer lifetime value.
Dimension
Customer citiesAll cities in the customer's history of addresses
  • Get the full picture of customers' ties to various cities.
  • Identify opportunities for local marketing and targeted city-based promotions.
Dimension
Customer cityIndividual cities in the customer's history of addresses
  • Analyze customer behavior patterns at the city level for local marketing.
  • Identify which cities drive the most valuable customer relationships.
Dimension
Customer cohort monthMonth the customer placed their first order
  • Analyze seasonal customer acquisition patterns and plan marketing accordingly.
  • Compare retention rates between customers acquired in different months.
Dimension
Customer cohort quarterQuarter the customer placed their first order
  • Track longer-term customer acquisition trends across business quarters.
  • Plan quarterly retention strategies based on customer acquisition timing.
Dimension
Customer cohort weekWeek the customer placed their first order
  • Evaluate acquisition-focused marketing efforts from different weeks.
  • Identify which weeks bring in customers with the highest lifetime value.
Dimension
Is placeholder rowLabel specifying whether the row is a blank placeholder for the purpose of maintaining the cohort table's shapeFilter out incomplete data to focus analysis on actionable insights. Identify data gaps that need attention for accurate reporting. Dimension
Months since first purchaseMonths from the customer's first order to the given orderPlan retention campaigns based on when customers typically need re-engagement. Time product recommendations for different customer lifecycle stages. Dimension
Months since first purchaseMonths from the customer's first order to the given orderPlan retention campaigns based on when customers typically need re-engagement. Time product recommendations for different customer lifecycle stages. Dimension
Is placeholder rowLabel specifying whether the row is a blank placeholder for the purpose of maintaining the cohort table's shapeFilter out incomplete data to focus analysis on actionable insights. Identify data gaps that need attention for accurate reporting. Dimension
Quarters since first purchaseQuarters from the customer's first order to the given orderPlan retention campaigns based on when customers typically need re-engagement. Time product recommendations for different customer lifecycle stages. Dimension
Is placeholder rowLabel specifying whether the row is a blank placeholder for the purpose of maintaining the cohort table's shapeFilter out incomplete data to focus analysis on actionable insights. Identify data gaps that need attention for accurate reporting. Dimension
Weeks since first purchaseWeeks from the customer's first order to the given orderPlan retention campaigns based on when customers typically need re-engagement. Time product recommendations for different customer lifecycle stages. Dimension
Customer countriesAll countries in the customer's history of addresses
  • Identify international customers and plan global expansion strategies.
  • Optimize international shipping policies based on customer location patterns.
Dimension
Customer emailEmail address of the customer
  • Plan targeted email marketing campaigns and customer communication.
  • Identify duplicate accounts and clean up your customer database.
Dimension
Customer email domainDomain of the customer's email address
  • Identify business customers versus personal shoppers for targeted marketing.
  • Spot potential fraud patterns and suspicious email domains.
Dimension
Customer email subscription statusEmail marketing subscription status of the customer
  • Stay compliant with email marketing regulations by respecting customer preferences.
  • Optimize campaign targeting by focusing on engaged, subscribed customers.
Dimension
Customer first order dateDate of the customer's first order
  • Track customer acquisition patterns over time to identify growth trends.
  • Plan retention campaigns based on how long customers have been with you.
Dimension
Customer IDShopify identifier for the customer
  • Connect customer data to other business records for detailed analysis.
  • Track individual customer performance and identify patterns.
Dimension
Customer languageLanguage associated with the customer
  • Optimize marketing messages and customer service in preferred languages.
  • Identify opportunities to expand into new markets.
Dimension
Customer last order dateDate of the customer's last order
  • Identify at-risk customers who haven't purchased recently.
  • Plan win-back campaigns for customers showing signs of churn.
Dimension
Customer nameFull name of the customer
  • Provide personalized customer service and build stronger relationships.
  • Analyze top customers by purchase value and frequency in reports.
Dimension
Customer number of ordersNumber of orders the customer has placed across all time
  • Identify your most loyal repeat customers for VIP treatment.
  • Segment customers by purchase frequency for targeted marketing.
Dimension
Customer regionIndividual states or provinces in the customer's history of addresses
  • Optimize marketing campaigns at the state or province level.
  • Plan regional fulfillment strategies based on customer shipping patterns.
Dimension
Customer regionsAll states or provinces in the customer's history of addresses
  • Get the full picture of customers' geographic connections.
  • Identify opportunities for local marketing and targeted city-based promotions.
Dimension
Customer SMS subscription statusThe customer's SMS marketing subscription status
  • Send SMS campaigns only to customers who want to receive them.
  • Identify opportunities to grow your SMS subscriber list from existing customers.
Dimension
Customer tagTag associated with the customer
  • Organize customers into groups such as VIP, wholesale, or newsletter subscribers for targeted marketing.
  • Track which customer categories drive the most sales and engagement.
Dimension
Customer tagsSet of tags associated with the customer
  • Create targeted marketing campaigns for customer groups such as VIP, wholesale, or newsletter subscribers.
  • Focus marketing budget on the customer categories that drive the most sales and engagement.
Dimension
First order has subscriptionLabel specifying whether the customer's first order included a subscription purchase
  • Track how many new customers start with subscription products.
  • Optimize subscription marketing to increase first-order subscription conversions.
Dimension
First order productsProducts bought together in the customer's first order
  • Identify which products are most effective at attracting new customers.
  • Optimize product recommendations and cross-selling based on successful first purchases.
Dimension
Months since first purchaseMonths from the customer's first order to the given order. By convention, a value of -1 indicates that the given order is the customer's first order
  • Plan seasonal marketing campaigns based on customer purchase cycles.
  • Set up automated email sequences for customers at different lifecycle stages.
Dimension
New or returning customerLabel specifying whether an order is from a new or returning customer
  • Segment marketing campaigns based on customer purchase history.
  • Track the balance between customer acquisition and retention efforts.
Use as filter to compare new vs returning customer behavior.Dimension
Predicted spend tierLabel specifying how much the customer is predicted to spend in the next year
  • Prioritize high-value customers for premium service and personalized attention.
  • Invest more marketing budget on customers likely to spend more.
Dimension
Quarters since first purchaseQuarters from the customer's first order to the given order. By convention, a value of -1 indicates that the given order is the customer's first order
  • Plan quarterly retention campaigns based on customer purchase patterns.
  • Track long-term customer loyalty and lifetime value trends.
Dimension
RFM groupCustomer groupings based on recency (days since last order), frequency (orders per customer), and monetary spend (revenue from orders)
  • Implement a referral program and early access offers for your brand champions.
  • Plan targeted actions, such as re-engagement campaigns for dormant customers.
Dimension
Weeks since first purchaseWeeks from the customer's first order to the given order. By convention, a value of -1 indicates that the given order is the customer's first order
  • Time your marketing campaigns based on when customers typically make repeat purchases.
  • Identify customers who are overdue for their next purchase and need re-engagement.
Dimension
Years since first purchaseYears from the customer's first order to the given order. By convention, a value of -1 indicates that the given order is the customer's first order
  • Identify your most loyal long-term customers for VIP treatment.
  • Plan anniversary campaigns and long-term customer appreciation programs.
Dimension

Fees

Fees that apply to your orders, transactions, and other features you use.

Table containing a list of all fees analytics fields.
NameDescriptionUsesNotesType
Average foreign exchange feesAverage foreign exchange fee across all ordersUnderstand the fees you incur for currency conversion when selling in international markets, averaged across all of your orders. Metric (Money average)
Average international feesAverage fees that you pay per order for foreign exchanges and Managed Markets
Formula: average foreign exchange fees + average managed markets fees
Understand the fees you incur when selling in international markets, averaged across all of your orders. Metric (Money average)
Average Managed Markets feesAverage Managed Markets fee across all ordersUnderstand the fees you incur to use Managed Markets, averaged across all of your orders. Metric (Money average)
Average payment processing feesAverage payment processing fee across all ordersUnderstand the fees you incur to process payments, averaged across all of your orders. Metric (Money average)
Foreign exchange feesCurrency conversion fees you pay when customers purchase in a different currencyUnderstand the fees you incur for currency conversion when selling in international markets. Metric (Money total)
International feesFees you pay for foreign exchanges and Managed Markets
Formula: foreign exchange fees + managed markets fees
Understand the fees you incur when selling in international markets. Metric (Money total)
Managed Markets feesFees charged when you use Shopify's Managed Markets to sell internationallyUnderstand the fees you incur to use Managed Markets. Metric (Money total)
Payment processing feesPayment processing fees you pay per order through Shopify PaymentsUnderstand the fees you incur to process payments. Metric (Money total)

Finance and payments

Taxes, payment methods, payouts, platform fees, gift cards, and store credit.

Table containing a list of all finance and payments analytics fields.
NameDescriptionUsesNotesType
Adjusted gift card valueValue of gift cards adjusted in the given period
  • Spot unusual gift card activity that might need investigation.
  • Understand changes to gift card liability when planning financial reports.
Metric (Money total)
Cash roundingCash rounding adjustment (positive or negative) applied to cash transactions to round them to the nearest currency unit
  • Track cash rounding impact on total revenue and customer experience.
  • Optimize cash handling procedures based on rounding patterns.
Metric (Money total)
Credited store creditValue of store credit credited in the given period
  • Calculate the revenue impact of issuing store credits instead of cash refunds.
  • Track how much money you're giving away in promotional credits.
Metric (Money total)
Debited store creditValue of store credit debited in the given period
  • Track how much store credit customers use versus what you issue.
  • Predict future redemptions based on historical usage patterns.
Metric (Money total)
Disabled gift card valueValue of gift cards deactivated in the given period
  • Calculate how much money you're losing to gift card refunds and fraud issues.
  • Follow up with customers whose gift cards were deactivated.
Metric (Money total)
Ending gift card balanceBalance of gift cards at the end of the given period
  • Plan cash flow around the money you owe customers on gift cards.
  • Set aside money to cover gift card redemptions in future periods.
Metric (Money total)
Ending store credit balanceBalance of store credit at the end of the given period
  • Plan your cash flow by knowing how much store credit customers could redeem.
  • Set aside money to cover store credit redemptions in future months.
Metric (Money total)
Expired store creditValue of store credit expired in the given period
  • Recover revenue from expired store credits that customers never used.
  • Set optimal expiration periods to balance customer satisfaction with cash flow.
Metric (Money total)
Failed payment attemptsNumber of failed payment attempts
  • Identify payment methods or processors that fail too often and need replacement.
  • Reduce revenue loss by improving payment systems that cause the most failures.
Metric (Count)
Gift card balance net changeNet change in gift card balances in the given period
Formula: ending gift card balance - starting gift card balance
  • Track whether your gift card liability is growing or shrinking over time.
  • Adjust gift card marketing when liability grows faster than sales.
Metric (Money total)
Gift cards adjustedNumber of gift cards adjusted in the given period
  • Investigate operational issues when gift card adjustments spike unexpectedly.
  • Identify patterns in gift card adjustments to improve accuracy.
Metric (Count)
Gift cards disabledNumber of gift cards deactivated in the given period
  • Investigate spikes in deactivated cards to identify fraud or system issues.
  • Understand operational workloads related to gift cards.
Metric (Count)
Gift cards issuedNumber of gift cards issued in the given period
  • Plan gift card marketing campaigns based on seasonal patterns.
  • Scale gift card promotions during periods with high demand.
Metric (Count)
Gross paymentsAmount of payments before any refunds
  • Reconcile payment processor data with your order revenue.
  • Plan cash flow based on total payment volume before fees.
Metric (Money total)
Issued gift card balanceBalance of gift cards issued in the given period
  • Track how much gift card liability you're taking on each period.
  • Plan cash flow based on the value of gift cards you're selling.
Metric (Money total)
Net paymentsAmount of payments after any refunds
  • Track revenue after refunds for accurate financial planning.
  • Set realistic revenue targets based on net payment history.
Metric (Money total)
Net payments excluding gift cardsAmount of payments after any refunds, excluding amount redeemed from gift cards
  • Track revenue separately from gift card redemptions.
  • Plan cash flow based on payments that generate immediate cash.
Metric (Money total)
Orders with transactionsNumber of orders associated with payment transactions
  • Connect payment success to order fulfillment performance.
  • Track order-to-payment conversion rates across different channels.
Metric (Count)
Payment authorization rateRate of successful payments, relative to unique payment attempts
Formula: successful_payments / unique_payment_attempts
  • Measure how effectively your payment system converts payment attempts into sales.
  • Set benchmarks for payment processor performance and switch providers if rates drop.
Metric (Percentage & rate)
Payment authorization rate (raw)Rate of successful payments, relative to total payment attempts
Formula: successful_payments / total_payment_attempts
  • Adjust fraud detection settings if legitimate customers are retrying payments too often.
  • Optimize payment retry logic based on how retries affect overall success rates.
Metric (Percentage & rate)
Payout amountValue of the payout
  • Track your total earnings from Shopify Payments over time.
  • Plan business expenses and investments based on payout amounts.
Metric (Money total)
Payout amount in payout currencyValue of the payout, in the currency the payout was issued in
  • Track payouts in their original currency to avoid conversion confusion.
  • Plan international banking and currency exchange based on payout currencies.
Metric (Money total)
Pricing adjustment valueValue of pricing adjustments made to orders
  • Calculate the total revenue impact of your pricing strategies.
  • Compare the profitability of different pricing adjustment amounts.
Metric (Money total)
Redeemed gift card valueAmount redeemed from gift cards
  • Track gift card program effectiveness to optimize promotional strategies.
  • Plan gift card inventory and promotion timing based on redemption patterns.
Metric (Money total)
Refunded gift card valueAmount refunded to gift cards
  • Identify gift card refund patterns to improve return policies.
  • Track gift card liability and cash flow impact from refunds.
Metric (Money total)
Refunded paymentsAmount of refunded payments
  • Track refund patterns to reduce future returns through product improvements.
  • Identify products that generate frequent refunds for quality review.
Metric (Money total)
Rounded net paymentsAmount of payments after any refunds, rounded to the nearest currency unit
  • Track the impact of rounding on your total revenue for accurate financial reporting.
  • Compare rounded versus unrounded amounts to understand rounding effects on profit margins.
Metric (Money total)
Sales taxesTaxes applied to sales
  • Set aside the right amount of money for tax payments each quarter.
  • Avoid penalties by reporting accurate tax collection amounts.
Metric (Money total)
Sold gift card balanceBalance of gift cards sold in the given period
  • Plan cash flow around expected future gift card redemptions.
  • Track gift card liability for accurate financial reporting.
Metric (Money total)
Starting gift card balanceBalance of gift cards at the start of the given period
  • Track your gift card liability at the beginning of each period.
  • Compare starting and ending balances to measure gift card usage changes.
Metric (Money total)
Starting store credit balanceBalance of store credit at the start of the given period
  • Plan your cash flow by knowing how much store credit customers could redeem.
  • Set aside money to cover store credit redemptions in future months.
Metric (Money total)
Store credit balance net changeNet change in store credit balances in the given period
Formula: ending store credit balance – starting store credit balance
  • Track whether your store credit liability is growing or shrinking over time.
  • Adjust store credit policies if your liability is growing too fast.
Metric (Money total)
Successful paymentsNumber of successful payments
  • Track payment system performance and identify when success rates drop.
  • Set benchmarks for payment processor performance and negotiate better rates.
Metric (Count)
Total payment attemptsTotal number of payment attempts, with retried payments counted as separate attempts
  • Understand how hard customers work to complete payments despite failures.
  • Measure the total load on your payment systems including retry attempts.
Metric (Count)
Transaction amountAmount of all payment transactions
  • Track payment processing volume to optimize transaction fees.
  • Analyze transaction size patterns to adjust pricing strategies.
Metric (Money total)
TransactionsNumber of payment transactions
  • Track payment processing volume to plan system capacity.
  • Identify transaction processing trends for operational planning.
Metric (Count)
Unique payment attemptsNumber of payment attempts, with retried payments for the same purchase counted one time
  • Measure how many customers attempt to pay versus how many succeed.
  • Identify the true conversion rate from payment attempt to successful purchase.
Metric (Count)
Credit card tierTier of credit card used for the transaction
  • Optimize checkout experience for premium versus standard card users.
  • Adjust fraud detection rules based on credit card tier patterns.
Dimension
Credit card typeType of credit card used for the transaction
  • Understand which card brands your customers prefer.
  • Balance card acceptance with processing fees to optimize profit margins.
Dimension
Digital walletDigital wallet used for the transaction
  • Promote digital wallets that convert better than traditional payments.
  • Identify which digital wallets have lower fraud rates for safer transactions.
Dimension
Is in-person paymentLabel indicating whether the payment was made in person
  • Compare online versus in-person payment success rates to optimize each channel.
  • Identify whether payment issues are specific to your online or offline sales.
Dimension
Is Shop channel transactionLabel specifying whether the transaction was processed through the Shop channel
  • Compare Shop channel payment performance versus other sales channels.
  • Focus marketing efforts on channels with the highest payment success rates.
Dimension
Is Shop Pay transactionLabel specifying whether the transaction was processed through Shop Pay
  • Promote Shop Pay more prominently if it converts better than other methods.
  • Compare Shop Pay performance against other payment options.
Dimension
Order transaction IDUnique number that identifies the payment transaction in Shopify's system
  • Resolve payment issues by connecting orders to specific payment transactions.
  • Track payment success rates across different payment methods.
Dimension
Payment attempt amountAmount of the attempted payment (in your store's currency)
  • Identify payment failure patterns at different price points to adjust pricing strategies.
  • Set payment limits and fraud detection rules based on transaction amounts.
Dimension
Payment attempt amount (customer currency)Amount of the attempted payment (in the customer's currency)
  • Price products in currencies that have the highest payment success rates.
  • Identify currency-specific payment issues to improve international checkout.
Dimension
Payment attempt currencyCurrency the customer used for the payment attempt
  • Focus payment optimization efforts on the currencies that drive the most sales.
  • Add payment methods that work better for specific currencies.
Dimension
Payment attempt groupShopify identifier for the payment attempt group
  • Group related payment attempts together to analyze retry patterns and success rates.
  • Identify which payment retry strategies work best for recovering failed transactions.
Dimension
Payment card BINBank Identification Number (BIN) of the payment card
  • Detect fraudulent payment patterns by analyzing card issuer data.
  • Optimize payment routing based on which banks approve transactions most often.
Dimension
Payment card BIN countryCountry associated with the payment card's BIN
  • Adjust fraud detection rules based on card issuer countries.
  • Identify geographic payment issues that need different payment processors.
Dimension
Payment card brandBrand of the payment card
  • Promote payment methods that have the highest success rates for your customers.
  • Identify card brands that frequently fail to improve fraud detection settings.
Dimension
Payment card issuerIssuer of the payment card
  • Identify card issuers with frequent payment failures.
  • Adjust fraud detection settings based on card issuer patterns.
Dimension
Payment card sourceFunding source of the payment card
  • Compare success rates of credit versus debit versus prepaid cards.
  • Optimize your checkout flow for the most common use-cases.
Dimension
Payment card walletDigital wallet used for the payment
  • Promote digital wallets that convert better than traditional card payments.
  • Optimize checkout flow by featuring the wallets your customers prefer.
Dimension
Payment first attempted atTimestamp of the first payment attempt
  • Identify peak payment failure times to schedule payment system maintenance.
  • Optimize customer support coverage during high payment attempt periods.
Dimension
Payment gatewayPayment gateway used for the transaction
  • Focus on payment gateways with the highest success rates.
  • Remove payment gateways that cause frequent transaction failures.
Dimension
Payment last attempted atTimestamp of the last payment attempt
  • Identify how long customers persist with failed payments before giving up.
  • Set up automated retry sequences based on customer payment attempt patterns.
Dimension
Payment methodMethod used for the payment
  • Feature payment methods that work best for your customers at checkout.
  • Remove payment methods that cause frequent failures or cart abandonment.
Dimension
Payment sourceSource of funds used for the payment
  • Focus marketing on payment sources that have the highest conversion rates.
  • Identify payment sources that frequently fail to reduce checkout friction.
Dimension
Payout currencyCurrency the payout was issued in
  • Track payouts in different currencies to understand foreign exchange impact.
  • Plan cash flow based on which currencies you receive most payouts in.
Dimension
Pricing adjustment categoryKind of pricing adjustment made to the order
  • Compare the effectiveness of different pricing strategies.
  • Focus on the pricing adjustment types that generate the best ROI.
Dimension
Store credit currencyThe currency of a store credit amount
  • Track store credit liabilities separately for each currency you accept.
  • Set different store credit policies for different international markets.
Dimension
Store credit eventThe event that resulted in the store credit transaction
  • Plan store credit promotions based on how customers typically earn and use credits.
  • Track store credit liability for accurate financial planning.
Dimension
Store credit expiration dateThe date and time a credited amount expires in your shop's timezone
  • Send reminder emails to customers before their store credits expire.
  • Set expiration dates that encourage quick purchases without frustrating customers.
Dimension
Store credit IDShopify identifier for the store credit transaction
  • Connect store credit data to other business records for detailed analysis.
  • Track individual store credit transaction performance and identify patterns.
Dimension
Store credit sourceOrigin of the store credit transaction
  • Reduce the number of credits issued from returns by improving product quality.
  • Limit promotional credits that don't drive additional sales.
Dimension
Tax nameName of the tax
  • Check that you're charging the right tax types for each location.
  • Ensure tax names are consistent and properly labeled for your accounting reports.
Dimension
Tax rateRate of the tax
  • Verify your tax calculations match what you should be charging.
  • Compare tax rates across locations to ensure consistent pricing.
Dimension
Transaction currencyCurrency of the transaction
  • Focus payment optimization efforts on currencies that drive the most sales.
  • Add payment methods that work better for specific currencies.
Dimension
Transaction IDShopify identifier for the transaction
  • Connect payment patterns to specific transactions.
  • Analyze transaction patterns to identify which payment flows convert best.
Dimension
Transaction kindTransaction kinds include sale, authorization, capture, refund, and others
  • Spot processing issues across different types of payment activities.
  • Identify patterns in refunds versus sales.
Dimension
Transaction numberNumber of the transaction
  • Track specific transactions for customer service and dispute resolution.
  • Organize payment records for accounting and financial reporting.
Dimension
Transaction sale typeSale type of the transaction, such as Shop App or Shop Pay
  • Compare payment performance across different channels.
  • Configure payment routing and fraud detection settings by sale type.
Dimension
Transaction statusStatus of the transaction, such as success, pending, or failure
  • Identify payment processing issues quickly to minimize lost sales.
  • Follow up on failed or pending transactions to recover revenue.
Dimension

Fraud prevention

Risk assessments and suspicious transaction detection, including chargeback data.

Table containing a list of all fraud prevention analytics fields.
NameDescriptionUsesNotesType
Acceptable fraud risk ratePercentage of orders marked as low or medium risk by Shopify's fraud analysis
  • Track how much of your business comes from low-risk, legitimate customers.
  • Adjust fraud settings to approve more good orders and block bad ones.
Metric (Percentage & rate)
Chargeback amountValue of all disputed charges of any kind
  • Know the total financial impact of payment disputes on your business.
  • Plan budgets for chargeback losses and fraud prevention measures.
Metric (Money total)
Chargeback ratePercentage of payments with disputed charges of any kind
Formula: chargebacks / successful transactions
  • Track dispute rates to prevent payment processor fees and account issues.
  • Identify when dispute levels exceed industry standards or payment processor limits.
Metric (Percentage & rate)
ChargebacksNumber of payments with disputed charges of any kind
  • Track the volume of payment disputes affecting your business.
  • Identify trends that might indicate fraud or customer satisfaction issues.
Metric (Count)
Checkout impact ratePercentage of checkout attempts that triggered your fraud prevention rules
  • Know what portion of your checkout traffic triggers fraud prevention rules.
  • Optimize rules to catch fraud without blocking too many legitimate customers.
Metric (Percentage & rate)
Checkouts impacted decision rulesNumber of checkout attempts that triggered your fraud prevention rules
  • Track how many checkout attempts your fraud rules are affecting.
  • Monitor rule performance to avoid blocking legitimate customers.
Metric (Count)
Value impacted by decision rulesValue of checkout attempts that triggered your fraud prevention rules
  • Understand the sales impact of fraud rules.
  • Balance fraud protection with potential revenue loss from blocked checkouts.
Metric (Money total)
Fraudulent chargeback ratePercentage of payments with disputed charges due to reported fraud
Formula: fraudulent chargebacks / successful transactions
  • Reduce fraud rates to make sure you steer clear of penalties from payment processors.
  • Track effectiveness of fraud prevention measures over time.
Metric (Percentage & rate)
Fraudulent chargebacksNumber of payments with disputed charges due to reported fraud
  • Monitor fraud-related financial losses and security vulnerabilities.
  • Plan fraud prevention investments based on chargeback volumes.
Metric (Count)
High fraud risk ratePercentage of orders marked as high risk by Shopify's fraud analysis
  • Monitor fraud trends to protect your business from chargebacks and losses.
  • Adjust fraud protection settings based on your risk tolerance and loss patterns.
Orders flagged as high risk. Higher rates might indicate targeting issues.Metric (Percentage & rate)
Successful transactionsNumber of successful payment transactions
  • Track healthy payment processing volume for rate calculations.
  • Know your baseline of successful transactions to measure dispute rates.
Metric (Count)
Chargeback reasonReason for the chargeback
  • Identify the most common dispute reasons to fix underlying business issues.
  • Improve customer service and product quality based on chargeback patterns.
Dimension
Checkout rule IDUnique identifier for the fraud prevention rule
  • Connect fraud rule data to other business records for detailed analysis.
  • Track individual fraud rule performance and identify patterns.
Dimension
Order cancellation reasonReason why the order was canceled
  • Identify the most common reasons orders get canceled to address underlying issues.
  • Spot fraud patterns and inventory problems that are costing you sales.
Dimension
Order is Shopify Protect coveredWhether the order has met Shopify Protect fulfillment requirements (shipped and tracked properly)
  • Know which orders you've fulfilled properly according to Shopify Protect requirements.
  • Track your success rate at meeting the fulfillment requirements for protection.
Dimension
Order is Shopify Protect eligibleWhether the order qualifies for Shopify Protect
  • Identify orders that can earn chargeback protection if you fulfill them within the time requirements.
  • Prioritize eligible orders for quick fulfillment to secure chargeback protection.
Dimension
Order is Shopify Protect protectedWhether the order has full Shopify Protect coverage against fraud
  • Identify orders that are fully protected from fraudulent and unrecognized chargebacks.
  • Review how many of your orders have earned complete chargeback protection.
Dimension
Order risk levelRisk level assigned to the order by Shopify's fraud analysis
  • Prioritize manual review of high-risk orders before fulfilling them.
  • Set up automated processes to handle low-risk orders and protect against fraud.
Dimension
Decision rule evaluated while inactiveWhether the fraud rule was tested without actually blocking the checkout
  • Test fraud prevention rules without actually blocking customer checkouts.
  • Evaluate rule effectiveness before fully activating fraud controls.
Dimension

Inventory

Stock levels, product availability, and how quickly products sell.

Table containing a list of all inventory analytics fields.
NameDescriptionUsesNotesType
Acceptance ratePercentage of received items that were accepted
Formula: accepted_quantity / received_quantity
  • Stop using carriers with consistently low acceptance rates.
  • Set quality standards for suppliers based on acceptance data.
Metric (Percentage & rate)
Accepted quantityQuantity accepted after quality checks
  • Track inventory that passed quality checks upon receipt.
  • Measure shipment quality and supplier reliability.
Metric (Count)
Days in inventoryNumber of days in the given period with a record of the inventory item
  • Calculate how long you've been carrying each product or variant.
  • Compare product lifecycles to optimize inventory planning.
Metric (Duration (days))
Days in inventory (at location)Number of days in the given period with a record of the inventory item at the specified location
  • Review how long products were available at each location during any time period.
  • Calculate accurate location-specific sales rates by accounting for actual availability.
Metric (Duration (days))
Days in stockNumber of days in the given period with inventory in stock, based on each day's ending inventory units
  • Measure how often products are available for customers to buy.
  • Identify products that are frequently in stock to increase marketing focus.
Metric (Duration (days))
Days in stock (at location)Number of days in the given period with inventory in stock, based on each day's ending inventory units at the specified location
  • Track how often each location actually has products available for customers.
  • Identify locations with frequent stockouts that need better inventory management.
Metric (Duration (days))
Days of inventory remainingForecasted number of days of inventory remaining
Formula: ending inventory units / inventory units sold per day
  • Plan reorders before you run out of popular products.
  • Communicate urgency in your marketing when inventory is running low.
How long until stockout at current sales rate.Metric (Duration (days))
Days of inventory remaining (at location)Forecasted number of days of inventory remaining at the specified location
Formula: ending inventory units (at location) / inventory units net change (at location) per day
  • Know which locations will run out of stock first for each product.
  • Plan location-specific reorders and transfers before stockouts occur.
Metric (Duration (days))
Days out of stockNumber of days in the given period with inventory out of stock, based on each day's ending inventory units
  • Identify products with stockout problems that might be losing you sales.
  • Adjust reorder points to reduce the time products spend out of stock.
Metric (Duration (days))
Days out of stock (at location)Number of days in the given period with inventory out of stock, based on each day's ending inventory units at the specified location
  • Identify which locations are missing sales due to empty shelves.
  • Plan transfers from locations with excess stock to locations with stockouts.
Metric (Duration (days))
Ending inventory retail valueValue of all units in inventory at the end of the given period, based on their retail price
Formula: ending inventory units * product variant price
  • Calculate the potential revenue from selling everything at full price.
  • Plan location-specific markdowns based on the retail value of unsold inventory.
Metric (Money total)
Ending inventory retail value (at location)Value of all units in inventory at the specified location at the end of the given period, based on their retail price
Formula: ending inventory units (at location) * product variant price
  • Know the potential revenue from inventory at each location if everything sold.
  • Plan location-specific markdowns based on the retail value of unsold inventory.
Metric (Money total)
Ending inventory unitsInventory units at the end of the given period
  • Know exactly how much inventory you have left to sell.
  • Plan storage space and warehouse organization based on inventory levels.
Metric (Count)
Ending inventory units (at location)Units at the end of the given period at the specified location
  • Know exactly how much stock each location has for every product.
  • Identify locations with excess inventory that could transfer to other locations.
Metric (Count)
Ending inventory valueValue of all units in inventory at the end of the given period, based on their cost
Formula: ending inventory units * inventory item cost
  • Determine how much cash you can free up by running sales on slow products.
  • Plan markdowns based on how much money is tied up in each product.
Metric (Money total)
Ending inventory value (at location)Value of all units in inventory at the specified location at the end of the given period, based on their cost
Formula: ending inventory units (at location) * inventory item cost
  • Know how much money you have tied up in inventory at each location.
  • Optimize cash flow by rebalancing inventory investment across locations.
Metric (Money total)
First day in inventoryFirst day in the given period with a record of the inventory item
  • Track when you first started carrying each product or variant.
  • Identify seasonal products by when they first appear in your inventory.
Metric (Date)
First day in inventory (at location)First day in the given period with a record of the inventory item at the specified location
  • Track when products first arrived at each location.
  • Calculate how long products have been available at specific locations.
Metric (Date)
Inventory adjustment changeChange in inventory quantity
  • Track how much inventory is being added or removed from your stock.
  • Identify products with biggest inventory swings that need better management.
Metric (Count)
Inventory adjustment countAmount of times an inventory adjustment was made
  • Count how many times inventory was adjusted to spot problem areas.
  • Compare adjustment frequency across time to determine if accuracy is improving.
Metric (Count)
Inventory units net change (at location)Net change in units over the given period at the specified location
Formula: starting inventory units (at location) - ending inventory units (at location)
  • Track which locations are gaining or losing inventory over time.
  • Identify locations with unusual inventory movement patterns.
Metric (Count)
Inventory units soldQuantity of inventory units sold in a given period
  • Identify which products are selling fastest.
  • Calculate how much inventory you need to order to meet demand.
Metric (Count)
Inventory units sold per dayInventory units sold per day in the given period with a record of the inventory item
Formula: inventory units sold / days in inventory
  • Forecast future inventory needs based on daily sales velocity.
  • Compare product performance to decide which items deserve more shelf space.
Metric (Count ratio)
Last day in inventoryLast day in the given period with a record of the inventory item
  • Know when you stopped carrying products or when they sold out.
  • Track the lifespan of seasonal or limited-time products.
Metric (Date)
Last day in inventory (at location)Last day in the given period with a record of the inventory item at the specified location
  • Track when products were discontinued at specific locations.
  • Understand product lifecycle timing at each location.
Metric (Date)
Ordered quantityQuantity of inventory items ordered for transfer
  • Plan warehouse capacity based on typical transfer volumes.
  • Identify unusually large transfers that need special handling.
Metric (Count)
Percent of inventory soldPercent of inventory sold during the given period
Formula: inventory units sold / starting inventory units
  • Identify which products are turning over inventory fastest.
  • Adjust purchase quantities based on what percentage of inventory typically sells.
Metric (Percentage & rate)
Received quantityQuantity received at destination locations
  • Spot shipment shortages by comparing received to shipped quantities.
  • Update inventory counts as shipments arrive.
Metric (Count)
Rejected quantityQuantity rejected due to quality issues or damage
  • Identify quality issues with shipped inventory.
  • Track losses due to damage or quality problems during transit.
Metric (Count)
Rejection ratePercentage of received items that were rejected
Formula: rejected_quantity / received_quantity
  • Stop using carriers or routes with consistently high rejection rates.
  • Improve packaging standards to reduce damage during transit.
Metric (Percentage & rate)
Sell-through rateSell-through rate during the given period
Formula: inventory units sold / (inventory units sold + ending inventory units)
  • Focus marketing efforts on slow-moving inventory to free up cash.
  • Decide which products to reorder in larger quantities next time.
Metric (Percentage & rate)
ShipmentsNumber of unique shipments
  • Track shipment volume and logistics activity.
  • Identify opportunities to consolidate small, frequent shipments.
Metric (Count)
Shipped quantityQuantity shipped between locations
  • Plan warehouse capacity based on shipment volumes.
  • Identify unusually large shipments that need special handling.
Metric (Count)
Starting inventory unitsInventory units at the start of the given period
  • Compare starting and ending inventory to review how much you sold.
  • Plan inventory purchases based on how much stock you began with.
Metric (Count)
Starting inventory units (at location)Units at the start of the given period at the specified location
  • Know exactly how much stock each location started with.
  • Calculate how much inventory moved at each location during any time period.
Metric (Count)
TransfersNumber of inventory transfers
  • Plan staffing levels based on transfer volume patterns.
  • Consolidate frequent small transfers to reduce handling costs.
Metric (Count)
Transfer line itemsNumber of line items across transfers
  • Allocate more time and resources to complex multi-item transfers.
  • Simplify transfers by reducing the number of items moved at one time.
Metric (Count)
Unique items shippedNumber of unique inventory items shipped
  • Consolidate shipments of frequently moved items to reduce costs.
  • Identify items that need better stock distribution across locations.
Metric (Count)
Unique items transferredNumber of unique inventory items transferred
  • Consolidate shipments of frequently moved items to reduce costs.
  • Balance stock levels to reduce how often items need redistribution.
Metric (Count)
CarrierName of the shipping carrier company
  • Switch to more reliable carriers based on performance data.
  • Negotiate better rates with carriers that deliver consistently.
Dimension
Carrier codeCarrier code or abbreviation (such as UPS, FEDEX, USPS)
  • Filter and group shipments by carrier code.
  • Integrate with carrier tracking systems.
Dimension
Inventory destination cityCity of the location that's receiving inventory
  • Analyze geographic patterns in inventory distribution.
  • Optimize logistics based on the cities that receive frequent transfers.
Dimension
Inventory destination countryCountry where the inventory destination location is located
  • Plan customs documentation and duties for international inventory transfers.
  • Compare fulfillment performance across warehouses in different countries.
Dimension
Inventory destination nameName of the location receiving inventory
  • Identify which warehouses or locations are receiving inventory.
  • Compare transfer and shipment activity across different destination locations.
Dimension
Inventory destination regionProvince or state of the location that's receiving inventory
  • Balance inventory levels across region to reduce expensive rush transfers.
  • Analyze regional fulfillment patterns.
Dimension
Document URIURI path identifying this transfer in Shopify (such as /transfers/12345)
  • Link back to the original transfer record in Shopify Admin.
  • Use as a unique reference for integrations and external systems.
Dimension
Expected delivery dateEstimated date and time the shipment will arrive
  • Schedule receiving staff based on expected arrivals.
  • Plan receiving operations and staffing.
Dimension
Inventory adjustment group IDShopify identifier for the inventory adjustment group
  • Group related inventory adjustments together for bulk analysis.
  • Analyze large-scale inventory corrections to improve counting processes.
Dimension
Inventory adjustment IDShopify identifier for the inventory adjustment
  • Review specific adjustments when investigating stock discrepancies.
  • Track individual changes to understand your inventory accuracy.
Dimension
Inventory app IDShopify identifier for the inventory app that made the adjustment
  • Filter adjustments by the specific app that made them.
  • Track which inventory management apps make the most changes.
Dimension
Inventory app nameName of the inventory app that made the adjustment
  • Identify which inventory management apps are making changes to your stock.
  • Evaluate the reliability of different inventory apps based on adjustment patterns.
Dimension
Inventory change reasonReason for the inventory change, such as Correction or Restock
  • Understand why inventory levels changed (sales, damages, corrections, and more).
  • Identify if inventory issues are due to fulfillment problems or stock counting errors.
Dimension
Inventory cost is recordedLabel specifying whether the inventory item's cost is recorded
  • Find products missing cost data that need pricing information.
  • Focus profit analysis on products with complete cost records.
Dimension
Inventory destination IDShopify identifier for the location receiving inventory
  • Connect destination location data to transfers and shipments.
  • Track inventory movement to specific warehouses or locations.
Dimension
Inventory group IDGrouping of inventory items based on where they physically reside
  • Filter inventory adjustments by specific locations or warehouses.
  • Identify which locations have the most inventory accuracy problems.
Dimension
Inventory is trackedLabel specifying whether the inventory item's inventory adjustments are tracked
  • Know which products have inventory tracking activated or deactivated.
  • Focus inventory management efforts on tracked items that affect stock levels.
Dimension
Inventory item costCost of goods sold for this inventory item
  • Calculate profit margins by comparing cost to selling price.
  • Track inventory value and make better pricing decisions.
Dimension
Inventory item IDShopify identifier for the inventory item
  • Track inventory performance at the most detailed level.
  • Connect inventory data to product variants for purchasing decisions.
Dimension
Inventory location IDShopify identifier for the inventory location
  • Connect inventory location data to fulfillment data for detailed inventory analysis.
  • Compare performance between different named locations in your business.
Dimension
Inventory location nameName of the inventory location
  • Identify which warehouse, store, or fulfillment center each location represents.
  • Compare performance between different named locations in your business.
Dimension
Inventory origin cityCity of the location that's sending inventory transfers
  • Analyze geographic patterns in inventory sourcing.
  • Optimize logistics based on origin city locations.
Dimension
Inventory origin countryCountry of the location that's sending inventory transfers
  • Plan customs documentation and duties for international inventory transfers.
  • Compare shipping costs and speed across warehouses in different countries.
Dimension
Inventory origin IDShopify identifier for the location sending inventory transfers
  • Connect origin data to other business records for detailed transfer analysis.
  • Track inventory movement from specific warehouses or locations.
Dimension
Inventory origin nameName of the location sending inventory transfers
  • Identify which warehouses or locations are sending inventory.
  • Compare transfer and shipment activity across different origin locations.
Dimension
Inventory origin regionProvince or state of the location that's sending inventory transfers
  • Balance inventory levels across regions to avoid depleting specific warehouses.
  • Plan regional fulfillment by tracking which states send the most inventory.
Dimension
Shipment IDShopify identifier for the shipment
  • Connect shipment data to transfer and inventory records.
  • Track individual shipments across different reports.
Dimension
Shipment line item IDShopify identifier for the shipment line item
  • Connect line item data to other business records for detailed analysis.
  • Track individual line items within shipments.
Dimension
Inventory stateState of the inventory quantity that was adjusted
  • Understand what type of inventory was adjusted (available, damaged, and others).
  • Track changes to different inventory buckets to optimize stock levels.
Dimension
Transfer IDShopify identifier for the transfer that created this shipment
  • Connect shipments back to their originating transfers.
  • Analyze the relationship between transfers and actual shipments.
Dimension
Transfer line item IDShopify identifier for the transfer line item
  • Connect line item data to other business records for detailed analysis.
  • Track performance at the individual transfer line level.
Dimension
Reference document IDID of the Shopify resource, if the reference document URI is from Shopify
  • Link inventory adjustments to specific Shopify resources for detailed analysis.
  • Track down the exact order, transfer, or other record that caused the adjustment.
Dimension
Reference document typeType of the Shopify resource, if the reference document URI is a Shopify resource
  • Understand what type of Shopify resource triggered the inventory change.
  • Focus on the business processes that cause the most inventory adjustments.
Dimension
Reference document URIFreeform URI for why the inventory change happened. Can be from Shopify or an external tool.
  • Track what caused each inventory adjustment for better accountability.
  • Investigate inventory discrepancies by following the reference trail.
Dimension
Shipment app IDShopify identifier for the app that created the shipment
  • Track which apps are creating shipments.
  • Filter shipments by specific apps.
Dimension
Shipment app nameName of the app or integration that created the shipment
  • Identify which apps are managing shipment logistics.
  • Compare shipment quality and efficiency across different apps.
Dimension
Shipment nameName combining the transfer name and shipment number for easy reference
  • Quickly identify and reference specific shipments in reports.
  • Filter and organize shipments using recognizable names.
Dimension
Shipment received dateDate and time the shipment was initially received
  • Verify shipments arrived on time and follow up on delays.
  • Calculate average transit times to set better delivery expectations.
Dimension
Shipment shipped dateDate and time the shipment was shipped
  • Identify delays between when transfers are created and shipped.
  • Improve warehouse efficiency by tracking shipping speed.
Dimension
Shipment statusCurrent status of the shipment
  • Focus follow-up efforts on shipments stuck in transit.
  • Plan receiving capacity based on expected arrivals.
Dimension
Tracking numberTracking number used by the carrier to identify the shipment
  • Locate lost or delayed shipments quickly.
  • Provide tracking updates to team members waiting for inventory.
Dimension
Tracking URLURL to track the shipment on the carrier's website
  • Check shipment status without searching carrier websites.
  • Share tracking links with warehouse staff expecting deliveries.
Dimension
Transfer created dateDate and time when the transfer was created
  • Identify delays between when transfers are created and shipped.
  • Plan warehouse staffing based on typical transfer creation times.
Dimension
Transfer nameDisplay name of the inventory transfer
  • Quickly identify and reference specific transfers in reports.
  • Filter and organize transfers using recognizable names.
Dimension
Transfer noteAdditional note attached to the inventory transfer
  • Share special handling instructions with warehouse staff.
  • Record reasons for transfers to spot recurring issues.
Dimension
Transfer referenceReference name of the inventory transfer
  • Group transfers by your custom reference codes for detailed analysis.
  • Track performance patterns across different staff, campaigns, or suppliers.
Dimension
Transfer statusCurrent status of the inventory transfer
  • Monitor transfer progress and identify bottlenecks in the workflow.
  • Improve warehouse processes based on time spent in each status.
Dimension
Transfer tagsCustom tags assigned to the inventory transfer
  • Filter and categorize transfers using your custom tags.
  • Find all transfers tagged with specific projects or campaigns.
Dimension

Locations

Performance metrics for individual warehouses, fulfillment centers, and inventory locations.

Table containing a list of all locations analytics fields.
NameDescriptionUsesNotesType
Billing address IDShopify identifier for the billing address
  • Connect billing information to specific customer transactions.
  • Track payment and fraud patterns by linking sales to billing addresses.
Dimension
Billing cityCity of the billing address
  • Identify your strongest local markets and high-performing cities.
  • Plan targeted marketing campaigns and local promotions by city.
Dimension
Billing companyB2B customer associated with the billing address
  • Identify which orders are business purchases versus personal purchases.
  • Spot patterns in corporate buying behavior and bulk order trends.
Dimension
Billing countryCountry of the billing address
  • Understand which international markets drive the most revenue.
  • Plan global expansion strategies and international shipping policies.
Dimension
Billing postal codePostal code of the billing address
  • Identify high-value neighborhoods and demographic segments.
  • Optimize delivery routes and target local marketing efforts.
Dimension
Billing regionState or province of the billing address
  • Uncover regional sales patterns and market opportunities.
  • Optimize shipping strategies and tax compliance by state or province.
Dimension
Customer countryIndividual countries in the customer's history of addresses
  • Analyze international customer behavior and plan country-specific strategies.
  • Optimize international shipping and payment options by customer location.
Dimension
Shipping address IDShopify identifier for the shipping address
  • Connect shipping data back to specific customer addresses.
  • Track shipping costs and delivery performance by geographic area.
Dimension
Shipping cityCity of the shipping address
  • Target local advertising to cities where you already have lots of customers.
  • Negotiate better shipping rates for cities that order frequently.
Dimension
Shipping companyCompany of the shipping address
  • Track which businesses place the most orders from your store.
  • Plan shipping strategies for business addresses versus residential deliveries.
Dimension
Shipping countryCountry of the shipping address
  • Expand your business to countries that already order from you regularly.
  • Set up local payment methods for your biggest international markets.
Dimension
Shipping postal codePostal code of the shipping address
  • Identify specific neighborhoods and areas with the most customers.
  • Optimize delivery routes and shipping costs for high-volume postal codes.
Dimension
Shipping regionState or province of the shipping address
  • Focus marketing efforts on states or provinces with the most customers.
  • Plan regional shipping strategies and warehouse locations.
Dimension
Storefront IDID of Hydrogen storefront used, defaults to online_store
  • Compare performance between different storefronts if you run multiple sites.
  • Identify which storefront needs performance improvements when managing multiple stores.
Dimension
Tax cityCity where the tax was applied
  • File city-specific tax reports where local taxes are required.
  • Track which cities generate the most tax revenue for your business.
Dimension
Tax countryCountry where the tax was applied
  • File tax reports for each country where you collect taxes.
  • Focus expansion efforts on markets with favorable tax requirements.
Dimension
Tax regionRegion where the tax was applied
  • File state or province tax reports with the correct regional breakdown.
  • Plan expansion based on regions with favorable tax environments.
Dimension

Marketing

Campaign performance, customer acquisition costs, and marketing channel ROI.

Table containing a list of all marketing analytics fields.
NameDescriptionUsesNotesType
Ad impressionsNumber of unique ad impressions served
  • Monitor ad volume to ensure you're maximizing advertising opportunities on your store.
  • Compare impressions across different placements to identify high-performing placements.
Metric (Count)
Page views with adsNumber of unique page views that included ads
  • Track what percentage of your store traffic sees ads to optimize ad coverage.
  • Identify placements with low ad coverage that could be improved.
Metric (Count)
Product network clicksTotal number of unique clicks on product network ads
  • Track overall click volume to measure ad performance and user interest.
  • Analyze clicks by category and placement using dimensions for detailed insights.
Metric (Count)
CommissionsValue of commissions paid to publishers for driving sales
  • Track total publisher payouts to understand advertising costs (such as commissions generated 6:1 return on investment).
  • Monitor commission spending trends by month to optimize your product network budget (such as December commissions 40% higher than November).
Metric (Money total)
Network purchasesNumber of orders generated through the product network
  • Track order volume driven by product network advertising (such as 150 network orders out of 500 total orders = 30% from network).
  • Compare network purchase trends by day of week to optimize publisher campaigns (such as Fridays generate 25% more network orders).
Metric (Count)
Shop Campaign ad spendTotal ad spend for orders associated with Shop Campaigns
  • Set monthly advertising budgets based on your Shop Campaign spending patterns.
  • Track if you're staying within your customer acquisition cost targets.
Metric (Money total)
Shop Campaign average order valueAverage order value of orders associated with Shop Campaigns
Formula: shop campaign sales / shop campaign customers
  • Focus budgets on campaigns that attract higher-spending customers.
  • Optimize your Shop.
  • Store and offers to increase order values.
Metric (Money average)
Shop campaign credits earnedAmount of credits earned from displaying ads
  • Track total campaign credits earned to understand your store's advertising income.
  • Compare earnings across different time periods to identify seasonal trends.
Metric (Money total)
Shop Campaign customersNumber of customers that placed orders associated with Shop Campaigns
  • Scale campaigns that acquire the most new customers for your budget.
  • Calculate the true cost of acquiring each customer through Shop Campaigns.
Metric (Count)
Shop Campaign return on ad spendReturn on ad spend for orders associated with Shop Campaigns
Formula: shop campaign sales / shop campaign ad spend
  • Compare ROAS across Shop Campaigns to review campaign performance.
  • Reallocate budget from low-ROAS campaigns to high-performing ones.
Metric (Multiplier)
Shop Campaign salesSales revenue from Shop Campaigns orders, with discounts, taxes, and shipping factored in; excludes refunds
  • Calculate which campaigns make you the most money and increase their budgets.
  • Cancel campaigns that generate less revenue than they cost.
Metric (Money total)
External ad group IDExternal identifier for the ad group from the marketing platform
  • Analyze performance of specific ad groups.
  • Optimize ad group targeting and budget allocation.
Dimension
External ad IDExternal identifier for the ad from the marketing platform
  • Track individual ad performance.
  • Compare different ad creatives and messaging.
Dimension
API client IDShopify identifier for the API client
  • Track which apps or channels created marketing activities.
  • Analyze marketing performance by platform.
Dimension
Automation step typeType of step in the marketing automation workflow
  • Analyze performance by automation step.
  • Optimize automation workflows.
Dimension
Marketing activity budgetMarketing activity budget amount
  • Track marketing spend across activities.
  • Calculate return on ad spend (ROAS).
Dimension
Marketing budget typeType of budget allocated to the marketing activity
  • Analyze spending patterns by budget type.
  • Understand budget allocation strategies.
Dimension
Marketing channel handleIdentifier for the marketing channel
  • Track which channels deliver marketing activities.
  • Compare performance across different marketing channels.
Dimension
Marketing activity created atDate and time the marketing activity was created
  • Track when marketing activities were set up.
  • Analyze campaign launch timing.
Dimension
Marketing activity deleted atDate and time the marketing activity was deleted
  • Track when marketing activities were removed.
  • Analyze campaign lifecycle.
Dimension
Marketing delivery channelChannel used to deliver the marketing contentFocus marketing budget on delivery channels that drive the most conversions. Plan channel-specific content strategies based on performance. Dimension
Marketing activity ended atDate and time the marketing activity ended
  • Track campaign completion dates.
  • Analyze campaign duration.
Dimension
Marketing activity hierarchy depthDepth in the marketing activity hierarchy
  • Track complexity of campaign structures.
  • Analyze nested campaign performance.
Dimension
Marketing activity hierarchy levelLevel in the marketing activity hierarchy
  • Understand campaign structure.
  • Analyze performance at different hierarchy levels.
Dimension
Marketing activity is automationMarketing activity is automated
  • Compare automated versus manual campaign performance.
  • Track automation adoption and effectiveness.
Dimension
Marketing activity is deletedMarketing activity has been deleted
  • Filter out deleted activities from reports.
  • Track historical campaigns that are no longer active.
Dimension
Marketing activity is externalMarketing activity was created outside Shopify
  • Track which activities come from external platforms.
  • Compare Shopify versus external campaign performance.
Dimension
Marketing activity manage URLURL for managing the marketing activity in the source platform
  • Quickly access campaigns in external platforms.
  • Link analytics to campaign management tools.
Dimension
Marketing activity IDShopify identifier for the marketing activityConnect specific marketing activities to orders and customer behavior. Track individual campaign performance over time for optimization. Dimension
Marketing automation IDShopify identifier for the marketing automation
  • Track automated marketing campaigns.
  • Analyze automation performance compared to manual campaigns.
Dimension
Marketing campaign IDShopify identifier for the marketing campaign
  • Group marketing activities by campaign.
  • Track overall campaign performance.
Dimension
Marketing activity channelMarketing channel category for the activity
  • Analyze performance by marketing channel.
  • Allocate budget across different channels.
Dimension
Marketing event IDUnique identifier for the associated marketing eventConnect specific marketing activities to orders and customer behavior. Track individual campaign performance over time for optimization. Dimension
Marketing event typeType of the associated marketing eventFocus marketing budget on the types of campaigns that work best for your business. Plan marketing strategies based on which event types drive the most value. Dimension
Page hostPage hostCompare performance between different storefronts or domains. Focus development resources on the domains that drive the most value. Dimension
Page pathPage pathImprove your most-visited pages to maximize conversion opportunities. Focus content creation on page types that perform best. Dimension
Landing page URLURL of the session first page view eventImprove your most common landing pages to increase conversion rates. Focus SEO and content efforts on pages that bring the most traffic. Dimension
Parent event IDShopify identifier for the parent marketing event
  • Track relationships between nested marketing events.
  • Analyze hierarchical campaign structures.
Dimension
Marketing activity preview URLURL for previewing the marketing activity
  • Review marketing content before launch.
  • Share campaign previews with team members.
Dimension
Product network categoryProduct category name associated with the engagement
  • Track which product categories generate the most publisher engagement.
  • Focus marketing efforts on categories with highest engagement rates.
Dimension
Product network placementAd placement location where the engagement occurred
  • Compare engagement rates across different ad placements (such as homepage vs product pages).
  • Optimize ad placement strategy by identifying highest-performing locations.
Dimension
Marketing channelAd product, messaging tool, or site that an online store session is credited to
  • Compare paid and organic channel performance in a single view.
  • Identify which marketing channels drive the most sessions, sales, and new customers.
For paid traffic, the ad product that you bought. For organic traffic, the site or app where you posted.Dimension
Marketing platformPlatform that a marketing channel belongs to, such as Meta for Meta Ads, Facebook, and Instagram
  • Review the combined paid and organic results from one platform.
  • Compare marketing performance across platforms.
Replaces Referring platform.Dimension
Referring channelSite or app that a visitor came from, which is where your marketing was displayedShift marketing budget to channels that drive the most profitable customers. Focus customer acquisition efforts on your highest-performing traffic sources. Dimension
Marketing activity referring domainDomain that referred traffic from the marketing activity
  • Track which domains drive traffic from marketing campaigns.
  • Build partnerships with high-performing referral sources.
Dimension
Referring mediumCategory of referring channel that led to an online store sessionBalance investment between paid advertising and organic marketing efforts. Focus budget on paid or organic approaches based on which converts better. Dimension
Referring platformPlatform that led to an online store sessionIncrease advertising spend on platforms that deliver the best customer value. Focus creative development on platforms that drive the most profitable sales.Replaced by Marketing platform.Dimension
External platform IDExternal identifier from the marketing platform
  • Connect Shopify data with external marketing platforms.
  • Reconcile data across systems.
Dimension
Scheduled to end atDate and time the marketing activity is scheduled to end
  • Track campaign end dates.
  • Plan for campaign renewals or follow-ups.
Dimension
Shop Campaign nameName of the Shop Campaign
  • Scale budgets for campaigns that bring you the most profitable customers.
  • Optimize campaigns that aren't meeting your targets.
Dimension
Marketing activity started atDate and time the marketing activity started
  • Track campaign launch dates.
  • Analyze timing of successful campaigns.
Dimension
Marketing activity statusStatus of the marketing activityFocus budget on active campaigns and pause underperforming ones. Track campaign lifecycle from launch to completion. Dimension
Marketing activity tacticMarketing tactic used for the activity
  • Compare effectiveness of different marketing tactics.
  • Optimize strategy by focusing on successful tactics.
Dimension
Marketing activity titleTitle of the marketing activityCompare performance between different marketing campaigns by name. Identify your highest-performing campaigns for future planning. Dimension
Traffic typeType of traffic that led to an online store sessionCalculate true marketing ROI by separating paid from organic performance. Focus paid advertising budget on channels that outperform organic traffic. Dimension
URL parameter keyCustom URL parameter key for activity tracking
  • Track custom marketing parameters.
  • Organize marketing tracking by parameter type.
Dimension
URL parameter valueCustom URL parameter value for activity tracking
  • Track specific marketing activities by custom parameters.
  • Analyze performance by custom tracking values.
Dimension

Orders

Order volume, payment and fulfillment states, order attributes and attribution.

Table containing a list of all orders analytics fields.
NameDescriptionUsesNotesType
Average cost of goods soldAverage cost-of-goods sold
  • Negotiate better supplier pricing when costs exceed target margins.
  • Focus marketing on products with the best cost-to-revenue ratios.
Metric (Money average)
Average customer duties and import taxesAverage duties and import taxes customers pay per order
  • Adjust international pricing to help customers afford duty costs.
  • Decide whether to offer duty-inclusive pricing for international customers.
Metric (Money average)
Average customer shipping chargesAverage shipping costs customers pay per order
  • Set free shipping thresholds that encourage larger orders without hurting margins.
  • Compare shipping charges to competitors to stay competitive.
Metric (Money average)
Average duty and import tax adjustment costsAverage amount you pay per order on duty and import tax adjustments
  • Build duty adjustment costs into international pricing strategies.
  • Focus on shipping destinations and products with fewer duty complications.
Metric (Money average)
Average profit at delivery (before returns)Early profit indicator calculated in the period from order placement to delivery (excludes marketing costs, packaging costs and returns)
Formula: average_revenue_before_returns - average_store_costs_before_returns
  • Focus marketing on orders that are profitable even if some get returned.
  • Plan cash flow based on profits you lock in at delivery.
Metric (Money average)
Average revenue (before returns)Average revenue from each order excluding returns and sales tax
  • Set revenue targets based on initial order value before return processing.
  • Focus on products that maintain revenue even with return risk.
Metric (Money average)
Average sale after discountsAmount customers have paid on products before sales reversals, averaged across orders
Formula: gross sales - sales reversals
  • Evaluate whether discount strategies are worth the revenue reduction.
  • Set sustainable discount levels that maintain profitable average order values.
Metric (Money average)
Average sales taxesAverage taxes you collect per order
  • Plan cash flow for tax remittance based on typical collection amounts.
  • Account for tax burden when setting pricing in different regions.
Metric (Money average)
Average shipping label adjustment costsAverage amount you pay per order on shipping label adjustments
  • Build shipping adjustment costs into your fulfillment budget.
  • Focus on carriers and shipping methods with fewer costly corrections.
Metric (Money average)
Average shipping label costAverage cost of shipping labels
Formula: shipping label costs / shipping labels
  • Add this amount to your product prices to cover shipping costs.
  • Raise prices when shipping costs increase to protect your profit margins.
Metric (Money average)
Average store costs (before returns)Average costs you pay for fulfillment, before returns
Formula: average_cost_of_goods_sold + average_store_shipping_costs + average_store_duties_and_import_taxes
  • Set pricing that covers fulfillment costs and stay competitive.
  • Focus on reducing per-order costs to improve profit margins.
Metric (Money average)
Average store duties and import taxesAverage duties and import taxes you pay per order
Formula: average_customer_duties_and_import_taxes + average_duty_and_import_tax_adjustment_costs
  • Factor duty costs into international expansion decisions.
  • Build import costs into product pricing for international markets.
Metric (Money average)
Average store shipping costsAverage amount you pay per order on shipping
  • Negotiate better shipping rates when costs exceed revenue from shipping charges.
  • Decide whether to absorb shipping costs or pass them to customers.
Metric (Money average)
First click average order quantityAverage order quantity using the first click cross-device attribution model
Formula: (products + gift cards) / orders
Invest more in awareness channels that attract customers who buy multiple items. Create bundle offers for channels that bring customers who naturally buy more. Metric (Count ratio)
First click average order valueAverage order value for the first click cross-device attribution model
Formula: (gross sales - discounts) / orders
Increase spending on awareness campaigns that attract high-value customers. Focus brand marketing on channels where customers make larger first purchases. Metric (Money average)
First click net items soldNet items sold using the first click cross-device attribution model
Formula: products + gift cards
Plan inventory investment for channels that drive high initial purchase volume. Focus product marketing on channels that sell the most items per conversion. Metric (Count)
First click order countCount of orders for the first cross-device attribution modelIncrease awareness budget for channels that introduce the most new customers. Measure brand marketing effectiveness beyond final conversion. Metric (Count)
First click salesSales for the first cross-device attribution model
Formula: gross sales - discounts
Justify awareness spending by showing revenue from customers first discovered through each channel. Balance brand marketing budget across channels based on long-term customer introduction value. Metric (Money total)
Last click average order quantityAverage order quantity using the last click attribution model
Formula: (products + gift cards) / orders
Focus conversion budget on channels that close larger multi-item orders. Optimize checkout experiences for channels that drive bulk purchases. Metric (Count ratio)
Last click average order valueAverage order value for the last click attribution model
Formula: (gross sales - discounts) / orders
Increase retargeting spend on channels that convert high-value customers. Focus closing campaigns on channels that drive premium purchases. Metric (Money average)
Last click net items soldNet items sold using the last click attribution model
Formula: products + gift cards
Plan fulfillment capacity for channels that drive large-volume conversions. Focus inventory on channels that close multi-item sales. Metric (Count)
Last click order countOrder count for the last click attribution modelIncrease conversion budget for channels that close the most sales. Optimize bottom-funnel campaigns for your highest-converting channels. Metric (Count)
Last click salesSales for the last click attribution model
Formula: gross sales - discounts
Focus retargeting budget on channels that drive the highest-value conversions. Optimize conversion campaigns for channels that close the biggest orders. Metric (Money total)
Last non-direct click average order quantityAverage order quantity using the last non-direct click cross-device attribution model
Formula: (products + gift cards) / orders
Focus marketing spend on channels that drive large orders without inflating direct traffic credit. Compare paid channel effectiveness at driving multi-item purchases. Metric (Count ratio)
Last non-direct click average order valueAverage order value for the last non-direct click cross-device attribution model
Formula: (gross sales - discounts) / orders
Shift budget to marketing channels that drive high-value orders. Avoid over-crediting direct visits when evaluating marketing channel performance. Metric (Money average)
Last non-direct click net items soldNet items sold using the last non-direct click cross-device attribution model
Formula: products + gift cards
Plan marketing budgets for channels that drive the most product volume. Focus on marketing channels that close large quantity orders. Metric (Count)
Last non-direct click order countCount of orders for the last non-direct click cross-device attribution modelIncrease marketing spend on channels that drive conversions beyond direct visits. Measure true marketing effectiveness without brand search inflation. Metric (Count)
Last non-direct click salesSales for the last non-direct cross-device attribution model
Formula: gross sales - discounts
Calculate marketing ROI without over-crediting customers who would buy anyway. Focus marketing budget on channels that truly drive incremental revenue. Metric (Money total)
Linear average order quantityAverage order quantity using the linear cross-device attribution model
Formula: (products + gift cards) / orders
Plan full-funnel marketing strategies that support larger order sizes throughout the journey. Balance touchpoint investments based on contribution to multi-item purchases. Metric (Count ratio)
Linear average order valueAverage order value using the linear cross-device attribution model
Formula: (gross sales - discounts) / orders
Balance marketing budget across touchpoints that support high-value purchases. Plan customer journey experiences that build toward larger orders. Metric (Money average)
Linear net items soldNet items sold using the linear cross-device attribution model
Formula: products + gift cards
Balance inventory marketing across all touchpoints that contribute to product sales. Plan product promotion strategies across the full customer journey. Metric (Count)
Linear order countCount of orders using the linear cross-device attribution modelBalance marketing investment across all touchpoints that contribute to conversions. Plan customer journey optimization based on conversion contribution at each stage. Metric (Count)
Linear salesSales using the linear cross-device attribution model
Formula: gross sales - discounts
Allocate marketing budget fairly based on each touchpoint's revenue contribution. Plan full-funnel marketing strategies that maximize total customer journey value. Metric (Money total)
Median days fulfillment to shippingMedian days from the fulfillment to the shipping handoff
  • Minimize delays between fulfilling orders and getting them to carriers.
  • Set realistic expectations for when fulfilled orders will ship out.
Metric (Duration (days))
Median days order to deliveryMedian day from the order to the delivery
  • Promise delivery times that match your typical complete fulfillment speed.
  • Identify when your end-to-end delivery process is taking too long.
Metric (Duration (days))
Median days order to fulfillmentMedian days from the order to the fulfillment
  • Set processing time promises that you can meet for most orders.
  • Identify when your fulfillment process is slower than your typical speed.
Metric (Duration (days))
Median days order to shippingMedian days from the order to the shipping handoff
  • Advertise shipping times that reflect your typical processing performance.
  • Spot when your order-to-ship process is taking longer than usual.
Metric (Duration (days))
Median days shipping to deliveryMedian days from the shipping handoff to the delivery
  • Select shipping services that meet your customers' delivery expectations.
  • Offer premium shipping options based on which carriers deliver fastest.
Metric (Duration (days))
Median hours fulfillment to shippingMedian hours from the fulfillment to the shipping handoff
  • Reduce delays between packing orders and shipping them out.
  • Set realistic expectations for when fulfilled orders will ship.
Metric (Duration (hours))
Median hours order to deliveryMedian hours from the order to the delivery
  • Promise delivery times that match your typical end-to-end performance.
  • Identify when your complete fulfillment process is taking too long.
Metric (Duration (hours))
Median hours order to fulfillmentMedian hours from the order to the fulfillment
  • Spot when your fulfillment process is getting slower or faster than usual.
  • Promise delivery times that you can actually meet most of the time.
Metric (Duration (hours))
Median hours order to shippingMedian hours from the order to the shipping handoff
  • Promise shipping times that reflect your typical processing speed.
  • Identify when your order-to-ship process is slower than usual.
Metric (Duration (hours))
Median hours shipping to deliveryMedian hours from the shipping handoff to the delivery
  • Choose shipping carriers that deliver in the time your customers expect.
  • Balance shipping costs with delivery speed based on carrier performance.
Metric (Duration (hours))
OrdersNumber of orders placed
  • Track order volume trends to plan inventory and staffing needs.
  • Compare order frequency across different marketing channels and campaigns.
Returns generate order records to maintain accurate inventory and financial tracking. Filter by 'Order status' to exclude returned orders from your analyses.Metric (Count)
Orders deliveredNumber of orders delivered in the selected time period
  • Track how many orders successfully reach customers.
  • Identify delivery problems that hurt customer satisfaction.
Metric (Count)
Delivered within 5 days ratePercentage of orders delivered within 5 days
  • Monitor whether your delivery speed meets customer expectations.
  • Identify opportunities for faster delivery.
Metric (Percentage & rate)
Orders fulfilledNumber of orders fulfilled in the selected time period
  • Plan staffing schedules for your busiest fulfillment periods.
  • Set realistic promises to customers about how many orders you can handle.
Metric (Count)
Orders shippedNumber of orders shipped in the selected time period
  • Track whether your fulfillment team is keeping up with order volume.
  • Plan carrier pickup schedules based on your typical shipping volume.
Metric (Count)
Shipped next day ratePercentage of orders shipped and scanned by the carrier within 36 hours
  • Monitor whether your delivery times meets customer expectations.
  • Identify opportunities for faster shipping.
Metric (Percentage & rate)
Tracking included ratePercentage of orders with a valid tracking number
  • Track how many of your orders included tracking when shipped.
  • Reduce customer service inquiries by giving customers visibility into their order status.
Metric (Percentage & rate)
Shipping label costsSum of shipping label costs
  • Set monthly shipping budgets based on these costs.
  • Find cheaper shipping options when costs increase too much.
Metric (Money total)
Shipping labelsNumber of shipping labels created
  • Track shipping volume to negotiate better carrier rates.
  • Plan fulfillment capacity based on label creation trends.
Metric (Count)
First order referring channelReferring channel associated with the customer's first order
  • Identify which marketing channels bring in your most valuable new customers.
  • Optimize marketing spend by focusing on your best customer acquisition sources.
Dimension
First order sales channelSales channel that the customer's first order came from
  • Identify which channels convert the most valuable new customers.
  • Optimize sales channels with lower new customer conversions.
Dimension
First order traffic typeType of traffic associated with the customer's first order
  • Understand whether paid or organic traffic converts better for new customers.
  • Optimize your marketing mix between paid advertising and organic efforts.
Dimension
Fulfillment event (days)Days to complete a fulfillment event
  • Set realistic fulfillment timelines for complex or custom orders.
  • Plan inventory and staffing for fulfillment events that take multiple days.
Dimension
Fulfillment event (hours)Hours to complete a fulfillment event
  • Optimize your fulfillment process to reduce time per order.
  • Schedule fulfillment staff based on how long each order typically takes.
Dimension
Fulfillment IDShopify identifier for the fulfillment
  • Connect fulfillment data to other business records for detailed analysis.
  • Track individual fulfillment performance and identify patterns.
Dimension
Fulfillment origin countryCountry where the fulfillment originated
  • Analyze fulfillment patterns by origin location to optimize warehouse placement.
  • Track cross-border fulfillment performance and shipping costs by country.
Dimension
Fulfillment providerName of the fulfillment provider
  • Compare which fulfillment providers deliver orders fastest and most reliably.
  • Negotiate better terms with providers based on their performance data.
Dimension
Fulfillment provider IDShopify identifier for the fulfillment provider
  • Connect fulfillment provider data to other business records for detailed analysis.
  • Track individual fulfillment provider performance and identify patterns.
Dimension
Fulfillment to shipping (days)Days from the fulfillment to the shipping handoff
  • Reduce delays between packing orders and shipping them out.
  • Schedule carrier pickups more efficiently based on your handoff timing.
Dimension
Fulfillment to shipping (hours)Hours from the fulfillment to the shipping handoff
  • Identify bottlenecks between packing orders and getting them to carriers.
  • Schedule carrier pickups more efficiently based on your warehouse workflow.
Dimension
Is canceled orderLabel indicating whether the order is canceled
  • Understand how often customers are canceling orders and why.
  • Identify patterns in canceled orders to improve your sales process.
Dimension
Landed cost adjustment typeType of landed cost adjustment, either duty or tax
  • Plan international shipping strategies around the most common cost adjustments.
  • Build buffer costs into international pricing for typical duty and tax adjustments.
Dimension
MarketMarket you've defined in Shopify, such as a geographical market or customer group
  • Identify which markets drive the most sales revenue.
  • Focus your business strategy on the markets that deliver the best results.
Dimension
MarketsMarkets or customer segments associated with the order
  • Identify which markets or customer segments generate the most profitable orders.
  • Optimize your market strategy by focusing on the segments that drive the best results.
Dimension
Order checkout currencyPresentment currency the customer saw when placing the order
  • Set pricing in the currencies that drive the most sales.
  • Plan international expansion based on which currencies customers prefer.
Dimension
Order fulfillment statusOrder's fulfillment status, such as Fulfilled
  • Know which orders still need to be packed and shipped to customers.
  • Track your fulfillment team's progress on completing orders.
Dimension
Order IDShopify identifier for the order
  • Connect order data to other business records for detailed analysis.
  • Track individual order performance and identify patterns.
Dimension
Order includes dutiesLabel indicating whether the order includes duties
  • Price international orders more competitively by understanding duty costs.
  • Improve international customer experience by showing duty-inclusive pricing.
Dimension
Order landing page pathPath of the first page of the user session that resulted in the order
  • Identify which page paths on your site convert best for different campaigns.
  • Optimize your site structure based on high-converting customer paths.
Dimension
Order landing page URLFirst page of the user session that resulted in the order
  • Optimize your highest-converting landing pages to drive more sales.
  • Send more marketing traffic to pages that convert visitors into customers.
Dimension
Order marketing event IDShopify identifier for the marketing event associated with the order
  • Connect orders to specific marketing campaigns for ROI measurement.
  • Track which marketing events generate the most revenue.
Dimension
Order marketing event targetPlatform or channel where the marketing activity was deployed
  • Identify which platforms and channels deliver the best results for your marketing campaigns.
  • Focus marketing budget on the channels that drive the most sales.
Dimension
Order marketing event typeType of marketing activity that led to the order
  • Identify which types of marketing activities (ads, newsletters, retargeting) drive the most orders.
  • Focus your marketing efforts on the campaign types that generate the highest ROI.
Dimension
Order nameName or number of an order (customer-facing)
  • Identify patterns in order processing issues by analyzing order sequences.
  • Spot seasonal trends and peak periods based on order numbering patterns.
Dimension
Order payment statusPayment status of an order, such as Pending or Paid
  • Promote the payment methods that have the highest success rates.
  • Identify payment issues that could be affecting your cash flow.
Dimension
Order referrer domainDomain of the site that led to the order
  • Identify which websites consistently send you customers who make purchases.
  • Build referral partnerships with domains that drive valuable traffic.
Dimension
Order referrer nameName of the site that led to the order
  • Track which specific websites are your most valuable traffic sources.
  • Prioritize outreach and partnerships with sites that send converting customers.
Dimension
Order referrer pathPath of the site that led to the order
  • Identify which specific pages on referrer sites send the most valuable traffic.
  • Focus partnership efforts on the most effective pages of referring websites.
Dimension
Order referrer siteSite that led to the order
  • Track overall performance of different referring websites.
  • Negotiate better placement or partnerships with your most valuable referrer sites.
Dimension
Order referrer sourceReferrer type that led to the order (organic, email, and others)
  • Compare conversion rates between organic search, email, social media, and other sources.
  • Adjust your marketing strategy based on which referrer types drive the most sales.
Dimension
Order referrer URLExternal page that referred a customer and led to the order
  • Identify which external sites are sending you the most valuable customers.
  • Build partnerships with sites that consistently drive sales.
Dimension
Order sales channelSales channel that an order came from
  • Focus marketing budget on the sales channels that generate the most orders.
  • Optimize your product listings and promotions for each sales channel.
Dimension
Order sales channel IDShopify identifier for the order's sales channel
  • Connect order performance data back to specific sales channels.
  • Troubleshoot channel-specific issues such as payment failures or shipping problems.
Dimension
Order tagTag associated with the order
  • Identify the most common operational issues affecting your orders and customer satisfaction.
  • Compare tag patterns across different time periods, shipping carriers, or geographies.
Dimension
Order tagsSet of tags associated with the order
  • Quickly resolve operational issues such as shipping delays, product defects, or fulfillment bottlenecks.
  • Identify opportunities for cross-selling or premium service offerings based on tags.
Dimension
Order to delivery (days)Days from the order to the delivery
  • Set delivery promises that account for your complete fulfillment process.
  • Identify orders that take too long and might hurt customer satisfaction.
Dimension
Order to delivery (hours)Hours from the order to the delivery
  • Promise delivery times that match your total fulfillment and shipping speed.
  • Identify which orders take too long from start to finish.
Dimension
Order to fulfillment (days)Days from the order to the fulfillment
  • Set processing time expectations that you can consistently meet.
  • Plan staffing increases during periods when fulfillment takes longer.
Dimension
Order to fulfillment (hours)Hours from the order to the fulfillment
  • Set realistic delivery expectations based on your fulfillment speed.
  • Find the busiest times when orders pile up and need more staff.
Dimension
Order to shipping (days)Days from the order to the shipping handoff
  • Advertise shipping times that reflect your total processing speed.
  • Compare your processing speed to competitors and industry standards.
Dimension
Order to shipping (hours)Hours from the order to the shipping handoff
  • Set accurate shipping promises by knowing your total processing time.
  • Find opportunities to speed up your entire order-to-ship process.
Dimension
Order UTM campaignUTM name of the campaign associated with the orderMeasure which specific marketing campaigns are driving the most sales Replicate successful campaign strategies and stop underperforming ones Dimension
Order UTM contentUTM content of the campaign associated with the order
  • Test which ad creative or content variations drive the most sales.
  • Focus your creative budget on content that converts viewers into customers.
Dimension
Order UTM mediumUTM medium of the campaign associated with the order
  • Compare performance between email, paid ads, social media, and other mediums.
  • Focus your marketing efforts on the mediums that generate the most revenue.
Dimension
Order UTM sourceUTM source of the campaign associated with the order
  • Compare sales performance across different marketing sources such as Google or Instagram.
  • Allocate more budget to the sources that drive the highest-value customers.
Dimension
Order UTM termUTM term of the campaign associated with the order
  • Identify which keywords or search terms drive the most valuable customers.
  • Optimize your paid search campaigns based on terms that convert to sales.
Dimension
Origin countryCountry the shipment originated from
  • Plan warehouse locations to reduce shipping costs to your biggest markets.
  • Track shipping performance from different fulfillment centers.
Dimension
Package dimension unitsUnit of measurement of the shipping package's dimensions
  • Ensure consistent measurements across all your shipping operations.
  • Convert between measurement systems for international shipping.
Dimension
Package heightHeight of the package for the shipment
  • Avoid height restrictions that trigger higher shipping rates.
  • Ensure packages fit through standard sorting equipment.
Dimension
Package lengthLength of the package for the shipment
  • Optimize package sizes to reduce dimensional weight charges.
  • Choose products that ship together efficiently in standard box sizes.
Dimension
Package nameName of the shipping package
  • Standardize package naming to reduce confusion and errors.
  • Track which package types perform best for different products.
Dimension
Package typeType of package for the shipment, such as box, envelope, flat pack, or soft pack
  • Choose the most cost-effective packaging for different products.
  • Track which package types get damaged most during shipping.
Dimension
Package weightWeight of the package for the shipment
  • Optimize packaging materials to reduce weight and shipping costs.
  • Bundle lightweight products together to maximize shipping efficiency.
Dimension
Package weight unitsUnit of measurement of the shipping package's weight
  • Maintain consistent weight measurements across all shipments.
  • Calculate accurate shipping costs for international orders.
Dimension
Package widthWidth of the package for the shipment
  • Design packaging that minimizes wasted space and shipping costs.
  • Bundle products effectively to fit in standard shipping boxes.
Dimension
Shipping carrierName of the shipping carrier
  • Switch to faster or cheaper shipping carriers based on delivery performance.
  • Offer customers carrier options based on which ones perform best to their location.
Dimension
Shipping label adjustment IDUnique number that identifies the shipping label adjustment in Shopify's system
  • Reduce shipping costs by fixing issues that cause frequent adjustments.
  • Improve address validation to prevent shipping corrections.
Dimension
Shipping label currencyCurrency the shipping label was created in
  • Track shipping costs across different currencies and markets.
  • Plan international shipping budgets based on exchange rates.
Dimension
Shipping priceShipping price associated with the order
  • Set shipping rates that cover your costs without losing customers.
  • Identify orders where you're losing money on shipping.
Dimension
Shipping serviceName of the shipping service
  • Compare costs between different service speeds to find the best value.
  • Offer customers the right balance of shipping speed and cost.
Dimension
Shipping to delivery (days)Days from the shipping handoff to the deliverySelect shipping services that meet your customers' delivery expectations Charge appropriate shipping fees based on carrier performance and speed Dimension
Shipping to delivery (hours)Hours from the shipping handoff to the delivery
  • Choose shipping carriers that deliver fastest to your customers.
  • Set delivery expectations based on carrier performance rather than promises.
Dimension

Point of sale

In-store sales, point-of-sale transactions, and in-person staff performance.

Table containing a list of all point of sale analytics fields.
NameDescriptionUsesNotesType
Assisting staff member IDShopify identifier for the staff member who assisted
  • Connect staff performance data back to individual team members.
  • Track which staff members are involved in your highest-value sales.
Dimension
Assisting staff member nameName of the staff member assisting with the retail sale
  • Recognize team member contributions to sales performance.
  • Plan staff scheduling and incentive programs based on sales performance.
Dimension
Is physical storefrontWhether the location is marked as a physical retail storefront in the location's detail page
  • Filter analytics to show locations marked as physical retail storefronts.
  • Compare performance between physical storefronts and other location types.
Reflects the current state of the location's "Physical storefront" setting, not its state at the time of each sale.Dimension
POS location IDShopify identifier for your physical retail location
  • Connect sales performance back to specific physical store locations.
  • Track which retail locations are driving the most revenue.
Dimension
POS location nameName of your physical retail location
  • Compare payment success rates across different store locations.
  • Identify locations with connection issues that affect payment success rates.
Dimension
POS register IDIdentifier for the register at your physical retail location
  • Track sales patterns by register to optimize store layout and staffing.
  • Identify which registers might need maintenance based on transaction volume history.
Dimension
Staff member IDShopify identifier for the staff member
  • Connect staff data to other business records for detailed analysis.
  • Track individual staff performance and identify patterns.
Dimension
Staff member nameName of the staff member associated with the order
  • Reward staff members who generate the most sales or handle the most orders.
  • Identify training opportunities for staff members who need additional support.
Dimension

Products

Top sellers, items bought together, and variant-level performance insights.

Table containing a list of all products analytics fields.
NameDescriptionUsesNotesType
App (product creation)App that created the product
  • Find out which apps create products that sell well.
  • Focus on apps that add high-performing products.
Dimension
Bundle product IDShopify identifier for the bundle product
  • Connect bundle product data to other business records for detailed analysis.
  • Track individual bundle product performance and identify patterns.
Dimension
Bundle titleDisplay name of the bundle
  • Identify your best-performing product bundles by name.
  • Optimize bundle offerings based on customer demand and sales data.
Dimension
CategoryCategory of productFocus inventory investment on your highest-performing product categories. Plan marketing campaigns around categories that drive the most profit. Dimension
Is bundleLabel specifying whether the line item is a bundleCompare bundle sales performance against individual product sales Uncover opportunities to create more profitable product bundles Dimension
Number of products bought togetherTotal unique products in the same order
  • Understand how many different products customers typically buy per order.
  • Optimize your product pages and checkout to encourage larger basket sizes.
Dimension
Variants bought together (count)Number of unique variants in the same order (each SKU is counted one time)
  • See when customers buy multiple variants of the same product (such as different colors or sizes).
  • Optimize your store layout to encourage customers to add more to their cart.
Dimension
Product collectionCollection associated with the product
  • Identify which collections generate the most sales to focus marketing efforts.
  • Find underperforming collections to optimize.
Dimension
Product collectionsSet of collections associated with the product
  • See which collections drive the most sales so you can focus on what works.
  • Find products that are hard for customers to discover and need better collection placement.
Dimension
Product IDShopify identifier for the product, which might have multiple variants
  • Distinguish between different products with similar titles.
  • Make decisions about discontinuing or expanding products.
Dimension
Product tagTag associated with the product
  • Identify which product tags are associated with your best-selling or highest-margin items.
  • Remove or consolidate tags that aren't adding value to your store.
Dimension
Product tagsSet of tags associated with the product
  • Identify which product tags are associated with your best-selling or highest-margin items.
  • Create targeted marketing campaigns and promotions based on product types and characteristics.
Dimension
Product titleDisplay name of the product that your customers view
  • Focus your marketing budget on the product names that sell best.
  • Rewrite low-performing product titles to improve click-through rates and conversions.
'Product title' displays the current name in your catalog. 'Product title at time of sale' preserves the historical name when the order was placed, which is useful when product names change over time.Dimension
Product typeType (category) that you've assigned to the product
  • Allocate more inventory budget to your most profitable product types.
  • Expand product lines for product types that are already driving strong sales.
Custom product categorization you set in Shopify.Dimension
Product variant ABC gradeA-grade product variants account for 80% of your revenue; B-grade 15%; C-grade 5%
  • Focus your marketing budget and inventory investment on the variants that drive most of your revenue.
  • Identify C-grade variants to discount or discontinue to free up cash and warehouse space.
Dimension
Product variant IDShopify identifier for the product variant
  • Track performance for specific sizes, colors, or styles.
  • Identify which variants sell best to focus purchasing and marketing efforts.
Dimension
Product variant SKUSKU of the product variant
  • Evaluate your inventory levels over time, to optimize reordering cadence.
  • Sync sales data with your accounting, warehouse, or other business systems.
Dimension
Product variant titleDisplay name of the product variant
  • Review your most popular variants and use them for your marketing.
  • Refine your product and inventory strategy based on what variants sell best.
Specific size/color/style. Use for granular inventory analysis.Dimension
Product vendorVendor of the product
  • Negotiate better deals with suppliers who provide your best-selling products.
  • Expand your product line with vendors whose existing products already perform well.
Manufacturer or brand. Useful for multi-brand stores.Dimension
Products bought togetherProducts frequently in the same order
  • Find natural product combinations that customers already choose.
  • Set up product bundles and recommendations based on real buying patterns.
Dimension
Products bought together (IDs)Products frequently in the same order
  • Create new product bundles based on popular combinations.
  • Set up automated cross-selling recommendations based on product ID relationships.
Dimension
TagTag assigned to productsFocus marketing and inventory on tagged product groups that perform best. Plan business strategies around custom segments you've created with tags. Dimension
Variants bought togetherProduct variants frequently in the same order
  • Identify which specific product variants (size, color, style) customers combine.
  • Create targeted bundles based on the most popular variant combinations.
Dimension

Sales revenue

Line-item financial metrics including gross sales, discounts, sales reversals, taxes, and bundled purchase patterns.

Table containing a list of all sales analytics fields.
NameDescriptionUsesNotesType
Active subscriptionsNumber of active subscriptions in the given period
  • Calculate your monthly recurring revenue by multiplying active subscriptions by average subscription price.
  • Set growth targets for new subscriptions based on your current subscriber base.
Metric (Count)
Additional feesAdditional fees associated with the given sale
  • Track extra revenue from processing fees, rush charges, or premium services.
  • Decide whether to adjust or eliminate fees that might deter customers.
Metric (Money total)
Additional product and order discountsValue of all other product and order discounts in the order
  • Review how much extra discount customers get when multiple promotions combine.
  • Create discount stacking rules that prevent excessive promotional costs.
Metric (Money total)
Additional shipping discountsValue of all other shipping discounts in the order
  • Understand how discount stacking affects your shipping promotion costs.
  • Set limits on combined shipping discounts to protect your profit margins.
Metric (Money total)
Amount spent per customerAverage cumulative amount customers have spent at your store
  • Track customer lifetime value to inform acquisition and retention spending.
  • Identify your highest-value customers for VIP treatment and retention focus.
Metric (Money average)
Applied discountsAmount discounted for the given discount
  • Calculate the total financial impact of each promotional campaign.
  • Compare discount effectiveness across different products and time periods.
Metric (Money total)
Average order valueAverage value of orders placed, excluding any post-order adjustments
Formula: (gross sales - discounts) / orders
  • Increase revenue by focusing on strategies that raise average order value.
  • Set minimum order thresholds for free shipping and promotions.
Revenue ÷ orders. Use to set minimum thresholds for free shipping.Metric (Money average)
Bundles orderedNumber of bundles ordered, independent of any returns
  • Review gross order data to identify effective marketing and promotions.
  • Optimize your selling strategies based on order performance.
Metric (Count)
Checkout feesValue of additional fees charged to customers at checkout, less fees refunded
  • Set aside the fee amounts that you need to remit each period.
  • Track fee income separately from product sales.
Not included in gross sales or net sales. Included in total sales.Metric (Money total)
Cost of goods soldDirect cost of goods sold, such as manufacturing cost
  • Track your product costs to calculate accurate profit margins.
  • Negotiate better pricing with suppliers based on volume and cost data.
Must be configured in product settings. Missing costs display as $0.Metric (Money total)
CustomersNumber of customers who placed an order
  • Track customer acquisition and retention across different time periods.
  • Set customer acquisition goals and budget allocation based on historical performance.
Metric (Count)
Discounted ordersNumber of orders with discounts applied
  • Track what percentage of your sales rely on promotional pricing.
  • Plan promotional campaigns to balance discounted and full-price sales.
Metric (Count)
DiscountsAmount discounted from sales revenue
  • Track how much revenue you're giving up through promotional pricing.
  • Adjust your discount strategy to balance sales volume against profit margins.
Use as filter (such as discounts > $10) to find heavily discounted orders.Metric (Money total)
Discount reversalsValue of discounts you got back from sales reversals
  • Track how much promotional spending you recover from returned items.
  • Adjust discount strategies based on return patterns.
Metric (Money total)
DutiesDuties associated with the given sale
  • Track international shipping costs that affect your pricing strategy.
  • Plan product sourcing and pricing for international customers.
Metric (Money total)
Gift card discountsValue of discounts on gift card sales (negative numbers)
  • Track promotional discounts on gift card sales.
  • Plan gift card promotions to balance sales with profitability.
Metric (Money total)
Gift card gross salesGift card sales revenue, before discounts and sales reversals are factored in
  • Track gift card sales as a source of upfront cash flow.
  • Plan gift card promotions to boost short-term revenue.
Metric (Money total)
Gift card net salesGift card sales revenue, discounts and sales reversals factored in
  • Track gift card revenue after all adjustments.
  • Plan cash flow knowing your true gift card income.
Metric (Money total)
Gift card taxesTaxes for sales of gift cards
  • Track tax obligations on gift card sales for compliance reporting.
  • Plan gift card pricing strategies that account for tax requirements.
Metric (Money total)
Gross marginPercentage of your sales that is profit (factoring in cost of goods sold)
Formula: gross profit / net sales
  • Focus marketing and inventory investments on higher-margin areas.
  • Set minimum margin requirements for new products and pricing decisions.
Requires cost of goods sold. Use as filter (such as margin < 20%) to find low-margin products.Metric (Percentage & rate)
Gross profitSales revenue minus the cost of goods sold
Formula: net sales - cost of goods sold
  • Focus marketing and inventory investment on your most profitable products.
  • Set pricing strategies that maximize profit rather than just revenue.
Requires cost of goods sold to be set up in Shopify for accurate calculations.Metric (Money total)
Gross sales reversalsValue of sales reversals, before discounts are factored in
  • Track the full value of returned merchandise at original prices.
  • Identify products that consistently generate high-value returns.
Metric (Money total)
Gross salesSales revenue, before discounts and sales reversals are factored in
  • Track your revenue potential before any adjustments.
  • Compare full-price performance across products and time periods.
Full price before any adjustments. Use to understand demand at full price.Metric (Money total)
Line item discountsAmount deducted from specific line items in the sale
  • Track the effectiveness of product-specific discounts and promotions.
  • Choose which products to discount for maximum sales impact.
Metric (Money total)
Net items soldNumber of items in the given sale, with returns factored in
  • Track inventory movement after accounting for returns.
  • Plan inventory replenishment based on net items moving out of stock.
Metric (Count)
Net sales reversalsValue of sales reversals, with discounts factored in
Formula: gross sales reversals + discount reversals
  • Track the financial impact of returns on your business.
  • Plan cash flow and refund policies based on return values.
Total value of returned items. Use to understand return impact on revenue.Metric (Money total)
Net salesSales revenue, with discounts and sales reversals factored in
Formula: gross sales - discounts - sales reversals
  • Track your revenue after all adjustments and sales reversals.
  • Compare revenue performance across products and time periods after all adjustments.
Best approximation of actual revenue. Preferred over gross_sales for most analyses.Metric (Money total)
Net sales with cost recordedNet sales revenue where cost of goods sold is recorded
  • Focus profit analysis on products where you have complete cost data.
  • Calculate accurate margins for products with known costs.
Metric (Money total)
Net sales without cost recordedNet sales revenue where cost of goods sold isn't recorded
  • Identify products that need cost information added for profit analysis.
  • Track revenue from products where margin calculations aren't possible yet.
Metric (Money total)
New customersNumber of new customers who placed an order
  • Track customer acquisition performance across marketing channels.
  • Set customer acquisition goals and measure marketing campaign success.
First-time purchasers only. Use to measure acquisition effectiveness.Metric (Count)
Number of orders per customerAverage cumulative number of orders customers have placed at your store
  • Track customer loyalty and lifetime engagement with your brand.
  • Set goals for increasing repeat purchase frequency.
Metric (Count ratio)
Order-level discountsAmount deducted from the entire order
  • Track the effectiveness of store-wide promotions and discount codes.
  • Plan order-level promotions that encourage larger purchases.
Metric (Money total)
Order sale agreementsNumber of order sale agreements made
  • Track agreement-based sales for complex or high-value transactions.
  • Monitor contract-based revenue streams separate from standard orders.
Metric (Count)
Orders (first-time)Number of orders from first-time customers
  • Track customer acquisition success across different marketing channels.
  • Plan marketing budgets based on how many new customers you're attracting.
Metric (Count)
Orders (returning)Number of orders from customers who've bought from you before
  • Track customer retention success and loyalty program effectiveness.
  • Focus retention efforts on encouraging more repeat purchases.
Metric (Count)
Product and order discountsAmount discounted by all discounts other than shipping-specific discounts
  • Understand how much revenue you're giving up through product promotions.
  • Plan future discount budgets based on historical promotional spending.
Metric (Money total)
Product and order discounts from appsAmount discounted by apps from products and orders
  • Track how much third-party discount apps are costing your business.
  • Evaluate whether automated discount apps are delivering better results than manual promotions.
Metric (Money total)
Quantity orderedNumber of items ordered, before any returns
  • Track initial demand for products before returns impact the data.
  • Plan inventory levels based on ordering patterns before returns.
Total units ordered before returns. Useful for inventory planning.Metric (Count)
Quantity ordered per orderAverage number of items ordered, excluding reversed quantity
  • Encourage customers to buy more items per order through bundling and promotions.
  • Plan inventory and packaging based on typical order sizes.
Metric (Count ratio)
Reversed quantityNumber of items returned for the given sale
  • Account for expected returns during inventory planning.
  • Identify products, customer segments, or order attributes with high return rates.
Metric (Count)
Rate of staff-assisted salesPercentage of sales that were assisted by a staff member
  • Track the value of personal customer service in driving sales.
  • Plan staffing levels based on the impact of assisted sales on revenue.
Percentage of sales involving staff. Higher rates often mean higher AOV.Metric (Percentage & rate)
Return feesReturn fees associated with the given sale
  • Track revenue from return processing fees to offset return costs.
  • Decide whether return fees are helping or hurting customer satisfaction.
Metric (Money total)
Reversed quantity rateRatio of returned items to sold items
  • Identify products with high return rates that need quality improvements.
  • Set return rate benchmarks and monitor product performance against them.
Returns ÷ orders. Use as filter to find products with >10% return rates.Metric (Percentage & rate)
Returning customer ratePercentage of returning customers relative to all customers who placed orders
Formula: returning customers / customers
  • Gauge how well you're retaining customers versus attracting new ones.
  • Decide whether to focus marketing efforts on retention or acquisition.
Higher rates reduce acquisition costs. Most stores display 20-40%.Metric (Percentage & rate)
Returning customersNumber of returning customers who placed an order
  • Track customer retention success and loyalty program effectiveness.
  • Focus retention marketing on bringing back previous customers.
Customers who've purchased before. Key indicator of loyalty.Metric (Count)
Sales reversalsAmount refunded from sales revenue
  • Identify products with high return rates that need quality improvements.
  • Plan cash flow and inventory levels accounting for expected returns.
Negative value. Use as filter to identify products with high return amounts.Metric (Money total)
Shipping charge discountsAmount discounted from shipping charges
  • Track how much shipping revenue you give up through free shipping promotions.
  • Adjust shipping promotions to balance conversion rates with profit margins.
Metric (Money total)
Shipping charge taxesTaxes for shipping charges
  • Track tax obligations on shipping revenue for compliance reporting.
  • Plan shipping pricing strategies that account for tax requirements.
Metric (Money total)
Shipping chargesAmount customers spent on shipping
  • Evaluate whether to adjust shipping rates or offer free shipping promotions.
  • Track shipping revenue as a separate profit center in your business.
Metric (Money total)
Shipping discountsAmount discounted by shipping-specific discounts
  • Calculate the real cost of free shipping offers on your profit margins.
  • Determine optimal shipping discount thresholds to increase order values.
Metric (Money total)
Shipping discounts from appsAmount discounted by apps from shipping-specific charges
  • Monitor how much automated shipping discount apps are costing your business.
  • Compare app-generated shipping discounts with your manual promotional campaigns.
Metric (Money total)
Shipping reversalsValue of shipping charges refunded to the customer
  • Track how much shipping revenue you lose from returns.
  • Decide whether to adjust return policies to recover shipping costs.
Metric (Money total)
Shop Mini ordersNumber of orders placed inside of Shop MinisFocus more promotion and resources on Shop Minis that drive the most orders Redesign Shop Minis that rarely result in orders Metric (Count)
Shop Mini salesSales placed inside of Shop Minis
  • Calculate which Shop Minis generate the most revenue for your business.
  • Set benchmarks for how much sales each Shop Mini should drive.
Metric (Money total)
Shop post-purchase ordersNumber of orders resulting from Shop post-purchase offers
  • Track how many additional orders your post-purchase offers generate.
  • Calculate the conversion rate from offers sent to orders placed.
Metric (Count)
Shop post-purchase salesSales resulting from Shop post-purchase offersCreate more offers similar to the ones that generate the most additional revenue Stop using offers that customers rarely accept Metric (Money total)
Total item tax amountTaxes collected on the sale of taxable items
  • Report this exact amount to each state tax authority when filing returns.
  • Set aside this money in a separate account for tax payments.
Metric (Money total)
Total net item salesRevenue from individual product totals, not including shipping and fees
Formula: line item sales - discounts - sales reversals
  • Calculate the exact taxable sales amount to report on state tax returns.
  • Plan cash flow by understanding your pre-tax revenue in each state.
Metric (Money total)
Total shippingAmount customers were charged for shipping
  • Track shipping revenue separately for states that tax shipping differently than products.
  • Calculate total shipping charges to understand your logistics costs by state.
Metric (Money total)
Total shipping tax amountTaxes collected on shipping fees
  • Report shipping taxes separately where required by state tax authorities.
  • Identify states where shipping taxes create the biggest tax burden.
Metric (Money total)
Total exempt and non-taxable item salesCombined revenue from products that were exempt or non-taxable
Formula: total exempt item sales + total non-taxable item sales
  • Report total non-taxed sales to jurisdictions that require this breakdown.
  • Verify that your tax-free sales percentages match jurisdiction expectations.
Metric (Money total)
Total exempt item salesRevenue from products that were exempt from taxes
  • Report tax-exempt sales separately where required by local authorities.
  • Track which products qualify for tax exemptions in each jurisdiction.
Metric (Money total)
Total item tax amountTaxes collected on the sale of taxable items
  • Report this exact amount to each local tax authority when filing returns.
  • Set aside this money in separate accounts for each jurisdiction's tax payments.
Metric (Money total)
Total net item salesRevenue from individual product totals, not including shipping and fees
  • Calculate the exact taxable sales amount to report to each local jurisdiction.
  • Plan cash flow by understanding your pre-tax revenue in each area.
Metric (Money total)
Total non-taxable item salesRevenue from products that were non-taxable
  • Verify that non-taxable sales are correctly classified for each jurisdiction.
  • Track products that don't require tax collection in specific areas.
Metric (Money total)
Total shippingAmount customers were charged for shipping
  • Track shipping revenue separately for jurisdictions that tax shipping differently.
  • Calculate total shipping charges to understand logistics costs by area.
Metric (Money total)
Total shipping tax amountTaxes collected on shipping fees
  • Report shipping taxes separately where required by local tax authorities.
  • Identify jurisdictions where shipping taxes create significant tax burden.
Metric (Money total)
Total taxable item salesRevenue from products that were subject to taxes
  • Calculate the exact amount each jurisdiction should receive in tax payments.
  • Verify that taxable sales match the amounts you're collecting taxes on.
Metric (Money total)
DiscountsAmount discounted from transactions
  • Demonstrate to auditors how discounts reduced the taxable amount for each transaction.
  • Verify that tax calculations properly account for promotional discounts.
Metric (Money total)
Exempt amountSale amount that was exempt from tax due to customer's tax-exempt status
  • Provide detailed records of tax-exempt sales with customer documentation to justify non-collection.
  • Track which customers are using tax-exempt status for compliance verification.
Metric (Money total)
Gross sales on line itemsAmount in sales revenue from each line item before any adjustments
  • Display the full transaction trail from original price to final tax calculation.
  • Verify that tax calculations started with the correct gross amounts.
Metric (Money total)
Net sales on line itemsAmount in sales revenue from each line item, after discounts and sales reversals
Formula: line item sales - discounts - sales reversals
  • Demonstrate to auditors the final amount that taxes were calculated on.
  • Verify that net sales match your accounting records for each transaction.
Metric (Money total)
Non-taxable amountSale amount that was not subject to tax based on product classification
  • Provide detailed records showing why certain products aren't taxed under state law.
  • Track which products are consistently non-taxable to verify correct product classifications.
Metric (Money total)
Non-taxed amountSale revenue of all that was non-taxable or exempt
Formula: non-taxable amount + exempt amount
  • Display the total portion of each transaction that wasn't subject to tax.
  • Provide summary figures for audit reviews of non-taxed sales.
Metric (Money total)
ReturnsReturn amount applied to the product
  • Demonstrate how returns reduced the taxable amount for audit purposes.
  • Track which transactions involved returns that affected tax calculations.
Metric (Money total)
ShippingPortion of shipping costs allocated to this product
  • Provide line-item shipping records for jurisdictions that tax shipping differently.
  • Verify that shipping charges were allocated correctly across products in tax calculations.
Metric (Money total)
Tax amountTax collected on the taxable portion of a sale
  • Provide exact tax amounts collected for each transaction during audits.
  • Verify that tax collection matches the calculated rates and taxable amounts.
Metric (Money total)
Taxable amountSale amount that was subject to tax
  • Calculate tax owed by multiplying this amount by the jurisdiction's tax rate.
  • Keep detailed records of taxable amounts for audit protection.
Metric (Money total)
Subscriptions addedNumber of subscriptions your customers added in the given period
  • Identify which marketing campaigns drive the most new subscription sign-ups.
  • Scale up successful acquisition channels that bring in new subscribers.
Metric (Count)
Subscriptions canceledNumber of subscriptions your customers canceled in the given period
  • Create incentives to win back customers who canceled a subscription.
  • Identify spikes in cancellations that might indicate product or service issues.
Metric (Count)
TaxesTaxes for the given sale
  • Track total tax obligations for accurate financial reporting.
  • Plan cash flow for tax payments and compliance requirements.
Metric (Money total)
Taxes excluding gift cardsTaxes for the given sale, excluding those from gift cards
  • Track tax obligations for product sales separate from gift card transactions.
  • Plan tax reporting and compliance for your product revenue.
Metric (Money total)
Tax reversalsValue of taxes refunded to the customer
  • Track tax refunds for accurate financial reporting and compliance.
  • Plan cash flow for tax refunds on returned merchandise.
Metric (Money total)
TipsGratuity for the given sale
  • Track tip revenue from in-store or service-based sales.
  • Evaluate customer satisfaction through voluntary tip amounts.
Metric (Money total)
Total sales reversalsAmount of sales reversals (subtotal, discounts, shipping, fees, taxes)
Formula: net sales reversals + shipping reversals + return fees + tax reversals
  • Track the complete financial impact of returns including all components.
  • Plan return policies and cash reserves based on total return costs.
Metric (Money total)
Total salesAmount customers spent in your store (subtotal, discounts, taxes, fees, shipping, sales reversals)
Formula: net sales + additional fees + checkout fees + duties + shipping charges + taxes
  • Track the complete revenue impact including all fees and adjustments.
  • Compare total customer spending across different products and channels.
The complete amount customers paid, including taxes and shipping. Use for cash flow planning.Metric (Money total)
Total sales (first-time)Amount new customers spent in your store (subtotal, discounts, taxes, fees, shipping, sales reversals)
  • Track revenue from customer acquisition to measure marketing effectiveness.
  • Compare first-time customer value to customer acquisition costs.
Metric (Money total)
Total sales (returning)Amount returning customers spent in your store (subtotal, discounts, taxes, fees, shipping, sales reversals)
  • Track revenue from customer retention to measure loyalty program effectiveness.
  • Focus retention marketing on customers who generate the most repeat revenue.
Metric (Money total)
Total shipping chargesAmount customers spent on shipping
Formula: shipping charges - shipping discounts + shipping taxes
  • Track total shipping revenue including all adjustments and taxes.
  • Adjust shipping strategies to balance customer satisfaction and profitability.
Metric (Money total)
Collective supplierSupplier of the product sourced through Shopify Collective
  • Identify which supplier partnerships drive the most sales and profit.
  • Optimize your product mix by tracking top-performing Collective suppliers.
Dimension
Cost is recordedLabel specifying whether the sale has an associated cost of goods sold
  • Focus profit analysis on sales where you have complete cost data.
  • Update product cost information for more accurate revenue data.
Dimension
Discount classCategory indicating what the discount applies to (entire order, specific products, or shipping)
  • Identify which discount types drive the most sales and customer satisfaction.
  • Plan your promotional calendar around the most effective discount strategies.
Dimension
Discount codePromotional code entered by customer or applied automatically to receive the discount
  • Know which promotional codes customers actually remember and use.
  • Evaluate which campaigns drive the most sales.
Dimension
Discount IDShopify identifier for the specific discount
  • Track the performance of individual discount campaigns across all your sales channels.
  • Identify which specific promotions customers use most.
Dimension
Discount line IDShopify identifier for the discount line
  • Connect discount performance data to specific promotional codes or campaigns.
  • Track which discount strategies are driving the most sales.
Dimension
Discount methodHow the discount was triggered, such as discount code or automated rule
  • Evaluate your discount strategy holistically.
  • Reduce the need for manual staff intervention in discount processing.
Dimension
Discount namePromo code entered by the customer, or name auto-generated from a price rule
  • Identify specific discounts for analysis.
  • Plan future promotional campaigns using language that converts best.
Dimension
Discount shipping priceShipping cost before applying the discount, reflecting the pre-discount value
  • Evaluate how much shipping costs impact customer purchase decisions.
  • Set the right free shipping thresholds to increase average order values.
Dimension
Discount shipping titleDisplay name of the shipping discount when it was applied
  • Identify which shipping options customers choose when you offer free or discounted shipping.
  • Optimize your shipping promotions to encourage upgrades to faster delivery methods.
Dimension
Discount titleTitle of the discount when it was applied
  • Track how discount campaign names and messaging performed over time.
  • Avoid repeating promotional language that didn't drive strong results.
Dimension
Discount typeType of discount, such as a fixed amount off or a percentage reduction
  • Know whether your customers respond better to percentage or dollar-amount discounts.
  • Plan promotions that feel more valuable to customers and protect your margins.
Dimension
Discount valueAmount that was discounted
  • Calculate the real impact of discounts on your revenue and profit margins.
  • Compare which discount amounts work best for different products or customer segments.
Dimension
Excludes post-order adjustmentsLabel specifying whether the sale excludes adjustments made to the order after it was created
  • Focus on original sale data without post-purchase modifications.
  • Compare initial order values to final processed amounts.
Dimension
Filed by channelLabel indicating whether the channel filed taxes for the transaction
  • Identify which transactions you still need to file taxes for yourself.
  • Avoid double-filing taxes on transactions when the channel already handled it.
Dimension
Gift card IDShopify identifier for the gift card
  • Track gift card redemption patterns and liabilities.
  • Compare gift card payment success rates versus other payment methods.
Dimension
Is discounted saleLabel specifying whether the sale was discounted
  • Track discounted vs full-price revenue to anchor customer expectations to the full price.
  • Adjust your marketing tactics by tracking discount effectiveness.
Dimension
Is POS saleLabel specifying whether the sale was made at a physical retail location
  • Compare performance between online and in-store sales channels.
  • Allocate marketing budget between online and physical store channels.
Use as filter to separate in-store from online sales.Dimension
Is sales reversalLabel specifying whether the sale is associated with a return or return fee
  • Track the financial impact of returns on your overall revenue.
  • Separate return-related transactions from regular sales in your performance analysis.
Dimension
Is sale adjustmentLabel specifying whether the sale was an adjustment
  • Track post-purchase adjustments to understand order modification patterns.
  • Identify products or processes that frequently require adjustments.
Dimension
Is unverified returnLabel specifying whether the return is unverified
  • Prioritize processing returns that are still waiting for verification.
  • Monitor your return processing workflow and identify bottlenecks.
Dimension
Line item IDShopify identifier for the line item
  • Connect line item data to other business records for detailed analysis.
  • Track individual line item performance and identify patterns.
Dimension
Line typeSales line types include product, shipping, duty, taxes, and others
  • Build costs into your product prices, so customers aren't surprised by fees.
  • Set pricing for shipping, taxes, and fees to reduce cart abandonment.
Dimension
Order or sales reversalLabel specifying whether the sale event is an order or a sales reversal
  • Separate orders from returns in your analysis.
  • Track the value of new orders versus returns.
Dimension
Price rule discount titleTitle of the discount attached to a price rule when it was applied
  • Track which promotional campaigns generate the most sales across all your discount codes.
  • Plan future campaigns based on the messaging and themes that worked best.
Dimension
Price rule discount typeType of discount attached to the price rule, such as fixed amount or percentage
  • Review which discount structures you offer most often in your promotional campaigns.
  • Optimize your automated discounts to focus on the most effective discount methods.
Dimension
Price rule discount valueAmount of the discount based on a price rule
  • Understand how often discount limits and conditions reduce your intended promotional impact.
  • Plan discount campaigns that deliver the customer savings you intend.
Dimension
Price rule typeType of discount (percentage/fixed) and activation method (automatic/code)
  • Analyze which discount structures convert best to focus your promotional strategy.
  • Automate more of your successful discount campaigns to reduce manual work.
Dimension
Product title at time of saleDisplay name of the product at the time of its sale
  • Track how product name changes affect customer recognition and sales.
  • Analyze historical product performance even after you've updated the product title.
'Product title' displays the current name in your catalog. 'Product title at time of sale' preserves the historical name when the order was placed, which is useful when product names change over time.Dimension
Product type at time of saleType (category) assigned to the product at the time of its sale
  • Understand which product categories are driving your sales.
  • Focus marketing and inventory investments on your most profitable product types.
Dimension
Product variant compare at priceCompare at price of the product variant at the time of its sale
  • Know the discount amounts customers are getting when you mark down products.
  • Plan your pricing strategy by tracking the effectiveness of sales and promotions.
Dimension
Product variant pricePrice of the product variant at the time of its sale
  • Track the actual selling prices of your products over time.
  • Identify pricing trends and evaluate the impact of price changes on sales.
Dimension
Product variant SKU at time of saleSKU of the product variant at the time of its sale
  • Track individual SKU performance to optimize inventory levels and purchasing decisions.
  • Identify your best and worst performing SKUs for marketing and pricing strategies.
Dimension
Product variant title at time of saleDisplay name of the product variant at the time of its sale
  • Identify which specific variants (size, color, style) customers prefer.
  • Optimize your product variant naming strategy based on customer purchasing patterns.
Dimension
Product vendor at time of saleVendor of the product at the time of its sale
  • Identify which suppliers generate the most sales revenue for your business.
  • Negotiate better terms with vendors based on sales performance and volume.
Dimension
Refund IDShopify identifier for the refund
  • Connect refund data to other business records for detailed analysis.
  • Track individual refund performance and identify patterns.
Dimension
Return reasonReason the item was returned
  • Fix product quality issues and sizing problems by analyzing refunds in detail.
  • Update product descriptions to set better expectations and reduce returns.
Dimension
Sale IDShopify identifier for the sale
  • Connect individual sales records to other data in your store.
  • Track specific transactions across different reports and time periods.
Dimension
Sales channel IDShopify identifier for the sales channel
  • Connect sales performance back to specific marketing channels.
  • Track which sales channels are driving the most revenue.
Dimension
Sales channelName of the sales channel where the customer made a purchase
  • Focus your efforts on your highest-performing sales channels.
  • Adjust your product mix and sales strategies for each channel's unique audience.
Online Store, POS, Shop App, and others Use to compare channel performance.Dimension
Bundle IDShopify identifier for the bundle
  • Connect bundles, their sales performance, and individual products.
  • Track which bundles are selling together in the same orders.
Dimension
Sales tax IDShopify identifier for the sales tax
  • Review specific tax charges when customers question their bills or request refunds.
  • Track down tax calculation errors by linking to the exact tax record.
Dimension
Destination stateState the taxes are associated with
  • Organize your tax filings by state to meet each state's reporting requirements.
  • Focus compliance efforts on states with the highest taxable sales.
Dimension
Is filed by channelLabel indicating whether the channel filed taxes for the transaction
  • Know which transactions you still need to file taxes for versus ones already handled.
  • Avoid double-reporting taxes by identifying sales where the marketplace already filed.
Dimension
Destination stateState the taxes are associated with, typically based on shipping address
  • Organize your tax filings by state to meet each state's reporting requirements.
  • Focus compliance efforts on states with the highest taxable sales.
Dimension
Is filed by channelLabel indicating whether the channel filed taxes for the transaction
  • Know which transactions you still need to file taxes for versus ones already handled.
  • Avoid double-reporting taxes by identifying sales where the marketplace already filed.
Dimension
Tax countyCounty where the taxes apply
  • File county tax returns with the correct local tax authorities.
  • Track sales volume in counties that have different tax requirements.
Dimension
Tax jurisdictionName of the local tax authority
  • Identify which local governments require separate tax filings.
  • Contact the right tax authority when you have questions about rates or requirements.
Dimension
Tax jurisdiction codeCode used to identify the local tax authorityReview specific tax jurisdictions when filing returns or updating rates Cross-reference with tax authority databases to verify correct jurisdiction codes Dimension
Tax jurisdiction typeType of local government (city, county, district, and others)
  • Understand which level of government requires each tax filing.
  • Organize your tax compliance by jurisdiction type for easier management.
Dimension
Tax rateTax percentage charged on sales
  • Check that these rates match what local tax authorities require you to collect.
  • Update your tax settings when jurisdictions change their rates.
Dimension
ChannelSale channel used to place the order
  • Track tax collection differences between your online store and other sales channels.
  • Provide channel-specific tax data to accountants when preparing returns.
Dimension
Destination cityCity where the product was shipped
  • Verify that city taxes were calculated correctly for audit purposes.
  • Track sales volume in cities that have local tax requirements.
Dimension
Destination countryCountry where the product was shipped
  • Separate domestic and international sales for tax reporting.
  • Provide complete shipping destination records when auditors review individual transactions.
Dimension
Destination stateState where the product was shipped
  • Organize transaction records by state for tax filing purposes.
  • Provide state-specific transaction details to your accountant.
Dimension
Is filed by channelLabel indicating whether the sales channel filed taxes for the transaction
  • Identify which specific transactions you still need to file taxes for.
  • Provide documentation showing which sales were handled by sales channels during audits.
Dimension
Line item IDShopify identifier for the line item
  • Connect line item data to other business records for detailed analysis.
  • Track individual line item performance and identify patterns.
Dimension
Order numberShopify identifier for the order
  • Connect order data to other business records for detailed analysis.
  • Track individual order performance and identify patterns.
Dimension
Shopify reference IDShopify identifier for specific payment transactions or ordersReview complete transaction details in your Shopify admin when preparing tax documentation Reference specific transactions when helping your customers with questions about transactions Dimension
Tax countyCounty where the product was shipped
  • Verify that county taxes were applied correctly.
  • Track transaction volume in counties with special tax districts.
Dimension
Tax jurisdictionName of the local tax authority
  • Identify which local authorities collected taxes on specific transactions.
  • Provide jurisdiction-specific transaction records during audits.
Dimension
Tax jurisdiction codeCode used to identify the local tax authority
  • Cross-reference transaction records with tax authority databases.
  • Verify that the correct jurisdiction codes were used for each transaction.
Dimension
Tax jurisdiction typeType of local government (city, county, district, and others)
  • Understand which level of government each transaction was taxed by.
  • Organize tax documentation by jurisdiction type for easier review.
Dimension
Tax rateTax percentage charged on the sale
  • Verify that the correct tax rates were applied to each transaction.
  • Provide rate documentation when auditors question tax calculations.
Dimension
Subscription or one-timeLabel specifying whether the sale is a one-time or subscription purchase
  • Focus marketing efforts on building recurring subscription revenue.
  • Track the balance between one-time and recurring revenue streams.
Dimension

Sessions and behavior

Store traffic and visitor journeys, including page views and browsing patterns.

Table containing a list of all sessions and behavior analytics fields.
NameDescriptionUsesNotesType
Added to cart rateOnline store visits with items added to cart relative to total visits
Formula: sessions with cart additions / sessions
  • Review what percentage of visitors indicate serious buying interest.
  • Improve product pages if too few visitors add items to cart.
Checkouts can exceed add-to-cart counts when customers purchase directly from channels such as Instagram Shopping or Facebook Shops without visiting your cart page.Metric (Percentage & rate)
Average session durationAverage duration, in seconds, of online store visits
  • Set targets for how long visitors should spend on your online store.
  • Compare visit length across different time periods.
Measured in seconds. Longer isn't always better - depends on your store type.Metric (Avg duration (seconds))
Bounce ratePercentage of online store visits that ended after a single pageview
Formula: bounces / sessions
  • Measure how well your online store keeps visitors engaged.
  • Fix landing pages with high bounce rates.
High bounce rate isn't always bad - it might mean visitors found what they needed quickly.Metric (Percentage & rate)
BouncesOnline store visits that ended after a single pageview
  • Find visitors who leave immediately after arriving.
  • Improve landing pages that cause visitors to leave quickly.
Metric (Count)
Campaign added to cart rateCampaign-associated online store visits (sessions) with items added to cart relative to total campaign visits
Formula: sessions with cart additions / sessions
  • Review what percentage of campaign visitors indicate serious buying interest.
  • Improve campaign product pages if too few visitors add items to cart.
Metric (Percentage & rate)
Campaign average session durationAverage duration, in seconds, of campaign-associated online store visits
  • Set targets for how long campaign visitors should spend on your online store.
  • Compare campaign visit length across different time periods.
Metric (Avg duration (seconds))
Campaign bounce ratePercentage of campaign-associated online store visits (sessions) that ended after a single pageview
Formula: bounces / sessions
  • Measure how well your campaigns keep visitors engaged.
  • Fix campaign landing pages with high bounce rates.
Metric (Percentage & rate)
Campaign bouncesCampaign-associated online store visits that ended after a single pageview
  • Find campaign visitors who leave immediately after arriving.
  • Improve campaign landing pages that cause visitors to leave quickly.
Metric (Count)
Campaign checkout conversion rateCampaign-associated online store visits (sessions) with completed purchases relative to campaign visits that reached checkout
Formula: sessions that completed checkout / sessions that reached checkout
  • Measure how well your campaign checkout page converts visitors into customers.
  • Fix campaign checkout barriers that cause visitors to abandon their purchase.
Metric (Percentage & rate)
Campaign completed checkout rateCampaign-associated online store visits (sessions) that completed checkout after reaching checkout and adding items to cart relative to campaign visits reaching checkout with items added to cart
Formula: sessions with cart additions that reached checkout and completed checkout / sessions with cart additions that reached checkout
  • Review how well your campaign checkout process converts serious shoppers into customers.
  • Fix campaign checkout problems that prevent visitors from completing purchases.
Metric (Percentage & rate)
Campaign conversion ratePercentage of campaign-associated online store visits (sessions) that resulted in a sale
Formula: sessions that completed checkout / sessions
  • Track how well your campaigns turn browsers into customers.
  • Set benchmarks for converting campaign visitors into customers.
Metric (Percentage & rate)
Campaign online store visitorsUnique online store visitors from campaigns (one visitor can visit multiple times)
  • Track how many different people discover your online store through campaigns.
  • Measure campaign reach versus repeat campaign visits.
Metric (Count)
Campaign pageviewsTotal pageviews across all campaign-associated online store visits
  • Track how much content campaign visitors view on your online store.
  • Identify which campaign pages attract the most visitor attention.
Metric (Count)
Campaign-associated store pageviews per sessionAverage number of pageviews per campaign-associated online store visit
Formula: pageviews / sessions
  • Review how engaged campaign visitors are when they browse your online store.
  • Improve campaign site navigation if visitors view too few pages.
Metric (Count ratio)
Campaign reached checkout rateCampaign-associated online store visits (sessions) that reached checkout after adding items to cart relative to campaign visits with items added to cart
Formula: sessions that reached checkout / sessions
  • Track how well your campaigns guide interested visitors toward checkout.
  • Improve campaign cart design if visitors add items but don't proceed to checkout.
Metric (Percentage & rate)
Campaign sessionsNumber of campaign online store visits
  • Track how many times visitors browse your online store from campaigns.
  • Measure the traffic effectiveness of your campaigns.
Metric (Count)
Campaign sessions that completed checkoutCampaign-associated online store visits in which a purchase was completed
  • Track successful sales from campaign browsing visits.
  • Compare campaign conversion rates across different time periods.
Metric (Count)
Campaign sessions that reached and completed checkoutCampaign-associated online store visits in which the checkout page was reached, then purchase was completed
  • Track how well your campaign checkout process converts visitors into customers.
  • Measure campaign checkout success rates to identify improvement opportunities.
Metric (Count)
Campaign sessions that reached checkoutCampaign-associated online store visits in which the checkout page was reached
  • Track how many campaign visitors make it to your checkout page.
  • Fix checkout issues if too many campaign visitors abandon at this step.
Metric (Count)
Campaign sessions with cart additionsCampaign-associated online store visits in which a visitor added an item to cart
  • Track how many campaign visitors indicate serious buying interest.
  • Send cart abandonment emails to campaign visitors who don't complete purchase.
Metric (Count)
Checkout conversion rateOnline store visits with completed purchases relative to visits that reached checkout
Formula: sessions that completed checkout / sessions that reached checkout
  • Measure how well your checkout page converts visitors into customers.
  • Fix checkout barriers that cause visitors to abandon their purchase.
Checkout completions ÷ checkout starts. Low rates suggest checkout friction.Metric (Percentage & rate)
CLS distributionDistribution of Cumulative Layout Shift score
  • Review what percentage of visitors experience good, moderate, or poor layout stability.
  • Track how layout improvements move more visitors into the good experience category.
Metric (Array)
CLS good view countNumber of page load events with a good CLS score
  • Track how many visitors have a good experience with stable page layouts.
  • Measure the success of layout improvements you make to your site.
Metric (Count)
CLS okay view countNumber of page load events with a needs improvement CLS score
  • Identify visitors experiencing moderate layout issues that need fixing.
  • Prioritize layout improvements to move more visitors into the good experience category.
Metric (Count)
CLS poor view countNumber of page load events with a poor CLS score
  • Identify how many visitors experience content jumping around on your pages.
  • Fix layout issues that are creating poor experiences for too many visitors.
Metric (Count)
Completed checkout rateOnline store visits that completed checkout after reaching checkout and adding items to cart relative to visits reaching checkout with items added to cart
Formula: sessions with cart additions that reached checkout and completed checkout / sessions with cart additions that reached checkout
  • Review how well your checkout process converts serious shoppers into customers.
  • Fix checkout problems that prevent visitors from completing purchases.
Metric (Percentage & rate)
Conversion ratePercentage of online store visits (sessions) that resulted in a sale
Formula: sessions that completed checkout / sessions
  • Track how well your online store turns browsers into customers.
  • Set benchmarks for converting visitors into customers.
Might appear lower than expected due to bot traffic. Filter by 'Human' traffic for a more accurate view of actual customer behavior.Metric (Percentage & rate)
FCP distributionDistribution of First Contentful Paint score
  • Review what percentage of visitors experience fast, moderate, or slow initial content loading.
  • Track how speed improvements help more vistors view content faster.
Metric (Array)
FCP good view countNumber of page load events with a good FCP score
  • Track how many visitors view your content appear quickly.
  • Measure the success of improvements you make to initial page loading speed.
Metric (Count)
FCP okay view countNumber of page load events with a needs improvement FCP score
  • Identify visitors experiencing delays before viewing any content.
  • Prioritize improvements to help more visitors view content faster.
Metric (Count)
FCP P5050th percentile of First Contentful Paint score, in milliseconds
  • Optimize your site so visitors view content appear faster.
  • Reduce the time visitors spend looking at blank pages.
Metric (Duration (milliseconds))
FCP P7575th percentile of First Contentful Paint score, in milliseconds
  • Optimize your site so visitors view content appear faster.
  • Reduce the time visitors spend looking at blank pages.
Metric (Duration (milliseconds))
FCP P9090th percentile of First Contentful Paint score, in milliseconds
  • Optimize your site so visitors view content appear faster.
  • Reduce the time visitors spend looking at blank pages.
Metric (Duration (milliseconds))
FCP P9999th percentile of First Contentful Paint score, in milliseconds
  • Optimize your site so visitors view content appear faster.
  • Reduce the time visitors spend looking at blank pages.
Metric (Duration (milliseconds))
FCP poor view countNumber of page load events with a poor FCP score
  • Identify how many visitors experience delays before viewing any content.
  • Fix initial loading issues that frustrate visitors with blank pages.
Metric (Count)
Form conversion rateConversion rate of Shopify Forms
Formula: form_submissions / form_views
  • Remove fields — and friction — from forms with low completion rates.
  • Test different form designs to increase the percentage of visitors who submit them.
Metric (Percentage & rate)
Form submissionsSubmissions of Shopify Forms
  • Calculate your cost per lead by dividing marketing costs by form submissions.
  • Follow up with leads within 24 hours to increase sales.
Metric (Count)
Form viewsViews of Shopify Forms
  • Track which forms get the most visibility from customers.
  • Improve forms that get views but few submissions.
Metric (Count)
Global search requestsNumber of unique global search requests
  • Improve product findability for the most common customer search terms.
  • Add new products that customers are searching for but not finding.
Metric (Count)
INP distributionDistribution of Interaction to Next Paint score
  • Review what percentage of visitors can interact with your site without delays.
  • Track how responsiveness improvements help more visitors navigate smoothly.
Metric (Array)
INP good view countNumber of page load events with a good INP score
  • Track how many visiotrs can click buttons and links without delays.
  • Measure the success of improvements you make to page responsiveness.
Metric (Count)
INP okay view countNumber of page load events with a needs improvement INP score
  • Identify visitors experiencing delays when clicking buttons and links.
  • Remove unnecessary code when too many visitors experience slow interactions.
Metric (Count)
INP P50The Interaction to Next Paint (INP) score measures interactivity based on how long it takes the page to become responsive to most user actions, such as clicking a link or a button. An INP score of less than 200 milliseconds for the 75th percentile of users is considered a good performance as the page becomes interactive quickly.
  • Optimize your site so visitors can interact with buttons and links without delays.
  • Remove slow-loading apps or code when this time exceeds 200 milliseconds.
Metric (Duration (milliseconds))
INP P75The Interaction to Next Paint (INP) score measures interactivity based on how long it takes the page to become responsive to most user actions, such as clicking a link or a button. An INP score of less than 200 milliseconds for the 75th percentile of users is considered a good performance as the page becomes interactive quickly.
  • Optimize your site so visitors can interact with buttons and links without delays.
  • Remove slow-loading apps or code when this time exceeds 200 milliseconds.
Metric (Duration (milliseconds))
INP P90The Interaction to Next Paint (INP) score measures interactivity based on how long it takes the page to become responsive to most user actions, such as clicking a link or a button. An INP score of less than 200 milliseconds for the 75th percentile of users is considered a good performance as the page becomes interactive quickly.
  • Optimize your site so visitors can interact with buttons and links without delays.
  • Remove slow-loading apps or code when this time exceeds 200 milliseconds.
Metric (Duration (milliseconds))
INP P99The Interaction to Next Paint (INP) score measures interactivity based on how long it takes the page to become responsive to most user actions, such as clicking a link or a button. An INP score of less than 200 milliseconds for the 75th percentile of users is considered a good performance as the page becomes interactive quickly.
  • Optimize your site so visitors can interact with buttons and links without delays.
  • Remove slow-loading apps or code when this time exceeds 200 milliseconds.
Metric (Duration (milliseconds))
INP poor view countNumber of page load events with a poor INP score
  • Identify how many visitors experience unresponsive buttons and links.
  • Fix interaction delays that prevent visitors from navigating your site smoothly.
Metric (Count)
LCP distributionDistribution of Largest Contentful Paint score
  • Review what percentage of visitors experience fast, moderate, or slow page loading.
  • Track how speed improvements move more visits into the fast-loading category.
Metric (Array)
LCP good view countNumber of page load events with a good LCP score
  • Track how many visitors experience fast-loading pages.
  • Measure the success of speed improvements you make to your site.
Metric (Count)
LCP okay view countNumber of page load events with a needs improvement LCP score
  • Identify visitors experiencing moderate loading speeds that need improvement.
  • Prioritize speed improvements to move more visitors into the fast-loading category.
Metric (Count)
LCP P50Largest Contentful Paint (LCP) measures loading speed, based on how fast the largest element or main content becomes visible to visitors. A good LCP score is when the main content is loaded within 2,500 milliseconds for the 75th percentile of users.Optimize images and content to improve page loading speed Compress large images when loading times exceed 2.5 seconds Metric (Duration (milliseconds))
LCP P75Largest Contentful Paint (LCP) score measures loading speed, based on how fast the largest element or main content becomes visible to visitors. A good LCP score is when the main content is loaded within 2,500 milliseconds for the 75th percentile of users.Optimize images and content to improve page loading speed Compress large images when loading times exceed 2.5 seconds Metric (Duration (milliseconds))
LCP P90Largest Contentful Paint (LCP) score measures loading speed, based on how fast the largest element or main content becomes visible to visitors. A good LCP score is when the main content is loaded within 2,500 milliseconds for the 75th percentile of users.Optimize images and content to improve page loading speed Compress large images when loading times exceed 2.5 seconds Metric (Duration (milliseconds))
LCP P99Largest Contentful Paint (LCP) score measures loading speed, based on how fast the largest element or main content becomes visible to visitors. A good LCP score is when the main content is loaded within 2,500 milliseconds for the 75th percentile of users.Optimize images and content to improve page loading speed Compress large images when loading times exceed 2.5 seconds Metric (Duration (milliseconds))
LCP poor view countNumber of page load events with a poor LCP score
  • Identify how many visitors experience slow-loading pages.
  • Fix loading speed issues that are creating poor experiences for too many visitors.
Metric (Count)
Online store visitorsUnique visitors (one visitor can visit multiple times)
  • Track how many different people discover your online store.
  • Measure your reach versus repeat visits.
Unique visitors - one person visiting 5 times counts as 1 visitor but 5 sessions.Metric (Count)
CLS P50Cumulative Layout Shift (CLS) measuring visual stability, in which content doesn't shift unexpectedly on the page. CLS score <0.1 for 75th percentile is considered good.
  • Fix images and elements that jump around and confuse visitors.
  • Improve visual stability by reducing unexpected content movement.
Metric (Dimensionless score)
CLS P75Cumulative Layout Shift (CLS) measuring visual stability, in which content doesn't shift unexpectedly on the page. CLS score <0.1 for 75th percentile is considered good.
  • Fix images and elements that jump around and confuse visitors.
  • Improve visual stability by reducing unexpected content movement.
Metric (Dimensionless score)
CLS P90Cumulative Layout Shift (CLS) measuring visual stability, in which content doesn't shift unexpectedly on the page. CLS score <0.1 for 75th percentile is considered good.
  • Fix images and elements that jump around and confuse visitors.
  • Improve visual stability by reducing unexpected content movement.
Metric (Dimensionless score)
CLS P99Cumulative Layout Shift (CLS) measuring visual stability, in which content doesn't shift unexpectedly on the page. CLS score <0.1 for 75th percentile is considered good.
  • Fix images and elements that jump around and confuse visitors.
  • Improve visual stability by reducing unexpected content movement.
Metric (Dimensionless score)
Page loadsTotal number of page load events
  • Focus performance improvements on pages that get the most traffic.
  • Invest in faster hosting if page loads consistently increase without sales growing.
Metric (Count)
PageviewsTotal pageviews across all online store visits
  • Track how much content visitors view on your online store.
  • Identify which pages attract the most visitor attention.
Metric (Count)
Pageviews per sessionAverage number of pageviews per online store visit
Formula: pageviews / sessions
  • Review how engaged visitors are when they browse your online store.
  • Improve site navigation if visitors view too few pages.
Metric (Count ratio)
Percent of page loadsPercent of total page load events
  • Compare performance across different pages, devices, or time periods.
  • Focus optimization efforts on the biggest performance problems affecting the most visitors.
Metric (Percentage & rate)
Product added to cart ratePercentage of store sessions where the product was added to the cart, relative to its views
  • Identify which products spark customer interest but need better conversion.
  • Improve product pages for items that get viewed but not added to cart.
Metric (Percentage & rate)
Product added to cart (session count)Store sessions where the product was added to the cart
  • Find products that customers want but might not be buying.
  • Send cart abandonment emails for products customers add but don't purchase.
Metric (Count)
Product checkout conversion ratePercentage of store sessions where the product was purchased, relative to the visitor reaching checkout with it
  • Find products that successfully close the sale after customers reach checkout.
  • Fix final checkout barriers for products that lose customers at the end.
Metric (Percentage & rate)
Product completed checkout ratePurchase rate after set steps on your store: view → cart → checkout → purchase
  • Identify which products successfully guide customers through the full buying process.
  • Fix checkout problems for products that lose customers at the final step.
Metric (Percentage & rate)
Product conversion ratePercentage of store sessions where the product was purchased, relative to its views
  • Find products that convert browsers into customers most effectively.
  • Identify products that need better descriptions or pricing to convert.
Metric (Percentage & rate)
Product purchased (session count)Store sessions where the product was purchased
  • Track which products drive completed sales.
  • Focus inventory and marketing on products that convert best.
Metric (Count)
Product reached checkout ratePercentage of store sessions where the product reached checkout, relative to its views
  • Find products that successfully move customers toward purchase.
  • Identify products that lose customers before they reach checkout.
Metric (Percentage & rate)
Product reached checkout (session count)Store sessions where the product reached the checkout page
  • Identify which products make it far in the buying process.
  • Fix checkout issues for products that reach checkout but don't convert.
Metric (Count)
Product recommendation added to cart ratePercentage of sessions with product recommendations where customers added a recommended item to their cart
  • Identify which recommendations convince customers to buy something.
  • Focus on recommendation strategies that move customers closer to purchase.
Metric (Percentage & rate)
Product recommendation click ratePercentage of sessions with product recommendations where customers clicked on at least one recommendation
  • Find out which recommendations customers find appealing versus irrelevant.
  • Replace low-performing recommendations with products that get more clicks.
Metric (Percentage & rate)
Product recommendation conversion ratePercentage of sessions with product recommendations where customers purchased a recommended item
  • Measure how much revenue your recommendation system generates.
  • Optimize recommendations to focus on products that drive completed sales.
Metric (Percentage & rate)
Product recommendation low click rateOnline store sessions in which a customer clicked on a product recommendation relative to all sessions with product recommendations
  • Remove or replace product recommendations that customers consistently ignore.
  • Test different product recommendation strategies to improve engagement.
Metric (Percentage & rate)
Product recommendation performance gapDifference between this recommendation's click rate and your store's 30-day average click rate
  • Identify recommendations that perform worse than your store average.
  • Prioritize fixing the recommendations with the biggest performance gaps.
Metric (Percentage & rate)
Product recommendation sessions that completed checkoutNumber of online store sessions in which a customer clicked on a product recommendation and purchased that recommended item
  • Track how many sales your product recommendations generate.
  • Calculate the revenue impact of your recommendation system.
Metric (Count)
Product recommendation sessions with cart additionsNumber of online store sessions in which a customer clicked on a product recommendation and added that recommended item to their cart
  • Track how many customers want the products you recommend.
  • Measure how well recommendations move customers toward purchase.
Metric (Count)
Product recommendation sessions with clicksNumber of online store sessions in which a customer clicked on a product recommendation
  • See how many customers find your recommendations interesting enough to click.
  • Track which recommendations grab customer attention versus those that get ignored.
Metric (Count)
Product viewed (session count)Store sessions where the product was viewed
  • Identify which products get the most attention from customers.
  • Focus marketing efforts on products that already attract interest.
Metric (Count)
Reached checkout rateOnline store visits that reached checkout relative to total visits
Formula: sessions that reached checkout / sessions
  • Track what percentage of visitors make it to checkout.
  • Improve your cart and product pages if too few visitors reach checkout.
Checkouts can exceed add-to-cart counts when customers purchase directly from channels such as Instagram Shopping or Facebook Shops without visiting your cart page.Metric (Percentage & rate)
Search added to cart rateOnline store sessions with searches and items added to cart relative to all sessions with searches
  • Improve search results to better match what customers want to buy.
  • Set benchmarks for how often search should lead to cart additions.
Metric (Percentage & rate)
Search click rateOnline store sessions in which a customer clicked a search result relative to all sessions with searches
  • Fix search results that customers ignore by improving product titles and descriptions.
  • Add popular products that aren't showing up in search results.
Metric (Percentage & rate)
Search conversion rateOnline store sessions with searches and a completed purchase relative to all sessions with searches
  • Improve your search results to convert more searchers into customers.
  • Test different product descriptions and images to boost conversion rates.
Metric (Percentage & rate)
Search queriesNumber of search queries
  • Track how much customers rely on search to navigate your store.
  • Improve site navigation when high search volume suggests browsing issues.
Metric (Count)
Search queries with clicksNumber of search queries in which the customer clicked on a search result
  • Promote the products that customers click after searching.
  • Use these successful search terms in your advertising campaigns.
Metric (Count)
Search sessions that completed checkoutNumber of online store sessions in which a customer searched your site and also made a purchase
  • Count how many searchers buy products after finding them.
  • Schedule promotions during times when search-driven sales peak.
Metric (Count)
Search sessions with cart additionsNumber of online store sessions in which a customer searched your site and also added an item to the cart
  • Track how well search results lead customers to products they want to buy.
  • Compare added-to-cart rates across different search terms to optimize results.
Metric (Count)
Search sessions with clicksNumber of online store sessions in which a customer clicked on a search result
  • Identify when search results are compelling enough to click.
  • Improve product titles and images for searches that get few clicks.
Metric (Count)
SearchesNumber of search queries made on your online store
  • Track how much customers rely on search to navigate your store.
  • Improve site navigation if search volume is too high compared to browsing.
Metric (Count)
SessionsNumber of online store visits
  • Track how many times visitors browse your online store.
  • Measure the effectiveness of your marketing campaigns.
Only counted when visitors consent to cookies through your cookie banner. If counts seem low, then verify your cookie banner is displaying and functioning correctly. Note: other analytics platforms calculate sessions differently.Metric (Count)
Sessions that completed checkoutOnline store visits in which a purchase was completed
  • Track successful sales from browsing visits.
  • Compare conversion rates across different time periods.
Metric (Count)
Sessions that reached and completed checkoutOnline store visits in which the checkout page was reached, then purchase was completed
  • Track how well your checkout process converts visitors into customers.
  • Measure checkout success rates to identify improvement opportunities.
Metric (Count)
Sessions that reached checkoutOnline store visits in which the checkout page was reached
  • Track how many visitors make it to your checkout page.
  • Fix checkout issues if too many visitors abandon at this step.
Checkouts can exceed add-to-cart counts when customers purchase directly from channels such as Instagram Shopping or Facebook Shops without visiting your cart page.Metric (Count)
Sessions with cart additionsOnline store visits in which a visitor added an item to cart
  • Track how many visitors indicate serious buying interest.
  • Send cart abandonment emails to visitors who don't complete their purchase.
Use as filter to analyze only high-intent visitors.Metric (Count)
Sessions with product recommendationsNumber of online store sessions in which a customer was displayed a product recommendation
  • Track how many customers view your product recommendations.
  • Measure the reach of your recommendation system across customer sessions.
Metric (Count)
Sessions with searchesNumber of online store sessions with searches
  • Track how many visitors rely on search to find products on your site.
  • Improve site navigation if too many customers need to use search.
Metric (Count)
Shop Mini opensNumber of times a Shop Mini was openedPromote the Shop Minis that get opened most frequently Redesign Shop Minis with low open rates Metric (Count)
Shop post-purchase offersNumber of customers who received a Shop post-purchase offer
  • Track how many customers you're reaching with post-purchase offers.
  • Calculate the redemption rate by comparing offers sent to offers used.
Metric (Count)
Shop product impressionsNumber of times products were viewed in the Shop channel
  • Feature your most-viewed products in your main store navigation.
  • Create similar products to the ones that get the most impressions.
Metric (Count)
Shop review conversion ratePercentage of Shop review push notifications that resulted in a review
  • Test different review request messages to increase response rates.
  • Send your review requests when customers are likely to be most satisfied.
Metric (Percentage & rate)
TTFB distributionDistribution of Time to First Byte score
  • Review what percentage of visitors experience fast, moderate, or slow server responses.
  • Track how hosting improvements help more visitors connect to your server faster.
Metric (Array)
TTFB good view countNumber of page load events with a good TTFB score
  • Track how many visitors connect to your server quickly.
  • Measure the success of hosting improvements you make.
Metric (Count)
TTFB okay view countNumber of page load events with a needs improvement TTFB score
  • Identify visitors experiencing server response delays.
  • Consider hosting upgrades when too many visitors have slow server connections.
Metric (Count)
TTFB P5050th percentile of Time to First Byte score, in milliseconds
  • Monitor server response times and upgrade hosting when consistently slow.
  • Fix server issues that prevent visitors from connecting quickly.
Metric (Duration (milliseconds))
TTFB P7575th percentile of Time to First Byte score, in milliseconds
  • Monitor server response times and upgrade hosting when consistently slow.
  • Fix server issues that prevent visitors from connecting quickly.
Metric (Duration (milliseconds))
TTFB P9090th percentile of Time to First Byte score, in milliseconds
  • Monitor server response times and upgrade hosting when consistently slow.
  • Fix server issues that prevent visitors from connecting quickly.
Metric (Duration (milliseconds))
TTFB P9999th percentile of Time to First Byte score, in milliseconds
  • Monitor server response times and upgrade hosting when consistently slow.
  • Fix server issues that prevent visitors from connecting quickly.
Metric (Duration (milliseconds))
TTFB poor view countNumber of page load events with a poor TTFB score
  • Identify how many visitors experience slow server response times.
  • Upgrade your hosting when too many visitors can't connect to your server quickly.
Metric (Count)
Browser familyType of web browser used for the session
  • Fix browser-specific performance issues that might be costing you sales.
  • Test your site improvements on the browsers your visitors use most.
Dimension
Cumulative layout shift targetAsset for which cumulative layout shift is measured
  • Fix specific images or elements that jump around and confuse visitors.
  • Optimize the elements that cause the most layout problems during page loading.
Dimension
Device typeType of device used for the session
  • Optimize your mobile site when mobile users experience slower speeds than desktop users.
  • Focus performance improvements on the device type that drives the most sales.
Dimension
Form IDShopify identifier for the Shopify Form
  • Connect form data to other business records for detailed analysis.
  • Track individual form performance and identify patterns.
Dimension
Form page typeType of page where the Shopify Form was displayed
  • Focus form placement on page types where customers complete them most.
  • Remove forms from page types with poor completion rates.
Dimension
Form typeType of Shopify Form displayed
  • Test popup versus inline forms to determine which converts better.
  • Use the form type that generates the most submissions for each page.
Dimension
Human or bot sessionWhether store traffic comes from human visitors or automated bots
  • Filter out bots from your session analysis.
  • Understand high-volume bot traffic during peak times.
Dimension
Interaction to next paint targetAsset for which interaction to next paint is measured
  • Fix specific buttons or links that respond too slowly when people click them.
  • Remove or optimize elements that make your pages feel unresponsive.
Dimension
Is article search queryLabel indicating whether the search query was for an article
  • Create more blog content around topics customers search for frequently.
  • Use article searches to identify product education opportunities.
Dimension
Is page search queryLabel indicating whether the search query was for a page
  • Improve site navigation for pages customers have trouble finding.
  • Add important pages to your main menu if customers search for them often.
Dimension
Is product search queryLabel indicating whether the search query was for a product
  • Focus on improving product searches since these drive sales most directly.
  • Compare product search success rates to other types of searches.
Dimension
Landing page pathThe first page a visitor landed on when they arrived at your online store
  • Identify the most common entry points to your online store.
  • Improve landing pages to better convert new visitors.
Dimension
Landing page typeType of the first page a visitor landed on when they arrived at your online store
  • Review what types of pages visitors land on most.
  • Focus optimization efforts on your most popular landing page types.
Dimension
Landing page URLThe first page a visitor landed on when they arrived at your online store
  • Identify which pages visitors land on when they find your online store.
  • Optimize landing pages that bring in the most traffic.
Dimension
Largest contentful paint targetAsset for which largest contentful paint is measured
  • Compress or optimize the specific images that load slowest on your pages.
  • Replace large images that make your pages load too slowly for visitors.
Dimension
Micro session IDShopify identifier for the online store session
  • Connect session data to other business records for detailed analysis.
  • Track individual session performance and identify patterns.
Dimension
Page typeType of the page of an online store session, such as collection
  • Focus performance improvements on the page types that convert visitors into customers.
  • Fix slow-loading product pages that might be preventing sales.
Dimension
Referrer domainDomain of the site that led to the online store visit
  • Track which domains send traffic to your online store.
  • Focus marketing efforts on domains that drive conversions.
Dimension
Referrer nameName of the site that led to the online store visit
  • Identify your most valuable traffic sources by their brand names.
  • Negotiate better partnerships with high-performing referral sources.
Dimension
Referrer pathPath of the site that led to the online store visit
  • Identify which specific pages on other sites link to your online store.
  • Build relationships with sites that send valuable traffic.
Dimension
Referrer siteSite that led to the online store visit
  • Identify which websites send the most traffic to your online store.
  • Build partnerships with sites that drive valuable visitors.
Dimension
Referrer sourceReferrer type that led to the online store visit (organic, email, and others)
  • Focus marketing budget on the channels that drive the most traffic.
  • Compare conversion rates across different traffic sources.
Automatically detected traffic source. More reliable than UTM for organic traffic.Dimension
Referrer termsSearch engine query that led to the online store visit
  • Review what visitors search for before finding your online store.
  • Optimize your SEO for the search terms that drive traffic.
Dimension
Referrer URLExternal page that led to the online store visit
  • Track which specific external pages drive traffic to your online store.
  • Build partnerships with pages that send valuable visitors.
Dimension
Search querySearch query made on your online storeAdd these exact words to your product titles and descriptions for better search results Stock new products that customers are searching for but can't find Dimension
Search query intentIntent of the search query made on your online store
  • Focus on the types of searches that lead to purchases versus just browsing.
  • Create content and products that match what customers are looking for.
Dimension
Search result was clickedLabel indicating whether the customer clicked on one of the search query's results
  • Identify search terms that display good results versus ones that need improvement.
  • Focus on fixing searches where customers don't click any results.
Dimension
Search results were returnedLabel indicating whether the search query returned results
  • Fix searches that return zero results by adding missing products.
  • Update product descriptions to include common search terms.
Dimension
AppIdentifier of the client type (hydrogen, headless, or online store) based on the API client ID
  • Focus development resources on your key storefront type.
  • Compare performance across different storefront interfaces.
Dimension
Session bouncedLabel indicating whether the online store visit ended after a single pageview
  • Identify visits where visitors left immediately.
  • Improve landing pages that cause high bounce rates.
Dimension
Session cityCity from which a visitor browsed your online store
  • Target marketing campaigns to cities with the most visitors.
  • Adjust shipping and inventory strategies based on where visitors live.
Dimension
Session countryCountry from which a visitor browsed your online store
  • Expand to countries with growing visitor interest.
  • Set up international shipping for countries with high traffic.
Visitor's country based on IP address. May have some inaccuracy with VPNs.Dimension
Session country codeCountry code of the country from which a visitor browsed your online store
  • Filter and segment visitors by specific countries.
  • Set up country-specific pricing and shipping rules.
Dimension
Session browserBrowser used to visit your online store
  • Focus testing efforts on the browsers visitors use most.
  • Fix display issues that affect popular browsers.
Dimension
Session browser versionVersion number of the browser used to visit your online storeUpdate your online store to work with the browser versions visitors use Stop supporting outdated versions that few visitors use Dimension
Session device OSOperating system of the device used for visiting your online store
  • Focus testing efforts on the operating systems visitors use most.
  • Fix compatibility issues with popular operating systems.
Dimension
Session device OS versionOperating system version of the visitor's deviceUpdate your online store to work with the OS versions visitors use Drop support for outdated versions that few visitors use Dimension
Session device typeDevice type used to visit your online store
  • Focus design efforts on the devices visitors use most.
  • Test your online store thoroughly on mobile if most visitors shop on phones.
Dimension
Session durationDuration, in seconds, of the online store visit
  • See how long visitors spend browsing your online store.
  • Improve site engagement if visitors leave too quickly.
Dimension
Session IDShopify identifier for a visit to your online store
  • Connect session data to other business records for detailed analysis.
  • Track individual session performance and identify patterns.
Dimension
Session regionState or province from which a visitor browsed your online store
  • Focus marketing efforts on regions with the most visitors.
  • Plan regional shipping rates and delivery options.
Dimension
Shop Mini nameName of the Shop Mini
  • Scale up Shop Minis that customers engage with most frequently.
  • Remove or redesign Shop Minis that customers rarely open.
Dimension
Shop post-purchase discount codeDiscount code created through the Shop post-purchase offer
  • Track which specific offers drive the most repeat purchases.
  • Test different discount tactics to determine what converts best.
Dimension
UTM campaignUTM name of the campaign that led to the online store visit
  • Track which campaigns drive the most traffic to your online store.
  • Compare conversion rates across different campaign types.
Which campaign drove the traffic. Requires consistent UTM naming conventions.Dimension
UTM contentUTM content of the campaign that led to the online store visit
  • Compare performance of different ad creatives and messages.
  • Create more ads similar to the content that converts best.
Dimension
UTM mediumUTM medium of the campaign associated with the online store visit
  • Identify which marketing mediums work best for your online store.
  • Allocate budget to the mediums that drive the most conversions.
Marketing medium (cpc, email, social). Standardize values for accurate grouping.Dimension
UTM sourceUTM source of the campaign that led to the online store visit
  • Track which traffic sources from your campaigns perform best.
  • Focus marketing spend on sources that drive quality traffic.
Where traffic came from (google, facebook, newsletter). Requires UTM tagging.Dimension
UTM termUTM term of the campaign that led to the online store visit
  • Review which keywords and terms drive traffic from your campaigns.
  • Optimize ad targeting for terms that convert best.
Dimension

Stores

Compare your various online stores and brands.

Table containing a list of all stores analytics fields.
NameDescriptionUsesNotesType
Shop IDShopify identifier for the shop
  • Filter rollouts by specific shops or merchants.
  • Compare rollout performance across different shops.
Dimension
Store nameName of your store
  • Filter analytics data to focus on one specific store when you have multiple stores.
  • Compare sales performance between different store brands.
Dimension

Time

Fields for grouping and filtering data by dates, times, and temporal patterns.

Table containing a list of all time analytics fields.
NameDescriptionUsesNotesType
DayDay (timestamp) the data was recorded Most common time grouping. Use week or month for trend analysis.Dimension
Day of weekDay of week the data was recorded 1=Monday through 7=Sunday. Use to identify peak shopping days.Dimension
HourHour (timestamp) the data was recorded Dimension
Hour of dayHour of day the data was recorded 0-23 hour format. Useful for scheduling promotions and ads.Dimension
MinuteMinute (timestamp) the data was recorded Dimension
MonthMonth (timestamp) the data was recorded Dimension
Month of yearMonth of year the data was recorded Dimension
QuarterQuarter (timestamp) the data was recorded Dimension
SecondSecond (timestamp) the data was recorded Dimension
Sale dateDate when the transaction was placed
  • Organize tax records by reporting periods for filing deadlines.
  • Provide precise transaction dates to auditors.
Dimension
WeekWeek (timestamp) the data was recorded Dimension
Week of yearWeek of year the data was recorded Dimension
YearYear (timestamp) the data was recorded Dimension