Challenged myself to make a Farcaster social credit system myself, but sufficiently transparent, and 100% on Dune with available data on Dune + spam labels.

I call it "Caster Credibility Score"
Calculation is based on:
- Activity
- Interaction
- Network
- Engagement
- Sustainability of activity over time
- Spam label

It ranks from 0 till 100.
If you're not on the list, you scored 0.

And to be clear, this says nothing about the quality of someone's casts. But the value that a caster brings to the Farcaster network.

The Dune script:

Challenged myself to make a Farcaster social credit system myself, but sufficiently transparent, and 100% on Dune with available data on Dune + spam labels.

I call it "Caster Credibility Score"
Calculation is based on:
- Activity
- Interaction
- Network
- Engagement
- Sustainability of activity over time
- Spam label

It ranks from 0 till 100.
If you're not on the list, you scored 0.

And to be clear, this says nothing about the quality of someone's casts. But the value that a caster brings to the Farcaster network.

The Dune script: https://dune.com/queries/5497120

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

Fun facts:
- My rating is "good" with 74.1 points, and not excellent 😭 
- 341,766 FIDs on the list have a "poor" rating (91.6%)
- Only 1,062 FIDs have an "Excellent" rating (0.3%)
- The most of the FIDs didn't get on the list because they didn't have 5 or more casts in the last 365 days