Utopian.io - Full Year 2017 Statistics

in #utopian-io7 years ago (edited)

In this third study of the 2017 full year statistics for the steem blockchain platforms I will look at the figures for Utopian.io.

cover_utopian2017.png

Utopian.io is a platform built on top of the steem blockchain with the aim of rewarding open source contributors. Contributions to the platform must be related to open source projects but are not restricted to development work or bug-hunting; other categories of contributions include analysis, tutorials, translation, graphics and copywriting. Contributions are rewarded in the same way as other steem blockchain articles, using a stake-weighted voting system to distribute newly minted steem, but additionally benefit from a significant vote from utopian-io if the contribution passes the moderation rules for quality.

The Utopian.io project launched in September 2017 and this analysis over 2017 thus contains four months of data.

There are four parts to the analysis:

  • Overview of 2017: An overview of the figures for the full year 2017 (daily individual author numbers, post numbers and reward payouts) illustrating the rapid growth in the platform over the lat three months of the year;

  • Analysis by contribution type: A breakdown of the contributions by category type (development, analysis, tutorials etc) to illustrate where contributions and rewards are heaviest.

  • Analysis by organisation and repository: A breakdown of the contributions by organisation and repository to illustrate which projects are benefiting from the launch of Utopian.io

  • Top 50 users: A summary of the payouts for the top 50 users over 2017 showing those users that have had most financial success through the platform and their main categories of contribution.


Outline

  1. Scope of Analysis
  2. Tools Used
  3. Overview of 2017
  4. Analysis by contribution type
  5. Analysis by organisation and repository
  6. Top 50 users
  7. Scripts


1 Scope of Analysis

The analysis is based on the data for the Utopian platform obtained through SQL queries of SteemSQL, a publicly available Microsoft SQL database containing all the Steem blockchain data.

The Utopian data has been filtered from the overall steem blockchain data 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. However it is expected that this limitation has minimal effect.

The analysis focuses on articles posted in 2017. The data has been filtered by date using the timestamps in the created column of the Comments table.

Category and repository information has been obtained from the type and repository.full_name label information in the json_metadata column of the Comments table.


2 Tools Used

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 at the end of this analysis.


3 Overview of 2017

The Utopian.io project launched in September 2017 and showed rapid growth over the last three months of the year. In December it had risen to the third largest application on the steem blockchain ranked by total post payout, or sixth ranked by number of users posting articles.

The chart below covers the last three months of 2017 for the Utopian platform:

  • The light blue line is the number of articles per day and the dark blue line is number of distinct authors. These are plotted against the left hand axis.
  • The silver columns are author rewards and the gold columns are curator rewards. These are plotted against the right hand axis.

Screen Shot 2018-01-15 at 19.52.47.png

2017 main metrics - Utopian

The chart illustrates the attractiveness of the open source proposition to users of the steem blockchain. There has been exponential growth in users, articles and payouts over the last three months (although it is noted that the growth in rewards was assisted by the rise in the steem price over December, from US$1 to US$3).

Finally the table of monthly figures for Utopian summarises the overall results by month.

MonthAll PostersRegular PostersAll PostsTotal Payouts
Sep101227
Oct199365677,210
Nov5541922,74365,031
Dec1,2706249,758221,268
Total2,02485213,069293,737

The December figures showed over a 200% increase in regular author, post and reward numbers.

The figures also suggest an overall average payout of around $22 per article.

Looking to 2018 it will be interesting to see whether user numbers and payouts continue to rise, or if there is a plateauing from a saturation effect on the platform, with individual rewards reduced by increasing numbers.

Whilst the steem price has again risen in January, effectively giving the project additional funds for payouts, there has also been a stringent tightening of the quality requirements for Utopian contributions which may deter some users.


4 Analysis by contribution type

The aims of the second and third parts of the analysis are to understand what kind of work is being carried out and rewarded (part 4) and which projects are benefiting from this work (part 5).

The chart below shows post payouts (orange columns - excluding the utopian beneficiary payments) and post numbers (blue dots)

Screen Shot 2018-01-15 at 19.54.33.png

Breakdown by contribution type

Far and away the largest category, both by popularity of contribution and by payout, was translations. Tutorials ranked second under both metrics. Development was third most rewarded and seventh most popular contribution.

I would expect this pattern to significantly change over 2018. The recent doubling of rewards for development would be expected to significantly increase contributions from this category, whilst the increased stringency over translation and tutorials may well reduce contribution in these categories.


5 Analysis by organisation and repository

The circle packing diagram below shows the organisations that have most benefitted from the work carried out by the Utopian project. The size of the circles represents the payouts from utopian posts (there is an assumption made that the size of payout is a better proxy for the benefit to the project than the number of contributions - no measure will be perfect here).

The organisations and repositories have been extracted from the json_metadata and should reflect the file structure on GitHub. Some organisations may not be well known and as such I have added the most popular repository for clarity. Unfortunately due to space restrictions it was not possible to add all the repositories for each organisation, so some of the circles above relate to more than one project for the same organisation (e.g. MattyIce (bottracker) also includes work done on the postpromoter bot).

organisations5.png

Apologies the text is a little small - in order the entries are:
utopian-io, steemit, busyorg, WordPress, facebook (react)
opencart, eSteemApp, GNOME (gimp), code-dot-org, Minecolonies
bitshares, magento, electron, FreeCAD, inkscape, stoodkev (SteemPlus)
phalcon, deveerei (steemplay), therealFlauwy (1UP), liferay, Microsoft (TouchDevelop)
dtube, Chainers (steepshot-web), audacity, MattyIce (bottracker), BeehiveForum
shopware, gornanization (1k), JefPatat (SteemMakers), geoserver, zaproxy
exoplatform, Zappl, gplcart, torvalds (linux), arduino
mcfarhat (various), openfoodfacts, Akintunde102 (various), aaroncox (steemdb), thelia
apache (openoffice), LLK (scratchjr), netuoso (pacman-steem), coorasse (Airesis),
myary (steemauto), cloh76 (WhaleSong)

