Analysis – Posts per month average for Merited members

[DdmrDdmr]

1.   Introduction

I wanted to see posting habits of forum members (volume wise) in general. In order to do so, we either need the complete posting history (no way I’m going to scrape that), or a couple of database snapshots to compare. The information that I keep track of is all related to members that have at least been awarded 1 sMerit, so that is the base for the following study.

What I’ve done is play around with 3 merited user profile snapshot databases:
-   06/08/2018 (normally it should have been 03/08/2018, but I was away for a few days).
-   06/07/2018
-   08/06/2018
Now using these three snapshots, we can derive some interesting information concerning posting volumes, associated ranks and merit.

On this occasion, the information is presented in tabular mode, since graphics seem more difficult to follow and I have discarded them in favour of tables.


2.   Posting Segment distribution

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. After studying the information, I derived the following segments:

01. Very Heavy:      >= 5 posts per day during the last month.
02. Heavy:            >= 3 and <5 posts per day during the last month.
03. Mid:                >= 1 and <3 posts per day during the last month.
04. Low:              >0 and <1 posts per day during the last month.
05. Zero:              0 posts   per day during the last month.
06. Negative:       <0 posts per day during the last month (deleted greater than created).
07. New to Merit:   They appear on the 06/08/2018 snapshot, but not on 06/07/2018 snapshot (therefore, cannot derive incremental posts).

We could argue on the segment definitions, buy I find them adequate after studying the data.The distribution of merited users according to this distribution is as follows:



What’s interesting to see is that there are 198 heavy users making >= 5 posts per day on average (more on that later).
In order to rank-up, on the activity side, we should be creating an average of 1 post per day. Nevertheless, only 20,74% of merited users do that (segments 01, 02 and 03). What’s more, 28,06% have not posted during the last month (holiday break?), and a surprisingly high 17,77% have a decrement their post count during the month. That is quite a lot, even more so considering that we’re talking about merited users.

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; NewMerit-> in 1 month):

Code:

user_id   name                     rank                NewPost   merit     NewMerit  url
1176794   ChiNgadOr                Full Member         1130      119       0         https://bitcointalk.org/index.php?action=profile;u=1176794
1068464   Xal0lex                  Staff               954       225       31        https://bitcointalk.org/index.php?action=profile;u=1068464
1719931   Custterol                Jr. Member          725       2         0         https://bitcointalk.org/index.php?action=profile;u=1719931
1773383   tumis                    Jr. Member          550       1         0         https://bitcointalk.org/index.php?action=profile;u=1773383
1302577   Ardipwnz                 Member              546       13        0         https://bitcointalk.org/index.php?action=profile;u=1302577
1016855   JollyGood                Sr. Member          541       254       1         https://bitcointalk.org/index.php?action=profile;u=1016855
846936    sabotag3x                Hero Member         537       738       36        https://bitcointalk.org/index.php?action=profile;u=846936
808310    batang_bitcoin           Hero Member         531       522       0         https://bitcointalk.org/index.php?action=profile;u=808310
105963    cybergamp                Member              447       10        0         https://bitcointalk.org/index.php?action=profile;u=105963
1432468   mdayonliner              Full Member         446       239       56        https://bitcointalk.org/index.php?action=profile;u=1432468
2078      dorianm421               Member              427       10        0         https://bitcointalk.org/index.php?action=profile;u=2078
105347    piter66                  Member              418       16        0         https://bitcointalk.org/index.php?action=profile;u=105347
1394080   sergeykravcov177         Member              417       10        0         https://bitcointalk.org/index.php?action=profile;u=1394080
1616894   perova93                 Member              410       10        4         https://bitcointalk.org/index.php?action=profile;u=1616894
106029    cdousley                 Member              409       10        0         https://bitcointalk.org/index.php?action=profile;u=106029
245285    sunce33                  Hero Member         406       505       0         https://bitcointalk.org/index.php?action=profile;u=245285
1083073   ismart1                  Full Member         391       115       0         https://bitcointalk.org/index.php?action=profile;u=1083073
1268261   o.ogurlu                 Member              382       12        0         https://bitcointalk.org/index.php?action=profile;u=1268261
1512010   zelenkova                Member              378       10        0         https://bitcointalk.org/index.php?action=profile;u=1512010
1838442   Tapai manis              Jr. Member          372       1         0         https://bitcointalk.org/index.php?action=profile;u=1838442
2036758   CryptAssist              Jr. Member          366       3         0         https://bitcointalk.org/index.php?action=profile;u=2036758
64507     philipma1957             Legendary           360       1276      23        https://bitcointalk.org/index.php?action=profile;u=64507
143168    TheQuin                  Hero Member         358       650       24        https://bitcointalk.org/index.php?action=profile;u=143168
956126    KingScorpio              Sr. Member          354       270       5         https://bitcointalk.org/index.php?action=profile;u=956126
1265536   dimon_btc11              Member              338       11        0         https://bitcointalk.org/index.php?action=profile;u=1265536
1112165   Sveta74189               Full Member         330       106       2         https://bitcointalk.org/index.php?action=profile;u=1112165
459836    LoyceV                   Legendary           329       1651      95        https://bitcointalk.org/index.php?action=profile;u=459836
1178986   rahul10948               Full Member         326       114       0         https://bitcointalk.org/index.php?action=profile;u=1178986
625576    hendrakhow               Member              326       11        0         https://bitcointalk.org/index.php?action=profile;u=625576
819237    gabmen                   Hero Member         319       523       0         https://bitcointalk.org/index.php?action=profile;u=819237
1533028   denis-z12                Member              308       97        8         https://bitcointalk.org/index.php?action=profile;u=1533028
1215537   Arrrvin                  Member              304       40        3         https://bitcointalk.org/index.php?action=profile;u=1215537
1000199   krogothmanhattan         Sr. Member          301       694       35        https://bitcointalk.org/index.php?action=profile;u=1000199
1412697   vanilaice                Jr. Member          300       2         0         https://bitcointalk.org/index.php?action=profile;u=1412697
114706    mymenace                 Legendary           297       1057      17        https://bitcointalk.org/index.php?action=profile;u=114706
1257516   Rosewater Foundation     Full Member         296       194       37        https://bitcointalk.org/index.php?action=profile;u=1257516
1659648   First77                  Member              289       31        2         https://bitcointalk.org/index.php?action=profile;u=1659648
1239025   zorchy                   Member              287       10        0         https://bitcointalk.org/index.php?action=profile;u=1239025
1297193   johnywalkerrr            Member              286       11        0         https://bitcointalk.org/index.php?action=profile;u=1297193
1202061   chimk                    Full Member         284       174       19        https://bitcointalk.org/index.php?action=profile;u=1202061
2161892   juraangel                Jr. Member          283       1         0         https://bitcointalk.org/index.php?action=profile;u=2161892
1464627   cryptohipo               Jr. Member          280       1         0         https://bitcointalk.org/index.php?action=profile;u=1464627
883221    termion                  Hero Member         279       531       0         https://bitcointalk.org/index.php?action=profile;u=883221
698159    Jet Cash                 Legendary           276       1091      102       https://bitcointalk.org/index.php?action=profile;u=698159
1138114   SalmanMJ9                Member              270       12        0         https://bitcointalk.org/index.php?action=profile;u=1138114
382413    xandry                   Staff               270       1023      1         https://bitcointalk.org/index.php?action=profile;u=382413
155345    gentlemand               Legendary           267       1198      22        https://bitcointalk.org/index.php?action=profile;u=155345
511692    BitcoinTurk              Full Member         267       205       8         https://bitcointalk.org/index.php?action=profile;u=511692
1411023   virendarnagpal           Jr. Member          266       4         2         https://bitcointalk.org/index.php?action=profile;u=1411023
181806    HairyMaclairy            Hero Member         266       549       54        https://bitcointalk.org/index.php?action=profile;u=181806
994859    CryptoBry                Sr. Member          266       272       1         https://bitcointalk.org/index.php?action=profile;u=994859
1333278   mycrypto93               Jr. Member          263       3         0         https://bitcointalk.org/index.php?action=profile;u=1333278
395583    aidit45@gmail.com        Sr. Member          262       251       0         https://bitcointalk.org/index.php?action=profile;u=395583
1417140   sashulya7979             Member              261       10        0         https://bitcointalk.org/index.php?action=profile;u=1417140
1077525   arun9900                 Full Member         259       101       0         https://bitcointalk.org/index.php?action=profile;u=1077525
557798    TryNinja                 Hero Member         258       707       35        https://bitcointalk.org/index.php?action=profile;u=557798
1179426   hasyurt                  Full Member         257       111       3         https://bitcointalk.org/index.php?action=profile;u=1179426
1067333   micgoossens              Sr. Member          256       520       117       https://bitcointalk.org/index.php?action=profile;u=1067333
674078    Gothorum                 Sr. Member          256       383       28        https://bitcointalk.org/index.php?action=profile;u=674078
507856    LeGaulois                Copper Member       255       793       14        https://bitcointalk.org/index.php?action=profile;u=507856
1339716   coinlocket$              Sr. Member          254       292       19        https://bitcointalk.org/index.php?action=profile;u=1339716
252510    JayJuanGee               Legendary           250       1303      24        https://bitcointalk.org/index.php?action=profile;u=252510
1779611   Andy Leto                Member              249       10        0         https://bitcointalk.org/index.php?action=profile;u=1779611
1118969   JanEmil                  Member              249       27        4         https://bitcointalk.org/index.php?action=profile;u=1118969
543626    jackg                    Copper Member       245       1082      3         https://bitcointalk.org/index.php?action=profile;u=543626
1916934   Alfamouse                Member              243       10        0         https://bitcointalk.org/index.php?action=profile;u=1916934
2157460   iamsediii                Member              241       10        2         https://bitcointalk.org/index.php?action=profile;u=2157460
554165    South Park               Hero Member         241       502       0         https://bitcointalk.org/index.php?action=profile;u=554165
934247    Ace44                    Member              240       11        0         https://bitcointalk.org/index.php?action=profile;u=934247
81995     peloso                   Legendary           236       1045      0         https://bitcointalk.org/index.php?action=profile;u=81995
225497    kinki                    Jr. Member          236       6         0         https://bitcointalk.org/index.php?action=profile;u=225497
1766457   easybtcearn2017          Jr. Member          235       1         0         https://bitcointalk.org/index.php?action=profile;u=1766457
487418    The Pharmacist           Legendary           235       1497      78        https://bitcointalk.org/index.php?action=profile;u=487418
1035253   nika555                  Full Member         234       102       0         https://bitcointalk.org/index.php?action=profile;u=1035253
870828    upline                   Sr. Member          233       286       1         https://bitcointalk.org/index.php?action=profile;u=870828
1188361   cryptossi                Full Member         232       106       0         https://bitcointalk.org/index.php?action=profile;u=1188361
1568958   shaman11                 Member              230       16        0         https://bitcointalk.org/index.php?action=profile;u=1568958
1648809   _X_X_X_                  Member              229       26        4         https://bitcointalk.org/index.php?action=profile;u=1648809
308793    1Referee                 Legendary           228       1155      27        https://bitcointalk.org/index.php?action=profile;u=308793
1422459   Liternyy                 Member              228       11        0         https://bitcointalk.org/index.php?action=profile;u=1422459
1440473   rajnipatel1983@gmail.com Jr. Member          227       1         0         https://bitcointalk.org/index.php?action=profile;u=1440473
358787    Dudeperfect              Hero Member         227       527       0         https://bitcointalk.org/index.php?action=profile;u=358787
1681931   phabulu                  Member              227       16        1         https://bitcointalk.org/index.php?action=profile;u=1681931
1253176   Lisa110386               Member              224       12        0         https://bitcointalk.org/index.php?action=profile;u=1253176
1982152   lovesmayfamilis          Jr. Member          223       2         1         https://bitcointalk.org/index.php?action=profile;u=1982152
1352827   SB90                     Member              222       12        0         https://bitcointalk.org/index.php?action=profile;u=1352827
1760729   neymarjunior50           Jr. Member          220       1         0         https://bitcointalk.org/index.php?action=profile;u=1760729
1634977   puzzling_rvat            Jr. Member          220       1         0         https://bitcointalk.org/index.php?action=profile;u=1634977
1117066   Smartprofit              Full Member         219       161       7         https://bitcointalk.org/index.php?action=profile;u=1117066
1840000   TranslateIntoDutch       Member              219       60        26        https://bitcointalk.org/index.php?action=profile;u=1840000
761729    gembitz                  Sr. Member          219       270       2         https://bitcointalk.org/index.php?action=profile;u=761729
1837238   crypmike                 Member              218       49        30        https://bitcointalk.org/index.php?action=profile;u=1837238
1787849   nfransisca               Jr. Member          218       1         0         https://bitcointalk.org/index.php?action=profile;u=1787849
479624    Last of the V8s          Hero Member         218       1164      74        https://bitcointalk.org/index.php?action=profile;u=479624
1630472   Cobrak777                Jr. Member          217       4         0         https://bitcointalk.org/index.php?action=profile;u=1630472
1061974   phantam                  Full Member         216       106       0         https://bitcointalk.org/index.php?action=profile;u=1061974
970060    sachdientugoogle         Full Member         216       101       0         https://bitcointalk.org/index.php?action=profile;u=970060
1606609   Furgon Chino             Member              215       12        9         https://bitcointalk.org/index.php?action=profile;u=1606609
368438    ccsang                   Full Member         214       103       0         https://bitcointalk.org/index.php?action=profile;u=368438
1182581   faulerwilli              Full Member         213       109       0         https://bitcointalk.org/index.php?action=profile;u=1182581
901859    buwaytress               Hero Member         211       636       22        https://bitcointalk.org/index.php?action=profile;u=901859
379147    pooya87                  Legendary           210       1111      12        https://bitcointalk.org/index.php?action=profile;u=379147
374061    Kakmakr                  Legendary           209       1106      29        https://bitcointalk.org/index.php?action=profile;u=374061
1837191   bitnissa                 Jr. Member          209       2         0         https://bitcointalk.org/index.php?action=profile;u=1837191
1142091   QUASA                    Member              209       20        10        https://bitcointalk.org/index.php?action=profile;u=1142091
806776    digaran                  Hero Member         209       605       21        https://bitcointalk.org/index.php?action=profile;u=806776
826292    carlisle1                Hero Member         207       502       0         https://bitcointalk.org/index.php?action=profile;u=826292
234771    suchmoon                 Legendary           207       1460      71        https://bitcointalk.org/index.php?action=profile;u=234771
886521    mjglqw                   Sr. Member          206       365       27        https://bitcointalk.org/index.php?action=profile;u=886521
2022002   minefarmbuy              Member              204       19        11        https://bitcointalk.org/index.php?action=profile;u=2022002
403303    Pursuer                  Legendary           203       1047      4         https://bitcointalk.org/index.php?action=profile;u=403303
408246    YuTü.Co.in               Sr. Member          202       331       10        https://bitcointalk.org/index.php?action=profile;u=408246
2046647   sunnybeacher             Jr. Member          202       4         0         https://bitcointalk.org/index.php?action=profile;u=2046647
323499    oni4an                   Sr. Member          201       253       0         https://bitcointalk.org/index.php?action=profile;u=323499
894070    MineCoin.org             Sr. Member          201       288       0         https://bitcointalk.org/index.php?action=profile;u=894070
783422    Slow death               Hero Member         201       586       12        https://bitcointalk.org/index.php?action=profile;u=783422
960511    nullCoiner               Sr. Member          200       351       29        https://bitcointalk.org/index.php?action=profile;u=960511
326880    dwminer1                 Hero Member         198       508       0         https://bitcointalk.org/index.php?action=profile;u=326880
198573    Hueristic                Legendary           197       1042      5         https://bitcointalk.org/index.php?action=profile;u=198573
1058769   billy.ryoko              Full Member         196       103       0         https://bitcointalk.org/index.php?action=profile;u=1058769
204821    Buchi-88                 Legendary           195       1028      3         https://bitcointalk.org/index.php?action=profile;u=204821
1094102   GREENch                  Full Member         195       102       0         https://bitcointalk.org/index.php?action=profile;u=1094102
1062787   JuliaJi                  Full Member         195       103       0         https://bitcointalk.org/index.php?action=profile;u=1062787
1045881   FourByfour               Member              194       11        0         https://bitcointalk.org/index.php?action=profile;u=1045881
1296859   jamzzz123                Member              194       16        0         https://bitcointalk.org/index.php?action=profile;u=1296859
1335258   NEERAJ ANAND             Member              193       12        0         https://bitcointalk.org/index.php?action=profile;u=1335258
1084486   sportclub2010            Full Member         192       108       0         https://bitcointalk.org/index.php?action=profile;u=1084486
1106178   wiredideas               Full Member         192       101       0         https://bitcointalk.org/index.php?action=profile;u=1106178
1180319   tor676                   Member              191       42        1         https://bitcointalk.org/index.php?action=profile;u=1180319
1186194   Cryptochel               Full Member         191       106       0         https://bitcointalk.org/index.php?action=profile;u=1186194
257004    big_daddy                Full Member         190       146       5         https://bitcointalk.org/index.php?action=profile;u=257004
1980983   Coolcryptovator          Copper Member       190       123       42        https://bitcointalk.org/index.php?action=profile;u=1980983
62358     Gyrsur                   Legendary           190       1028      9         https://bitcointalk.org/index.php?action=profile;u=62358
1188543   o_e_l_e_o                Sr. Member          189       391       71        https://bitcointalk.org/index.php?action=profile;u=1188543
1117299   mpufatzis                Full Member         188       118       0         https://bitcointalk.org/index.php?action=profile;u=1117299
930744    birbok                   Full Member         188       103       0         https://bitcointalk.org/index.php?action=profile;u=930744
1274683   iSparta                  Member              187       10        0         https://bitcointalk.org/index.php?action=profile;u=1274683
1059082   hugeblack                Sr. Member          186       316       2         https://bitcointalk.org/index.php?action=profile;u=1059082
939701    opium                    Sr. Member          185       265       0         https://bitcointalk.org/index.php?action=profile;u=939701
359800    Darkoth89                Hero Member         183       505       0         https://bitcointalk.org/index.php?action=profile;u=359800
149737    BADecker                 Legendary           182       1037      1         https://bitcointalk.org/index.php?action=profile;u=149737
164749    stompix                  Hero Member         180       638       18        https://bitcointalk.org/index.php?action=profile;u=164749
3028      Anon136                  Legendary           180       1154      58        https://bitcointalk.org/index.php?action=profile;u=3028
533006    richardsNY               Legendary           180       1084      7         https://bitcointalk.org/index.php?action=profile;u=533006
764495    DoublerHunter            Hero Member         180       520       0         https://bitcointalk.org/index.php?action=profile;u=764495
397737    hilariousetc             Hero Member         179       959       132       https://bitcointalk.org/index.php?action=profile;u=397737
1731782   Kakady13                 Member              179       10        0         https://bitcointalk.org/index.php?action=profile;u=1731782
1170376   Andrew_G                 Full Member         179       102       0         https://bitcointalk.org/index.php?action=profile;u=1170376
325061    pugman                   Legendary           177       1224      34        https://bitcointalk.org/index.php?action=profile;u=325061
393159    darkangel11              Legendary           177       1047      5         https://bitcointalk.org/index.php?action=profile;u=393159
803757    BrewMaster               Hero Member         177       617       9         https://bitcointalk.org/index.php?action=profile;u=803757
947291    Polar91                  Sr. Member          176       345       26        https://bitcointalk.org/index.php?action=profile;u=947291
1143728   Spazzer                  Member              176       88        24        https://bitcointalk.org/index.php?action=profile;u=1143728
1082600   kenzawak                 Full Member         175       100       18        https://bitcointalk.org/index.php?action=profile;u=1082600
901383    audaciousbeing           Hero Member         174       550       3         https://bitcointalk.org/index.php?action=profile;u=901383
963640    bct_ail                  Sr. Member          173       298       6         https://bitcointalk.org/index.php?action=profile;u=963640
1147073   Mazda17                  Full Member         173       101       0         https://bitcointalk.org/index.php?action=profile;u=1147073
1680941   PnP                      Jr. Member          172       3         0         https://bitcointalk.org/index.php?action=profile;u=1680941
1837296   oerdogan                 Member              172       21        19        https://bitcointalk.org/index.php?action=profile;u=1837296
1328868   nadosuge                 Member              172       23        1         https://bitcointalk.org/index.php?action=profile;u=1328868
1137368   nesh1                    Full Member         171       110       0         https://bitcointalk.org/index.php?action=profile;u=1137368
1201921   firman33                 Member              170       11        0         https://bitcointalk.org/index.php?action=profile;u=1201921
1555320   Hilde X                  Member              170       38        7         https://bitcointalk.org/index.php?action=profile;u=1555320
1894120   madnessteat              Member              169       22        1         https://bitcointalk.org/index.php?action=profile;u=1894120
379487    LFC_Bitcoin              Copper Member       168       1112      15        https://bitcointalk.org/index.php?action=profile;u=379487
1538848   Zedxxx                   Member              168       20        0         https://bitcointalk.org/index.php?action=profile;u=1538848
802442    boyptc                   Hero Member         168       511       2         https://bitcointalk.org/index.php?action=profile;u=802442
1339284   NightLady                Member              168       11        0         https://bitcointalk.org/index.php?action=profile;u=1339284
554       Elwar                    Legendary           168       1218      46        https://bitcointalk.org/index.php?action=profile;u=554
867786    HCP                      Hero Member         167       902       65        https://bitcointalk.org/index.php?action=profile;u=867786
137185    jeremypwr                Legendary           167       1118      92        https://bitcointalk.org/index.php?action=profile;u=137185
1190616   ANDREW 555               Jr. Member          166       7         2         https://bitcointalk.org/index.php?action=profile;u=1190616
837148    ethereumhunter           Hero Member         166       501       0         https://bitcointalk.org/index.php?action=profile;u=837148
1290176   v_i_p                    Member              165       18        2         https://bitcointalk.org/index.php?action=profile;u=1290176
350580    irfan_pak10              Copper Member       164       1060      0         https://bitcointalk.org/index.php?action=profile;u=350580
1153568   voinnov111               Full Member         164       102       0         https://bitcointalk.org/index.php?action=profile;u=1153568
1214555   26FISCH_RU               Member              163       10        0         https://bitcointalk.org/index.php?action=profile;u=1214555
1370336   lequocvuongpro           Jr. Member          162       1         0         https://bitcointalk.org/index.php?action=profile;u=1370336
579628    bob123                   Sr. Member          162       492       42        https://bitcointalk.org/index.php?action=profile;u=579628
931468    recusant2000             Jr. Member          162       2         1         https://bitcointalk.org/index.php?action=profile;u=931468
1297383   DIXItip4ik               Member              160       29        0         https://bitcointalk.org/index.php?action=profile;u=1297383
874254    game-protect             Hero Member         160       503       0         https://bitcointalk.org/index.php?action=profile;u=874254
1193825   mikolsoon                Member              160       12        0         https://bitcointalk.org/index.php?action=profile;u=1193825
1130307   slackovic                Full Member         160       201       10        https://bitcointalk.org/index.php?action=profile;u=1130307
1386572   jamesashmore1964         Jr. Member          159       1         0         https://bitcointalk.org/index.php?action=profile;u=1386572
1333897   Dorbaraco                Member              159       10        0         https://bitcointalk.org/index.php?action=profile;u=1333897
779106    Barcode_                 Staff               159       540       18        https://bitcointalk.org/index.php?action=profile;u=779106
84521     Welsh                    Staff               159       1318      22        https://bitcointalk.org/index.php?action=profile;u=84521
1548994   vipganyan                Copper Member       158       110       0         https://bitcointalk.org/index.php?action=profile;u=1548994
355683    BluRPie                  Hero Member         158       504       0         https://bitcointalk.org/index.php?action=profile;u=355683
1755885   DispatchLabs             Jr. Member          158       3         2         https://bitcointalk.org/index.php?action=profile;u=1755885
334783    seoincorporation         Legendary           157       1131      55        https://bitcointalk.org/index.php?action=profile;u=334783
833246    BitPotus                 Hero Member         157       527       6         https://bitcointalk.org/index.php?action=profile;u=833246
51478     mezzomix                 Legendary           157       1075      9         https://bitcointalk.org/index.php?action=profile;u=51478
2765      morrisby25               Member              156       10        0         https://bitcointalk.org/index.php?action=profile;u=2765
1382847   HMember                  Member              156       10        0         https://bitcointalk.org/index.php?action=profile;u=1382847
1222973   cryptobali               Member              155       11        0         https://bitcointalk.org/index.php?action=profile;u=1222973
1302804   balonka01                Member              155       12        0         https://bitcointalk.org/index.php?action=profile;u=1302804

To my amazement, the top poster on the list,ChiNgadOr, is from my local board (although he posts in sections I barely visit there such as Ann threads). Second on the lists is Xal0lex, a staff member on the Russian board who does some heavy work cleaning up his local thread. The third person on the list is an Ann thread owner, Custterol.
I recognize some forum members on the list immediately : mdayonliner, TheQuin, LoyceV, krogothmanhattan, Jet Cash, xandry, TryNinja, Gothorum, LeGaulois, coinlocket$, JayJuanGee, The Pharmacist, digaran, suchmoon, o_e_l_e_o, hugeblack, stompix, hilariousetc, pugman, LFC_Bitcoin, Welsh, and seoincorporation. These are known to me mostly due to their posts, and probably also for posting often and therefore being visually acknowledgeable (a bit like a personal brand I’d say).

I though seeing some (top 10 due to post limit restrictions I believe) of the profiles with most deleted posts in the last month could be interesting too. Many of them are bounty/ann related deletions by the looks of where the remaining posts are located. Others are reset accounts (sold or such):

Code:

user_id   name                     rank                posts     PostLoss  merit     NewMerit  url
1071531   serneo                   Full Member         664       -1647     101       0         https://bitcointalk.org/index.php?action=profile;u=1071531
1014315   Mungurul                 Sr. Member          640       -595      254       0         https://bitcointalk.org/index.php?action=profile;u=1014315
1310923   set08air                 Newbie              17        -437      1         0         https://bitcointalk.org/index.php?action=profile;u=1310923
1007399   SSowellSVT               Full Member         168       -422      101       0         https://bitcointalk.org/index.php?action=profile;u=1007399
1212376   dbijoy                   Jr. Member          284       -305      1         0         https://bitcointalk.org/index.php?action=profile;u=1212376
2189580   anunymint                Brand new           0         -271      127       52       https://bitcointalk.org/index.php?action=profile;u=2189580
1495332   Pranimbo                 Jr. Member          966       -259      3         0         https://bitcointalk.org/index.php?action=profile;u=1495332
1411175   cryptographer954         Member              62        -236      10        0         https://bitcointalk.org/index.php?action=profile;u=1411175
1655669   CoinRanker               Jr. Member          90        -227      2         0         https://bitcointalk.org/index.php?action=profile;u=1655669

