=== 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: expired, Platform: android
    Start: 2025-09-07 17:03:45, End: 2025-09-14 17:03:45

2. Status breakdown query:
  - Status 'expired': 3 trials

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

4. Daily stats query:
Daily stats: []

5. Active trials query:
Active trials: []

6. Full analytics response structure:
{
    "success": true,
    "data": {
        "overview": {
            "total_trials": 3,
            "active_trials": 0,
            "expired_trials": 3,
            "converted_trials": 0,
            "conversion_rate": 0
        },
        "summary": {
            "total_trials": 3,
            "active_trials": 0,
            "expired_trials": 3,
            "converted_trials": 0,
            "conversion_rate": 0
        },
        "daily_stats": [],
        "platform_breakdown": [
            {
                "platform": "android",
                "trials": 1
            }
        ],
        "active_trials": [],
        "recent_conversions": [],
        "expiring_soon": [],
        "event_analytics": []
    }
}