How Do I Calculate My Active Subscribers for a Specific Month Using Exports?

To calculate the total number of active subscribers for a specific month, you can use the Subscriptions export and a series of filters.

Here are the steps to follow:

1. Download the Subscriptions Export:

   • Download the Subscriptions export for "All" statuses and a Time Range of "All Time."

2. Filter by Activation Date:

   • In the downloaded file, go to the activated_at column and remove all subscriptions that were activated after the last day of the month you are analyzing.

3. Filter by Expiration Date:

   • Next, go to the expired_at column and remove all subscriptions that were expired before the last day of the month you are analyzing.

4. Remove Duplicate Subscribers:

   • Lastly, check the account_code column for duplicates. Since "Active Subscribers" counts individual subscribers and not individual subscriptions, you should remove the second subscription for any duplicate account codes.

The remaining list will represent your total number of active subscribers for that month.