Post
Topic
Board Meta
Re: Analysis – Posts per month average for Merited members
by
LoyceV
on 09/08/2018, 11:39:38 UTC
(quote taken from your deleted thread, now there's more to read again Cheesy)
What I’ve initially done is compare the database snapshots on merited user profiles for 06/08/2018 and 06/07/2018. I wanted to see how much people post on average on a daily basis for the month between the two snapshot dates.
~
I guess we wanted to see the list of posters in the "very heavy" user segment, so here it goes (NewPost -> number of posts in a month):
Code:
user_id   name                     rank                NewPost   merit     NewMerit    url
"NewMerit" in your table is the total amount of Merit earned since its introduction, until last Friday. Shouldn't that be the amount of Merit earned in the period between those two profile snapshots? This has been fixed.

a surprisingly high 17,77% have a decrement their post count during the month.
My guess would be Mods are more active lately cleaning up Spam Megathreads.

Quote
That is quite a lot, even more so considering that we’re talking about merited users.
Two days ago, I realized almost all 2053 accounts with exactly 10 Merit must have been Merit trading. I think I'll make a thread on this later, that's a very large percentage of all new Member accounts.
And if that's true, it doesn't surprise me many of them lose posts when Spam Megathreads are deleted.

Can you get me a list of all 1033 Member accounts that lost posts? I'd like to cross-reference them to the ones that earned exactly 10 Merit.