[CHARTS] Brief monthly overview of the local boards activity

[Rikafip]

I think you are the only one having more time to do this kind of stuff when not on holiday, rather than when on holiday!

I had an extremely active and hectic holiday with lots of travelling around after which I feel like I need another vacation to rest so going back to my usual routine is actually relaxing compared to what I've been through last month or so.  

Just admit the only thing that makes you get up in the morning is beating me every month on this!

C'mon man, I beat you fair and square! DdmrDdmr updated his Merit Dashboard week ago which gave you a plenty of time to beat me but I would lie if I say hat beating ou doesn't give me any pleasure.  

I will publish my update soon, I just have to replace all the places where I wrote: “I will add the graph as soon as Rikafip stops slacking and sleeping and will finally publish his charts, presumably toward the very end of the month”. /j

Then we can expect your overview in no time!

[1714219394]

1714219394

[1714219394]

1714219394

[1714219394]

1714219394

[joker_josue]

After quite some time we have anew name at the top, tw0.625 from Russian local board who wrote 458 posts (I have to say that i hear about him for the first time),

This is a troll and a ban evader, he has already managed to register more than 7 accounts, of which 5 were banned.

By chance, I also noticed the somewhat unusual volume for a user who has been on the forum for 1 month.
I was not aware of these details. But, with this information, these numbers now make sense. In due time, these types of users will take appropriate actions.


Therefore, removing this strange case from the accounts, I congratulate @Smartprofit [308] who was very close to me. 

[Pmalek]

This is a troll and a ban evader, he has already managed to register more than 7 accounts, of which 5 were banned.

I guess his accounts are only active in the Russian local or possibly also in boards I don't visit because I don't remember ever seeing any posts of those accounts in the forums I frequent. He isn't even trying to hide the connection to his older accounts since he uses similar usernames as those that are already banned. I don't understand people like that who hate this place and its members, and keep going back only to remind everyone of those facts and tell them how much better they are.

[joker_josue]

I don't understand people like that who hate this place and its members, and keep going back only to remind everyone of those facts and tell them how much better they are.

The point is that he is someone who is very old on the forum, and knows where to move. Just create these alts to troll. Maybe you're bored and have nothing to do, or maybe you're upset with someone here on the forum and this was a way of showing your anger.

Anyway, in a very large community, it is normal from time to time for these people to appear. 

[Rikafip]

He sits all day and provokes people to conflict and swearing, insulting the participants of the discussion for no reason in each post and talking in the style of I alone know everything, and you are all a herd of idiots. In terms of value for the locale, this member is of almost no use, and most of his posts are self-repetitions of the same fantasies of his about bitcoin religion and other schizophrenia that he broadcasts here every day.

Every once in a while we have a similar situation in our local board where inafmous troll and ban evader fxsurfer/antikvark/anthithesis (that is also known in the geenral part of the forum) comes to our local board and starts the same old bullshit story. Unfortunately some people can't resist answering his bullshit and he gets what he what trolls want the most and that is attention.

Almost no one communicates with him, and most users put him on the ignore list.

Unfortunately, all it takes are few members who will engage him.

Therefore, removing this strange case from the accounts, I congratulate @Smartprofit [308] who was very close to me. 

Yes you are right, he is the 2nd while Ratimov was actually 3rd. I edited the post, thanks.


@DdmrDdmr, @TryNinja, @LoyceV (or anyone else for that matter) is there a way to see percentage of merited posts during certain period on each (local) board?

[skarais]

@DdmrDdmr, @TryNinja, @LoyceV (or anyone else for that matter) is there a way to see percentage of merited posts during certain period on each (local) board?

That would definitely be a good idea to add, meaning I can get away from the calculator a bit when it comes to percentageing how many posts benefit in a given period.

[Rikafip]

That would definitely be a good idea to add, meaning I can get away from the calculator a bit when it comes to percentageing how many posts benefit in a given period.

