How Can I Use Exports to Calculate My Total of New Subscribers?

To find the total number of new subscribers for a specific time range, it is crucial to use the Subscriptions export with a "Time Range" of "All Time". This ensures you have a full history of every account, which is necessary to identify and remove all but the original subscription for each account.

Here is the process to find your new subscribers:

1. Download the Subscriptions export with the "Time Range" set to "All Time" and an "End date" that matches the end of your selected timeframe.

2. In the downloaded file, remove all but the first subscription associated with each unique account_code. This will remove duplicate subscriptions and leave only the original one for each account.

3. Use the activated_at column to remove any subscriptions with dates outside of the time range you are analyzing. For example, if you are looking at new subscribers for March 2020, you would remove all dates before and after March 1 - March 31, 2020.

4. After these steps, you can count the number of remaining rows to get the total number of new subscribers for that time period.