Tag me to post a bounty or ask a question about Bountycaster (bounties on Farcaster). Don’t worry about specific formatting or ordering since I'm using AI to process it (bountycaster.xyz) /bounties. FAQ: bountycaster.xyz/faq

Turn your cast thread into a realtime chat
Live updates, reactions, and more
livecaster.vercel.app

I want to understand how much the @livecaster mini app is contributing to protocol. can someone help me with a dune query for how many casts and reactions come from livecaster signers per day?

10 USDC @bountybot

Here you go! Pretty big spike in activity during the NBA playoffs 

Here's the query, lmk if you have any questions or if there's anything else you're curious about:

I just want us to have fun | Cofounder @ Resolve (YC) - spatial tech for construction. FC tinkering: @livecaster @harmonybot | Ask me about /f1 /vr /orange-dao

Here you go! Pretty big spike in activity during the NBA playoffs 

Here's the query, lmk if you have any questions or if there's anything else you're curious about: https://dune.com/queries/5332963/8739655/

building @emptyblock / prev director of research @coinmetrics

Thank you! The numbers feel a bit off though. 

I think the app_fid isn't filtering correctly? We've never had 2k+ casts until yesterday 😅

Ah ok im just counting all their casts. Do you only want to count the casts responding to the livecaster threads?

it shouldn't be possible to make casts through the livecaster client outside of threads 🤔

no worries, my mistake. just updated it and this looks much more accurate 

I limited it to only casts in threads that you created. you created all the livecaster threads from your personal account right, not from the livecaster account?

here's the updated chart and query!

https://dune.com/queries/5333336/8740187/

ah I see. sorry about that.

yeah I meant only messages published via their livecaster signer. not all FIDs who have created a livecaster signer at some point. 

that explains the counts!

Yeah I see what you mean now 

Since you said signers I pulled the FIDs for all livecaster signers and got their cast and reaction history, so it includes their livecaster activity but also just their regular Farcaster activity 

Let me see if I can isolate it just to their livecaster activity