Overview

Subscription Order Revenue refers to the total order revenue generated from all subscription orders.

📘

Subscription Order Revenue = Order Revenue from Subscription Orders

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

Detailed Breakdown

The formula above is derived from the following components:

• Subscription Order Revenue = sum(total_revenue) --> Subscription Metrics table
  • Where underlying logic = sum(order_revenue) where is_subscription_order = true --> Orders table

Insights and Actions

Subscription Order Revenue helps evaluate the strength and stability of your recurring revenue stream by capturing the total income from all active subscriptions:

• Track Subscription Growth: Monitor Subscription Order Revenue over time to measure the impact of retention, reactivation, and new subscriber growth on recurring income.
• Evaluate Retention Efficiency: Compare trends with Active Subscribers and Total Churned Subscribers to determine whether recurring revenue is growing sustainably.
• Balance Revenue Mix: Analyze Subscription Order Revenue alongside Order Revenue from the Orders table to understand how subscriptions contribute to total business revenue.

Related Metrics

• Active Subscribers – Indicates the number of ongoing paying subscribers driving recurring revenue.
• Total New Subscribers – Helps assess how acquisition efforts expand your subscriber base and revenue potential.
• Total Churned Subscribers – Shows subscription attrition that directly impacts recurring order revenue.

Example Use

Prompt

What was my total revenue from subscription orders yesterday?

Response

Query

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