Content
@
https://warpcast.com/~/channel/farcasterunion
0 reply
0 recast
0 reaction
Njal
@cryptonjal
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
2 replies
2 recasts
6 reactions
Pichi
@pichi
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?
1 reply
0 recast
1 reaction
Njal
@cryptonjal
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?
1 reply
0 recast
1 reaction
Pichi
@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?
2 replies
0 recast
2 reactions
Njal
@cryptonjal
Added two pie charts for active label 2 (active in the last 7d and 30d) https://dune.com/nhejyht/farcaster-followers-audit
3 replies
1 recast
11 reactions
darkknight_utk 🎩
@darkknightutk
This is awesome 😎
0 reply
0 recast
1 reaction
