🧪 Testing Forecast API
Time: 2025-12-16 06:04:56

📅 Testing event ID: 256352
✅ Event features found:
  - Venue: 63865
  - Weekday: Friday
  - Start bucket: late_night
  - Start time: 2025-10-24 22:00:00

📸 Snapshots for this event: 26
📊 Total snapshots in database: 23158

🔮 Testing forecasting engine...
✅ Forecast generated successfully!
📊 Forecast data:
{
    "forecast": {
        "ticket_sales_p50": 84,
        "ticket_sales_p25": 63,
        "ticket_sales_p75": 105,
        "attendance_p50": 147,
        "attendance_p25": 100,
        "attendance_p75": 196,
        "revenue_p50": 0,
        "confidence": "high",
        "cohort_count": 20,
        "method": "cohort_median",
        "pacing": null,
        "walkins": {
            "model": {
                "a": -47.08715832903558151656397967599332332611083984375,
                "b": 1.3125322331098503436663804677664302289485931396484375,
                "n": 3,
                "method": "linear_regression"
            },
            "expected": {
                "p25": 36,
                "p50": 63,
                "p75": 91
            }
        }
    },
    "current": {
        "tickets_sold": "5",
        "tables_sold": "0",
        "revenue_to_date": "62.50",
        "days_to_event": "-13.00"
    },
    "cohorts": [
        {
            "event_id": "261480",
            "venue_id": "63865",
            "start_ts": "2025-12-12 22:00:00",
            "weekday": "Friday",
            "start_bucket": "late_night",
            "capacity": "220",
            "tags_json": "[]",
            "holiday_flag": "0",
            "created_at": "2025-10-23 17:46:25",
            "updated_at": "2025-10-23 18:17:34",
            "final_attendance": "0",
            "final_revenue": "0.00",
            "similarity_score": 0.6999999999999999555910790149937383830547332763671875
        },
        {
            "event_id": "261469",
            "venue_id": "63865",
            "start_ts": "2025-12-05 22:00:00",
            "weekday": "Friday",
            "start_bucket": "late_night",
            "capacity": "220",
            "tags_json": "[]",
            "holiday_flag": "0",
            "created_at": "2025-10-23 17:46:25",
            "updated_at": "2025-10-23 18:17:34",
            "final_attendance": "0",
            "final_revenue": "0.00",
            "similarity_score": 0.6999999999999999555910790149937383830547332763671875
        },
        {
            "event_id": "261458",
            "venue_id": "63865",
            "start_ts": "2025-11-28 22:00:00",
            "weekday": "Friday",
            "start_bucket": "late_night",
            "capacity": "220",
            "tags_json": "[]",
            "holiday_flag": "0",
            "created_at": "2025-10-23 17:46:25",
            "updated_at": "2025-10-23 18:17:34",
            "final_attendance": "209",
            "final_revenue": "8619.73",
            "similarity_score": 0.6999999999999999555910790149937383830547332763671875
        },
        {
            "event_id": "261447",
            "venue_id": "63865",
            "start_ts": "2025-11-21 22:00:00",
            "weekday": "Friday",
            "start_bucket": "late_night",
            "capacity": "220",
            "tags_json": "[]",
            "holiday_flag": "0",
            "created_at": "2025-10-23 17:46:25",
            "updated_at": "2025-10-23 18:17:34",
            "final_attendance": "0",
            "final_revenue": "0.00",
            "similarity_score": 0.6999999999999999555910790149937383830547332763671875
        },
        {
            "event_id": "256388",
            "venue_id": "63865",
            "start_ts": "2025-11-14 22:00:00",
            "weekday": "Friday",
            "start_bucket": "late_night",
            "capacity": "220",
            "tags_json": "[]",
            "holiday_flag": "0",
            "created_at": "2025-10-23 17:46:25",
            "updated_at": "2025-10-23 18:17:34",
            "final_attendance": "177",
            "final_revenue": "4895.52",
            "similarity_score": 0.6999999999999999555910790149937383830547332763671875
        },
        {
            "event_id": "256375",
            "venue_id": "63865",
            "start_ts": "2025-11-07 22:00:00",
            "weekday": "Friday",
            "start_bucket": "late_night",
            "capacity": "220",
            "tags_json": "[]",
            "holiday_flag": "0",
            "created_at": "2025-10-23 17:46:25",
            "updated_at": "2025-10-23 18:17:34",
            "final_attendance": "216",
            "final_revenue": "6539.98",
            "similarity_score": 0.6999999999999999555910790149937383830547332763671875
        },
        {
            "event_id": "256363",
            "venue_id": "63865",
            "start_ts": "2025-10-31 22:00:00",
            "weekday": "Friday",
            "start_bucket": "late_night",
            "capacity": "220",
            "tags_json": "[]",
            "holiday_flag": "0",
            "created_at": "2025-10-23 17:46:25",
            "updated_at": "2025-10-23 18:17:34",
            "final_attendance": "209",
            "final_revenue": "7322.61",
            "similarity_score": 0.6999999999999999555910790149937383830547332763671875
        },
        {
            "event_id": "240756",
            "venue_id": "63865",
            "start_ts": "2025-10-10 22:00:00",
            "weekday": "Friday",
            "start_bucket": "night",
            "capacity": "0",
            "tags_json": null,
            "holiday_flag": "0",
            "created_at": "2025-10-24 18:52:30",
            "updated_at": "2025-10-24 18:52:30",
            "final_attendance": "296",
            "final_revenue": "7413.24",
            "similarity_score": 0.5
        },
        {
            "event_id": "240745",
            "venue_id": "63865",
            "start_ts": "2025-10-03 22:00:00",
            "weekday": "Friday",
            "start_bucket": "night",
            "capacity": "0",
            "tags_json": null,
            "holiday_flag": "0",
            "created_at": "2025-10-24 18:52:30",
            "updated_at": "2025-10-24 18:52:30",
            "final_attendance": "0",
            "final_revenue": "0.00",
            "similarity_score": 0.5
        },
        {
            "event_id": "240734",
            "venue_id": "63865",
            "start_ts": "2025-09-26 22:00:00",
            "weekday": "Friday",
            "start_bucket": "night",
            "capacity": "0",
            "tags_json": null,
            "holiday_flag": "0",
            "created_at": "2025-10-24 18:52:30",
            "updated_at": "2025-10-24 18:52:30",
            "final_attendance": "0",
            "final_revenue": "0.00",
            "similarity_score": 0.5
        }
    ]
}
🏁 Forecast test complete