January '19 New STEEM Account Report

Each month I will be producing a report with details of New accounts created on STEEM.  It has long been established that the account creation route via Steemit Inc has flaw, with delays, batch account creation and users never activating accounts one they have been created.

At one stage Steemit Inc conurted with this problem and issued a post stating they have put in place measures to track every stage of the sign up process, from first landing on the sign up page to logging into their newly created accounts.  However we have seen no further information from Steemit inc to see where the exact problem is.

HF20 implemented changes to account creation.  These changes made is easier for others to create accounts using free account creation tokens.  However, this process still requires delegation, so accounts have enough RCs to transact.  There was also a change in accounts created with fees where by under the new system, the fee would be burnt.

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 so they can transact. 

 Repository

https://github.com/steemit/steem

Overview

Jan 18

  

December 18

  

January 19

  

Jan 18 was a peak month for account creation with over 159k new accounts created.  As previously highlighted Dec ’18 was a problem month, as Steemit inc under went some changes and account creation hit rock bottom.  It had been identified that come the end of Dec 18, Steemit inc was sitting on a backlog of accounts to be created.

Jan 19 shows much improvement with Steemit inc again creating the bulk of new accounts (89.4%).  This % of accounts created in Jan 19 by Steemit inc is higher than other months since HF20 suggesting that steemit inc tackled the backlog of accounts not created in December.

45% of accounts created in December have never transacted on the blockchain via wallets or posts or votes, this can be compared to 36% in Jan 18 and 58% in Jan 19.

Another notable different between Jan 18 and Jan 19 is the Creation fees.  This change is down to HF 20.

Two interesting values I keep an eye on are the % about profile complete and the % of accounts with website on their profile.  These values give an indication of the caliber of user.  Those with intent of using the platform will have more tendency to complete their profile.

Activity Level by creator

Taking the top 6 account creators, below we can compare the activity levels of the accounts created.  Partiko stands out with the highest % of accounts not active in any form.  Blocktrades stands out with the highest % of wallet users and Oracle-d stand out with the most accounts considered fully activity (that is the have both voted and posted)

 

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, however these accounts also seem to need delegation to transact.

  

98.32% 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,884 which is 75% of accounts set up in January have received delegation.

Of this 18,884 account that received delegation, just over 95% received 30K Vests which we can see in the pie chart below

The first table below shows the new accounts, who set them up and how much in delegation they received.  The second table shows the people setting up accounts and how much in delegation they accounts they set up received.

   

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 were claimed in January.  Below shows who has been claiming these account creation tokens.  We can see Steemit Inc has claimed 22% of these, yet they have set up almost 90% of new accounts.  

 

Conclusion

2018 seen a down trend each month on the number of new accounts created.  Due to the standstill of accounts created by Steemit Inc in Dec its hard to tell if this trend has bottomed but I will be keeping an eye on things as the months progress.   Partiko has a large portion of inactive accounts however the total number of accounts created by them is rather small and therefore would not have a large impact in the overall number of non active accounts.  therefore I would put the increase in non active accounts down to the account creation delay by Steemit Inc.

Although there are many new account creation services, such as Steem-ninja, we have yet to see a large shift in the % of accounts set up by Steemit Inc v’s others.

 

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,'12/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/2018')

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.