Stats on the Rank pipeline - How many are we on the way to ranking-up (II) ?

[DdmrDdmr]

1. Introduction.

Almost a year ago, I created a post on how the ranking-up pipeline looked like (see Stats on the Rank pipeline - How many are we on the way to ranking up? extension), and I thought that it may be interesting to create an updated version of the analysis to take a look at how things stand now.

Most of what I’ve included here can also be retrieved and followed with weekly updates on the Merit Dashboard, selecting the tabs labelled “Ranked-up” to see those that have ranked-up under the Merit System, and “Ranking-up Pipeline” to follow the core of this post dynamically.


2. Ranked-up under the Merit System

As a general context, the following is a summary of what I make as the amount of forum members that have ranked-up under the Merit System (needing at least 1 sMerit in the process):

 

What the table shows is that 13.229 people have ranked-up (as of last Friday), making it:

-   Legendary:       10 (from Hero Member).
-   Hero Member:   38 (22 from Sr. Member, 11 from Full Member and 5 from Member).
-   Sr. Member:     100 (63 from Full Member, 6 from Member, 1 from New Era Newbie and 30 from Old Era Newbie).
-   Full Member:    174 (84 from Member, 13 from New Era Newbie and 77 from Old Era Newbie).
-   Member:       3.183 (437 from New Era Newbie and 2.746 from Old Era Newbie).
-   Jr. Member:   9.724 (4.783 from New Era Newbie and 4.941 from Old Era Newbie).

One curios thing that stands out is that the number of accounts that have made it to Jr. Member are currently now nearly half and half between New Era Newbie (first merit >= 17/09/2018) and Old Era Newbie (first merit < 17/09/2018.). We could cross this data with last active to get some more insights, but that is not really the objective here.

A full list of the ranked-up members can be retrieved from the Merit Dashboard, but I’ve also provided an easier (static – i.e. not updated weekly) access here to the complete list of ranked-up forum members: https://docs.google.com/spreadsheets/d/1-Kt6olnf_vTnNXa-l_LVX2as3Rwz-K727OMForuAYDA/edit?usp=sharing .

Note that the column "started with" is sometimes slightly off when the person has been merited between the creation of the forum’s merit.txt file, and my profile scrape a few hours later.



3. Ranking-up pipeline - Summary

The ranking-up pipeline summary looks like this:
 

Out of the 27.147 merited profiles, 1.390 are not really in the ranking-up pipeline (Legendaries, staff, etc.), so we get a net of 25.757 profiles that are included in the ranking-up pipeline.
We could go a step further and discard profiles that have not logged in x months, but I don’t think it is worth doing that yet (besides, they may revive as accounts).

Out of those 25.757 profiles, 62,10% lack just the merits for ranking-up to their next level, 15,25% lack just the Activity, and 22,35% lack both. An additional 76 people are Heroes with the minimum activity (775) and the necessary merits (earned + airdropped), and whose formal conversion requires the activity to build a bit more and/or the ranking Legendary algorithm to kick-in.


4. Ranking-up pipeline – by Rank
The ranking-up pipeline summary by Rank looks like this:



The above gives us a breakdown of the table is section 3, by Rank. There’s a new segment category here, “3. Soon may rank up to Rank”, indicating that those people are within 20% of the required Merits and Activity (on both accounts) to reach their next rank. They are not the only ones, since those that are near the merit or goal rank individually are also near to their goal (more on that later on).

Interesting to see:

-   660 profiles would be legendries (or at least postulated at the minimum required activity threshold) with the old system, but not under the Merit System.

-   1.210 Sr. Members would have been Heroes under the old system.

-   2.657 Full Members would already be Sr. Members under the old meritless system.

-   4.460 Members would have been Full members by now under the old system.

-   7.009 Jr. Members would now be Members under the old system.

-   There are 3.284 Newbie accounts, with at least 1 Merit that have not ranked-up due to lack of activity. That is surprising, but there are likely causes such as nuked and being here for just to make a couple of questions or comments.


5. Ranking-up pipeline – by Rank and segment of Merits and Activity

This breaks down what we saw in the previous chart, in order to show us just how close or distant each profile is within a given segment, creating subsegment quintiles for Activity and Merits.
  
