Steemfest: An analysis of the tags used by Steemfest attendees

in #steemfest7 years ago

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



title.jpg


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.

UserTags
@sterlinluxananarchism,anarchy,psychology
@shortcutart,deutsch,photography
@opheliafuart,drawing,creativity
@mysteemart,freedom,meditation
@paolobenefortiart,funny,drawing
@satureart,life,music
@yoganarchistaart,life,story
@voronoiart,steemit,architecture
@chris4210beyondbitcoin,bitshares,News
@aaronkoenigbitcoin,blockchain,film
@prcbitcoin,life,cryptocurrency
@charlieshrembitcoin,steem,life
@robrigobitshares,security,blockchain
@wmougayarblockchains,models,innovation
@anasyacrazychallenge,game,fun
@pollux.onedeutsch,life,photography
@redpalestinodeutsch,photography,travel
@spurious-claimseducation,government,life
@ivargereikofitness,health,gym
@allasyummyfoodfood,blog,recipe
@knozaki2015food,travel,minnowsunite
@orogerfr,belgium,steemit
@roxanefr,maviedeblogueuse,busy
@ginacarrfreedom,choice,liberty
@acromottfreedom,life,art
@lenadrfunny,blog,writing
@felixxxfunny,photography,steemit
@edbfunny,politics,netherlands
@alanfreestonehealth,homeopathy,vaccines
@varunpintoindia,photography,life
@fukakojapanese,art,drawing
@kinakomochijapanese,blog,food
@shogojapanese,photography,food
@andrewmcmillenjournalism,longform,writing
@ramengirlkr,blog,food
@ludorumkr,blog,life
@maakr,coinkorea,bitcoin
@successtrainerkr,kr-newbie,steemit
@roychoikr,kr-newbie,steemit
@hansikhousekr,life,story
@the-alienlife,alien,steemit
@e-saberlife,art,gaming
@comealonglife,art,photography
@soldierlife,art,writing
@surfermarlylife,blog,steemit
@wandereronwheelslife,blog,travel
@mrs.steemitlife,blog,travel
@future24life,deutsch,photography
@getonthetrainlife,money,history
@juanmiguelsalaslife,photography,art
@silviabenefortilife,photography,art
@lex030life,photography,deutsch
@jaybirdlife,photography,music
@detlevlife,photography,story
@noboxeslife,photography,travel
@pjolife,photography,travel
@serejandmyselflife,poetry,writing
@dayleeolife,remsteem,remotevoices
@cryptofunklife,steemit,bitcoin
@ballinconsciouslife,steemit,money
@ekitcholife,steemit,steem
@terrybrocklife,steemit,success
@dougkarrlife,steemit,video
@teamhumblelife,steemit,wakeup
@exylelife,story,blog
@bkdbkdlife,story,health
@ericvancewaltonlife,story,writers
@saramillerlife,yoga,health
@karensuestudioslove,blog,freedom
@massivevibrationmassivevibrations,music,art
@xanoxtminnowsunite,payitforward,photography
@gmuxxminnowsupportproject,minnowsupport,art
@twinnermoney,bitcoin,permacryptofolio
@walterjaymoney,cryptocurrency,bitshares
@dollarvigilantemoney,finance,bitcoin
@tomasgeorgemusic,production,video
@elearopensource,steemdev,steemitdev
@shakpevo,science,meetup
@s0u1photo,life,automobile
@everlovephotography,art,life
@gringaliciousphotography,food,life
@eveuncoveredphotography,life,art
@reaphotography,life,cn
@liliana.duartephotography,life,portugal
@timsaidphotography,life,steemit
@mammasittaphotography,life,travel
@xroniphotography,nature,photo
@nomadnessiephotography,nature,travel
@quinneakerphotography,steemit,art
@osm0sisphotography,travel,culturevulture
@jeffjagoephotography,travel,food
@tarquinmainephotography,travel,writing
@lenkapolish,steepshot,life
@annaarthurpolitics,germany,democracy
@jexblackmorepolitics,religion,activism
@ashleypeatpromo-uk,promo-steem,steem
@starkerzpromo-uk,promo-steem,steemitroadshow
@logicscience,steemit,steemsquad
@brian-rhodesscreenwriting,filmmaking,acting
@valspam,ru,podcasts
@oscarcc89spanish,art,blog
@gargonspanish,cervantes,life
@pgarcgospanish,cervantes,steem-guild
@inquiringtimessteem,minnowsupport,life
@wingzsteem,money,steemit
@nedsteem,steemit,art
@steemrollinsteem,steemit,cryptocurrency
@good-karmasteem,steemit,esteem
@furionsteem,steemit,money
@roelandpsteem,steemit,steemfest
@heimindangersteem,steemit,whales
@demotruksteem,steemit,youtube
@lukestokessteem,trading,steemit
@philmesniersteemfest,eos,blockchain
@sompitonovsteemit,art,origami
@bitrocker2020steemit,art,teammalaysia
@simonjaysteemit,blockchain,crypto-news
@connecteconomysteemit,cryptocurrency,bitcoin
@fatpandadesignsteemit,cryptocurrency,msp
@abh12345steemit,life,music
@blueorgysteemit,life,photography
@lrocksteemit,photography,berlin
@vi1sonsteemit,photography,steemitphotochallenge
@t3ran13steemit,rating,blog
@vandebergsteemit,rickandmorty,steem
@burninsteemit,scifi,fiction
@jerrybanfieldsteemit,steem,life
@grumlinsteemit,steem,money
@noisysteemit,steem,polish
@theprophet0steemit,steem,witness-category
@timcliffsteemit,steem,witness-category
@steevcsteemit,tsudoscience,music
@andrarchysteemit,video,steem
@sneaksteemit,videos,life
@dan-atstarlitesteemit,vlog,steem
@pncsteem-quebec,blockchain,fr
@teodorasteepshot,life,photography
@vcelierstory,life,bd
@michelle.gentstory,writing,fiction
@ezzystory,writing,life
@tobydaniel2surfing,travel,photography
@alexlinebrinktechnology,cryptocurrency,blockchain
@joythewanderertravel,cn,photography
@martibistravel,poetry,steemit
@arunaelentaritravel,spain,art
@anomadsoultravel,spanish,cervantes
@lafonavideo,steemit,story
@heiditravelsvideo,travel,cryptocurrency
@wolfcatwolfcat,travel,wildatlanticway
@theowlhourswriting,fiction,creativity
@artist1989writing,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.

