why do I still not have the active badge?

If this page is still accurate than the only thing that could be missing is the cast vs engagement ratio afaict

https://warpcast.notion.site/Active-badge-d81fea2e953e4dafae7c85295ffaf3ae

The only problem is externality pricing.

Building https://negationgame.com

weird internet kid. word rotator. yapping on /okbanger. playing with @wannanaplabs. curating in /cameron | dev + vet + HBS. 
seemore.tv/cameron 🫡

yea by my eyeballin it id agree w that. 

Maybe @pixel could run your numbers for you, but Occam’s razor I think Merkle’s calc seems off/out of date in your case. 

Or maybe they changed the rules

reactions + replies / casts in last 30 days I think

past 30d:
you made 264 casts, you received 1.2k reactions, and 271 casts were replies to your cast

def above the active threshold...

dude throw this shit in a GUI, make a trending list, and you have the next hot FC microapp

the polished one (the other cast) has self-reply weeded out (ie. "where parent_fid = 2588 and fid != 2588")

i'm using Warpcast's postgres replicator to pull the numbers :)

So I'm way over the threshold... 

damn this is such a sick api how can I use it?

does this query account for self-replies?