It's been a ride 🙂

0 reply

0 recast

1 reaction

thanks to @nastya for the help. a dune query mapping Polymarket users to FC users in case anyone needs https://dune.com/queries/6153579/9837536/

1 reply

1 recast

4 reactions

Did some optimization and managed to cut down credit required to run 15 queries from 52 to 26 credits. Is it good enough or could still be better? TBH kinda like the new model as previously running those 15 queries will cost me 150 credits

1 reply

0 recast

2 reactions

Any power /dune users willing to show me around the platform for 15 mins?

5 replies

6 recasts

17 reactions

Has anyone done dune charts for per client retention metrics and charts like this dune https://dune.com/dtech/dtechvision-farcaster-pulse but also adding metrics per client? Like I wanna see cohort retention of warpcast(farcaster app) vs base app and total on farcaster Would be super fun to have DAU split per app + combined on protocol and so on.

3 replies

1 recast

7 reactions

Can we query a @fileverse sheet or pull data from it? Problem: I do weekly raffles for $CARDBOARD. I am tracking winners in a sheet. I’d like to pull the number of winners and the $ the cards raffles are worth. Unfortunately tracking a wallet isn’t a good solution

1 reply

1 recast

2 reactions

anyone good at dune? trying to figure out why I am coming empty handed on some sql. feels like I am missing a simple thing (yes I tried Claude)

3 replies

0 recast

5 reactions

@dune.eth Dashboard for Farcaster - USDC Rewards - Detailed stats from the start of this rewards (17th Dec, 2024) with score, rank, rewards for every week. You can also find top creators and their rewards stats. https://dune.com/jkavithamahesh/farcaster-usdc-rewards-with-points-and-ranks

2 replies

2 recasts

5 reactions

New @dune.eth Dashboard Track Farcaster users activity over the past 30 days — broken down by hour (UTC). Find the best time to post, or view when your followers are most active by entering your FID and run the dashboard. https://dune.com/jkavithamahesh/farcaster-activities-utc-time-zone

10 replies

9 recasts

13 reactions

Is there dune dash for casts that gives accurate cast time and date graphs for all casts (not interested in specific casts, so rather a broad overview) and adding is there a similar dune dash that would give you time, date and engagement data for a specific user?

2 replies

0 recast

2 reactions

@dune.eth Dashboard for Farcaster Stats - Farcaster User Growth - DAU Last 3 Months (Spam Label 2 and all) - Daily and Monthly Casts - Daily and Monthly reactions https://dune.com/jkavithamahesh/farcaster-growth-stats

6 replies

4 recasts

8 reactions

Created a new @dune.eth dashboard for the Base App Rewards. https://dune.com/jkavithamahesh/tba-the-base-app-rewards

10 replies

11 recasts

18 reactions

Updated the @dune.eth dashboard for Farcaster Collectables. Farcaster Collectables - Auction Stats Bid Details Top 25 - Highest Bid Top 25 - Highest Bid (No of Bids) Top 25 Bidders (No. of Bids) Daywise Auction Chart Auction Winners (Coming Soon) https://dune.com/jkavithamahesh/farcaster-collectables

2 replies

1 recast

9 reactions

guys can we please get spam labels up to date in dune cc @rish @mats this is necessary for almost any serious analytics query upon farcaster

1 reply

1 recast

2 reactions

Anyone has a dune dashboard that show the distribution of Farcaster accounts by geo ? (how many US based, EU based etc...)

2 replies

0 recast

1 reaction