@utopian-io - Contribution 'Approved/Rejected' Analysis - 23rd - 29th March 2018

in #utopian-io7 years ago (edited)

This is an analysis of the Contribution types, and approval/rejection numbers for the 23rd - 29th March 2018 inclusive.

Contents

General / Assumptions

  1. Contributions Summary

  2. Contributions by Type

  3. All contribution Types

  4. Summary Analysis

  5. Tools used to gather data and compile report


newtitle.png


General

@utopian-io is the open source project for open source projects, housed on the Steem Blockchain.

Currently, @utopian.io holds almost 3.9 million Steem power through delegations from its kind sponsors.

To become a sponsor and view the current standings visit https://utopian.io/sponsors

This report is an analysis of the number and type of contributions sent for review, and the success/fail rate of each contribution type.

Recent reports of this type are listed here.

OCT 2017: October 2017

NOV 2017: Week 1 - Week 2 -
Week 3 - Week 4

DEC 2017: Week 1 - Week 2 -
Week 3 - Week 4

JAN 2018: Week 1 - Week 2 -
Week 3 - Week 4 - Week 5

FEB 2018: Week 1 - Week 2 - Week 3 - Week 4

MAR 2018: Week 1 - Week 2 - Week 3


I will aim to provide this report on a weekly basis, with a look at the previous weeks data and more historical data to compare and contrast.

This will allow contributors and employees of utopian.io to keep in touch with how the platform is progressing with regards to approval percentages and number of Contribution Types being submitted.


Assumptions

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 week, 23rd - 29th March 2018 inclusive, the SteemSQL DataBase holds a total of 1077 potential contributions to utopian-io. This is 274 fewer contributions than the previous weeks' total which was 1351.

status.png

382 of these contributions have been approved, 173 fewer than the previous weeks' total of 555.

The approval percentage of 35% is a 6% fall from the previous week. The approval percentage also fell 6% last week from the week prior to that.



The Contributions offered can be any one of the following types:

catsnotrans.png

Note: 'Translation' contributions are currently on hold.



This weeks data, split into Contribution types is shown in the pie chart below:

allconts.png

'Ideas/Suggestions' continue to hold the largest share of contributions at 34% this week, and has maintained being the source of around a third of all contributions. However, the total for the category is noticeably lower this week and stands at 371, down 154 from last weeks' total.

'Bug-hunting' retains second position with 26% of all contributions, a rise of 7% on the previous week. There are 49 fewer submissions to this category this week.

'Graphics', in 3rd spot last week, holds this place again this week with 17% of all contributions - the same percentage total as last week.

These three largest categories account for over three-quarters of all contributions offered.


2 Contributions by Type

In this section we take a look a few of the individual contribution types of interest.

A full list of contribution types is listed further below with associated figures and analysis.


'Development' - Approvals / Rejections

The 'Development' category continues to flourish is 2018 with another excellent week. An approval rating of 89% is 22% higher than the next best categories and this figure shows that almost 9 out of every 10 contributions are approved.

image.png

Despite the dramatic fall in overall contribution numbers over the past month (as we shall see below), 'Development' submissions contribute to hold up close to 100 for the week analysed.

89% approval for the category is the highest in 2018.

'Suggestions/Ideas' - Approvals / Rejections

The most contributed to category again this week, 'Ideas' submissions totalled 371. However, the approval percentage for this category is poor and totalled only 22% this week.

image.png

As the chart above shows, the approval percentage has now declined for 3 consecutive weeks and is now only just above 1 from 5 contributions receiving approval.


3. All contribution types

The following table shows all types and totals of contributions submitted, with their approval percentage in the end column.

image.png

'Development' continues to be the stand-out category for utopian-io.

'Analysis' contributions totalled only 6 for this weeks analysis, with 4 of these receiving approval. Whilst the category has never been the most popular, 6 contributions is a clear low for 2018.

'Bug-hunting' gained a 36% approval percentage, it's lowest in 6 weeks but did show a small increase in contribution numbers - the only one of the more popular categories to do so this week.

'Tutorials' and 'Video Tutorials' again showed a combined approval average of 46% but totalled less than 100 contributions for this week's' analysis.

