Post
Topic
Board Meta
Merits 4 from 3 users
Re: [Merit Analysis] Users ranked Sr. Member & up that have not earned any merit
by
cryptovigi
on 04/10/2018, 00:17:36 UTC
⭐ Merited by DdmrDdmr (2) ,vlad230 (1) ,taikuri13 (1)

1. How many Sr. Member & up users exist that have not earned any merit?
Code:
1078 Sr. Members
476 Hero Members
224 Legendary Members
There are 1778 users ranked Sr. Member & up that have not earned any merit, they just got "airdropped" merit from when the merit system was implemented.
...

As you know I was the one who challenged vlad230 to make this analysis.

Unfortunately I’ve read that this results due to a limited only data source (only given and received merits) its results may be far from the reality.
I was really interested in the results, so I was looking for a way to make this analysis in a more appropriate way. I didn’t find a database which contains all users who was airdropped a merit, I didn’t find also a database with current number of users and their ranks and the number of merits held…. But I found some further threads by mazdafunsun who scraped first 2 million users of Bitcointalk in July this year https://bitcointalk.org/index.php?topic=4901670.0;all and decided to take take this numbers to make some comparison….

I took this number than checked how many users has ranked up since July. To check it I took all users who has received any merit from https://albertoit.github.io/Merit-Explorer-SQL/ than checked current merit number on the bitcointalk.com site. After deduction I got the number of airdropped merit to each user (who have received at least one merit). Then I checked once again on merit explorer number of merit given till July. Thanks to that I was able to correct mazdafunsun’s result with rank promotions
by merit since July (there still be some inaccuracy because probably some users has been promoted since July by activity, unfortunately I have no way to check it...)

After comparing these results with given merit in merit explorer I’ve received such set of data:

Rank                       number of users      number of users      
received at least
1 merit

number of users      
with who didn’t
earn any merit

Member27 9184 744 (17%)23 174  (83%)
Full Member18 1813 173 (17,45%)15 008  (82,55%)
Sr. Member9 0161 818 (20,16%)7 198  (79,84%)
Hero Member4 1431 105 (26,67%)3 038  (73,33%)
Legendary2 1451 133 (52,82%)1 012  (47,18%)

As you can see, my results differ significantly from vlad230's and the numbers are few times bigger.

@vlad230: I think that case you should update numbers or description in your opening post...

It looks like there are really plenty of high ranked users who hasn't earn even one merit yet. Probably some of them are "dead souls" - users who aren't active for many month or even years, but for sure there are as well a lot of "ranked" users who simply didn't deserved any merit yet. This number decreases (percentage) with the increase of rhe rank, but its level in all groups (maybe exept Legendary) remains high.

So  guys look at these numbers and be little more lenient for newbies and jr. members  as you see the rank not always it determines their value...