[CHARTS] Brief monthly overview of the local boards activity

[joker_josue]

I am really interested in yearly review, or something I suggested before to show historical activity of local board from the first day they got created, and it doesn't need to contain all the details, but only important stuff.

You mean like total amount of posts created/merits shared since creation? I am not sure how that would look like since some local boards were created in 2010 while some in 2014 so it wouldn't really be fair comparison. Or you had something else in mind?

A historical report from the beginning I won't say, because, as I said, the local boards appeared in different years, and therefore an analysis would not be realistic.

Now doing an annual analysis could be interesting, to get a simpler and more practical view of how things were developing in 2022.

[WatChe]

Thank you, Rikafip, for this brilliant effort. These stats will definitely help the Pakistani community here in proving the fact that they are very much active and rightly deserve their separate board. Just a quick question from my side (please ignore my ignorance), how do you compute these stats? You have some code that do this job for you?

[Rikafip]

Just a quick question from my side (please ignore my ignorance), how do you compute these stats? You have some code that do this job for you?

All the data that you can see in this overview can be found in @DdmrDdmr Merit Dashboard and @TryNinja Ninjastic.space, I just use it to create the charts (via Google Sheets) and the table and the same thing (afaik) goes for other members that are doing similar overviews for their own local boards.

[bitmover]

Someone could also make one of those animated racing bars that most of us like to see.

That's actually a very good idea and something I would like to see as well. I don't know how to do it though (maybe its done in Powerpoint or similar tool?) so maybe @bitmover (iirc he was the one making them) could do it, if he can be bothered with it.

That's a nice idea.

I would love to make a racing of all local boards activity.

Do you have this data in a .xlsx file @Rikaflip? Or a csv? I would love if you can share with me the number of posts and the merits of each month/day . It would save me a lot of time scraping this topic.

[Rikafip]

I would love to make a racing of all local boards activity.

Awesome to hear that, thanks a lot!

Do you have this data in a .xlsx file @Rikaflip? Or a csv? I would love if you can share with me the number of posts and the merits of each month/day . It would save me a lot of time scraping this topic.

No need to scrape this topic, I will send you .csv files in about ~2 weeks as I have to wait until January 6th for December merit data to have a full year.

[dkbit98]

You mean like total amount of posts created/merits shared since creation? I am not sure how that would look like since some local boards were created in 2010 while some in 2014 so it wouldn't really be fair comparison. Or you had something else in mind?

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.

[Rikafip]

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.

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.

[bitmover]

Someone could also make one of those animated racing bars that most of us like to see.

That's actually a very good idea and something I would like to see as well. I don't know how to do it though (maybe its done in Powerpoint or similar tool?) so maybe @bitmover (iirc he was the one making them) could do it, if he can be bothered with it.

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.

[Rikafip]

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.

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!

[Daniel91]

Someone could also make one of those animated racing bars that most of us like to see.

That's actually a very good idea and something I would like to see as well. I don't know how to do it though (maybe its done in Powerpoint or similar tool?) so maybe @bitmover (iirc he was the one making them) could do it, if he can be bothered with it.

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.

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.

[fillippone]

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]

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.

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.

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

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!

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.

[Rikafip]

Slacking has ended and I finally published my META update.

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.

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.

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.

[Rikafip]

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]	|

[DdmrDdmr]

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.

[Rikafip]

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.

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.

[fillippone]

As I promised couple of weeks ago, here is the first yearly overview of the local board activity.

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

[bitmover]

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).

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!

[DdmrDdmr]

<…>

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.

[fillippone]

(Data derived from ninjastic)

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