utopian-io - Category Tag Analysis

in utopian-io •  7 years ago 

This is a look at the most popular tags used within each contribution category.

Sections

  1. Category contribution totals

  2. The Ten most popular tags in each contribution category

  3. Analysis Summary

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


t1.png


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 TypeTotal
ideas1667
translations1397
tutorials1372
graphics895
bug-hunting809
development551
video-tutorials533
blog320
analysis172
social103
documentation100
copywriting40
sub-projects12


image.png

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

Tag4th DecTag18th Dec
analysis72analysis106
bisteemit71bisteemit95
data37data57
contribution31steemit57
steemit31steem41
steem19contribution39
analytics9analytics14
stats7stats12
sndbox6contributors11
contributors5cryptocurrency9

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

Tag4th DecTag18th Dec
blog49blog90
steemit40opensource60
utopian-io38utopian-io58
opensource26steemit50
steem23steem28
utopian17spanish22
spanish16indonesia21
indonesia13technology21
open-source10utopian19
community9open-source15

Blogs making reference to 'technology' have increased and enter the top 10.


Bug-hunting

Tag4th DecTag18th Dec
bug318bug416
steemit150steemit180
utopian-io102utopian-io136
busy100busy115
opensource73opensource92
esteem57esteem73
airhawk-project50airhawk-project65
steem48bugs52
bugs44nigeria46
contribution38contribution44

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

Tag4th DecTag18th Dec
copywriting14utopian12
utopian12utopian-help11
utopian-io8copywriting9
utopian-help5utopian-io8
blog3art3
steem3blog3
business2steem3
marketing2steemit3
rules2business2
sndbox2marketing2

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

Tag4th DecTag18th Dec
steemdev122steemdev166
programming102programming134
opensource76opensource123
steem43steem58
steemit35dev53
development34development48
busy29steemit45
dev29javascript40
utopian-io22news34
condenser21github33

The tags 'javascript', 'news', and 'github', have entered into the top 10 tags used for 'Development' contributions.

Documentation

Tag4th DecTag18th Dec
steemdev16documentation23
steemit16utopian-io20
indonesia14steemit18
utopian-io14steemdev15
documentation9indonesia13
programming8utopian10
opensource7programming9
utopian7wordpress8
busy6mapsters7
github4busy6

An increasing number of contributions relating to 'wordpress', and 'mapsters' have seen these tags enter into the top 10.


Graphics

Tag4th DecTag18th Dec
design304design605
graphics155graphics347
opensource142utopian-io289
utopian-io142art243
art119logo160
utopiangif115opensource143
logo70utopiangif115
creative62creativity97
contest41creative82
steemit35graphic63

The top 10 for the 'Graphics' contribution category remains mostly unchanged following no new major drivers since the 'utopiangif' contest took place.


Ideas

Tag4th DecTag18th Dec
steemit485steemit634
utopian-io276utopian-io380
suggestion194suggestion309
idea171nigeria209
steem153steem206
opensource145idea185
nigeria143opensource175
steemdev107steemdev142
ideas88busy117
indonesia84contribution104

'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

Tag4th DecTag18th Dec
steemit29steemit44
utopian-io20promo-steem28
promo-steem17utopian-io27
opensource14visibility18
facebook11marketing17
visibility11facebook14
marketing10nigeria13
nigeria10opensource9
steemdev7sndbox9
busy6steem9

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

Tag4th DecTag18th Dec
programming1utopian-io4
opensource1steemit3
java1food1
gaming1facebook1
games1design1
game1creative1
contest1contribution1
condenser1contest1
busy1condenser1
blog1busy1

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

Tag4th DecTag18th Dec
translation373translation944
utopian-io172utopian-io432
opensource120opensource306
blog84blog194
contribution80indonesia188
indonesia58contribution183
busy56translate171
cn46tr157
steemit45cn88
utopian43utopian74

'indonesia' has moved further away from 'china', now with 100 more Translation contributions compared with just 12 two weeks ago.


Tutorials

Tag4th DecTag18th Dec
tutorial338tutorial703
tr157utopian-io313
utopian-io127tr284
tutorials95tutorials207
steemit80opensource145
indonesia67indonesia144
wordpress66steemit137
opensource62wordpress118
howto46howto86
contribution40programming86

'Tutorials' top 10 tags remains mostly unchanged, however there is a new entry for 'programming'.

Video-tutorials

Tag4th DecTag18th Dec
tutorial135tutorial273
tr80tr220
utopian-io65utopian-io162
video21video71
opensource20opensource46
videotutorial20videotutorial37
wordpress16gimp36
steemit13steemit30
blog12blog23
kodi12project19

'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:

image.png

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

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

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!

Sangat luar biasa.
Amazing.
Informasi yang bagus.
Salam kenal

Thanks!

Oke

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 :)

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.

Qurator
Your Quality Content Curator
This post has been upvoted and given the stamp of authenticity by @qurator. To join the quality content creators and receive daily upvotes click here for more info.

Qurator's exclusive support bot is now live. For more info click HERE or send some SBD and your link to @qustodian to get even more support.

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

Hey @abh12345 I am @utopian-io. I have just upvoted you!

Achievements

  • Seems like you contribute quite often. AMAZING!

Community-Driven Witness!

I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!

mooncryption-utopian-witness-gif

Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x