Hey,
Is there is any way to find the active users per day and to find the unique users per day ?
AI-generated summary
In a discussion about tracking active and unique users per day, Gaurav_Sardana asked how to extract this data directly from the database. jord8on first directed them to the built-in admin dashboard reports, particularly the âUser Visitsâ report, which shows daily active/unique user counts via customizable date ranges and visualizations. However, when Gaurav_Sardana clarified they wanted to identify which specific users were active â not just aggregate numbers â jord8on acknowledged this isnât available in standard reports. Later, jord8on suggested using the Data Explorer plugin, which allows custom SQL queries to extract user-level data. They shared a GitHub list of sample queries that may help retrieve the desired user-specific metrics. The conversation highlights that while high-level metrics are readily available, granular user identification requires plugin-based SQL querying.
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!
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 ![]()
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!
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 which I think might be the key to what you are looking for:
And here is a list of SQL queries you can use with the data explorer plugin:
Specifically, hereâs a couple of queries that might give you (us) what you (we) want ă