I am not sure I understood you correctly; does that mean you are actually manually counting posts in your local board that have been merited in order to get that percentage?

I guess it is doable if you are doing it for only one board, but there's no way in hell I would do it for 18 local boards. Thinking of it, I wouldn't even do it for my own local board lol.

[Pmalek]

Every once in a while we have a similar situation in our local board where inafmous troll and ban evader fxsurfer/antikvark/anthithesis (that is also known in the geenral part of the forum) comes to our local board and starts the same old bullshit story.

I wonder where he is. One would think it was a wonderful opportunity for him to tell us how useless bitcoin is and what a big scheme it is after the value fell from almost $30k down to $25k. Or when the Ordinals spam started clogging up the blockchain, causing hundreds of thousands of transactions to be unconfirmed. We have to wait some more for his return...

[LoyceMobile]

@DdmrDdmr, @TryNinja, @LoyceV (or anyone else for that matter) is there a way to see percentage of merited posts during certain period on each (local) board?

That would definitely be a good idea to add, meaning I can get away from the calculator a bit when it comes to percentageing how many posts benefit in a given period.

It's probably easiest to just read the total number of posts for the board on the forum, and then do it again the next time you want the data.
That gives the difference excluding deleted posts.

[DdmrDdmr]

<…> is there a way to see percentage of merited posts during certain period on each (local) board?

You can on the Merit/post tab of the Merit Dashboard; that is, bearing in mind the way I derive the number of posts per month on a given board (forum stats value difference between two snapshots). I've now added a new column on the Merit per Post tab called %MeritedPosts, that simply calculates the percentage based on data that was already there: nNetPosts (postcount) and nMeritedPosts (distinct merited posts).

You can always just use the already existing nMeritedPosts column and divide it by the values obtained from Ninjastic, as I believe you do for the Merit/Post ratio.

See:
https://public.tableau.com/views/BitcointalkMeritDashboard/MeritperPost?:language=es-ES&publish=yes&:display_count=n&:origin=viz_share_link

[Rikafip]

You can on the Merit/post tab of the Merit Dashboard; that is, bearing in mind the way I derive the number of posts per month on a given board (forum stats value difference between two snapshots). I've now added a new column on the Merit per Post tab called %MeritedPosts, that simply calculates the percentage based on data that was already there: nNetPosts (postcount) and nMeritedPosts (distinct merited posts).

Awesome, that's exactly what I needed and I can't believe that I forgot that it was already available in your Merit Dashbord after looking at it for years. Anyway, thanks a lot!

You can always just use the already existing nMeritedPosts column and divide it by the values obtained from Ninjastic, as I believe you do for the Merit/Post ratio.

Yep that's what I did, I used Merit Dashboard's number of merited posts and then ninjastic.space for total amount of posts to caluclate percentage.


Since I had some free time on my hands and it didn't take me much time, here is the test version of "percentage of merited posts per local board" as I thought it would be another interesting chart, to get a little bit clearer pciture of what's going on merit wise in local boards.

What do you guys think about this one and would you like to see it being added to the next month's overview as well?

[joker_josue]

What do you guys think about this one and would you like to see it being added to the next month's overview as well?

If it's not something complicated and that will make you spend a lot more of your time. It looks like a good graph to me.
This allows you to understand a little better how merits are distributed.

[Lillominato89]

I would say that if it doesn't take up too much of your time during the process of drawing up your reports you could include it, the counting of the percentage of merits gives a more accurate overview of how the merits are spent on the forum and it is an excellent report

[fillippone]

You can on the Merit/post tab of the Merit Dashboard; that is, bearing in mind the way I derive the number of posts per month on a given board (forum stats value difference between two snapshots). I've now added a new column on the Merit per Post tab called %MeritedPosts, that simply calculates the percentage based on data that was already there: nNetPosts (postcount) and nMeritedPosts (distinct merited posts).

Awesome, that's exactly what I needed and I can't believe that I forgot that it was already available in your Merit Dashbord after looking at it for years. Anyway, thanks a lot!

