Banyan - Sutra Project Workshop 2 Materials

Banyan - Sutra Project Workshop 2 Session

Objectives

Cross Sell and Upsell and Increase Lifetime value of customer

Question that needs to be answered: What campaign should i run to achieve above

Business lines in scope:

  • CM (Hotel)
  • MYK (Hotel)
  • PB (Hotel)
  • Banyan Tree Essentials (SPA Retail)

Data Analysis Findings - Hotel Reservation & FinTrax

image

Data Cleansing - Customers

image

Overview

Count
Total customers with spent
188,121
Unique customers with spent
94,706
Unique customers with -ve spent
124
Unique customers with +ve spent
94,582