@utopian-io - Contribution 'Approved/Rejected' Analysis - October 2017
This is an analysis of the Contribution types, and approval/rejection numbers for October 2017.
Sections
General / Assumptions
Contributions Summary
Contributions by Type
Summary
Tools used to gather data and compile report
General
@utopian-io is the new kid on the Steem block, and has amassed 3.7 million Steem power through delegations.
This is an analysis of the number and type of contributions sent for review, and the success/failure rate of each contribution type.
Assumptions
Currently, there is no indicator for 'approved' or 'rejected' contributions to utopian.io on the Steem Blockchain.
In this report, 'Approved' contributions have been voted on by @utopian-io.
'Rejected' contributions have not received a vote from @utopian-io.
1. Contributions Summary
For the month of October 2017, the SteemSQL DataBase holds a total of 740 potential contributions to utopian-io.
In October, 524 of this contributions were approved, a total of 71%.
The Contributions can be split into the following categories:
This data is also represented in the chart below:
44% of the contributions to utopian-io in October were 'Ideas' based with the second biggest type of contribution being 'Translations', at 15% of the total made.
2 Contributions by Type
In this section the main contribution types are presented using a pie chart and the remaining types are also listed below with associated figures.
Ideas - Approvals / Rejections
Bug-hunting - Approvals / Rejections
Translation - Approvals / Rejections
Development - Approvals / Rejections
Graphics - Approvals / Rejections
Documentation - Approvals / Rejections
Social - Approvals / Rejections
All contribution types
The following table shows all types and totals of contributions submitted, with their approval % in the end column.
- The 'Undefined' contribution type is fro data gathered prior to an addition of contribution (github) 'type' in the 'json_metadata' field.
3. Summary
From the data above, the following evaluations can be made.
71% of all contributions are approved. This is promising for anyone willing to take the step to help support utopian.io
Development contributions total only 9% of all submissions in October, showing that utopian.io is not just for developers.
'Social' and 'Announcement developments/ideas' have the lowest approval success rate, while 'Analysis' has the highest. However, there were only 5 analysis contributions in October and so this could unbalance the figure here.
Almost 60% of all contributions are a combination of 'Ideas' and 'Bug-hunting', again showing that it is possible for anyone to make a useful contribution to @utopian-io.
4. Tools used to gather this report
The data is sourced from SteemSQL - A publicly available SQL database with all the blockchain data held within (Data is normally 1/2 hours delayed from live)
The SQL queries to extra to the data have been produced in both SQL Server Personal Edition and LINQPAD 5.
The charts used to present the data were produced using MS Excel.
This data was compiled on the 23rd November at 8:30 am CET
I am part of a Steemit Business Intelligence community. We all post under the tag #bisteemit. If you have analysis you would like to be carried out on utopian-io/Steem data, please do contact me or any of the #bisteemit team and we will do our best to help you.
Thanks
Asher @abh12345
Posted on Utopian.io - Rewarding Open Source Contributors
This post took approximately 15 hours to put together, I hope that someone finds it of use!
lol I can laugh because i understand. These posts do take a long long time but be assured they also do add value. I really liked how you were thinking outside of the box when it came to identifying 'approved' or 'rejected.
Thanks Paula!
Yes you spend hours formulating the data and then almost as long building the charts and formatting the post.
Yes I had a good think about it and decided votes by @utopian-io must = approved.
The trickiest part is parsing the (ugly) json_metadata field in 'Comments. This field can change depending on last edit location (Steemit, busy, etc) and at least one other reason I've noticed but yet to figure out why!
Thanks for your support as always 😁
P.s. I'll be entering this into the last #bisteemit comp soon
oh, I was looking at the json_metadata last night and ran into problems with my sql. I will ping you on discord in a few hours when I have a bit of time
No problem, I'll be around 😊
Its Thanksgiving in the States... they've all got enough pies on their plates.
Lucky them!
there might be an easier way to get this information from the utopian API:
https://api.utopian.io/api/posts, there ispending/reviewed/flaggedavailable, see github. Use?limit=0to get all utopian contributions at once (several MB of JSON!) or via pagination (?skip=#&limit=#). Thesection=,sortBy=,filterBy=andstatus=parameters should be able to give the expected result. Check the API requests of the Utopian frontend for examples.Looks like some learning is required here for me!
Thanks for the heads up 👍🏾😁
I was not aware of this either. Awesome. Is this API documented on github?
AFAIK there is no documentation beside the code and its comments, but this in combination with a look into the API calls from the frontend is comparably easy to understand.
These are the basic API URLs:
https://api.utopian.io/api/postshttps://api.utopian.io/api/usershttps://api.utopian.io/api/statshttps://api.utopian.io/api/moderatorshttps://api.utopian.io/api/sponsorsfor the options of each call, see the according file in src/server/models.
thank you for this valuable information
Not challenging your statement, but I am a developer who prefers to hunt bugs and make suggestions for now. So it is probably not the case that 81% of all utopians are non-developers.
Fair point. The statement was made to encourage non-developers to see if they can contribute in any way.
I've had comments on recent blogs from 'non-devs' assuming they have no role to play.
I think this is a great opportunity for all!
Thank you for the contribution. It has been approved.
You can contact us on Discord.
[utopian-moderator]
Thank you very much!
Your posts make me want to eat a pie
All day i think about pie :p
3.14159 IN YO FACE!
Wrong pie for my face :(
Better?
is that soc cah or toa or sine? I need sleeeeep.
Hey @abh12345 I am @utopian-io. I have just upvoted you at 12% Power!
Achievements
Community-Driven Witness!
I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!
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
This is a gold mine to tap in. You can make serious money and dominate every tag you pair with utopian-io if you get approved.
Certainly has a lot of potential, lets see!
Ha. I just submitted my analysis for approval. I should have read this first! 71% says my luck should be in hopefully!
Good luck!
Yes i think 71% is very reasonable!
The mods are helpful in discord, and now you can chat to them on the web interface too.
Dine well....
Good Job
Thanks for share
Cheese on toast for lunch :)
Thank you!