I used to do that, using your post number for consistency reasons, not using ninjastic tools for this.
I actually think I was the one originally asking to add that column on your dashboard I used to produce this graph:

Ripropongo il grafico della percentuale di post meritati su ogni board.


Fig. 12. Merited Post Ratio across local boards

Also in June the Romanian board was rocking!

Rather than an “horizontal” graph, I liked more the  to  “vertical” deep dove on the Italian board.
Something like this.

A questo punto, concentrandoci sulla board italiana, si può anche vedere come si è evoluta questa percentuale nella storia:


Fig. 13. Merited Post Ratio history for Italian board

Da qui si vede come l'ultimo mese sia riuscito a riprendere il buon trend positivo che avevamo facendo segnare un leggerissimo aumento. Significa che abbiamo raggiunto una sorta di equilibrio, ed oramai la quantità di post meritati è tutto sommato stabile. Speriamo bene per i prossimi mesi.

So, I reckon your graph is very interesting as well.
First hints:

• amount of spam on each board
• MS coverage of each board.

[Rikafip]

If it's not something complicated and that will make you spend a lot more of your time. It looks like a good graph to me.
This allows you to understand a little better how merits are distributed.

I would say that if it doesn't take up too much of your time during the process of drawing up your reports you could include it, the counting of the percentage of merits gives a more accurate overview of how the merits are spent on the forum and it is an excellent report

It's not really matter of taking much of my time (at this point after making so many of those in the last 3 and a half years it doesn't take me much time at all) but more about not having too many charts so people get bored and overvwhelmed with it. For that reason I removed "posts per user" chart after intitially adding it as I though it didn't bring much but I think that "percebtage of merited posts" actually helps with getting a clearer picture of merit situation in local boards.

I actually think I was the one originally asking to add that column on your dashboard I used to produce this graph

Might be, my memory is not what it used to be. 

Also in June the Romanian board was rocking!

Romanian board usually has very high merit/post ratio so I wasn't surprised when I saw them at the top. Then again, these less active boards can have big amplitudes so it will be interesting to see next month's overview.

Anyway, I think I will include this chart in my regular setup from next month's overview and will see how it goes. Though, it started as a brief monthly overview and I would like to keep it somewhat brief (maybe its already too late for that  )

[fillippone]

I actually think I was the one originally asking to add that column on your dashboard I used to produce this graph

Might be, my memory is not what it used to be. 

Sorry, bad quoting, I was referring to @ddmrddmr message regarding his addition to the dashboard.
I recall I asked that column because I wanted to produce those graphs for my overview. Now that I have suspended the usage of that column, it might be nice if you go on with it!

[bitmover]

i have updated the local chart race with the latest data from Rikafip




Bitcointalk post: https://bitcointalk.org/index.php?topic=5432447.new#new
Race: https://public.flourish.studio/visualisation/12312077/

[Rikafip]

Sorry, bad quoting, I was referring to @ddmrddmr message regarding his addition to the dashboard.

Yes, that makes more sense

I recall I asked that column because I wanted to produce those graphs for my overview. Now that I have suspended the usage of that column, it might be nice if you go on with it!

