Free business impact calculator for experiments

Over the past years I have developed a business impact calculator template based on the learnings from running hundreds of experiments across multiple subscription-based mobile apps. I used this experience to create and finetun the model that has now been published by Reforge Artifact  and is free to download 🎉

Reforge artifacts has a number of amazing product, growth, and marketing artifacts that can help you accomplish your tasks faster and at higher quality. I am happy that some of my templates are available among so many other great artifacts. When you take a look at my artifact, make sure to browse the others as well!

‍

Overview of the template

The template works best as part of your experimentation brief (see here for a free experimentation brief template you can use) where you define the expected business impact of your upcoming experiment (e.g. during onboarding or on the paywall). By providing estimates on how your conversion and retention rates are going to change with your newest experimentation idea, the model calculates the experiment’s impact on revenue. This is fed back into your experiment brief to evaluate whether it makes sense to prioritize this particular experiment.

‍

‍

The spreadsheet has two main tabs

1. Business Impact Calc: provides an overview over all results and contains all underlying calculations apart from the subscription renewal (retention) calculation
2. Renewal Calc: contains the retention model and corresponding renewal revenue calculations for the subscription plans of the baseline and new variant.

It's easy to get started using this document by adding in your unique data. Opening this file in Google Sheets also includes detail use instructions.

‍

‍

Download free template

You can download the free template here.

If you need any support working on the model, feel free to reach out.