🔍 DETAILED COHORT ANALYSIS FOR FORECASTING
Event ID: 240721
================================================================================

1️⃣ CURRENT EVENT DETAILS
--------------------------------------------------
Event: TWNTY7 - Grown & Sexy Saturdays
Date: 2025-10-25 23:00:00
Venue: TWNTY7 Nightclub

2️⃣ EVENT FEATURES
--------------------------------------------------
Venue ID: 63865
Weekday: Saturday
Time Bucket: late_night
Holiday Flag: 0

3️⃣ COHORT MATCHING CRITERIA
--------------------------------------------------
Matching events with:
  • Same venue: 63865
  • Same weekday: Saturday
  • Same time bucket: late_night
  • Same holiday flag: 0
  • Past events only: start_ts < NOW()
  • Excluding current event: 240721

4️⃣ COHORT EVENTS FOUND
--------------------------------------------------
Total cohorts: 20

Cohort 1:
  Event ID: 263787
  Date: 2025-12-13 22:30:00
  Time Bucket: late_night
  Title: TWNTY7 - Let's Get LIT Saturdays
  ❌ No Actuals Data
  📸 Snapshots Data:
    2025-12-14 23:59:59: D-1.00, 127 tix, £1782.49
    2025-12-14 23:00:00: D-1.00, 3 tix, £24.99
    2025-12-13 23:59:59: D0.00, 104 tix, £1427.49

Cohort 2:
  Event ID: 263774
  Date: 2025-12-06 22:30:00
  Time Bucket: late_night
  Title: TWNTY7 - Let's Get LIT Saturdays
  ✅ Actuals Data:
    Final Attendance: 170
    Final Revenue: £3348.16
    Entered At: 2025-12-08 15:39:24
  📸 Snapshots Data:
    2025-12-07 23:59:59: D-1.00, 158 tix, £2185.00
    2025-12-06 23:59:59: D0.00, 146 tix, £2005.00
    2025-12-06 03:47:42: D0.79, 53 tix, £772.50

Cohort 3:
  Event ID: 263761
  Date: 2025-11-29 22:30:00
  Time Bucket: late_night
  Title: TWNTY7 - Let's Get LIT Saturdays
  ✅ Actuals Data:
    Final Attendance: 177
    Final Revenue: £5885.73
    Entered At: 2025-12-08 16:19:13
  📸 Snapshots Data:
    2025-11-30 23:59:59: D-1.00, 114 tix, £1627.50
    2025-11-30 23:00:00: D-1.00, 3 tix, £19.99
    2025-11-29 23:59:59: D0.00, 111 tix, £1582.50

Cohort 4:
  Event ID: 254078
  Date: 2025-11-22 22:30:00
  Time Bucket: late_night
  Title: TWNTY7 - Let's Get LIT Saturdays
  ✅ Actuals Data:
    Final Attendance: 219
    Final Revenue: £9048.97
    Entered At: 2025-11-24 14:22:15
  📸 Snapshots Data:
    2025-11-23 23:59:59: D-1.00, 139 tix, £2317.48
    2025-11-23 23:00:00: D-1.00, 4 tix, £124.98
    2025-11-22 23:59:59: D0.00, 139 tix, £2317.48

Cohort 5:
  Event ID: 254065
  Date: 2025-11-15 22:30:00
  Time Bucket: late_night
  Title: TWNTY7 - Let's Get LIT Saturdays
  ✅ Actuals Data:
    Final Attendance: 231
    Final Revenue: £6219.53
    Entered At: 2025-11-18 17:08:29
  📸 Snapshots Data:
    2025-11-16 23:59:59: D-1.00, 120 tix, £1832.46
    2025-11-16 23:00:00: D-1.00, 25 tix, £807.46
    2025-11-15 23:59:59: D0.00, 120 tix, £1832.46

Cohort 6:
  Event ID: 254052
  Date: 2025-11-08 22:30:00
  Time Bucket: late_night
  Title: TWNTY7 - Let's Get LIT Saturdays
  ✅ Actuals Data:
    Final Attendance: 221
    Final Revenue: £6141.85
    Entered At: 2025-11-10 11:47:13
  📸 Snapshots Data:
    2025-11-09 23:59:59: D-1.00, 24 tix, £305.00
    2025-11-09 23:00:00: D-1.00, 160 tix, £2072.44
    2025-11-08 23:59:59: D0.00, 104 tix, £1285.00

