Overview

First Order Revenue refers to the total revenue generated from first orders in each subscription, after adjustments such as discounts, shipping, fees, and taxes (but before refunds).

📘

First Order Revenue = Gross Sales from First Orders - Discounts + Shipping + Tax

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

Insights and Actions

First Order Revenue measures the revenue contribution from initial subscription purchases, helping you understand the value of newly acquired subscribers and the effectiveness of acquisition strategies:

• Evaluate Subscriber Acquisition Value: Track First Order Revenue alongside Total New Subscribers to gauge the average revenue driven by each new subscription.
• Monitor Subscription Quality: Compare First Order Revenue with Reactivated Subscribers and Active Subscribers to assess whether new or returning customers contribute more to long-term revenue.
• Optimize Campaign Efficiency: Use this metric with Order Revenue from the Orders table to determine how subscription-based revenue complements one-time purchases in your overall sales mix.

Related Metrics

• Total New Subscribers – Measures how many new subscriptions were initiated, providing context for acquisition-driven revenue.
• Active Subscribers – Indicates ongoing subscription engagement and helps evaluate revenue sustainability.
• Order Revenue – Captures total revenue across all orders, enabling comparison between subscription and non-subscription income streams.

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;