October '18 New STEEM Account Report

in #utopian-io5 years ago

At the beginning of every month I prepare a report containing details of new users for the previous month. I had changed to every second month for part of the year. However due to HF20 and the changes in account creation, I believe this report will be of value on a month to month basis and will be returning to producing it monthly, with additional information relating to account creation tokens.

If you missed the last report you can read it here

https://steemit.com/utopian-io/@paulag/august-and-september-18-new-steem-user-report

Aim of Analysis

The aim of this analysis is:

• Establish how many new users registered

• Establish what % of accounts have posts and voted and are just wallet holders.

• See who is claiming account creation tokens

• Establish if delegation is been given to accounts to they can transact. 

 Repository

https://github.com/steemit/steem

Year to Date Data

2018 Year to date has seen  0.62M new accounts registered on steem.  

The median new accounts per month this year is 48.8K, however we can see clearly that the first quarter of the year had substantial more registrations the then next two quarters.  New registrations had been decreasing since March, however we had a small upturn in September to reduce again in October

October Overview

The above dashboard shows details of accounts set up in October.  Of the 21K new accounts, 13.44% have completed their about section in their profiles and 6.4% have added a link.  Completing these fields indicate a level of the quality of the user and have a correlation with retention.

29% of accounts have posted once, with 6.8% posting more than 10 times and 0.76% posting more than 50 times. 

69% of accounts have voted at least once.

Looking at the activity pie we can see 'Not active' accounts make up only 9.9% of accounts.  Fully active accounts have both posted and voted.  This makes up almost 8.9% of accounts registered in October.  20.8% of accounts have posted but never voted and 61% have voted and never posted.  Finally only 0.84% of accounts are Wallet user only.

2.29K STEEM was burnt on Account creation fees and 0M vests were delegated to in the set-up process.

The table on the left of the dashboard shows who set up the accounts.

HF20 Changes

Under HF20 accounts can now be set up by either burning the STEEM and sending delegation so the accounts can transact, or they can be set up with discount account creation tokens where the fee is 0.

96.4% of new accounts set up, were set up with the newly introduced account creation tokens.  The balance was made up of accounts set up by burning steem at 3 steem per account.

However when accounts are set up, without delegation, there resource credits and voting mana need to be boosted so they can really transact on the block.  So many new accounts have received delegation.

18,755 which is 87.5% of accounts set up in October have received delegation.

Of this 18,755 account that received delegation, 83% received 30K Vests

Account Creation Tokens

The introduction of account creation tokens in HF20 allows users claim the right to set up an account.  In total 61K account creation tokens have been claimed.  Below shows who has been claiming these account creation tokens.  We can see Steemit Inc has claimed 33% of these, yet they have set up 87% of new accounts.

   

 Conclusion

In terms of the number of new accounts registered, the last 3 months have not changed that much and I hope we will soon see a little break upward.

So far with the introduction of HF20 changes, we have not yet seen a large shift from the account creation process being handled by Steemit inc and other sources.  It is also interesting that most accounts are receiving delegation, although small, to help them with RC's.

What is rather interesting is the activity levels.  Only 9% of new accounts set up in October are not active.  This value was almost 35% in September.  What we have seen in an increase in the number of accounts that are voting only.  This was 30% in September and now is over 60%.

Could this increase in accounts voting and not posting, coupled with the lower % completing their profile suggest a higher number of bots?

The Data-source and Query

As always to produce this report I connect to Steemsql (paid subscription services held and managed by @arcange ) with Power BI. The SQL query used to gather the data for this report was

