RE: Snaps Container // 1739612160

[steevc]

I just ran a query with @hivesql to see how many of my followers are active in 2025. Out of over 7100 it is about 1500. That's actually more than I expected. If I ignore those who are just voting it is 755 who posted.

Comments

[louis88]

Noice! Can u share me the Details of it? Would to to check it out with HAFSql and maybe building a little frontend to it :) would be a neat little project.

[steevc]

It's pretty simple:

select count(*)
from Accounts a
join followers f on f.following='steevc' and f.follower=a.name
where a.last_vote_time >= '2025-01-01'
or
a.last_root_post >= '2025-01-01'

[katerinaramm]

Hey! That would be interesting!

[friendlymoose]

Ah, cool! Never thought of that!
I'm one of 755!

Also interesting to see the same over your following.
That way you can see the retention of the people you followed.

[steevc]

I'd been meaning to check this and it's pretty easy really. I've collected those followers over many years and I expected a lot to have dropped off. I wonder how many abandoned accounts are still voting.

[katerinaramm]

If they have the automated hive vote, they could be considered active even if they vote daily (or follow a trail)

[steevc]

I think there will be a lot using Hive Vote, but not checking their accounts. They may have nice rewards to claim. A few will have lost their keys.

[emrebeyler]

can you check mine :)

[steevc]

986 in total, 454 posting.

[curatorcat.ccc]

Given that typical "active usage" on membership sites runs about 5-6% across web forums and the like, that's not too bad, actually...

[steevc]

I think others have run stats on activity. We have lost so many users and don't get enough new ones to really build the activity up.

[curatorcat.ccc]

We lack one key thing other "social" platforms have: an effective peer-to-peer message system. A way to do "relationship marketing." A way for me so send you a message saying "hey Steve, haven't seen you in a while, hope you're OK!" to ping "dead" accounts.

[steevc]

We have messaging in peakd and some other dapps, but that relies on people looking at it. If people drop off then we may lose touch.

[katerinaramm]

Still, where are the remaining ones?
Hey, could you help someone track their first ever post via HiveSQL?

[steevc]

I found yours

Query is:

select *
from Comments c
where c.author ='katerinaramm'
and c.depth=0
order by c.created

[katerinaramm]

Thank you so much!!
Oh I really should start using HiveSQL!!
!BEER
@curamax please let Steve know if you will need your first post or if you somehow managed to find it