Topic: [CHARTS] Brief monthly overview of the local boards activity - page 24. (Read 21078 times)

Well, you really have to manage your time well, so as not to leave other tasks behind throughout the day.

Normally, throughout the day, I can access the forum every hour or every 2 hours, for about 5 minutes. And then at the end of the day, I dedicate a little more time to the forum.

One thing I always try is that the forum does not affect the opportunity to do other things in my day to day offline. If one day I can't come to the forum or come less often, I'm not bothered.

I like DdmrDdmr's way better. Since it's a yearly overview, 10 posts can't really be a number where you would consider someone to be an active poster. I would consider someone that makes a minimum of 10 posts per month in their local as a regular local board poster. Those should belong to the top category in my opinion. If we multiply that by 12, we get at least 120 posts a year to get into the big boys club. But it's not the same thing to write 120 posts in an active local such as the Russian or German, as it is in one that rarely gets much attention or only has a local thread, for example.   

Couldn't agree more with this. This forum can be a confusing place for a newbie and local boards definitely help. I mean, I've been active on various forums for ~20 years, wasn't new in crypto and have no problem understanding English yet it was helpful to have group of people that speak my language in that first period when i was getting used to this forum. And now imagine how it is for someone who is new to crypto, has no previous experience on any other forum and struggles with English.


No worries about that, I haven't missed making monthly overview in last 3 years since I created this thread and certainly won't miss last month's overview.


Yeah you are right, I was too conservative and still thinking like I am making monthly overview and not yearly.


Things get more complicated when you have to include boards that very different in terms of activity. I am still checking things out but I am leaning towards making 4 groups: 1-9 posts, 10-49, 50-99, 100+. Eventually I may add one more groups for those extra active (500+) but I am still not sure about it as not many boards would have members in that bracket.


Keep in mind that even those who wrote a single post in a whole are counted, so that's why numbers are somewhat inflated.

That's beautiful! I didn't expect we had this lot of people active in the local thread. I was expecting somewhat 100 or +-10 lol but this number seems great though we had a lot less posts + merit than others. Still, it's great achievement.

You spend quite a long time on the forum. How do you manage this time lol? Congrats and thanks a lot for the contribution to the forum.

Interesting results. Not because I was in first place, since it was normal for having been in first place almost every month. But, I expected second place to come from the Russian tab.

But, of course, what counts here is the consistency throughout the year and not just in a few months.

Congratulations to my podium colleagues: @DdmrDdmr @Ratimov 

This is a fascinating idea. Definitely looking forward to replicating for the Italian board, unless @rikafip is quicker than me.
Also funny to see @ddmrddmr, the demigod of merit analysis, is taking data from @tryninja

If we’re considering data for a whole year, the top range, 10 posts (although +) is less than an average of 1 post per month on the lower end of the range, which is a small contribution, and perhaps gets too mixed-up in the same segment with the real heavy posters.

Finding the adequate groups is not trivial. In my case, since I’m only focused on one single board, It’s easier to create groups that are more fitting to be meaningful. With an overall approach, I’d probably have created the group based on conceptual average weekly posting ranges, and scales that up to a yearly outcome.

i.e. Tentative:
 +10 posts per week -> [500++] posts per year (Heavy Regular posters)
[5..10) posts per week -> [250..500) posts per year
[1..5) posts per week -> [50..250) posts per year
(0..1) posts per week -> [1..50) posts per year

Now after trying a few local boards, it may result in the bottom segment being too concentrated (i.e. the Spanish local board would render 94,62%), and I’ve got a feeling that there may be many 1..2 posts per year accounts in general. It may be worthwhile breaking down the lowest group to see this hypothesis (which is meaningful per se), as it turned out to be in the Spanish local board:
 (0..1) posts per week -> [1..50) posts per year could be replaced by:

[26,50) posts per year
[3,25] posts per year
[1.2] posts per year

As I said, the above is tentative, and subject to what you see in the data, and how much of an effort it implies. Perhaps just to emphasize that it’s interesting to separate the heavy posters and the very sporadic posters as separate groups (as I did above), and break down all between figures into something manageable.

Thank you for your excelente work Rikafip.

I hope you won't forget your monthly update with December date. I now use this data in 2 reports of mine, the local boards race and my Portuguese Board consolidation.

It is impressive the Arabic board post/merit ratio. So low activity, and so much merits.

The amount of Russians is incrediable as well, 1800 users!!

