Hello manfred wang!

Thank you for your great questions and sorry for my late reply.

1) I decided to show the general formula for CLTV to make a reader aware about the concept. However, due to data limitations, I decided to focus on the sales only, which I think should be directly related to CLTV. More a user spends - higher CLTV he/she has.

2) Regarding new customers, I think it's quite tricky to predict their CLTV becuase we do not know about their purchasing behavior. Therefore, I would exclude them from the anaysis and wait until we get enough data.

Hope I could answer your questions.

If you have any ides on the questions you asked, please share with me. I'd be happy to learn from you 😊

Also, I'd be happy to get connected with you on LinkedIn and keep in touch. My LinkedIn: https://www.linkedin.com/in/aigerimshopenova/

Kind regards,




Data Scientist @ Rakuten | 💜 Data Science and Psychology | https://www.linkedin.com/in/aigerimshopenova/

Love podcasts or audiobooks? Learn on the go with our new app.

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store