farcasterunion

The trend for active FIDs with spam label 2 is still upwards, and the number of active FIDs with spam label 0 is still going down.

ATM, 43.4% of this (non-closed) month is spam label 2 (not spammy), and 54.3% of all engagement comes from spam label 2 accounts.
https://dune.com/nhejyht/farcaster-monthly-dashboard

On the daily data, you will indeed see a decrease, but I think this is due to the introduction of the pro subscriptions that enthused casters, the effect of which has now worn off.
https://dune.com/nhejyht/farcaster-dashboard

Overall, Farcaster is going in the right direction

Interests: crypto, economics, TA & blockchain related innovations | 🔗 https://linktr.ee/cryptonjal 🔗 https://dune.com/nhejyht

Pi-chi.eth Artist /animeoutcasts
Hosting: /sakura /kyoto /anime-manga /farcasterunion

https://portrait.so/pichi

I didn’t realize you could track when they last liked!

I learned something new! I always forget how powerful dune is. 

Is there a better way to
Visualize that? Aka 30% of your level 2 followers were active in the last week?

The days_since_last_activity column shows how many days ago someone cast, replied or liked. Deliberately not just casts because some people sometimes temporarily do not cast, but are active. In standard sorting the script also takes into account last activity. Is this sufficient? Or do you want to see it specifically from casts?

For your followers audit, do you think you can add in something about when your followers last casted?

I’m trying to figure out how many followers of mine are active. I only care about label 2 folks as well. 

I think looking at follower numbers is the wrong thing to look at. It’s about how many of them are truly active. The team hasn’t shared a formal definition but I’d love to see who casted in the last day, 3 days, week, etc. 

Does that seem like it’s more helpful to see who is actually here?