'Graphics' approvals fell 16% on the previous week with 49 few contributions.

'Social' had 2 approvals this week from 16 contributions, lifting the approval percentage out of single digits.

And 'Blog' contributions still continues to disappoint as a category with just one approval (from 15 contributions - 16 previously) again this week.


4. Summary Analysis

This week, the number of contributions has fallen once again.

Previously:

This is largely due to the pausing of 'Translation' contributions (two weeks ago), and the tightening of the rules regarding 'Social' contributions.

While this 'excuse' could have held true previously, the additional fall in totals this week cannot be tied to this and speaks of further reasons behind the fall in contributions.

image.png

The total contributions have again reached a new low for 2018.

Perhaps the reason for this is due to the fall in the price of STEEM, which has declined rapidly since the middle of January. Only today (3rd April 2018) has there been a swing in the price of the token, and this could well be the turning point in contribution totals.

As well as the fall in submissions, the approval percentages have also suffered in recent weeks.

image.png

It is the 3rd week in a row that the overall approval percentage has fallen, and it is now over 30% from the recent highs at the beginning of March.

While a tightening of the criteria and rules across the categories will account for some of this, it is tough to see this as the whole reason behind the drop in success rate - perhaps the level of quality just isn't reaching that of earlier in the year.


Summary

Another slide in contributions and approval percentages - just over one third of all contributions receiving approval.

'Translations' is still on hold.

Rule changes, and other factors including the fall in the price of STEEM are putting pressure on both contribution totals and approval percentages.

'Development' remains the shining light for utopian-io, and contributors to this category are doing an excellent job and continue to be rewarded well for their work.


5. Tools used to gather this data and compile report

The charts used to present the data were produced using MS Excel.

The data is sourced from SteemSQL - A publicly available SQL database with all the blockchain data held within.

The SQL queries to extra to the data have been produced in both SQL Server Personal Edition and LINQPAD 5. Some of the code used for these results is as follows:


----------------------------------------------
-- MAIN INSERT START
----------------------------------------------

-- TAGS and Authors
SET NOCOUNT ON
Declare @postlink Varchar(2000)
Declare @startCount int
Declare @endCount int
Declare @typeStartCount int
Declare @typeEndCount int
Declare @value Varchar(100)
Declare @starter Varchar(50)
Declare @ender Varchar(50)
Declare @typeStarter Varchar(50)
Declare @typeEnder Varchar(50)
Declare @utopianEnder Varchar(50)
Declare @newtags Varchar (2000)
Declare @author Varchar (50)
Declare @created datetime
Declare @tags Varchar (MAX)
Declare @contributionType Varchar (50)
Set @starter = '"tags"'
Set @ender = '"links"'
Set @utopianEnder = '"users"'
Set @typeStarter = '"github","type"'
Set @typeEnder = '"tags"'
DECLARE EMP_CURSOR CURSOR FOR

SELECT a.[permlink]
      ,a.[author]
      ,JSON_VALUE(a.[json_metadata],'$.type')
      ,a.[created]utopian_authors_mar_2018_week4
FROM [SQL.STEEMSQL.COM].[DBSteem].[dbo].[Comments] a WITH (NOLOCK)
WHERE 

a.[created] BETWEEN '03/23/2018 00:00:00' AND '03/29/2018 23:59:59' 

and
a.[parent_author] = ''
and
a.[category] = 'utopian-io' -- 199
order by [created] asc
OPEN EMP_CURSOR
FETCH NEXT FROM EMP_CURSOR
INTO @postlink, @author, @tags, @created

WHILE (@@FETCH_STATUS = 0)
BEGIN

Insert into utopian_authors_mar_2018_week4
SELECT @postlink, @author, @tags, @created, NULL, NULL  


    FETCH NEXT FROM EMP_CURSOR
    INTO @postlink, @author, @tags, @created
END

CLOSE EMP_CURSOR
DEALLOCATE EMP_CURSOR

SET NOCOUNT OFF

----------------------------------------------
-- MAIN INSERT COMPLETE
----------------------------------------------

delete from [dbo].[utopian_authors_mar_2018_week4] where [contributiontype] is NULL


