Suggestion: Give Us Some Statistics

[Phillyman]

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.

[Robulosity2]

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

[AlexJ]

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. :)

[Robulosity2]

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.

[Michael]

You can also work out queries to run to pull these stats and save them in the Saved Queries app.

/shameless self-promotion