Content pfp
Content
@
0 reply
0 recast
0 reaction

Ryan J. Shaw pfp
Ryan J. Shaw
@rjs
FID vs. OpenRank "Engagement" Ranking: - https://dune.com/queries/3901607 - *ridiculously heavily* skewed towards the earliest users of Farcast - Why? Because the algorithm starts off by selecting a trusted group of core users based on metrics heavily biased in favor of early users (see https://docs.openrank.com/integrations/farcaster/ranking-strategies-on-farcaster). - early users receive multiple boosts to engagement due to similar algorithms being used everywhere (e.g. Power Badge, Degen Tips), which results in a positive feedback loop. FID vs. Follower Count: - https://dune.com/queries/3901623/6557858 - nearly impossible for users who registered after a certain point to create the mega followings of the earliest users Why not use first cast or registration date? Dune's Neynar data doesn't have this <= 2023-09. If anybody has an alternative data source I can use on Dune, it would be much appreciated. Next: I investigate the degree of cliquiness in early users, if anybody is interested?
30 replies
14 recasts
70 reactions

mvr šŸ¹ pfp
mvr šŸ¹
@mvr
Our links data in @dune.eth is weird btw. e.g. you have batches of multiple follows within 0ms. timestamp is before created_at... https://dune.com/queries/3902281?fid_n26d66=426045 What do you think that caused those, hub sync issues? new autofollows? Does this affect all other metrics we create from @dune.eth?
1 reply
0 recast
0 reaction

Ryan J. Shaw pfp
Ryan J. Shaw
@rjs
Maybe they process the stuff off a queue and batch reads/writes to the queue?
1 reply
0 recast
0 reaction