Skip to main content
Total revenue from repeat buyers including shipping and taxes.

Formula

Returning Customer Total Revenue = SUM ( Order Total ) WHERE customer_type = returning_customer

Formula Components

MetricDefinition
Order TotalComplete order value including product subtotal, shipping, and taxes
customer_type = returning_customerFilter for customers who have placed at least one prior order
Metadata
TypeCurrency
Data SourceShopify
AggregationSum

Example

Your store generated $215,780 from returning customers in April:
WeekRC RevenueOrdersAvg Order
Week 1$48,920412$118.74
Week 2$56,340478$117.87
Week 3$52,180439$118.86
Week 4$58,340491$118.82

How It Works

Returning Customer Total Revenue sums the complete order value—product subtotal, shipping, and taxes—for every customer who has placed at least one prior order. Shopify determines returning status based on email address match against previous orders.

When to Use

ScenarioAction
Measure retention valueQuantify revenue from your existing customer base
Track revenue mixMonitor the split between new and returning customer revenue
Evaluate loyalty programsAssess whether retention efforts drive repeat purchases
Calculate customer lifetime valueUse as the repeat-order revenue component for LTV

MetricRelationship
Total RevenueAll customers combined (NC + RC)
New Customer Total RevenueThe acquisition counterpart to this metric
Returning Customer Net RevenueSame segment, excludes shipping/taxes
Returning Customer Gross RevenueSame segment, before discounts and refunds
See all Revenue metrics →