-- CHECK AND UPDATE IF APPROVED (VOTED ON BY @UTOPIAN-IO)
UPDATE [dbo].[utopian_authors_mar_2018_week4]
set [poststatus] = 'APPROVED'
where permlink in (select permlink COLLATE SQL_Latin1_General_CP1_CS_AS from [SQL.STEEMSQL.COM].[DBSteem].[dbo].[TxVotes] v  WITH (NOLOCK)
where voter = 'utopian-io')


-- 'Not approved' To the Rest of the entries
UPDATE [dbo].[utopian_authors_mar_2018_week4]
set [poststatus] = 'NO VOTE'
WHERE [poststatus] IS NULL


-- CHECK THE NUMBERS
select * from [dbo].[utopian_authors_mar_2018_week4] -- 1077 (1351)
select * from [dbo].[utopian_authors_mar_2018_week4] where poststatus = 'APPROVED'  -- 382 (555)
select * from [dbo].[utopian_authors_mar_2018_week4] where poststatus <> 'APPROVED' -- 695 (796)


-- RAW DATA FOR EXCEL
select contributiontype, poststatus from [dbo].[utopian_authors_mar_2018_week4]
where contributiontype is not NULL
order by [contributiontype] asc


-- COUNT WHEN APPROVED
select contributiontype, count(contributiontype) from [dbo].[utopian_authors_mar_2018_week4]
where poststatus = 'APPROVED'
group by [contributiontype]
order by [contributiontype] asc


This data was compiled on the 4th April 2018 at 9:30am (UCT)



Thanks

Asher @abh12345



Posted on Utopian.io - Rewarding Open Source Contributors

Sort:  

Thank you for the contribution. It has been approved.

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

Due to the new changes in utopian.io not all posts will now get into the voting round. Therefore it might not be the best approach to look for posts upvoted by @utopian-io.

You can see if a post got approved in the json_metadata of each post.

Approved post:

image.png

Rejected post:

image.png

But still good analysis!!

These changes aren't active yet. ETA is "April 14th or earlier".
But you're right, future analyses will have to include the possibility to get an approval without a vote.

ah ok thanks didn't notice that

Thanks for the information @wil1liam.

I do need to switch to the json_metadata at some point for sure, but hopefully the vote by utopian is still an accurate gauge of 'approval'.

Cheers!

I think it will stay like that for a while. But maybe as utopian.io gets more and more members a fewer percentage of all submissions will receive an upvote

I'm looking forward to seeing this analysis in the future :)

Rule changes, and other factors including the fall in the price of STEEM are putting pressure on both contribution totals and approval percentages.

I think the rules play quite a big role in this. They have been a lot of strict rules by Utopian in the last few weeks and these has caused some controversy. Visibility, suggestions and design categories have really felt these changes.

Indeed they have. I blamed them for the cut in approvals last week, but this week (without further changes that I'm aware of), there has been further reductions and so i'm blaming STEEM :)

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

Achievements

  • WOW WOW WOW People loved what you did here. GREAT JOB!
  • 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

This is a good contribution on data analysis.
Good job Mr.Asher.
👍

Thank you! :D

You are welcome.

Very strong analysis and really fascinating study
We hope that happens

Thank you :D

Thanks for sharing helpful post.
I appreciate your analysis

Thank you very much :)

Approvals really plummeted. Stricter policy or rating method? Utopian still a great thing for steem. You've seen the steem moon run, are we in for the run or someone playing tricks on us? :)

wooww.
your work is very good @asher.
keep contributing in utopian-io hope you alwasy succeed.

Wow, some of those categories are so dead. I wonder how often they evaluate adding or removing a category.

It is always more interesting when the factors to be and the numbers you have don’t always create a 100% “that is the cause” of things. Stricter restraints along with current price slums and warmer seasons ahead. Does make me wonder if we will keep seeing a decline for next couple of months. More so over, how will they react if this new possible new trend continues of less submissions.

Have they ever had a history of just sitting at 100% SP?

Coin Marketplace

STEEM 0.24
TRX 0.25
JST 0.039
BTC 96247.25
ETH 3349.36
USDT 1.00
SBD 3.28