I intend to do some house cleaning on my discourse install. I want to identify two similar types of users: Inactive users without posts (pre-Discourse signups) Active users without posts and excessive read times (lurkers) I am going to get rid of #1s and seek creative ways to reach out to the #2…

Sure @techapj can you suggest some data explorer queries that might help here?

[imagem] will_io: Inactive users without posts (pre-Discourse signups) SELECT u.id, u.username_lower AS "username", u.created_at, u.last_seen_at FROM users u WHERE u.active = false ORDER BY u.id Note: Since inactive users can’t create posts, we do not need to check for posts…

Possibly worth adding these queries to the “stock queries” that ship with data explorer

Queries for inactive and active users?

Product Support

rishabh Dezembro 28, 2018, 6:51am 9

I modified the second query to accept a parameter and added both queries in:

https://github.com/discourse/discourse-data-explorer/commit/7de1e5a68e1ddd1ca894c054647dc5da54a700c6

Tópico		Respostas	Visualizações
Data explorer query for all active users (Lurkers + Posters) Data & reporting sql-query	5	1084	25 de Novembro de 2024
"clean up inactive users after days" meaning and statistics Data & reporting	3	187	14 de Novembro de 2024
How to measure active users? Data & reporting sql-query	15	5111	6 de Março de 2025
Automatic/Bulk deleting inactive users Feature	13	1476	4 de Maio de 2019
How to find the most active users over the last month Data & reporting	5	801	4 de Março de 2024

Queries for inactive and active users?

Tópicos relacionados