This is an SQL version of the Dashboard Report for Moderator Activity. This report provides a comprehensive overview of the activities performed by moderators within a specified time frame on a Discourse site. The report combines multiple aspects of moderator activity: time spent on the platform, n…

Hi @SaraDev , This is really useful. Would it be possible to add '‘Posts approved’ and ‘Posts rejected’ columns to the Moderator Activity report? Thanks, T_Disco

Hi @T_Disco , [image] T: Would it be possible to add '‘Posts approved’ and ‘Posts rejected’ columns to the Moderator Activity report? Yes, to add Posts approved and Posts rejected results to the Moderator Activity report, we can utilize the reviewables and reviewable_scores tables. Specifical…

That’s brilliant, thank you @SaraDev ! Will those columns be added to the Moderator Activity report on the /admin/dashboard/moderation tab at some point? Thanks again :slight_smile: T_Disco

@SaraDev Is a query possible for number of topic merges carried out in a given time period

[image] T: Will those columns be added to the Moderator Activity report on the /admin/dashboard/moderation tab at some point? We don’t currently have any plans to add those columns to the dashboard version of the report, but I can bring this up with our team to see if we can make some improve…

Rapport du tableau de bord - Activité du modérateur - #7 par SaraDev - Données et rapports

Sujet		Réponses	Vues	Activité
Analyzing Moderation and Flagging Activity Reports Data & reporting moderation , sql-query	0	213	Février 13, 2025
User Page Metrics Data & reporting sql-query	6	195	Février 27, 2025
Add more Moderator activity metrics to the Moderation tab on the dashboard Feature moderation , dashboard-reports , reporting	0	57	Juillet 4, 2025
Solved Topic and Moderator Response Stats by Category Data & reporting solved , sql-query	0	338	Avril 3, 2024
Dashboard Report - Flags Status Data & reporting sql-query , dashboard-reports , dashboard-sql	0	420	Décembre 22, 2023

Analyzing Moderation and Flagging Activity Reports

Data & reporting

moderation , sql-query

0

213

Février 13, 2025

User Page Metrics

Data & reporting

sql-query

6

195

Février 27, 2025

Add more Moderator activity metrics to the Moderation tab on the dashboard

Feature

moderation , dashboard-reports , reporting

0

57

Juillet 4, 2025

Solved Topic and Moderator Response Stats by Category

Data & reporting

solved , sql-query

0

338

Avril 3, 2024

Dashboard Report - Flags Status

Data & reporting

sql-query , dashboard-reports , dashboard-sql

0

420

Décembre 22, 2023

Rapport du tableau de bord - Activité du modérateur

Sujets connexes