farcasterunion

When I run @mvr ‘s cool new Dune query for active, non spammy followers, I get some interesting results. 

1. Quality casters (level 2 spam label: the good one) who casted at least 4 times in 30 days (aka once a week):
5640

2. Who casted 2/3 times a week: 
3,191

3. Who casted every day for the past month: 
1,122

If you are here to vibe everyday, probably more important to engage with group 3 the most.  

You can change the parameters of the Dune query yourself to what you consider “active/engaged”.

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

When I run @mvr ‘s cool new Dune query for active, non spammy followers, I get some interesting results. 

1. Quality casters (level 2 spam label: the good one) who casted at least 4 times in 30 days (aka once a week):
5640

2. Who casted 2/3 times a week: 
3,191

3. Who casted every day for the past month: 
1,122

If you are here to vibe everyday, probably more important to engage with group 3 the most.  

You can change the parameters of the Dune query yourself to what you consider “active/engaged”. 

https://dune.com/queries/4761620?previous_days_t6c1ea=30&times_casted_t6c1ea=4

Pi-chi.eth (she/her) Artist /animeoutcasts
Purple Promoter| Hosting: /moxietools /kyoto /momiji  /anime-manga /farcasterunion

https://portrait.so/pichi

You keep helping people even when you don't need to. Thank you for always.

In summary, any one with label 0 if they interact with the 3rd category of user stated in your cast. their spam label can change, Correct?

Devot Christian || Product Manager || Customer success manager || Diehard Arsenal fan ||  who is passionate about leadership  😊😊

Anyone’s labels can change. We want to save good people who have been mislabeled.

Ofcourse yes. I just wanted to be sure I understood your analysis.