# Active users per day
**URL:** https://meta.discourse.org/t/active-users-per-day/143724
**Category:** Data & reporting
**Created:** [March 9, 2020, 5:36pm UTC](https://meta.discourse.org/t/active-users-per-day/143724 "2020-03-09T17:36:24Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Gaurav\_Sardana](https://meta.discourse.org/u/Gaurav_Sardana)
#### Post date: [March 9, 2020, 5:36pm UTC](https://meta.discourse.org/t/active-users-per-day/143724/1 "2020-03-09T17:36:24Z")
Hey,
Is there is any way to find the active users per day and to find the unique users per day ?
---
### Author:  [@jord8on](https://meta.discourse.org/u/jord8on)
#### Post date: [March 9, 2020, 6:04pm UTC](https://meta.discourse.org/t/active-users-per-day/143724/2 "2020-03-09T18:04:17Z")
There are some great reports on your admin dashboard:
`https://YOUR_SITE_NAME/admin/dashboard/`
You can see a list of all system reports here:
`https://YOUR_SITE_NAME//admin/dashboard/reports`
I think the “User Visits” report will give you what you’re looking for in terms of active users per day.
- This link will let you see, over a week, or change the date range to be for one day:
- `https://YOUR_SITE_NAME/admin/reports/visits?end_date=2020-03-09&start_date=2020-02-09`
- You can also use the two toggle buttons to see a line graph or individual daily numbers:
- 
I would suspect that those numbers, in that Users report, are “unique users per day”
On your main dashboard you can scroll down, on the left and reference some great quick stats:
I hope this points you in the right direction @Gaurav_Sardana!
---
### Author:  [@Gaurav\_Sardana](https://meta.discourse.org/u/Gaurav_Sardana)
#### Post date: [March 9, 2020, 6:07pm UTC](https://meta.discourse.org/t/active-users-per-day/143724/3 "2020-03-09T18:07:58Z")
I already aware of this metric. But what if need to find this unique user from my database ?
I didn’t find any table where we can find this metric. Can you please help me out 🙂
---
### Author:  [@jord8on](https://meta.discourse.org/u/jord8on)
#### Post date: [March 9, 2020, 6:28pm UTC](https://meta.discourse.org/t/active-users-per-day/143724/4 "2020-03-09T18:28:32Z")
Ahh, so it sounds like you are wanting to know WHO those actual unique users are, instead of just knowing a number? If that’s the case then I don’t know the answer… but am also interested to know!
---
### Author:  [@jord8on](https://meta.discourse.org/u/jord8on)
#### Post date: [March 13, 2020, 8:10pm UTC](https://meta.discourse.org/t/active-users-per-day/143724/6 "2020-03-13T20:10:16Z")
Hey @Gaurav_Sardana,
I just noticed that most of the out-of-the-box reports are number based. There are only two or three reports that focus on listing users instead of numbers.
I just found the [data explorer plugin](https://meta.discourse.org/t/data-explorer-plugin/32566) which I think might be the key to what you are looking for:
And [here is a list of SQL queries](https://github.com/SidVal/discourse-data-explorer/blob/queries/querys.md) you can use with the [data explorer](https://meta.discourse.org/t/32566?silent=true) plugin:
Specifically, here’s a couple of queries that might give you (us) what you (we) want ツ
