新規ユーザー（および他の信頼レベル）が最も投稿するカテゴリを確認する

コミュニティ データとレポート
1

特定の信頼レベルに属するユーザーが最もよく利用するカテゴリを確認する方法はありますか？
特に、新規ユーザーがトピックを作成しそうなカテゴリ、また一般的にどこに投稿するか、さらに他の信頼レベルのユーザーの行動についても興味があります。
例えば、ランクアップ前の通常ユーザーの投稿やトピックは、カウントしないか、あるいは以前の信頼レベルにカウントするべきです。

私の仮説では、新規ユーザーは何かの助けを得られるカテゴリで投稿（特にトピック作成）する可能性が最も高く、一方、通常ユーザーは深い議論を行うためにカテゴリを利用する傾向が強いということです。

2

Sounds like a job for the Data Explorer plugin! Very useful, you can learn more about it here:

Here’s a stab at a SQL query that does something like this — it takes trust_level as a parameter, and then returns a sorted list of the # of posts created in each category by users w/ that trust level (disclaimer, I’m a SQL novice, modify as needed!):

-- [params]
-- int :trust_level = 1

WITH topic_categories AS
    (SELECT
        t.id topic_id,
        t.user_id,
        t.created_at,
        t.score,
        c.id category_id,
        c.name category_name
    FROM
        topics t
    LEFT JOIN categories c
    ON t.category_id = c.id
    )

SELECT 
    count(tc.*) count,
    tc.category_id
FROM
    users u
LEFT JOIN topic_categories tc
ON u.id = tc.user_id
WHERE 
    tc.created_at IS NOT NULL
    AND tc.category_id IS NOT NULL
    AND u.trust_level = :trust_level
GROUP BY 
    tc.category_id
ORDER BY count DESC
3

That’s something I’d also be very interested in.

Recently I asked a similar question and it seems like out-of-the-box metrics for user interactions are coming soon to the admin dashboard 2.0 :rofl:

Not sure if this specific feature would also be included; perhaps @HAWK might also be able to confirm that.

4

The dashboard won’t specifically include this data. My challenge is to simplify the dashboard but make it useful for all community types. For instance, CoP CMs need very different data to support community CMs. TL data is of very little (if any) relevance to the latter.

What we are planning as a compromise is to surface approved data explorer queries via the dashboard so that mods have access.

Here is an early mockup:

image
image2198×1378 210 KB