Identifying Top Contributors to LET
IWe've been evaluating ways to award a Top Contributor tag on a monthly or quarterly basis to those who contribute the most to the forum. There isn't a Vanilla plugin for this - I'm just doing analysis in the DB via SQL.
Vanilla provides the following metrics that we could use:
number of threads started by the user
number of comments by the user
amount of text the user posted. This is just a raw statistic - it doesn't differentiate between quoted text, posting a long command output, etc.
number of comments in threads the user started
number of views of the user's threads
number of thanks the user received
The first three are more quantity; the last two are more about quality.
The question is what formula to use to compute a score using these statistics. A few filters would be used:
moderators, admins, banned people, etc. are not eligible and their scores are filtered out, though their comments in threads, thanks given, etc. would still count towards other eligible users' scores.
flag reports, dumped threads, etc. are filtered out
threads, comments, and thanks in Offers and Shared Hosting Offers categories are filtered out. This is to prevent providers from dominating the results. Yes, providers' posts are valuable but their reward is business...we're trying to acknowledge people who participate for non-commercial reasons.
I have some ideas for a scoring formula but I thought I'd ask the community for their advice. Thoughts? To me, the number of thanks, number of views generated (divided by some scaling factor, otherwise it will outweigh everything), and number of comments in discussions are the most important factors, though this does weigh things in favor of those who start discussions.
Some statistics (with the above-mentioned filters applied) based on August + September 2021.
MIN MAX AVG STDEV num_comments 0 342 9.5 25.4 num_discussions 0 13 0.3 .8 num_comments_in_discussions 0 611 5.7 26.4 num_views_generated 33 61200 786.8 2947.5 num_thanks 0 271 5.2 19.9 total_length_of_posts 0 292738 3674.8 13476.2 thanks_per_comment 0 8 .3 .6