PDO::ERRMODE_EXCEPTION,PDO::ATTR_DEFAULT_FETCH_MODE=>PDO::FETCH_ASSOC]); $_db->exec("SET search_path TO admin,public"); $_tc=(int)$_db->query("SELECT COUNT(*) FROM send_contacts")->fetchColumn(); $_ta=(int)$_db->query("SELECT COUNT(*) FROM send_contacts WHERE status='active'")->fetchColumn(); $_by_isp=$_db->query("SELECT isp,COUNT(*) as cnt FROM send_contacts GROUP BY isp ORDER BY cnt DESC LIMIT 15")->fetchAll(); $_by_source=$_db->query("SELECT COALESCE(source,'unknown') as source,COUNT(*) as cnt FROM send_contacts GROUP BY source ORDER BY cnt DESC LIMIT 10")->fetchAll(); $_warmup=(int)$_db->query("SELECT COUNT(*) FROM warmup_accounts WHERE status='warming'")->fetchColumn(); $_seeds=(int)$_db->query("SELECT COUNT(*) FROM seed_accounts")->fetchColumn(); $_bc=(int)$_db->query("SELECT COUNT(*) FROM brain_send_configs WHERE status='active'")->fetchColumn(); $_bw=(int)$_db->query("SELECT COUNT(*) FROM brain_send_configs WHERE is_winner=true")->fetchColumn(); $_creatives=(int)$_db->query("SELECT COUNT(*) FROM offer_creatives WHERE status='active'")->fetchColumn(); $_offers=(int)$_db->query("SELECT COUNT(*) FROM offers WHERE status='active'")->fetchColumn(); $_sent_today=(int)$_db->query("SELECT COUNT(*) FROM unified_send_log WHERE created_at > CURRENT_DATE")->fetchColumn(); $_sent_week=(int)$_db->query("SELECT COUNT(*) FROM unified_send_log WHERE created_at > CURRENT_DATE - INTERVAL '7 days'")->fetchColumn(); $_opens=(int)$_db->query("SELECT COUNT(*) FROM open_log")->fetchColumn(); $_clicks=(int)$_db->query("SELECT COUNT(*) FROM click_log")->fetchColumn(); $_cv_real=(int)$_db->query("SELECT COUNT(*) FROM conversion_log WHERE source='real'")->fetchColumn(); $_rev_real=(float)$_db->query("SELECT COALESCE(SUM(payout),0) FROM conversion_log WHERE source='real'")->fetchColumn(); $_cap=$_warmup*50; ?> WEVADS - CRM Send

📤 CRM Send

Targeted email campaigns — Segmented send, ISP routing, funnel tracking

Total Contacts

Warming Accounts

Daily Capacity

Active Configs

$

Real Revenue

📊 Send Funnel — Live

Sent (7d)

→

Opens

→

Clicks

→

Conversions

→

$

Revenue

Segments

By ISP

By Source

Send Ready

🟢 Active Pool

Ready to receive emails

🌱 Seeds

Inbox placement validators

🎨 Creatives

Active email templates

⚡ Send Engine Status

Component	Value
Warming Accounts
Daily Capacity	emails
Active Configs
Winner Configs
Active Offers
Sent Today

📈 Performance

Metric	Value
Sent (7 days)
Total Opens
Total Clicks
Real Conversions
Real Revenue	$
Conversion Rate	0?number_format($_cv_real/$_clicks*100,2):'0'?>%

ISP Distribution — Contacts

0?round($i['cnt']/$_tc*100,1):0;$clr=$pct>30?'var(--gn)':($pct>10?'var(--cy)':'var(--pu)');?>

ISP	Contacts	Share	Distribution
		%

Contact Sources

Source	Contacts	Share
		0?number_format($s['cnt']/$_tc*100,1):0?>%

Send Pipeline Ready

📧

Contacts

🎨

Creatives

⚡

Configs

Brain productive sends are automated via cron. CRM targeted campaigns coming in Phase 2.