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	185	Février 13, 2025
User Page Metrics Data & reporting sql-query	6	169	Février 27, 2025
Add more Moderator activity metrics to the Moderation tab on the dashboard Feature reporting , moderation , dashboard-reports	0	52	Juillet 4, 2025
Solved Topic and Moderator Response Stats by Category Data & reporting solved , sql-query	0	330	Avril 3, 2024
Dashboard Report - Flags Status Data & reporting dashboard-reports , sql-query , dashboard-sql	0	418	Décembre 22, 2023

Analyzing Moderation and Flagging Activity Reports

Data & reporting

moderation , sql-query

0

185

Février 13, 2025

User Page Metrics

Data & reporting

sql-query

6

169

Février 27, 2025

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

Feature

reporting , moderation , dashboard-reports

0

52

Juillet 4, 2025

Solved Topic and Moderator Response Stats by Category

Data & reporting

solved , sql-query

0

330

Avril 3, 2024

Dashboard Report - Flags Status

Data & reporting

dashboard-reports , sql-query , dashboard-sql

0

418

Décembre 22, 2023

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

Sujets connexes