As some of you already know, I'm currently trying out the wonderful Github Copilot to improve my programming skills and I have to say that it's working really well. As I've been in IT for a very long time, some things are perhaps easier for me than others. And this morning I thought to myself that I would like to write another little helper script - ideally for Hive, as I like to develop things here. I thought to myself that I could actually ask a few questions about things that are not really transparent here. I thought to myself, since Inleo is currently advertising that they have managed to have 13,000 active people interacting on Inleo who actively participate in the community life every month. So I sat down and started by looking at the accounts created by the leo.voter account in 2024. This was actually quite simple, as I used the hafSQL connection to @mahdiyari again. Using the following SQL command I got a nice list of 18,531 hive accounts and thought to myself - WOW! That's really a lot of accounts in a whole year on one service alone and InLeo managed to onboard the masses. I used the following SQL command:
SELECT new_account_name, timestamp, block_num
FROM vo_account_created
WHERE creator = 'leo.voter'
AND timestamp >= '2024-01-01 00:00:00'
AND timestamp < '2025-01-01 00:00:00'
ORDER BY timestamp ASC;
If you are interested in the entire output of the data, you will find a list of the accounts here, separated by commas:
https://img.inleo.io/DQmV7i9zaVQyKh7srw6N7zbzLiHqEoFzcgafaSgRtYHK9hD/accounts.txt
or here simply the SQL JSON dump
https://img.inleo.io/DQmPi44DFdBWciEkt41GBgnkJec8umdXMkEn1qT4pdN9Ezg/inleo_signups_2024.json
Ok, I thought to myself - that worked! Now I have valid data and I can start building a frontend so that I have a control command line or simply a dashboard with which I can push my beautiful data back and forth. No sooner said than done! I launched Visual Studio Code, gave Github Copilot a few treats as a reward for a job well done and off I went. I told the Copilot that I wanted to have a dashboard that analyzes and processes the data from the json so that I can take a closer look at what actually happened in the whole year 2024 with the accounts created by leo.voter. After a few lines, the first dashboard was ready - by either 1) uploading my json file or 2) entering a specific date from and to and then querying the hafSQL database. Then at 3) the data is displayed in a diagram, depending on the month how many users were onboarded.
Ok, based on this data you can of course make further great queries with hafSQL to maybe find out a few more details about what the accounts did on the blockchain and how long they were really active - yes, I know - this is only based on data created using leo.voter accounts but even that alone should provide interesting data - as this is the main onboarding point at Inleo. So let's summarize the actual numbers of onboarded users created in 2024 broken down to months:
January: 833
February: 1011
March: 1372
April: 1153
May: 1029
June: 781
July: 1066
August: 1146
September: 942
October: 1310
November: 1344
December: 6544
As I don't want to make this post too long, I'm only highlighting the data that I found in December 2024. I wanted to find out how active, i.e. how many interactions individual users have made - and I am only counting the “comments” here, as this is the main activity at Inleo - so rather the threading which is technically just a comment. So based on the data I found, I can say here that out of 6544 accounts created, only 3486 accounts have had at least one interaction - the remaining 3058 accounts have unfortunately not written a comment and are unfortunately not included in these statistics - but hey, your time will certainly come in 2025 to actively participate in the ecosystem. Be that as it may - of the 3486 accounts that have carried out at least one interaction, 2557 have actually only carried out one interaction. Just 308 accounts carried out exactly 2 interactions. Only 70 accounts thought that all good things come in threes. So 70 only interacted with Inleo or the Hive Community 3 times.
62 accounts have interacted exactly 4 times. What's amazing is that 121 accounts interacted exactly 5 times in December - probably because of the referral bonuses. This leaves only 368 accounts that have interacted more than 5 times. At this point, there is only one person to congratulate: @iamctgroot You made a lot of great interactions in December at Inleo. Congratulations
But what do we learn from these statistics, which anyone can more or less call up and think about?
Well, we actually want more people like these people, people who believe in the platform, the ecosystem and buy HIVE, who are actively involved and feel comfortable in our hive ecosystem. People like these - who were onboarded by the leo.voter in the course of 2024 and have built up a fine HIVE Power Balance:
Why am I doing this here?
Ey, very simple... I like to tinker - I like to question things that are obvious, I enjoy programming and I like to educate myself. When I'm not hacking frontends or looking for and finding security vulnerabilities in webpages / servers, I like to educate myself to become faster and more effective. Of course, it's quite possible that I'm being portrayed as an absolute asshole here again - but hey, numbers don't lie and I just want a lot more transparency in our Hive blockchain projects - be it about money that is paid to projects from the DHF or frontends that don't make their source code 100% public. In any case, I won't tire of continuing my research and pointing out anything I notice.
Hands up for more transparency!
Peace out.
Vote for my Hive Witness
U can vote for my Witness using Hive Keychain here: https://vote.hive.uno/@louis.witness
Vote for my Hive Engine Witness
Vote for my Witness on Hive-Engine using Primersion Tool: https://primersion.com/he-witnesses Enter your Username and search for louis.witness
This is great analysis Louis. I wonder out of the 486 accounts that made one comment, how many said more than 5 words 🤔
Interesting :) That's something can be found out. But not now - Now is late and Sleepy Time :)
I have an answer, @louis88 and @livinguktaiwan! A lot of the comments I checked are like this ...
That's disturbing ☹️
It is quite disturbing. Also consider what was said and asked in the proposal of July 28, 2023 (post here so you can read for yourself) to get those results:
Notice that on July 28, 2023, there was no talk of creators and consumers, and nor was there this further slide of the goalpost we are seeing in the comments recently about "Well, 90 percent of people on social media are consumers, so ... ." But if I were on the hook for $241K, and asking for $453K more, I would understand the temptation to slide the goalposts too, if I thought I could get away with it.
I think your ask was very reasonable for 1,000, given that in July we see that there were supposed to be regularly published lists of users. Shouldn't be hard out of 13,000 to find 1,000 if that was done!
That's pretty cool and very telling with the data. Also interesting given they have a proposal out currently asking for a lot of money for onboarding and such. On a separate subject. I was thinking the other day there has to be a way to use the SQL piece of HIVE to locate posts with the same title. It might help track down those recently created accounts that are plagiarizing old posts.
Well, yea thanks for bringing up that topic! I think my investigation work worked wonders because as i daily monitoring the 18,xk Accounts what they are doing and nuked a lot of these plagiarzed posts down. Luckily, i dont see any more from this Group stealing content. So, this was a Win for our Team - The Anti-Fraud/Plag Team, that want HIVE a nice place :)
That's great news! I found one only because the post from the original author had me tagged in it and they didn't bother to change any of the details. I nuked their account from 25 rep down to like 12, then some others took it the rest of the way. I should have assumed you were taking things one step further when I read your other post!
Nice tool and statistics 😀
!BBH
Thank you, that you did the job of @leofinance, I asked for it few days ago
https://ecency.com/hive-167922/@mein-senf-dazu/10k-mau-says-nothing-10k-mau-sagt-nichts-aus-3xn
For a such big Proposal, there has to be much more statistic.
Interesting article from greetings for today.
Not sure I’m finding a lot of this accurate. How about monthly active consumers?
As I’ve said in many places: 90% of social media usage is content consumption, not creation.
The dash team alone is more onboards than the assumptions presented here
We’ve posted our own data post several days ago that has the accurate numbers if anyone’s curious for them.
Give us the stats that shows how many users connected Dash wallet with Keystore.