Cohort 7:
  Event ID: 254039
  Date: 2025-11-01 22:30:00
  Time Bucket: late_night
  Title: TWNTY7 - Let's Get LIT Saturdays
  ✅ Actuals Data:
    Final Attendance: 212
    Final Revenue: £5152.72
    Entered At: 2025-11-06 01:46:53
  📸 Snapshots Data:
    2025-11-02 23:59:59: D-1.00, 11 tix, £252.50
    2025-11-02 23:00:00: D-1.00, 109 tix, £1997.43
    2025-11-01 23:59:59: D0.00, 68 tix, £900.00

Cohort 8:
  Event ID: 240695
  Date: 2025-10-11 22:30:00
  Time Bucket: night
  Title: TWNTY7 - Grown & Sexy Saturdays
  ✅ Actuals Data:
    Final Attendance: 191
    Final Revenue: £3163.14
    Entered At: 2025-10-28 00:21:33
  📸 Snapshots Data:
    2025-10-12 23:59:59: D-1.00, 87 tix, £1344.51
    2025-10-12 23:00:00: D-1.00, 89 tix, £1364.49
    2025-10-11 23:59:59: D0.00, 61 tix, £874.77

Cohort 9:
  Event ID: 240682
  Date: 2025-10-04 22:30:00
  Time Bucket: night
  Title: TWNTY7 - Grown & Sexy Saturdays Independence Edition
  ✅ Actuals Data:
    Final Attendance: 164
    Final Revenue: £4349.00
    Entered At: 2025-10-28 00:24:01
  📸 Snapshots Data:
    2025-10-05 23:59:59: D-1.00, 76 tix, £1724.24
    2025-10-05 23:00:00: D-1.00, 85 tix, £1794.20
    2025-10-04 23:59:59: D0.00, 46 tix, £904.55

Cohort 10:
  Event ID: 226777
  Date: 2025-09-27 22:30:00
  Time Bucket: night
  Title: TWNTY7 - Grown & Sexy Saturdays
  ✅ Actuals Data:
    Final Attendance: 306
    Final Revenue: £10762.00
    Entered At: 2025-10-28 00:25:34
  📸 Snapshots Data:
    2025-09-28 23:59:59: D-1.00, 105 tix, £2638.95
    2025-09-28 23:00:00: D-1.00, 119 tix, £2868.93
    2025-09-27 23:59:59: D0.00, 76 tix, £1694.29

Cohort 11:
  Event ID: 226764
  Date: 2025-09-20 22:30:00
  Time Bucket: night
  Title: TWNTY7 - Grown & Sexy Saturdays
  ✅ Actuals Data:
    Final Attendance: 221
    Final Revenue: £11501.00
    Entered At: 2025-10-28 00:26:36
  📸 Snapshots Data:
    2025-09-21 23:59:59: D-1.00, 0 tix, £0.00
    2025-09-21 23:00:00: D-1.00, 165 tix, £3023.40
    2025-09-20 23:59:59: D0.00, 106 tix, £1853.96

Cohort 12:
  Event ID: 226751
  Date: 2025-09-13 22:30:00
  Time Bucket: night
  Title: TWNTY7 - Grown & Sexy Saturdays
  ✅ Actuals Data:
    Final Attendance: 196
    Final Revenue: £6858.00
    Entered At: 2025-10-28 00:28:16
  📸 Snapshots Data:
    2025-09-14 23:59:59: D-1.00, 3 tix, £130.00
    2025-09-14 23:00:00: D-1.00, 103 tix, £1904.03
    2025-09-13 23:59:59: D0.00, 59 tix, £989.42

Cohort 13:
  Event ID: 226735
  Date: 2025-09-06 22:30:00
  Time Bucket: night
  Title: TWNTY7 - Grown & Sexy Saturdays
  ✅ Actuals Data:
    Final Attendance: 220
    Final Revenue: £10265.00
    Entered At: 2025-10-28 00:29:37
  📸 Snapshots Data:
    2025-09-07 23:59:59: D-1.00, 3 tix, £59.97
    2025-09-07 23:00:00: D-1.00, 143 tix, £2748.63
    2025-09-06 23:59:59: D0.00, 89 tix, £1679.13

Cohort 14:
  Event ID: 220827
  Date: 2025-08-30 22:30:00
  Time Bucket: night
  Title: TWNTY7 - Grown & Sexy Saturdays
  ✅ Actuals Data:
    Final Attendance: 234
    Final Revenue: £8763.00
    Entered At: 2025-10-28 00:30:55
  📸 Snapshots Data:
    2025-09-03 23:59:59: D-4.00, 0 tix, £0.00
    2025-08-31 23:59:59: D-1.00, 0 tix, £0.00
    2025-08-31 23:00:00: D-1.00, 136 tix, £2818.74

