Shopify IntegrationTurn Shopify order data into a causal model of what drives your e-commerce revenue, and who owns each lever.
Shopify captures every order, product view, cart event, customer record, and fulfilment step. KPI Tree connects to Shopify through the official Shopify Storefront MCP and Customer Accounts MCP servers that ship with every store, through your data warehouse where Shopify Admin data already lands via Fivetran or Hightouch, or through a professional services engagement that builds the stack for you. Once connected, KPI Tree builds what no e-commerce dashboard can: causal metric trees that model how GMV, average order value, conversion rate, repeat purchase rate, and customer lifetime value drive each other. Every metric gets an owner, statistical monitoring, and a direct line to action. Your e-commerce data stops sitting in reports and starts driving accountability across marketing, product, and operations.
From order events to accountable revenue trees
KPI Tree connects to Shopify through the Shopify Storefront MCP server for catalogue and cart data, through your warehouse for full merchant-side order history and lifecycle metrics, or through a professional services engagement that builds the full stack for you.
Connect your Shopify data
Three ways to get started, depending on your stack.
Pull metrics from Shopify directly through the Model Context Protocol.
Connect your existing warehouse where Shopify data already lands.
Our professional services team can build you turn-key AI foundations in a matter of weeks. Data warehouse on Snowflake/BigQuery, ELT with Fivetran, all modelled in dbt with a semantic layer.
Define e-commerce metrics from Shopify tables
Create metrics from your Shopify data - GMV, net revenue, average order value, units per order, conversion rate, cart abandonment rate, repeat purchase rate, customer lifetime value, refund rate, and more. Write SQL against your existing tables or sync metric definitions from your dbt semantic layer.
Build revenue trees and assign ownership
Arrange metrics into parent-child trees that model how they causally drive each other. GMV decomposes into orders multiplied by average order value. Orders decompose into traffic multiplied by conversion rate. Each node gets a RACI owner, statistical monitoring, and personalised alerts. When AOV drops, the merchandising team knows before the weekly review.
E-commerce intelligence your storefront analytics cannot deliver
Shopify's analytics show you what happened in your store. KPI Tree models why it happened, assigns accountability, and tracks whether the response worked.
Revenue decomposition trees from order data
Break GMV into its causal components: traffic multiplied by conversion rate multiplied by average order value. Decompose further by product category, acquisition channel, geography, device type, or any dimension in your warehouse. Each node is an owned metric with trend analysis and statistical alerts - so when revenue dips, you trace the exact driver.
Causal analysis across the e-commerce funnel
KPI Tree runs correlation and causality analysis across your Shopify metrics. Discover that free shipping threshold changes correlate with AOV shifts, that email campaign timing is a leading indicator of repeat purchase rate, or that specific product categories drive disproportionate LTV. Statistical relationships grounded in your store's actual data.
Customer cohort metrics with ownership
First-purchase AOV, 90-day repeat rate, cohort LTV, and reactivation rate become owned metrics in your tree. Each cohort metric links causally to the acquisition and retention strategies that drive it - connecting marketing spend to long-term customer value through a single accountable structure.
The classic e-commerce equation, modelled as a causal tree.
Revenue equals traffic multiplied by conversion rate multiplied by average order value. Every e-commerce team knows this equation. KPI Tree makes it operational. Each component is a metric node with an owner, a baseline, and alerts. Traffic decomposes by channel. Conversion rate decomposes by device and funnel stage. AOV decomposes by product category and basket composition. When revenue misses target, you follow the tree to the component that drove the miss and the person accountable. No weekly review required to identify the problem.
- GMV decomposed into traffic, conversion rate, and average order value
- Each component breaks further by channel, device, product, and geography
- RACI ownership at every level connects metrics to accountable teams
- Period-over-period comparison identifies which component drove the change
Customer lifetime value as a metric tree, not a single number.
LTV is the metric everyone quotes and nobody decomposes. In KPI Tree, customer lifetime value breaks into its causal drivers: first-purchase AOV, repeat purchase rate, purchase frequency, average order margin, and retention curve. Each driver is an owned metric. When LTV trends down, the tree reveals whether it is because new customers are spending less on their first order, repeat rates are declining, or margins are compressing. Each cause has a different owner and a different response - the tree routes you to the right one.
- LTV decomposed into first-purchase AOV, repeat rate, frequency, and margin
- Cohort-based LTV tracking with statistical comparison between cohorts
- Each driver links to the team responsible - marketing, merchandising, or CX
- Leading indicators surface LTV problems before they compound
Product and category performance with accountability.
Shopify shows you which products sell. KPI Tree models how product performance drives overall revenue metrics. Attach rate of high-margin accessories. Conversion rate by product category. Return rate by product line. Each becomes a metric node with an owner - the merchandising team owns category mix, the product team owns return rate, marketing owns category-level conversion. When aggregate metrics move, the tree traces the cause to specific products and the teams responsible.
- Product category contribution modelled as metric tree nodes
- Attach rate, conversion rate, and return rate tracked per category
- Ownership assigned to merchandising, product, and marketing by metric
- Category-level changes automatically surface in parent revenue metrics
Combine Shopify with marketing, payments, and fulfilment data.
Shopify does not exist in isolation. Your warehouse also holds marketing spend from Google Ads and Klaviyo, payment processing data from Stripe, fulfilment metrics from your 3PL, and customer support data from Intercom or Pylon. KPI Tree builds trees across all of it. A single tree traces the path from ad spend to site visit to order to fulfilment to repeat purchase - with an owner at every stage. That end-to-end model is what siloed tool dashboards cannot provide.
- Shopify order data alongside marketing, payments, and fulfilment metrics
- End-to-end attribution from acquisition spend to customer lifetime value
- Cross-tool correlation surfaces relationships invisible in individual dashboards
- Every metric carries ownership regardless of which tool generated the data
What KPI Tree adds that Shopify Analytics cannot
Shopify Analytics is built for store operations. KPI Tree is built for understanding why e-commerce metrics move and holding cross-functional teams accountable.
Causal decomposition, not flat reports
Shopify Analytics shows metrics side by side. KPI Tree arranges them in parent-child trees that model how traffic, conversion, and AOV causally drive revenue - so you trace root causes instead of scanning dashboards.
Cross-functional ownership of revenue metrics
Shopify Analytics lives with the e-commerce team. KPI Tree assigns RACI ownership across marketing, merchandising, product, fulfilment, and customer experience - because revenue drivers span the entire organisation.
Statistical analysis across the full data stack
Shopify only sees store data. KPI Tree correlates Shopify metrics with marketing spend, payment health, fulfilment speed, and customer support volume to surface the complete picture of what drives e-commerce performance.
Metrics you can track
35 Shopify metrics ready to add to your metric trees.
Average Order Value
E-commerceMetric Definition
AOV = Total Revenue / Number of Orders
Average order value (AOV) is the mean monetary value of each completed order. It captures the combined effect of pricing, bundling, upselling, and promotional strategies on basket size.
Cart Abandonment Rate
E-commerceMetric Definition
Cart Abandonment Rate = ((Carts Created - Completed Orders) / Carts Created) × 100
Cart abandonment rate is the percentage of shopping carts created that are not converted into completed orders. It measures friction and hesitation between add-to-cart and purchase completion.
Checkout Conversion Rate
E-commerceMetric Definition
Checkout Conversion Rate = (Completed Orders / Checkout Starts) × 100
Checkout conversion rate is the percentage of visitors who begin the checkout process and successfully complete a purchase. It isolates conversion performance at the critical final stage of the buying journey.
Customer Acquisition Cost
E-commerceMetric Definition
CAC = Total Acquisition Spend / New Customers Acquired
Customer acquisition cost (CAC) measures the total marketing and sales spend required to acquire a new customer. It encompasses ad spend, creative costs, agency fees, and any other direct acquisition expenses.
Customer Lifetime Value
E-commerceMetric Definition
LTV = AOV × Purchase Frequency × Average Customer Lifespan
Customer lifetime value (LTV) estimates the total revenue a customer will generate over their entire relationship with your store. It combines average order value, purchase frequency, and customer lifespan into a single value figure.
Customer Repeat Rate
E-commerceMetric Definition
Repeat Rate = (Customers with 2+ Orders / Total Customers) × 100
Customer repeat rate is the percentage of customers who make more than one purchase within a defined period. It measures customer loyalty and the effectiveness of retention and re-engagement efforts.
Discount Usage Analysis
E-commerceMetric Definition
Discount usage analysis measures the frequency, value, and impact of discount codes and automatic discounts applied to orders. It quantifies how promotions affect revenue, margins, and customer behaviour.
Fulfilment Speed
E-commerceMetric Definition
Fulfilment Speed = Average (Shipment Date - Order Date)
Fulfilment speed measures the average time between order placement and shipment. It captures warehouse efficiency, inventory availability, and operational capacity to meet customer delivery expectations.
Gross Merchandise Volume
E-commerceMetric Definition
GMV = Sum of All Order Values (Before Returns and Discounts)
Gross merchandise volume (GMV) is the total value of all merchandise sold through your Shopify store before deducting returns, discounts, and fees. It represents the top-line scale of your e-commerce operation.
Inventory Turnover
E-commerceMetric Definition
Inventory Turnover = Cost of Goods Sold / Average Inventory Value
Inventory turnover rate measures how many times inventory is sold and replaced within a period. Higher turnover indicates efficient inventory management and strong demand, while low turnover suggests overstocking or weak sales.
Marketing Channel Attribution
E-commerceMetric Definition
Marketing channel attribution assigns revenue credit to the marketing channels that influenced each purchase. It helps determine which channels, such as paid search, social, email, or organic, deliver the best return on investment.
New vs Returning Customers
E-commerceMetric Definition
New vs returning customers measures the proportion of orders and revenue coming from first-time buyers versus repeat purchasers. It reveals whether growth is driven by acquisition or loyalty.
Order Frequency
E-commerceMetric Definition
Order Frequency = Total Orders / Unique Customers (in Period)
Order frequency measures the average number of orders placed by a customer within a defined period. It indicates purchasing cadence and is a key component of customer lifetime value calculations.
Orders Per Customer
E-commerceMetric Definition
Orders Per Customer = Total Lifetime Orders / Total Unique Customers
Orders per customer measures the cumulative average number of orders placed per customer across their entire relationship. Unlike order frequency which measures a period, this tracks lifetime purchase depth.
Product Performance Analysis
E-commerceMetric Definition
Product performance analysis evaluates each product on revenue, units sold, margin, return rate, and conversion rate. It identifies which products drive value and which underperform across multiple dimensions.
Product Return Rate
E-commerceMetric Definition
Return Rate = (Returned Units / Sold Units) × 100
Product return rate is the percentage of sold units that are returned by customers. It reflects product quality, description accuracy, and how well customer expectations are met.
Profit Margin by Product
E-commerceMetric Definition
Profit Margin = ((Revenue - COGS) / Revenue) × 100
Profit margin by product measures the percentage of revenue retained as profit after deducting cost of goods sold for each product. It reveals which products generate healthy margins and which are margin-dilutive.
Revenue by Channel
E-commerceMetric Definition
Revenue by channel segments total sales by the channel through which they occur, including online store, point of sale, social commerce, marketplaces, and wholesale. It shows channel contribution and diversification.
Revenue by Geography
E-commerceMetric Definition
Revenue by geography breaks down sales by customer location, including country, region, or city. It reveals market penetration, identifies growth opportunities, and highlights geographic concentration risk.
Revenue Per Visitor
E-commerceMetric Definition
RPV = Total Revenue / Unique Visitors
Revenue per visitor (RPV) divides total revenue by the number of unique site visitors. It combines conversion rate and average order value into a single efficiency metric that reflects overall store performance.
Sessions to Purchase Ratio
E-commerceMetric Definition
Sessions to Purchase Ratio = Total Sessions / Total Purchases
Sessions to purchase ratio measures how many site sessions are needed, on average, before a visitor makes a purchase. It captures the consideration cycle length and browsing behaviour of your customers.
Shipping Cost Analysis
E-commerceMetric Definition
Shipping cost analysis measures total shipping expenditure and cost per order across carriers, destinations, and service levels. It reveals the true logistics cost of fulfilling customer orders.
Store Conversion Rate
E-commerceMetric Definition
Store Conversion Rate = (Purchasing Visitors / Total Unique Visitors) × 100
Store conversion rate is the percentage of unique visitors who complete at least one purchase. It is the broadest measure of how effectively your store converts browsing traffic into paying customers.
Top Selling Products Analysis
E-commerceMetric Definition
Top selling products analysis ranks products by revenue, units sold, or order count to identify the items that drive the most business value. It highlights heroes, rising stars, and declining performers.
Traffic Source Performance
E-commerceMetric Definition
Traffic source performance evaluates each traffic source on volume, conversion rate, revenue contribution, and customer quality. It compares organic, paid, social, email, direct, and referral channels holistically.
Abandoned Cart Recovery Rate
E-commerceMetric Definition
Abandoned Cart Recovery Rate = (Recovered Carts / Total Abandoned Carts) × 100
Abandoned cart recovery rate is the percentage of abandoned carts that are subsequently converted into completed orders through recovery efforts such as email sequences, SMS reminders, or retargeting campaigns. It quantifies the effectiveness of your win-back automation.
Average Product Rating
E-commerceMetric Definition
Average Product Rating = Sum of All Ratings / Number of Reviews
Average product rating is the mean star rating across all customer reviews for a given product or your entire catalogue. It serves as a proxy for customer satisfaction and product quality perception.
Cart Conversion Rate
E-commerceMetric Definition
Cart Conversion Rate = (Completed Orders / Sessions with Add-to-Cart) × 100
Cart conversion rate is the percentage of visitors who add items to their cart and subsequently complete a purchase. It isolates the effectiveness of the post-browse, pre-checkout stage of the buying journey.
Checkout Abandonment Rate
E-commerceMetric Definition
Checkout Abandonment Rate = ((Checkout Starts - Completed Orders) / Checkout Starts) × 100
Checkout abandonment rate is the percentage of visitors who initiate the checkout process but leave before completing payment. Unlike cart abandonment, it focuses exclusively on drop-off after the buyer has committed to purchasing.
Collection Performance Analysis
E-commerceMetric Definition
Collection performance analysis evaluates each Shopify collection on revenue contribution, conversion rate, average order value, and traffic volume. It reveals which product groupings resonate with customers and which underperform.
Customer Cohort Analysis
E-commerceMetric Definition
Customer cohort analysis groups customers by their acquisition period and tracks their purchasing behaviour over subsequent time intervals. It reveals how retention, order frequency, and revenue evolve for each cohort as they mature.
Customer Segmentation Analysis
E-commerceMetric Definition
Customer segmentation analysis divides your customer base into distinct groups based on purchasing behaviour, order value, frequency, recency, and product preferences. It enables targeted strategies for each segment rather than a one-size-fits-all approach.
Payment Method Distribution
E-commerceMetric Definition
Payment method distribution measures the share of transactions completed via each payment method, including credit cards, digital wallets, buy-now-pay-later, and alternative payment options. It reveals customer payment preferences and potential friction points.
Revenue Growth Rate
E-commerceMetric Definition
Revenue Growth Rate = ((Current Period Revenue - Previous Period Revenue) / Previous Period Revenue) × 100
Revenue growth rate measures the percentage change in revenue between comparable periods, typically month-over-month or year-over-year. It captures the overall trajectory of your business and whether growth is accelerating or decelerating.
Seasonal Trend Analysis
E-commerceMetric Definition
Seasonal trend analysis examines recurring patterns in sales, traffic, and customer behaviour across different time periods - weekly, monthly, and annually. It identifies predictable demand cycles that inform planning decisions.
Related integrations
Other data sources that work with KPI Tree.
Common questions
- Shopify ships two official MCP servers with every store: the Storefront MCP for products, cart, and checkout, and the Customer Accounts MCP for order history and account data. KPI Tree can consume both for shopper-facing and customer-account analytics. For full merchant analytics like historical GMV, cohort retention, and product-level margin, most teams replicate Shopify Admin data to Snowflake, BigQuery, or Databricks via Fivetran, Hightouch, or the Shopify Data Export, and KPI Tree reads those tables directly. Teams without a warehouse engage our professional services team, which stands up the pipeline and ships dbt models for the full order lifecycle.
- Any metric computable from Shopify data in your warehouse: GMV, net revenue, average order value, units per order, conversion rate, cart abandonment rate, repeat purchase rate, customer lifetime value, refund rate, product category mix, discount usage rate, fulfilment time, and more. If it can be expressed as SQL against your Shopify tables, it can be a KPI Tree metric.
- Yes. KPI Tree connects to your warehouse, not directly to Shopify, so it works identically for standard Shopify and Shopify Plus stores. Any additional data that Shopify Plus provides - such as more granular checkout and script data - is usable as long as it reaches your warehouse.
- It depends on your connection method. With MCP, you can be pulling Shopify metrics in minutes - no warehouse needed. If your data is already in a warehouse, connecting KPI Tree takes under an hour. Teams with a dbt semantic layer can sync Shopify metrics in one click. For Professional Services engagements where we build the AI foundations, timelines depend on scope but typically take a few weeks.
- No. Shopify Analytics is designed for day-to-day store operations - order management, product performance, traffic reports. KPI Tree serves a different purpose: modelling how e-commerce metrics causally drive each other, assigning ownership across teams, and creating accountability loops. Most teams use both.
- Yes. If data from multiple Shopify stores lands in the same warehouse, you can create metrics that span stores or build separate trees per store. Each metric carries its own ownership and monitoring regardless of which store generated the data.
- KPI Tree connects to your warehouse, not directly to Shopify. Your warehouse security model - RSA key-pair authentication, service accounts, network policies - remains fully enforced. KPI Tree queries aggregated metric data, not individual customer PII.
- No. You can define metrics directly with SQL against your Shopify warehouse tables. If you use dbt with Shopify source models (such as the dbt-shopify package), KPI Tree can sync those metric definitions automatically via the dbt Cloud or dbt Core integration.
Related guides
Deep dives into the frameworks and metrics that work with Shopify.
Your store generates the data. Make sure your team acts on it.
Connect your warehouse to KPI Tree and turn Shopify order data into causal metric trees with ownership, statistical analysis, and accountability across marketing, merchandising, and operations.
