ilemi on Warpcast

Content pfp

0 reply

0 recast

0 reaction

ilemi pfp

✨Introducing "Farcaster Trends", a dashboard where you can find, track, and analyze trends across users, channels, and words. Want to find trending users or channels based on influencer they interact with? Or filter on those by nouns holders? Then this one is for you 😁 https://www.youtube.com/watch?v=cy9ezbbh9FY

60 replies

104 recasts

422 reactions

ilemi pfp

The dashboard can be found bellow For the builders, think of the "all active farcaster users" and "all active farcaster channels" queries as your base tables for building off of (in Dune or API). Both contain dozens of metrics from offchain and onchain. https://dune.com/ilemi/farcaster-explorer

1 reply

1 recast

14 reactions

ilemi pfp

For starters, let's take a look at words. I implemented TF-IDF so that you can has a frequency, quality, and uniqueness check on trending words on Farcaster. Not surprisingly, we see mint, degen, nft, and base in here. You can filter for trending in a specific channel too.

1 reply

0 recast

4 reactions

ilemi pfp

Next up, we have user tiers. I created five tiers of users "npc, active, star, influencer, and vip". You can find the definitions for them in the dashboard, but this gives us an immediate quality filter (which was already applied to the trending words query 😉)

3 replies

0 recast

4 reactions

ilemi pfp

For tracking all users, you can see not only their farcaster activity and onchain txs/volume/contract deploys, but also their top channels and top shared domains (in links).

1 reply

0 recast

2 reactions

ilemi pfp

There is a "trending users" query that lets you apply six different filters. Below I've applied filters for "users that @jessepollak has followed who are less than 7 days old and sorted by week over week growth in engagement" These might be some up and coming base builders 👀

1 reply

0 recast

2 reactions

ilemi pfp

Next up are channels. I've created five tiers of channels, seen below. This is mostly inspired by how subreddit work. There are roughly 130 high quality channels (niche+).

1 reply

0 recast

2 reactions

ilemi pfp

Looking at the "all channels" summary, we can start to get some interesting insight by layering in our user tiers. Not only can we see channel activity, but we can see the activity by quality of the user (and most active high quality users).

1 reply

0 recast

2 reactions

ilemi pfp

Imagine you wanted to find new channels that had the most active influencers - you can use filters on the trending channels query for that! Looks like there are a few small channels that might be worth checking out and joining early 👀

1 reply

0 recast

2 reactions

ilemi pfp

This is just the tip of data iceberg, it's the first time that this kind of combined identity/social/transaction analysis is possible basically for free for anyone. I'm really excited to see what you all find and build with this 😁 https://dune.com/ilemi/farcaster-explorer

3 replies

0 recast

4 reactions

ilemi pfp

Full guide that goes into the schemas more https://read.cryptodatabytes.com/p/how-to-find-and-analyze-trends-on

2 replies

0 recast

3 reactions

jesse.base.eth 🔵 pfp

jesse.base.eth 🔵

this is so awesome! one small nit: /base is called onchain-summer in the dash. this is because that's what it was originally called. any chance you can update to base?

2 replies

0 recast

0 reaction

0xHashbrown🎩🍖✋ pfp

0xHashbrown🎩🍖✋

10000 $DEGEN So dope for putting this together, those queries are 🔥 and are super helpful for others building too. Thanks for building with open tools and in public 🎩.

0 reply

0 recast

1 reaction