Ninjastic
PostEdited versionsQuotes to this post
Post
Topic
Board Meta
Re: Analysis – Posts per month average for Merited members
by
LoyceV
on 10/08/2018, 17:06:01 UTC
Quote from: DdmrDdmr on August 09, 2018, 01:49:53 PM
a)  https://docs.google.com/spreadsheets/d/1fVkH12ZVS50LEJWG5WjuvLqdAB144zWxP0AIY3f5N2o/edit?usp=sharing
It contains all the users in segment '06. Negative' (not just Members, but Rank is included so it can be delimited by filtering).
There are very few cases there that have earned 9 or 10 merits in the past month and deleted a buch of posts, so I think it won’t really be useful to you.

b) https://docs.google.com/spreadsheets/d/1u9bgcvKRDJwCi4NsuxFKjo57pPPWXCD-crsBwBJwJhA/edit?usp=sharing
This file contains all users with 9 or 10 merits on their profile (as of last scrape 06/08/2018) and 9 or 10 merits derived from the cumulative merit.txt files (therefore, earned merits with no airdrop). The total is less than the amount you pointed to (I’ve got 1.672) , so there must be a criteria difference.
My list included all users who earned 9 or 10 Merit, including the ones who received a Merit airdrop. That explains the difference, you don't have this one for example:
89349: erwinbit (history)

Quote
The interesting column is the last one (MeritReceivedFromNUsers), since it tell us how many people have awarded each of these users with merit.
It's quite likely the Members who received 10 Merit from one user either got them from their alt, or bought them.