Steemfest: An analysis of the tags used by Steemfest attendees
Yes, another Steemfest 2' homework edition' blog has been completed. I hope you find it of use....
Perhaps you'd like to seek (or avoid!) people at the event with particular blog interests?
What are the most popular tags used by SF2 attendees?
What are the most used tags by each attendee?
Answers to these questions (and more) below...
Hi all
Following an attempt at gathering a list of all the attendees to Steemfest 2 in Lisbon this year, I thought it would be interesting to look into what other information I could find that may be of interest prior to the event.
In today's blog (which took a fair amount of time to create to say the least!), I present to you information regarding the tags used by this years' Steemfest attendees.
The 3 most popular tags used by each attendee
This table presents the 3 most popular tags each attendee has used throughout their blogging career on the Steem Blockchain. The table is ordered alphabetically by first tag, which is the also the most popular tag each attendee has used.
| User | Tags |
|---|---|
| @sterlinluxan | anarchism,anarchy,psychology |
| @shortcut | art,deutsch,photography |
| @opheliafu | art,drawing,creativity |
| @mysteem | art,freedom,meditation |
| @paolobeneforti | art,funny,drawing |
| @sature | art,life,music |
| @yoganarchista | art,life,story |
| @voronoi | art,steemit,architecture |
| @chris4210 | beyondbitcoin,bitshares,News |
| @aaronkoenig | bitcoin,blockchain,film |
| @prc | bitcoin,life,cryptocurrency |
| @charlieshrem | bitcoin,steem,life |
| @robrigo | bitshares,security,blockchain |
| @wmougayar | blockchains,models,innovation |
| @anasya | crazychallenge,game,fun |
| @pollux.one | deutsch,life,photography |
| @redpalestino | deutsch,photography,travel |
| @spurious-claims | education,government,life |
| @ivargereiko | fitness,health,gym |
| @allasyummyfood | food,blog,recipe |
| @knozaki2015 | food,travel,minnowsunite |
| @oroger | fr,belgium,steemit |
| @roxane | fr,maviedeblogueuse,busy |
| @ginacarr | freedom,choice,liberty |
| @acromott | freedom,life,art |
| @lenadr | funny,blog,writing |
| @felixxx | funny,photography,steemit |
| @edb | funny,politics,netherlands |
| @alanfreestone | health,homeopathy,vaccines |
| @varunpinto | india,photography,life |
| @fukako | japanese,art,drawing |
| @kinakomochi | japanese,blog,food |
| @shogo | japanese,photography,food |
| @andrewmcmillen | journalism,longform,writing |
| @ramengirl | kr,blog,food |
| @ludorum | kr,blog,life |
| @maa | kr,coinkorea,bitcoin |
| @successtrainer | kr,kr-newbie,steemit |
| @roychoi | kr,kr-newbie,steemit |
| @hansikhouse | kr,life,story |
| @the-alien | life,alien,steemit |
| @e-saber | life,art,gaming |
| @comealong | life,art,photography |
| @soldier | life,art,writing |
| @surfermarly | life,blog,steemit |
| @wandereronwheels | life,blog,travel |
| @mrs.steemit | life,blog,travel |
| @future24 | life,deutsch,photography |
| @getonthetrain | life,money,history |
| @juanmiguelsalas | life,photography,art |
| @silviabeneforti | life,photography,art |
| @lex030 | life,photography,deutsch |
| @jaybird | life,photography,music |
| @detlev | life,photography,story |
| @noboxes | life,photography,travel |
| @pjo | life,photography,travel |
| @serejandmyself | life,poetry,writing |
| @dayleeo | life,remsteem,remotevoices |
| @cryptofunk | life,steemit,bitcoin |
| @ballinconscious | life,steemit,money |
| @ekitcho | life,steemit,steem |
| @terrybrock | life,steemit,success |
| @dougkarr | life,steemit,video |
| @teamhumble | life,steemit,wakeup |
| @exyle | life,story,blog |
| @bkdbkd | life,story,health |
| @ericvancewalton | life,story,writers |
| @saramiller | life,yoga,health |
| @karensuestudios | love,blog,freedom |
| @massivevibration | massivevibrations,music,art |
| @xanoxt | minnowsunite,payitforward,photography |
| @gmuxx | minnowsupportproject,minnowsupport,art |
| @twinner | money,bitcoin,permacryptofolio |
| @walterjay | money,cryptocurrency,bitshares |
| @dollarvigilante | money,finance,bitcoin |
| @tomasgeorge | music,production,video |
| @elear | opensource,steemdev,steemitdev |
| @shak | pevo,science,meetup |
| @s0u1 | photo,life,automobile |
| @everlove | photography,art,life |
| @gringalicious | photography,food,life |
| @eveuncovered | photography,life,art |
| @rea | photography,life,cn |
| @liliana.duarte | photography,life,portugal |
| @timsaid | photography,life,steemit |
| @mammasitta | photography,life,travel |
| @xroni | photography,nature,photo |
| @nomadnessie | photography,nature,travel |
| @quinneaker | photography,steemit,art |
| @osm0sis | photography,travel,culturevulture |
| @jeffjagoe | photography,travel,food |
| @tarquinmaine | photography,travel,writing |
| @lenka | polish,steepshot,life |
| @annaarthur | politics,germany,democracy |
| @jexblackmore | politics,religion,activism |
| @ashleypeat | promo-uk,promo-steem,steem |
| @starkerz | promo-uk,promo-steem,steemitroadshow |
| @logic | science,steemit,steemsquad |
| @brian-rhodes | screenwriting,filmmaking,acting |
| @val | spam,ru,podcasts |
| @oscarcc89 | spanish,art,blog |
| @gargon | spanish,cervantes,life |
| @pgarcgo | spanish,cervantes,steem-guild |
| @inquiringtimes | steem,minnowsupport,life |
| @wingz | steem,money,steemit |
| @ned | steem,steemit,art |
| @steemrollin | steem,steemit,cryptocurrency |
| @good-karma | steem,steemit,esteem |
| @furion | steem,steemit,money |
| @roelandp | steem,steemit,steemfest |
| @heimindanger | steem,steemit,whales |
| @demotruk | steem,steemit,youtube |
| @lukestokes | steem,trading,steemit |
| @philmesnier | steemfest,eos,blockchain |
| @sompitonov | steemit,art,origami |
| @bitrocker2020 | steemit,art,teammalaysia |
| @simonjay | steemit,blockchain,crypto-news |
| @connecteconomy | steemit,cryptocurrency,bitcoin |
| @fatpandadesign | steemit,cryptocurrency,msp |
| @abh12345 | steemit,life,music |
| @blueorgy | steemit,life,photography |
| @lrock | steemit,photography,berlin |
| @vi1son | steemit,photography,steemitphotochallenge |
| @t3ran13 | steemit,rating,blog |
| @vandeberg | steemit,rickandmorty,steem |
| @burnin | steemit,scifi,fiction |
| @jerrybanfield | steemit,steem,life |
| @grumlin | steemit,steem,money |
| @noisy | steemit,steem,polish |
| @theprophet0 | steemit,steem,witness-category |
| @timcliff | steemit,steem,witness-category |
| @steevc | steemit,tsudoscience,music |
| @andrarchy | steemit,video,steem |
| @sneak | steemit,videos,life |
| @dan-atstarlite | steemit,vlog,steem |
| @pnc | steem-quebec,blockchain,fr |
| @teodora | steepshot,life,photography |
| @vcelier | story,life,bd |
| @michelle.gent | story,writing,fiction |
| @ezzy | story,writing,life |
| @tobydaniel2 | surfing,travel,photography |
| @alexlinebrink | technology,cryptocurrency,blockchain |
| @joythewanderer | travel,cn,photography |
| @martibis | travel,poetry,steemit |
| @arunaelentari | travel,spain,art |
| @anomadsoul | travel,spanish,cervantes |
| @lafona | video,steemit,story |
| @heiditravels | video,travel,cryptocurrency |
| @wolfcat | wolfcat,travel,wildatlanticway |
| @theowlhours | writing,fiction,creativity |
| @artist1989 | writing,story,fiction |
Ordering the table by each users most popular tag roughly groups users together. It's quite easy to spot the Artists, and Photographers for example.
Pressing 'Ctrl' + F when using a PC, should bring up the 'Find' box. Entering 'Art', for example, here should allow quick searching of users who have 'Art' as a second or third most popular tag.
The 10 most popular tags used by Steemfest attendees
Our attendess have used over 10000 different tags in the creation of their blogs, but which tags are the most popular?
The next table displays the 10 tags that are used the most by the vistors to Lisbon this year.
| Tag | Count |
|---|---|
| life | 8419 |
| photography | 5670 |
| steemit | 5521 |
| art | 4472 |
| blog | 3420 |
| story | 2966 |
| travel | 2815 |
| food | 2698 |
| steem | 2449 |
| writing | 2278 |
| others | 84719 |
Life is leading the way (as it should?!), being the most popular tag for 29 attendees and represents 7% of the total tags used.
These top 10 tags represent 32% of all the tags used.
Two tags I wouldn't have guessed to appear in the top 10 are 'story' and 'writing'. @vcelier, @michelle.gent, @ezzy have their top tag as 'story', and @theowlhours and @artist1989 have used 'writing' more than any other tag.
Unique top tags used by Steemfest attendees
Are there any niche bloggers attending Steemfest with a particular interest at heart? Lets see what the data says...
In this list are attendees that have a unique most used tag.
| Tag | Count |
|---|---|
| @sterlinluxan | anarchism |
| @chris4210 | beyondbitcoin |
| @robrigo | bitshares |
| @wmougayar | blockchains |
| @anasya | crazychallenge |
| @spurious-claims | education |
| @ivargereiko | fitness |
| @alanfreestone | health |
| @varunpinto | india |
| @karensuestudios | love |
| @massivevibration | massivevibrations |
| @tomasgeorge | music |
| @elear | opensource |
| @shak | pevo |
| @lenka | polish |
| @logic | science |
| @brian-rhodes | screenwriting |
| @val | spam |
| @tobydaniel2 | surfing |
| @alexlinebrink | technology |
| @wolfcat | wolfcat |
This information could be said to highlight a user with a particular blogging interest.
If you are keen to learn more about 'opensource', @elear looks to be your man. @robrigo seems to be the go-to for more information on 'bitshares', and if you need a bit more 'spam' in your life, speak to @val :)
The Steemfest attendees list
The base data and inspiration for the information above came from the idea to create a list of all the users heading to Portugal this year. I posted this list in a blog last week, and have continued to update it following comments, @roelandp's blog, and a check in @steemfest's wallet.
I'm hoping we have most attendees now on the list below, but if you are not present then please let me know.
I'll continue to update it as and when I receive new information, and this will be the last blog I write containing the list (I promise!).
Thanks to everyone for your support with this!
| User | Brief | 1 | 2 |
|---|---|---|---|
| @aaronkoenig | Entrepreneur, consultant, writer and film producer organising Bitfilm contest | - | - |
| @abh12345 | IT consultant, UK Expat, steemian | - | - |
| @acromott | - | - | - |
| @alanfreestone | Homeopath, crypto-enthusiast, interested in launching an ICO/token sale | - | - |
| @alexlinebrink | CEO of PassageX. Serial Entrepreneur. Crypto-Trader. Drone Builder | - | - |
| @allasyummyfood | Youtuber, chef and steemian | - | - |
| @ana.telepova | Flacoin Co-founder | - | - |
| @anasya | Flacoin Co-founder | - | - |
| @andrarchy | Steemit Team Member | - | - |
| @andrewmcmillen | - | - | - |
| @annaarthur | - | - | - |
| @anomadsoul | Nomad. Writer. Dreamer | 1 | - |
| @artist1989 | Artist/author | 1 | - |
| @arunaelentari | - | - | - |
| @ashleypeat | - | - | - |
| @ballinconscious | Hypnotist, Therapist, and Musician | - | - |
| @bitrocker2020 | - | - | - |
| @bkdbkd | - | - | - |
| @blueorgy | - | - | - |
| @brian-rhodes | - | - | - |
| @burnin | - | - | - |
| @charlieshrem | - | - | - |
| @chris4210 | Co-founder Bitshares Munich | - | - |
| @comealong | - | - | - |
| @connecteconomy | Cryptocurrency mentor for conscious women entrepreneurs & and an online biz management consultant focused on customer happiness | - | - |
| @cryptofunk | - | - | - |
| @dan-atstarlite | Vlogger, Founder of Steemit Health - Half of The @SteemBirds | - | - |
| @dayleeo | Digital Freelancer, Voice Over, & Media Maker | 1 | - |
| @demotruk | Developer, investor, stakeholder. | - | - |
| @detlev | CEO, Speaker, Consultant, Author, Traveller, BBQ and (TAG)BeerSaturday creator | - | - |
| @dollarvigilante | - | - | - |
| @dougkarr | Writer. Director. Crypto Enthusiast | - | - |
| @edb | - | - | - |
| @ekitcho | - | - | - |
| @elear | Software Developer/Architect. Tech geek | - | - |
| @ericvancewalton | Author. Traveler. Crypto Enthusiast | - | - |
| @e-saber | Mathematician, Chaos Theorist | - | - |
| @everlove | Artist of life, Steemit Collaborative Art Journey | - | - |
| @eveuncovered | - | - | - |
| @exyle | - | - | - |
| @ezzy | - | - | - |
| @fatpandadesign | - | - | - |
| @felixxx | - | - | - |
| @fukako | - | - | - |
| @furion | - | - | - |
| @future24 | - | - | - |
| @gargon | - | - | - |
| @getonthetrain | Personal finance blogger and Author | - | - |
| @ginacarr | Tribe Builder, Health Activist, Vegan Enthusiast | - | - |
| @gmuxx | Writer, 3D artist and moderator at The Writers' Block | - | - |
| @good-karma | - | - | - |
| @gringalicious | Food blogger / photographer, US citizen who just returned to the states from living in Patagonia Chile for 4 years | 1 | - |
| @grumlin | - | - | - |
| @hansikhouse | Cultural Development Strategist, Co-Founder of Sndbox | - | - |
| @heiditravels | - | - | - |
| @heimindanger | - | - | - |
| @hkjn | - | - | - |
| @inquiringtimes | - | 1 | - |
| @ivargereiko | - | - | - |
| @jaybird | Music/Creative, Founder of The Steemit Sandwich Contest & Half of the @steemBirds | - | - |
| @jeff7 | CFO Steemit | - | - |
| @jeffjagoe | Crypto-Evangelist with a passion for Nature, Food, Technology & Freedom | 1 | - |
| @jerrybanfield | Youtuber, educator, witness, comedian | - | - |
| @jexblackmore | Interdisciplinary artist and activist. Spokesperson for The Satanic Temple | - | - |
| @joythewanderer | multilingual travel blogger, anarchist | - | - |
| @juanmiguelsalas | Video editor and graphic designer from Cuba living in Germany. Education project on Blockchain, uses and advantages for Latin American countries | - | - |
| @karensuestudios | Acroyogi teaching acroyoga at Steemfest, artist, youtuber, published author | - | 2 |
| @kinakomochi | - | - | - |
| @knozaki2015 | - | - | - |
| @lafona | - | - | - |
| @lenadr | Artist, writer, animal fanatic, mayhem creator | - | - |
| @lenka | - | - | - |
| @lex030 | - | - | - |
| @liliana.duarte | - | - | - |
| @logic | - | - | - |
| @lrock | - | - | - |
| @ludorum | - | - | - |
| @lukestokes | Father, husband, business owner, programmer, voluntaryist | 1 | - |
| @maa | - | - | - |
| @mammasitta | - | - | - |
| @martibis | - | - | - |
| @massivevibration | - | - | - |
| @michelle.gent | - | - | - |
| @mrs.steemit | Co-founder Appics | - | - |
| @mysteem | - | - | - |
| @ned | - | - | - |
| @noboxes | Husband, father of 7, crazy life liver, cryto enthusiast, recently returned to the states from living in Patagonia for 4 years and last but not least, Dad of @gringalicious | 1 | - |
| @noisy | - | - | - |
| @nomadnessie | - | - | - |
| @opheliafu | Artist and visual storyteller | - | - |
| @oroger | - | - | - |
| @oscarcc89 | Artist, Computer Technician, Digital Designer. | - | - |
| @osm0sis | - | - | - |
| @paolobeneforti | Artist, Art-At-Steemfest event | 1 | - |
| @peterpanski | - | - | - |
| @pgarcgo | - | - | - |
| @philmesnier | Partner and Blockchain Practice Lead, Object Computing, Inc | - | - |
| @pjo | - | - | - |
| @pnc | - | - | - |
| @pollux.one | - | - | - |
| @prc | - | - | - |
| @quinneaker | Visionary & Founder of the Garden Of Eden EcoVillage | - | - |
| @ramengirl | - | - | - |
| @rea | - | - | - |
| @redpalestino | - | - | - |
| @robrigo | - | - | - |
| @roelandp | Kitesurfer, (mobile app) developer, dad, witness, @steemfest organiser | - | - |
| @roxane | - | - | - |
| @roychoi | - | - | - |
| @s0u1 | - | - | - |
| @saramiller | Yogini, Dakini, & Reiki Master | - | - |
| @sature | - | - | - |
| @serejandmyself | CEO Golos Fund | - | - |
| @shak | PEvO Project Manager | - | - |
| @shogo | Description: University Student(Japan) | - | - |
| @shortcut | Artist, video-editor and web-designer from Germany. Into photography, music and poetry | 1 | - |
| @silviabeneforti | Artist, Art-At-Steemfest event | 1 | - |
| @simonjay | - | - | - |
| @sneak | - | - | - |
| @soldier | - | - | - |
| @sompitonov | - | - | - |
| @spurious-claims | - | - | - |
| @starkerz | Responsible Steem Holder (TAG)promo-steem, (TAG)promo-uk | - | - |
| @steemrollin | Founder BitCash & Peerhub | - | - |
| @steevc | - | - | - |
| @sterlinluxan | Communications Ambassador for Bitcoin.com | - | - |
| @successtrainer | - | - | - |
| @surfermarly | Computer Scientist, surfergirl and steemian | - | 2 |
| @t3ran13 | - | - | - |
| @Tarquinmaine | Curios Nomad Writer Filmmaker | - | 2 |
| @teamhumble | - | 1 | - |
| @teodora | "Nature Warrior, Magic Builder, IOT lover, Meditate- or, Startup Curious and Wannabe Crypto Entrepreneur | - | - |
| @terrybrock | Speaker, Columnist, MC For SteemFest, Steemit Lover | - | - |
| @the-alien | (Ghost)Writer, entrepreneur, world traveler, blockchain and open-source enthusiast | - | - |
| @theowlhours | - | - | - |
| @theprophet0 | SteemSports General Manager, witness in DPoS | - | - |
| @timcliff | Steem witness | - | - |
| @timsaid | Crypto Challenge, scientist, photographer and free | - | - |
| @tobydaniel2 | - | - | - |
| @tomasgeorge | - | - | - |
| @twinner | - | - | - |
| @val | - | - | - |
| @vandeberg | Steemit Blockchain Developer | - | - |
| @varunpinto | - | - | 2 |
| @vcelier | Retired Navy officer, software engineer | - | - |
| @vi1son | - | - | - |
| @voronoi | Curious urbanist. Co-Founder of Sndbox | - | - |
| @walterjay | - | - | - |
| @wandereronwheels | - | - | - |
| @wingz | - | - | - |
| @wmougayar | - | - | - |
| @wolfcat | - | - | - |
| @xanoxt | Rudex.org, Modern Nomad and crypto enthusiast | - | - |
| @xroni | - | - | - |
| @yoganarchista | - | - | - |
| Martin Smolka | https://decent.ch/ Decent chain, ice hockey lover and dog owner | - | - |
Attending and not on the list? Sorry! Let me know!
I hope you have found the data --> information in today's blog useful. The process took me much longer than I initially expected, both to write and execute the queries involved. One query took over 5 hours to complete- Linked server connections with string manipulation do not seem to be the quickest, although my SQL scripting could also be at fault!
If there are users reading this who are interested in the SQL scripts use to extract and organise this data from SteemSQL, let me know by commenting below.
If anyone has ideas on the data they might wish to see regarding Steemfest, the attendees, or anything else in the SteemSQL DB that could be of use, please comment below.
Finally, thank you very much for supporting my blogs and I shall be seeing at least 155 of you in less than a weeks time!
Safe travels all, and have a great day!
Asher
In other news...
It would be great to hear about what Steemfest attendees (and everyone else of course) think about @ned's recent decision to take back 3 million delegated Steem Power from 6 (of the 7) users he distributed it to on the 8th August.
I'd love to have the chance to ask him about this at Steemfest!
Good post. I'm not sure I agree w your metrics however. If I had to say myself the significant tags I use would be steemit (but can be omitted in general since it's ubiquitous) steemit-help minnowsupport newsteem and discussion. I don't remember having used #life more than once ever and also should be omitted from analysis because it's so generic and over used.. that's all just my opinion. <3
A better metric might be "tags most commonly used by..." However sounds harder to grab that data... Idk
Opinion noted :)
Having listened to an hour long interview of a big Steemit vlogger mentioning that he is most interested in people who blog/vlog about 'life', I'll have to side with him and the other 30 users who decide to choose this as their most popular tag when creating a Steemit blog.
I could rename it to 'tag most commonly used by' if you wish, but this is the most commonly used tag per individual, so I'm unsure the renaming of the table will mean much.
I've used the life tag no more than 5 times - I use it when I talk about myself.
Cheers!
I only used life a few times in 4 months here, if you have data to show otherwise, I'm interested. It seems to be a generic tag for when people don't know which tags to use. again, that's my opinion. Seeing that a post has the tag #life gives me 0 information about what the post actually relates to without the title first lines and the rest.
If it was more specifically explained what the tag is about and what should be used for, it could be a useful tag, imo. Otherwise, everything under the sun is life.
This comment has received a 12.86 % upvote from @lovejuice thanks to: @abh12345. They love you, so does Aggroed. Please be sure to vote for Witnesses at https://steemit.com/~witnesses.
Great post. So many stats are involved, damn! Must have taken some time to make
Most of a day, yes.
Thanks very much for your comments!
Wow this list must have taken you forever to create! Thank you for your contribution! Excited to hear about what is to come from Steemfest. 100% upvoted.
God Speed Brethren.
Yeah most of a day for this one :)
A good exercise SQL-wise, and hopefully it'll be useful for some come next week.
Thanks for the comment and up-vote 😁
Great info to make sure we get the most out of our time/posts!
Excellent post @abh12345. The data in this post is unbelievable. Super helpful! Thanks :)
Funny you are asking about @neds un delegation. I just looked at the data in a lot of detail. I know you will find it interesting
https://steemit.com/steemit/@paulag/can-the-data-tell-us-why-ned-undelegated-so-much-steem-power-steemit-business-intelligence
That's a great post Paula.
My post on the subject included little data, I knew what would be found and thought I'd just throw it out there and let people do the talking!
hahah this is so interesting! I'm the ONLY one that uses love? LOL :) Fun facts. Thanks for the share.
Yep!
Well done you!
Interesting! Funny that "life" always finds a way ;)
😁
When I first heard of blogging, I thought that life - your life, was the only original content.
Not sure if my mind has changed that much, 20 years later :)
That’s a damn good point my friend- sharing life through storytelling is in our DNA as a species
Im new here in steemit.. My friends told me to maximize 5 tags.. What is the significance of that?? And what can you suggest as the best tags to use so others can see also my post incase?? I still on my way learning steemit. Hope i could seek advice : )
Welcome :)
5 is the maximum, but you don't need to use 5 each time.
Some users look at specific tags, and like to support that tag by voting posts in that category.
The most important thing about tags is to not use them when they don't relate to your post.
For example, only use introduceyourself on your first couple of posts that talk about you. Using this tag later may end up with a flag/down-vote.
I see you have used 4 tags on your latest post, I think these are all relevant - good job :)
Ow i see :)
thank you for that info. Hoping i can improve my post. : )
Very original and useful application of the data, Asher. A great idea!
That 5 hour query length sounds long though!
Have fun at the festival!
Thank you!
Yes 5 hours is too long, most likely my rough SQL!