Jondar

@jondar

67 Following

159 Followers

Jondar pfp

Sharing again my @noiceapp dune dashboard just to farm some ok bangers https://dune.com/jondar/noice-dashboard

1 reply

0 recast

5 reactions

Jondar pfp

For anyone looking for a @dune.eth dashboard for their miniapp dms are open Here are some previous works I've done on miniapps: - @noiceapp: dune.com/jondar/noice-dashboard - @higherarrows: dune.com/jondar/arrows - @betttr: dune.com/jondar/betttr Dune profile: dune.com/jondar

0 reply

2 recasts

9 reactions

Jondar pfp

yes, i have this query that returns the list of users that have paid the subscription with a verified address that also joins the dwr list to label who has also the nft. My theory is that 8,250 users paid with warplet and the rest 3,250 paid with warps as you said, but for each warps subscription the team made a transaction of 120 usdc to the subscription address with a new, non verified address. If someone from the team confirms this i can go on with my dashboard https://dune.com/queries/5207027

0 reply

0 recast

1 reaction

Jondar pfp

But this is counting all on chain transactions of addresses that sent 120 usdc to the farcaster subscription address. I then joined those addresses to the verified addresses from neynar's tables. Since there are more than 11500 addresses that bought on chain the subscription, at least those should be from verified addresses and then the number of total subscribers should be higher because of offchain subscriptions, or am i missing something?

1 reply

0 recast

0 reaction

Jondar pfp

Joining Farcaster tables on Dune with all the "from" addresses who sent 120 usdc to the subscription address, looks like only 8,225 subs come from verified addresses. Is this possible? @dwr.eth @v @horsefacts.eth https://dune.com/queries/5206627/8565304

1 reply

0 recast

0 reaction

Jondar pfp

Dashboard: https://dune.com/jondar/noice-dashboard Recipients table: https://dune.com/queries/5178830/8524523

0 reply

0 recast

3 reactions

Jondar pfp

Want to know if you received any tips through @noiceapp? Use this table to search for your name and see how many tips and how much money you received! Link to the full dashboard in the first comment

1 reply

4 recasts

17 reactions

Jondar pfp

i think you can achieve this with X + Neynar APIs, but it can get expensive https://docs.x.com/x-api/users/lookup/introduction https://docs.neynar.com/reference/lookup-users-by-x-username

0 reply

0 recast

1 reaction

Jondar pfp

Thanks @noiceapp for the bounty on the dashboard and @garrett for tagging me on the post, i would have missed it without the notification

1 reply

0 recast

1 reaction

Jondar pfp

The social response to the project has been great. Using @neynar tables to track casts, we can see that since the announcement post on 2025-05-16 the word “Noice” has appeared in over 10,383 casts by 4,525 unique users

1 reply

0 recast

1 reaction

Jondar pfp

The Token Distribution section shows the spread of different tokens tipped so far. As of this post 27 tokens have been used, with USDC leading the way with over $5.1K tipped

1 reply

0 recast

1 reaction

Jondar pfp

The Weekly Breakdown section shows the same metrics (number of tips, USD volume, and the count of tippers and recipients) aggregated by week

1 reply

0 recast

0 reaction

Jondar pfp

The Daily Breakdown section shows the number of tips, USD volume, and the count of tippers and recipients per day

1 reply

0 recast

0 reaction

Jondar pfp

In these two tables you can see the top tippers and top recipients ranked by number of tips, volume, and token diversification. Search your Farcaster handle in the recipients table to see if you’ve received a tip without even knowing it!

1 reply

0 recast

0 reaction

Jondar pfp

There have been 43,160 tips so far made by 1,419 tippers. A really interesting metric is that 1,265 of those tippers made at least a second tip, meaning the return rate of tippers is 89.20%

1 reply

0 recast

0 reaction

Jondar pfp

Of course it makes sense that there have been more recipients than tippers, in fact there have been 5,407 recipients who have received over $5.5K in tips overall. Kudos to the creator who received the highest single tip of $100!

1 reply

0 recast

1 reaction

Jondar pfp

Yesterday I worked on a Dune Dashboard about @noiceapp Noice is a mini-app that lets users tip creators with every interaction they make. Let’s dive into the data so far A @dune.eth 🧵: https://dune.com/jondar/noice-dashboard

3 replies

2 recasts

10 reactions

Jondar pfp

0 reply

0 recast

1 reaction

Jondar pfp

Glad you like the dashboard 🫡

0 reply

0 recast

1 reaction

Jondar pfp

Here you have the dashboard! https://dune.com/jondar/noice-dashboard

0 reply

0 recast

3 reactions