Chart showing number of references to #promo-steem since the tag started

in promo-steem •  7 years ago  (edited)

promo-steem growth.png

Incredibly, this data shows a clear pattern in usage of the tag both in terms of number of posts, and the number of times it's been referenced.

The first ever post using the #promo-steem happened on the 14th August 2017. Since then, there have been over 7300 posts to the promo-steem tag. This graph shows a nice visual of the number of daily posts since it began.

number of promo-steem posts.png

Look at those lovely waves. A technical analyists wet dream if ever I saw one!


How many times has #promo-steem been referenced?

But that's not all. Thanks to the incredibly helpful data you can get off the blockchain, I've even managed to pull the number of times @promo-steem has been referenced in posts too.

number of promo-steem references

This graph shows the number of times someone has put #promo-steem in a post.

Clever people (not like me, I mean really clever people) may be able to take this and extrapolate the growth of the tag over the next 6-12 months. (I'm looking at you @cryptocurator!)


All interesting stuff. Now can you imagine what this will look like in six months from now? Especially when we have the Steem Ambassador programme fully up and running with the guild online and working in it's beautifully decentralised and automated way? Now imagine what happens if we have plenty of delegated SP in the @steem-ambassador account, making sure that we can reward high quality promotional work really well?

That's what it's all about. We know that right now, we are at the beginning. We want the whales to recognise this, and realise that by delegating, they are helping themselves as well as a decentralised community of voluntaryists who are committed to Steemit and the STEEM blockchain!

Over the next few weeks, we will be launching a drive to bring this sort of investment in. What we are seeing is nothing short of phenomenal. Now we are intent on taking it to the next level.


How to run this fun query yourself...or get data on another tag


If you'd like to run this yourself, or maybe even get the data on other tags, you can use the following SQL query to get the data from SteemSQL:

SELECT CONVERT(DATE, created) as Date, COUNT(*) as Posts
FROM Comments
WHERE parent_author=' ' AND depth=0 and created >= '2017/01/01' AND created < '2018/03/08' and category in ('promo-steem')
GROUP BY CONVERT(DATE, created)
ORDER BY CONVERT(DATE, created) DESC

Just change the word 'promo-steem' to whatever tag you want (inside of the ' ' quotes) and you can run a search on pretty much any tag. You might also want to alter the date range too!


Love, light and laughter


Anarcotech x

promo-steem appearing at the London Cryptocurrency Show 14 April 2018

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:  

What a great GRAPH! Very proud of you man.... you are now a 100% undiluted, definitive, unadulterated , authenticated, certified and verified GEEK!!. This is really great and valuable work thanks. SteemSQL-ON!!

I love the fact you struckout unadulterated! Thanks dude.

Glad to see @promo-steem is a successful project.

My 2 cents about your query:

parent_author=' ' AND depth=0

Both filter are redundant. And using parent_author=' ' will slow down your query even more as this column is not indexed.

category in ('promo-steem')

Better to use category = 'promo-steem'

Thanks so much for the input! I will clearly have to come along and have a chat in the SteemSQL room.

Thank to who created promo-steem tag, thanks to brother @@@anarcotech, success always for you and for all stemian arround the world, greeting friendship from me @abialfatih

Congratulations to "us". Yaaaaay!

this is an incredible achievement and I'm sure the future will be more phenomenal from now on because I see so many people who use the #promo-steem tag especially for those who promote steemit and it's my reference that I'm sure the future will be more phenomenal again and maybe could be the main tranding that will be loaded every news throughout the media in the world.
with the hard work of the team and the strong confidence and determination to do what can help the world's people.
I personally want to take part of the growth that will happen in the future.
greeting me respectfully.
sorry if there is an error in my comment

Well I haven't used this tag since I joined this platform, how does it help?

This is the tag to which anyone can post who does great work to promote the steem block chain or any part of it. The idea is that whales can then easily find this work and up vote it

Hi @starkerz and @anarcotech, I just wanted to let you know I made a post about important projects to delegate, and mentioned you and @steem-ambassador

Reason #2 - Uncountable Reasons to Power Up your Steem! - You can Earn Interest by Delegating Steem Power

Looking forward to your feedback!

Regards, @gold84

Thanks! Awesome work!!

  ·  7 years ago (edited)

@starkerz I found the right person @toofasteddie that has made and adaptation of another bid bot to make daily payouts. He mentioned that @yabapmatt (creator of bottracker) can help with this..

By the way, I just wrote reason 3 for powering up!
https://steemit.com/promo-steem/@gold84/reason-3-uncountable-reasons-to-power-up-your-steem-you-can-get-the-needed-funds-to-start-a-project-just-by-posting-about-it

Hope all this is helping new people understand the magic of the steem blockchain.

Regards, @gold84

Full details here in the community guidelines

Wow likes your post .. happy reading it .. really amazing ... thanks for sharing on a good day.
I like to read every post you .. I also learn a lot about steemit from every post you. Whether it's writing or photos. Thank you steemians ..
It's an honor for me if you visit my blog ..
@imranpase

I am happy about this, thank God I have started promoting too and seeing this will encourage me the more. However, after promotion my team members always have issues signing up, out of 100% of my team members just about 20% has successfully opened account. This has been happening from the week I joined and started telling people about Steemit. For a plankton like me I don't have enough funds to help them open account via other means like Steem invite, Block trades and the rest. I hope this is resolved soon.

Yes us too. Hopefully something which is being addressed in forthcoming Hard Forks.

Ok, let's hope for the best

There is massive growth growth and improvement in the family..Keep up the good work with all the inspiration you give to some of us..The promo-steem project has been more than very helpful to some of us and everyone is committed to ensure the sustainability and the growth of it..Good to see you share this, @anarcotech

The promo-steem tag is the very first tag I came to know about since I was introduced to steemit a month ago. Iam happy to see it grow quickly.
Thanks for that wonderful tutorial

My favourite tag on steemit. 'Promo-steem' I am always glad to contribute my quota to this steem. @anarcotech

I am pretty sure to the project of #promo-steem and I am going to work hard for it in Indonesia. THanks for the lesson. Wish All The Best.

Regards

Thank you my friend! Always good to get your support.

Congratulations! Your post has been selected as a daily Steemit truffle! It is listed on rank 20 of all contributions awarded today. You can find the TOP DAILY TRUFFLE PICKS HERE.

I upvoted your contribution because to my mind your post is at least 22 SBD worth and should receive 60 votes. It's now up to the lovely Steemit community to make this come true.

I am TrufflePig, an Artificial Intelligence Bot that helps minnows and content curators using Machine Learning. If you are curious how I select content, you can find an explanation here!

Have a nice day and sincerely yours,
trufflepig
TrufflePig

That's great. It good to see that 'promo-steem' project was a successful one.