# Can I find out who are 'new contributors'?

**URL:** https://meta.discourse.org/t/can-i-find-out-who-are-new-contributors/125461
**Category:** Support
**Created:** [August 11, 2019, 11:45am UTC](https://meta.discourse.org/t/can-i-find-out-who-are-new-contributors/125461 "2019-08-11T11:45:45Z")
**Posts on this page:** 12
**Page:** 1

<div class="post-metadata">

### Author: ![Ed\_S](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/ed_s/32/134015_2.png) [@Ed\_S](https://meta.discourse.org/u/Ed_S)
#### Post date: [August 11, 2019, 11:45am UTC](https://meta.discourse.org/t/can-i-find-out-who-are-new-contributors/125461/1 "2019-08-11T11:45:45Z")

</div>

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?

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [August 11, 2019, 12:00pm UTC](https://meta.discourse.org/t/can-i-find-out-who-are-new-contributors/125461/2 "2019-08-11T12:00:14Z")

</div>

Admin, Users, New is the main place.

---

<div class="post-metadata">

### Author: ![Ed\_S](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/ed_s/32/134015_2.png) [@Ed\_S](https://meta.discourse.org/u/Ed_S)
#### Post date: [August 11, 2019, 12:24pm UTC](https://meta.discourse.org/t/can-i-find-out-who-are-new-contributors/125461/3 "2019-08-11T12:24:12Z")

</div>

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.)

---

<div class="post-metadata">

### Author: ![hawm](https://avatars.discourse-cdn.com/v4/letter/h/f07891/32.png) [@hawm](https://meta.discourse.org/u/hawm)
#### Post date: [August 11, 2019, 12:34pm UTC](https://meta.discourse.org/t/can-i-find-out-who-are-new-contributors/125461/4 "2019-08-11T12:34:38Z")

</div>

I think you need a plugin to do that.

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [August 11, 2019, 1:46pm UTC](https://meta.discourse.org/t/can-i-find-out-who-are-new-contributors/125461/5 "2019-08-11T13:46:06Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![Ed\_S](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/ed_s/32/134015_2.png) [@Ed\_S](https://meta.discourse.org/u/Ed_S)
#### Post date: [August 11, 2019, 2:20pm UTC](https://meta.discourse.org/t/can-i-find-out-who-are-new-contributors/125461/6 "2019-08-11T14:20:29Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [August 11, 2019, 3:28pm UTC](https://meta.discourse.org/t/can-i-find-out-who-are-new-contributors/125461/7 "2019-08-11T15:28:34Z")

</div>

You could do a [data explorer](https://meta.discourse.org/t/32566?silent=true) search. There should be a similar example in the [data explorer](https://meta.discourse.org/t/32566?silent=true) cool query topic.

---

<div class="post-metadata">

### Author: ![Ed\_S](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/ed_s/32/134015_2.png) [@Ed\_S](https://meta.discourse.org/u/Ed_S)
#### Post date: [August 11, 2019, 4:48pm UTC](https://meta.discourse.org/t/can-i-find-out-who-are-new-contributors/125461/8 "2019-08-11T16:48:56Z")

</div>

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?](https://meta.discourse.org/t/what-cool-data-explorer-queries-have-you-come-up-with/43516):
>
> 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](https://meta.discourse.org/t/32566?silent=true) query, or have one to share, please start a new topic in the #data-reporting category and tag it with the #sql-query tag. +1information_source For an alternative searchable list of queries that were in this topic, see @SidV’s [query list on GitHub](https://github.com/SidVal/discourse-data-explorer/blob/queries/querys.md).

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [February 21, 2023, 8:58pm UTC](https://meta.discourse.org/t/can-i-find-out-who-are-new-contributors/125461/9 "2023-02-21T20:58:21Z")

</div>



---

<div class="post-metadata">

### Author: ![Canapin](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/canapin/32/119591_2.png) [@Canapin](https://meta.discourse.org/u/Canapin)
#### Post date: [February 22, 2023, 3:06pm UTC](https://meta.discourse.org/t/can-i-find-out-who-are-new-contributors/125461/10 "2023-02-22T15:06:03Z")

</div>

Hey @Ed_S, did you figure out a solution?

---

<div class="post-metadata">

### Author: ![Ed\_S](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/ed_s/32/134015_2.png) [@Ed\_S](https://meta.discourse.org/u/Ed_S)
#### Post date: [February 22, 2023, 3:42pm UTC](https://meta.discourse.org/t/can-i-find-out-who-are-new-contributors/125461/11 "2023-02-22T15:42:14Z")

</div>

Yes, it looks like [Data Explorer](https://meta.discourse.org/t/32566?silent=true) is the answer. Specifically, this query from the linked github repo:

- Users with first post within period - [SQL](https://github.com/SidVal/discourse-data-explorer/blob/queries/queries/users-first-post-period.sql)

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [March 24, 2023, 3:42pm UTC](https://meta.discourse.org/t/can-i-find-out-who-are-new-contributors/125461/12 "2023-03-24T15:42:59Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
