@bountybot make a bounty for someone to make a dune dashboard that compares Farcaster metrics against the 90-9-1% benchmark rules of content creation in communities

(for reference - https://en.wikipedia.org/wiki/1%25_rule)

Reward: $50 USDC or equivalent

Post bounties and services on Farcaster by tagging me. Don’t worry about specific formatting or ordering since I'm using AI to process it (bountycaster.xyz) /bounties. FAQ: bountycaster.xyz/FAQ

took a quick pass at a query (def not a dashboard), and was surprised how high the numbers were

excluding replies that included "degen" or "tip" and it didn't bring reply participation down much

if only @sayangel put his scores on dune, then we could exclude bot behavior

Creator of /bot-or-not. Contributing to /blitkin & /orange-dao IRL: Building spatial computing for construction @ Resolve YC W15 | FID 1725

/cameron for content experiments. Helping Creators with /seemore. Yapping on /okbanger. Curating in /lounge. Dev + Veteran + HBS. 
seemore.tv/cameron 🫡

took a quick pass at a query (def not a dashboard), and was surprised how high the numbers were

excluding replies that included "degen" or "tip" and it didn't bring reply participation down much

if only @sayangel put his scores on dune, then we could exclude bot behavior

https://dune.com/queries/3810228/6407925

enjoy cats, running, bread, and a bit of w̶e̶b̶3̶ onchain data

that said, these are “all time” figures. without “logins” being onchain, couldn’t figure out how to get these stats for like the past month, for folks who actually logged in

Oh actually this is super interesting - thanks for getting this together!