October '18 New STEEM Account Report

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

/@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. 


H2
H3
H4
Upload from PC
Video gallery
3 columns
2 columns
1 column
22 Comments