In a forum in the early stages of growth, it feels handy to know who has recently made their first post. If I happen to see it, it has a little banner box. But if I don’t see that, is there any way to find the post? (The Admin interface tells me that there has been a new contributor.) I’ve looked…

Yes, it looks like Data Explorer is the answer. Specifically, this query from the linked github repo: Users with first post within period - SQL

Admin, Users, New is the main place.

Indeed, that gives me recent joiners, but not recent new contributors. (It’s fairly likely that a new contributor will have been a lurker for a while, so won’t be a new joiner.)

I think you need a plugin to do that.

It depends how you define “contributors”, I would argue that spending a lot of time reading and liking is also an important contribution. That’s why those stats appear on the Admin, Users, New list.

And very handy they are too. But the Admin dashboard and stats pages show a ‘new contributors’ graph, also handy, which is what caught my attention, and gave me the terminology.

You could do a data explorer search. There should be a similar example in the data explorer cool query topic.

Thanks @pfaffman - I thought that might be the answer although I’ve never delved into that world. [图片] (Superseded) What cool data explorer queries have you come up with? data & reporting This topic became too long to be easily searched and has been broken down into separ…

Hey @Ed_S , did you figure out a solution?

如何查找“新贡献者”？

支持

Ed_S (Ed S) 2023 年2 月 22 日 15:42 11

是的，看起来数据浏览器是答案。具体来说，是来自链接的 GitHub 存储库中的这个查询：

在特定时期内发布第一帖的用户 - SQL

Community Guide: Activating Lurkers

话题		回复	浏览量
Can I create a badge for 'new contributors'? Support	1	71	2025 年2 月 28 日
Dashboard Report - New Contributors Data & reporting dashboard-reports , sql-query , dashboard-sql	0	364	2024 年1 月 17 日
Tracking unique contributors Support	1	773	2020 年9 月 3 日
Add top contributors list Support	1	326	2021 年4 月 15 日
Is there a way to create a report on how many users posted new queries each month? Data & reporting sql-query	7	655	2023 年12 月 19 日

如何查找“新贡献者”？

相关话题