Exercise

Calculate traditional CLV

Now you will calculate one of the most popular descriptive CLV models that accounts for the retention and churn rates. This gives a more robust estimate, but comes with certain assumptions that have to be validated. Make sure you review the video slides before you apply this method to your own use case.

The pandas and numpy libraries have been loaded as pd as np respectively. The online and retention datasets have been imported for you.

Instructions

100 XP
  • Group by CustomerID and InvoiceMonth and calculate monthly spend per customer.
  • Calculate average monthly retention rate.
  • Calculate average monthly churn rate.
  • Calculate traditional CLV by multiplying monthly average spend with retention to churn ratio.