=== TRIAL ANALYTICS DEBUG ===

1. Raw trials table data:
Found 3 trials:
  - ID: trial_689d748d099d4_fd806516, Status: expired, Platform: android
    Start: 2025-08-14 05:30:53, End: 2025-08-21 05:30:53
  - ID: trial_68a18985ab7d0_52e95c6f, Status: expired, Platform: android
    Start: 2025-08-17 07:49:25, End: 2025-08-24 07:49:25
  - ID: trial_68bdbaf16dddd_8cd5f3a4, Status: active, Platform: android
    Start: 2025-09-07 17:03:45, End: 2025-09-14 17:03:45

2. Status breakdown query:
  - Status 'active': 1 trials
  - Status 'expired': 2 trials

3. Analytics calculation:
Analytics result:
{
    "total_trials": 3,
    "active_trials": 1,
    "expired_trials": 2,
    "converted_trials": 0,
    "conversion_rate": 0
}

4. Daily stats query:
Daily stats: [
    {
        "date": "2025-09-07",
        "trials_started": 1
    }
]

5. Active trials query:
Active trials: [
    {
        "trial_id": "trial_68bdbaf16dddd_8cd5f3a4",
        "status": "active",
        "platform": "android",
        "trial_start": "2025-09-07 17:03:45",
        "trial_end": "2025-09-14 17:03:45",
        "days_remaining": 3,
        "days_since_start": 4
    }
]

6. Full analytics response structure:
{
    "success": true,
    "data": {
        "overview": {
            "total_trials": 3,
            "active_trials": 1,
            "expired_trials": 2,
            "converted_trials": 0,
            "conversion_rate": 0
        },
        "summary": {
            "total_trials": 3,
            "active_trials": 1,
            "expired_trials": 2,
            "converted_trials": 0,
            "conversion_rate": 0
        },
        "daily_stats": [
            {
                "date": "2025-09-07",
                "trials_started": 1
            }
        ],
        "platform_breakdown": [
            {
                "platform": "android",
                "trials": 1
            }
        ],
        "active_trials": [
            {
                "trial_id": "trial_68bdbaf16dddd_8cd5f3a4",
                "status": "active",
                "platform": "android",
                "trial_start": "2025-09-07 17:03:45",
                "trial_end": "2025-09-14 17:03:45",
                "days_remaining": 3,
                "days_since_start": 4
            }
        ],
        "recent_conversions": [],
        "expiring_soon": [],
        "event_analytics": []
    }
}