Skip to main content
Total revenue from orders where a customer starts a new subscription for the first time.

Formula

Subscription Initial Purchase Revenue = SUM ( Order Revenue ) WHERE order_type = subscription_initial_purchase

Formula Components

MetricDefinition
Order RevenueTotal revenue value of each order
order_type = subscription_initial_purchaseFilter for orders that initiate a new subscription (excludes recurring renewals and one-time purchases)
Metadata
TypeCurrency
Data SourceShopify
AggregationSum

Example

Your store generated $18,630 in subscription initial purchase revenue in Q1:
MonthRevenueNew SubscribersAvg Initial Order
January$5,39098$55.00
February$6,205107$58.00
March$7,035119$59.12

How It Works

This metric sums revenue from a customer’s first subscription order. It excludes subsequent recurring charges and one-time purchases. Subscription initial purchases are identified by matching a subscription_initial_purchase event with the same order ID.

When to Use

ScenarioAction
Value subscription acquisitionsMeasure revenue from new subscriber signups
Calculate subscription CACCompare against marketing spend for subscriber acquisition
Analyze subscription pricingTrack average first-order value for new subscribers
Forecast recurring revenueProject LTV from initial subscription value

MetricRelationship
Subscription Initial Purchase OrdersCount of initial subscriptions (this metric sums their value)
Total RevenueAll order revenue including subscriptions
New Customer Total RevenueRevenue from first-time buyers (different from first-time subscribers)
Net RevenueRevenue after discounts and refunds
See all Revenue metrics →