🔍 COMPREHENSIVE FORECAST ANALYSIS FOR EVENT 240721 Date: 2025-11-05 03:48:46 ================================================================================ 1️⃣ EVENT BASIC INFORMATION ---------------------------------------- Event Title: TWNTY7 - Grown & Sexy Saturdays Event ID: 240721 Post Status: publish Event Start: 2025-10-25 23:00:00 Event End: 2025-10-26 04:00:00 Venue ID: 63865 Days to Event: -10 Venue Name: TWNTY7 Nightclub 2️⃣ EVENT FEATURES ---------------------------------------- ✅ Event features found: Venue ID: 63865 Weekday: Saturday Time Bucket: late_night Start Time: Created: 2025-10-23 17:46:25 3️⃣ CURRENT SALES DATA ---------------------------------------- Live Sales Analysis: Total sales records: 99 Table: £100 x1 = £100 → 1 tables = 6 entries Paid ticket: £15 x1 = £19.99 Table: £100 x1 = £100 → 1 tables = 6 entries Paid ticket: £15 x1 = £19.99 Paid ticket: £5 x1 = £9.99 Table: £100 x1 = £100 → 1 tables = 6 entries Paid ticket: £5 x2 = £19.98 Paid ticket: £7.5 x1 = £9.99 Paid ticket: £17.5 x1 = £19.99 Paid ticket: £5 x5 = £49.95 Paid ticket: £7.5 x5 = £49.95 Table: £100 x1 = £100 → 1 tables = 6 entries Paid ticket: £10 x1 = £14.99 Paid ticket: £12.5 x1 = £14.99 Paid ticket: £5 x10 = £99.9 Table: £100 x1 = £100 → 1 tables = 6 entries Paid ticket: £5 x1 = £9.99 Paid ticket: £5 x1 = £9.99 Paid ticket: £7.5 x1 = £9.99 Paid ticket: £12.5 x2 = £29.98 Paid ticket: £7.5 x1 = £9.99 Paid ticket: £7.5 x1 = £9.99 Paid ticket: £17.5 x2 = £39.98 Paid ticket: £17.5 x1 = £19.99 Paid ticket: £7.5 x1 = £9.99 Paid ticket: £10 x1 = £14.99 Paid ticket: £10 x1 = £14.99 Paid ticket: £10 x1 = £14.99 Paid ticket: £10 x1 = £14.99 Paid ticket: £10 x1 = £14.99 Paid ticket: £10 x1 = £14.99 Paid ticket: £5 x1 = £9.99 Paid ticket: £5 x1 = £9.99 Paid ticket: £10 x1 = £14.99 Paid ticket: £10 x1 = £14.99 Paid ticket: £5 x2 = £19.98 Paid ticket: £12.5 x1 = £14.99 Paid ticket: £5 x1 = £9.99 Paid ticket: £12.5 x5 = £74.95 Paid ticket: £10 x1 = £14.99 Paid ticket: £10 x1 = £14.99 Paid ticket: £10 x1 = £14.99 Paid ticket: £10 x2 = £29.98 Paid ticket: £5 x1 = £9.99 Paid ticket: £15 x1 = £19.99 Paid ticket: £10 x1 = £14.99 Paid ticket: £12.5 x1 = £14.99 Paid ticket: £5 x1 = £9.99 Paid ticket: £15 x1 = £19.99 Paid ticket: £17.5 x1 = £19.99 Paid ticket: £17.5 x1 = £19.99 Paid ticket: £10 x1 = £14.99 Paid ticket: £5 x1 = £9.99 Paid ticket: £15 x1 = £19.99 Paid ticket: £15 x2 = £39.98 Paid ticket: £15 x2 = £39.98 Paid ticket: £10 x1 = £14.99 Paid ticket: £15 x1 = £19.99 Paid ticket: £15 x1 = £19.99 Paid ticket: £15 x1 = £19.99 Paid ticket: £5 x1 = £9.99 Paid ticket: £10 x1 = £14.99 Paid ticket: £15 x1 = £19.99 Paid ticket: £17.5 x1 = £19.99 Paid ticket: £17.5 x1 = £19.99 Paid ticket: £15 x1 = £19.99 Paid ticket: £17.5 x1 = £19.99 Paid ticket: £17.5 x1 = £19.99 Paid ticket: £15 x1 = £19.99 Paid ticket: £17.5 x1 = £19.99 Paid ticket: £15 x1 = £19.99 Paid ticket: £15 x1 = £19.99 Paid ticket: £15 x1 = £19.99 Paid ticket: £5 x1 = £9.99 Paid ticket: £10 x2 = £29.98 Paid ticket: £17.5 x1 = £19.99 Paid ticket: £10 x1 = £14.99 Paid ticket: £17.5 x1 = £19.99 Paid ticket: £15 x1 = £19.99 Paid ticket: £15 x1 = £19.99 Paid ticket: £15 x1 = £19.99 Paid ticket: £17.5 x1 = £19.99 Paid ticket: £17.5 x1 = £19.99 Paid ticket: £10 x1 = £14.99 Paid ticket: £15 x1 = £19.99 Paid ticket: £10 x1 = £14.99 Paid ticket: £10 x1 = £14.99 Paid ticket: £10 x1 = £14.99 Paid ticket: £10 x1 = £14.99 Paid ticket: £15 x1 = £19.99 Paid ticket: £15 x2 = £39.98 Paid ticket: £17.5 x3 = £59.97 Paid ticket: £17.5 x2 = £39.98 Paid ticket: £17.5 x1 = £19.99 Paid ticket: £10 x2 = £29.98 Paid ticket: £10 x1 = £14.99 Paid ticket: £17.5 x1 = £19.99 Paid ticket: £15 x1 = £19.99 Paid ticket: £15 x1 = £19.99 Summary: Total tickets sold: 133 Paid tickets: 128 Free tickets: 0 Tables sold: 5 Table entries: 30 Total revenue: £2463.72 Paid tickets + table entries: 158 4️⃣ SNAPSHOTS DATA ---------------------------------------- Snapshots found: 17 Latest snapshot: 2025-10-26 23:59:59 (D-1.00) Latest tickets: 128 Latest tables: 5 Latest revenue: £2463.72 D+1 Snapshot (Final Sales): Date: 2025-10-26 23:59:59 Days: D-1.00 Final tickets: 128 Final tables: 5 Final revenue: £2463.72 5️⃣ COHORT ANALYSIS ---------------------------------------- Cohort Criteria: - Venue ID: 63865 - Weekday: Saturday - Time Bucket: late_night - Excluding current event: 240721 Cohort Events Found: 8 Cohort Final Sales Data: Events with D+1 snapshots: 0 Events with fallback snapshots: 8 Event 263800: TWNTY7 - Let's Get LIT Saturdays Date: 2025-12-20 22:30:00 Final tickets: No data (Source: Latest) Event 263787: TWNTY7 - Let's Get LIT Saturdays Date: 2025-12-13 22:30:00 Final tickets: No data (Source: Latest) Event 263774: TWNTY7 - Let's Get LIT Saturdays Date: 2025-12-06 22:30:00 Final tickets: No data (Source: Latest) Event 263761: TWNTY7 - Let's Get LIT Saturdays Date: 2025-11-29 22:30:00 Final tickets: No data (Source: Latest) Event 254078: TWNTY7 - Let's Get LIT Saturdays Date: 2025-11-22 22:30:00 Final tickets: No data (Source: Latest) Event 254065: TWNTY7 - Let's Get LIT Saturdays Date: 2025-11-15 22:30:00 Final tickets: No data (Source: Latest) Event 254052: TWNTY7 - Let's Get LIT Saturdays Date: 2025-11-08 22:30:00 Final tickets: No data (Source: Latest) Event 254039: TWNTY7 - Let's Get LIT Saturdays Date: 2025-11-01 22:30:00 Final tickets: No data (Source: Latest) Cohort Final Sales Percentiles: P25: 4 tickets P50: 6 tickets P75: 97 tickets 6️⃣ PACING ANALYSIS ---------------------------------------- Current Snapshot: Date: 2025-10-26 23:59:59 Days to event: D-1.00 Tickets sold: 128 Cohort Snapshots at Similar Days (D-1.00 ±1): Found 6 snapshots ❌ No pacing ratios calculated (insufficient data) 7️⃣ ACTUAL FORECASTING ENGINE TEST ---------------------------------------- ✅ Forecast Generated Successfully! Ticket Sales Forecast: P25: 54 tickets P50: 72 tickets P75: 90 tickets Attendance Forecast: P25: 74 attendees P50: 148 attendees P75: 110 attendees Revenue Forecast: P50: £0 Forecast Metadata: Confidence: high Method: cohort_median Cohort Count: 20 Current Data Used: Tickets sold: 133 Tables sold: 5 Revenue: £2463.72 Days to event: -10 ================================================================================ ✅ COMPREHENSIVE ANALYSIS COMPLETE