I am trying to find customer future value. I am using a very simple formula here. cfv for year 1 = yearly gross margin or profit * probability of retention. Now if I want to find cfv for year 2, then its the same formula but I want to find out probability of retention of customer in year 2. How do I do it?
I could assume probability of retention is constant but in my survival analysis it follows a non linear curve. So its definitely not constant. Most customers drop by year 1, 2 , 3 and then it becomes constant.
Here my target variable is if customer churned or not. I got probability of retention from modelling results.
Wouldn't you get the retention (survival/failure rate) from your survival analysis and apply it to your data? PROC LIFETEST or PROC PHREG can give you the survival rates depending on the complexity of the model.
A lot of this depends on your data structure so if you show what you have and what you've done so far, we can probably recommend the next steps from there.
@harsh0404 wrote:
I am trying to find customer future value. I am using a very simple formula here. cfv for year 1 = yearly gross margin or profit * probability of retention. Now if I want to find cfv for year 2, then its the same formula but I want to find out probability of customer in year 2. How do I do it?
I could assume probability of retention is constant but in my survival analysis it follows a non linear curve. So its definitely not constant. Most customers drop by year 1, 2 , 3 and then it becomes constant.
Here my target variable is if customer churned or not. I got probability of retention from modelling results.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.
Find more tutorials on the SAS Users YouTube channel.