Cohort 15:
  Event ID: 220814
  Date: 2025-08-23 22:30:00
  Time Bucket: night
  Title: TWNTY7 - Grown & Sexy Saturdays
  ✅ Actuals Data:
    Final Attendance: 202
    Final Revenue: £7898.00
    Entered At: 2025-10-28 00:32:45
  📸 Snapshots Data:
    2025-08-24 23:00:00: D-1.00, 144 tix, £3663.73
    2025-08-23 23:59:59: D0.00, 75 tix, £1549.29
    2025-08-22 23:59:59: D0.96, 30 tix, £974.76

Cohort 16:
  Event ID: 220801
  Date: 2025-08-16 22:30:00
  Time Bucket: night
  Title: TWNTY7 - Grown & Sexy Saturdays
  ❌ No Actuals Data
  📸 Snapshots Data:
    2025-08-17 23:59:59: D-1.00, 2 tix, £40.00
    2025-08-17 23:00:00: D-1.00, 112 tix, £2578.99
    2025-08-16 23:59:59: D0.00, 63 tix, £1509.42

Cohort 17:
  Event ID: 220788
  Date: 2025-08-09 22:30:00
  Time Bucket: night
  Title: TWNTY7 - Grown & Sexy Saturdays
  ❌ No Actuals Data
  📸 Snapshots Data:
    2025-08-10 23:00:00: D-1.00, 146 tix, £2943.67
    2025-08-09 23:59:59: D0.00, 63 tix, £1314.45
    2025-08-08 23:59:59: D0.96, 33 tix, £584.68

Cohort 18:
  Event ID: 215269
  Date: 2025-08-02 22:30:00
  Time Bucket: night
  Title: TWNTY7 - Grown & Sexy Saturdays
  ❌ No Actuals Data
  📸 Snapshots Data:
    2025-08-03 23:00:00: D-1.00, 164 tix, £3733.50
    2025-08-02 23:59:59: D0.00, 95 tix, £2084.11
    2025-08-01 23:59:59: D0.96, 11 tix, £159.89

Cohort 19:
  Event ID: 215256
  Date: 2025-07-26 22:30:00
  Time Bucket: night
  Title: TWNTY7 - Grown & Sexy Saturdays
  ❌ No Actuals Data
  📸 Snapshots Data:
    2025-07-27 23:00:00: D-1.00, 122 tix, £2673.87
    2025-07-26 23:59:59: D0.00, 90 tix, £1704.13
    2025-07-25 23:59:59: D0.96, 7 tix, £74.93

Cohort 20:
  Event ID: 215243
  Date: 2025-07-19 22:30:00
  Time Bucket: night
  Title: TWNTY7 - Grown & Sexy Saturdays
  ❌ No Actuals Data
  📸 Snapshots Data:
    2025-07-20 23:00:00: D-1.00, 92 tix, £1579.12
    2025-07-19 23:59:59: D0.00, 25 tix, £414.75
    2025-07-18 23:59:59: D0.96, 15 tix, £259.86

5️⃣ DATA COMPLETENESS ANALYSIS
--------------------------------------------------
Total Cohort Events: 20
Events with Actuals: 14
Events with Snapshots: 20
Events with Both: 14
Data Completeness: 70%

6️⃣ WALK-IN ANALYSIS POTENTIAL
--------------------------------------------------
Events suitable for walk-in analysis: 14

Walk-in Analysis Data:
  Event 263774: 170 attendance - 158 tickets = 12 walk-ins
  Event 263761: 177 attendance - 114 tickets = 63 walk-ins
  Event 254078: 219 attendance - 139 tickets = 80 walk-ins
  Event 254065: 231 attendance - 120 tickets = 111 walk-ins
  Event 254052: 221 attendance - 24 tickets = 197 walk-ins
  Event 254039: 212 attendance - 11 tickets = 201 walk-ins
  Event 240695: 191 attendance - 87 tickets = 104 walk-ins
  Event 240682: 164 attendance - 76 tickets = 88 walk-ins
  Event 226777: 306 attendance - 105 tickets = 201 walk-ins
  Event 226764: 221 attendance - 0 tickets = 221 walk-ins
  Event 226751: 196 attendance - 3 tickets = 193 walk-ins
  Event 226735: 220 attendance - 3 tickets = 217 walk-ins
  Event 220827: 234 attendance - 0 tickets = 234 walk-ins
  Event 220814: 202 attendance - 144 tickets = 58 walk-ins

Average walk-ins: 141.4

================================================================================
✅ DETAILED COHORT ANALYSIS COMPLETE