New registrations

FredC

Well-known member
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.
 
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:

Screen shot 2010-12-27 at 9.17.08 AM.webp
 
Top Bottom