Hello, I would like to know: How long do users stay on the page of specific topic? Can I get the information from post_timings table? or should I take it from other source? Where can I find the data of users who have posted new topic?- [image] Where can I get the country of the user? Thanks in advance

I assume you have Data Explorer installed. [image] Maayan Mizrahi: How long do users stay on the page of specific topic? Can I get the information from post_timings table? or should I take it from other source? It looks like you can get it from post_timings: select topic_id, count(user_id) users, round(sum(msecs/(60*1000.0)),2)/count(user_id) avg_minutes from post_timings group by topic_id order by avg(msecs) desc I should note that only includes people who registered. You might want to use Google Analytics to get all readers. [image] Maayan Mizrahi: Where can I find the data of users who have posted new topic? I’m not sure what data you are looking for. Here’s how to find each user’s first post: select p.id post_id from posts p where p.id = (select min(id) from posts where user_id = p.user_id) Add and post_number = 1 if you want to find users who started by posting a new topic rather than starting by replying to an existing topic. Not sure if either of these are helpful. [image] Maayan Mizrahi: Where can I get the country of the user? People can enter their location, which might even be recognizable as a country: select user_id, location from user_profiles In my experience, people don’t usually bother. So Google Analytics might be more useful. There’s also ip_address in the users table, which can be used to look up location data.

How to find how long a user has viewed a topic/who has posted new topics/country of users

Community Building Data & reporting

Maayan_Mizrahi (Maayan Mizrahi) December 6, 2023, 11:16am 3

Thank you @jericson ! this is helpful

Topic		Replies	Views
For one topic, how do I see who read it and see the location of the users? Product Support	1	348	February 22, 2024
Recently Read Topics by User Data & reporting sql-query	0	197	May 4, 2016
How many viewers viewed a topic during a certain period? Data & reporting	3	1253	September 15, 2021
Record time_read in user_visits? Product Support	3	1389	April 22, 2017
How does post tracking work in Discourse Development dev-news	4	4343	April 24, 2019

How to find how long a user has viewed a topic/who has posted new topics/country of users

Related topics