Customer Spending and Retention Pattern Modeling
Originally published: 13/09/2021 07:51
Publication number: ELQ-33625-1
View all versions & Certificate

Customer Spending and Retention Pattern Modeling

This is a great calculator with clever logic to model revenues based on dynamic spending and retention patterns of your customers over a 60 month period.

First, let's talk about customer spend. If you know that there are large spending changes in your customers from the time they become a customer to the time they stop being one (or into perpetuity) then your financial model / forecast should account for that. Normally the traditional style is to define the average spend per month or average price of the contract they pay for each month, but that might not be sufficient depending on the kind of product or service that is being sold and/or the type of customer spending patterns that exist.

This model makes it easy to model this. You can manually enter the average amount spent for a given customer from month 1 to 60. The logic in this model will then take that and based on the customers added per month, it will calculate the total spend of each monthly cohort in the spending pattern defined across the same timeline in aggregate. The pattern might be defined as a curve or you can roughly estimate the output of spend per month from the initial acquisition and on-going life of your customers that you know to be true.

The second part of this model is customer retention. This aspect usually follows a general average linear curve. In a SaaS model, it would be assumed you lose x% customers per month or at renewal and x% never changes. Now, with this logic you can model dynamic retention rates over a 60-month period. What that means is you are able to define if customer churn happens faster in the first few months, slows down for awhile, speeds up, or whatever configuration makes sense based on your customer research.

The rate of customer loss may change over the life of a cohort. You can capture that dynamic nature with this template.

The final results will show cumulative customers (gained / lost / cumulative) and monthly revenue over a 60 month period. Visualizations make it easy to see the curve you have defined for retention and spend.

This Best Practice includes
1 Excel model and 1 Tutorial Video

Acquire business license for $40.00

Add to cart

Add to bookmarks


Further information

Provide a customer count and revenue forecast for up to 60 months.

When customer retention and spend follow a dynamic pattern instead of a fixed average value.

If spend and retention are constant.


  • Be the first to review this Downloadable Best Practice

    Write a review

People using this Best Practice also downloaded


More Best Practices from Jason Varner

See all

Any questions on Customer Spending And Retention Pattern Modeling?

The user community and author are here to help. Go ahead!

0.0 / 5 (0 votes)

please wait...