Turkish Community on Utopian.io in December 2018

in #utopian-io2 years ago (edited)

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:


image.png

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:


image.png

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:


image.png

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:


image.png

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

Sort:  

Your contribution cannot be approved because it is not as informative as other contributions. See the Utopian Rules. Contributions need to be informative and descriptive in order to help readers and developers understand them.

Dear @alfanerd, your contribution is lacking reference data from a larger time scale. There is data from around 5 months available, but you show only a snapshot of one month. There are a few typos but also inconsistencies: the title and the text says "Dec. 2018" which is in 10 months, the "scope of the analysis" and the queries section contain January 2018. Additionally, I think that your approach only covers a fraction of the tr community. Since tags have to be related to the contribution by the utopian rules, language tags are primarily only used on translations and non-English content (tutorials/video-tutorials at the time with was allowed to be non-English). An option would be to also look into the location information on the user profiles, but this is also very error prone since users can put any text there.

You can contact us on Discord.
[utopian-moderator]

That was fast! Thank you for your comment. I saw my mistakes once again, I will work on the issues you mention and hoppefully produce more stable resuslts.