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 =

Revenue from Ad Number of Orders 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 =

Total Sales Value of Abandoned checkouts Abandoned Checkouts

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 =

Sales Amount Number of Customers

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 =

Sales Amount Number of Orders

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 =

Untracked Revenue Untracked Number of Orders

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 =

Number of Orders Number of Customers

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 =

Products in Order Number of Orders

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 =

Sales Amount Quantity Sold

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) =

Sales Amount from Discounted Orders Quantity Sold in Discounted Orders

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) =

Sales Amount from Non-Discounted Orders Quantity Sold in Non-Discounted Orders

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 =

Quantity Sold Number of Orders

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 =

Quantity Sold Product in Order

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 =

Revenue from Primary SKU + Revenue from Secondary SKU

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 =

Reached Checkouts Add to Cart × 100

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 =

Sessions Converted Reached Checkouts × 100

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 =

Number of Orders from Ads Clicks × 100

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) =

Clicks Impression × 100

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 =

Number of Orders Sessions tracked by GA × 100

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 =

Commission Amount 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) =

Ads Cost Impressions × 1000

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) =

Ads Cost Clicks × 100

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 Subscription Customers Number of Customers × 100

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) =

Total Ads Cost Number of new customers

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 =

Customer Count Number of Customers × 100

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 Amount Gross Sales Amount × 100

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 % =

Discounted Orders Number of Orders × 100

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 Sessions × 100

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 % =

Current Period Cumulative Customer Count - Prior Period Cumulative Customer Count Prior Period Cumulative Customer Count × 100

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 =

Total Order Value Total Order Count

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 =

Total Order Count Total Order Value

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 =

Total Order Value Total Customer Count

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 =

Customer Acquisition Cost - Lifetime Value 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 New Customer Orders

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 =

Current Order Sequence Customer Count Previous Order Sequence Customer Count × 100

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 =

Number of Orders Number of 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 =

Pageviews Sessions

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 % =

Returns Amount Sales Amount × 100

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) =

Revenue from Ads Ad Cost

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 =

Sessions tracked by shopify Sessions Converted × 100

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 =

Add to Cart Sessions × 100

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 =

Reached Checkout Sessions × 100

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 Amount Sales Amount × 100

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 % =

Subscription Customers Number of Customers × 100

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 % =

Subscription Subscriptions × 100

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 Revenue Tracked Number of Orders

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 Revenue Untracked Number of Orders

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 =

Abandoned Checkouts Number of Orders × 100

% 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 =

Discounted Orders Number of Orders × 100

% 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 =

Shipping Cost-Linked Orders Number of Orders × 100

% 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 =

Abandoned Checkouts with Same Day Re-Order Abandoned Checkouts × 100

% 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 =

Abandoned Checkouts has Shipping Abandoned Checkouts × 100

% 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 =

Number of Customers who placed an order and had a repurchase within 2 weeks Number of Customer × 100

% 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 =

Number of Customers who placed an order and had a repurchase within 4 weeks Number of Customer × 100

% 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 =

Number of Customers who placed an order and had a repurchase within 8 weeks Number of Customer × 100

% 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 =

Number of Customers who placed an order and had a repurchase within 12 weeks Number of Customer × 100

% 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 =

Number of Customers who placed an order and had a repurchase within 26 weeks Number of Customer × 100

% 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 =

Number of Customers who placed an order and had a repurchase within 52 weeks Number of Customer × 100

% 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 =

Customers with Selected Order SKUs Customers with Selected Order & Next Order SKU × 100

% 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 =

Orders with Primary SKU Orders with Primary & Secondary SKU Together × 100

% 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 =

Customer Count Number of Customers × 100

% 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.

Still need help? Contact Us Contact Us