This template shows the Lifetime Value of your customers for your selected subscriptions.
To begin, click the “+” icon on your Dashboard and type “Lifetime” into the search bar. Then select the “Subscription Lifetime Value” template.
This report defaults to the Area chart type, I’ll leave it there. Because we are tracking just a single data point, stacking has no bearing on this report.
Check the “Show Total Number” box if you want to display the total on the top right-hand corner of the graph.
Now go to the “Options” tab. First, select your Subscriptions. Choosing more than one subscription plan joins the data into a single column, bar, or line. If you want to compare the lifetime value for one subscription to the lifetime value of another subscription, you’d use two separate widgets to do so.
Next, define your cancellation date. You might be wondering why we are asking about a cancellation date when you’re wanting to project future revenue from active customers . The short answer is, that it helps us figure out attrition which is very valuable when used in calculating lifetime value.. You’re simply helping us choose the best date for your business to define Active, versus Inactive.
Our first Option is Next Bill Date. This will be the most common selection for cancellation date. As a simple example: If the client is being billed on October 1st, they are essentially paid through the end of the month. And we would make their cancellation date November 1st if we chose the next bill date as our option.
The second option is Last Bill Date. This is going to be used a lot less frequently. But if you bill after a service is provided, at the tail end of that service, you would use Last Bill Date.
e third and final option is End Date. This is a great option because the End Date is not set automatically inside Infusionsoft, but rather you as a user have the ability to adjust and edit this field so that you can set a very specific day as the Cancellation Date. If you choose this option you HAVE to ensure that this field is always being set.
Next, set your Date Range. I’ll choose Year to Date, and group it by Months as the interval.
For ultimate control and customization, use the “Criteria Builder” to include additional rules and requirements to the report.
Once you have your everything set, click “Save Preferences” on This Widget.