How to export the subscription count report from Chargebee?
Problem Statement
The Subscriptions index displays 1000+ when the list contains more than 1,000 subscriptions, so the page does not show an exact count. Is there a way to export the subscription count?
Solution
Total Subscriptions is the Subscription Count report in Reports Explorer. It is the number of subscriptions during the selected period, including unpaid subscriptions. The count includes subscriptions in Trial, Active, Canceled, Non-renewing, and Future status as of the end of that period. For how the metric is calculated, see Total Subscriptions.
Total Subscriptions is the count for the period shown on the report. It is not the number of rows on the current Subscriptions index.
- Go to RevenueStory > Reports Explorer.
- Search for Total Subscriptions and select the report. Quick View shows the count for the period on screen. Monthly is the default granularity. Select another granularity when you need a different period.
- You can use the time-period selector to choose the desired date range before downloading the CSV.
- Click Download as CSV.
Chargebee downloads a CSV file of the Total Subscriptions report for the period shown in Quick View.
To export the count for each plan, search for Total Subscriptions by Plan instead of Total Subscriptions, then click Download as CSV. For how that metric is calculated, see Total Subscriptions by Plan.