3.   Posting Segment distribution by Rank

If we breakdown the Posting Segment distribution by Rank, we get the following table:


Nothing too remarkable on this breakdown, since distribution by rank also depends on how many members there are per rank, but I’ve highlighted in yellow how the negative post count concentrates on the lower merited ranks as expected.


4.   Posting Segment distribution – 2 consecutive months

The following table shows us how many forum members actually maintain their posting segment for 2 consecutive months, and/or the segment movements that occur. I’ve also added here the total merit gained by each segment combination over the two month period, and averaged to keep it simple but comparable.



Roughly half of the forum members maintain their posting segment for two months in a row, with the exception of the "01. Very Heavy" segment which keeps it up for 73,74% of its forum members, and surprisingly 39,51% of the "06. Negative” segment do too.

The average Merit per segment combination is higher the more posts that are made. This is a chilly conclusion and with a lack of context would be interpreted the wrong way. The base of the analysis is that of users with at least 1 sMerit. The best posters are therefore included here and therefore, it is logical to see more merit given to heavy posters since they have more decent posts that postulate to being merited. This only works in this context, and should not be extended to posting in general on the forum for all users (merited and unmerited).

By the way, I’m a "03. Mid" looking over my last month’s postings, but was "02. Heavy’" the previous month.

[1714838305]

