Metrics Bin and Dimension Categorisation
Overview of all categorisation and binning logic
Add content here
‣
Age
Generation Categorisation
Silent Generation: Born roughly between 1928 and 1945.
Baby Boomers: Born roughly between 1946 and 1964.
Generation X: Born roughly between 1965 and 1980.
Millennials (or Generation Y): Born roughly between 1981 and 1996.
Generation Z (or Zoomers): Born roughly between 1997 and 2012.
Generation Alpha (or Gen A): Born roughly between 2013 and present.‣
Nationality (geo)
Region, Sub-region
ISO-3166-Countries-with-Regional-Codes.xlsx26.1KB
‣
Total Nights (nights)
if x == 0:
return "01: 0 night"
elif x > 0 and x <= 2:
return "02: 1 - 2 nights"
elif x > 2 and x <= 4:
return "03: 3 - 4 nights"
elif x > 4 and x <= 5:
return "04: 4 - 5 nights"
elif x > 5 and x <= 8:
return "05: 6 - 8 nights"
elif x > 8 and x <= 14:
return "06: 9 - 14 nights"
elif x > 14 and x <= 21:
return "07: 15 - 21 nights"
else:
return "> 21 nights"‣
Total Visits (visit)
if x == 0:
return "01: 0 visit"
elif x > 0 and x <= 1:
return "02: 1 visit"
elif x > 1 and x <= 2:
return "03: 2 visits"
elif x > 2 and x <= 3:
return "04: 3 visits"
elif x > 3 and x <= 4:
return "05: 4 visits"
elif x > 4 and x <= 5:
return "06: 5 visits"
elif x > 5 and x <= 6:
return "07: 6 visits"
else:
return "> 6 visits"‣
CM Visits (visit)
if x == 0:
return "01: 0 visit"
elif x > 0 and x <= 1:
return "02: 1 visit"
elif x > 1 and x <= 2:
return "03: 2 visits"
elif x > 2 and x <= 3:
return "04: 3 visits"
elif x > 3 and x <= 4:
return "05: 4 visits"
elif x > 4 and x <= 5:
return "06: 5 visits"
elif x > 5 and x <= 6:
return "07: 6 visits"
else:
return "> 6 visits"‣
MYK Visits (visit)
if x == 0:
return "01: 0 visit"
elif x > 0 and x <= 1:
return "02: 1 visit"
elif x > 1 and x <= 2:
return "03: 2 visits"
elif x > 2 and x <= 3:
return "04: 3 visits"
elif x > 3 and x <= 4:
return "05: 4 visits"
elif x > 4 and x <= 5:
return "06: 5 visits"
elif x > 5 and x <= 6:
return "07: 6 visits"
else:
return "> 6 visits"‣
PB Visits (visit)
if x == 0:
return "01: 0 visit"
elif x > 0 and x <= 1:
return "02: 1 visit"
elif x > 1 and x <= 2:
return "03: 2 visits"
elif x > 2 and x <= 3:
return "04: 3 visits"
elif x > 3 and x <= 4:
return "05: 4 visits"
elif x > 4 and x <= 5:
return "06: 5 visits"
elif x > 5 and x <= 6:
return "07: 6 visits"
else:
return "> 6 visits"‣
Shopify Purchases (purchase)
if x == 0:
return "01: 0 purchase"
elif x > 0 and x <= 1:
return "02: 1 purchase"
elif x > 1 and x <= 2:
return "03: 2 purchases"
elif x > 2 and x <= 3:
return "04: 3 purchases"
elif x > 3 and x <= 4:
return "05: 4 purchases"
elif x > 4 and x <= 5:
return "06: 5 purchases"
elif x > 5 and x <= 6:
return "07: 6 purchases"
else:
return "> 6 purchases"‣
Day Counts Last Shopify Visit (days)
if x > 0 and x <= 90:
return "01: 1 - 3 months"
elif x > 91 and x <= 180:
return "02: 4 - 6 months"
elif x > 180 and x <= 365:
return "03: 7 - 12 months"
elif x > 365 and x <= 730:
return "04: 1 - 2 years"
elif x > 730 and x <= 1460:
return "05: 2 - 4 years"
else:
return "> 4 years"‣
Day Counts Last Hotel Visit (days)
if x > 0 and x <= 90:
return "01: 1 - 3 months"
elif x > 91 and x <= 180:
return "02: 4 - 6 months"
elif x > 180 and x <= 365:
return "03: 7 - 12 months"
elif x > 365 and x <= 730:
return "04: 1 - 2 years"
elif x > 730 and x <= 1460:
return "05: 2 - 4 years"
else:
return "> 4 years"‣
Day Counts First Hotel Visit (days)
if x > 0 and x <= 90:
return "01: 1 - 3 months"
elif x > 91 and x <= 180:
return "02: 4 - 6 months"
elif x > 180 and x <= 365:
return "03: 7 - 12 months"
elif x > 365 and x <= 730:
return "04: 1 - 2 years"
elif x > 730 and x <= 1095:
return "05: 2 - 3 years"
elif x > 1095 and x <= 1460:
return "06: 3 - 4 years"
else:
return "> 4 years"‣
Day Counts First Engagement (days)
if x > 0 and x <= 90:
return "01: 1 - 3 months"
elif x > 91 and x <= 180:
return "02: 4 - 6 months"
elif x > 180 and x <= 365:
return "03: 7 - 12 months"
elif x > 365 and x <= 730:
return "04: 1 - 2 years"
elif x > 730 and x <= 1095:
return "05: 2 - 3 years"
elif x > 1095 and x <= 1460:
return "06: 3 - 4 years"
else:
return "> 4 years"‣
Spent (amount)
if x > 0 and x <= 500:
return "01: <= 500"
elif x > 500 and x <= 1000:
return "02: 500 - 1000"
elif x > 1000 and x <= 1500:
return "03: 1000 - 1500"
elif x > 1500 and x <= 2000:
return "04: 1500 - 2000"
elif x > 2000 and x <= 2500:
return "05: 2000 - 2500"
elif x > 2500 and x <= 5000:
return "06: 2500 - 5000"
elif x > 5000 and x <= 10000:
return "07: 5K - 10K"
elif x > 10000 and x <= 15000:
return "08: 10K - 15K"
elif x > 15000 and x <= 20000:
return "09: 15K - 20K"
elif x > 20000 and x <= 25000:
return "10: 20K - 25K"
else:
return "> 25K"‣
Avg Visit Spent (amount)
if x > 0 and x <= 500:
return "01: <= 500"
elif x > 500 and x <= 1000:
return "02: 500 - 1000"
elif x > 1000 and x <= 1500:
return "03: 1000 - 1500"
elif x > 1500 and x <= 2000:
return "04: 1500 - 2000"
elif x > 2000 and x <= 2500:
return "05: 2000 - 2500"
elif x > 2500 and x <= 5000:
return "06: 2500 - 5000"
elif x > 5000 and x <= 10000:
return "07: 5K - 10K"
elif x > 10000 and x <= 15000:
return "08: 10K - 15K"
else:
return "> 15K"‣
Room Spent (amount)
if x == 0:
return "00: No spent"
if x > 0 and x <= 200:
return "01: <= 200"
elif x > 200 and x <= 400:
return "02: 200 - 400"
elif x > 400 and x <= 800:
return "03: 400 - 800"
elif x > 800 and x <= 1200:
return "04: 800 - 1200"
elif x > 1200 and x <= 2400:
return "05: 1200 - 2400"
elif x > 2400 and x <= 3600:
return "06: 2400 - 3600"
elif x > 3600 and x <= 7200:
return "07: 3.6KK - 7.2K"
elif x > 7200 and x <= 14400:
return "08: 7.2K - 14.4K"
else:
return "> 14.4K"‣
Food Spent (amount)
if x == 0:
return "00: No spent"
if x > 0 and x <= 100:
return "01: <= 100"
elif x > 100 and x <= 200:
return "02: 100 - 200"
elif x > 200 and x <= 300:
return "03: 200 - 300"
elif x > 300 and x <= 400:
return "04: 300 - 400"
elif x > 400 and x <= 800:
return "05: 400 - 800"
elif x > 800 and x <= 1600:
return "06: 800 - 1600"
elif x > 1600 and x <= 2400:
return "07: 1.6K - 2.4K"
elif x > 2400 and x <= 5200:
return "08: 2.4K - 5.2K"
else:
return "> 5.2K"‣
Spa Spent (amount)
if x == 0:
return "00: No spent"
if x > 0 and x <= 100:
return "01: <= 100"
elif x > 100 and x <= 200:
return "02: 100 - 200"
elif x > 200 and x <= 300:
return "03: 200 - 300"
elif x > 300 and x <= 400:
return "04: 300 - 400"
elif x > 400 and x <= 800:
return "05: 400 - 800"
elif x > 800 and x <= 1600:
return "06: 800 - 1600"
else:
return "> 1.6K"‣
Gallery Spent (amount)
if x == 0:
return "00: No spent"
if x > 0 and x <= 10:
return "01: <= 10"
elif x > 10 and x <= 15:
return "02: 10 - 15"
elif x > 15 and x <= 20:
return "03: 15 - 20"
elif x > 20 and x <= 40:
return "04: 20 - 40"
elif x > 40 and x <= 80:
return "05: 40 - 80"
elif x > 80 and x <= 160:
return "06: 80 - 160"
elif x > 160 and x <= 240:
return "06: 160 - 240"
elif x > 240 and x <= 480:
return "06: 240 - 480"
else:
return "> 480"‣
Shopify Spent (amount)
if x == 0:
return "00: No spent"
if x > 0 and x <= 10:
return "01: <= 10"
elif x > 10 and x <= 15:
return "02: 10 - 15"
elif x > 15 and x <= 20:
return "03: 15 - 20"
elif x > 20 and x <= 40:
return "04: 20 - 40"
elif x > 40 and x <= 80:
return "05: 40 - 80"
elif x > 80 and x <= 160:
return "06: 80 - 160"
elif x > 160 and x <= 240:
return "06: 160 - 240"
elif x > 80 and x <= 160:
return "06: 80 - 160"
else:
return "> 1.6K"‣
Avg Room Spent (amount)
if x == 0:
return "00: No spent"
if x > 0 and x <= 200:
return "01: <= 200"
elif x > 200 and x <= 400:
return "02: 200 - 400"
elif x > 400 and x <= 800:
return "03: 400 - 800"
elif x > 800 and x <= 1200:
return "04: 800 - 1200"
elif x > 1200 and x <= 2400:
return "05: 1200 - 2400"
elif x > 2400 and x <= 3600:
return "06: 2400 - 3600"
elif x > 3600 and x <= 7200:
return "07: 3.6KK - 7.2K"
elif x > 7200 and x <= 14400:
return "08: 7.2K - 14.4K"
else:
return "> 14.4K"‣
Avg Food Spent (amount)
if x == 0:
return "00: No spent"
if x > 0 and x <= 100:
return "01: <= 100"
elif x > 100 and x <= 200:
return "02: 100 - 200"
elif x > 200 and x <= 300:
return "03: 200 - 300"
elif x > 300 and x <= 400:
return "04: 300 - 400"
elif x > 400 and x <= 800:
return "05: 400 - 800"
elif x > 800 and x <= 1600:
return "06: 800 - 1600"
elif x > 1600 and x <= 2400:
return "07: 1.6K - 2.4K"
elif x > 2400 and x <= 5200:
return "08: 2.4K - 5.2K"
else:
return "> 5.2K"‣
Avg Spa Spent (amount)
if x == 0:
return "00: No spent"
if x > 0 and x <= 100:
return "01: <= 100"
elif x > 100 and x <= 200:
return "02: 100 - 200"
elif x > 200 and x <= 300:
return "03: 200 - 300"
elif x > 300 and x <= 400:
return "04: 300 - 400"
elif x > 400 and x <= 800:
return "05: 400 - 800"
elif x > 800 and x <= 1600:
return "06: 800 - 1600"
else:
return "> 1.6K"‣
Avg Gallery Spent (amount)
if x == 0:
return "00: No spent"
if x > 0 and x <= 10:
return "01: <= 10"
elif x > 10 and x <= 15:
return "02: 10 - 15"
elif x > 15 and x <= 20:
return "03: 15 - 20"
elif x > 20 and x <= 40:
return "04: 20 - 40"
elif x > 40 and x <= 80:
return "05: 40 - 80"
elif x > 80 and x <= 160:
return "06: 80 - 160"
elif x > 160 and x <= 240:
return "06: 160 - 240"
elif x > 240 and x <= 480:
return "06: 240 - 480"
else:
return "> 480"‣
Avg Shopify Spent (amount)
if x == 0:
return "00: No spent"
if x > 0 and x <= 10:
return "01: <= 10"
elif x > 10 and x <= 15:
return "02: 10 - 15"
elif x > 15 and x <= 20:
return "03: 15 - 20"
elif x > 20 and x <= 40:
return "04: 20 - 40"
elif x > 40 and x <= 80:
return "05: 40 - 80"
elif x > 80 and x <= 160:
return "06: 80 - 160"
elif x > 160 and x <= 240:
return "06: 160 - 240"
elif x > 80 and x <= 160:
return "06: 80 - 160"
else:
return "> 1.6K"On this page
- Metrics Bin and Dimension Categorisation
- Age
- Nationality (geo)
- Total Nights (nights)
- Total Visits (visit)
- CM Visits (visit)
- MYK Visits (visit)
- PB Visits (visit)
- Shopify Purchases (purchase)
- Day Counts Last Shopify Visit (days)
- Day Counts Last Hotel Visit (days)
- Day Counts First Hotel Visit (days)
- Day Counts First Engagement (days)
- Spent (amount)
- Avg Visit Spent (amount)
- Room Spent (amount)
- Food Spent (amount)
- Spa Spent (amount)
- Gallery Spent (amount)
- Shopify Spent (amount)
- Avg Room Spent (amount)
- Avg Food Spent (amount)
- Avg Spa Spent (amount)
- Avg Gallery Spent (amount)
- Avg Shopify Spent (amount)