This is an analysis of the Contribution types, and approval/rejection numbers for the 23rd - 29th March 2018 inclusive.
Contents
General / Assumptions
Contributions Summary
Contributions by Type
All contribution Types
Summary Analysis
Tools used to gather data and compile report
General
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
'Rejected' contributions have not received a vote from
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.
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:
Note: 'Translation' contributions are currently on hold.
This weeks data, split into Contribution types is shown in the pie chart below:
'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.
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.
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.
'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.
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.
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
Posted on Utopian.io - Rewarding Open Source Contributors