How Can I Calculate Subscription Growth for a Plan Using Exports?

To calculate the subscription growth for a specific plan, you will need to compare the number of new subscriptions to the number of churned subscriptions within a given period. This process uses two different data exports to get the necessary information.

Here is how you can perform this calculation for a specific plan:

To Find New Subscriptions

1. Download the Subscriptions export. Set the "Subscription Status" filter to "Live", the "Export On" filter to "Created", and select the "Time Range" for the month you are analyzing.

2. Once downloaded, use the plan_code column to filter for only the plan you are researching.

3. The list that remains is your total number of new subscriptions for that specific plan.

To Find Churned Subscriptions

1. Download the Subscriptions - Churned export. Set the "Time Range" to match the one you used for the Subscriptions export.

2. Use the plan_code column to filter for only the plan you are researching.

3. The list that remains is your total number of churned subscriptions for that specific plan.

To get the Net change for your chosen plan, simply subtract the total number of churned subscriptions from the total number of new subscriptions.