1714838305

[1714838305]

1714838305

[1714838305]

1714838305

[1714838305]

1714838305

[LoyceV]

(quote taken from your deleted thread, now there's more to read again )

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.

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.

[DdmrDdmr]

<...>
"NewMerit" in your table is the total amount of Merit earned since its introduction. Shouldn't that be the amount of Merit earned in the period between those two profile snapshots?
<...>

Thanks, I got the wrong column there. It's since been corrected.

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.

I'll get to it in a while (after lunch) and give you a google sheet link to the data.

[vphasitha01]

Another great work (again..) . So after looking back at your analysis, I have two questions

1) How you derived the posting segments (eg: Very Heavy >=5 posts per day). Because I believed that threshold number matters the most and it will clearly affect the data when we move to the comparison or talking about percentages.

2) Can we cross-referenced the posts of the users(636+1033+973) actually having negative posting state with posts that got deleted on ANN/ Bounty threads?

 

[DdmrDdmr]

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.

I've created two google sheet documents:

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. The interesting column is the last one (MeritReceivedFromNUsers), since it tell us how many people have awarded each of these users with merit.

<…>
1) How you derived the posting segments (eg: Very Heavy >=5 posts per day). Because I believed that threshold number matters the most and it will clearly affect the data when we move to the comparison or talking about percentages.

