Analysis of the 1UP Project

in #utopian-io7 years ago (edited)

The 1UP curation system designed by @flauwy is scheduled to go live later this week. This project aims to combine the power of the steem hive-mind with a lucrative curation trail to find and reward the best contributions to Utopian, the Steem platform for rewarding open source contributors.

The 1UP development will incorporate an additional “1UP” upvote button to the Steemit, Busy and Utopian platforms through the browser extension SteemPlus. This button will allow users to vote on their preferred Utopian posts using their daily allowance of “1UPs” and every 2.4 hours the highest ranking post by number of 1UPs will be rewarded with upvotes from the 1UP curation trail. The curation trail will operate prior to the powerful Utopian bot allowing members of the curation trail also to be rewarded through higher curation rewards.

The 1UP system is a brand new open source project, having been started in December last year. It has been developed through the collective work of many contributors on the Utopian platform who in return have received rewards for their efforts. The aim of this study is to examine the 1UP project as an early example of how the Utopian platform can act as a powerful tool in allowing a new project to come swiftly to fruition.

The two main areas of this study are:

  • An analysis of the 1UP project contributions by date and type to establish the timing of the project work-streams from inception to go-live and their associated rewards;
  • A breakdown of the contributions by author and type to illustrate how many Utopians have been mobilised to contribute to the project and how they have been rewarded.

analysis of 1up project cover.png

0 Summary of Findings

I start by presenting the 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.

0.1 Analysis of Project Timing and Work-streams

In the first area of the study I analyse the 1UP project contributions by date and type to establish the timing of the project work-streams and their associated rewards.

The calendar diagrams below illustrate the timing of the 1UP project from inception to go-live. The first Utopian contribution was on 14 December 2017 and the latest contribution was on 22 January 2018.

Screen Shot 2018-01-23 at 18.17.56.png

Screen Shot 2018-01-23 at 18.19.36.png

The Utopian contributions for the 1UP project fall into four types:

  • Development (red): This includes (i) the back-end development work implementing 1UP on SteemPlus which was carried out by @stoodkev and (ii) the styling and front-end development work which was produced by @andrejcibik.
  • Task-graphics (blue): These were requests made by @flauwy for Utopian contributors to provide potential graphics for use in the project. The first major request on December 15 was for the design of a pixel-art mascot. The second on 28 December was for the design of a cartoon illustration of the mascot for use in communications and on the 1UP ranking page.
  • Graphics (purple): These are contributions from many individuals in response to the task-requests from @flauwy (the circles combine all contributions made on the same day by different authors). We can see that they follow in the week after the task requests.
  • Blog (pink): A post from @flauwy towards the end of the project illustrating the mock-up of the designs for 1UP with a request for feedback.

The calendar immediately illustrates one of the strengths of Utopian: The platform is not just for rewarding development work but also incentivises contributions to be made in wider areas, allowing much rounder projects to be fashioned. For the 1UP project we can see that there were many contributions made for the graphical design. Utopian also has categories of contribution for tutorials, copyrighting, analysis, translation and bug-hunting - it is likely that many of these will also be employed on the 1UP system once the project moves from initial development to live status.

Another strength of Utopian seen in the data is the ability to quickly resource contributors through task requests, since there are a large number of contributors available on the platform. As illustrated for the two graphics task requests, the time from request to completion was only a week in each case and was enabled simply by launching the task request on Utopian.

The calendar also illustrates how quickly the project has been completed, with approximately seven weeks from inception to go-live. Whilst the data shows that a large part of this is thanks to the swift development work of @stoodkev (who has made 12 out of 13 development contributions) there is a clear possibility shown to progress work-streams in parallel, for example the graphics work and the development work.

The overall rewards for each contribution type were as follows:

Screen Shot 2018-01-24 at 00.47.55.png

In the next section I will illustrate how these figures break down by contributor.

0.2 Mobilisation and Reward of Utopians on the 1UP project

In this section area of study I analyse the breakdown of 1UP contributions by author and type to illustrate how many Utopians have been mobilised to contribute to the project and how they have been rewarded.

The sunburst chart below shows the breakdown by contribution type (inner circle) and contributor (outer circle).

Screen Shot 2018-01-23 at 19.09.03.png

A summarised version of the above sunburnt is included below for clarity.

Screen Shot 2018-01-24 at 01.22.11.png

In total there were fifty-three successful contributions to the 1UP project from thirty two contributors (and three that did not pass moderation). Two of those contributors were on development, both of the task request and blog categories were covered by @flauwy, and the remaining authors contributed potential designs for the graphics.

The development work was best rewarded, with an average payout per contribution of $68. The graphics contributions received $28 on average (all figures are author rewards only, excluding both curator and beneficiary payments, and as expressed on the user interfaces, i.e. not converted into $US values).

The breakdown illustrates the two different approaches taken to the development and graphics work streams. Whilst the development was covered by two individual developers working on the front-end and back-end, the graphics contributions were made through a competitive process involving many individuals.

The graphics work-stream shows the power of Utopian in quickly mobilising many contributors. As Utopian grows and attracts more open source developers from outside the Steem blockchain, there is potential for the development work to be equally well resourced, with a corresponding benefit of swift development of open source projects, many of which are likely to benefit the Steem infrastructure itself.

