🔍 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: 254039
  Date: 2025-11-01 22:30:00
  Time Bucket: late_night
  Title: TWNTY7 - Let's Get LIT Saturdays
  ❌ No Actuals Data
  📸 Snapshots Data:
    2025-11-01 23:59:59: D0.00, 97 tix, £1732.45
    2025-11-01 23:00:00: D0.00, 22 tix, £604.95
    2025-11-01 22:30:00: D0.00, 0 tix, £100.00

Cohort 2:
  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.04, 87 tix, £1344.51
    2025-10-10 22:30:00: D1.00, 25 tix, £449.75
    2025-10-09 22:30:00: D2.00, 18 tix, £324.82

Cohort 3:
  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.04, 76 tix, £1724.24
    2025-10-03 22:30:00: D1.00, 32 tix, £839.68
    2025-10-02 22:30:00: D2.00, 16 tix, £604.84

Cohort 4:
  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.04, 105 tix, £2638.95
    2025-09-26 23:00:00: D1.00, 34 tix, £1044.66
    2025-09-26 22:30:00: D1.00, 34 tix, £1044.66

Cohort 5:
  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.04, 141 tix, £2568.59
    2025-09-19 23:00:00: D1.00, 52 tix, £1009.48
    2025-09-19 22:30:00: D1.00, 51 tix, £989.49

Cohort 6:
  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.04, 88 tix, £1709.14
    2025-09-12 23:00:00: D1.00, 32 tix, £644.68
    2025-09-12 22:30:00: D1.00, 32 tix, £644.68

Cohort 7:
  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.04, 127 tix, £2618.73
    2025-09-05 23:00:00: D1.00, 40 tix, £924.60
    2025-09-05 22:30:00: D1.00, 38 tix, £894.62

Cohort 8:
  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-08-31 23:59:59: D-1.04, 118 tix, £2623.82
    2025-08-29 23:00:00: D1.00, 45 tix, £1269.55
    2025-08-29 22:30:00: D1.00, 41 tix, £1209.59

Cohort 9:
  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-22 23:00:00: D1.00, 51 tix, £1539.50
    2025-08-22 22:30:00: D1.00, 51 tix, £1539.50
    2025-08-21 23:00:00: D2.00, 30 tix, £709.70

Cohort 10:
  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-15 23:00:00: D1.00, 39 tix, £979.61
    2025-08-15 22:30:00: D1.00, 38 tix, £969.62
    2025-08-14 23:00:00: D2.00, 26 tix, £779.74

Cohort 11:
  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-08 23:00:00: D1.00, 72 tix, £1509.28
    2025-08-08 22:30:00: D1.00, 67 tix, £1444.33
    2025-08-07 23:00:00: D2.00, 44 tix, £1024.56

Cohort 12:
  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-01 23:00:00: D1.00, 55 tix, £1454.45
    2025-08-01 22:30:00: D1.00, 54 tix, £1434.46
    2025-07-31 23:00:00: D2.00, 46 tix, £1334.54

Cohort 13:
  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-25 23:00:00: D1.00, 26 tix, £969.74
    2025-07-25 22:30:00: D1.00, 26 tix, £969.74
    2025-07-24 23:00:00: D2.00, 19 tix, £894.81

Cohort 14:
  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-18 23:00:00: D1.00, 58 tix, £1104.42
    2025-07-18 22:30:00: D1.00, 58 tix, £1104.42
    2025-07-17 23:00:00: D2.00, 44 tix, £844.56

Cohort 15:
  Event ID: 215315
  Date: 2025-07-19 01:04:00
  Time Bucket: night
  Title: TWNTY7 - 29 NIGHTS
  ❌ No Actuals Data
  📸 Snapshots Data:
    2025-07-18 01:04:00: D1.00, 66 tix, £805.00
    2025-07-17 01:04:00: D2.00, 41 tix, £550.00
    2025-07-16 01:04:00: D3.00, 28 tix, £447.50

Cohort 16:
  Event ID: 215230
  Date: 2025-07-12 22:30:00
  Time Bucket: night
  Title: TWNTY7 -  Wireless Afterparty Edition - Grown & Sexy Saturdays
  ❌ No Actuals Data
  📸 Snapshots Data:
    2025-07-11 23:00:00: D1.00, 67 tix, £1574.33
    2025-07-11 22:30:00: D1.00, 67 tix, £1574.33
    2025-07-10 23:00:00: D2.00, 59 tix, £1354.41

Cohort 17:
  Event ID: 196165
  Date: 2025-07-05 22:30:00
  Time Bucket: night
  Title: TWNTY7 - Grown & Sexy Saturdays
  ❌ No Actuals Data
  📸 Snapshots Data:
    2025-07-04 23:00:00: D1.00, 72 tix, £2209.28
    2025-07-04 22:30:00: D1.00, 70 tix, £2169.30
    2025-07-03 23:00:00: D2.00, 49 tix, £1719.51

Cohort 18:
  Event ID: 196152
  Date: 2025-06-28 22:30:00
  Time Bucket: night
  Title: TWNTY7 - Grown & Sexy Saturdays
  ❌ No Actuals Data
  📸 Snapshots Data:
    2025-06-27 23:00:00: D1.00, 79 tix, £1824.22
    2025-06-27 22:30:00: D1.00, 79 tix, £1824.22
    2025-06-26 23:00:00: D2.00, 45 tix, £1199.56

Cohort 19:
  Event ID: 196139
  Date: 2025-06-21 22:30:00
  Time Bucket: night
  Title: TWNTY7 - Grown & Sexy Saturdays
  ❌ No Actuals Data
  📸 Snapshots Data:
    2025-06-20 23:00:00: D1.00, 25 tix, £609.75
    2025-06-20 22:30:00: D1.00, 25 tix, £609.75
    2025-06-19 23:00:00: D2.00, 19 tix, £529.81

Cohort 20:
  Event ID: 196126
  Date: 2025-06-14 22:30:00
  Time Bucket: night
  Title: TWNTY7 - Grown & Sexy Saturdays
  ❌ No Actuals Data
  📸 Snapshots Data:
    2025-06-13 23:00:00: D1.00, 50 tix, £1609.50
    2025-06-13 22:30:00: D1.00, 47 tix, £1564.53
    2025-06-12 23:00:00: D2.00, 28 tix, £1264.72

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

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

Walk-in Analysis Data:
  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 - 141 tickets = 80 walk-ins
  Event 226751: 196 attendance - 88 tickets = 108 walk-ins
  Event 226735: 220 attendance - 127 tickets = 93 walk-ins
  Event 220827: 234 attendance - 118 tickets = 116 walk-ins
  Event 220814: 202 attendance - 51 tickets = 151 walk-ins

Average walk-ins: 117.6

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