Active Subscriptions Report

The Active Subscriptions Report provides a snapshot of your subscription base at a specific point in time. Unlike most reports that show activity over a date range, this report answers the question: "What did my active subscriptions look like on this date?" It shows how many subscribers and subscriptions are active, how many have charges or shipments scheduled, and gives you a clear picture of your recurring revenue foundation.

Important: This is a single-date snapshot report. It shows the state of your subscriptions on the selected date — not a sum or trend over a date range. The date filter is based on the original order date.

What This Report Includes

This report captures the status of all active subscriptions as of the selected date, based on when the original order was placed.

Subscriptions Included:

• Subscriptions with an active or paused status as of the selected date
• Subscriptions that were cancelled after the selected date are included (they were still active at that point in time)
• Test orders are excluded
• This is a point-in-time snapshot — the selected date determines the "as of" date for evaluating subscription status

Why This Matters: Your active subscription base is the foundation of your recurring revenue. Understanding its size, the proportion of subscriptions with upcoming billing activity, and how many shipments are pending gives you the visibility needed to forecast revenue, plan fulfillment, and monitor subscriber retention health.

---

Report Metrics

Active Subscribers

The number of unique customers who have at least one active subscription on the selected date. A customer with multiple active subscriptions is counted only once. This metric tells you the size of your subscriber base in terms of real people — your core recurring customer count.

Active Subscriptions

The total number of active subscriptions on the selected date. A single customer may have multiple subscriptions (e.g., different products, different billing frequencies). This metric captures the full volume of your recurring obligations and is typically higher than Active Subscribers when customers hold more than one subscription.

Scheduled Charges

The number of active subscriptions that have a pending renewal charge scheduled. These subscriptions are queued for their next billing cycle. Comparing Scheduled Charges to Active Subscriptions tells you what proportion of your base is approaching its next payment, which is essential for revenue forecasting.

Scheduled Charges Rate

The percentage of active subscriptions that have a scheduled charge, calculated as Scheduled Charges divided by Active Subscriptions. A rate near 100% means nearly all active subscriptions are set to bill on schedule. A significantly lower rate may indicate subscriptions in a paused state, awaiting customer action, or in a skip cycle — worth investigating if unexpected.

Scheduled Shipments

The number of active subscriptions that have an upcoming shipment scheduled for fulfillment. This metric helps your operations and logistics teams prepare for fulfillment volume. Comparing Scheduled Shipments to Scheduled Charges can reveal whether billing and fulfillment are aligned.

---

Available Dimensions

Use these dimensions to slice and filter your active subscription data for deeper analysis.

Key Business Insights

1. Track Subscriber Base Growth Over Time

Run this report for the same date each week or month and compare Active Subscribers over time. An upward trend means your acquisition is outpacing churn. A flat or declining trend signals that you need to focus on either acquisition, retention, or both.

2. Subscriptions Per Subscriber Ratio

Calculate: Active Subscriptions / Active Subscribers. A ratio above 1.0 means your average subscriber holds more than one subscription. This is a powerful indicator of customer engagement and cross-sell effectiveness. If this ratio is declining, explore ways to encourage multi-product subscriptions.

3. Billing Readiness Check

Use Scheduled Charges Rate to gauge how much of your subscription base is ready to bill. If this rate drops significantly compared to prior snapshots, investigate whether subscriptions are being paused, delayed, or stuck in an unexpected state that's preventing billing.

4. Fulfillment Planning

Scheduled Shipments gives your operations team a forward-looking view of upcoming fulfillment demands. Compare this to recent fulfillment volumes to anticipate whether capacity, inventory, and logistics are adequately prepared.

5. Billing-Fulfillment Alignment

If Scheduled Charges is significantly higher than Scheduled Shipments (or vice versa), it may indicate a mismatch between billing and fulfillment cycles. Ideally these numbers move together — charges should correspond to shipments for most subscription models.

---

Optimization Strategies

Monitor Subscription Health

• Run this report on a consistent schedule (same day each week or month) to track your subscriber base trajectory
• Compare Active Subscribers to new subscription counts from other reports to calculate implicit churn — if you added 500 subscribers but Active Subscribers only grew by 200, approximately 300 were lost
• Watch for sudden drops in Active Subscriptions that don't correlate with known business actions (e.g., a purge or policy change)

Improve Retention

• A declining Active Subscribers trend over multiple snapshots is your most reliable early warning for retention problems
• Investigate the gap between Active Subscriptions and Scheduled Charges — subscriptions that are active but not scheduled to bill may be at risk of lapsing
• Use this report alongside your Transactions Report to correlate active subscription counts with actual renewal success rates

Optimize Fulfillment Operations

• Use Scheduled Shipments to provide your warehouse and fulfillment partners with advance volume forecasts
• If Scheduled Shipments fluctuates significantly week to week, investigate whether subscription billing dates are well-distributed or clustered — clustering can create fulfillment bottlenecks
• Align inventory purchasing with Scheduled Shipments trends to minimize both stockouts and excess inventory

---

Pro Tips

1. Remember: this is a snapshot, not a trend. Each date you select shows the state of subscriptions at that moment. To see trends, run the report for multiple dates and compare the results. Don't misinterpret a single snapshot as showing change over time.

2. Use this report for investor and stakeholder reporting. Active Subscribers and Active Subscriptions are among the most-requested metrics for recurring revenue businesses. A clean, consistent snapshot gives stakeholders the numbers they need without overcomplicating the data.

3. Cross-reference with revenue reports. Active Subscriptions tells you how many subscriptions exist, but the Transactions Report tells you how they're actually performing. Use both together to get the full picture: subscription base size (here) plus billing success, revenue, and retention (Transactions Report).

---

Frequently Asked Questions

Why is this report based on a single date instead of a date range?

Active subscriptions are a status, not an event. A subscription is either active or it isn't at any given moment. Using a date range would create ambiguity — a subscription that was active on day one but cancelled on day five wouldn't be accurately represented by a range-based count. The snapshot approach gives you the clearest, most accurate view.

What counts as an "active" subscription?

A subscription is counted as active if it is in an active or paused status on the selected date. Subscriptions that have been cancelled or expired before the selected date are not included.