KPI Tree

Shopify Metric

E-commerce

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.

Full guide: definition, formula, and benchmarks
ShopifyE-commerce

Customer Lifetime Value

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.

How to calculate customer lifetime value

LTV = AOV × Purchase Frequency × Average Customer Lifespan

Why customer lifetime value matters for Shopify users

LTV determines how much you can profitably invest in acquiring and retaining customers. It anchors budget decisions across marketing, loyalty programmes, and customer experience investment.

Shopify merchants can segment LTV by acquisition channel, first product purchased, and geography to identify the most valuable customer profiles and optimise acquisition targeting.

Understand and act on customer lifetime value with KPI Tree

Sync Shopify order history to your warehouse and compute LTV in KPI Tree. Build a metric tree linking LTV to its components, AOV, frequency, and retention, so teams can see which lever to pull.

Assign cross-functional ownership and set alerts when LTV-to-CAC ratio falls below your profitability target.

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