FredC Well-known member Dec 27, 2010 #1 Is there a way to keep track of new daily registrations? Id like to be able to keep track of how many new members register to my communities on a day by day basis.
Is there a way to keep track of new daily registrations? Id like to be able to keep track of how many new members register to my communities on a day by day basis.
Jake Bunce Well-known member Dec 27, 2010 #2 There is no such report in the current software. But here is a query you can run on your database: Code: SELECT COUNT(*) AS registrations, FROM_UNIXTIME(register_date, '%Y-%m-%d') AS date FROM xf_user GROUP BY date ORDER BY date This will generate results like this: Upvote 0 Downvote
There is no such report in the current software. But here is a query you can run on your database: Code: SELECT COUNT(*) AS registrations, FROM_UNIXTIME(register_date, '%Y-%m-%d') AS date FROM xf_user GROUP BY date ORDER BY date This will generate results like this:
R ragtek Guest Dec 27, 2010 #3 Sneak Preview: I hope that i can finish the UI tomorrow, then i'll release it here Upvote 0 Downvote
R ragtek Guest Dec 27, 2010 #4 First version is online Here we go: http://xenforo.com/community/threads/ragtek-registration-statistics.9689/ Upvote 0 Downvote
First version is online Here we go: http://xenforo.com/community/threads/ragtek-registration-statistics.9689/
Num7 Active member Dec 29, 2010 #5 That's a pretty cool mod Ragtek! I'll probably give it a try tonight. Thanks! Upvote 0 Downvote