Question Bank
Manage all questions — filter, edit, delete, bulk select
| # | Question | Subject | Topic | Sub-topic | Difficulty | Type | Year/PYQ | Status | Actions | |
|---|---|---|---|---|---|---|---|---|---|---|
—
Bulk Upload
Upload hundreds of questions at once via CSV
1Download Template & Fill
The CSV template has all required columns. Dropdowns in the template are populated from your database — subjects, topics, exams etc. match exactly what's in Supabase.
CSV Columns:
question_text Requiredoption_a Requiredoption_b Requiredoption_c Requiredoption_d Requiredcorrect_ans A/B/C/Dsubject From DBtopic From DBsub_topic Optionalexam Optionaldifficulty Easy/Med/Hardquestion_type MCQ/T-F/etcyear e.g. 2024tags comma-sepappeared_in e.g. SSC 2024explanation Optionalstatus active/draftIf subject/topic not found in DB → question auto-saved as draft. If correct_ans missing → draft. Column status=active → published directly.
2Upload & Validate
Drag & Drop your CSV here
or click to browse — .csv files only
Upload Log
Upload a CSV to see results here...
AI Import
Extract questions from book images or PDF pages using AI — choose any provider below
1Settings
Choose AI Provider
Stored in browser only. Get free key: aistudio.google.com
Upload the answer key image separately after questions
2Upload Images / PDF Pages
Drag & Drop images or PDF pages here
JPG, PNG, WebP • Multiple files OK • One page per file
AI Log
Upload images and click Extract...
Tips
One image = one book page
Works with photos, scans, screenshots
Handles A/B/C/D or 1/2/3/4 options
Tick checkbox if answers are on a separate page
✨ Gemini — FREE
1500 pages/day • No credit card • Best value
🔶 Anthropic Claude
Haiku: ~₹0.1/page • Sonnet: ~₹0.8/page
🟢 OpenAI GPT-4o
GPT-4o mini cheap • GPT-4o best vision
𝕏 Grok / 🐋 DeepSeek
Text-only extraction • Very affordable
Test Builder
Create mock tests dynamically from the question bank
Test Details
Exam-specific mock aligned to a single exam pattern and syllabus.
Filter & Pick Questions
| Question | Subject | Topic | Diff | Year | |
|---|---|---|---|---|---|
| Apply filters and click Search | |||||
—
Selected Questions
No questions added yet.
Filter and select from the left panel.
Filter and select from the left panel.
Test Summary
Selected0
Easy0
Medium0
Hard0
Subjects—
0 / 0 questions selected
Mock Tests
All created mock tests
| # | Test Name | Exam | Qs | Mins | Type | Package | Attempts | Status | Actions |
|---|---|---|---|---|---|---|---|---|---|
Exams
Manage exam categories shown on the landing page — exam cards, tabs, and registration dropdown all come from here
Every exam added here automatically appears as an exam card on the homepage, a category tab, and in the registration dropdown. No hardcoded data — 100% dynamic.
| # | Exam Name | Category | Tags | Free | Paid | Sort | Status | Actions |
|---|---|---|---|---|---|---|---|---|
Subjects & Topics
Manage subjects, topics — drag rows to reorder
Drag the ⠿ handle to reorder subjects. Inside each subject, drag topics to reorder them. Click Edit to rename or change icon.
Packages & Pricing
Manage subscription plans shown on landing page and job page
Packages configured here appear as PRO upgrade banners on the homepage sidebar, jobs page sidebar, and in the payment modal. Set exactly one package as Featured to highlight it.
| Package Name | Price / Month | Annual Price | Features | Banner Headline | Featured | Status | Actions |
|---|---|---|---|---|---|---|---|
| Loading... | |||||||
Sidebar Mock Slots
Choose which mock tests appear in the Practice Mocks sidebar on the Jobs page and Homepage
These 6 slots appear in the Practice Mock Tests sidebar on the Jobs page and Homepage. Drag to reorder. Each slot can link to any active mock test or a filtered URL. Changes take effect immediately.
Saves to
site_settings table as JSON
AI Answer Cache
Pre-generate AI explanations for all questions — users get instant answers at zero API cost
Total Questions
—
Cached (Explained)
—
Not Yet Generated
—
Cache Hit Rate
—
Est. One-time Cost
—
Total Cache Hits Served
—
Batch Generation Settings
🤖 AI Provider
● Not configured
Generates AI explanations for all uncached questions. Safe to run multiple times.
AI Answer Cache
Pre-generate AI explanations for all questions — users get instant answers at zero ongoing API cost
Total Questions
—
Cached
—
Not Generated
—
Cache Coverage
—
Est. One-time Cost
—
Total Hits Served
—
Batch Generation Settings
Generates AI explanations for all uncached questions. Safe to pause and resume. Rate-limit aware.
Google AdSense
Ad placement guide, slot IDs, and revenue overview for mock247.com
Publisher ID
ca-pub-9823669453895454
ads.txt Status
Deployed at /ads.txt
Auto Ads
Use manual slots (recommended)
AdSense Dashboard
Open AdSense
Ad Placement Map — All Pages
| Page | Location | Format | Size | Slot ID (paste from AdSense) |
|---|---|---|---|---|
| Home (mock247.html) | After Browse Mock Tests section | Rectangle | 300×250 | |
| Home (mock247.html) | Footer banner | Horizontal | 728×90 | |
| Home — Sidebar | Sidebar 300×250 block | Rectangle | 300×250 | |
| Jobs (mock247-jobs.html) | Top banner | Horizontal | 728×90 | |
| Jobs (mock247-jobs.html) | Inline between job cards (every 5) | Rectangle | 300×250 | |
| Current Affairs | Top banner + sidebar 300×250 + inline every 6 articles | Mixed | Multiple | |
| Mocks Page | Top banner + inline every 6 cards | Mixed | 728×90 / 300×250 | |
| Article Modal | Inside article popup (current affairs) | Horizontal | Responsive |
How to add slot IDs: Go to Google AdSense → Ads → By ad unit → Create each unit (use the format from the table above) → Copy the
data-ad-slot value (a number like 1234567890) → Paste it into the HTML files at the corresponding data-ad-slot="" attribute. Slot IDs noted above are for your reference only — they do not auto-update the HTML files.
Revenue Optimization Tips
✅ Approved PagesEnsure all 4 main pages (home, jobs, current-affairs, mocks) are submitted for review in AdSense. All must have substantial, original content.
📊 Best Performing FormatsRectangle (300×250) in sidebar performs best. Horizontal leaderboard (728×90) at top of page. In-article after 2nd paragraph on current affairs page.
🚫 Policy ReminderDo not click your own ads. Do not encourage clicks. Keep ads clearly labeled "Advertisement". Max 3 ads per page viewport. No ads near buttons.
💰 PRO Users = Ad-FreePro plan subscribers see no ads (as advertised). Ensure the ad containers are hidden for logged-in pro users via the userPlan check already in the codebase.
Users
View, suspend, reactivate, and upgrade user plans
| ID | Name | Phone | Plan / Expiry | Exam | Joined | Tests | Status | Actions | |
|---|---|---|---|---|---|---|---|---|---|
Transactions
| Order ID | User | Plan | Amount | Method | Date | Status |
|---|---|---|---|---|---|---|
Announcements
Live announcements appear in the marquee/banner on the landing page
Create / Edit Announcement
All Announcements
| Title / Message | Type | Target | Status | |
|---|---|---|---|---|
Current Affairs
Add and manage news articles — published articles appear on the landing page
| Headline | Category | Exam Tags | Date | Month | Status | Actions |
|---|---|---|---|---|---|---|
Job Openings
Active openings appear in the sidebar on the landing page
| Exam / Post | Vacancies | Age Limit | Salary / Pay | Dates | Featured Mock | Status | Actions |
|---|---|---|---|---|---|---|---|
Daily Challenge
Set and manage the daily challenge question shown to all users
| Date | Question | Topic | Status | Entries | Actions |
|---|---|---|---|---|---|
| Loading... | |||||
Discussion Moderation
Review and moderate peer comments on questions
| Comment | Upvotes | Date | Status | Actions |
|---|---|---|---|---|
| Loading... | ||||
Support Tickets
View user messages and send replies
| Ticket # | User | Subject | Category | Date | Priority | Status | Reply Preview | Actions |
|---|---|---|---|---|---|---|---|---|
User Feedback
Ratings and comments submitted by users after completing mock tests
—
Avg Rating
—
Total Responses
—
Positive (4-5★)
—
Needs Work (1-2★)
| Date | User | Test | Exam | Rating | Difficulty | Comment | Would Recommend | Actions |
|---|---|---|---|---|---|---|---|---|
Dashboard
—
Total Users
—
Pro Users
—
Active Tests
—
Questions
—
Today's Attempts
—
Today Revenue
Settings
General
Site Display
Pricing
Razorpay
SEO
Re-attempt Limits
Controls how many times a Free user can attempt the same test. PRO users always get unlimited attempts.
attempts per test (e.g. 3)
Free users: 3 attempts per test
PRO users: Unlimited
Referral Codes
Each user gets a unique referral code. When a friend applies it, both sender and recipient get PRO for the configured days. One-time use per email/mobile enforced automatically.
—
Total Codes
—
Total Uses
—
Active Codes
—
PRO Days Given
How It Works
1. Every registered user has a unique referral code (visible in their dashboard) •
2. User shares their code with a friend •
3. Friend applies the code → both get PRO for the days set below •
4. One-time use per email/mobile — duplicates blocked automatically
Global Referral Settings
Admin Promo Codes
| Code | Recipient Days | Sender Days | Max Uses | Used | Expires | Status | Actions |
|---|---|---|---|---|---|---|---|
Usage Log
| Date | Code | Recipient | Recipient PRO Until | Sender PRO Until |
|---|---|---|---|---|