# 모더레이터 성과 관리

**URL:** https://meta.discourse.org/t/managing-the-performance-of-moderators/261722
**Category:** Data & reporting
**Tags:** moderation, sql-query
**Created:** [4월 14, 2023, 5:13오후 UTC](https://meta.discourse.org/t/managing-the-performance-of-moderators/261722 "2023-04-14T17:13:39Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![Chris27](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/chris27/32/141170_2.png) [@Chris27](https://meta.discourse.org/u/Chris27)
#### Post date: [2월 27, 2024, 6:14오후 UTC](https://meta.discourse.org/t/managing-the-performance-of-moderators/261722/4 "2024-02-27T18:14:05Z")

</div>

관심 있는 분들을 위해, 저는 데이터 탐색기 플러그인을 사용하여 다음 메트릭을 테이블로 표시하는 이 쿼리를 사용하고 있습니다:

Moderator\_Username  
다음 항목의 수:  
post\_approved  
post\_rejected   
approve\_user   
delete\_user   
suspend\_user   
unsuspend\_user

```sql

WITH date_range AS (
  SELECT
    '2024-02-01'::date AS start_date, -- 실제 시작 날짜로 조정
    '2024-02-27'::date AS end_date -- 실제 종료 날짜로 조정
)

SELECT
  u.username AS "Moderator_Username",
  COUNT(CASE WHEN uh.action = 56 THEN 1 ELSE NULL END) AS "post_approved",
  COUNT(CASE WHEN uh.action = 64 THEN 1 ELSE NULL END) AS "post_rejected",
  COUNT(CASE WHEN uh.action = 69 THEN 1 ELSE NULL END) AS "approve_user",
  COUNT(CASE WHEN uh.action = 1 THEN 1 ELSE NULL END) AS "delete_user",
  COUNT(CASE WHEN uh.action = 10 THEN 1 ELSE NULL END) AS "suspend_user",
  COUNT(CASE WHEN uh.action = 11 THEN 1 ELSE NULL END) AS "unsuspend_user"
FROM users u
LEFT JOIN user_histories uh ON u.id = uh.acting_user_id
WHERE (uh.created_at BETWEEN (SELECT start_date FROM date_range) AND (SELECT end_date FROM date_range))
  AND (u.moderator = true OR u.admin = true)
GROUP BY u.username
ORDER BY u.username

```

공유하고 싶은 다른 쿼리가 있는 분이 있나요?

---

_[View the full topic](https://meta.discourse.org/t/managing-the-performance-of-moderators/261722)._