Apologies if this article is a little short--I just wanted to post this ASAP to get the information out quickly to everyone.
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.
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
Enough. Just Tell Me How To Do It Already!
Make sure you have your own Dune Analytics account (free).
Go to the original Dune query, here: Airdrop 2 Tip Allocations Exponential Decay (dune.com)
Hit the "Fork" button, top-right to fork a copy of the query to your own account.
Get your FID from farcaster.
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!
If you found this tip useful, please subscribe & follow me on farcaster: https://warpcast.com/arfonzo
I've just published my first @paragraph article! I explain how you can easily modify the default Dune Analytics SQL code to quickly query your new allocation stats (the ones which will take effect in June). $DEGEN: How To Quickly Query Your New Allocation
Will set this up later. So tired of the loading lol ~ Thank you! Will be back...
You're very welcome! Really helped me too (yeah the loading/timeout errors were getting ridiculous), so I thought to share it. Sharing is caring! 😻🤝😸
250 $DEGEN
Wow! Thank you very much @manuwilliams, most appreciated! 🙏😻
thanks arf!
ywyw! Sharing is caring frenpai 🙏
Does it contain tips on how to increase Allowance here, my boss? 🎭
There's not too many details I've seen yet about it, but here's a great cast about it! Basically, cast & tip legitimately, don't use spam tactics, engage with as many high quality users as possible. Just keep being normal! 😹 https://warpcast.com/nicolasdavis.eth/0xda4b659c
Ok, I'll try harder for that... Hahaha... ❤Thankyou
What is happening here, my boss My allowance 4,999,700 😁
Lmao I have no idea! Pray that it's true 😹 I suspect it's a temporary bug in calculations tho, maybe check again tomorrow.
gud cat
I gud. Except, when I not. 😼
Thanks! Very helpful :) 20 $degen
You're very welcome, glad to assist! And thanks! 🤝
Huge!👍