I know the "email users" does some of this, but it only returns a list of emails and not userID's, and not in a nice format that I could leverage in Excel (like a CSV).
For example: I have a lot of member that don't have avatars. I'd love to see a list of all users that don't have avatars (there is an option in the "Notices" feature to target these users) and then send them a notice to load an avatar. I'd then run the report again to see how effective the notices were at getting people to load avatars.
- I want a list of all user ID's that have logged in during the past 60
- All member ID's that have at least 200 posts
- A list of # of posts per member for members that have been registered for at least 5 years
Also, if it is via the DB, is there a way to run queries from within the admin section vs. going into something link phpmyadmin?