Hero and Sr. Member:

Notice how there are 607 (out of 660) Heroes that we can now see that have only somewhere between 40% and 60% of the Merit goal, while having the required activity. Only 10 profiles are very near their goal (activity >= 100% - minimum for Legendary; merits between 80% and 100%).
I’m not going to detail it all here, but the pattern is similar on all ranks.

Full Member:


Member and Jr. Member:


A complete list can be obtained here (second tab): https://docs.google.com/spreadsheets/d/1-Kt6olnf_vTnNXa-l_LVX2as3Rwz-K727OMForuAYDA/edit?usp=sharing.



6. Ranking-up pipeline – Next to rank-up (within 20% of goal in terms of Merit and activity)

Next Legendries:

Code:

user_id     name                               rank                NextRank            activity  merit     startedwith    segment_activity    segment_merit  url
1067333     micgoossens                        Hero Member         Legendary           630       1649      101            [80%..100%)         [>100%]        https://bitcointalk.org/index.php?action=profile;u=1067333
188198      Piggy                              Hero Member         Legendary           672       1234      250            [80%..100%)         [>100%]        https://bitcointalk.org/index.php?action=profile;u=188198
181806      HairyMaclairy                      Hero Member         Legendary           770       1219      251            [80%..100%)         [>100%]        https://bitcointalk.org/index.php?action=profile;u=181806
1000199     krogothmanhattan                   Hero Member         Legendary           686       1124      250            [80%..100%)         [>100%]        https://bitcointalk.org/index.php?action=profile;u=1000199
897509      xtraelv                            Hero Member         Legendary           644       1119      101            [80%..100%)         [>100%]        https://bitcointalk.org/index.php?action=profile;u=897509
107200      mOgliE                             Hero Member         Legendary           770       1115      1000           [80%..100%)         [>100%]        https://bitcointalk.org/index.php?action=profile;u=107200
406432      warningsigns                       Hero Member         Legendary           896       1082      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=406432
258048      bcmine                             Hero Member         Legendary           1013      1055      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=258048
351590      soulgate                           Hero Member         Legendary           938       1050      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=351590
94331       lavajumper                         Hero Member         Legendary           868       1026      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=94331
265513      NattyLiteCoin                      Hero Member         Legendary           914       1021      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=265513
361695      jiggytom                           Hero Member         Legendary           980       1016      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=361695
14716       rb1205                             Hero Member         Legendary           797       1016      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=14716
657268      Lionidas                           Hero Member         Legendary           1008      1012      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=657268
174939      punkrock                           Hero Member         Legendary           814       1010      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=174939
116332      IGHOR                              Hero Member         Legendary           960       1009      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=116332
493987      xRaVeNx                            Hero Member         Legendary           924       1009      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=493987
352642      fitraok09                          Hero Member         Legendary           938       1008      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=352642
3722        Unthinkingbit                      Hero Member         Legendary           932       1008      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=3722
415400      kken01                             Hero Member         Legendary           896       1007      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=415400
163494      EbonHawk                           Hero Member         Legendary           869       1007      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=163494
669062      Apriand                            Hero Member         Legendary           868       1007      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=669062
263267      xcbtrader                          Hero Member         Legendary           867       1006      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=263267
82566       No_2                               Hero Member         Legendary           839       1006      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=82566
8516        kangasbros                         Hero Member         Legendary           812       1006      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=8516
92246       Timetwister                        Hero Member         Legendary           992       1005      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=92246
153149      arallmuus                          Hero Member         Legendary           980       1005      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=153149
4248        keystroke                          Hero Member         Legendary           876       1005      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=4248
180891      kaene                              Hero Member         Legendary           784       1005      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=180891
73326       elbill                             Hero Member         Legendary           924       1004      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=73326
142966      principiante                       Hero Member         Legendary           840       1004      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=142966
161207      CosaNostra                         Hero Member         Legendary           836       1004      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=161207
146519      giveen                             Hero Member         Legendary           826       1004      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=146519
69553       C10H15N                            Hero Member         Legendary           810       1004      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=69553
1626        idev                               Hero Member         Legendary           1008      1003      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=1626
185404      illodin                            Hero Member         Legendary           966       1003      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=185404
112887      AzzAz                              Hero Member         Legendary           946       1003      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=112887
341982      mexxer-2                           Hero Member         Legendary           924       1003      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=341982
36319       SgtMoth                            Hero Member         Legendary           909       1003      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=36319
150593      valley365                          Hero Member         Legendary           896       1003      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=150593
130165      samsonn25                          Hero Member         Legendary           882       1003      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=130165
238821      david123                           Hero Member         Legendary           966       1002      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=238821
394642      Cripto DeD                         Hero Member         Legendary           952       1002      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=394642
182223      murderouskirk                      Hero Member         Legendary           938       1002      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=182223
106965      TracerX                            Hero Member         Legendary           918       1002      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=106965
183158      JorgeStolfi                        Hero Member         Legendary           910       1002      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=183158
339589      Atomicat                           Hero Member         Legendary           910       1002      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=339589
64396       Mapuo                              Hero Member         Legendary           905       1002      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=64396
223359      noise23                            Hero Member         Legendary           887       1002      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=223359
207035      bitcasino.io                       Hero Member         Legendary           866       1002      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=207035
119702      oddwh                              Hero Member         Legendary           854       1002      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=119702
100786      nwoolls                            Hero Member         Legendary           840       1002      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=100786
253843      Relaxedsense                       Hero Member         Legendary           809       1002      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=253843
102378      lukyforvar                         Hero Member         Legendary           796       1002      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=102378
321133      SuperClam                          Hero Member         Legendary           784       1002      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=321133
60653       CoinDiver                          Hero Member         Legendary           778       1002      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=60653
382626      ZACHM                              Hero Member         Legendary           777       1002      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=382626
4839        fornit                             Hero Member         Legendary           989       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=4839
230980      patmast3r                          Hero Member         Legendary           980       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=230980
34011       abracadabra                        Hero Member         Legendary           954       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=34011
380642      bennana                            Hero Member         Legendary           952       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=380642
400415      lestherat                          Hero Member         Legendary           943       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=400415
56297       Bitware                            Hero Member         Legendary           933       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=56297
166737      JuanHungLo                         Hero Member         Legendary           922       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=166737
17928       piuk                               Hero Member         Legendary           910       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=17928
365501      The Frisian                        Hero Member         Legendary           899       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=365501
103911      Mad_Max                            Hero Member         Legendary           896       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=103911
51908       Blazr                              Hero Member         Legendary           882       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=51908
17337       desired_username                   Hero Member         Legendary           867       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=17337
13672       filharvey                          Hero Member         Legendary           865       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=13672
451278      leps                               Hero Member         Legendary           859       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=451278
376375      Glucose                            Hero Member         Legendary           859       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=376375
537728      Unread                             Hero Member         Legendary           840       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=537728
390821      svetoch                            Hero Member         Legendary           826       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=390821
110699      BitJohn                            Hero Member         Legendary           826       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=110699
172727      jtoomim                            Hero Member         Legendary           818       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=172727
246704      snortex                            Hero Member         Legendary           815       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=246704
506438      rizzlarolla                        Hero Member         Legendary           798       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=506438
64847       DanielBTC                          Hero Member         Legendary           790       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=64847
232008      jsmit332                           Hero Member         Legendary           789       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=232008
107705      BTCtrader71                        Hero Member         Legendary           785       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=107705
29155       BkkCoins                           Hero Member         Legendary           784       1001      1000           [>100%]             [>100%]        https://bitcointalk.org/index.php?action=profile;u=29155
557989      BTCforJoe                          Hero Member         Legendary           882       971       500            [>100%]             [80%..100%)    https://bitcointalk.org/index.php?action=profile;u=557989
370611      bill gator                         Hero Member         Legendary           1008      945       500            [>100%]             [80%..100%)    https://bitcointalk.org/index.php?action=profile;u=370611
805820      Lafu                               Hero Member         Legendary           1092      918       501            [>100%]             [80%..100%)    https://bitcointalk.org/index.php?action=profile;u=805820
112493      Pmalek                             Hero Member         Legendary           882       918       501            [>100%]             [80%..100%)    https://bitcointalk.org/index.php?action=profile;u=112493
164749      stompix                            Hero Member         Legendary           1008      904       500            [>100%]             [80%..100%)    https://bitcointalk.org/index.php?action=profile;u=164749
225292      romanornr                          Hero Member         Legendary           674       900       550            [80%..100%)         [80%..100%)    https://bitcointalk.org/index.php?action=profile;u=225292
580327      eddie13                            Hero Member         Legendary           1064      855       500            [>100%]             [80%..100%)    https://bitcointalk.org/index.php?action=profile;u=580327
906023      poptop                             Hero Member         Legendary           798       849       500            [>100%]             [80%..100%)    https://bitcointalk.org/index.php?action=profile;u=906023
901859      buwaytress                         Hero Member         Legendary           924       838       502            [>100%]             [80%..100%)    https://bitcointalk.org/index.php?action=profile;u=901859
579628      bob123                             Hero Member         Legendary           840       831       250            [>100%]             [80%..100%)    https://bitcointalk.org/index.php?action=profile;u=579628
846936      sabotag3x                          Hero Member         Legendary           1050      820       500            [>100%]             [80%..100%)    https://bitcointalk.org/index.php?action=profile;u=846936

