June '19 New Steem User Report
utopian-io·@paulag·
0.000 HBDJune '19 New Steem User Report
<html> <p> Each month I produce a report with details of New accounts created on STEEM. It has long been established that the account creation route via Steemit Inc has flaws, with delays, batch account creation and users never activating accounts once they have been created. </p> <p>At one stage Steemit Inc acknowledged 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. </p> <p>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. These changes allowing others to create accounts, although technically ready and rolled out, have yet to have a major impact on the volume of accounts being set up by Steemit Inc. </p> <p>If you missed last months post you can check it out here</p> <p> <a href="https://steemit.com/utopian-io/@paulag/may-19-new-steem-user-report-1559482192612">https://steemit.com/utopian-io/@paulag/may-19-new-steem-user-report-1559482192612</a> </p> <h2>Aim of Analysis</h2> <p>The aim of this analysis is:</p> <p>• Establish how many new users registered</p> <p>• Establish what % of accounts have posts and voted and are just wallet holders.</p> <p>• See who is claiming account creation tokens</p> <p>• Establish if delegation is been given to accounts so they can transact. </p> <h2>Repository</h2> <p>https://github.com/steemit/steem</p> <h1>Overview</h1> <h3>June 18</h3> <p>https://cdn.steemitimages.com/DQmd3s4sbiFwourj5Yan8ZdxJGB5oQzVmKw9dB3GWvNTdPd/1.0.png </p> <h3>Year to Date 2019 </h3> <p>https://cdn.steemitimages.com/DQmYzJ9qHDovnGoifmy3KNUfvBxpbmDAC3VUzmMsnTw27ny/1.1.png </p> <h2>June 19</h2> <p>https://cdn.steemitimages.com/DQmUSSgpmfYw2DKjvawbEZhuD8HUkc4aaDjPAhiTnE1m4Hz/2.png </p> <p>June 18 seen a continuation of the downturn which started earlier that year and we see that 42% of account never became active. If we look at all accounts set up in 2019, we can see this is running at about 47% for the year to date. </p> <p>June 19 again shows Steemit Inc creating the bulk of new account. Last month I raised concerns about Steemit inc falling behind and it was confirmed there was a backlog. From the data above, it appears this backlog is growing.</p> <p>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 calibre of user. Those with intent of using the platform for a social purpose will have more tendency to complete their profile. The % of new accounts that have added a website or external link has been consistent at around 7%. This month however we see an increase to 11%.</p> <p>For clarification on the Account activity levels</p> <p>• Fully active accounts have both posted and voted</p> <p>• Not active accounts have not vote/posted or made a transfer</p> <p>• Wallet users have not vote or posted but have made a transfer out from their account.</p> <p>Last month I reported that the reduction in new accounts had bottomed out, however this month we see another reduction of around 30% on the previous month. </p> <p> https://cdn.steemitimages.com/DQmP8hCKv8yn1eQB3mkQXJ6CmtNhDizd31mGrZxm2GD8Cdv/3.png </p> <h2>Activity Level by Creator</h2> <p>Taking the top 6 account creators, below we can compare the activity levels of the accounts created. </p> <p> https://cdn.steemitimages.com/DQmQxLKW3qhZTzNMoz5pd5WS6whx5cygduMsjBkBw3rjDXW/4.png </p> <h2>HF20 Changes</h2> <p>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. </p> <p>96.53% of new accounts set up, were set up with the newly introduced account creation tokens. The balance, 329 accounts, were created by burning STEEM at 3 STEEM per account.</p> <p> https://cdn.steemitimages.com/DQmSMTHtaDWznFqmg7evWmnayk16s1eo2KFANGTDjisCYYH/6.png </p> <p>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?</p> <p>75% of accounts set up in June have received delegation. 25% have not. Of this 75% of account that received delegation, almost 73% received 30K Vests which we can see in the pie chart below. And the balance received more.</p> <p>https://cdn.steemitimages.com/DQmYBabPYViotjZgLKogYnvCi5fgL2Qv8mDrLG33itK7PVR/7.png </p> <p>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 sent accounts that we set up. </p> <p>The tables below show all the accounts set up in 2019. On the right, the table shows the number and % of accounts with an Owned SP grouping of 10. We can see that 97.87% of accounts own less than 10SP and 0.39% of accounts own between 10 and 20 SP.</p> <p> https://cdn.steemitimages.com/DQmZTUKYAmd1KTAv8x4DVZS2kYz5Ejb8cutgAbfgruAsq7q/8.png </p> <p>The table on the left shows all accounts set up in 2019 and how much SP they control. Controlling SP is Owned SP + Received Delegations – Delegations given. We can see from this 56% of accounts have less than 0 SP and 40% have between 0 and 10 SP they control. </p> <h2>Account Creation Tokens (Year to date)</h2> <p>The introduction of account creation tokens in HF20 allows users claim the right to set up an account. In total 60K account creation tokens were claimed in June. Below shows who has been claiming these account creation tokens year to date. We can see Steemit Inc has claimed almost 17% of these, yet they have set up 81% of new accounts year to date.</p> <p> https://cdn.steemitimages.com/DQmUd2n85pz3bkyhpGob8yR1hb1AC4XtDqJhtrzvDcSbow3/9.png </p> <h2>Conclusion</h2> <p>2018 seen a down trend each month on the number of new accounts created. It was looking like this downtrend had bottomed, however the decline last month and now again this month shows that we may not have seen the bottom yet.</p> <p>Last month I reported that steemit inc appeared to be behind in account creation and were sitting on a backlog. This was confirmed to be the case. From this months data, my workings would indicate that the accounts set up this month by steemit inc, covered the previous months backlog and a only small few applicants for June. I would anticipate the backlog levels to be around 4.5K accounts.</p> <p>The impact of these delay can be seen in the high % of accounts set up by steemit inc that never became active. To long of a wait and people forget or lose interest.</p> <p>56% of accounts set up this year have less than 10 SP they control. We have seen that this causes RC problems and restrictions on accounts. The % of inactive account is almost 47%. We can conclude from this 9% of active accounts control less than 10SP. </p> <p>It is also alarming that only 2% of accounts set up this year have powered up 10SP or more. Only 0.75% of accounts set up this year have powered up more than 100 SP</p> <h2>The Data-source and Query</h2> <p>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:</p> <pre><code>Select *</code></pre> <pre><code>FROM Accounts (NOLOCK)</code></pre> <pre><code>where </code></pre> <pre><code>( created >= CONVERT(datetime,'01/01/2019')</code></pre> <p><br></p> <p>To get details of who set up each account I used the following query</p> <pre><code>Select *</code></pre> <pre><code>FROM txAccountcreates (NOLOCK)</code></pre> <pre><code>where </code></pre> <pre><code>timestamp >= CONVERT(datetime,'01/01/2019')</code></pre> <p>and to get details of accounts that used their wallets I used the following</p> <pre><code>select [from], timestamp</code></pre> <pre><code>from TXTransfers</code></pre> <pre><code>where </code></pre> <pre><code>timestamp >= CONVERT(datetime,'01/01/2019')</code></pre> <p>The query used to find out who is claiming accounts was</p> <pre><code>Select *</code></pre> <pre><code>FROM TxAccountClaims (nolock)</code></pre> <p>Once I loaded the data into Power BI, I then carried out transformation and calculations using DAX language. </p> </html>
👍 aeiou00, cryptotokeneur, ken01, ezravandi, angelinafx, pc-tip, dlikeguy, accelerator, circa, johnhtims, shammi, reazuliqbal, barski, jacekw.dev, clumsysilverdad, map10k, jacuzzi, simplymike, damahsyari, rycharde, gamer86, hazard10, leir, tfq86, we-are-welcoming, stevelivingston, agnesmo, espoem, mops2e, crokkon, amico, abh12345, jacekw, wolfhart, amosbastian, steemclan, rufans, jaff8, bestofph, helo, kendallron, ulockblock, render-obsolete, akiroq, sbi5, codingdefined, newageinv, east.autovote, cicisaja, niallon11, buckydurddle, jinger, thehive, roxso, javicuesta, jan23com, make-a-whale, hitmeasap, solar, beamentor, myotherstuff, jasonbu, felicenavidad, wherein, ripperone, arcange, nanzo-scoop, freebornsociety, ravenruis, holger80, beeyou, lauchmelder, zcool, legendchew, wolfvanween, musmui, semperenglish, mummyimperfect, ak2020, emily-cook, t-bot, mafeeva, beautifuldata, wildarms65, fitat40, skramatters, scoopstakes, nanzo-snaps, peekbit, mcfarhat, etherpunk, steemituplife, kgdruglords, raphaelle, dreemsteem, aneukpineung78, roleerob, apostle-thomas, j3dy, arteem, ab123, bookkeeping, jbap85, steemitph, steeminer4up, mustang88, crazy-facts, wpkwolfe, akubaihaqi, nolimit909, marchforth, gokulnk, boxcarblue, rt395, steemitbc, cali914, orlandumike, true2bigblue, crimsonclad, akdx, wallyd, lordoffaux, sahari72, discordiant, cyrus33, richatvns, drbec, familytree, schro, protegeaa, amriadits, ladiesofsteemit, tebarsuara, payoutbot, followbtcnews, teamsteem, bembelmaniac, inquiringtimes, seanlloyd, slobberchops, bingbabe, dismayedworld, bluerobo, filterfield, ameliabartlett, memeitbaby, indayclara, cryptofuwealth, yomismosoy, kafupraise, enjar, juliakponsford, allseeingewe, oluwasetemi, bashadow, dalz, new-world-steem, dylanhobalart, masterthematrix, mytechtrail, kreesher, camillesteemer, mattclarke, sollot, scorer, cardboard, cfminer, gameo, tipu.curator, rokyupjung, steevc, partiko, yoogyart, danielsaori, pediatrics, etcmike, rayfa, we-are-palcoin, lextenebris, steemitri, steem-ua, sargoon, borislavzlatanov, jakipatryk, jonygomez, gsxr, ryuna.siege, utopian-io, tombstone, jga, dicetime, cryptouno, alitavirgen, rikaz87,