Online learning companies collect detailed data on every click, video and quiz. Analysts help them answer two big questions: are we converting the right learners, and are learners actually finishing and benefiting?
The learner funnel
Visit โ sign up โ start free trial or first lesson โ active during trial โ pay โ stay active โ complete โ renew or refer.
Each step has a conversion rate, and the biggest drops show where to focus.
Acquisition and conversion KPIs
- Sign-up conversion: visitors who create an account.
- Activation rate: sign-ups who complete a meaningful first action, such as finishing a lesson.
- Trial-to-paid conversion: trial users who pay.
- Cost per acquisition by channel.
- Time to convert: days from sign-up to payment.
Engagement KPIs
- Daily and weekly active learners.
- Lessons or minutes per learner per week.
- Quiz attempts and scores.
- Streaks: consecutive days of activity.
- Doubt or mentor session usage.
Outcome KPIs
- Course completion rate: learners who finish รท learners who started.
- Module drop-off: where learners stop.
- Assessment improvement over the course.
- Refund rate and its reasons.
- Renewal or upgrade rate.
Operations KPIs
- Mentor load: learners or doubts per mentor.
- Doubt resolution time.
- Live class attendance.
Analysing a conversion drop
- Confirm the drop is real (tracking changes often break funnels).
- Split conversion by channel, device, course, city and sign-up week.
- Compare trial behaviour of converters and non-converters: lessons watched, quizzes taken, first-day activity.
- Check product or pricing changes around the drop date.
- Recommend: improved onboarding, nudges for inactive trial users, channel budget shifts.
Analysing course drop-off
- Plot the share of learners reaching each module.
- Find modules with sharp drops; check length, difficulty and quiz failure rates.
- Relate drop-off to mentor response times and doubt backlogs.
- Recommend: split long modules, add practice, rebalance mentor allocation.
Portfolio projects
Both are on the edtech projects page. Funnels and cohorts are core skills here; see SQL cohort retention analysis and the A/B testing guide.
Practise what you just read
Reading helps; writing the code yourself is what sticks. Start here: