Pichi 🟪 🍡🌸 on Warpcast

Content pfp

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

0 reply

0 recast

0 reaction

Dan Romero pfp

The fundamental issue with consumer crypto today is lack of consumers. Consumers need interesting or entertaining content to stick around. Sign ups are irrelevant if you can’t retain them. Everything else is a marginal improvement at best.

70 replies

66 recasts

521 reactions

Pichi 🟪 🍡🌸 pfp

Pichi 🟪 🍡🌸

Would you be willing to share retention metrics? I can see the number of users who signed up in a particular month but I have no idea how many of them are still “active casters”.

1 reply

0 recast

3 reactions

Dan Romero pfp

Data is public on Dune

1 reply

0 recast

1 reaction

Pichi 🟪 🍡🌸 pfp

Pichi 🟪 🍡🌸

Thanks! I’ll summon a Dune Wizard for assistance. Thankfully the latest moxie Dune challenge brought several new players to the surface!

1 reply

0 recast

0 reaction

Fibo pfp

@fibo112358.eth

I was curious too so dug through the data. https://dune.com/queries/3996249/6726522 This query calculates the engagement metrics for Farcaster users based on their signup month, focusing on the last 30 days of activity such as reactions and casts.

2 replies

0 recast

0 reaction

Pichi 🟪 🍡🌸 pfp

Pichi 🟪 🍡🌸

This is also pretty crazy. I assumed the people who joined before April would have more stickiness.

1 reply

0 recast

0 reaction

Fibo pfp

@fibo112358.eth

True. One thing to note though is that the ratio is vs signups instead of vs MAU. Maybe I'll check later if I can see a different result.

1 reply

0 recast

0 reaction

Fibo pfp

@fibo112358.eth

Changed it to DAU/MAU in the past 30 days, per signup month. Now it seems the older signups are stickier.

1 reply

0 recast

1 reaction

Pichi 🟪 🍡🌸 pfp

Pichi 🟪 🍡🌸

This is hard for me to wrap me head around. A lot of my friends from Feb/March are still here. A handful have churned but most have stuck around. But this seems like only about 30% stay and most leave.

2 replies

0 recast

0 reaction

Fibo pfp

@fibo112358.eth

I see. How you feel could still be true. It's a little challenging to interpret/use those data actually. 1. vs signups Gives a better idea of churn, but it may include lots of signups that were never intended to be active or used naturally in the first place (e.g. FID booking, bots, farming accounts), pushing down the numbers. 2. vs MAU Gives a better idea of how often they are on FC per 30 days, but the higher the MAU is the lower the % could be (i.e. does not accurately reflect the churn or whether active at least once). The most accurate way to find the churn would be to use "vs signups" after excluding non-real accounts, but I don't know how those can be identified without false positives. I would love to know if there are other better ways to measure the real retention.

1 reply

0 recast

0 reaction