Warpcast

What if, Warpcast would only show active followers?

Let's call it the Purge 2.0. But what is the definition of active? Let's take 5 casts in the past 60 days. @geoffgolberg is that any good? 

Add this to a @dune.eth query and we have an active followers number, take out L0 spammers and we get an even lower active quality followers number. 

With above parameters, @dwr.eth has 20,5k active qfollowers. How many do you have? Check in the dune query below

Working on Farcaster and Warpcast. Longer thoughts at https://dwr.email

I like running, poker and oysters | Founder, Social Forensics (SocialForensics.com) | Berkeley & UPenn | Learning to listen

What if, Warpcast would only show active followers?

Let's call it the Purge 2.0. But what is the definition of active? Let's take 5 casts in the past 60 days. @geoffgolberg is that any good? 

Add this to a @dune.eth query and we have an active followers number, take out L0 spammers and we get an even lower active quality followers number. 

With above parameters, @dwr.eth has 20,5k active qfollowers. How many do you have? Check in the dune query below

https://dune.com/queries/4761620

Interesting thought. Interesting for analysing followers. If I use 1 cast in the last 30 days on a fork (thanks Claude for the edits 😁) of this Dune query, there seems to be relative more quality casters inactive than active (well, at least for mine and your account).
https://dune.com/queries/4761920?previous_days_t6c1ea=30&times_casted_t6c1ea=1

hamst.art $hamster /hamster 
martinvr.eth 
deploy.degen.eth

Interests: crypto, economics, TA & blockchain related innovations | Links: https://linktr.ee/cryptonjal

You don't have to fork you can change days / casts in the input boxes below the query :)

I'm not that old 😆
I just wanted more detailed figures