In this second study of the 2018 January statistics for the Steem blockchain platforms I will look at the figures for busy.org.
Busy.org is a social network platform that interfaces with the Steem blockchain. The platform showed substantial growth in user metrics over the last three months of 2017, rising to be the second ranked Steem platform by payouts and third ranked by post numbers and regular user numbers by the end of the year. My January analysis of the “Market Share of the Steem Blockchain by Application” showed that the busy.org metrics for January 2018 were also very positive. This analysis looks in more detail at this growth and the statistics for busy.org over January 2018.
There are three parts to the analysis:
Overview of January 2018: An overview of the figures for January 2018 (daily individual author numbers, post numbers and reward payouts);
Analysis of Growth: A breakdown of the growth in key metrics from December 2017 to January 2018.
Top 50 Users: A summary of the payouts for the top 50 users over January 2018 showing those users that have had most financial success through the platform and the main tags under which they post.
I start by presenting a high level summary of findings for readers who have limited available time. The full details of the analysis are included in the later sections of this article.
An in the three preceding months, busy.org showed substantial growth in user metrics over January 2018.
The chart below covers the last three months: November 2017 - January 2018 for the platform:
Main metrics
Individual author numbers per day rose 140%, from around 900 at the end of December to 2,200 at the end of January.
The number of articles per day (not comments) increased at a similar speed, 1,300 articles became 3,100 over the course of the month.
Post payouts increased close to 100% month on month (taking the totals for each month as a whole) although the payouts in any particular week rose and fell, following the volatile movements in the Steem price (and crypto in general) across January.
Further analysis of these growth figures are included in the next section.
The table of figures below summarises the overall results for each month since the start of 2017:
| Month | All Posters | Regular Posters | All Posts | Total Payouts |
|---|---|---|---|---|
| Jan 17 | 8 | 2 | 24 | 22 |
| Feb 17 | 49 | 9 | 98 | 296 |
| Mar 17 | 31 | 8 | 75 | 126 |
| Apr 17 | 25 | 3 | 51 | 44 |
| May 17 | 50 | 5 | 109 | 242 |
| Jun 17 | 64 | 10 | 165 | 724 |
| Jul 17 | 117 | 32 | 1223 | 1,024 |
| Aug 17 | 64 | 10 | 169 | 288 |
| Sep 17 | 126 | 34 | 472 | 2,555 |
| Oct 17 | 937 | 307 | 4124 | 23,968 |
| Nov 17 | 1,367 | 747 | 14,266 | 59,900 |
| Dec 17 | 2,672 | 1,579 | 29,790 | 25,0011 |
| Jan 18 | 7,409 | 3,959 | 69,833 | 486,425 |
| Total | 120,399 | 825,624 |
Looking forward to February I would expect the strong growth in busy.org metrics to continue. However its rankings may come under challenge by DTube following the substantial additional delegation made to DTube from the central 
This section focuses on the growth in busy.org metrics between December and January. The following waterfalls break this growth down into its constituent parts.
It’s useful to consider the picture as a whole, so I’ll post the charts first and then draw conclusions.
The waterfalls tell a clear story of the growth over the last month.
Red float - User loss: Only 21% of users from December did not post again on busy.org in January. As in December (when the corresponding figure was 27%) busy.org has the lowest percentage user loss across all Steem platforms. It is also noticeable that these users represented a small proportion of posts generated and rewards (6% and 4% losses respectively).
Amber float - Increased production from existing users: Existing busy.org users from December increased their production by 33% on the platform between December and January, as measured by post numbers; a broadly comparable figure to that of 46% for last month. Their rewards increased by 55% (just above the 48% seen on steemit.com). The majority of this increase comes from the rise in the Steem price over January.
Green floats - Overall the number of authors in January increased by over 175% from that in December. The majority of additional authors were accounts created prior to the start of January (so could be considered to be users transitioning across to the platform). However there were also a sizeable number of users with accounts created in January, illustrating that new users to the blockchain are finding their way across to the alternative platform quickly. As might be expected, newer users obtained a smaller proportion of rewards than older existing accounts.
As a final analysis I look at the Top Users of the busy.org platform for January 2018, as measured by author payout.
It is worth noting that there are a couple of limitations to this analysis:
The sunburst chart illustrates the Top User payouts generated from the busy.org platform as measured over January 2018. A further layer of breakdown - the main tags under which they post - has been added.
(“various” is typically seen where posters use a wide variety of main tags).
top 50 users
A few highlights:
These top 50 authors represent 0.7% of all posters over January 2018 and earned just under 37% of all author payouts from the platform.
“funny” became there highest rated first tag in January 2018, with photography, life, busy and kr making up the top 5. “steemit” was the only new tag in the top 10.
The analysis is based on the data for the busy.org platform obtained through SQL queries of SteemSQL, a publicly available Microsoft SQL database built and maintained by 
The busy.org data has been filtered from the overall steem blockchain by use of the app label information in the json_metadata column of the Comments table. One limitation of this approach is that modifying an article in another application causes the app label information in the json_metadata column to change to that of the modifying platform. A recent analysis based on the Utopian platform data suggests that this limitation may have an impact of around 5% (although I would expect this impact to be smaller for busy.org data).
The analysis focuses on articles posted in January 2018. The data has been filtered by date using the timestamps in the created column of the Comments table.
Tag information has been obtained from the tag label information in the json_metadata column of the Comments table.
Valentina Studio, a free data management tool, was used to run the SQL queries. The raw data was then verified and analysed in the spreadsheet application of the LibreOffice office suite.
Graphs and charts were produced using Numbers, the Mac spreadsheet tool, or using RAWGraphs, an open source data visualisation framework.
SQL scripts are included in the next section.
This was the main script used for the analysis.
/* SINGLE APP ANALYSIS by AUTHOR and MONTH */
SELECT
Comments.author,
YEAR(Comments.created) AS [YEAR],
MONTH(Comments.created) AS [MONTH],
IIF(isjson(comments.json_metadata) = 1, IIF(CHARINDEX('/', json_value(comments.json_metadata, '$.app')) > 0, SUBSTRING(json_value(comments.json_metadata, '$.app'), 1, CHARINDEX('/', json_value(comments.json_metadata, '$.app'))-1),json_value(comments.json_metadata, '$.app')), null) as [Application],
Count(Comments.author) AS [Posts],
Count(distinct Comments.author) AS [DistinctCommentAuthor],
count(Comments.parent_author) AS [ParentAuthor],
count(distinct Comments.parent_author) AS [DistinctParentAuthor],
sum(CONVERT(REAL,Comments.pending_payout_value)) AS [PendingPayoutValue],
sum(CONVERT(REAL,Comments.curator_payout_value)) AS [CuratorPayoutValue],
sum(CONVERT(REAL,Comments.total_payout_value)) AS [TotalPayoutValue]
FROM
Comments (NOLOCK)
WHERE
YEAR(Comments.created) = 2018 AND
MONTH(Comments.created) = 1 AND
depth = 0 AND
IIF(isjson(comments.json_metadata) = 1, IIF(CHARINDEX('/', json_value(comments.json_metadata, '$.app')) > 0, SUBSTRING(json_value(comments.json_metadata, '$.app'), 1, CHARINDEX('/', json_value(comments.json_metadata, '$.app'))-1),json_value(comments.json_metadata, '$.app')), null) = 'busy'
GROUP BY
Comments.author,
YEAR(Comments.created),
MONTH(Comments.created),
IIF(isjson(comments.json_metadata) = 1, IIF(CHARINDEX('/', json_value(comments.json_metadata, '$.app')) > 0, SUBSTRING(json_value(comments.json_metadata, '$.app'), 1, CHARINDEX('/', json_value(comments.json_metadata, '$.app'))-1),json_value(comments.json_metadata, '$.app')), null)
Very similar scripts were used for the analysis by first tag and for the extraction of data by day. Briefly the small differences are:
tag label information for extraction and grouping in place of the year / month.That's all for today. Thanks for reading!
