Content
@
0 reply
20 recasts
20 reactions
Garrett
@garrett
Farcaster is almost to the millionth FID or registered account What’s the best data source to track DAU now? Does anyone have a good dune?
6 replies
1 recast
35 reactions
tldr (tim reilly)
@tldr
my mental approximation for qDAU is ~50x the number of likes on the most liked cast of the day
3 replies
1 recast
11 reactions
Pichi 🟪🍖🐹🎩 🍡🌸
@pichi
This is my new Bible. Who’s here daily. https://dune.com/queries/4733142
1 reply
0 recast
1 reaction
Garrett
@garrett
This seems pretty accurate from my personal experience. I had always thought that Farcaster Daily Posters oscillated between 10-20k
1 reply
0 recast
2 reactions
Pichi 🟪🍖🐹🎩 🍡🌸
@pichi
My gut stays its right. And the number of good accounts is even lower but I don’t know how you’d pull qDAU? @jc4p is it possible to cross reference this with the public spam labels? I’d like to know how many of these are level 2. My guess would be 2-3k but I’d love to know for real. @mvr would line your thoughts too
1 reply
0 recast
2 reactions
Kasra Rahjerdi
@jc4p
i’m like 80% sure @rish added the labels to the Dune dataset recently, will investigate and see if i can add into my query!
2 replies
0 recast
2 reactions
rish
@rish
It’s in our sql playground, not on dune yet
1 reply
0 recast
3 reactions
Kasra Rahjerdi
@jc4p
ty!! @pichi i’ll run the data for you in neyar’s sql playground so we have a snapshot then add it to the dune later :)
2 replies
0 recast
3 reactions
mvr 🐹
@mvr
fwiw this is the source thats imported to multiple datasets in Dune https://github.com/warpcast/labels not sure if you can rely on any (I mean no guarentees they are updated every week with a fresh set) @rish yours also updates weekly or realtime?
2 replies
0 recast
3 reactions
rish
@rish
neynar data updates every 30 mins or so
2 replies
0 recast
4 reactions
Pichi 🟪🍖🐹🎩 🍡🌸
@pichi
I knew you’d know the answer instantly!
0 reply
0 recast
3 reactions
