Y'know, it would be neat if the follower count showed which were still active.
XXXX followers (XXX active in the past 30 days)
Y'know, it would be neat if the follower count showed which were still active.
XXXX followers (XXX active in the past 30 days)
I was looking at this recently and @hivesql can easily tell you. For @acidyo 1634/33002 followers have been active this year, so about 5%. For me it was nearer 10%. It's about the same for you with 316/3230.
select count(*)
from followers f
join accounts a on a.name=f.follower
where following='acidyo'
and a.last_post > '2026'
Cool! Thanks for this.
For me it is 541 out of 1295
That's a pretty good rate really. I hope some more will come back.
Thanks. I think a lot of new users come from recent projects and initiatives I've been doing. And interactions of course 😊