How Do I View My Churn Rate Using Exports?

To view your churn rate using exports, you will need to perform a calculation based on the number of subscriptions that churned and the number of subscriptions that were active at the beginning of the period.

Here is the formula for the calculation:

% Churn = (Total subscriptions churned over the selected interval / Total subscriptions active at the beginning of the selected interval) x 100

Here are the steps to get the data you need from the exports:

Step 1: Find Active Subscriptions at the Beginning of the Period

1. Download the Subscriptions export with the "Status" filter set to "All" and "Time Range" set to "All Time".

2. Once downloaded, go to the activated_at column and remove all subscriptions that were activated after the time period you are analyzing.

3. Next, go to the expired_at column and remove all subscriptions with a date prior to the time period you are analyzing.

4. The remaining list is your total number of active subscriptions at the beginning of the selected interval.

Step 2: Find Churned Subscriptions During the Period

1. Download the Subscriptions - Churned export for the specific time interval you are analyzing (e.g., January 1-31, 2020).

2. Sum the total number of subscriptions listed in this export. This is the total number of subscriptions that churned over the selected interval.

Once you have these two numbers, you can use the formula above to calculate your churn rate.