Provide a CLV (Customer lifetime value) formula according to the below data dictionary (you need to pick and select relevant variables)

Data dictionary

*The data may require further cleaning and recoding depending on the analyses you wish to do. You may also need to make assumptions with justification for your analyses. E.g.

1. customer_id: unique customer ID
2. User.Profiles.Age: age
3. User.Profiles.Gender: gender
4. Users.Auto.Invest.Amount: amount of recurring/automatic investment
5. Users.Auto.Invest.Frequency: frequency of payment through auto investment (0= recurring investment not set up (1 = daily; 2 = weekly; 3 = monthly; 4 = fortnightly)
6. User.Profiles.Spending.Account: whether the user has linked a spending account
7. Roundup.Settings.Automatic.Roundup.Enabled.Date: date of signing up for Roundup investment option
8. Users.Created.Week: Joining date
9. Users.Closed.Week: Closing date (churn indicator)
10. Users.Source.ID: Acquisition channel
11. Users.Sign.In.Count: Frequency of sign in incidents by a given user
12. Suitability.Netwealth: reported netwealth (1=less than $10,000; 10001=$10,000-$50,000; 50001=$50,000-$100,000; 100001=$100,000 - $250,000; 250001= $250,000+)
13. Suitability.Yearly.Income: (1=less than $25,000; 20001=$25,000-$50,000; 50001=$50,000-$100,000; 100001=$100,000 - $250,000; 250001= $250,000+)
14. Suitability.Reason.to.Invest: Reason to invest: Children General Long_term Major_Purchase Short_term
15. Suitability.Time.Frame (investment time horizon): 5=less than 5 years; 10=5-10 years; 15=10-15 years; 25=15-25 years; 100=25+ years)
16. User.Portfolios.Portfolio.ID: 1 = conservative; 2 = moderately conservative; 3 = moderate; 4 = moderately aggressive; 5 = aggressive; 6 = emerald
17. Returns.Investment.Amount.Deposit: Total deposit (if deposit is NA, then the customer has not activated the account)
18. Returns.Investment.Amount.Withdraw: Total withdrawal
19. Returns.Investment.Balance: balance (deposit - withdrawal+ return)
20. Returns.Investment.Return.Amount: return on investment
21. User.Investment.First.Date.Account.Duration.Before.Close in days, only for those who have churned
22. User.Investment.First.Date.Days.Since.First.Investment
23. User.Last.Investment.Date.Days.From.Last.Investment
24. User.Profiles.Zip: postcode
25. User.Profiles.State: State (location)
26. User.Profiles.Occupation:
27. Users.Sale.Subscriptions.Created.Date (date which the customer turned on the carbon offset program where they pay for carbon emissions associated with their transaction.
28. Users.Sale.Subscriptions.Active (whether they turned on the carbon offset program)
29. Suitability.Status.Employment: levels : Full-Time Part-Time Retired Self-Employed Student Unemployed
30. Referrals.Count.Referrer.Reward.ID (the number of referred customers who signed up to the service and activated the account by investing at least $5)
31. Fee: total amount of investment fees paid to Raiz Invest
32. Total_reward: total amount of Raiz Rewards received
33. Churn_prob: churn probability
34. predicted.churn: Yes = likely to churn; No = likely to stay
35. Churns Threshold: the cutoff used to determine predicted.churn
36. super Whether the customer has Raiz superannuation account
37. super_balance The amount of balance in the Raiz superannuation account
38. survey_gender: gender reported in the survey
39. survey_state: state (location) reported in the survey
40. survey_age: age reported in the survey
41. survey_postcode: postcode reported in the survey
42. nps: How likely are you to recommend Raiz Invest to a friend or colleague? (0 = Not at all likely to recommend; 10 = Extremely likely to recommend)
43. request: Have you previously had to contact Raiz Invest with a request? (1=Yes; 2=No)
44. Effort: How much effort did you personally have to put forth to handle your request? (1 = Very low effort; 5 = very high effort)
45. Satisfaction: All in all, how satisfied or unsatisfied are you with Raiz Invest? (1 = very dissatisfied; 7 = very satisfied)
46. use_other Do you use any other investment services/platforms similar to Raiz Invest? (1= Yes; 2 = No)
47. use_other_names Which other investment services/platforms do you use that are similar to Raiz Invest? [text]
48. aware_other (Only ask if use_other = No) Which other investment services/platforms are you aware of that are similar to Raiz Invest?
49. relative_sat Compared to other investment services/platforms you use or aware of that are similar to Raiz Invest, how satisfied are you with Raiz Invest? (1 = much less; 7 = much more)
50. relative _rec Compared to other investment services/platforms you use or aware of that are similar to Raiz Invest, how likely are you to recommend Raiz Invest? (1 = much less; 7 = much more)
51. relative _rep Compared to other investment services/platforms you use or aware of that are similar to Raiz Invest, how likely are you to repurchase Raiz Invest? (1 = much less; 7 = much more)
52. started_time time survey was started
53. completed_time time survey was completed
54. time_to_complete
55. device Device used to answer the survey
56. mobile Whether the device was mobile