Overview / نظرة عامة Sprints / السبرينتات Stack / التقنية Content / المحتوى Dashboard / لوحة التحكم

Analytics Dashboard

Real-time visibility into the enrollment engine. Traffic, funnels, KPIs, alerts - all in one mission control.

System Online - All dashboards operational

📊 Plausible - Traffic

12.5K
Visitors (7d)
28.3K
Pageviews
42%
Bounce Rate
2:34
Avg Duration
Mon
Tue
Wed
Thu
Fri
Sat
Sun

Top Sources

Google Ads35%
Meta (FB+IG)28%
Organic Search18%
LinkedIn12%
Direct / WhatsApp7%

Device Breakdown

Mobile68%
Desktop27%
Tablet5%

UTM Campaigns

cohort1_central_awareness4.2K
cohort1_eastern_consideration3.1K

🔍 PostHog - Funnel

Landing Page View
100%
Scroll to CTA Section
60%
Click CTA - Book/WhatsApp
15%
Complete Booking / Chat
8%
Attend Consultation
5%
Submit Application
2%
Pay Enrollment Deposit
1%
250
Consultations
50
Applications
10
Enrollments

📈 Metabase - CRM KPIs

18%
MQL Rate
12%
SQL Rate
4%
Enrollment Rate

Regional Performance

Central
Eastern
Western
Northwest
South

SQL Queries

-- Lead Volume (30 days)
SELECT DATE(created_at), region, channel, COUNT(*) FROM leads GROUP BY DATE(created_at), region, channel;
-- Conversion Rates
SELECT status, COUNT(*), AVG(engagement_score) FROM leads GROUP BY status;

💰 Financial KPIs

Customer Acquisition Cost
SAR 4,800
Target: below SAR 10,000
Lifetime Value (LTV)
SAR 70,740
GW tuition + JIC onboarding
LTV:CAC Ratio
14.7:1
Excellent (above 3:1)
Monthly Ad Spend
SAR 48,000
~$12,800 USD

Source Attribution

SourceLeadsEnrollmentsConv. Rate
Google Ads4,37550.11%
Meta (FB+IG)3,50030.09%
LinkedIn1,50010.07%
Organic2,25010.04%
WhatsApp/Direct87500.00%

🚨 Alert Configuration

AlertConditionChannelRecipient
🚨 Enrollment rate dropbelow 10% for 3 daysEmail + WhatsAppMarketing Lead
🚨 Lead volume dropbelow 50% of 7-day avgEmailMarketing Team
🚨 High CACCAC above SAR 10,000EmailLeadership
✅ Milestone: 10 enrollmentsCount equals 10WhatsApp GroupAll Teams
✅ Milestone: 50 consultationsCount equals 50EmailAdmissions
⚠️ Stalled leadsNo contact in 14+ daysCRM TaskAssigned Rep
⚠️ Low engagementScore below 20CRM AlertAssigned Rep

📋 Daily Report Preview

# Daily Report - 2026-05-08 09:00 KSA
Traffic: 1,847 visitors (+12% WoW) | 4,203 pageviews (+15%)
Leads: 42 new | 18 qualified | 8 consultations booked | 2 applications | 0 enrollments
Funnel: LP to CTA 14.2% | CTA to Booking 52% | Booking to Attendance 68% | App to Enroll 25%
Revenue: SAR 0 (pending apps) | CAC: N/A | LTV: SAR 70,740
Top Region: Central (46%) | Top Source: Google Ads (38%)
Status: All systems operational. No alerts.
$ generate-report --format=daily --recipients=team@jic.edu.sa