Select *
FROM Accounts (NOLOCK)
where   
( created >= CONVERT(datetime,'01/01/2018')
AND created< CONVERT(datetime,'10/01/2018')



To get details of who set up each account I used the following query


Select *
FROM txAccountcreates (NOLOCK)
where   
timestamp >= CONVERT(datetime,'01/01/2018')



and to get details of accounts that used their wallets I used the following


select [from], timestamp
from TXTransfers
where   
timestamp >= CONVERT(datetime,'01/01/2017')


The query used to find out who is claiming accounts was

Select *
FROM TxAccountClaims (nolock)

Once I loaded the data into Power BI, I then carried out transformation and calculations using DAX language. 


Sort:  

Hi @paulag, exciting changes compared to the previous months! While the number of new accounts increased only slightly, the changes to new account activity and the increase in the rate of voting-only accounts are quite large. Any idea what caused this change?

Your contribution has been evaluated according to Utopian policies and guidelines, as well as a predefined set of questions pertaining to the category.

To view those questions and the relevant answers related to your post, click here.


Need help? Write a ticket on https://support.utopian.io/.
Chat with us on Discord.
[utopian-moderator]

thank you for the review @crokkon. I have no idea what caused the change in the rate of voting only accounts. Maybe its bots?

Thank you for your review, @crokkon! Keep up the good work!

How many of these new accounts have interacted with Steem Monsters? :)

2 questions about Steem Monsters. I will have to take a look.

There's an API you should be able to hook into, that generates a whole bunch of JSON data. I don't know all the details, but @holger80 has a lot of technical detail using some Python to query a whole bunch of Steem Monsters stuff.

I don't pretend to understand it, because the extent of my analytical skills are basically pivot tables, and importing xml sources into excel.

I don't have nearly enough SQL or database skills! :)

thank you... 😊 always interesting to have some numbers... @peekbit

These charts will not show anything magical the next couple of years. As there won't be a month where people randomly discovers this place and becomes enlightened XD

It will be a very slow process of converting people into loyal users. As the key to a new user is to get them to have more buy in and create more value in the system. A user's value comes down to how skilled they are at Leverage stuff in their life. And that is a process that takes a lot of time and energy. Just for a user to understand a little bit takes a few months.

there are things like steemmonsters and spunkeemonekee that have the ability to open steem up to more and more non crypto people. I dont think it will be as slow as you might think, one good app and we could see things move fast. although the next 4-5 months till SMTs go live, i think you are right.

Did you actually take the accounts that got created using RC into consideration for checking who set up an account? Because these are actually two different types of transactions, both creating a new account on the blockchain, so I think you need to redesign your SQL query :-)
Pretty cool analysis though ;-)

I think it will depend upon how @arcange has designed the Accounts table in SteemSQL? I'm guessing that both types of account creation would feed into that table.

Yeah it wouldn't be definitive, but a table called txAccountcreates sounds like it only contains "normal" account creation operations and not create_claimed_account. Maybe it isn't the case though, and @paulag made everything right :-)
Just wanted to make her aware of the possibility ;-)

Its all taken in. Both accounts created by burning steem and accounts with discount tokens (RC`s).

Posted using Partiko Android

Don't you think steemmonsters tournament might be a reasons for the new accounts created on October 😉

I just wish we could further understand what barrier if any it was from someone creating an account to it having any signs of life out of it what so ever.

I was hoping the dapps would start showing more uptick in people they are onboarding. Those really don't appear to be very impressive numbers compared with all everything this platform has to offer.

Hi @paulag!

Your post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation!
Your UA account score is currently 6.916 which ranks you at #93 across all Steem accounts.
Your rank has not changed in the last three days.

In our last Algorithmic Curation Round, consisting of 219 contributions, your post is ranked at #3. Congratulations!

Evaluation of your UA score:
  • You've built up a nice network.
  • The readers appreciate your great work!
  • Good user engagement!

Feel free to join our @steem-ua Discord server

Congratulations @paulag! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :

You received more than 7000 as payout for your posts. Your next target is to reach a total payout of 8000

Click here to view your Board of Honor
If you no longer want to receive notifications, reply to this comment with the word STOP

Do not miss the last post from @steemitboard:

The new Steemfest³ Award is ready!

Support SteemitBoard's project! Vote for its witness and get one more award!

This post has been found valuable and upvoted by El surtidor

Coin Marketplace

STEEM 0.35
TRX 0.12
JST 0.040
BTC 70455.47
ETH 3561.82
USDT 1.00
SBD 4.71