TagCount
life8419
photography5670
steemit5521
art4472
blog3420
story2966
travel2815
food2698
steem2449
writing2278
others84719


top 10 tags.png



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.

TagCount
@sterlinluxananarchism
@chris4210beyondbitcoin
@robrigobitshares
@wmougayarblockchains
@anasyacrazychallenge
@spurious-claimseducation
@ivargereikofitness
@alanfreestonehealth
@varunpintoindia
@karensuestudioslove
@massivevibrationmassivevibrations
@tomasgeorgemusic
@elearopensource
@shakpevo
@lenkapolish
@logicscience
@brian-rhodesscreenwriting
@valspam
@tobydaniel2surfing
@alexlinebrinktechnology
@wolfcatwolfcat

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!

UserBrief12
@aaronkoenigEntrepreneur, consultant, writer and film producer organising Bitfilm contest--
@abh12345IT consultant, UK Expat, steemian--
@acromott---
@alanfreestoneHomeopath, crypto-enthusiast, interested in launching an ICO/token sale--
@alexlinebrinkCEO of PassageX. Serial Entrepreneur. Crypto-Trader. Drone Builder--
@allasyummyfoodYoutuber, chef and steemian--
@ana.telepovaFlacoin Co-founder--
@anasyaFlacoin Co-founder--
@andrarchySteemit Team Member--
@andrewmcmillen---
@annaarthur---
@anomadsoulNomad. Writer. Dreamer1-
@artist1989Artist/author1-
@arunaelentari---
@ashleypeat---
@ballinconsciousHypnotist, Therapist, and Musician--
@bitrocker2020---
@bkdbkd---
@blueorgy---
@brian-rhodes---
@burnin---
@charlieshrem---
@chris4210Co-founder Bitshares Munich--
@comealong---
@connecteconomyCryptocurrency mentor for conscious women entrepreneurs & and an online biz management consultant focused on customer happiness--
@cryptofunk---
@dan-atstarliteVlogger, Founder of Steemit Health - Half of The @SteemBirds--
@dayleeoDigital Freelancer, Voice Over, & Media Maker1-
@demotrukDeveloper, investor, stakeholder.--
@detlevCEO, Speaker, Consultant, Author, Traveller, BBQ and (TAG)BeerSaturday creator--
@dollarvigilante---
@dougkarrWriter. Director. Crypto Enthusiast--
@edb---
@ekitcho---
@elearSoftware Developer/Architect. Tech geek--
@ericvancewaltonAuthor. Traveler. Crypto Enthusiast--
@e-saberMathematician, Chaos Theorist--
@everloveArtist of life, Steemit Collaborative Art Journey--
@eveuncovered---
@exyle---
@ezzy---
@fatpandadesign---
@felixxx---
@fukako---
@furion---
@future24---
@gargon---
@getonthetrainPersonal finance blogger and Author--
@ginacarrTribe Builder, Health Activist, Vegan Enthusiast--
@gmuxxWriter, 3D artist and moderator at The Writers' Block--
@good-karma---
@gringaliciousFood blogger / photographer, US citizen who just returned to the states from living in Patagonia Chile for 4 years1-
@grumlin---
@hansikhouseCultural Development Strategist, Co-Founder of Sndbox--
@heiditravels---
@heimindanger---
@hkjn---
@inquiringtimes-1-
@ivargereiko---
@jaybirdMusic/Creative, Founder of The Steemit Sandwich Contest & Half of the @steemBirds--
@jeff7CFO Steemit--
@jeffjagoeCrypto-Evangelist with a passion for Nature, Food, Technology & Freedom1-
@jerrybanfieldYoutuber, educator, witness, comedian--
@jexblackmoreInterdisciplinary artist and activist. Spokesperson for The Satanic Temple--
@joythewanderermultilingual travel blogger, anarchist--
@juanmiguelsalasVideo editor and graphic designer from Cuba living in Germany. Education project on Blockchain, uses and advantages for Latin American countries--
@karensuestudiosAcroyogi teaching acroyoga at Steemfest, artist, youtuber, published author-2
@kinakomochi---
@knozaki2015---
@lafona---
@lenadrArtist, writer, animal fanatic, mayhem creator--
@lenka---
@lex030---
@liliana.duarte---
@logic---
@lrock---
@ludorum---
@lukestokesFather, husband, business owner, programmer, voluntaryist1-
@maa---
@mammasitta---
@martibis---
@massivevibration---
@michelle.gent---
@mrs.steemitCo-founder Appics--
@mysteem---
@ned---
@noboxesHusband, 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 @gringalicious1-
@noisy---
@nomadnessie---
@opheliafuArtist and visual storyteller--
@oroger---
@oscarcc89Artist, Computer Technician, Digital Designer.--
@osm0sis---
@paolobenefortiArtist, Art-At-Steemfest event1-
@peterpanski---
@pgarcgo---
@philmesnierPartner and Blockchain Practice Lead, Object Computing, Inc--
@pjo---
@pnc---
@pollux.one---
@prc---
@quinneakerVisionary & Founder of the Garden Of Eden EcoVillage--
@ramengirl---
@rea---
@redpalestino---
@robrigo---
@roelandpKitesurfer, (mobile app) developer, dad, witness, @steemfest organiser--
@roxane---
@roychoi---
@s0u1---
@saramillerYogini, Dakini, & Reiki Master--
@sature---
@serejandmyselfCEO Golos Fund--
@shakPEvO Project Manager--
@shogoDescription: University Student(Japan)--
@shortcutArtist, video-editor and web-designer from Germany. Into photography, music and poetry1-
@silviabenefortiArtist, Art-At-Steemfest event1-
@simonjay---
@sneak---
@soldier---
@sompitonov---
@spurious-claims---
@starkerzResponsible Steem Holder (TAG)promo-steem, (TAG)promo-uk--
@steemrollinFounder BitCash & Peerhub--
@steevc---
@sterlinluxanCommunications Ambassador for Bitcoin.com--
@successtrainer---
@surfermarlyComputer Scientist, surfergirl and steemian-2
@t3ran13---
@TarquinmaineCurios Nomad Writer Filmmaker-2
@teamhumble-1-
@teodora"Nature Warrior, Magic Builder, IOT lover, Meditate- or, Startup Curious and Wannabe Crypto Entrepreneur--
@terrybrockSpeaker, Columnist, MC For SteemFest, Steemit Lover--
@the-alien(Ghost)Writer, entrepreneur, world traveler, blockchain and open-source enthusiast--
@theowlhours---
@theprophet0SteemSports General Manager, witness in DPoS--
@timcliffSteem witness--
@timsaidCrypto Challenge, scientist, photographer and free--
@tobydaniel2---
@tomasgeorge---
@twinner---
@val---
@vandebergSteemit Blockchain Developer--
@varunpinto--2
@vcelierRetired Navy officer, software engineer--
@vi1son---
@voronoiCurious urbanist. Co-Founder of Sndbox--
@walterjay---
@wandereronwheels---
@wingz---
@wmougayar---
@wolfcat---
@xanoxtRudex.org, Modern Nomad and crypto enthusiast--
@xroni---
@yoganarchista---
Martin Smolkahttps://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!

