Turkish Community on Utopian.io in December 2018

Details

The goal of this analysis is to show the activity of Turkish users on Utopian.io in December 2012. The analysis is intended to see the overall post made under the tr and the utopian-io tags. To do so I focused on the posts under utopian-io category (the first tag used in the posts) with the trtag and to determine the approved contributions I looked for uptove from @utoian-io. Those analyses are based from "tags", "authors" and "payouts" for each individual posts.

Outline

1. Scope of Analysis
2. Tools and Code
3. Results
4. Summary

1. Scope of Analysis

Date of the analysis is 10.02.2018 and timeframe of the analyzed data is between from 01.01.2018 to 01.02.2018.

2. Tools

The data to be analyzed is taken from SteemSQL - A publicly available SQL database – by using DBeaver. And charts and graphics are produced by using MS Excel.

I used the following codes to get the information

 Select title, author, category, total_payout_value, curator_payout_value, children, json_metadata, active_votes
FROM comments (NOLOCK)
 where   
 created >= ('2018-01-01T00:00:00.000Z')
 and created < ('2018-02-01T00:00:00.000Z')
 and Depth = 0
 and json_metadata like '%"tr"%'
 and category = 'utopian-io'

And

Select title, author, category, total_payout_value, curator_payout_value, children, json_metadata, active_votes, url
FROM comments (NOLOCK)
 where   
 created >= ('2018-01-01T00:00:00.000Z')
 and created < ('2018-02-01T00:00:00.000Z')
 and Depth = 0
 and json_metadata like '%"tr"%'
 and category = 'utopian-io'
 and active_votes like '%"utopian-io"%'

3. Results

In December 2018, 317 authors have crated 2271 cobtributions under utopian-io category with trtag. 1443 of those contributions were accepted and that means more than 50% of the contributions are approved precise % can be seen in the graphic down below:

Total payout number of December is 35936,918 and it is distributed like 25221,888 (both SBD and SP) for authors' payout and for 10715,03 (SP) for curator's payout. When we look at the payout distribution by contributions type, we have the following graph:

Translation category was the first choice of the authors, followed by video tutorials and tutorials in the first month of the year. We can see the all contributions' distribution among the types here:

193 unique authors' countribuions from trcomunity approved by utopian.io in December 2018. And the top 15 contributer of the month's are given below with their post number:

4. Summary

This analysis shows us tr community done not a bad work, more than half of it's contributions are approved in December. Yet some of the authors need to improve their work or understand the rules correctly. I will keep tracking the statistics of the community in the following months.

Before ending my analysis, let me repeat some numbers again:

• Total number of apporved contributons made by trcommunity under utopian tag: 2271
• Total number of the unique contributer from tr community: 317
• Total amount of payment under done to the contributers from tr community: 35936,918 (25221,888 (both SBD and SP) for authors payout and 10715,03 (SP) for curator payout)

---

Posted on Utopian.io - Rewarding Open Source Contributors

---