🔍 COMPREHENSIVE FORECAST ANALYSIS FOR EVENT 240721 Date: 2025-12-16 18:22:09 ================================================================================ 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: -51 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: 30 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: 8 Events with fallback snapshots: 0 Event 263800: TWNTY7 - Let's Get LIT Saturdays Date: 2025-12-20 22:30:00 Final tickets: No data (Source: D+1) Event 263787: TWNTY7 - Let's Get LIT Saturdays Date: 2025-12-13 22:30:00 Final tickets: No data (Source: D+1) Event 263774: TWNTY7 - Let's Get LIT Saturdays Date: 2025-12-06 22:30:00 Final tickets: No data (Source: D+1) Event 263761: TWNTY7 - Let's Get LIT Saturdays Date: 2025-11-29 22:30:00 Final tickets: No data (Source: D+1) Event 254078: TWNTY7 - Let's Get LIT Saturdays Date: 2025-11-22 22:30:00 Final tickets: No data (Source: D+1) Event 254065: TWNTY7 - Let's Get LIT Saturdays Date: 2025-11-15 22:30:00 Final tickets: No data (Source: D+1) Event 254052: TWNTY7 - Let's Get LIT Saturdays Date: 2025-11-08 22:30:00 Final tickets: No data (Source: D+1) Event 254039: TWNTY7 - Let's Get LIT Saturdays Date: 2025-11-01 22:30:00 Final tickets: No data (Source: D+1) Cohort Final Sales Percentiles: P25: 24 tickets P50: 120 tickets P75: 139 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 24 snapshots ❌ No pacing ratios calculated (insufficient data) 7️⃣ ACTUAL FORECASTING ENGINE TEST ---------------------------------------- ✅ Forecast Generated Successfully! Ticket Sales Forecast: P25: 128 tickets P50: 128 tickets P75: 128 tickets Attendance Forecast: P25: 227 attendees P50: 227 attendees P75: 227 attendees Revenue Forecast: P50: £5519.225 Forecast Metadata: Confidence: high Method: pacing_based Cohort Count: 20 Current Data Used: Tickets sold: 128 Tables sold: 5 Revenue: £2463.72 Days to event: -1.00 ================================================================================ ✅ COMPREHENSIVE ANALYSIS COMPLETE