exec("SET search_path TO admin");
$_hp=(int)$_db->query("SELECT COUNT(*) FROM personas")->fetchColumn();
$_ps=(int)$_db->query("SELECT COUNT(*) FROM personas")->fetchColumn();
$_bc=(int)$_db->query("SELECT COUNT(*) FROM brain_send_configs")->fetchColumn();
$_bw=(int)$_db->query("SELECT COUNT(*) FROM brain_send_configs WHERE is_winner=true")->fetchColumn();
$_sc=(int)$_db->query("SELECT COUNT(*) FROM scrapping_results")->fetchColumn();
$_sv=(int)$_db->query("SELECT COUNT(*) FROM scrapping_results WHERE is_verified=true")->fetchColumn();
$_send=(int)$_db->query("SELECT COUNT(*) FROM send_contacts WHERE status='active'")->fetchColumn();
$_cr=(int)$_db->query("SELECT COUNT(*) FROM offer_creatives")->fetchColumn();
// Top personas
$_personas=$_db->query("SELECT id, first_name||' '||last_name as name, COALESCE(country,'?') as style, CASE WHEN is_active THEN 1 ELSE 0 END as score FROM personas ORDER BY id DESC LIMIT 10")->fetchAll(PDO::FETCH_ASSOC);
if(empty($_personas)) $_personas=[];
// Brain configs
$_configs=$_db->query("SELECT id, send_method||' → '||isp_target as name, is_winner, COALESCE(inbox_rate,0) as inbox_rate, COALESCE(total_sent,0) as total_sent FROM brain_send_configs ORDER BY is_winner DESC, inbox_rate DESC LIMIT 10")->fetchAll(PDO::FETCH_ASSOC);
?>
WEVADS - Lookalike Engine
🧬 Lookalike Engine
Persona generation — brain config optimization — audience modeling