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.
- Scope of Analysis
- Tools and Code
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.
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'
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"%'
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:
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
- Total number of the unique contributer from
- Total amount of payment under done to the contributers from
trcommunity: 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