Phillyman Posted March 3, 2010 Share Posted March 3, 2010 I would really appreciate it if the Invision Gods gave us the ability to see some core statistics about our forums. How many members do you have? What percentage of members have posted? How many PM Messages are in the system? How many members have been active within the past 7 days How many members have been active within the past month How many members have been active within the past 6 months Who is the most ignored member Top 10 most viewed topics on our forum Top 10 most replied topics on our forum Average replies per topic Average views per topic Really the ideas are endless, but many of these stats will help out with organization and how to handle future changes. Link to comment Share on other sites More sharing options...
Robulosity2 Posted March 3, 2010 Share Posted March 3, 2010 The most general report's are already included with the product, although some of these I can see as being an added bonus all of them can be done via MySQL > CSV and importing into excel for a report Link to comment Share on other sites More sharing options...
AlexJ Posted March 3, 2010 Share Posted March 3, 2010 can be done via MySQL > CSV and importing into excel for a report A little how (SQL queries + exporting to CSV) to will help for newbies like me. Thank you. :) Link to comment Share on other sites More sharing options...
Robulosity2 Posted March 3, 2010 Share Posted March 3, 2010 Depends if you want it automated (which could be done via Cron etc) The biggest issue here would be translated If you're just going to dump the tables its the below ones (unsure of which one has the who's ignored table..) the only issue here is you need to know the formatting for dates (e.g 1205035954) Table: ibf_members joined last_visit last_activity msg_count_total temp_ban ignored_users subs_pkg_chosen members_editor_choice members_display_name members_profile_views member_banned Table: ibf_message_posts msg_id msg_author_id msg_is_first_post I'm not going to go through typing out the MySQL Queries to do each of these, but as I said CSV is a powerful tool and so is Macro'ing. Link to comment Share on other sites More sharing options...
Michael Posted March 3, 2010 Share Posted March 3, 2010 You can also work out queries to run to pull these stats and save them in the Saved Queries app. /shameless self-promotion Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.