Pichi on Farcaster

Content pfp

https://warpcast.com/~/channel/spotlight

0 reply

0 recast

0 reaction

MJC pfp

Three learnings from the $PRO airdrop - The 10k Pro NFT holders list is a good, but not great starting point for a distribution. I wonder if someone (@linda, @pichi ?) could create a dataset that takes the 10k and filters for some basic follower/following/activity metrics) - Mini apps are a good way to build initial distribution. The feed itself is an even better way Both an obvious and somehow non-obvious observation - Raw experiments are more exciting and therefore more likely to spread But on the flipside, raw experiments are harder to advance once they're live. Food for thought

30 replies

24 recasts

230 reactions

Pichi pfp

@mvr @cryptonjal have made a lot of dune queries with data on spam labels. Maybe we need to open rank and Neynar scores too.

3 replies

0 recast

24 reactions

Njal pfp

This is my 10k list https://dune.com/queries/5200345 FIDs above 1,089,899 are 100% farming, based on time, and lack of (label 2) followers. Below 1,089,899 there are also label 0, 2 and no labels, and also bots (e.g. clanker). Neynar is a good addition, but not available on Dune as far as I know. I believe that Openrank is possible on Dune but never tested that. @mvr has data about rewards, so if someone has received rewards it says something about engagement. Also possible to calculate engagement in a certain period before the event in Dune.

3 replies

0 recast

2 reactions

MJC pfp

i think people will appreciate a public easily downloaded csv!

1 reply

1 recast

8 reactions

Amirhassan pfp

@amirhassan5303

Good solution 👌

0 reply

0 recast

0 reaction