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 , [图片] 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. Specifically,…

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

[图片] 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 improvemen…

仪表盘报告 - 管理员活动 - #7，来自 SaraDev - 数据与报告

话题		回复	浏览量	活动
Analyzing Moderation and Flagging Activity Reports Data & reporting moderation , sql-query	0	184	2025 年2 月 13 日
User Page Metrics Data & reporting sql-query	6	167	2025 年2 月 27 日
Add more Moderator activity metrics to the Moderation tab on the dashboard Feature reporting , moderation , dashboard-reports	0	51	2025 年7 月 4 日
Solved Topic and Moderator Response Stats by Category Data & reporting solved , sql-query	0	330	2024 年4 月 3 日
Dashboard Report - Flags Status Data & reporting dashboard-reports , sql-query , dashboard-sql	0	418	2023 年12 月 22 日

Analyzing Moderation and Flagging Activity Reports

Data & reporting

moderation , sql-query

0

184

2025 年2 月 13 日

User Page Metrics

Data & reporting

sql-query

6

167

2025 年2 月 27 日

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

Feature

reporting , moderation , dashboard-reports

0

51

2025 年7 月 4 日

Solved Topic and Moderator Response Stats by Category

Data & reporting

solved , sql-query

0

330

2024 年4 月 3 日

Dashboard Report - Flags Status

Data & reporting

dashboard-reports , sql-query , dashboard-sql

0

418

2023 年12 月 22 日

仪表盘报告 - 管理员活动

相关话题