See which learners finish, and which have gone quiet
Connect your platform's database, then ask in plain English: enrolments by course, completion by cohort, learners inactive for 14 days, pass rates by module and seats activated for each customer.
For online course and learning platforms, tutoring and test-prep companies, and B2B learning products.
Free plan. No credit card required.
Completion rate by course for the March cohort
AI Analyst
SQL for Analysts has the lowest completion in the March cohort: 31.3% of 380 learners, against 42.2% across all four courses.
Readenrolmentslesson_completionscoursesSQL
Keep itPin to dashboardEmail it weeklyAlert me
Every question, by who asks it
Taken from what teams in this industry ask Supaboard. Each one opens a free account with the question waiting.
01 · Courses and completion
- Enrolments by course this month against last monthAsk this: Enrolments by course this month against last month
- Completion rate by course for the March cohortAsk this: Completion rate by course for the March cohort
- Which lesson do most learners stop at in our biggest course?Ask this: Which lesson do most learners stop at in our biggest course?
- First-attempt pass rate by module: where do learners fail most?Ask this: First-attempt pass rate by module: where do learners fail most?
02 · Learners and tutors
- Learners inactive for 14 days who are under halfway through their courseAsk this: Learners inactive for 14 days who are under halfway through their course
- Students with a test date in the next 30 days who haven't sat a practice testAsk this: Students with a test date in the next 30 days who haven't sat a practice test
- Tutor utilisation last week: hours booked against hours available, by tutorAsk this: Tutor utilisation last week: hours booked against hours available, by tutor
03 · Plans and customers
- Trial-to-paid conversion: learners who finished lesson 1 against those who didn'tAsk this: Trial-to-paid conversion: learners who finished lesson 1 against those who didn't
- Renewal rate of annual plans that came up for renewal last quarterAsk this: Renewal rate of annual plans that came up for renewal last quarter
- Seats activated for each B2B customer against seats boughtAsk this: Seats activated for each B2B customer against seats bought
Keep it running
What teams keep on a schedule once they've asked the question once.
Report · Monday 08:00
The weekly learner report
Enrolments, completion by course and cohort, and the learners who've gone quiet, summarised and in the learning team's inbox.
- Timed Start
- Query Your Data
- Summarize Insights
- Send Email
Alert · Every 5 minutes
Gone-quiet watch
A SQL check finds learners reaching 14 days without a session while under halfway, and calls your webhook so your email tool can send a nudge.
- Alerts
- Send Webhook
Datasite · Quarter end
Each customer's own datasite
A private datasite per B2B customer, with Google or Microsoft sign-in, showing its seats activated and its learners' completion.
The numbers it keeps watch on
Standard definitions, and where each one lives in Supaboard once you've asked for it.
| Measure | Definition | Source | In Supaboard |
|---|---|---|---|
| Enrolments | Learners newly enrolled in a course in the period, by course and plan | Common practice | Monday learner report |
| Completion rate | Learners who complete every required lesson ÷ learners enrolled, by course and cohort | Common practice | Monday learner report |
| Completion and pass, apart | Finishing a course (completed or incomplete) and passing it (passed or failed) are separate statuses | SCORM 2004 run-time data model | A rule, read with every question |
| First-attempt pass rate | Learners who pass an assessment at the first attempt ÷ learners who attempted it | Your pass mark | Dashboard by module |
| Inactive learners | Enrolled learners with no session in the last 14 days and under halfway through their course | Common practice | Alert, then a nudge |
| Tutor utilisation | Hours booked ÷ hours available, per tutor per week | Common practice | Weekly report |
| Annual renewal rate | Annual plans renewed ÷ annual plans that came up for renewal | Common practice | Monthly question |
| Seat activation | Seats whose learner has started a course ÷ seats bought, per customer | Your contract | Each customer's datasite |
Where your data lives
PostgresLive
MySQLLive
MongoDBLive
BigQueryLive
Or attach an export to a conversation, as CSV or Excel:
- XLSCourse and gradebook exportsUpload
The tables these questions read:
- Learners and enrolments, with cohort and plan
- Courses, modules and lessons
- Lesson completions and learner sessions
- Quiz and assessment attempts, with scores
- Tutor availability and bookings
- B2B customers, contracts and seats
Teach it your definitions once
Rules are read with every question, so a term means the same thing in Chat, in Slack and in the Monday report.
- Rule“A course is complete when every required lesson is done; passing the final assessment is counted apart.”
- Rule“Inactive means no lesson session in the last 14 days.”
- Rule“A seat is activated when its learner starts their first lesson.”
Security
Read-only by construction
Database and warehouse queries are read-only. We give you the SQL for a read-only user too.
Credentials stay in the workspace
Scoped to the one workspace that connected them, never logged and never sent back to a browser.
SOC 2 Type II
An organisation-wide audit of the platform, covering every plan.
Frequently asked questions
Does it work with our learning platform?
If your platform's data is in Postgres, MySQL, MongoDB or BigQuery, connect it live and ask. From a hosted course or learning system, export enrolments, completions and grades to CSV or Excel and upload them, or copy them into a database you connect.
Can each B2B customer see its own numbers?
Yes. Publish a private datasite for each customer with Google or Microsoft sign-in, or keep one workspace per customer. To show reports inside your own product, embed dashboards, or use the white-label app: one per workspace, on your own domain.
How does it learn what "completed" means for us?
Write it once as a rule, such as "a course is complete when every required lesson is done". The agent reads its rules with every question, and you can save reviewed SQL as examples.
Can it change learner records?
No. Database and warehouse queries are read-only. We give you the SQL to create a read-only user.
Can the learning team get it every Monday?
Yes. An automation runs your questions at 08:00 on Monday in your timezone, summarises what changed and emails it. Dashboard reports can also go out as PDF, PowerPoint or Excel.
More in Software & Commerce
- SaaS & Cloud SoftwareMRR movements, churn, expansion and activation, from billing and product data.
- Subscription BoxesActive subscribers, failed payments, gifting and churn by box, from billing data.
- E-commerce & DTC BrandsProfit after ads, stock cover and repeat buyers, across store, marketplace and retail.
Ask your first question on your own data
Connect a source, ask in plain English, and keep what you find.
Start FreeBook a 30-minute demo
Free plan. No credit card required.