Share of sessions completed (more than 3 exchanges saved and scored), per period.
Sessions started per period (IST).
Share of all sessions reaching each step.
Failure categories, % of all sessions. One category per failed session.
What each category is read from in the logs or the mic recording.
First warning the app was sent in each session (the app shows only one). "Heard after" = a learner turn was committed after it.
Share of sessions and completion rate per session language.
From the app's client_info message (user agent). "Not reported" = the mic never started, so the app never sent it.
Data: the uploaded prod backend logs of app-yodagptbackend-prod-01 and the learners' mic recordings, processed by the backend on this PC (start_backend.bat). Times are IST. The Excel has the same 70 columns as "IIFL Sarvam Roleplay Sessions 21-28 Sep"; learner, cohort, scenario, score and transcript columns fill in once the CRUD export is added to the backend.