Lilly
February 22, 2024, 2:47am
2
You can get some of this info using Data Explorer .
There are a number of queries in the data & reporting topic_views table only records the first view by a user. Here’s a related query:
I’ve got a Data Explorer query for this (which shows username to enable csv / groups / pms stuff):
-- Who viewed this topic? https://meta.discourse.org/t/see-who-viewed-topic/29277/11
-- [params]
-- int :topic_id
SELECT tu.user_id, u.username, total_msecs_viewed/1000 AS seconds_viewed
FROM topic_users tu
JOIN users u ON tu.user_id = u.id
WHERE tu.topic_id = :topic_id
AND total_msecs_viewed > 0
GROUP BY tu.user_id, u.username, tu.total_msecs_viewed
ORDER BY tu.total_msecs_viewed desc
If …
2 Likes