New User of the Month Algorithm Questions

[RGJ (Richard - Communiteq)]

@Turtle

having 1.1K likes with 700ish posts and 60ish solutions in two weeks is considered helpful on a forum or having 60ish likes and 40ish posts (in roughly the same amount of time) is considered more “new user of the month” material?

This is a very good point and I agree with you that the current algorithm might be too simplistic. I think a good first step would be to make the post factor nonlinear like

SUM(...) / SQRT(5 + COUNT(DISTINCT p.id))::float AS score

or maybe even

LN(1 + SUM(CASE ... END)) / (5 + COUNT(DISTINCT p.id))::float AS score