Over the years on Hive I've created quite a few Hive accounts manually with my primary account 
SELECT Count(DISTINCT new_account_name) FROM TxAccountCreates WHERE creator = 'demotruk'
83
Reviewing the names, three categories emerge.
SELECT new_account_name FROM TxAccountCreates WHERE creator = 'demotruk'
There are my own accounts, gift accounts for friends and family, and users I helped to onboard, generally on Hive Telegram.
Sadly, of the 83 created accounts, only 6 are still making transactions since Nov 1.
SELECT Count(DISTINCT author) FROM TxComments JOIN TxAccountCreates ON author = new_account_name WHERE TxAccountCreates.creator = 'demotruk' AND TxComments.timestamp > '2021-11-01 00:00:00.000'
6
Of those, one is my own account and another is my wifes, so of the others only 4 are active, and none of the gift accounts are active.
SELECT DISTINCT author FROM TxComments JOIN TxAccountCreates ON author = new_account_name WHERE TxAccountCreates.creator = 'demotruk' AND TxComments.timestamp > '2021-11-01 00:00:00.000'
@jianil90
@lucieagboola
@demotruktrade
@ruscom
@golodriga
@yunnie
Of the 4 still recently active, they are still pretty new. 2 at least,
Of the less recently created accounts, not a single one is still active.
It's hard to get going on Hive. Aside from creating the account itself and often a small Hive Power delegation, I didn't really help any of these users to get going. I see some groups of new users getting kick started straight to the front page (eg. the group from Cebu, Philippines, and many from Vietnam recently), but without the kind of camaraderie and/or assistance from established users, it is a struggle. Yet, objectively it is less difficult here to reach earnings than on other platforms based on simple numbers - it's a much smaller percentage of Youtube creators that even see a single penny, on the other hand the median payout on posts here is now above $2, ie. half of all posts make enough money to buy a can of coca cola.
My hope is that the apps themselves are worth sticking around for on Hive in the future, even if most users don't make a significant monetary return on the time they spend here.
