How does everyone measure active/super active users? ie people who have logged in or commented in the past month, for example.
The dashboard tells me the number of visits and comments etc, but I don’t know how to chunk this down easily into actual users. We’ve got 1400 members on our community, but I’d like to know how many of those are engaging with it month on month.
Thanks,
Sian
The data explorer plugin will let you look at the data in a more granular fashion than the basic information which admin>dashboard shows.
See, for example, Active users in the last 30 days
Oo sounds interesting, how do I go about setting that up? I’m not a developer so have no idea where to begin.
See “Installation” at the bottom of: Data Explorer Plugin
These queries will help:
Returns the top 50 posters for a given monthly period. Results are ordered by post_count. It accepts a ‘months_ago’ parameter, defaults to 1 to give results for the most recently completed calendar month.
-- [params]
-- int :months_ago = 1
WITH query_period AS (
SELECT
date_trunc('month', CURRENT_DATE) - INTERVAL ':months_ago months' as period_start,
date_trunc('month', CURRENT_DATE) - INTERVAL ':months_ago months' + INTERVAL '1 month' - INTERVAL '1 second' as period_end
),
user_posts_in_period AS (
SELECT
p.user_id
FROM posts p
INNER JOIN query_period qp
ON p.created_at >= qp.period_start
AND p.created_at <= qp.period_end
WHERE p.user_id > 0
)
SELECT
up.user_id,
count(1) as post_count
FROM user_posts_in_period up
GROUP BY up.user_id
ORDER BY post_count DESC
LIMIT 50
Returns the top 50 likers for a given monthly period. Results are ordered by like_count. It accepts a ‘months_ago’ parameter, defaults to 1 to give results for the most recently completed calendar month.
-- [params]
-- int :months_ago = 1
WITH query_period AS (
SELECT
date_trunc('month', CURRENT_DATE) - INTERVAL ':months_ago months' as period_start,
date_trunc('month', CURRENT_DATE) - INTERVAL ':months_ago months' + INTERVAL '1 month' - INTERVAL '1 second' as period_end
)
SELECT
ua.user_id,
count(1) AS like_count
FROM user_actions ua
INNER JOIN query_period qp
ON ua.created_at >= qp.period_start
AND ua.created_at <= qp.period_end
WHERE ua.action_type = 1
GROUP BY ua.user_id
ORDER BY like_count DESC
LIMIT 50you could also get in touch with @DiscourseMetrics.com and @Bas (about Community Analytics)
their tools can give you loads of extra stats so you don’t have to do the work … I’m looking at such tools at the moment myself
Up till now I’ve been doing this just in excel - you can export your user data and run a few queries to monitor this. I gave a value to each post read, to posts (replies) and to new threads, then categorised them accordingly
So far it shows 20% are ‘readers’, 25% are ‘participants’ and 15% are ‘creators’
I’ve found that most analysis tools are under-valuing the role of readers because of a focus just on the activity of posting. There is a big difference between inactive members and active readers!
Good luck!
I think you are correct in saying this.
There are ways (e.g. separating logged in/out users, measuring read time, collating paged threads etc.) to guide Google Analytics to do quite a bit of this for you; but it takes some proper GA-fu to accomplish.
Great queries Sarah! Thanks for share.
I updated the query list, if you have more to add, please just send PR 
Thanks again !
I can’t take credit – @simon wrote them.
如何根据唯一 IP 获取每日计数？
仪表板 > 用户访问是否基于 IP，（包括登录用户和访客？）
谢谢…
我不这么认为。这是关于登录用户。
你也可以看看 What is "user visits" on the admin dashboard?
我认为这个和你想要找的类似。由于你想要所有用户，而不仅仅是匿名用户，你必须删除用户匿名的条件。
在用户列表中，我们有以下统计信息：
用户名、上次邮件发送时间、最后上线时间、浏览主题数、阅读帖子数、阅读时长、创建时间
是否可以添加：
创建的主题数、创建的帖子数、点赞数、收到的点赞数。
这些对于衡量最活跃的贡献者很有用。
这些都包含在 Discourse Meta 中
谢谢。看起来它在用户目录中，但不在管理员用户列表中，地址为：
https://meta.discourse.org/admin/users/list/active
我想知道是否可以在管理员界面中显示相同的字段，或者（当在设置中禁用时）管理员是否仍然可以查看用户目录，以便显示这些附加详细信息。
您好，刚看到这个帖子，如果您在这里，能否告诉我除了发帖活动之外，还有哪些工具可以帮助跟踪社区参与度，特别是衡量活跃读者？
谢谢，
Mike Taku。
我能为这些海报和点赞者创建一个徽章吗？