I can't get any more names on this post, so I've added the full list of Next ranking-members here (third tab called "Soon will rank-up"):  https://docs.google.com/spreadsheets/d/1-Kt6olnf_vTnNXa-l_LVX2as3Rwz-K727OMForuAYDA/edit?usp=sharing.

[coinlocket$]

Nice work, as usual, adding one note:

A cool thing to add could be a tab with these simple values:

A= N of users could be new X rank = Y
B= N of users ranked up to X rank = Z

% users ranked up B/A x 100= %

For example

-   660 profiles would be legendries (or at least postulated at the minimum required activity threshold) with the old system, but not under the Merit System.

This means =

%= 10/660*100= only 1.51% of potential legendaries has ranked up!

[LoyceV]

-   There are 3.284 Newbie accounts, with at least 1 Merit that have not ranked-up due to lack of activity. That is surprising, but there are likely causes such as nuked and being here for just to make a couple of questions or comments.

Those are the Newbies I send Merit to when I see them. Real users who aren't here to spam the forum shouldn't be restricted by the Merit system.

[tranthidung]

This means =

%= 10/660*100= only 1.51% of potential legendaries has ranked up!

It is normal figure, I think.
Most of Hero Members (airdropped Hero members) from the old era (before merit system) will not be able to move up to Legendary rank.
Over time, we will see the difference in pecentages of Hero Members ranked up to Legendaries between new and old era.
Who can rank up with new era, to become Legendary will be different.
Of course, there are still Legendaries from old era are outstanding guys in the forum.
Over time, the four clubs in my topic will mostly contain totally self-made users (by mentioning totally self-made users, I meant who started from zero to higher ranks)
[CLUBS] Top Merited-Users Classified into 4 Clubs

