# Ed-Tech Analytics: Enrolments, Completion and Renewals > Ask your learning platform's data about enrolments, course completion, learners gone quiet, assessment pass rates and seats activated for each B2B customer. HTML version: https://supaboard.ai/industry/edtech **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. ## Every question, by who asks it ### Courses and completion - Enrolments by course this month against last month - Completion rate by course for the March cohort - Which lesson do most learners stop at in our biggest course? - First-attempt pass rate by module: where do learners fail most? ### Learners and tutors - 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 test - Tutor utilisation last week: hours booked against hours available, by tutor ### Plans and customers - 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 quarter - Seats activated for each B2B customer against seats bought ## Keep it running - **The weekly learner report** (Monday 08:00). Enrolments, completion by course and cohort, and the learners who've gone quiet, summarised and in the learning team's inbox. Automation: Timed Start → Query Your Data → Summarize Insights → Send Email. - **Gone-quiet watch** (Every 5 minutes). 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. Automation: Alerts → Send Webhook. - **Each customer's own datasite** (Quarter end). 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 | 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 - [Postgres](https://supaboard.ai/integrations/postgresql): connects live - [MySQL](https://supaboard.ai/integrations/my-sql): connects live - MongoDB: connects live - [BigQuery](https://supaboard.ai/integrations/bigquery): connects live Or attach an export to a conversation, as CSV or Excel: Course and gradebook exports. 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." [How rules work](https://supaboard.ai/product/knowledge-and-rules) ## 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. ## FAQ ### 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 Software](https://supaboard.ai/industry/saas): MRR movements, churn, expansion and activation, from billing and product data. - [Subscription Boxes](https://supaboard.ai/industry/subscription-boxes): Active subscribers, failed payments, gifting and churn by box, from billing data. - [E-commerce & DTC Brands](https://supaboard.ai/industry/ecommerce): Profit after ads, stock cover and repeat buyers, across store, marketplace and retail. Supaboard is [the AI data analyst connected to your business data](https://supaboard.ai/). [All industries](https://supaboard.ai/industry). --- - Site index for agents: https://supaboard.ai/llms.txt - Sitemap: https://supaboard.ai/sitemap.xml - Blog feed: https://supaboard.ai/blog/rss.xml - Product documentation: https://docs.supaboard.ai Any page on https://supaboard.ai is available as markdown: append `.md` to its path, or send `Accept: text/markdown`.