Hey,
Is there is any way to find the active users per day and to find the unique users per day ?
1 Like
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!
5 Likes
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 
1 Like
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!
3 Likes
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 ă
5 Likes