Dashboard for tutors and online schools in Google Sheets

Dashboard for tutors and online schools in Google Sheets

A ready-made dashboard for a private tutor, tutoring agency, or small online school. It runs on Google Sheets—no Excel, specialized software, or programmer required.

WHAT’S IN THE PACKAGE
• Google Sheets template with all formulas included (link to copy)
• 10-step PDF guide with screenshots
• 5-minute video overview: setup and usage instructions
• Backup file (TEMPLATE.xlsx) for Excel or LibreOffice
• Demo version with sample data—preview before you buy

WHAT THE DASHBOARD TRACKS
• Revenue, average transaction value, and margins by teacher
• Active students, new vs. churned students, and churn rate
• LTV, lesson cancellation rate, and prepaid lesson balances
• Sales funnel: leads → trial lessons → payments
• CAC and LTV/CAC ratio by lead source
• Top 10 students and "at-risk" students (those who haven´t attended recently)

Includes 12 status cards with color-coded "good/bad" indicators, 8 charts, and data tables broken down by teacher, subject, and source. Everything updates automatically when you enter new data. HOW TO USE
1. Receive the archive after payment
2. Open the template link and select "File → Make a copy"
3. Fill in the white columns: students, lessons, payments, inquiries, and advertising expenses
4. Gray columns and charts calculate automatically

REQUIREMENTS
• Google account (free)
• Data format: YYYY-MM-DD
• Lesson statuses: Conducted, Student cancellation, Teacher cancellation, No-show

IMPORTANT
Do not enter students´ full names, phone numbers, or email addresses. Use IDs and initials instead—this is a requirement of Federal Law No. 152-FZ on personal data.

LIMITS
Up to 500 students, 5,000 lessons, and 1,500 payments. If you are an agency with higher volumes, contact us and we can expand these limits.

LICENSE
1 license = 1 organization. You may customize the template to suit your needs, but you may not resell it.

Additional information:

Before purchasing, please check out the demo version with test data—the link is in the product description. If something isn´t calculating correctly after your purchase, please contact me via the Digiseller support form, and I’ll help you sort it out. I respond within 24 hours.