Good job!

Very interesting recap. Sometime is interesting zooming out a little bit and focus on the bigger picture.
Also very interesting how small is the number of users I know from the local boards. There are so many posters out there who never venture outside of the local boards.
For this reason I think local boards are so important for the forum, and providing them good content is a vital objective for the forum (and where I try to give my humble contribution

That's exactly what I planned to do but then I scratched that idea due sheer laziness. Initial idea was to divide users into 3 groups: those who wrote 1 post, then group for 2-9 posts and 3rd for all that made 10+ posts. Does that make sense to you?
I might even try to do it today and if I can make it look good I'll update the overview with the new chart.

Another interesting exercise that can be done for a given local board, which is quite revealing, is to break down the number of active posters on a given local board into groups, based on the number of posts that they've made.

For example, the 260 active members on the Spanish local board seems like a pretty high figure for what I normally see over there, but if we break it down, the data looks like this (I’ve also got data for prior years, as I’ve been updating the chart on my local board over time):

(Data derived from ninjastic)

Looking at 2022’s data, it turns out that 188 of those 260 posters (72,31%) are actually accounts that have created 1 or 2 posts on the Spanish local board. On the other end of the scale, only 14 people are kind of regulars (50+ posts on the Spanish local board during 2022), a figure that has been clearly decreasing over time.

One could then go deeper and see where those sporadically posters actually post (likely Altcoins, or even random spammers posting a link to who knows where), but I haven't taken it down that road to date.

As I promised couple of weeks ago, here is the first yearly overview of the local board activity. Main reason for this overview is to be able to compare and follow the situation in following years. Since this month I have to make 4 overviews I will keep it brief & simple and if you have any other ideas what should I add, please let me know.

All charts and tables were made using data from @DdmrDdmr Merit Dashboard and @TryNinja Ninjastic.space. Communities marked with * don't have their own local board (yet).

---

Post activity per local board during 2022

During above mentioned period 193839 posts were made across 18 local boards/communities with Russian board far ahead the others, followed by Turkish and German board far behind them and at the bottom we have usual names that we see in similar positions in  those monthly overviews. It is also encouraging to see that one of the communities without local board (Pakistan) is so high on the chart, while I expect the one that recently got their own local board (Nigerian) much higher on the next year's overview.

---

Number of active members per local board during 2022

Overall, 5960 members wrote at least 1 post in one of those 18 local boards. I thought about setting requirement much higher as if someone writes 1 post during a year it can be hardly counted as an active member, but since I set the same requirement for monthly overview, in the end I went with the same number.

Anyway, Russian board has by far the most members who wrote at least one post, while Germans and Turks changes the position compared to post chart and the only one that was somewhat close to them was Indonesian board, while all the others were far behind.

---

Merit shared per local board during 2022

During 2022, total amount of 71009 merits were shared. I don't have the info from 2021, but since theymos introduced new merit sources last year, I am fairly certain that number increased significantly when compared with previous period. Once again Russian board is far ahead the others with 18226 merits shared, followed by Turkish (9735) and German (9621).

---

Merit senders and receivers per local board during  2022

When we are looking at overall numbers for 2022, 1098 members send merit and 1963 members received merit across 15 local boards. Pakistan and Bangladesh are missing here as I only have that info for those with their own local boards and hopefully next year there will be at least 1 more local board on his chart. Another reminder that boards are ordered based on the amount of merits shared.

---

Merit/Post ratio per local board for 2022

Since Arabic board was consistently if not the top then 2nd board with highest merit.post ratio in those monthly overviews, its no surprise that it is far ahead the others in yearly chart too and very same can be said about those that were at the bottom in monthy charts, namely Pilipinas, Greek and Indian that are very far behind the others. Beside those few local boards, I think that situation geenrally looks pretty good and probably much better than in previous years.

---

The most active members per local board during 2022

Last but not the least, list of those who kept their boards alive and kicking during last year. Among all of them, the most active one was joker_josue with 3282 posts written in Portuguese board, followed by DdmrDdmr who wrote 2076 posts in Spanish board and Ratimov at the 3rd spot with 1998 posts written in Russian board.

Russian	|	German	|	Turkish	|	Italian	|	Portuguese	|	Spanish	|
____________________	|	____________________	|	____________________	|	____________________	|	____________________	|	____________________	|
1. Ratimov [1998]	|	1. mole0815 [1767]	|	1. mandown [1214]	|	1. fillippone [1668]	|	1. joker_josue [3282]	|	1. DdmrDdmr [2076]	|
2. Snork1979 [1900]	|	2. willi9974 [1326]	|	2. Phoenix Anka [1082]	|	2. babo [906]	|	2. TryNinja [1616]	|	2. famososMuertos [698]	|
3. The0ldl_lser [1488]	|	3. 1miau [1157]	|	3. ZekiBeyy [988]	|	3. Ale88 [827]	|	3. bitmover [1268]	|	3. Hispo [605]	|
4. xandry [1119]	|	4. bct_ail [1093]	|	4. wolwoo [956]	|	4. duesoldi [546]	|	4. Disruptivas [809]	|	4. Porfirii [567]	|
5. klarki [1097]	|	5. bullrun2020bro [984]	|	5. MK-74 [920]	|	5. Paolo.Demidov [542]	|	5. Lucasgabd [639]	|	5. darxiaomi [361]	|
6. lutik378 [1056]	|	6. sam00 [901]	|	6. meser# [906]	|	6. jack0m [350]	|	6. alegotardo [598]	|	6. Don Pedro Dinero [256]	|
7. Olgacom [1054]	|	7. Lakai01 [894]	|	7. Red Pie [888]	|	7. Plutosky [346]	|	7. rdluffy [542]	|	7. seoincorporation [241]	|
8. Excimer [1024]	|	8. Unknown01 [877]	|	8. Bthd [885]	|	8. gbianchi [314]	|	8. gagux123 [430]	|	8. LUCKMCFLY [144]	|
9. Galina1006 [903]	|	9. cygan [806]	|	9. kriminall [885]	|	9. bitbollo [280]	|	9. Paredao [278]	|	9. d5000 [117]	|
10. Julien_Olynpic [867]	|	10. Soonandwaite [805]	|	10. Retro Harmony [838]	|	10. giammangiato [249]	|	10. tg88 [247]	|	10. Silberman [106]	|

Indonesian	|	French	|	Pilipinas	|	Croatian	|	Polish	|	Arabic	|
____________________	|	____________________	|	____________________	|	____________________	|	____________________	|	____________________	|
1. Husna QA [949]	|	1. Danydee [503]	|	1. blockman [520]	|	1. slackovic [579]	|	1. Tytanowy Janusz [481]	|	1. Kavelj22 [531]	|
2. DroomieChikito [816]	|	2. Saint-loup [470]	|	2. Fredomago [447]	|	2. Daniel91 [414]	|	2. wwzsocki [240]	|	2. Ulven [265]	|
3. abhiseshakana [544]	|	3. patrickus [373]	|	3. bisdak40 [427]	|	3. Trofo [401]	|	3. PawGo [177]	|	3. OmegaStarScream [251]	|
4. masulum [505]	|	4. LeGaulois [302]	|	4. Baofeng [307]	|	4. casperBGD [281]	|	4. cygan [134]	|	4. yhiaali3 [222]	|
5. Luzin [470]	|	5. elma [228]	|	5. mirakal [299]	|	5. dkbit98 [273]	|	5. lokas0506 [114]	|	5. khaled0111 [170]	|
6. mamesso [442]	|	6. GrosWesh [188]	|	6. carlisle1 [266]	|	6. Pmalek [272]	|	6. malevolent [63]	|	6. GxSTxV [119]	|
7. blue Snow [396]	|	7. perl [153]	|	7. serjent05 [259]	|	7. FatFork [235]	|	7. Flangler1 [59]	|	7. albon [75]	|
8. erep [303]	|	8. Melja [137]	|	8. Jemzx00 [251]	|	8. cryptofrka [204]	|	8. pbies [24]	|	8. mikeywith [65]	|
9. Antonas1 [245]	|	9. Halab [135]	|	9. acroman08 [250]	|	9. Rikafip [151]	|	9. Rath_ [21]	|	9. Bybit Arabic [35]	|
10. Razmirraz [244]	|	10. F2b [123]	|	10. arwin100 [227]	|	10. CroBoy12 [109]	|	10. dwminer1 [12]	|	10. abderrazak belkhir [23]	|

Romanian	|	Indian	|	Greek	|	Pakistan*	|	Nigeria*	|	Bangladesh*	|
____________________	|	____________________	|	____________________	|	____________________	|	________________________	|	____________________	|
1. NeuroticFish [206]	|	1. sagarbansal21 [147]	|	1. cryptosize [313]	|	1. Sayeds56 [556]	|	1. Maestro75 [225]	|	1. Little Mouse [90]	|
2. GazetaBitcoin [189]	|	2. pakhitheboss [86]	|	2. BlackHatCoiner [172]	|	2. NoorulHuda [516]	|	2. uchegod-21 [219]	|	2. Crypto Library [86]	|
3. Rizzrack [45]	|	3. teosanru [57]	|	3. chek2fire [53]	|	3. UmerIdrees [451]	|	3. CryptopreneurBrainboss [169]	|	3. Review Master [55]	|
4. PrivacyG [28]	|	4. Frengki_cisco [53]	|	4. Dr1000 [35]	|	4. ThemePen [223]	|	4. Wiwo [150]	|	4. wtsimis [50]	|
5. 1miau [11]	|	5. pawanjain [44]	|	5. HmmMAA [23]	|	5. galambo [221]	|	5. Charles-Tim [148]	|	5. shasan [44]	|
6. IonCreanga [9]	|	6. avikz [27]	|	6. bomberb17 [18]	|	6. Hamza2424 [218]	|	6. Agbe [138]	|	6. Cryptoworldman [41]	|
7. Palinca89 [6]	|	7. nestproclub [24]	|	7. Nikosbtc [10]	|	7. Morningstarr [213]	|	7. Coyster [134]	|	7. musafar37 [38]	|
8. flori70 [5]	|	8. ANKIT007 [21]	|	8. olesg13 [9]	|	8. shahzadafzal [204]	|	8. Marykeller [123]	|	8. naim027 [34]	|
9. 3dOOm [4]	|	9. libert19 [21]	|	9. Dimitris [8]	|	9. Mariah20 [162]	|	9. BIT-BENDER [113]	|	9. Teletalk.org [24]	|
10. Elvenland [4]	|	10. pihumehra09 [20]	|	10. scrab4ever [8]	|	10. ZAINmalik75 [160]	|	10. Davidvictorson [110]	|	10. sakil200 [21]	|

You really don't wanna to lose slacker of the month award since you are you are coming dangerously close to the end of the month with your local board overviews.    Joke aside, another incredibly detailed overview  so no wonder that it takes you quite some time to finish it.


Nope, I don't have ninjastic.space data prior to August 2021. I can prepare something next week (no guarantees dee my tendency to  procrastinate  ) unless you do it by yourself.

I changed the total time from 90sec to 120sec. It will be a little slower now! THanks for the suggestion.


Do you have the data of Russian of those months from ninjastic.space?


I can just add them now so it doens't show zero.

Slacking has ended and I finally published my META update.
Thank you very much @Rikfip for your incredible work I used in my post there!

bitmover, you really did great job, thank you.
I watched your animation and really enjoyed it, it's much clearer and more transparent than ordinary statistical data in numbers.
Of course, I focused on my Croatian local board and it was really interesting how we rose and fell on the list of local boards over time 
Can the animation be a little slower?
Anyway, thanks for a job well done!
It was really interesting to watch.

Awesome work, thank you!

Few notes:
-Can you also make it to show accumulative posts throughout the years, instead of showing each month separately?
-As other pointed out, Russian board has issue and that's because up until 2021 (more precisely from August 2021 overview ) I was using Merit Dashboard that calculates total amount of posts different way and can be affected by large amount of deleted posts like it is the case in Russian board. For that reason I switched to ninjastic.space that doesn't take into consideration deleted posts. Having said that, it would be good to use data from ninjatic.space only for these charts of yours.

I am sure that it took you some time to scrape all that data manually from my charts so thank you once again!

As you guys suggested, here is the Local Boards Post Race
https://bitcointalk.org/index.php?topic=5432447.new#new

I am open for suggestions.

Well, since I don't have that data any more than he does, its really up to him to make those racing bars. Thing with those bars is that it would look much better (I guess, bitmover knows more about it) if you use data for each month since creation of the board, instead just yearly values, but that would mean a lot work as some boards are more than 10 years old. Unfortunately, I don't have that amount of free time right now, to manually take all that data from ninjastic.space and merit dashboard.

You know much better than me how this statistic stuff works
It doesn't have to be full comparison between different boards, but we could see dates of creation, activity and number of posts and merits for every year since creation of specific local board.
You can do whatever you think it's best, but if bitmover creates racing bars all that information would look much better.