It is perhaps not surprising that the three largest projects to benefit, Utopian, Steemit, and busy.org are all steem blockchain platforms.

Over 2018, as utopian starts to draw in users from outside the steem blockchain, I would expect the central circles to reduce and rewards to diversify into projects from the wider open source world.


6 Top 50 Users

Finally, a sunburst chart of the top 50 users by author payout for the Utopian platform over 2017.

A further layer of breakdown - the main category type under which they post - has also been added. The colours should tally with those used on the utopian site for each contribution type. The grey segments are various smaller contribution types combined.

It is worth noting that there is at least one limitations to this analysis:

  • The amounts are expressed as per the payout values shown on steem platform sites - no conversion has been made to US$ or to Steem. The value of payouts can actually differ quite substantially from one month to the next, depending on the value of the underlying currencies.

top50bytype_crop.png

top 50 users over 2017 - utopian.io

A few highlights:

  • The chart shows that the three top rewarded users all diversified into various different categories for their contributions.

  • Four of the top ten users specialised mostly in translation, with two video tutorial creators, and two developers.

With the increased rewards for development I would expect the developers to start to dominate the top places on the rankings in 2018.


7 Scripts

This was the main script used for the analysis.


/* SINGLE APP ANALYSIS by AUTHOR and MONTH - 2017 Full year */
SELECT
    Comments.author,
    Month(Comments.created) as [CommentMonth],
    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) = 2017 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) = 'utopian'     


GROUP BY
    Comments.author,
Month(Comments.created) as [CommentMonth]
    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 analyses by contribution type and organisation / repository and for the extraction of data by day. Briefly the small differences are:

  • Changing from grouping by the month of the comment creation date to the exact date of comment creation allows the extraction by individual date. The author information is not required for this run (and the results would be very large by author and date)
  • Use of type and repository.full_name label information for extraction and grouping in place of the month.

That's all for today. Thanks for reading!



Posted on Utopian.io - Rewarding Open Source Contributors

Sort:  

Thank you for the contribution. It has been approved.

Hey @miniature-tiger, great analysis as always! I especially like the graph with the number of post and the total payout per category. I haven't seen this presented before. This seems to confirm that "development" is rewarded comparably well as intended. But the payout per post for analysis also seems higher than the others, at least from a first glance. The bot configuration changed a couple of times in the analyzed time range, but with the majority of contributions and payout in the last few weeks this should not make a bit difference IMO.

Just a minor remark: could you change the repo to utopian-io/api.utopian.io? This is more about the backend than the frontend.

You can contact us on Discord.
[utopian-moderator]

Thanks @crokkon!

Yes, I think that's the right conclusion on payout per post - development does well as intended. I think analysis also does better than most due to the low number of contributions, so more of them get the higher level of upvote and fewer at the minimum.

I'm happy to change the repo, except when I edit the post it's greyed out and won't change. Any ideas?.

You indeed cannot change the repository after the contribution was approved, sorry. Let's leave it like that this time...

Incredible compilation! Thank you for doing the due-diligence​ to bring this data to the masses here on Steemit. Plus, your infographics are STUNNING. I can't help it, I'm a sucker for beautiful data. 😍

Thank you Amelia!

I'm using rawgraphs.io for the lower two graphics (and mac numbers for the top two).
Rawgraphs does very pretty things but only the way it wants to. So you have to fit your data into its moulds. Still it's fun to play with and it does produce some intuitive graphics.

Awesome to see you have not only the pun skillz, but also the analysis skillz. Same part of the brain, that. ;P

Yes. In the hippo camp by us.

This is amazing! I am really glad to be part of the top contributors. It's an honor to be part and thank you for bringing these amazing data.

Again, amazing and inspiring!

Hey @jassennessaj, no problem! Great to see your name up there representing Team Analysis!

Cool analysis. Thanks.

You're an inspiration. :) You've presented it in ways I never could have done.

Thanks @eastmael! Oh and congratulations! You made it onto that top 50 list - more of the same for 2018!

Thank you. I particularly loved the sunburst. It was a chart I have never understood its use, but your example made tit clear to me.

thanks for sharing! extra point for providing the scripts you used! :-)

Ah, them's the rules. It's a good one too. It is open source after all!

Hey @miniature-tiger I am @utopian-io. I have just upvoted you!

Achievements

  • Seems like you contribute quite often. AMAZING!

Community-Driven Witness!

I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!

mooncryption-utopian-witness-gif

Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x

Thanks to everyone who worked on sorting out the glitches yesterday!

que buen análisis! es mas es buen material de referencias para lo pronósticos de análisis de las plataformas de steem blockchain para el presente año! es mi forma de pensar, soy nueva en el tema y quiero aprender mas!

I was a new Member, please help so that my success in my steemit want to help parents pay for the treatment of pain again at the hospital.

https://steemit.com/introduceyourself/@faisalmakruf/hallo-sahabat-steemit-saya-ingin-memperkenal-diri-hello-steemit-family-i-wanna-introduce-myself

Coin Marketplace

STEEM 0.20
TRX 0.15
JST 0.029
BTC 62864.56
ETH 2538.87
USDT 1.00
SBD 2.93