utopian-io - Category Tag Analysis
This is a look at the most popular tags used within each contribution category.
Sections
Category contribution totals
The Ten most popular tags in each contribution category
Analysis Summary
Tools used to gather data and compile report
Previous reports of this type can be found here:
4th December 2017 - utopian-io - Category Tag Analysis
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
1. Category contribution totals
From the inception of utopian-io we have seen 7971 contributions across the 13 main contribution types. These types are listed below and displayed as a pie chart.
| Contribution Type | Total |
|---|---|
| ideas | 1667 |
| translations | 1397 |
| tutorials | 1372 |
| graphics | 895 |
| bug-hunting | 809 |
| development | 551 |
| video-tutorials | 533 |
| blog | 320 |
| analysis | 172 |
| social | 103 |
| documentation | 100 |
| copywriting | 40 |
| sub-projects | 12 |
As we know, each contribution is allowed 4 tags, as the first tag is reserved for 'utopian-io'.
The purpose of this report is to detail which are the most popular 'additional' tags used for each contribution category, and this is displayed in the next section.
These additional tags will also be analysed against previous data collected in the summary section of the report.
2. The Ten most popular tags in each contribution category
The tables are ordered in contribution type order - (Tag, Total number of Tags)
The dates show from the start of the project to 4th December, and then from the start of the project to 18th December.
Analysis
| Tag | 4th Dec | Tag | 18th Dec |
|---|---|---|---|
| analysis | 72 | analysis | 106 |
| bisteemit | 71 | bisteemit | 95 |
| data | 37 | data | 57 |
| contribution | 31 | steemit | 57 |
| steemit | 31 | steem | 41 |
| steem | 19 | contribution | 39 |
| analytics | 9 | analytics | 14 |
| stats | 7 | stats | 12 |
| sndbox | 6 | contributors | 11 |
| contributors | 5 | cryptocurrency | 9 |
Analysis relating to 'sndbox' have fallen out of the top 10, while 'cryptocurrency' is a new entry. This is perhaps to the recent surge in the price of Bitcoin and other Alt. coins.
Blog
| Tag | 4th Dec | Tag | 18th Dec |
|---|---|---|---|
| blog | 49 | blog | 90 |
| steemit | 40 | opensource | 60 |
| utopian-io | 38 | utopian-io | 58 |
| opensource | 26 | steemit | 50 |
| steem | 23 | steem | 28 |
| utopian | 17 | spanish | 22 |
| spanish | 16 | indonesia | 21 |
| indonesia | 13 | technology | 21 |
| open-source | 10 | utopian | 19 |
| community | 9 | open-source | 15 |
Blogs making reference to 'technology' have increased and enter the top 10.
Bug-hunting
| Tag | 4th Dec | Tag | 18th Dec |
|---|---|---|---|
| bug | 318 | bug | 416 |
| steemit | 150 | steemit | 180 |
| utopian-io | 102 | utopian-io | 136 |
| busy | 100 | busy | 115 |
| opensource | 73 | opensource | 92 |
| esteem | 57 | esteem | 73 |
| airhawk-project | 50 | airhawk-project | 65 |
| steem | 48 | bugs | 52 |
| bugs | 44 | nigeria | 46 |
| contribution | 38 | contribution | 44 |
The top 7 tags remain the same for the 'Bug-hunting' category. 'nigeria' is a new entry, while 'steem' falls out of the top 10
Copywriting
| Tag | 4th Dec | Tag | 18th Dec |
|---|---|---|---|
| copywriting | 14 | utopian | 12 |
| utopian | 12 | utopian-help | 11 |
| utopian-io | 8 | copywriting | 9 |
| utopian-help | 5 | utopian-io | 8 |
| blog | 3 | art | 3 |
| steem | 3 | blog | 3 |
| business | 2 | steem | 3 |
| marketing | 2 | steemit | 3 |
| rules | 2 | business | 2 |
| sndbox | 2 | marketing | 2 |
Copywriting relating to 'utopian' has grown as this is now the most popular tag. 'art' is a new tag which has entered into the top 10.
Development
| Tag | 4th Dec | Tag | 18th Dec |
|---|---|---|---|
| steemdev | 122 | steemdev | 166 |
| programming | 102 | programming | 134 |
| opensource | 76 | opensource | 123 |
| steem | 43 | steem | 58 |
| steemit | 35 | dev | 53 |
| development | 34 | development | 48 |
| busy | 29 | steemit | 45 |
| dev | 29 | javascript | 40 |
| utopian-io | 22 | news | 34 |
| condenser | 21 | github | 33 |
The tags 'javascript', 'news', and 'github', have entered into the top 10 tags used for 'Development' contributions.
Documentation
| Tag | 4th Dec | Tag | 18th Dec |
|---|---|---|---|
| steemdev | 16 | documentation | 23 |
| steemit | 16 | utopian-io | 20 |
| indonesia | 14 | steemit | 18 |
| utopian-io | 14 | steemdev | 15 |
| documentation | 9 | indonesia | 13 |
| programming | 8 | utopian | 10 |
| opensource | 7 | programming | 9 |
| utopian | 7 | wordpress | 8 |
| busy | 6 | mapsters | 7 |
| github | 4 | busy | 6 |
An increasing number of contributions relating to 'wordpress', and 'mapsters' have seen these tags enter into the top 10.
Graphics
| Tag | 4th Dec | Tag | 18th Dec |
|---|---|---|---|
| design | 304 | design | 605 |
| graphics | 155 | graphics | 347 |
| opensource | 142 | utopian-io | 289 |
| utopian-io | 142 | art | 243 |
| art | 119 | logo | 160 |
| utopiangif | 115 | opensource | 143 |
| logo | 70 | utopiangif | 115 |
| creative | 62 | creativity | 97 |
| contest | 41 | creative | 82 |
| steemit | 35 | graphic | 63 |
The top 10 for the 'Graphics' contribution category remains mostly unchanged following no new major drivers since the 'utopiangif' contest took place.
Ideas
| Tag | 4th Dec | Tag | 18th Dec |
|---|---|---|---|
| steemit | 485 | steemit | 634 |
| utopian-io | 276 | utopian-io | 380 |
| suggestion | 194 | suggestion | 309 |
| idea | 171 | nigeria | 209 |
| steem | 153 | steem | 206 |
| opensource | 145 | idea | 185 |
| nigeria | 143 | opensource | 175 |
| steemdev | 107 | steemdev | 142 |
| ideas | 88 | busy | 117 |
| indonesia | 84 | contribution | 104 |
'Suggestions' with the tag 'nigeria' have continued to increase as this tag has moved to 4th in the rankings. 'busy' also enters the top 10 most used tags.
Social
| Tag | 4th Dec | Tag | 18th Dec |
|---|---|---|---|
| steemit | 29 | steemit | 44 |
| utopian-io | 20 | promo-steem | 28 |
| promo-steem | 17 | utopian-io | 27 |
| opensource | 14 | visibility | 18 |
| 11 | marketing | 17 | |
| visibility | 11 | 14 | |
| marketing | 10 | nigeria | 13 |
| nigeria | 10 | opensource | 9 |
| steemdev | 7 | sndbox | 9 |
| busy | 6 | steem | 9 |
Contributions for the 'Social' category also remain static at the top, but 'sndbox' , and 'steem' have replaced 'steemdev' and 'busy' in the top 10.
Sub-projects
| Tag | 4th Dec | Tag | 18th Dec |
|---|---|---|---|
| programming | 1 | utopian-io | 4 |
| opensource | 1 | steemit | 3 |
| java | 1 | food | 1 |
| gaming | 1 | 1 | |
| games | 1 | design | 1 |
| game | 1 | creative | 1 |
| contest | 1 | contribution | 1 |
| condenser | 1 | contest | 1 |
| busy | 1 | condenser | 1 |
| blog | 1 | busy | 1 |
Sub-projects related to 'utopian-io' are a new entry at number 1, and 'steemit' is also a new entry in 2nd place. This a clear indicator of where the current project focus lies.
Translations
| Tag | 4th Dec | Tag | 18th Dec |
|---|---|---|---|
| translation | 373 | translation | 944 |
| utopian-io | 172 | utopian-io | 432 |
| opensource | 120 | opensource | 306 |
| blog | 84 | blog | 194 |
| contribution | 80 | indonesia | 188 |
| indonesia | 58 | contribution | 183 |
| busy | 56 | translate | 171 |
| cn | 46 | tr | 157 |
| steemit | 45 | cn | 88 |
| utopian | 43 | utopian | 74 |
'indonesia' has moved further away from 'china', now with 100 more Translation contributions compared with just 12 two weeks ago.
Tutorials
| Tag | 4th Dec | Tag | 18th Dec |
|---|---|---|---|
| tutorial | 338 | tutorial | 703 |
| tr | 157 | utopian-io | 313 |
| utopian-io | 127 | tr | 284 |
| tutorials | 95 | tutorials | 207 |
| steemit | 80 | opensource | 145 |
| indonesia | 67 | indonesia | 144 |
| wordpress | 66 | steemit | 137 |
| opensource | 62 | wordpress | 118 |
| howto | 46 | howto | 86 |
| contribution | 40 | programming | 86 |
'Tutorials' top 10 tags remains mostly unchanged, however there is a new entry for 'programming'.
Video-tutorials
| Tag | 4th Dec | Tag | 18th Dec |
|---|---|---|---|
| tutorial | 135 | tutorial | 273 |
| tr | 80 | tr | 220 |
| utopian-io | 65 | utopian-io | 162 |
| video | 21 | video | 71 |
| opensource | 20 | opensource | 46 |
| videotutorial | 20 | videotutorial | 37 |
| wordpress | 16 | gimp | 36 |
| steemit | 13 | steemit | 30 |
| blog | 12 | blog | 23 |
| kodi | 12 | project | 19 |
'gimp' is a new entry for 'Video Tutorials', while 'kodi' falls from the top 10.
3. Summary
We can see that 'utopian-io' is being added as an additional tag. The user interface still allows this tag to be entered even though it is the default first tag.
An appearance of 'programming' as a tag in Tutorials is interesting. Perhaps this is a sign of an increase in 'help the helper' as the platform matures and relationships are made.
'indonesia' has shot away from 'china' in the 'Translations' category as translations tagged 'indonesia' have grown over 300% since the last set of data was collected two weeks ago. This shows strong growth in this community and the number of contributors for @utopian-io.
'nigeria' is popping up as a tag now in multiple Categories - is this a sign of the growth in open source, and contributions to open source in Africa?
The tags tied to contributions can be a useful way to extract what's Contributions have long term impact and can also be used to spot new trends in contribution types.
4. Tools used to gather this report
The data is sourced from SteemSQL - A publicly available SQL database with all the blockchain data held with (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.
And extract of code for 'Analysis' Category type:
The charts used to present the data were produced using MS Excel.
This data was compiled on the 18th December 2017 at 2:30 pm CET
Thanks
Asher @abh12345
Posted on Utopian.io - Rewarding Open Source Contributors
Thank you for the contribution. It has been approved.
You can contact us on Discord.
[utopian-moderator]
Thank you!
Nice work. Good to see the SQL code in there too! I'm getting to the point where I start reading other people's SQL to pick up tips! I hadn't seen .type before - that's useful.
Oh, arcange told me to use depth = 0 instead of parent_author = ''
I guess it's faster / more efficient.
ahh yes, and i read that comment too.
He said their was an index on that field, thanks for reminding me about it!
wonderful your content. @abh12345
Thank you :)
Great SQL code. I interested to learn this type of coding.
Thanks. There are a lot of examples on the internet :)
Sangat luar biasa.
Amazing.
Informasi yang bagus.
Salam kenal
Thanks!
Oke
Nice one @abh12345.
Thanks :)
Congratulations! This post has been upvoted from the communal account, @minnowsupport, by abh12345 from the Minnow Support Project. It's a witness project run by aggroed, ausbitbank, teamsteem, theprophet0, someguy123, neoxian, followbtcnews/crimsonclad, and netuoso. The goal is to help Steemit grow by supporting Minnows and creating a social network. Please find us in the Peace, Abundance, and Liberty Network (PALnet) Discord Channel. It's a completely public and open space to all members of the Steemit community who voluntarily choose to be there.
If you would like to delegate to the Minnow Support Project you can do so by clicking on the following links: 50SP, 100SP, 250SP, 500SP, 1000SP, 5000SP. Be sure to leave at least 50SP undelegated on your account.
Nice post...
Thanks!
thanks for sharing the experience you had when first starting out. i will keep that in mind for any future comments i might be making. thanks for preventing new steemians from making those mistakes :) by the way i like what your doing here on steem, you keep it real, i can appreciate that for sure :)
thanks for sharing your experience :) ..
same comment as my other blog! :D