@utopian-io - Contribution 'Approved/Rejected' Analysis - 30th March - 5th April 2018

This is an analysis of the Contribution types, and approval/rejection numbers for the 30th March - 5th April 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

---

---

General

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

Currently, @utopian.io holds 3.6 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 - Week 4

---

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, 30th March - 5th April 2018 inclusive, the SteemSQL DataBase holds a total of 881 potential contributions to utopian-io. This is 196 fewer contributions than the previous weeks' total which was 1077.

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

The approval percentage of 39% is a 4% rise from the previous week.

---

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

Note: 'Translation' contributions are currently on hold.

---

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

'Ideas/Suggestions' again form the largest number of contributions at 35% this week, and has maintained being the source of around a third of all contributions. There are 62 fewer contributions to this category than the previous week.

'Bug-hunting' retains second position with 28% of all contributions, a rise of 3% on the previous week.

'Graphics', in 3rd spot last week, holds this place again this week with 12% of all contributions and has 76 fewer contributions compared to the previous week's analysis.

These three largest categories account for three-quarters (75%) 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.

---

'Graphics' - Approvals / Rejections

The 'Graphics' category has consistently been one of the top 3 contributed categories in recent months but despite holding 3rd spot this week, the submission total for this category has fallen 70% on the previous week.

As we can see from the chart above, there has been a consistent decline in the number of contributions to this category since the highs in late January, and this week has seen the biggest decline yet in percentage terms, from the previous week.

Not only have the contributions numbers fallen, the approval percentage for the category has also declined in recent weeks and now sits at 28% - marginally better than 1 in every 4 submissions gaining approval.

'Analysis' - Approvals / Rejections

The 'Analysis' category is one of the few that has received growth in both submissions totals and approval percentages this week.

The number of contributions has almost doubled, and the approval percentage is the joint highest figure in the past 10 weeks.

'Development' - Approvals / Rejections

The 'Development' category is consistently the best performer in terms of submission approval percentages and and against scores better than 4 out or every 5 contributions receiving approval.

However, the category has not been able to escape the falling trend in submissions and 84 is the lowest total of 'Development' contributions submitted in 2018.

---

3. All contribution types

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

'Blog' contributions scored its highest approval rate in months with 31% - The 4 approvals from 13 this past week equal the total the number of approvals for the previous 3 weeks combined.

'Bug-hunting' gained 2% on last weeks approval percentage which stands at 38%. 32 few contributions were made to the category than in the previous week's analysis.

'Tutorials' and 'Video Tutorials' showed a combined approval average of 47% (1% higher than the previous week) and received a combined total of 13 fewer contributions than the previous week.

'Social' again had 2 approvals this week, but the contribution total fell 9 from 16 to 7.

'Ideas/Suggestions' achieved a 30% approval percentage, an 8% rise on the previous week.

---

4. Summary Analysis

This week, the number of contributions has fallen once again. This marks another year low in totals, both submitted and approved.

As no major rule changes have taken place over the past few weeks, the continued fall in submission numbers can seemingly only relate to a lack of interest / reduction in the price of STEEM - the payment currency for contributions.

Over the past week there has been some hope that the price of the token is stabilizing, and if this is the case we could expect the contribution totals to level off at around 800 - 100 for the coming weeks.

As well as the fall in submissions, the approval percentages have also suffered in recent weeks, but this week there has been a small rise in the success rate of approved contributions.

This is one of the few positives to take from this weeks analysis, and hold onto this we shall!

---

Summary

Another slide in contribution totals but a small increase in the overall approval percentage.

'Translations' is still on hold.

The fall in the price of STEEM is seemingly the main reason for the slide in contribution totals

'Development' continues to reign supreme at the head of the submission approval percentages.

---

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_april_2018_week1
FROM [SQL.STEEMSQL.COM].[DBSteem].[dbo].[Comments] a WITH (NOLOCK)
WHERE 

a.[created] BETWEEN '03/30/2018 00:00:00' AND '04/05/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_april_2018_week1
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_april_2018_week1] where [contributiontype] is NULL


-- CHECK AND UPDATE IF APPROVED (VOTED ON BY @UTOPIAN-IO)
UPDATE [dbo].[utopian_authors_april_2018_week1]
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_april_2018_week1]
set [poststatus] = 'NO VOTE'
WHERE [poststatus] IS NULL


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


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


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

---

_{This data was compiled on the 10th April 2018 at 10:30am (UCT)}

---

Thanks

Asher @abh12345

---

Posted on Utopian.io - Rewarding Open Source Contributors

---