KPI Tree

Shopify Metric

Revenue

Revenue Per Customer = Total Order Revenue in Period / Number of Distinct Customers in Period

Revenue Per Customer measures the average total revenue your Shopify store generates from each unique customer over a chosen period. It is built from Shopify order data grouped by customer record, summing the value of every order a shopper has placed and dividing by the number of distinct customers. Unlike average order value, which looks at single transactions, this metric captures the full spend of each customer across repeat purchases.

Full guide: definition, formula, and benchmarks
ShopifyRevenue

Revenue Per Customer

Revenue Per Customer measures the average total revenue your Shopify store generates from each unique customer over a chosen period. It is built from Shopify order data grouped by customer record, summing the value of every order a shopper has placed and dividing by the number of distinct customers. Unlike average order value, which looks at single transactions, this metric captures the full spend of each customer across repeat purchases.

How to calculate revenue per customer

Revenue Per Customer = Total Order Revenue in Period / Number of Distinct Customers in Period

Why revenue per customer matters for Shopify users

For a Shopify store, acquiring a customer carries a fixed cost in ads, discounts and effort, so the more revenue each customer returns the healthier the unit economics. Revenue Per Customer tells you whether shoppers are coming back and spending again or whether the store relies on a constant stream of one-off buyers to hit its numbers.

Watching this metric over time shows whether retention, cross-selling and loyalty efforts are actually paying off. A rising figure means your customer base is becoming more valuable, while a flat or falling figure is an early warning that growth depends on ever more expensive acquisition rather than deepening relationships with existing shoppers.

Understand and act on revenue per customer with KPI Tree

Sync your Shopify orders and customers data into your warehouse and compute Revenue Per Customer in KPI Tree by aggregating order revenue per customer record over your chosen window. Place it in a metric tree alongside average order value and cart conversion rate so you can see how order size and conversion roll up into the value of each customer.

Assign RACI ownership in KPI Tree to your retention or ecommerce lead so it is clear who is accountable for moving the number, and set a monthly review cadence to catch shifts in repeat purchase behaviour before they show up in revenue.

Get started with your Shopify data

Query using MCP
MCP

Pull metrics from Shopify directly through the Model Context Protocol.

Data Warehouse
SnowflakeBigQueryDatabricksRedshift

Connect your existing warehouse where Shopify data already lands.

Professional Services
FivetranSnowflakedbt

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.

Empower your team to understand and act on Shopify data

Map what drives your metrics, measure progress at any grain, prove what works statistically, and deliver personalised action plans to every team member.

Experience That Matters

Built by a team that's been in your shoes

Our team brings deep experience from leading Data, Growth and People teams at some of the fastest growing scaleups in Europe through to IPO and beyond. We've faced the same challenges you're facing now.

Checkout.com
Planet
UK Government
Travelex
BT
Sainsbury's
Goldman Sachs
Dojo
Redpin
Farfetch
Just Eat for Business