[DdmrDdmr]

<…>

It’s a good idea, although not too trivial to interpret. Nevertheless, I’ve gone ahead and given it a go (Added to the "Ranked-up" Tab).

It’s also not that easy to implement either on the Merit Dashboard, since data is at two different levels: The current rank in the pipeline and the current rank "+1" in the ranked-up data. Nevertheless, I’ve managed to include it by shifting the logic to SQL and having Tableau display a new simple additional source. The result should be therefore updated each week, and looks like this:



Note that the last column is a ratio, and not an exact conceptual percentage. For example, the 100 Full Members (that have ranked-up to Sr. Member) could also be included in the count for Sr. Members lacking merit to reach the Hero rank.

[cryptovigi]

Nice! It looks like I'm the only one Sr. Member from the New Era Newbie? If it's true, I would be very proud of myself - OP can you confirm that?

[edit:]
Sorry I haven't noticed spreadsheed attached... Just checked - IT'S ME 

[DdmrDdmr]

<..->

Correct as far as I can make it, as per the following definition:
New Era Newbie: First Merit >= 17/09/2018
Old Era Newbie: First Merit < 17/09/2018

From New Era Newbies up to Sr. Member you are (as of last Friday’s data - just checked the Merit Dashboard if anyone else had done so this week) the only one to have made it so far. Well done there!

In addition, there are 31 Old Era Newbies to have reached that rank.