Angel
@sayangel
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
5 replies
1 recast
17 reactions
Nate Maddrey
@nmadd
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/
1 reply
0 recast
1 reaction
Angel
@sayangel
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 😅
1 reply
0 recast
0 reaction
Nate Maddrey
@nmadd
Ah ok im just counting all their casts. Do you only want to count the casts responding to the livecaster threads?
2 replies
0 recast
1 reaction
Angel
@sayangel
it shouldn't be possible to make casts through the livecaster client outside of threads 🤔
1 reply
0 recast
0 reaction
Nate Maddrey
@nmadd
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
1 reply
0 recast
0 reaction
Angel
@sayangel
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!
1 reply
0 recast
0 reaction
Nate Maddrey
@nmadd
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/
1 reply
0 recast
0 reaction
