In June, we're going to see a new system of ranking rolling out for $DEGEN tip allocations. See the original cast by Jacek here:

Jacek 🎩 on Warpcast

For June tipping, we're updating the algo to use social graph data instead of just engagement data. You still need 10k $DEGEN in your wallet, but no minimum posts are required. Rankings drop if you don't tip at least 5 times in the last 7 days. The algo will be updated on Tuesday.

Farcaster

In a nutshell, it's going to be using openrank data and no longer relies purely on engagement metrics. I think it's great news, but I'm not here to talk about that today. I just want to focus on getting your own allocation data quickly from the Dune Analytics query.

A Dune query has been released for this data (supposedly), which you can reference here: Airdrop 2 Tip Allocations Exponential Decay (dune.com)

The issue is that the whole query fails frequently, as it hits a 2-minute execution timeout error. Otherwise it chugs for quite a while before returning all results for you to filter through.

This article explains how you can filter the results to only grab your own data, which results in a much faster query (in my testing it's around 5 seconds).

I casted about it earlier, but I thought it might merit a more thorough explanation for those new to Dune Analytics.

arfonzo on Warpcast

Hey frenpais! Got many queries about the allo info I posted yesterday. Here's how you can track your own $DEGEN allocation on Dune without exec timeouts or long queries: - Go here: https://dune.com/queries/3745431 - Fork it (account needed) - Modify the SQL source to filter only your FID. You're welcome. 😽❤️ https://imagedelivery.net/BXluQx4ige9GuW0Ia56BHw/c3c94090-79bb-4c7f-894d-b9cbb4be9100/original

Farcaster

Enough. Just Tell Me How To Do It Already!

1. Make sure you have your own Dune Analytics account (free).

2. Go to the original Dune query, here: Airdrop 2 Tip Allocations Exponential Decay (dune.com)

3. Hit the "Fork" button, top-right to fork a copy of the query to your own account.

4. Get your FID from farcaster.

5. Modify the SQL source code so that the query only fetches data pertaining to your FID. You'll want to go to line 22, and insert the following lines (replace 31337 with your FID):

WHERE
    fid = 31337

Now, when you run the query, it should go very quickly and return only your own results. If you want, you can now save the query (and mark it private), so you can query your data anytime.

Have fun!