You are viewing a single comment's thread from:

RE: More than 800,000 Steemit accounts / Mehr als 800.000 Steemit-Konten

in #steemit6 years ago
  1. How many of those 800K accounts are retained as daily, weekly active users?
  2. How many of them turn into investors?

The Steem price tells another story. It should be up with more users, but investors know that most of those users come for the rewards, won’t invest into Steem, won’t contribute much to the platform, and probably majority of them won’t remain as active users.

Sort:  
active in ...number of active accounts
last 24 hours70341
last 7 days119268
last 30 days224414
last 365 days690139
alltime801724

I use these values to determine the activity:

  • last_post
  • last_root_post
  • last_vote_time

Thank you for these numbers. They are important. You can eventually add the “last comment” figure, if that’s available.

To me, the only two meaningful numbers on that table is daily and weekly, but the rest is also interesting, because it shows how low the retention rate is.

These numbers also contain people who have just signed up. This can be filtered out by restricting the query to accounts older than 30 days. You can calculate a retention ratio by calculating the following ratio: (accounts older than 30 days and active in the last seven days) / accounts older than 30 days.

Do these numbers also include automated accounts, i.e. bots? If so, I don’t know how to filter them. And actual human numbers might be lower.

Just added the table with the number of active users to my post.

Thank you for the numbers, @cryptoriddler. I wrote a post about this issue and used a screenshot of the table in your comment with proper links to this post and to your profile. I hope this is fine for you. If not, let me know, and I'm going to remove it.

Coin Marketplace

STEEM 0.16
TRX 0.14
JST 0.028
BTC 59403.33
ETH 2607.28
USDT 1.00
SBD 2.38