A member of our Discourse forum has asked if Discourse has a way to show/recognize consecutive days visiting in or posting in a Discourse forum. I don’t see that information anywhere in the admin’s user information, is it kept anywhere? FWIW, reddit has this feature.

[Screenshot 2025-01-29 at 8.02.06 PM] You can probably make a data explorer query. here is the user_visits table schema here: app/models/user_visit.rb d75a0b116 # == Schema Information # # Table name: user_visits # # id :integer not null, primary key # user_id :integer not null # visited_at :date not null # posts_read :integer default(0) # mobile :boolean default(FALSE) # time_read :integer default(0), not null # # Indexes # # index_user_visits_on_user_id_and_visited_at (user_id,visited_at) UNIQUE # index_user_visits_on_user_id_and_visited_at_and_time_read (user_id,visited_at,time_read) # index_user_visits_on_visited_at_and_mobile (visited_at,mobile) # maybe something like this? :thinking: WITH consecutive_visits AS ( SELECT user_id, visited_at, visited_at - INTERVAL '1 day' * ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY visited_at) AS grp FROM user_visits ), visit_streaks AS ( SELECT user_id, COUNT(*) AS streak_length FROM consecutive_visits GROUP BY user_id, grp ) SELECT user_id, MAX(streak_length) AS longest_streak FROM visit_streaks GROUP BY user_id ORDER BY longest_streak DESC LIMIT 100 or perhaps you could combine with the user_actions table instead (visits with likes and posts?), which is here: app/models/user_action.rb d75a0b116 # Table name: user_actions # # id :integer not null, primary key # action_type :integer not null # user_id :integer not null # target_topic_id :integer # target_post_id :integer # target_user_id :integer # acting_user_id :integer # created_at :datetime not null # updated_at :datetime not null # # Indexes # # idx_unique_rows (action_type,user_id,target_topic_id,target_post_id,acting_user_id) UNIQUE # idx_user_actions_speed_up_user_all (user_id,created_at,action_type) # index_user_actions_on_acting_user_id (acting_user_id) # index_user_actions_on_action_type_and_created_at (action_type,created_at) # index_user_actions_on_target_post_id (target_post_id) # index_user_actions_on_target_user_id (target_user_id) WHERE (target_user_id IS NOT NULL) This file has been truncated. show original

Thanks, I’ll keep that in mind.

Does Discourse track consecutive days active?

Community Building Data & reporting

NateDhaliwal (Nate Dhaliwal) January 30, 2025, 3:52am 2

Well, yes, as there are badges like Enthusiast, Aficionado, and Devotee that are for consecutive days visited. Visited = liked a post/replied once IIRC.

Topic		Replies	Views
How can I see how many days in a row I visited the forum? Product Support	2	1832	October 25, 2018
See how many days straight we've been on the forums Feature	4	858	August 15, 2023
Is there a log of user visits? Product Support	6	1705	October 27, 2018
Daily usage streak and badges (for building a habit) Feature	8	1526	October 13, 2017
'Seen in last X days' badge? Data & reporting sql-triggered-badge	12	373	August 26, 2016

Does Discourse track consecutive days active?

Related topics