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.
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.
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
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!!Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I love the fact you struckout unadulterated! Thanks dude.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Glad to see @promo-steem is a successful project.
My 2 cents about your query:
Both filter are redundant. And using
parent_author=' '
will slow down your query even more as this column is not indexed.Better to use
category = 'promo-steem'
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks so much for the input! I will clearly have to come along and have a chat in the SteemSQL room.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Congratulations to "us". Yaaaaay!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Well I haven't used this tag since I joined this platform, how does it help?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks! Awesome work!!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Full details here in the community guidelines
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Yes us too. Hopefully something which is being addressed in forthcoming Hard Forks.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Ok, let's hope for the best
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
My favourite tag on steemit. 'Promo-steem' I am always glad to contribute my quota to this steem. @anarcotech
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you my friend! Always good to get your support.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
That's great. It good to see that 'promo-steem' project was a successful one.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit