如何跟踪哪些用户查看了特定主题？

[Monika_Gupta]

我们如何追踪查看了特定主题的“用户列表”？

[EricGT]

我会提出两点注意事项，至少就我的具体需求而言：一是需要细化到帖子级别，二是需要设定帖子被查看的最短时长。

虽然我不需要用户友好的图形界面，因为我认为拥有 PostgreSQL 数据库的管理员权限后，直接运行查询即可。

[Mevo]

Hawk 在另一个话题中的回答可能也解答了你的问题：

@HAWK

接入 Google Analytics 后，你将能够获取更细粒度的用户旅程信息。

不过，如果你这样做，可能需要处理 Cookie 接受的相关事宜。

[mcwumbly (Dave McClure)]

@EricGT

虽然我不需要用户友好的图形界面，因为我怀疑只要拥有 PostgreSQL 数据库的管理员权限，就可以运行查询。

是的，而且……

这可以通过 #plugin:data-explorer 来实现。

[EricGT]

@mcwumbly

这可以通过 #plugin:data-explorer 实现。

谢谢。

虽然我无法访问数据浏览器，但我还是检查了一些查询，并找到了：

按日期统计的主题阅读量

或者类似反向索引的功能：
能否查看用户浏览过的主题？

我记得还有另一个主题列出了有用的数据浏览器查询，但目前我暂时找不到它。

[mcwumbly (Dave McClure)]

看起来你链接的那篇帖子确实有一个示例：

@ditatompel

谁（已登录用户）查看了特定主题

-- [参数]
-- int :topic_id = 1

SELECT
    title,
    viewed_at,
    tv.user_id
FROM topics t
LEFT JOIN topic_views tv
    ON t.id = tv.topic_id
WHERE category_id IS NOT NULL
    AND tv.user_id IS NOT NULL
    AND t.id = :topic_id
ORDER BY viewed_at DESC
LIMIT 1000

[mcwumbly (Dave McClure)]

相关话题：

Delivered and read notifications?

Hmmm since this topic was last posted we did build this feature for group messages: [image] So yeah, a lot of the mechanics are in core, its just a question of how many toggles we want to give people. I can see the appeal in personal messages that are not group messages to “know” that you were read, but there are privacy concerns and I am not sure how many toggles should be provided.

以及：

Publish group read state

When in a group, knowing if another user reads a message can be quite useful. A couple of months ago we added the experimental “Publish read state” feature, which after a lot of tweaks is now ready to be safely used. As you may have noticed, this shows who read which post. It adds a new icon and the reader’s count just before the likes: [Screen Shot 2020-02-27 at 15.03.02] If you click the icon, you can also see the reader’s avatars (it works the same way that likes). You will only count as a…