This is an analysis of the Contribution types, and approval/rejection numbers for the 9th - 15th 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
@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
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, 9th - 15th March 2018 inclusive, the SteemSQL DataBase holds a total of 1645 potential contributions to utopian-io. This is 1233 less contributions than the previous weeks' total which was 2878.
768 of these contributions have been approved, ** 1164 less** than the previous weeks' total of 1932.
The approval percentage of 47% is a 20% fall from the previous week.
The Contributions offered can be any one of the following types:
Note: 'Translation' contributions have been paused for the whole week of this analysis and are not present in the results.
This weeks data, split into Contribution types is shown in the pie chart below:
This week, we have a new most contributed category due to the pausing of 'Translation' contributions.
'Ideas/Suggestions' has made up 33% of all the contributions this past week with 547.
'Social' contributions are in second with 18%, and Graphics in third place with 15% of all the contributions submitted.
The three largest categories submitted to account for over half 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.
Suggestions(Ideas)- Approvals / Rejections
This category recieved the largest number of contributions this week.
As we can see though from the chart below, the approval % of the category is not great, with less than a 3rd of contributions submitted being approved.
'Suggestions', whilst being a popular 'entry' category for new contributors to utopian-io due to the reduced requirement for detailed technical knowledge, continues to as one of lowest contribution categories with regards to accepted submissions.
Social - Approvals / Rejections
The 'Social' category has been the 2nd most contributed to this week.
And as last week, almost 300 contributions were submitted for approval.
This week though, this approval rate has fallen 11%, and previously it was noted:
The analyst is surprised at this level of growth and wonders what the underlying factors are. @utopian-io may well take a closer look at the recent approvals / rules for this category as this level of growth seems unsustainable going forward.
The growth of previous weeks has stopped dead this week and this is viewed as a good sign by the Analyst.
It has been noted in the past that when a category undergoes rapid growth, there is usually a focus on the category by utopian-io who then investigate as to why this is happening, and then decide to adjust the rules for this category in attempt to maintain quality, and reduce submissions from contributors who are looking to jump between categories 'for the money', and not for the desire to create quality work in this area.
Graphics - Approvals / Rejections
The third most contributed to category this week is 'Graphics' with a 50% approval rate.
As the below chart suggest, this isn't down to the growth of the category and is more likely due to the reduction of submissions in other categories.
The contribution totals peaked at the end of January and early February, and the past two weeks have produced the lowest number of contributions in 2018.
The approval rate of 'Graphics' submissions has also dropped on average since the beginning of the year.
In the first 4 weeks of January, the approval rate averaged at 60%, and in the last 4 weeks has averaged at 49.5%.
Despite the falling number contributions in the category, the approval rate has not improved, which has been the case with other categories in the past.
This suggests that the moderation team has a good understanding of the level of quality required, and are not going to lower these standards 'to make the numbers look better'.
3. All contribution types
The following table shows all types and totals of contributions submitted, with their approval % in the end column.
As is becoming standard in the realm of utopian-io, 'Development' contributions again hold the number 1 accepted contribution / submission ratio. 90 out of 110 contributions were approved, 4 out of every 5.
'Analysis' contributions continues to perform reasonably well, without standing out. a 67% approval rate is just 2% lower than last week, but there were 5 more contributions to evaluate this time around.
Tutorials and Video Tutorials, gained respective approval rates of 44% and 52% this week. Previously, 'Tutorials' scored a 16% larger approval rate than 'Video Tutorials' and so there has been a noticeable reversal here his week.
4. Summary Analysis
As the life of the project extends, it is possible to learn more about the developing trends in the utopian-io ecosystem.
This week, the number of contributions (and therefore approvals) has dropped significantly. This is largely due to the pausing of 'Translation' contributions.
As we can see from the chart above, this category recently accounted for a large portion of the total contributions with the previous 4 weeks averaging at 1156.
If this average was to be added onto this weeks' total contributions, the number would be 2801, just 77 short of the previous weeks total submissions.
Perhaps more surprising this week, is that the contribution approval percentage has also taken a large dip when compared with recent weeks.
47% is the lowest approval rate since mid December 2017 and earlier and 20% lower than the previous two weeks.
Such a noticeable decline in the approval percentage could partly be explained by the absence of 'Translation' contributions, but it also the case that 'Analysis', 'Bug-Hunting', 'Graphics', 'Suggestions', 'Social', 'Tutorials', and 'Development' contributions have also fallen in approval percentage this week.
Only 'Video-Tutorials' in the group of popular contribution categories has seen an increase in submissions approved this week.
Summary
A fall in both contributions and approval % this week.
'Translations' are on pause, explaining a large part of the above, but many other categories have also fallen short in their figures also.
Previously:
The analyst expects to see a move into other focus areas from the 'Translation' contributors as they attempt to continue to contribute, and profit from doing so.
The gap created by the lack of 'Translation' contributions has not been filled by any other category, as was thought likely to be the case.
In summary, a tough week for utopian-io contributors with the absence of a key contribution category and no let up on the rules enforced in other categories.
5. Tools used to gather this data and compile report
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_week2
FROM [SQL.STEEMSQL.COM].[DBSteem].[dbo].[Comments] a WITH (NOLOCK)
WHERE
--author = 'zajkowskimarcin'
--and
--a.[created]BETWEEN '12/01/2017 00:00:00' AND '12/07/2017 23:59:59' -- DEC 2017
--a.[created] BETWEEN '12/08/2017 00:00:00' AND '12/14/2017 23:59:59' -- WEEK 2: NOVEMBER
a.[created] BETWEEN '03/09/2018 00:00:00' AND '03/15/2018 23:59:59' -- WEEK 3: DEC
--a.[created] BETWEEN '11/15/2017 00:00:00' AND '11/21/2017 23:59:59' -- WEEK 3: NOVEMBER
--a.[created] BETWEEN '11/22/2017 00:00:00' AND '11/30/2017 23:59:59' -- WEEK 4: NOVEMBER
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_week2
SELECT @postlink, @author, @tags, @created, NULL, NULL
--Insert into utopian_authors
--SELECT @postlink, @author,@contributionType, value
--FROM STRING_SPLIT(@newtags, ',')
--WHERE RTRIM(value) <> '';
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_week2] where [contributiontype] is NULL
-- CHECK AND UPDATE IF APPROVED (VOTED ON BY @UTOPIAN-IO)
UPDATE [dbo].[utopian_authors_mar_2018_week2]
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_week2]
set [poststatus] = 'NO VOTE'
WHERE [poststatus] IS NULL
-- CHECK THE NUMBERS
select * from [dbo].[utopian_authors_mar_2018_week2] -- 1645 (2878)
select * from [dbo].[utopian_authors_mar_2018_week2] where poststatus = 'APPROVED' -- 768 (1932)
select * from [dbo].[utopian_authors_mar_2018_week2] where poststatus <> 'APPROVED' -- 877 (946)
-- RAW DATA FOR EXCEL
select contributiontype, poststatus from [dbo].[utopian_authors_mar_2018_week2]
where contributiontype is not NULL
order by [contributiontype] asc
-- COUNT WHEN APPROVED
select contributiontype, count(contributiontype) from [dbo].[utopian_authors_mar_2018_week2]
where poststatus = 'APPROVED'
group by [contributiontype]
order by [contributiontype] asc
The charts used to present the data were produced using MS Excel.
This data was compiled on the 20th March 2018 at 11am (UCT)
I am part of a Steemit Business Intelligence community. We all post under the tag #blockchainbi. If you have analysis you would like to be carried out on utopian-io/Steem data, please do contact me or any of the #blockchainbi team and we will do our best to help you.
Thanks
Asher @abh12345
Posted on Utopian.io - Rewarding Open Source Contributors