dune

headmaster @duneanalytics, previously mirror and consensys

hey @ilemi, love and often use your farcaster explorer dash. how would one edit your active farcaster users query to filter out specific top channels?

Might try these also, brother, I use them daily when scoping for farcaster data / moxie FT hunting:

1)  https://dune.com/ilemi/farcaster-explorer by @ilemi (scroll bottom for channels, can sort by whatever filter/column header you would like)
2) https://dune.com/ryanjshaw/ultimate-moxie-dashboard by @rjs (moxie data, but also useful user and channel statistics you may find helpful)

Hope you are well, wake!  God speed!

Husband, dad, dev • @dune.eth wizard • Ultimate Ⓜ️oxie Dashboard https://tinyurl.com/moxiedash • Ultimate Degen Tips FAQ https://tinyurl.com/degenfaq

linktr.ee/drakhonen

ETH | SOL | XTZ | PFP: 👺 @aXrNFT

💻 /drak-support 🖖 /drak-thedegen 👻 /chatbfg

yep, i have both open right now. the query i asked about is part of the explorer dashboard. it pulls in a lot of data and with it a lot of noise. but if recurring bot-friendly channels can be filtered out, it might also surface new and newly successful farcasters.

You should definitely be able to filter out certain channels. Whats the link for the dune dashboard you’re talking about?

This one? If you fork the query you can use dunes AI assistant to try to edit the query with what you’re trying to filter. I can also give it a shot later today. Any specific channels you are trying to filter out?

This one? If you fork the query you can use dunes AI assistant to try to edit the query with what you’re trying to filter. I can also give it a shot later today. Any specific channels you are trying to filter out?

https://dune.com/queries/3418402/5739663

yeah, the farcaster explorer dash with the "all active farcasters" query.