August 11, 2019, 11:45am
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?
Admin, Users, New is the main place.
August 11, 2019, 12:24pm
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.)
August 11, 2019, 12:34pm
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.
August 11, 2019, 2:20pm
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.
August 11, 2019, 3:28pm
You could do a data explorer search. There should be a similar example in the data explorer cool query topic.
August 11, 2019, 4:48pm
@pfaffman - I thought that might be the answer although I’ve never delved into that world.
Continuing the discussion from
Data Explorer Plugin:
For a searchable list of queries in this topic, see @SidV’s query list on GitHub.
This topic has become too long to be easily searched. If you have questions about how to write a Data Explorer query, start a new topic in the #support category and tag it with data-explorer.
Here’s a couple I’m starting with:
Users Last Seen Since (Since N Weeks Ago)
with intervals as (
n as start_time,
(Coin-coin le Canapin)
February 22, 2023, 3:06pm
@Ed_S, did you figure out a solution?
February 22, 2023, 3:42pm
Yes, it looks like
Data Explorer is the answer. Specifically, this query from the linked github repo:
Users with first post within period -
March 24, 2023, 3:42pm
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.