Well thank you for that (and DddmrDdmr ofc who keeps adding new stuff and without whom there woulnd't be our overviews) and yeah, I will include this chart in my next month's overview.

i have updated the local chart race with the latest data from Rikafip

Cheers, I've updated the overview with your animated local chart race.

[CryptoHeadlineNews]

This month Nigerian board managed to reach 4th spot with 1438 posts which is their record (up from 1174) and I expect them to continue with their growth, while Portuguese board closes top 5 with 1427 posts (up from 1112).

This is impressive, and I really appreciate you @ "Rikafip" for this wonderful job you are doing here. However, I'm really happy to see my local board growing progressively each month on this forum in terms of post count, as I can remember in  June we came out 6th, in July we came out 5th, and last month "Augest" happy to see us coming out 4th position, as that shows how active and contributing the Nigerian local board is on this forum. Don't worry, I'm sure we gonna come out 3rd in this month of "September".

[Rikafip]

Time has come for yet another brief monthly overview of the local boards activity, and yet again in a reasonable time frame (*flex* ). All charts and table are made using data from @DdmrDdmr Merit Dashboard and @TryNinja Ninjastic.space so thanks guys for your awesome tools and of course big thanks to joker_josue and his TalkImg.

Communities marked with * (Pakistan, Bangladesh) don't have their own local boards and that's something that I hope will change sooner than later.


Post activity per local board during September 2023

During above mentioned period, 18741 posts were made across 18 local boards and it was a solid ~5% increase compared to August during which 17919 posts were written. Since summer is behind us and people tend to spend more time in hiouse, I hope that number will go up in future months.

When it comes to the most active boards, Russian remain the most active one with yet again more than 6,000 posts, followed by Turkish (2275) and Nigerian local board that had its all time high of 1898 posts and its just a matter of time before they overtage Turkish board while Indonesian (1465) and Portuguese (1452) close the top 5. For the first time since I am making these overviews German board didn't finish in top 5 and they unfortunately continue their activity decline.

At the bottom we can see the usual names and unfortunately and while Greek and Romanian barely improved compared to last month, Polish board numbers went down dramatically, from 97 in August to 32 in September. I do hope that its just a temporrary slump and that they recover soon.

Local Board post race

Animated local board post race chart, courtesy of bitmover

Source: https://bitcointalk.org/index.php?topic=5432447.msg61520566#msg61520566

Number of active members per local board during September 2023

During last month, 1355 members wrote at least one post in one of the local boards which is a slight decrease compared to month before that had 1403 active members. Since all those who wrote at least 1 post counts, its normal to have fluctuations on the monthly basis.

Once again Russian board had by far the most active members, followed by Nigerian, Indonesian, German and Turkish board. Its really interesting to see how in this rregard Nigerian board keeps growing as only few months ago they had less than 90 and now its already at 140+ with tendency to grow further.

Local board members per amount of posts during September 2023

When it comes to members who wrote only 1 post during September, Greek has the highest percentage of those (57%), followed by Arabic (41%) and Polish (40%) local boards. At the same time, Portuguese has the loweet percentage of such members (13%), followed by Nigerian (14%) and Pilipinas (19%) local boards.

In the 2-9 posts bracket Romanian board is leadder with 60%, while Indian (50% and German (48%) are at the 2nd and 3rd spot. Meanwhile, Croatian board has the lowest percentage of such members (22%), followed by Pakistan (26%) and Turkish (28%) local boards.

Turkish local board boasts with the highest percentage of members who wrote at least 10 posts (50%), followed by Portuguese (48%) and Nigerian (46%) local boards. On the other hand, Greek board has the lowest percentage of such members (14%), followed by Indian (19%) and Romanian & Polish board that both had 20% of such members.

Merit shared per local board during September 2023

During above mentioned period 9835 merit was shared across 18 local boards which is an increase compared with August during which that number was noticeably smaller (8360). Russian board with 2137 shared merit took the first place from German who finished 2nd with an excellent 1813 merits shared that is even higher than their previous month number. This month we have a surprise at the 3rd spot, Nigerian board that had 1148 merits shared which is by far their best result yet. Since they only have (afaik) 1 merit sourse, this growth is mainly caused by an external merit sources that helped them greatly and I do hope will continue to do the same.

As it was with post chart, we have the usual names at the bottom part of this one as well, but until they increase their post activity its not realistic to expect that their number of merits shared will increase (at least not significantly).

Merit senders and receivers per local board during September 2023

As always, pretty straighforward chart that follows amount of merit shared (more or less), with the standard exceptions like Pilipinas and Nigerian local boards and no we have Turks joned as well which might be one of the indications that they could use more merit sources.

Merit/Post ratio per local board for September 2023

Once again German local board is at the top with a very good 1.28 merits per post, followed by Arabic board that is usually at the top, and another standrad names, Italian. At the bottom we have Greek locall board whose very low ratio is not a surprise due lack of activity, but imho Pilipinas should be much higher and it would be great if other external merit sources could help them the way they are helping some other local boards.

Percentage of merited posts across local boards during September 2023

This is one of the new charts that shows the percentage of merited posts per local board and difference between boards is staggering as for example in Romanian board almost every 2nd post got merited (41%), while in Pilipinas every ~15th post got merited. Then again, less active boards like Romanian could have such a high percentage, but Pilipinas is on par with some of the lowest quality parts of the forum like Off Topic and i seriously doubt they have such a low quality of posts.

Merit per transaction ratio across local boards during September 2023

And the last in this series of charts, merit/tx ratio which shows how members in local boards have very different merit habits. Just keep in mind that less active boards could have very high numbers, like Polish local board for example while next month that ratio could be much lower meaning amplitudes are big.

The most active members per local board during September 2023

And for the end of this month's (not so) brief local board overview, its time to mention top 10 members across 18 local boards. joker_josue regained the title of the most active local board spammer ( ) after that Russian troll seemingly disappeared this month, followed by Smartprofit who wrote 276 posts and Ratimov with 244 posts who are both from Russian local board. GG!

Russian	|	German	|	Turkish	|	Italian	|	Portuguese	|	Spanish	|
_________________	|	_________________	|	_________________	|	_________________	|	_________________	|	______________________	|
1. Smartprofit [276]	|	1. bullrun2020bro [141]	|	1. mandown [196]	|	1. Ale88 [120]	|	1. joker_josue [293]	|	1. DdmrDdmr [129]	|
2. Ratimov [244]	|	2. Turbartuluk [138]	|	2. ZekiBeyy [157]	|	2. fillippone [95]	|	2. TryNinja [149]	|	2. Don Pedro Dinero [48]	|
3. jokers10 [224]	|	3. cygan [107]	|	3. totti67 [129]	|	3. bastisisca [92]	|	3. sabotag3x [138]	|	3. famososMuertos [44]	|
4. Julien_Olynpic [215]	|	4. 5tift [83]	|	4. execijutiere [85]	|	4. babo [66]	|	4. Paredao [129]	|	4. Hispo [39]	|
5. The0ldl_lser [214]	|	5. Lakai01 [71]	|	5. gospodin [74]	|	5. giammangiato [46]	|	5. darkv0rt3x [128]	|	5. Porfirii [29]	|
6. BVeyron [184]	|	6. Buchi-88 [61]	|	6. verbakalim [68]	|	6. Plutosky [36]	|	6. tg88 [125]	|	6. albert0bsd [29]	|
7. klarki [173]	|	7. 1miau [60]	|	7. Phoenix Anka [67]	|	7. Lillominato89 [34]	|	7. bitmover [103]	|	7. darbitmobilerecovery [28]	|
8. Snork1979 [136]	|	8. Real-Duke [60]	|	8. Dzigie [65]	|	8. Italian Panic [29]	|	8. Disruptivas [86]	|	8. Artemis3 [23]	|
9. internetional [130]	|	9. bct_ail [56]	|	9. kriminall [63]	|	9. conilmionome [26]	|	9. rdluffy [71]	|	9. Drawesome [19]	|
10. safar1980 [123]	|	10. Unknown01 [51]	|	10. Jossque [61]	|	10. gbianchi [26]	|	10. Loganota [56]	|	10. seoincorporation [18]	|

Indonesian	|	French	|	Pilipinas	|	Croatian	|	Nigerian	|	Arabic	|
_________________	|	__________________________	|	_________________	|	______________________	|	________________________	|	_________________	|
1. blue Snow [86]	|	1. Danydee [45]	|	1. bhadz [82]	|	1. slackovic [31]	|	1. Charles-Tim [140]	|	1. Kavelj22 [42]	|
2. Husna QA [72]	|	2. iwantmyhomepaidwithbtc2 [34]	|	2. blockman [44]	|	2. Pmalek [26]	|	2. rachael9385 [78]	|	2. yhiaali3 [30]	|
3. Sarah Azhari [52]	|	3. Joan of Arc official [32]	|	3. dothebeats [43]	|	3. cryptofrka [23]	|	3. CryptopreneurBrainboss [68]	|	3. Trawda [26]	|
4. armanda90 [45]	|	4. Melja [30]	|	4. tech30338 [42]	|	4. Lunorael [20]	|	4. EluguHcman [54]	|	4. mikeywith [24]	|
5. Chikito [44]	|	5. Saint-loup [29]	|	5. serjent05 [28]	|	5. dkbit98 [20]	|	5. Majestic-milf [51]	|	5. GxSTxV [22]	|
6. abhiseshakana [44]	|	6. patrickus [28]	|	6. bisdak40 [24]	|	6. Rikafip [19]	|	6. Gozie51 [41]	|	6. khaled0111 [21]	|
7. masulum [44]	|	7. F2b [24]	|	7. gunhell16 [22]	|	7. FatFork [18]	|	7. Odohu [35]	|	7. hg_away [18]	|
8. mu_enrico [40]	|	8. LeGaulois [21]	|	8. Johnyz [21]	|	8. Trofo [18]	|	8. Sim_card [35]	|	8. Nalain420 [13]	|
9. Luzin [39]	|	9. GrosWesh [15]	|	9. Mr. Magkaisa [21]	|	9. examplens [17]	|	9. SmartGold01 [35]	|	9. albon [9]	|
10. arimamib [37]	|	10. G.Seed [11]	|	10. robelneo [21]	|	10. SirJohnVonSlotty [12]	|	10. sokani [35]	|	10. Ulven [8]	|

Polish	|	Indian	|	Greek	|	Romanian	|	Pakistan*	|	Bangladesh*	|
_________________	|	_________________	|	_________________	|	_________________	|	_________________	|	_________________	|
1. cygan [20]	|	1. pakhitheboss [25]	|	1. cryptosize [16]	|	1. GazetaBitcoin [23]	|	1. ZAINmalik75 [53]	|	1. Learn Bitcoin [40]	|
2. Tytanowy Janusz [8]	|	2. Bitcoin Smith [23]	|	2. BlackHatCoiner [8]	|	2. NeuroticFish [8]	|	2. JunaidAzizi [50]	|	2. DYING_S0UL [38]	|
3. fillippone [2]	|	3. pawanjain [18]	|	3. apogio [4]	|	3. ltcrstrbrt [4]	|	3. Gladitorcomeback [45]	|	3. Subbir [36]	|
4. Flangler1 [1]	|	4. Bureau [15]	|	4. Kutsal [1]	|	4. Rizzrack [3]	|	4. Publictalk792 [43]	|	4. Crypto Library [21]	|
5. pawel7777 [1]	|	5. elevates [15]	|	5. Pricecheck [1]	|	5. adleras [1]	|	5. Cheema02 [38]	|	5. Bd officer [18]	|
	|	6. teosanru [12]	|	6. cryptonomyGr [1]	|		|	6. HONDACD125 [38]	|	6. Z_MBFM [18]	|
	|	7. JSRAW [8]	|	7. mastercryptogr [1]	|		|	7. Hamza2424 [35]	|	7. roksana.hee [18]	|
	|	8. Stedsm [6]	|		|		|	8. UmerIdrees [34]	|	8. HelliumZ [17]	|
	|	9. rajsunil [6]	|		|		|	9. ThemePen [32]	|	9. Little Mouse [16]	|
	|	10. avikz [5]	|		|		|	10. Faisal2202 [29]	|	10. Shishir99 [15]	|