Overview

First Order Revenue refers to the total order revenue generated from first orders in each subscription.

📘

First Order Revenue = Order Revenue from First Orders in Subscriptions

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

Detailed Breakdown

The formula above is derived from the following components:

• First Order Revenue = sum(total_revenue_first_order) --> Subscription Metrics table
  • sum(total_revenue_first_order) = sum(order_revenue) where is_first_order_in_subscription = TRUE --> Orders table

Insights and Actions

First Order Revenue helps evaluate the financial impact of new subscriber acquisitions and the initial value each subscription contributes to your overall revenue:

• Measure New Subscriber Value: Track First Order Revenue alongside Total New Subscribers to understand the average revenue from each newly acquired subscription.
• Assess Retention Quality: Compare First Order Revenue with Active Subscribers and Total Churned Subscribers to see if high initial spend correlates with longer retention.
• Optimize Subscription Offers: Pair First Order Revenue with Total New Subscriptions to assess how pricing, bundling, or discount strategies influence first-purchase performance.

Related Metrics

• Total New Subscribers – Indicates the number of new subscribers gained within the selected period, helping contextualize First Order Revenue growth.
• Active Subscribers – Shows ongoing subscription engagement, useful for linking first-order performance to long-term retention.
• Total Churned Subscribers – Measures the number of subscribers lost, helping identify if high first-order revenue is offset by short subscription duration.

Example Use

Prompt

What was my revenue from first subscription orders over the past 30 days?

Response

Query

SELECT
  SUM(smt.total_revenue_first_order) AS total_revenue
FROM
  subscription_metrics_table AS smt
WHERE
  smt.event_date BETWEEN CURRENT_DATE() - 30 AND CURRENT_DATE()  - 1;