Metric Name
|
Definition
|
Page Availability
|
1st Sub. Order Revenue
|
SUM(Revenue) WHERE is_first_sub_order
|
Executive Summary,Product Performance
|
1st Sub. Orders
|
COUNT_DISTINCT(order_id) WHERE is_first_sub_order
|
Executive Summary,Product Performance
|
Active Revenue
|
SUM(Revenue) WHERE is_active
|
Active Subscribers
|
Count of all unique customers with at least 1 active subscription
|
Executive Summary
|
Active Subscriptions
|
Count of all currently active subscriptions (subscription_id)
|
Executive Summary,Product Performance
|
Active Subscriptions per Subscriber
|
Active Subscriptions / Active Subscribers
|
Executive Summary
|
AOV - Sub.
|
Sub. Revenue / Sub. Orders
|
Executive Summary,Product Performance
|
Cancelled Subscribers
|
Count of unique customers with no more active subscriptions — essentially the non-cumulative representation of Churned Subscribers
|
Executive Summary
|
Cancelled Subscriptions
|
Count of all cancelled subscriptions
|
Executive Summary,Product Performance
|
Churned Subscribers
|
Cumulative count of all unique customers who have churned fully from your subscription program since inception. Note: a subscriber will be considered churned the day AFTER they cancel.
|
Executive Summary
|
Churned Subscriptions
|
Cumulative count of all cancelled subscriptions since the start of your subscription program
|
Executive Summary,Product Performance
|
Discounts
|
The monetary value of discounts applied to subscription orders within a given aggregation
|
Product Performance
|
Dunned Subscribers
|
Count of all unique customers who have 1 or more subscriptions in “dunning” — e.g. passive cancel due to failed card attempts
|
Executive Summary
|
Dunning Subscriptions
|
Count of all subscriptions in “dunning” — e.g. passive cancel due to failed card attempts
|
Executive Summary,Product Performance
|
Gross Revenue
|
line item price * Quantity
|
Product Performance
|
MRR
|
sub price / interval * 30.437
|
Executive Summary,Product Performance
|
MRR - Cancelled
|
sub price / interval * 30.437 from cancelled subscriptions within the date range
|
Executive Summary,Product Performance
|
MRR - Current
|
sub price / interval * 30.437
|
Executive Summary
|
MRR - New
|
sub price / interval * 30.437 from new subscriptions within the date range
|
Executive Summary,Product Performance
|
New Active MRR
|
sub price / interval * 30.437 from new subscriptions that are still active within the date range
|
Product Performance
|
New Active MRR / Sub.
|
New Active MRR / New Active Subscriptions
|
Product Performance
|
New Active Price / Sub.
|
Active Revenue / Active Subscriptions
|
Product Performance
|
New Active Subscriptions
|
Count of all active subscriptions with a created_at date falling within the selected date range.
|
Product Performance
|
New Subscribers
|
Count of unique customers who became subscribers — no previously active subscriptions, now subscribed
|
Executive Summary
|
New Subscriptions
|
Count of new subscriptions — not dependent on the subscriber being a New Subscriber
|
Executive Summary,Product Performance
|
Recurring Sub. Order Revenue
|
SUM(Subtotal Revenue) WHERE is_recurring_sub_order
|
Executive Summary,Product Performance
|
Recurring Sub. Orders
|
COUNT_DISTINCT(order_id) WHERE is_first_sub_order
|
Executive Summary,Product Performance
|
Rev. / Unit
|
Sub. Revenue / Sub. Quantity
|
Product Performance
|
Revenue
|
subtotal_revenue
|
Executive Summary,Product Performance
|
Sub. Orders
|
COUNT_DISTINCT(order_id) WHERE is_sub_order
|
Executive Summary,Product Performance
|
Sub. Quantity
|
SUM(quantity) WHERE is_sub_order
|
Product Performance
|
Sub. Revenue
|
SUM(Gross Revenue - Discounts) WHERE is_sub_order
|
Product Performance
|
Subscription Interval Days (Interval)
|
A string dimension representing the subscription billing interval — e.g. how often does this recurring order ship
|
Product Performance
|
Subscription Order Sequence
|
A string representing whether a given order was a 1st-time subscription, recurring subscription, or non-subscription order
|
Product Performance
|
Subscriptions
|
COUNT_DISTINCT(subscription_id)
|
Executive Summary,Product Performance
|