However the graphics work-stream could also be considered as quite inefficient compared to the development work-stream. As Utopian continues to grow it will be interesting to see whether different systems are put in place to maximise the efficiency of producing work and distributing rewards. For example a system of tendering, or direct requests to contributors from project owners based on evidence of prior work could be possible approches.


Outline

  1. Summary of Findings (see above)
    0.1 - Analysis of Project Timing and Work-streams
    0.2 - Mobilisation and Reward of Utopians on the 1UP project
  2. Scope of Analysis
  3. Tools Used
  4. Scripts


1 Scope of Analysis

The analysis is based on the data for Utopian contributions to the 1UP project. The data has been obtained through SQL queries of SteemSQL, a publicly available Microsoft SQL database containing all the Steem blockchain data.

The 1UP project data has been filtered from the overall steem blockchain data by use of the .repository.name label information in the json_metadata column of the Comments table. The .type label allowed the separation by contribution type.

The analysis focuses on the time period of December 2017 and January 2018 (although data was extracted from September to capture any potential data since the start of the Utopian project). The data has been filtered by date using the timestamps in the created 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 RAWGraphs, an open source data visualisation framework.

SQL scripts are included at the end of this analysis.


Summary of Findings

Analysis findings have been included in the summary of findings at the start of the report. I have decided not to repeat the information here.


3 Scripts

This was the script used to extract the data relating to the 1UP project:


SELECT
    Comments.author AS [Author],
    CONVERT(date, comments.created) as [DATE],
    Comments.category as [category],
    IIF(isjson(comments.json_metadata) = 1, json_value(comments.json_metadata, '$.repository.name'), null) as [Repo],
    IIF(isjson(comments.json_metadata) = 1, json_value(comments.json_metadata, '$.repository.full_name'), null) as [RepoFull],
    IIF(isjson(comments.json_metadata) = 1, json_value(comments.json_metadata, '$.type'), null) as [Type],
Comments.total_payout_value as [AuthorPayment],
Comments.curator_payout_value as [CuratorPayment],
Comments.pending_payout_value as [PendingPayment],
IIF(isjson(comments.json_metadata) = 1, json_value(comments.json_metadata, '$.app'), null) as [App],
case when comments.last_update > comments.created then 1 else 0 end as [Edited],
Comments.title as [Title]


FROM
       Comments (NOLOCK)


WHERE
   CONVERT(date, comments.created) >= '2017-09-01' and
    depth = 0 and
    Comments.category = 'utopian-io' and
    IIF(isjson(comments.json_metadata) = 1, json_value(comments.json_metadata, '$.repository.name'), null) = '1UP'


ORDER BY
    Comments.created

That's all for today. Thanks for reading!



Posted on Utopian.io - Rewarding Open Source Contributors

Sort:  

.

Thanks @crokkon!

Agreed! I think it will be fascinating to see how the project works once it goes live, how people vote and which contributions get the 1UP trail. I'm not sure where the data will be available from though so make that kind of analysis with the 1UP votes. One to look into!

OMG that is such an amazing and detailed analysis. You totally blew me away with this. Thanks! :)

No problem @flauwy. I'm glad you enjoyed it!

Congratulations to yourself and to everyone working on 1UP so far for bringing the project on so quickly. And good luck for the go-live!

Wow! Great work @miniature-tiger, I have been following you for a while now! Didn t think I would see my name in here someday ;)

I'm sure with all your development skills we'll be seeing your name a lot more around here in the future!

good stuff, i'm going to have to watch a tutorial about utopian sometime, i was checking out the site last week / peace

It's worth at least joining the platform and having a look around. Even if not to contribute it's interesting how it operates differently from the rest of the blockchain in terms of rewards. It's close to skills-based rewards than stake-based rewards.

I was not aware of this project, thanks for sharing, im now going to look up more on 1up

It's an interesting one Paula - I'll be keen to see how it plays out once it launches!

This is an interesting insight into how a project develops within the Utopian community. !UP is exciting a topic and I'm looking forward to it launching and the subsequent BI analysis of the project as well.

Thanks for another great job, @miniature-tiger.

Thanks Mayhem!

Hi miniature-tiger, i may be completely off-topic here but i wanted to draw your attention to a recent post of @arcange https://busy.org/steemsql/@arcange/steemsql-is-moving-to-a-monthly-subscription-model as i assume that you are using Steemsql.

Thanks @dbddv01, that's very much on topic and I'm grateful to you for bringing it to my attention.

Excited to see the new functionality in SteemPlus and how well it will be adopted by steemit users.

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 your post!

great idea...

Nice post and very educative. I have followed and upvoted this post. Please be kind enough to follow back and upvote my posts to encourage me as a minnow. Thank you in advance. Steemit will be there I believe.

Congratulations @miniature-tiger! You have completed some achievement on Steemit and have been rewarded with new badge(s) :

Award for the total payout received

Click on any badge to view your own Board of Honor on SteemitBoard.
For more information about SteemitBoard, click here

If you no longer want to receive notifications, reply to this comment with the word STOP

By upvoting this notification, you can help all Steemit users. Learn how here!

OMG IS VERY BEUTIFUL, I LIKE THIS @miniature-tiger..i have following you, every day I see you steemit