Glossary
Abandoned Checkouts:
The total count of checkouts initiated but not completed by the customer.
Abandoned Cart Value (Bins):
This field categorizes the total value of abandoned carts into predefined value bins. Each bin represents a specific range of cart values for checkouts that were initiated but not completed. For example, if an abandoned cart has a value of £12, it would fall into the £010-015 bin.
Acquired Customers
The total number of customers who have made their first purchase.
Actual
This represents the value of the metric for the Selected Year.
Ad Platform
A digital service or network where businesses can create, manage, and display advertisements to reach their target audiences. For example, Google Ads, Meta Ads, TikTok Ads, etc.
Add to Cart
The total number of shopping carts created during the sessions tracked in Shopify. It is calculated by summing the total number of carts created.
Ads Cost
The total spend on advertisements across all advertising platforms. It is calculated by summing the costs associated with each ad platform.
Affiliate Product Spend
The cost associated with products provided to affiliates.
Affiliate Commission
Payments made to affiliates based on agreed commission rates.
Affiliate Sales Amount
Revenue generated from affiliate-driven sales.
AOV of Total Orders
This shows the average order value when the selected product is part of the customer's order.
Average Days to Repeat
The median number of days it takes for a customer to make a repeat purchase within a year after their initial order. It calculates the median of the days to repeat the order. It specifically considers only those orders where the number of days to repeat is less than 365.
Average Order Value from Ads
The average revenue per order generated from all advertising platforms. It is calculated by dividing the total ad revenue by the total ad orders.
Average Order Value from Ads =
Average Cart Value:
The average value of orders abandoned during the checkout process. It is calculated by dividing the total cart value of abandoned checkouts by the total number of abandoned checkouts.
Average Cart Value =
Average Customer Spend:
The average amount spent by each customer. It is calculated by dividing the total customer spend (Sales Amount) by the number of unique customers.
Average Customer Spend =
Average Days to Repurchase
The average number of days it takes for a customer to repurchase a specific item. It is calculated by dividing the total number of days between first and subsequent purchases by the number of repeat purchases.
Average Days Since Last Order
The average number of days since customers in a segment last made a purchase.
Average Order Value (AOV)
The average amount a customer spends per order. It is calculated by dividing the total sales amount by the number of orders.
Average Order Value =
Average Order Value - GA Untracked
The average amount a customer spends per order that is not tracked by Google Analytics(GA). It is calculated by dividing the total revenue from GA-untracked orders by the total number of GA-untracked orders.
Untracked Average Order Value =
Average Orders per Customer
Average number of orders placed by each customer. It is calculated by dividing the total number of orders by the number of unique customers.
Average Orders per Customer =
Average Products per Order
The average number of unique products purchased per order. It is calculated by dividing the total number of unique products present in orders by the total number of orders placed.
Average Products per Order =
Average Unit Price
The average selling price of a single unit of a product. It is calculated by dividing the total sales amount by the total number of products sold.
Average Unit Price =
Average Unit Price (Discounted)
The average selling price of a single unit of a product specifically for orders where a discount was applied, either at the header level or at the line item level. It is calculated by dividing the total discounted sales amount by the total quantity of products sold in those discounted orders.
Average Unit Price (Discounted) =
Average Unit Price (Non-Discounted)
The average selling price of a single unit of a product specifically for orders where no discount was applied, either at the header level or at the line item level. It is calculated by dividing the total non-discounted sales amount by the total quantity of products sold in those non-discounted orders.
Average Unit Price (Discounted) =
Average Units per Order
The average number of units sold (Quantity sold) per order. It is calculated by dividing the total number of units sold by the total number of orders.
Average Units per Order =
Average Units per Product
Average number of units sold per product with a given order. It is calculated by dividing the total quantity of products sold by the total products in order.
Average Units per Product =
Browser
The specific web browser used by a website visitor, such as Chrome, Opera, or Firefox, as tracked by Google Analytics.
Bought Together Total Revenue
The total revenue generated from products that are frequently purchased together. It is calculated by summing the revenue of both primary and secondary SKUs bought together.
Bought together total revenue =
Cancellation Reactivated
The number of subscribers who reactivated within a specific period.
Cancellation Reactivated %
The percentage of total subscribers who reactivated within a specific period.
Cancel Flow Status
This refers to the status of a subscription after a customer initiates cancellation. Common statuses include Cancelled (subscription is terminated), Paused (subscription is temporarily halted), and Saved (customer intended to cancel but ultimately remained subscribed).
Campaign
A specific marketing initiative aimed at promoting products, as tracked by Google Analytics.
Campaign Medium
The primary channel through which a marketing campaign reaches customers, as tracked by Shopify. This field categorizes the medium used, such as paid ads, newsletters, messages, social media, etc.
Cart to Checkout Rate
The percentage of carts that reached the checkout stage. It is calculated by dividing the number of checkouts by the number of shopping carts created.
Cart to Checkout Rate =
Checkouts to Order Rate
The percentage of checkouts that result in a successful order. It is calculated by dividing the sessions converted by the total number of sessions reached at checkouts.
Checkout to Order Rate =
City
The city where a customer is located.
Clicks
The total number of clicks generated from all advertising platforms. It is calculated by summing the clicks across all ad platforms.
Clicks to Order Conversion
The percentage of ad clicks that result in an order across all advertising platforms. It is calculated by dividing the total number of ad orders by the total number of ad clicks.
Clicks to Order Conversion =
Click through Rate (CTR)
The percentage of ad impressions that resulted in clicks across all advertising platforms. It is calculated by dividing the total number of ad clicks by the total number of ad impressions.
Clicks through Rate (CTR) =
Conversion Rate (Google Analytics)
The percentage of website sessions tracked by Google Analytics (GA) that result in a purchase. It is calculated by dividing the number of orders by the number of sessions.
Conversion Rate =
Commission Amount
Total payments made to the affiliate for their sales contributions.
Commission % of Sales Amount
Percentage of revenue paid as commission to the affiliate. It is calculated by dividing the Commission Amount by the Sales Amount.
Commission % of Sales Amount =
Cost per 1000 Impressions (CPM)
The average cost per thousand ad impressions across all advertising platforms. It is calculated by dividing the total ad cost by the total number of ad impressions and then multiplying by 1,000.
Cost per 1000 Impressions (CPM) =
Cost per Click (CPC)
The average cost incurred for each click on advertisements across all advertising platforms. It is calculated by dividing the total ad cost by the total number of ad clicks.
Cost per Click (CPC) =
Country
The country where a customer is located.
Cumulative Number of Customers
The total number of customers accumulated over time. It is calculated by counting the total number of unique customers who have made their first purchase on or before the current period.
Cumulative Customer Count (Growth)
The total number of customers accumulated over time. It is calculated by counting the total number of unique customers who have made their first purchase on or before the current period.
Cumulative Subscription Customers
The running total count of unique customers who have created a subscription up to and including the selected period.
Cumulative Subscription Customers %
The percentage of the total customer base that has ever held a subscription up to and including the selected period. It is calculated by dividing the Cumulative Subscription Customers by the Number of Customers.
Cumulative Subscription Customers % =
Cumulative Cancellation Reactivated
The running total of subscribers who reactivated up to and including the selected period.
Cumulative Cancellation Reactivated %
The percentage of total subscribers who reactivated up to and including the selected period.
Current Year
The ongoing calendar year during which the data is being viewed or analyzed.
Customer Acquisition Cost (CAC)
The cost associated with acquiring a new customer through advertising efforts. It is calculated by dividing the total ad cost by the number of new customers.
Customer Acquisition Cost (CAC) =
Customer Browser
The web browser is used by a customer to make a purchase, as tracked by Shopify. The values in this field can include options such as Chrome, Firefox, Safari, and others.
Customer Device
The type of device used by a customer to make a purchase, as tracked by Shopify. The values in this field can include options such as Desktop, Mobile, Smart TV, Tablet, etc.
Customers with Selected Order SKU
The total number of customers who purchased the selected product in their first order.
Customers with Selected Order SKU & Next Order SKU
The number of customers who purchased both the selected product in their first order and a specific product in their next order.
Customer OS
The operating system used by a customer to make a purchase, as tracked by Shopify. The values in this field include options such as Android, iOS, Chrome OS, etc.
Customer Repurchase Rate
The proportion of unique customer relative to the total number of unique customers.
Customer Repurchase Rate =
Date
A specific point in time is used for recording and tracking events, transactions, or metrics.
Device Category
The category of device used by a website visitor, such as Desktop, Mobile, or Tablet, as tracked by Google Analytics.
Dimension Type
Dimension Type represents attributes of a dimension. For example, if order is the dimension, then order source or number of units per order are the dimension types.
Dimension Value
Dimension Values are the individual values of a dimension type. For example, if the order source is dimension type, then Google, Facebook, or Direct under order source are dimension values.
Discount Amount
The total value of discounts applied to customer orders. It is calculated by summing the discount amounts of orders.
Discount Amount %
The percentage of total revenue that is accounted for by discounts applied to customer orders. It is calculated by dividing the total discount amount by the gross sales revenue.
Discount Amount % =
Discount Code
A unique code associated with a specific discount is applied to an order.
Discount Order %
The percentage of total orders that received a discount. It is calculated by dividing the number of discounted orders by the total number of orders.
Discount Order % =
Discount Type
A field that specifies the type of discount applied to an order.
Discounted Orders
The total number of orders where a discount was applied, either at the header level or at the line item level.
Digital Ad Spend
The total spend on advertisements across all advertising platforms. It is calculated by summing the costs associated with each ad platform.
Engagement Rate
The percentage of sessions that resulted in meaningful user interactions on the website, as defined by Google Analytics. It is calculated by dividing the number of engaged sessions by the total number of sessions.
Engagement Rate =
Engaged Sessions
The total number of sessions where users interacted meaningfully with the website, as tracked by Google Analytics. It is calculated by summing the number of engaged sessions.
First Order Browser
The specific web browser used by a customer at the time of their first order, such as Chrome, Opera, or Firefox, as tracked by Google Analytics.
First Order Campaign
The specific marketing campaign associated with a customer’s first order, as tracked by Google Analytics.
First Order Date
The date on which a customer made their initial purchase.
First Order Device Category
The category of device used by a customer at the time of their first order, such as Desktop, Mobile, or Tablet, as tracked by Google Analytics.
First Order Discount % (Bins)
A categorical field that classifies the discount percentage applied to a customer’s first order into predefined ranges, or bins, such as 0%, 1%-5%, 6%-10%, etc. For example, if the discount on the first order is 8%, it would fall into the 6%-10% bin.
First Order Discount Code
The specific discount code applied to a customer’s first order, if any.
First Order Discount Type
A field indicating the type of discount applied to a customer’s first order, such as fixed amount, percentage, or shipping discount.
First Order has Discount
A field indicating whether a discount was applied to a customer’s first order.
First Order has GWP
A field indicating whether a customer’s first order included a Gift-With-Purchase (GWP).
First Order has Return
A field indicating whether a customer’s first order included any returned products.
First Order has Sample
A field indicating whether a sample product was included in a customer’s first order.
First Order has Shipping
A field indicating whether shipping fees were applied to a customer’s first order.
First Order Hour
The specific hour during which a customer placed their first order, typically recorded in a 24-hour format (e.g., 13 for 1 PM).
First Order Landing Page Path
The specific URL path of the page where a customer first landed when placing their initial order, as tracked by Google Analytics.
First Order Landing Page Type
The category of the landing page where a customer first arrived when placing their initial order, as tracked by Google Analytics.
First Order Marketing Channel
The specific marketing channel through which a customer accessed the website and made their first order, as tracked by Google Analytics. Possible values include Affiliates, Cross-network, Direct, Email, and others.
First Order Medium
The type of marketing channel that describes how a customer arrived at the website when placing their first order, as tracked by Google Analytics. Possible values include Organic, Paid, Referral, and others.
First Order Month
The month during which a customer made their initial purchase, is often represented in a format such as "2024-Jan" or "Jan” for January.
First Order New or Returning Users
A classification field indicating whether a customer was a new or returning user at the time of their first order, as tracked by Google Analytics.
First Order Operating System
The operating system used by a customer at the time of their first order, such as Windows, iOS, or Linux, as tracked by Google Analytics.
First Order Product
The specific item purchased by a customer in their initial order.
First Order Product Category
The category of the product purchased in a customer’s initial order, as tracked by the business.
First Order Products in Order
The total number of distinct products included in a customer’s first order.
First Order Referring Site
The website or platform that directed a customer to the site when they placed their first order, as tracked by Google Analytics.
First Order SKU
The SKU associated with the specific product purchased in a customer's initial order.
First Order Type
A classification indicating the type of a customer's initial purchase, such as one-time purchase, subscription first order, or other categories relevant to the business model.
First Order Units in Order
The total number of individual items included in a customer’s first order, regardless of product type.
First Order Value (Bins)
A categorical field that classifies the order value of a customer’s first order into predefined ranges, or bins, such as £0-10, £20-30, £30-40, and so on. For instance, if the first order value is £25, it would fall into the £20-30 bin.
First Order Week
The week during which a customer made their initial purchase, is represented in a format like "Year-W##" (e.g., “2024-W16” or “16” for “Week 16”).
First Order Year
The calendar year in which a customer made their initial purchase.
Fixed Amount - Discount Type
Orders where a specific monetary value is deducted from gross value.
Gross Sales Amount
The total revenue generated from customer orders before any deductions, such as discounts, returns, or taxes.
Growth % over prior period
The cumulative percentage growth of customers over time. It is calculated by comparing the current cumulative number to the base number.
Cumulative Growth % =
Impressions
The total number of times advertisements were displayed to users across all advertising platforms. It is calculated by summing the impressions from all ad platforms.
Key Drivers for Sales Decline
Reveal the areas (Dimension Values and Type) that have negatively impacted your revenue.
Key Drivers for Sales Growth
Reveal the areas (Dimension Values and Type) that have positively impacted your revenue.
Landing Page Path
The specific URL path of the page where a visitor first arrives on the website, as tracked by Google Analytics.
Landing Page Type
The category of the landing page where a visitor first arrives on the website, as tracked by Google Analytics.
Last Year
The previous calendar year immediately preceding the Current Year.
Lifetime Average Order Value
The average order value over the lifetime of customers. It is calculated by dividing the total order value by the total order count.
Lifetime Average Order Value =
Lifetime Orders per Customer
The average number of orders placed by customers over their lifetime. It is calculated by dividing the total order count by the total number of customers.
Lifetime Orders per Customer =
Lifetime Period
The Lifetime Period refers to the specific time frame used to measure a customer's spending from the date of their first purchase. This standardized period allows for consistent comparisons across customer segments by capturing customer behavior within a defined duration, such as 30 days, 90 days, 1 year, or 2 years.
Lifetime Value per Customer
The average lifetime value per customer. It is calculated by dividing the total order value by the total number of customers.
Lifetime Value per Customer =
Location City
The city from which a customer made a purchase, as tracked by Shopify.
Location Country
The country from which a customer made a purchase, as tracked by Shopify.
Location Region
The geographic region from which a customer made a purchase, as tracked by Shopify.
Marketing Channel
The primary channel through which a customer accesses the website, as tracked by Google Analytics. Possible values include Affiliates, Cross-network, Direct, Email, and others.
Marketing Consent
A field indicating the type of marketing communication a customer has agreed to receive, with possible values including Email Only, Email & SMS, SMS Only, and others.
Medium
The type of marketing channel that describes how traffic arrives at a website, as tracked by Google Analytics. Possible values include Organic, Paid, Referral, and others.
Month
In reports, months are often represented in formats such as "2024-Jan" or "Jan” for January.
Net Contribution per Customer
The financial value that each customer contributes to the business after accounting for the costs associated with acquiring them. It is calculated by subtracting Customer Acquisition Cost (CAC) from Lifetime Value (LTV) per Customer.
Net Contribution per Customer =
New Customer
A new customer is an individual that makes their first purchase from a business. This is typically defined as a customer who has not made any previous purchases with the business before this initial order.
New Customer Average Order Value
The average amount spent per order by customers making their first purchase. It is calculated by dividing the total sales amount from new customers by the number of orders placed by those new customers.
New Customer Average Order Value =
New Customer Order Amount
The total revenue generated from customers who are making their first purchase.
New Customer Orders
The total number of orders placed by New Customers. It is calculated by counting the orders by New Customers.
New Customers
The total number of customers who have made their first purchase.
New or Repeat
Field that represents the type of customer such as New Customer and Repeat Customer.
New or Returning Users
A classification field indicating whether a website visitor is accessing the site for the first time (New) or has visited previously (Returning), as tracked by Google Analytics.
Next Order SKU
Refers to the product (SKU) purchased in the subsequent order after the selected SKU.
Number of Customers
Total count of unique customers who have made at least one purchase. It is calculated by counting the number of unique customers.
Number of Days to Repeat
The number of days between the customer's initial purchase and their current purchase.
Number of Orders
Total count of orders placed by customers. It is calculated by counting the number of orders.
Number of Orders from Ads
The total number of orders generated from all advertising platforms. It is calculated by summing the orders across all ad platforms.
Number of Site Users
The total number of unique users who visited the website, as tracked by Google Analytics. It is calculated by summing the total number of unique users recorded by Google Analytics.
Operating System
The operating system used by a website visitor, such as Windows, iOS, or Linux, as tracked by Google Analytics.
Order Discount % (Bins)
A categorical field that classifies orders into discount percentage ranges, or bins, based on the percentage of discount applied to each order. Examples of these bins include 0%, 1%-5%, and 6%-10%. For instance, if an order has a discount of 8%, it would fall into the 6%-10% bin.
Order has Discount
A field indicating whether a discount was applied to an order.
Order has GWP
A field indicating whether a Gift-With-Purchase (GWP) was included in an order.
Order has Return
A field indicating whether an order included returned items. It is typically represented as a binary value (e.g., Yes or No) to show if the customer returned any products from their purchase.
Order has Sample
A field indicating whether a sample product was included in an order.
Order has Shipping
A field indicating whether shipping fees were applied to an order.
Order Hour
The specific hour when an order was placed, is typically recorded in a 24-hour format (e.g., 13 for 1 PM).
Order Repurchase Rate
The proportion of customers who make a repeat purchase relative to the total number of customers associated with their previous order sequence.
Order Repurchase Rate =
Orders per Customer
The average number of orders placed by each customer. It is calculated by dividing the total number of orders by the total number of unique customers.
Order per Customer =
Order Sequence Number
A numerical identifier that represents the chronological order of a customer’s purchases. This field tracks the sequence of orders placed by an individual customer, starting from their first purchase.
Order Type
A classification field that categorizes orders into types such as one-time purchase, subscription first order, and subscription recurring order.
Order Value (Bins)
A categorical field that classifies orders into value ranges, or bins, based on the total sales amount. Examples of these bins include £0-10, £20-30, and £30-40. For instance, if an order has a sales amount of £35, it would fall into the £30-40 bin.
Orders with Primary SKU
This metric displays the total number of orders containing the primary product.
Orders with Primary & Secondary SKU
This metric shows the number of orders that included both the primary and secondary products.
Page Path
The specific URL path or route a customer navigates on a website, as tracked by Shopify.
Page Type
The category or type of webpage a customer visits on the website, as tracked by Shopify.
Pageviews
The total number of pages viewed on the website during the specified period, as tracked by Google Analytics. It is calculated by summing the total number of page views recorded in Google Analytics.
Pageviews per Session
The average number of pages viewed per session. It is calculated by dividing the total number of pageviews by the total number of sessions.
Pageviews per Session =
Percent Orders has Discount
A categorical field that represents the percentage range of a customer's orders that included a discount. This field is divided into percentage bins (e.g., 1-10%, 11-20%, 21-30%, so on) to indicate the proportion of orders placed with a discount. For example, if a customer placed 100 orders and 35 of those had a discount, the value would fall into the 31-40% bin, as 35% of their orders included a discount.
Percent Orders has GWP
A categorical field that represents the percentage range of a customer's orders that included a Gift-With-Purchase (GWP). This field is divided into percentage bins (e.g., 1-10%, 11-20%, 21-30%, so on) to indicate the proportion of orders placed with a GWP. For example, if a customer placed 100 orders and 25 of those included a GWP, the value would fall into the 21-30% bin, as 25% of their orders contained a GWP.
Percent Orders has Return
A categorical field that represents the percentage range of a customer’s orders that included a returned item. This field is divided into percentage bins (e.g., 1-10%, 11-20%, 21-30%, so on) to indicate the proportion of orders that resulted in returns. For example, if a customer placed 100 orders and 15 of those involved returns, the value would fall into the 11-20% bin, as 15% of their orders included a return.
Percent Orders has Sample
A categorical field that represents the percentage range of a customer’s orders that included a sample product. This field is divided into percentage bins (e.g., 1-10%, 11-20%, 21-30%, so on) to indicate the proportion of orders that contained a sample. For example, if a customer placed 100 orders and 40 of those included a sample, the value would fall into the 31-40% bin, as 40% of their orders contained a sample.
Percent Orders has Shipping
A categorical field that represents the percentage range of a customer’s orders that included a shipping charge. This field is divided into percentage bins (e.g., 1-10%, 11-20%, 21-30%, so on) to indicate the proportion of orders where shipping fees were applied. For example, if a customer placed 100 orders and 55 of those had a shipping charge, the value would fall into the 51-60% bin, as 55% of their orders included shipping.
Percent Orders has Subscription
A categorical field that represents the percentage range of a customer’s orders that included a subscription product. This field is divided into percentage bins (e.g., 1-10%, 11-20%, 21-30%, so on) to indicate the proportion of orders involving a subscription. For example, if a customer placed 100 orders and 20 of those included a subscription product, the value would fall into the 21-30% bin, as 20% of their orders involved subscriptions.
Percentage - Discount Type
Orders where a percentage of the total order value is discounted.
Prior Year
The year immediately preceding the Selected Year.
Product
An individual item offered for sale by a business, characterized by specific attributes such as name, description, price, and features.
Product Category
A classification that groups similar products together based on shared characteristics, attributes, or intended use.
Product in Orders
The total number of distinct products included in an order.
Product Price Range
A categorical field that classifies products into predefined price bins based on their selling price, such as £1-10, £11-20, and so on.
Primary and Secondary SKUs
Represents a pairing of a primary product (SKU) with a secondary product that customers frequently buy together.
Quantity Sold
The total number of units sold across all orders. It counts the total quantity of products sold.
Referrer Name
The specific website, platform, or entity that directed a customer to the website, as tracked by Shopify.
Referrer Source
The general category of the source that directed a customer to the website, as tracked by Shopify. This field identifies the type of traffic source, such as Direct, Email, Search, Social, etc.
Referrer Traffic
The classification of traffic is based on how customers arrive at the website, as tracked by Shopify. This field categorizes traffic into types such as Direct, Organic, Paid, Unattributed, Unknown, etc.
Referring Channel
A classification that indicates the type of source from which a visitor was referred to the website, as tracked by Google Analytics (GA).
Referring Site
The website or platform that directed a visitor to a specific page on another site, as tracked by Google Analytics.
Repeat Customer
A repeat customer is an individual who has made more than one purchase from a business. Repeat customers have returned to make additional purchases after their initial transaction.
Repeat Order Rate
The proportion of total orders that are placed by repeat customers. It is calculated by dividing the number of orders placed by repeat customers by total number of orders.
Returns Amount
The total revenue associated with returned items from customer orders. It is calculated by summing the sales amount for return orders.
Returns Amount % of Sales Amount
The percentage of total sales revenue that is attributed to returned products. It is calculated by dividing the returns amount by the total sales amount.
Returns Amount % =
Revenue from Ads
The total revenue generated from all advertising platforms. It is calculated by summing the order values across all ad platforms.
RFM Segment
RFM Segment refers to the categorization of customers based on three key metrics: Recency, Frequency, and Monetary value (RFM).
Return on Ad Spend (ROAS)
The revenue generated for every dollar spent on advertisements across all advertising platforms. It is calculated by dividing the total ad revenue by the total ad cost.
Return on Ad Spend (ROAS) =
Sales Amount
Total revenue generated from the sales. It is calculated by summing sales amount values.
Sales Channel
The platform or method through which a business sells its products or services to customers, i.e. Shopify, Amazon, Social media channels etc.
Sales from Discounted Orders
The total revenue generated from orders where a discount was applied, either at the header level or at the line item level. It is calculated by summing the sales amount of the discounted orders.
Sales from GWP-Linked Orders
The total sales amount from orders that included an item priced at zero. It is calculated by summing the sales amounts from orders that included an item priced at zero.
Sales from Sample-Linked Orders
The total sales amount from orders that included a line item sample. It is calculated by summing sales amount of orders that include a line item sample.
Sales from Shipping Cost-Linked Orders
The total sales amount from orders that included shipping costs. It is calculated by summing the sales amounts from orders that included shipping costs.
Selected Order SKU
The name of the main product that is being analyzed to understand customer purchase patterns.
Selected Year
The specific year is chosen by the user through a filter option in the Insight app.
Selected Order SKU
Refers to the primary product (SKU) in the initial purchase, for which repurchase or complementary buying patterns are being analyzed.
Session Converted
The total number of orders created during the sessions is tracked in Shopify.
Session Converted Rate
The percentage of sessions tracked by Shopify that resulted in an order. It is calculated by dividing the number of sessions by sessions converted.
Session Converted Rate =
Session to Cart Rate
The percentage of sessions that resulted in the creation of a shopping cart on Shopify. It is calculated by dividing the number of add-to-cart by the total number of sessions
Session to Cart Rate =
Session to Checkout Rate
The percentage of sessions that result in a checkout being initiated. It is calculated by dividing the reached checkout by the total number of sessions.
Session to Checkout Rate =
Sessions (Google Analytics)
The total number of sessions recorded in Google Analytics.
Sessions (Shopify)
The total number of sessions tracked in Shopify.
Shipping Amount
The total revenue generated from shipping linked orders.
Shipping Amount %
The percentage of total revenue generated from shipping-linked orders. It is calculated by dividing the shipping amount by the sales amount.
Shipping Amount % =
Shipping Cost-Linked Orders
The total number of orders where shipping costs were applied. It counts the total number of orders that included shipping fees.
Shipping - Discount Type
Orders where shipping costs are reduced or eliminated.
Spend per Order
The amount spent on the specific product when it is included in an order.
SKU
A unique identifier is assigned to a specific product and its variations (such as size or color) within a business's inventory system.
Source
The specific origin from which traffic is directed to a website, as tracked by Google Analytics. Possible values include Direct, Google, Bing, and others.
State
The state or province where a customer is located.
Subscription customers
The unique count of customers with at least one active subscription within the specific period.
Subscription Customers %
The percentage of customers who have an active subscription within a specific period. It is calculated by dividing the number of unique subscription customers by the total number of customers.
Subscription Customers % =
Subscriptions
The total number of individual subscriptions within the specific period. It is calculated by counting subscriptions (including multiple subscriptions held by the same customer).
Subscription
The unique count of subscriptions within a specific period.
Subscription %
The percentage of total subscriptions within a specific period. It is calculated by dividing Subscription by total subscriptions.
Subscription % =
Subscriptions (for Order Cycle & Churn)
The number of subscriptions that have churned (been discontinued) is based on the completion of subscription order cycles.
Subscriptions % of Total
The percentage of active subscriptions that have churned (been discontinued) is based on the completion of subscription order cycles.
Subscription Created
The total number of new subscriptions initiated by customers within a given period.
Subscription Saved
The number of subscriptions successfully retained within the specific period, following an attempt to cancel.
Subscription Cancelled
The total number of subscriptions terminated by customers within the specific period.
Subscriptions Non Cancelled
The total count of active subscriptions that were not canceled within the specific period.
Subs 1st Order
An order type represents the initial transaction in a subscription series, where a customer signs up for a recurring purchase plan.
Subs Recurring
An order type that represents subsequent transactions following the initial subscription order, occurring at regular intervals as part of a subscription plan.
Tracked Average Order Value
The average amount a customer spends per order, as tracked by Google Analytics(GA). It is calculated by dividing the total revenue from GA-tracked orders by the total number of GA-tracked orders.
Tracked Average Order Value =
Tracked Number of Orders
The total number of orders tracked by Google Analytics. It is calculated by counting all orders that are tracked by Google Analytics.
Tracked Revenue
The total revenue generated from orders is tracked by Google Analytics (GA). It is calculated by summing the sales amounts from all orders that are tracked by Google Analytics.
Total Affiliate Spend
The combined total of affiliate product costs and commissions.
Total Cart Value
The total net sales value of abandoned checkouts. It is calculated by summing the net sales amount for each unique abandoned checkout.
Total Customer Spend
The total amount of money spent by customers in a specific segment. This metric shows the total revenue contribution from each segment.
Total Customer Count
The total count of unique customers who have made at least one purchase. It is calculated by counting the distinct customers.
Total Order Count
The total number of orders placed by customers over their lifetime. It is calculated by summing the lifetime order counts.
Total Order Value
The total value of all orders placed by customers over their lifetime. It is calculated by summing the lifetime order values.
Untracked
The term "Untracked" refers to values or data points that are not monitored or recorded by Google Analytics or Shopify.
Untracked Average Order Value
The average amount a customer spends per order, which are not tracked by Google Analytics(GA). It is calculated by dividing the total revenue from GA-untracked orders by the total number of GA-untracked orders.
Untracked Average Order Value =
Untracked Number of Orders
The total number of orders not tracked by Google Analytics. It is calculated by counting all orders that are not tracked by Google Analytics.
Untracked Revenue
The total revenue generated from orders not tracked by Google Analytics (GA). It is calculated by summing the sales amount from all orders that are not tracked by Google Analytics.
Units in Order
The total number of individual products included in an order, regardless of product type.
Variance
The difference in metric between this year and the same period in the last year. It is calculated by subtracting the metric value of the same period prior year from the metric value of the selected year.
Variance %
The percentage change in a metric between this year and the same period last year. It is calculated by dividing the difference between the metric of the selected year and the same period prior year by the metric of the same period prior year.
Week
A time period consisting of seven consecutive days, represented in the format of "Year-W##" (e.g., “2024-W16” or “16” for “Week 16”). This format provides a clear reference to both the year and the specific week within that year.
Year
Years are typically represented in a four-digit format (e.g., “2024”).
YoY Variance
The difference in metric between this year and the same period in the last year. It is calculated by subtracting the metric value of the same period prior year from the metric value of the selected year.
YoY Variance %
The percentage change in a metric between this year and the same period last year. It is calculated by dividing the difference between the metric of the selected year and the same period prior year by the metric of the same period prior year.
% of Orders (Abandoned Checkouts)
The proportion of abandoned checkouts relative to the total number of completed orders that included the selected item. It is calculated by dividing the total number of abandoned checkouts by the total number of orders.
% of Orders =
% of Discounted Orders
The percentage of total orders that included a discount. It is calculated by dividing the discounted orders by the total number of orders.
% of Discounted Orders =
% of Shipping Cost-Linked Orders
The percentage of total orders that included shipping. It is calculated by dividing the discounted orders by the total number of orders.
% of Shipping Cost-Linked Orders =
% Converted on Abandoned Day
The percentage of abandoned checkouts that were followed by a re-order within the same day. It is calculated by dividing the total count of abandoned checkouts that resulted in a same-day re-order by the total number of abandoned checkouts.
% Converted on Abandoned Day =
% Has Shipping (Abandoned Checkouts)
The percentage of abandoned checkouts that included shipping charges. It is calculated by dividing the total number of abandoned checkouts that included shipping Abandoned Checkouts has Shipping by the total number of abandoned checkouts Abandoned Checkouts.
% Has Shipping =
% Repurchased with 2 Weeks
The percentage of unique customers who placed an order and had a repeat purchase within 2 weeks. It is calculated by dividing the number of customers who placed an order and had a repeat purchase within 2 weeks by the total number of customers.
% Repurchased with 2 Weeks =
% Repurchased with 4 Weeks
The percentage of unique customers who placed an order and had a repeat purchase within 4 weeks. It is calculated by dividing the number of customers who placed an order and had a repeat purchase within 4 weeks by the total number of customers.
% Repurchased with 4 Weeks =
% Repurchased with 8 Weeks
The percentage of unique customers who placed an order and had a repeat purchase within 8 weeks. It is calculated by dividing the number of customers who placed an order and had a repeat purchase within 8 weeks by the total number of customers.
% Repurchased with 8 Weeks =
% Repurchased with 12 Weeks
The percentage of unique customers who placed an order and had a repeat purchase within 12 weeks. It is calculated by dividing the number of customers who placed an order and had a repeat purchase within 12 weeks by the total number of customers.
% Repurchased with 12 Weeks =
% Repurchased with 26 Weeks
The percentage of unique customers who placed an order and had a repeat purchase within 26 weeks. It is calculated by dividing the number of customers who placed an order and had a repeat purchase within 26 weeks by the total number of customers.
% Repurchased with 26 Weeks =
% Repurchased with 52 Weeks
The percentage of unique customers who placed an order and had a repeat purchase within 52 weeks. It is calculated by dividing the number of customers who placed an order and had a repeat purchase within 52 weeks by the total number of customers.
% Repurchased with 52 Weeks =
% of Customers Next Bought
The percentage of customers who bought the "Next Order Product Name" after buying the "This Order Product Name.
% of Customers Next Bought =
% of Orders Bought Together
The percentage of total orders of the primary product that also includes the secondary product. It is calculated by dividing orders with primary SKUs by the orders with primary & secondary SKUs together.
% of Orders Bought Together =
% of Total Customers
The percentage of total customers out of all customers. It is calculated by dividing the number of customers by the total number of customers.
% of Total Customers =
% of Customers Next Bought
The percentage of customers who purchased the selected product in their first order and went on to purchase the next product in their subsequent order.