farcasterunion

Interests: crypto, economics, TA & blockchain related innovations | 🔗 https://linktr.ee/cryptonjal 🔗 https://dune.com/nhejyht

Can you add in pro badges with this data set?

https://www.dune.com/queries/5196610/8550394

99% of my timeline has them!

I added pro subscription to the Farcaster Followers Audit dashboard, but with important limitations:
- Not all wallet addresses can be linked to FIDs.
- If bought with warps, it won't appear on this list.
- to avoid time-outs I had to make 2 extra queries who are update automatically weekly.

If a FID isn't linked to any wallet, the column fc_pro will return unknown
If a FID is linked to a wallet which paid for a pro subscription, it returns yes
Else, it returns no.
Link:

I added pro subscription to the Farcaster Followers Audit dashboard, but with important limitations:
- Not all wallet addresses can be linked to FIDs.
- If bought with warps, it won't appear on this list.
- to avoid time-outs I had to make 2 extra queries who are update automatically weekly.

If a FID isn't linked to any wallet, the column fc_pro will return unknown
If a FID is linked to a wallet which paid for a pro subscription, it returns yes
Else, it returns no.
Link: https://dune.com/nhejyht/farcaster-followers-audit

If you want the latest data when using the dashboard than you should update first https://dune.com/queries/5200238 and after that

If you want the latest data when using the dashboard than you should update first https://dune.com/queries/5200238 and after that https://dune.com/queries/5198010