Is there is any way to find the active users per day and to find the unique users per day ?
There are some great reports on your admin dashboard:
You can see a list of all system reports here:
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:
- 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!
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 ツ