Sort:  

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.

Loading...

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 😁

Excellent post @abh12345. The data in this post is unbelievable. Super helpful! Thanks :)

Great info to make sure we get the most out of our time/posts!

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!

Very interesting analytics! Thank you for compiling this great list. Gives me an insight of what attendees interest will be. I will be in attendance this year. I'm a minnow though.

I am a minnow too. See you there! :)

Calling @originalworks :)
img credz: pixabay.com
Nice, you got a 25.0% @trafalgar upgoat, thanks to @abh12345
Want a boost? Minnowbooster's got your back!

The @OriginalWorks bot has determined this post by @abh12345 to be original material and upvoted(2%) it!

ezgif.com-resize.gif

To call @OriginalWorks, simply reply to any post with @originalworks or !originalworks in your message!

@reported has voted on behalf of @minnowpond.
If you would like to recieve upvotes from minnowponds team on all your posts, simply FOLLOW @minnowpond.

            To receive an upvote send 0.25 SBD to @minnowpond with your posts url as the memo
            To receive an reSteem send 0.75 SBD to @minnowpond with your posts url as the memo
            To receive an upvote and a reSteem send 1.00SBD to @minnowpond with your posts url as the memo

This wonderful post has received a bellyrub 16.64 % upvote from @bellyrub thanks to this cool cat: @abh12345. My pops @zeartul is one of your top steemit witness, if you like my bellyrubs please go vote for him, if you love what he is doing vote for this comment as well.

This post has received a 6.65 % upvote from @booster thanks to: @abh12345.

This post has received a 11.63 % upvote from @buildawhale thanks to: @abh12345. Send at least 0.50 SBD to @buildawhale with a post link in the memo field for a portion of the next vote.

To support our daily curation initiative, please vote on my owner, @themarkymark, as a Steem Witness

Resteem your post to 2000+ followers for only 0.5 SBD or Steem)

Just send 0.5 SBD or steem to @steemvote (URL as memo)

New Followers get 0.001 SBD$ and an upvote for free!!

Just follow @steemvote and...

  • we follow back
  • send you 0.001 SBD to your wallet