utopian-io - Contribution 'Approved/Rejected' Analysis - 8th - 14th November 2017

This is an analysis of the Contribution types, and approval/rejection numbers for 8th - 14th November 2017 inclusive.

Sections

General / Assumptions

1. Contributions Summary

2. Contributions by Type

3. Weeks' Summary Analysis

4. History Comparison 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.7 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.

October 2017
November 2017 - Week 1

I feel these reports should be released weekly (as a Standard Report), and also as monthly summary. 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

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 second week of November 2017 - 8th - 14th inclusive, the SteemSQL DataBase holds a total of 655 potential contributions to utopian-io.

494 of these contributions were approved, a total of 75%. This approval percentage is up 9% on the previous week, and their were 256 more contributions approved in total, a 52% increase.

---

The Contributions can be any one of the following types:

---

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

2 Contributions by Type

In this section we take a look a few of the individual contribution types and they are presented using a pie chart.

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

---

Development- Approvals / Rejections

---

Graphics - Approvals / Rejections

---

Translations - Approvals / Rejections

---

All contribution types

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

3. Weeks' Summary Analysis

From the data above, the following evaluations can be made.

• Three quarters of all submissions for this week in question were approved, that is an excellent figure and very encouraging for all contributors to utopian.io.

• A 100% successful approval rate for 'Video contributions' this week - Videos Tutorials proving very popular and shown to be of a very good quality based on this figure.

• An excellent result also for 'Development' contributions with 87 approved, a 92% success rate.

• Graphical, Tutorial, Idea, and Translation contributions all obtained an approval rate better than 2 our of every 3 submissions.

• Some of the lower approval percentage rates included Copy-writing (40%) and Documentation (50%).

---

4. History Comparison Analysis

As the weeks pass and the data grows, it is possible to learn more about the developing trends in the utopian-io ecosystem.

We can already see that the number of contributions is rising impressively.

.	OCTOBER	NOV WK 1	NOV WK 2
Total	740	360	655
Approved	524	238	494

In the first two weeks of November, submissions and approvals have already exceeded the totals for the month of October. And, the total approvals for the 2nd week of November are over twice as many as that of the first week of November.

A particularly interesting Contribution type as far as growth looks to be that of 'Development'. With 42 approved contributions for the month of October, the first 2 weeks of November have seen an approval total of 114. This is already almost 3 times the total of the previous month, and the acceptance rate for this type is almost 90% November thus far.

Other Contribution types such as 'Ideas' and 'Bug-hunting' have also surpassed the previous months totals already, and I forecast the total number of 'Ideas' for the month of November to total 900/1000.

One Contribution type that seems to be lacking growth is 'Social'. In October we saw 17 approval from 29 submissions, and for the November 1st - 14th, the numbers show only 9 submissions with 5 approvals. On this data, I project that we could see less 'Social' Contributions for the month of November.

In summary, utopian-io is seeing rapid growth in almost all Contribution areas. The number of votes (approved submissions) cast this month could well exceed 2000, which would be almost 4 times more than the month of October.

The report for the 3rd week of November will be completed over the next few days.

---

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 (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.

---

In addition to the tools, I would like to provide some SQL text which extracts the Data i have used for this report. This is the Cursor that iterates through the the 'Comments' table to extract the necessary data. This data is then stored in my own RDB, where further work is done to tidy, update, and prepare for export to MS Excel where I create the tables charts displayed in the report.

Apologies for the code dump below - please still consider scrolling down to show support for the considerable time and effort I put into making these reports as professional as I can, thanks!

---

• MAIN INSERT START
• Categories 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]
,a.[json_metadata]
,a.[created]
FROM [SQL.STEEMSQL.COM].[DBSteem].[dbo].[Comments] a WITH (NOLOCK)
WHERE
--author = 'zajkowskimarcin'
--and
--a.[created]BETWEEN '10/01/2017 00:00:00' AND '10/31/2017 23:59:59' -- OCTOBER 2017
--a.[created] BETWEEN '11/01/2017 00:00:00' AND '11/07/2017 23:59:59' -- WEEK 1: NOVEMBER
a.[created] BETWEEN '11/08/2017 00:00:00' AND '11/14/2017 23:59:59' -- WEEK 2: NOVEMBER
--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

If LEFT(@tags, 77) = '{"community":"utopian","app":"utopian/1.0.0","format":"markdown","repository"'
BEGIN
print '--------UTOPIAN START--------'

set @typeStartCount = PATINDEX('%' + @typeStarter + '%', @tags)+17
set @typeEndCount = PATINDEX('%' + @typeEnder + '%', @tags)-@typeStartCount-2

set @contributionType = SUBSTRING(@tags,@typeStartCount,@typeEndCount)
set @contributionType = REPLACE(@contributionType,'"','')

print '---UTOPIAN END ----'
END

If LEFT(@tags, 75) = '{"community":"utopian","app":"steemit/0.1","format":"markdown","repository"'
BEGIN
print '--------STEEMIT START--------'

set @typeStartCount = PATINDEX('%' + @typeStarter + '%', @tags)+17
set @typeEndCount = PATINDEX('%' + @typeEnder + '%', @tags)-@typeStartCount-2

set @contributionType = SUBSTRING(@tags,@typeStartCount,@typeEndCount)
set @contributionType = REPLACE(@contributionType,'"','')

print '---STEEMIT END ----'
END

Insert into utopian_authors_nov_2017_week2
SELECT @postlink, @author, @contributionType, @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

---

_{This data was compiled on the 26th November at 6:00 pm 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

---