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 in all recently updated threads and don’t see the box. Can I search for all users with only 1 post? Or all users with only a few posts?

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

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. [image] (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 separate topics. If you have any questions about how to write a Data Explorer query, or have one to share, please start a new topic in the #data-reporting category and tag it with the #sql-query tag. +1 information_source For an alternative searchable list of queries that were in this topic, see @SidV’s query list on GitHub.

Hey @Ed_S, did you figure out a solution?

Can I find out who are 'new contributors'?

Product Support

codinghorror (Jeff Atwood) August 11, 2019, 12:00pm 2

Admin, Users, New is the main place.

Topic		Replies	Views
Can I create a badge for 'new contributors'? Product Support	1	143	February 28, 2025
Dashboard Report - New Contributors Data & reporting sql-query , dashboard-reports , dashboard-sql	0	415	January 17, 2024
Tracking unique contributors Product Support	1	816	September 3, 2020
Add top contributors list Product Support	1	369	April 15, 2021
Is there a way to create a report on how many users posted new queries each month? Data & reporting sql-query	7	791	December 19, 2023

Can I find out who are 'new contributors'?

Related topics