Overview

Recurring Order Revenue refers to the total order revenue generated from recurring (non-first) subscription orders.

📘

Recurring Order Revenue = Revenue from Recurring Subscription Orders

The calculation is based on data from the Subscription Metrics table.

Detailed Breakdown

The formula above is derived from the following components:

• Recurring Order Revenue = sum(total_revenue_recurring) --> Subscription Metrics table
  • Where underlying logic = sum(order_revenue) where is_first_order_in_subscription = FALSE --> Orders table

Insights and Actions

Recurring Order Revenue helps you evaluate the long-term health of your subscription business by measuring how much revenue comes from repeat subscription orders rather than new acquisitions:

• Assess Subscription Retention: Monitor Recurring Order Revenue alongside Active Subscribers to understand how effectively your business retains paying customers over time.
• Evaluate Lifetime Value Growth: Use this metric with First Order Revenue to identify how much of your total subscription revenue is driven by renewals versus initial purchases.
• Optimize Retention Campaigns: Compare trends in Recurring Order Revenue and Total Churned Subscribers to determine whether retention efforts are successfully reducing churn.

Related Metrics

• First Order Revenue – Shows revenue from first-time subscription purchases, providing context for total subscription lifecycle value.
• Active Subscribers – Indicates the number of ongoing paying subscribers contributing to recurring revenue.
• Total Churned Subscribers – Helps evaluate if declines in recurring revenue are tied to cancellations or customer attrition.

Example Use

Prompt

What was my revenue from recurring subscription orders yesterday?

Response

Query

SELECT
  SUM(smt.total_revenue_recurring) AS total_revenue_recurring
FROM
  subscription_metrics_table AS smt
WHERE
  smt.event_date = CURRENT_DATE()  - 1;