Is there a way to find out who has posted the most over the last 30 days? Basically would be the Admin->Users-> active user list but with a filter of a month?

Would the user directory help here? Eg https://meta.discourse.org/u?order=post_count&period=monthly It won’t be as accurate as a data explorer query, but it may suffice? You can select the period, click on the column headers to add a sort, filter by group, and even add extra columns using the wre…

Hello, welcome :wave: This query should help: --[params] --date :start_date = 2024-01-01 --date :end_date = 2024-02-01 --int :top = 10 SELECT u.id AS user_id, COUNT(*) Count FROM posts AS p INNER JOIN users AS u on p.user_id = u.id INNER JOIN topics AS t ON t.id = p.topic_id AND t.deleted_…

So looking up how to run a SQL Query, I need a plug in that is at a more expensive plan, since we are pretty small, I don’t think that access to SQL queries would worth the 3x cost. So for us, I guess the answer is, no we can’t do it.

Wow, how did I miss this? Thanks, Jammy. :smile:

How to find the most active users over the last month

Community Building Data & reporting

AaronW (Aaron) March 4, 2024, 8:13pm 6

Thanks, not sure how I missed that too.

Topic		Replies	Views
How many active users last month? Data & reporting	13	4923	December 14, 2020
Active users for specific months Data & reporting sql-query	5	1704	October 17, 2016
Active users in the last 30 days Data & reporting sql-query	3	470	September 5, 2016
Top X posters in a given timeframe Data & reporting sql-query	3	284	May 28, 2024
Users who posted the most X months ago & how many users in total have posted within that time period Data & reporting sql-query	0	190	July 8, 2019

How to find the most active users over the last month

Related topics