How to Set Up the Subscription Lifetime Value Report

The Subscription Lifetime Value template shows the Lifetime Value of your customers for your selected subscriptions. 

Search for the Subscription Lifetime Value Template

To begin, click the “+” icon on your Dashboard and type “Lifetime” into the search bar. Then select the “Subscription Lifetime Value” template.

The subscription lifetime value template highlighted in the template library.

Chart Tab

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.

The chart type 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.

Click the Show Total Number box to display the total in the top right of the report.

Options Tab

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.

Select the subscriptions you want to track.
You can have multiple subscriptions being tracked.

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.

Select which date you want to use for cancellations.

Next, set your Date Range. I’ll choose Year to Date, and group it by Months as the interval.

Select your date range.
Select the display interval for the date range.

Criteria Builder Tab

For ultimate control and customization, use the Criteria Builder“to include additional rules and requirements to the report.

Use the criteria builder to filter the report furhter.

Once you have your everything set, click Save Preferences on This Widget.

Relevant Articles

Create Your Free Graphly Dashboard

You don’t need to struggle to find the data you need from your Infusionsoft or Keap application.  Create a free visual dashboard using the Graphly Lite plan. Using Graphly Lite, you get 1 user, 2 dashboards, and access to our 10 most widely used report templates. These templates include: 

  • Tags Applied 
  • Tags Applied Goal
  • Leads
  • Gross Revenue
  • Appt | Note | Task Summary
  • Email List Health
  • Refunds
  • Campaign Email Stats
  • Text Widget Area 

If you don’t already have a Graphly account, click here to get a Graphly Lite account so you can start making more informed decisions and grow your business.

Tags: , ,

Was this helpful?