Pichi on Farcaster

Content pfp

https://warpcast.com/~/channel/farcasterunion

0 reply

0 recast

0 reaction

Pichi pfp

We are close to FID 1,000,000! But we only have 30,000 DAU... But how many people cast consistently (5 days in a row)? 12,597 We dig deeper and look at how many of those are considered qDAU (quality Daily Active Users) the numbers are much more startling... 1,991 qDAU So if you missed the Warpcast Rewards Leaderboard this week, just keep casting. You are closer than you imagine if you show up everyday. You've got this! P.S. Out of the 1030 that got rewards, 1029 of them have a level 2 spam label (Don't get a bad SPAM Label)! Major shoutout to @jc4p and @mvr and @sheva7.eth who made the Dune queries that made this new analysis possible. https://dune.com/queries/4742322/7874634

42 replies

13 recasts

73 reactions

Pichi pfp

@geoffgolberg you may be interested in this.

0 reply

0 recast

4 reactions

Pichi pfp

5 Day In a Row Casters (no Spam Label Data) https://dune.com/queries/4733142

2 replies

0 recast

7 reactions

Pichi pfp

DAU Numbers (7 Day Average) from this query https://dune.com/pixelhack/farcaster

0 reply

0 recast

1 reaction

Pichi pfp

Warpcast Rewards Leaderboard with Spam Labels by @sheva7.eth https://dune.com/queries/4731174/7858744?label_t6c1ea=2

0 reply

0 recast

1 reaction

Pichi pfp

@mvr is it possible to find out who these daily Level 2 casters are? I'd rather be following and interacting with folks who are doing their best to be active.

2 replies

0 recast

1 reaction

Sheva pfp

Thank you for providing meaningful insights. It was similar to the trends I have been sensing. I can also feel firsthand that the number of Japanese people is gradually decreasing.

1 reply

0 recast

1 reaction

mvr 🐹 pfp

How many of the 1030 cast daily

1 reply

0 recast

0 reaction

Colin Johnson 💭 pfp

Colin Johnson 💭

Love the metrics! Most social networks operate on the 90%/9%/1% principal. qDAU under your definition (5 consecutive casts + other qualifiers) would be 2,000, which is the 1% That should imply a network of 200,000 “social network users”. It’s interesting because there aren’t 200k, obviously, so Farcaster is superindexed towards content-generating users.

1 reply

1 recast

2 reactions

J. Valeska 🦊🎩🫂 pfp

J. Valeska 🦊🎩🫂

interesting data 👀

1 reply

0 recast

1 reaction

Schmidtiest.eth 🎩 pfp

Schmidtiest.eth 🎩

@schmidtiest.eth

so 1 person that made the leaderboard has/had a spam label of 1 or 0?

1 reply

0 recast

1 reaction

Geoff Golberg pfp

I would use "accounts" rather than people here :)

1 reply

0 recast

1 reaction

Purpleman.base.eth 🎩 pfp

Purpleman.base.eth 🎩

Wow! Only 1991 qDAU! That’s tiny!

1 reply

0 recast

0 reaction

bradq pfp

this is brilliant. great work!

1 reply

0 recast

0 reaction

deriniti ✞🫶🖌 pfp

deriniti ✞🫶🖌

whoa! that's big!

1 reply

0 recast

0 reaction

Shira Stember pfp

Def a big opportunity to capture some rewards. How is qDAU defined? Not everyone is going to cast regularly but I’d bet there are plenty of people visiting everyday, scrolling their feed and liking some casts.

1 reply

0 recast

0 reaction

Callum Wanderloots ✨ pfp

Callum Wanderloots ✨

@wanderloots.eth

Super interesting! Thanks for sharing. 1991 qdau is actually pretty wild

1 reply

0 recast

0 reaction

Anemale🎩↑🔵ツ pfp

Anemale🎩↑🔵ツ

wow very interesting pichi, thank you for this analysis

1 reply

0 recast

0 reaction

Camila 🫂 pfp

That’s very interesting. I cast consistently. How do I know if I am considered a qDAU?

1 reply

0 recast

0 reaction

AndersO pfp

Thanks for sharing this. Very insightful. this is definitely a wake up call! I love farcaster but haven’t prioritized it enough the past few months.

1 reply

0 recast

0 reaction