How to track which users viewed a particular topic?

[Monika_Gupta]

How can we track the ‘list of users’ who viewed a particular topic??

[EricGT]

Two caveats I would make, or at least in my particular need, would be that it would also have to be granular down to the post, and it would need a minimum length of time the post was viewed.

While I don’t need a user friendly GUI as I suspect that having admin access to the PostgreSQL database, a query cold be run.

[Mevo]

Answer from Hawk in another topic which probably also answers yours:

@HAWK

Hook up Google Analytics and you’ll be able to get more granular info about user journeys.

If you do this, there may be a cookie acceptation matter to take care of, though.

[mcwumbly (Dave McClure)]

@EricGT

While I don’t need a user friendly GUI as I suspect that having admin access to the PostgreSQL database, a query cold be run.

Yes, and…

This could be done with #plugin:data-explorer

[EricGT]

@mcwumbly

This could be done with #plugin:data-explorer

Thanks.

While I don’t have access to Data Explorer did some checking of the quires and found

Topic Reads by Date

or like a reverse index
Is it possible to see the topics a user has viewed?

IIRC there is another topic that list useful Data Explorer quires but I can’t find it at the moment.

[mcwumbly (Dave McClure)]

It looks like that post you linked to has an example, in fact:

@ditatompel

Who (logged in user) view specific topic

-- [params]
-- 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)]

Also related:

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.

And:

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…