Voor één onderwerp, hoe zie ik wie het heeft gelezen en de locatie van de gebruikers?

[kenjdarhan (Ken)]

I want to make statistics on the usefulness of topics by seeing what users have read each topic and where in the world are the users at.

Is it possible?

Thanks for any help.

[Lilly (Lillian)]

You can get some of this info using Data Explorer.

There are a number of queries in the data & reporting category. But, note that the topic_views table only records the first view by a user. Here’s a related query:

See who viewed topic

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 …