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…

Dashboard Report - Moderator Activity

Community Building Data & reporting

Topic		Replies	Views
Analyzing Moderation and Flagging Activity Reports Data & reporting moderation , sql-query	0	287	February 13, 2025
User Page Metrics Data & reporting sql-query	6	296	February 27, 2025
Add more Moderator activity metrics to the Moderation tab on the dashboard Feature moderation , dashboard-reports , reporting	0	103	July 4, 2025
Solved Topic and Moderator Response Stats by Category Data & reporting solved , sql-query	0	415	April 3, 2024
Dashboard Report - Flags Status Data & reporting sql-query , dashboard-reports , dashboard-sql	0	448	December 22, 2023

Dashboard Report - Moderator Activity

Related topics