Overview Dashboard
Registration analytics — district-wise · course-wise · demographics
Registrations by District
Normalized · "Niwshera", "Nowsehra", "NOwshera" etc. all merged into Nowshera
Gender Distribution
Male / Female breakdown
Course Enrollment Share
Web Design + Web Development merged · Digital Marketing + SEO merged into bootcamp
Preferred Time Slot
🌅 Morning (10:00 AM - 12:00 PM) · 🔄 Afternoon (1:00 PM - 4:00 PM) · 🌆 Evening (4:00 PM - 6:00 PM)
Recent Registrations
Last 12 submissions
District Analysis
All district spelling variants normalized · top districts × courses cross-tab
District Breakdown
Count & percentage share
| District | Count | Share | % |
|---|
District × Course Matrix
Top 6 districts, enrollment counts per course
Course Analytics
Course name corrections applied — old/incorrect names normalized to standard names
Course Popularity
Each registrant may select multiple courses
Enrollment Table
Sorted by total enrollments
| Course | Count | Share | % |
|---|
All Registrants
Phone numbers formatted to +92 standard · search, filter by district / course / gender
| # | Name / Email | Phone (+92) | District | Courses | Time Slot | Gender |
|---|
Data Quality Report
Issues detected in raw form responses and corrections applied
District Spelling Corrections
All raw variants found in the CSV and their normalized values
| Raw Value in CSV | Normalized To | Issue Type |
|---|---|---|
| Nowhere KHESHGI | Nowshera | Wrong word — "Nowhere" instead of "Nowshera" |
| NOwshera | Nowshera | Mixed case |
| Niwshera | Nowshera | Misspelling — "Niw" instead of "Now" |
| Nowshere | Nowshera | Misspelling — "here" instead of "hera" |
| Nowsehra | Nowshera | Transposed letters |
| Nowahera | Nowshera | Misspelling |
| NOWSHERA / nowshera | Nowshera | All-caps / all-lowercase |
| Charssada / Charsada | Charsadda | Extra "s" / missing "d" |
| Raheem yar Khan | Rahim Yar Khan | "Raheem" → "Rahim" |
| MARDAN | Mardan | All-caps |
| Nigeria | Nigeria (Out of Pakistan) | Out-of-country registrant flagged |
Phone Number Formatting Rules
All numbers standardized to +923XXXXXXXXX format
| Rule | Example Input | Output |
|---|---|---|
| Starts with 0 → remove 0, add +92 | 03001234567 | +923001234567 |
| Starts with 3 → add +92 | 3001234567 | +923001234567 |
| Already has 92 prefix → add + | 923001234567 | +923001234567 |
| Already has +92 → keep as-is | +923001234567 | +923001234567 |
| Spaces and dashes stripped first | 0300 123-4567 | +923001234567 |
| Too short or non-numeric → flagged | 0370958 | Invalid |
Course Plan
Planned programme structure — batches, categories, and live enrollment from registration data
Interview Stats
Only students with interview assignment data · grouped by week · morning & evening course slots
Seat Availability
All 12 batches · sorted by open seats — assign students to batches with most gaps first
Interviewed Students
Students with assigned week and course(s) · — shown
| # | Name | District | Gender | Week | Morning (10:00 AM) | Evening (4:00 PM) |
|---|
Merit List
All 12 batches across 7 bootcamp weeks — assigned students per course slot
Send Email
Compose and send targeted emails to registrants — filter by district, course, or gender
Recipients
0 will receive this email
Compose Email
Personalization placeholders:
{{name}}
{{district}}
{{courses}}
{{phone}}
{{gender}}
Settings
Mail server configuration, data source, and appearance — stored locally in your browser
📧 Email Configuration
Upload server/send-mail.php to your VPS once — then paste the URL below. That's it.
send-mail.php script on your VPS
API_KEY constant in your PHP file
- Find the file
server/send-mail.php(created alongside this dashboard) - Open it and set
API_KEYto any secret string of your choice - Upload it to your VPS web root (e.g.
/var/www/html/send-mail.php) - Paste the public URL and the same secret key above, then click Save
📊 Data Source
Override the Google Sheets URL used to fetch registration data
🎨 Appearance
Default theme applied on page load
⚠ Danger Zone
Permanently remove all locally stored settings and credentials