Content
@
0 reply
0 recast
0 reaction
Ghostlinkz
@ghostlinkz.eth
The problem with the Warpcast Power Badge is that many spammers have it. Here's a list of the top 100 casts with the most recasts in the last 24 hours, made by users with the Power Badge data.hubs.neynar.com/public/dashboards/b1FfpKPs0IPEVvsopekEgCrlJK7a8CqARAeMRSvC To create a clean list, I had to manually filter out 145 FIDs that are spamming but still have the Power Badge. You can find the list of these accounts here docs.google.com/spreadsheets/d/1SMqs9VqucNo93k9doDJZMBtUwp4OjuzdwLjBo22MnNA If I can identify these accounts with a reasonable amount of effort, then so can the Warpcast team. As it stands, the Power Badge is not very useful. Don’t just take my word for it, analyze the data via @neynar
62 replies
13 recasts
70 reactions
Samo
@samo.eth
I was curious who they are so I made a query: https://dune.com/queries/3849118 Are you sure they're spammers? I see a few I held in high regard: - Nikolai, the builder of the best Degen dashboard - the Aerodrome company account - some ppl I interacted with on FC for a long time
9 replies
0 recast
17 reactions
Pichi 🟪 🍡🌸
@pichi
I need to learn dune. You did in 5 minyed which took me grabbing the laptop to run vlookups and half of these casters are my friends.
7 replies
1 recast
10 reactions
Tmophoto
@tmophoto
dune is an absolute superpower. start with existing queries and use some kind of AI for assistance in modifiying them. you start to burn up credits fast so be careful. just learning existing queries and dashboards is a superpower, there is so much on there for farcaster.
3 replies
0 recast
2 reactions
SQX
@sqx
Chatgpt. Tell it you are queried in trino. Just have to know the right functions to call. 111 $degen
3 replies
0 recast
0 reaction
Samo
@samo.eth
Dune rocks sometimes, yes! But from my own experience it's important to have great data sources for it (tables, queries by other users, etc) And re the casters on the list - it's the OP's opinion, with a filter based on sentiment. I like DATA better for data analysis, that's why I insisted...
1 reply
0 recast
0 reaction
Kenji
@kenjiquest
Reach out to @saxophone55.eth He’s our Japanese Dune Powerhouse
1 reply
0 recast
0 reaction
Andrew
@77luka.eth
I made the naughty list 😭
2 replies
0 recast
2 reactions
Ryan J. Shaw
@rjs
Excel is a data-based programming language... The equivalent of "vlookup" in SQL is "join"!
0 reply
0 recast
1 reaction
Diana🎩
@dianacutie.eth
Your friends who have a pb rn
0 reply
0 recast
0 reaction
