create account

How does your active follower count on Hive compare to Twitter? by demotruk

View this thread on: hive.blogpeakd.comecency.com
· @demotruk · (edited)
$8.68
How does your active follower count on Hive compare to Twitter?
If I look at my profile on Hive, I see nearly 6000 followers, which seems pretty impressive... but the vast majority of those I got in the first couple of years of Steem, I've been over 5000 for several years and it seems to increase very slowly now.

![image.png](https://files.peakd.com/file/peakd-hive/demotruk/Ep1VP5L7mpwYTWMTf76eZWmHYUbXRcA2isooFNi3YXuerzQkShgmPzUZ1hE3ruA4Cq2.png)

To find how many of my followers voted, or made or edited a comment in the last 30 days, I can run this query on @hivesql. You can run it yourself as well (obviously change it for your username), or I can run it for you if you like.

SELECT COUNT(DISTINCT f.follower) FROM Followers f JOIN TxVotes tv ON f.follower = tv.voter
WHERE f.following = 'demotruk'
AND (tv.timestamp >= DATEADD(day,-30,GETDATE()))

SELECT COUNT(DISTINCT f.follower) FROM Followers f JOIN TxComments tc ON f.follower = tc.author
WHERE f.following = 'demotruk'
AND (tc.timestamp >= DATEADD(day,-30,GETDATE()))

Voted: 783
Commented: 473

Still, it's a lot better than on Twitter where I've got only 233 after 10 years as a user 😭. I don't even know how many of those are active.

![image.png](https://files.peakd.com/file/peakd-hive/demotruk/23tSym8QDVHqnsArsJ85iPQCoqiw6Sdp7E45gC2QdongWubnDAJF3nzK8sPoZTHBqubPK.png)

How about you? Is your presence bigger here on Hive or on Twitter? Where do you get more engagement?
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 12 others
properties (23)
authordemotruk
permlinkhow-does-your-active-follower-count-on-hive-compare-to-twitter
categoryhive
json_metadata{"app":"peakd/2023.4.1","format":"markdown","tags":["hive","twitter","engagement"],"users":["hivesql."],"image":["https://files.peakd.com/file/peakd-hive/demotruk/Ep1VP5L7mpwYTWMTf76eZWmHYUbXRcA2isooFNi3YXuerzQkShgmPzUZ1hE3ruA4Cq2.png","https://files.peakd.com/file/peakd-hive/demotruk/23tSym8QDVHqnsArsJ85iPQCoqiw6Sdp7E45gC2QdongWubnDAJF3nzK8sPoZTHBqubPK.png"]}
created2023-04-07 11:15:21
last_update2023-04-07 11:33:30
depth0
children19
last_payout2023-04-14 11:15:21
cashout_time1969-12-31 23:59:59
total_payout_value4.347 HBD
curator_payout_value4.331 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,379
author_reputation279,182,076,424,485
root_title"How does your active follower count on Hive compare to Twitter?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,332,239
net_rshares15,418,012,901,422
author_curate_reward""
vote details (76)
@acidyo ·
$0.51
It's definitely bigger here, I only started being active on Twitter the last few years mainly due to POSH and spread the Hive word around. Though I gotta say that due to my activity and presence here I do quite good over there as well even though my follower number isn't that high. I often see people with 10-100x my follower count there get less engagement for instance. 

Either way, I'd love a query of my account if you're dishing them out.

I've only gained a few K followers here the last 3-4 years, most were early and in the pump of 2018. 
👍  
properties (23)
authoracidyo
permlinkre-demotruk-rsqtc1
categoryhive
json_metadata{"tags":["hive"],"app":"peakd/2023.4.1"}
created2023-04-07 11:31:15
last_update2023-04-07 11:31:15
depth1
children3
last_payout2023-04-14 11:31:15
cashout_time1969-12-31 23:59:59
total_payout_value0.256 HBD
curator_payout_value0.256 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length548
author_reputation3,333,766,336,004,232
root_title"How does your active follower count on Hive compare to Twitter?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,332,524
net_rshares909,776,371,013
author_curate_reward""
vote details (1)
@demotruk ·
$1.45
Looks like you might(?) be bigger on Twitter but I don't know how to check if Twitter followers are actually active or not.

Active voters: 3771
Active commenters: 2203

Twitter:

![image.png](https://files.peakd.com/file/peakd-hive/demotruk/23twABpY7B2mvEehWR4hZG3385a8UZC8WpwiwDq3xthVNjMZ2YxffSQecKdrgZCWhz6vs.png)
👍  
properties (23)
authordemotruk
permlinkre-acidyo-rsqtke
categoryhive
json_metadata{"tags":["hive"],"app":"peakd/2023.4.1"}
created2023-04-07 11:36:15
last_update2023-04-07 11:36:15
depth2
children1
last_payout2023-04-14 11:36:15
cashout_time1969-12-31 23:59:59
total_payout_value0.724 HBD
curator_payout_value0.725 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length316
author_reputation279,182,076,424,485
root_title"How does your active follower count on Hive compare to Twitter?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,332,625
net_rshares2,571,634,677,105
author_curate_reward""
vote details (1)
@acidyo ·
$0.24
I'm planning on creating the next POSH contest to get people to follow others on Twitter based on who they follow here, even though that technically creates an "echochamber" I think that as long as we grow and amplify each others tweets it might help. It's also very easy to do that now thanks to the Twitter Icon next to people's usernames if they've linked it on POSH, you just go to someone's profile, click the icon and follow them on Twitter.

Thanks for the data! 
👍  
properties (23)
authoracidyo
permlinkre-demotruk-rsqtpg
categoryhive
json_metadata{"tags":["hive"],"app":"peakd/2023.4.1"}
created2023-04-07 11:39:18
last_update2023-04-07 11:39:18
depth3
children0
last_payout2023-04-14 11:39:18
cashout_time1969-12-31 23:59:59
total_payout_value0.121 HBD
curator_payout_value0.122 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length470
author_reputation3,333,766,336,004,232
root_title"How does your active follower count on Hive compare to Twitter?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,332,674
net_rshares433,410,623,875
author_curate_reward""
vote details (1)
@demotruk ·
Do you have a spreadsheet of the mapping of POSH Hive accounts to Twitter Hive accounts, because maybe I could do an overall comparison of Hive user engagement on Twitter and Hive. Although I'm already having second thoughts because I remember that the Twitter API is going basically paid only...
properties (22)
authordemotruk
permlinkre-acidyo-rsqtoz
categoryhive
json_metadata{"tags":["hive"],"app":"peakd/2023.4.1"}
created2023-04-07 11:39:00
last_update2023-04-07 11:39:00
depth2
children0
last_payout2023-04-14 11:39:00
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length296
author_reputation279,182,076,424,485
root_title"How does your active follower count on Hive compare to Twitter?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,332,666
net_rshares0
@djbravo ·
$0.48
The most followers I have are above hive too. Because I work on it for about eight to ten hours a day and talk to people about comments. It's great to talk to people from all over the world and see what's going on around the world. Earlier Twitter used to open once or twice in a week but now because of Post Token I am opening it daily to bring people there too on hive.
👍  
properties (23)
authordjbravo
permlinkre-demotruk-202347t164327705z
categoryhive
json_metadata{"tags":["hive","twitter","engagement"],"app":"ecency/3.0.31-vision","format":"markdown+html"}
created2023-04-07 11:43:30
last_update2023-04-07 11:43:30
depth1
children0
last_payout2023-04-14 11:43:30
cashout_time1969-12-31 23:59:59
total_payout_value0.241 HBD
curator_payout_value0.241 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length371
author_reputation358,042,168,302,155
root_title"How does your active follower count on Hive compare to Twitter?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,332,729
net_rshares858,747,173,313
author_curate_reward""
vote details (1)
@gudnius.comics ·
I'm pretty sure I have more followers here. I'm not really a twitter person so I don't post anything there. Hive is a better place for gaining followers anyway because we can do way more stuff here in terms of content.
properties (22)
authorgudnius.comics
permlinkrssw54
categoryhive
json_metadata{"app":"hiveblog/0.1"}
created2023-04-08 14:27:15
last_update2023-04-08 14:27:15
depth1
children0
last_payout2023-04-15 14:27:15
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length218
author_reputation47,305,557,755,168
root_title"How does your active follower count on Hive compare to Twitter?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,361,724
net_rshares0
@hjrrodriguez ·
Firstly, it has a large number of followers on #Hive compared to #Twitter, I have practically the same number, although I don't give it much importance, I try to be active on both and get the best results.
properties (22)
authorhjrrodriguez
permlinkre-demotruk-202348t93428335z
categoryhive
json_metadata{"tags":["hive","twitter","engagement"],"app":"ecency/3.0.39-mobile","format":"markdown+html"}
created2023-04-08 13:34:27
last_update2023-04-08 13:34:27
depth1
children0
last_payout2023-04-15 13:34:27
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length205
author_reputation187,570,921,363,641
root_title"How does your active follower count on Hive compare to Twitter?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,360,654
net_rshares0
@holoz0r ·
$0.24
There used to be a tool for Steem called "dead followers" , did anyone ever port that to HIVE? I guess they could with your query, and allow the user to change the time span. 

I know that most of my followers are "probably" dead. 

I'd much rather see a "network size" to see how many users are interacting and commenting, much like Asher's engagement league. 
👍  
properties (23)
authorholoz0r
permlinkre-demotruk-rsrm7f
categoryhive
json_metadata{"tags":["hive"],"app":"peakd/2023.4.2"}
created2023-04-07 21:54:51
last_update2023-04-07 21:54:51
depth1
children2
last_payout2023-04-14 21:54:51
cashout_time1969-12-31 23:59:59
total_payout_value0.120 HBD
curator_payout_value0.120 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length361
author_reputation530,234,620,030,343
root_title"How does your active follower count on Hive compare to Twitter?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,346,028
net_rshares422,932,650,478
author_curate_reward""
vote details (1)
@demotruk ·
$0.03
There did used to be some great tools for showing a network graph of interacting users, but I don't think they made the transition to Hive either sadly. If you're interested, here's the amount of your followers still voting and commenting in the last 30 days:

Voting: 598
Commenting: 354
👍  
properties (23)
authordemotruk
permlinkre-holoz0r-rsrnfa
categoryhive
json_metadata{"tags":["hive"],"app":"peakd/2023.4.2"}
created2023-04-07 22:21:12
last_update2023-04-07 22:21:12
depth2
children1
last_payout2023-04-14 22:21:12
cashout_time1969-12-31 23:59:59
total_payout_value0.017 HBD
curator_payout_value0.017 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length288
author_reputation279,182,076,424,485
root_title"How does your active follower count on Hive compare to Twitter?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,346,585
net_rshares63,648,521,510
author_curate_reward""
vote details (1)
@holoz0r ·
$0.14
Thanks for looking that up for me. I guess that is what I probably expected in terms of numbers. 

I remember those charts. It also had the voting networks visualised so you could pretty quickly identify those who did vote trading and exchanges that were less than reputable. Sure the same can be quickly identified through some basic analysis these days, but I prefer to instead focus on delivering quality engagement and trying to find burgeoning content creators who deserve more attention. 

It's been a rewarding few weeks since I stopped using dlease to lease out my HP, and started hunting for my own curation rewards. 
👍  
properties (23)
authorholoz0r
permlinkre-demotruk-rsrnvy
categoryhive
json_metadata{"tags":["hive"],"app":"peakd/2023.4.2"}
created2023-04-07 22:31:12
last_update2023-04-07 22:31:12
depth3
children0
last_payout2023-04-14 22:31:12
cashout_time1969-12-31 23:59:59
total_payout_value0.070 HBD
curator_payout_value0.071 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length626
author_reputation530,234,620,030,343
root_title"How does your active follower count on Hive compare to Twitter?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,346,843
net_rshares253,138,190,904
author_curate_reward""
vote details (1)
@josediccus ·
$0.25
Twitter's engagement these days is being determined by the blue tick. Infact the engagement has gotten worse since Elon musk took over. As for part of your followers. I've been an ardent follower of yours and only started commenting. It's better here on hive because it's more organic. The fakery on Twitter is just too much.
👍  
properties (23)
authorjosediccus
permlinkrsqtmj
categoryhive
json_metadata{"app":"hiveblog/0.1"}
created2023-04-07 11:37:33
last_update2023-04-07 11:37:33
depth1
children2
last_payout2023-04-14 11:37:33
cashout_time1969-12-31 23:59:59
total_payout_value0.122 HBD
curator_payout_value0.123 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length325
author_reputation2,586,734,951,759,406
root_title"How does your active follower count on Hive compare to Twitter?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,332,647
net_rshares437,513,691,772
author_curate_reward""
vote details (1)
@demotruk ·
$0.16
Isn't it funny how on a platform where we essentially get paid to engage, engagement feels more authentic here than it does on Twitter where everything is free. I think that is essentially because of the large but non-obvious incentive on Twitter to harvest people's attention for financial gain (eg. promote covert advertisements and scams). While every single engagement on Hive is a potential earning, that potential is limited and the scope of earnings from attempting to harvest attention is not enough to justify those types of behavior. Perhaps even more importantly, attempting such strategies damages your ability to earn in the normal way on Hive. It would risk all your comments getting downvoted, which then proceeds to limit your reach.
👍  ,
properties (23)
authordemotruk
permlinkrsqunm
categoryhive
json_metadata{"app":"hiveblog/0.1"}
created2023-04-07 11:59:48
last_update2023-04-07 11:59:48
depth2
children1
last_payout2023-04-14 11:59:48
cashout_time1969-12-31 23:59:59
total_payout_value0.077 HBD
curator_payout_value0.078 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length749
author_reputation279,182,076,424,485
root_title"How does your active follower count on Hive compare to Twitter?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,332,997
net_rshares277,554,354,613
author_curate_reward""
vote details (2)
@josediccus ·
$0.23
You're absolutely right, another thing I think is that the whole ideas of web2 social apps are meant to take advantage of the larger population, for the gains of a few. Monetize their data, while creating a lot of fakery in the process. Like you said, hive is tailored in ways where the system blends one to good behavior that can be prospectively Incentivizating, and such good play helps one grow a decent reputation. It's the wild wild west on Twitter, but because it's already established, the rot is always overlooked.
👍  
properties (23)
authorjosediccus
permlinkrsquvc
categoryhive
json_metadata{"app":"hiveblog/0.1"}
created2023-04-07 12:04:24
last_update2023-04-07 12:04:24
depth3
children0
last_payout2023-04-14 12:04:24
cashout_time1969-12-31 23:59:59
total_payout_value0.114 HBD
curator_payout_value0.114 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length523
author_reputation2,586,734,951,759,406
root_title"How does your active follower count on Hive compare to Twitter?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,333,106
net_rshares406,351,765,916
author_curate_reward""
vote details (1)
@kawsar8035 ·
You have shared a very nice topic through which I learned something new and learned about Hive and Twitter followers.
properties (22)
authorkawsar8035
permlinkre-demotruk-rsr2wj
categoryhive
json_metadata{"tags":["hive"],"app":"peakd/2023.4.1"}
created2023-04-07 14:57:54
last_update2023-04-07 14:57:54
depth1
children0
last_payout2023-04-14 14:57:54
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length117
author_reputation392,636,640,737,274
root_title"How does your active follower count on Hive compare to Twitter?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,336,645
net_rshares0
@les90 ·
Sometimes i think maybe these followers are bot who are not active or might possible they're now leaving hive as it's bit complicated to under but One who got it and know about it than won't want to leave it but I'm really surprised to see your actual followers and your active followers 😐 

I think if someone not active since a year than hive should automatically deactivate his account to clean or pure the system. 

I listen that hive is a ocean of people but believe me i see little less as compare to my expectations 
properties (22)
authorles90
permlinkre-demotruk-202347t172833280z
categoryhive
json_metadata{"tags":["hive","twitter","engagement"],"app":"ecency/3.0.39-mobile","format":"markdown+html"}
created2023-04-07 12:28:33
last_update2023-04-07 12:28:33
depth1
children0
last_payout2023-04-14 12:28:33
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length523
author_reputation81,475,002,142,031
root_title"How does your active follower count on Hive compare to Twitter?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,333,503
net_rshares0
@poshtoken ·
https://twitter.com/1474070952325656577/status/1644696448376754177
<sub> The rewards earned on this comment will go directly to the people sharing the post on Twitter as long as they are registered with @poshtoken. Sign up at https://hiveposh.com.</sub>
properties (22)
authorposhtoken
permlinkre-demotruk-how-does-your-active-follower-count-on-hive-compar-531738312
categoryhive
json_metadata"{"app":"Poshtoken 0.0.1","payoutToUser":[]}"
created2023-04-08 13:39:33
last_update2023-04-08 13:39:33
depth1
children0
last_payout2023-04-15 13:39:33
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length254
author_reputation5,349,669,350,592,856
root_title"How does your active follower count on Hive compare to Twitter?"
beneficiaries
0.
accountnomnomnomnom
weight10,000
max_accepted_payout1,000,000.000 HBD
percent_hbd0
post_id122,360,740
net_rshares0
@rafzat ·
$0.23
The truth is that I have many followers on Hive than the one that I have on Twitter. It is even easy to get followers here than Twitter and that is why I mostly prefer to come here
I no longer use my Twitter account like before.
👍  
properties (23)
authorrafzat
permlinkre-demotruk-202347t16728304z
categoryhive
json_metadata{"tags":["hive","twitter","engagement"],"app":"ecency/3.0.39-mobile","format":"markdown+html"}
created2023-04-07 15:07:30
last_update2023-04-07 15:07:30
depth1
children0
last_payout2023-04-14 15:07:30
cashout_time1969-12-31 23:59:59
total_payout_value0.114 HBD
curator_payout_value0.114 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length228
author_reputation183,560,271,702,716
root_title"How does your active follower count on Hive compare to Twitter?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,336,882
net_rshares405,931,043,558
author_curate_reward""
vote details (1)
@sanach ·
I think this one platform is enough good to engage with the community rather than from Twitter but for the new updates sometimes look at it for a while. Nice post. 💙 
properties (22)
authorsanach
permlinkre-demotruk-202348t131514676z
categoryhive
json_metadata{"tags":["hive","twitter","engagement"],"app":"ecency/3.0.39-mobile","format":"markdown+html"}
created2023-04-08 08:15:18
last_update2023-04-08 08:15:18
depth1
children0
last_payout2023-04-15 08:15:18
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length166
author_reputation135,519,337,337,704
root_title"How does your active follower count on Hive compare to Twitter?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,355,663
net_rshares0
@tornad · (edited)
$0.50
I have more followers on hive than twitter because I don't spend much time on Twitter, I use hive whenever I'm free. On Twitter, I just go to get an update to see if there is an update about politics, sports etc or not. 
👍  
👎  ,
properties (23)
authortornad
permlinkre-demotruk-202347t163258359z
categoryhive
json_metadata{"tags":["hive","twitter","engagement"],"app":"ecency/3.0.31-vision","format":"markdown+html"}
created2023-04-07 11:32:57
last_update2023-04-07 11:33:42
depth1
children0
last_payout2023-04-14 11:32:57
cashout_time1969-12-31 23:59:59
total_payout_value0.250 HBD
curator_payout_value0.249 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length220
author_reputation54,966,731,255,881
root_title"How does your active follower count on Hive compare to Twitter?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id122,332,571
net_rshares887,759,698,485
author_curate_reward""
vote details (3)