The posts per day is calculated as an average per user per month. It is done by simply substracting the most current Posts value on User Profile from that of the DB snapshot a month ago, and dividing by the number of days between the two snapshots.

2) Can we cross-referenced the posts of the users(636+1033+973) actually having negative posting state with posts that got deleted on ANN/ Bounty threads?

Not with the data I have, since I’m just using basically the User Profile information, without actually looking at posts themselves (I’m not even sure if deleted posts can be read on a log on some sort, but it would be rather tedious to download, classify etc.). What I did is go through 20 or so profiles and by seeing what posts are still there you get a pretty good idea of what must have been deleted (i.e. some profiles have plenty of bounty reports still in their profiles, others one-liners trash, etc).

[LoyceV]

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)

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.

[DdmrDdmr]

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)

Yes, that has to be it.

It's quite likely the Members who received 10 Merit from one user either got them from their alt, or bought them.

That's what I thought. It's a possible indicator that can raise suspicious cases (along with other patterns we could think of easily). The thing is if could effectively lead anywhere practical in terms of tagging at least, since probably more than that is needed (especially in the lower end of the merit abuse/alt chain).

[bitmover]

I am going to confess I felt good for not being in the very heavy category. I thought I was. I spend too much time here already lol

[DdmrDdmr]

I am going to confess I felt good for not being in the very heavy category. I thought I was. I spend too much time here already lol

Nearly.. you're in segment "02. Heavy" for the last two months..

Yeah, the reading time is not quantified, and that probably adds up to a fair share for many of us too in relation to the time actually spent on posting. You may be on the very heavy side there.. I probably am (I’m not going to analyse logged in time, just in case that comes up..).