Student Admission Dashboard
Download a PDF showing the admitted-student count for every course in the selected admission-date range.
Upload the 2026 Excel/CSV report, then select the 2025 admission-date range for comparison.
Upload a 2026 Excel/CSV file with Course Name and Count, or student detail rows with a course column. Intake values are fixed from the shared intake PDF.
Mark 2026 admitted students as withdrawn. Withdrawn 2026 students are excluded from admission reports and counts.
Give these details to the Meritto team.
X-Meritto-Secret)| Field Name | Example Value | Notes |
|---|---|---|
name | Ravi Sharma | Required |
first_name / last_name | Ravi / Sharma | Alternative to name |
email | ravi@example.com | Used for upsert match |
mobile | 9876543210 | |
lead_id / application_id | MRT-20260001 | Stored as Student ID |
course_name | B.Tech CSE | |
course_level | UG | |
campus / center_name | GEU Dehradun | |
lead_stage / status | enquiry / registration / admission | Controls date type |
date_of_enquiry | 2026-01-15 | YYYY-MM-DD preferred |
date_of_registration | 2026-02-10 | |
date_of_admission | 2026-03-01 | |
gender | Male / Female | |
state / city | Uttarakhand / Dehradun | |
father_name | Suresh Sharma | |
intake / academic_year | 2026 |
{
"lead_id": "MRT-20260001",
"name": "Ravi Sharma",
"email": "ravi.sharma@example.com",
"mobile": "9876543210",
"course_name": "B.Tech CSE",
"course_level": "UG",
"campus": "GEU Dehradun",
"lead_stage": "admission",
"date_of_enquiry": "2026-01-15",
"date_of_registration": "2026-02-10",
"date_of_admission": "2026-03-01",
"gender": "Male",
"father_name": "Suresh Sharma",
"state": "Uttarakhand",
"city": "Dehradun",
"intake": "2026"
}
Upload one or two Razorpay Excel / CSV reports. Auto-detects columns.
File must have an "Email" column. Supported formats: CSV, XLSX, XLS
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<style>
body { font-family: Arial, sans-serif; background: #f4f4f4; padding: 20px; }
.container { max-width: 600px; margin: 0 auto; background: white; padding: 30px; border-radius: 10px; }
.header { color: #0066cc; text-align: center; margin-bottom: 20px; }
.button { display: inline-block; background: #0066cc; color: white; padding: 12px 30px; text-decoration: none; border-radius: 5px; }
</style>
</head>
<body>
<div class="container">
<div class="header">
<h1>📚 Graphic Era University</h1>
</div>
<p>Dear Student,</p>
<p>This is a reminder that the admission deadline is approaching.</p>
<div style="text-align: center;">
<a href="https://geu.ac.in/apply" class="button">Complete Application</a>
</div>
<p>Best regards,<br>Admissions Team</p>
</div>
</body>
</html>
No campaigns yet. Create your first campaign in the Send tab!
Click "Refresh Preview" to see the email