Another one, and a great data-dive idea by @charisma777, who (picked up a follow for proof of brain!) and wanted to know which were the most commented on posts with the tag #informationfinding.
I can see this being useful for those of us who've used a custom tag, perhaps to invite others to use the same tag for a competition entry or to try to raise the awareness and get the tag listed in the 'All tags' menu.
I've seen many users define a new tag and run with it, encouraging other Steemians to use the tag in their posts. And in time, you can see communities growing around these tags, which is super awesome!
walkwithme, gifteconomy, #steemgigs, steemfest, newbieresteemday, witness-category, slothicoin, teardrops, etc, etc
I think there could be some interest here :D
The list will look something like this, and these are the results from the #informationfinding tag:
| Created | Author | Link | Count |
|---|---|---|---|
| 1/26/2018 | apolymask | information-finding-championship-season-1-round-1-150-steem- | 95 |
| 2/19/2018 | markkennard | an-up-and-coming-steemian-with-great-content | 64 |
| 1/28/2018 | apolymask | information-finding-championship-season-1-round-3-150-steem- | 50 |
| 3/11/2018 | apolymask | information-finding-championship-season-1-round-16 | 49 |
| 1/30/2018 | nxtblg | information-finding-championship-season-1-round-4-entry | 45 |
| 2/18/2018 | apolymask | information-finding-championship-season-1-round-10 | 41 |
| 1/27/2018 | apolymask | information-finding-championship-season-1-round-2-150-steem- | 39 |
| 2/17/2018 | apolymask | information-finding-championship-season-1-round-9 | 38 |
| 2/11/2018 | apolymask | information-finding-championship-season-1-round-8 | 37 |
| 3/1/2018 | amariespeaks | information-finding-championship-season-1-round-12-entry-wat | 37 |
The query looks at the 'category' metadata, and each of the 5 possible tags (I think the 'category' is the same as the first tag?) that can be assigned to a post. 'Count' is the number of comments the post has received.
The smallprint
This query takes some time to run (12 - 18 minutes in testing) and I'm likely to receive a phone call from @arcange if I pummel his DataBase too much!
Depending on the number of responses, I'm unlikely to fulfill all requests this time, and I'd prefer to see suggestions of tags that are not amongst the most popular.
Comment counts could be slightly off if the post is still 'active'.
Other posts like this one
Your Top 10 most engaging posts by comment count - Get your list here!
Your Top 10 most resteemed posts - Get your list here!
Do you want to know what your top 20 most rewarded votes were in the past 2 weeks?
If you think this information would be useful to someone, or a community, pass the message on!
Thanks!
Asher @abh12345
Thank you so much for pulling this for us! This will be useful for sure, much appreciated! Thanks again @abh12345!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
if you are free from work then only share otherwise all gucci ;p my tag would be life ; )
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Life! Pick a quiet tag will ya? :D
The 10 most popular posts by number of comments in the tag, #life!
And the top one is Spam! hahaha
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Good morning Asher. I don’t see my team here yet so I will make this request. Could you query #newbieresteemday?
Only if you have time, some might want to know about #newbiegames too. Thank you!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Good morning!
#newbieresteemday is the first official request :D
I hope it's of use and/or interest!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you! We always encourage our newbies to enter @danielsaori’s Steemit Comment Challenge. Happy to see Daniel’s comment challenge are top performers for comment count!
@davemmcoy and @terminallyill would be happy to know they made the list too. Funny that my teammate, Mello, made it on with his Super Bowl contest that inspired his regular NBA contest, hehe.
Thanks again Asher. Have a great day!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I'm glad you like what you see and I'm sure @danielsaori will too.
Go #newbieresteemday :D
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Wow! cool stuff. Thanks for the stats Asher. :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
My pleasure :)
If you have another tag you'd like to see the data for, or any other stats ideas let me know, cheers!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This was really interesting and helpful to look at! Thanks for sharing and also thanks to @charisma777 for requesting it as well! :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks @apolymask!
I've just been looking around your blog and at the resteems - still figuring out what's going on but it looks like you have an engaged community over there, nice one!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
You're welcome. Credit where credit is due. :) And oh? Cool. Yeah.. It's getting off to a great start in my opinion! Only a little more than a month into this and we're learning and still in our baby steps, yet.. I think we have around 50 people on our discord and two witnesses helping to sponsor our contest, plus a bunch of other really positive things are happening! So.. Yeah.. It's looking really good so far! Though.. It's hard keeping up with it all sometimes. ._. Thanks for the feedback! :D
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
The site isn't perfect yet but ongoing. Open-source as well, so we can move faster. Thank you for still remembering the tag ALOT
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hey, nice!
Let me know when it's up, and thank you for the RS!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
https://steemit.com/steemgigs/@surpassinggoogle/the-grand-picture-the-detailed-faq-s-for-https-steemgigs-org-and-all-the-answers-please-bookmark-this
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hi Terry, thanks for the link - glad to see Steemgigs looking better than ever!
I will certainly offer my 'adhoc crazy stats service' on there soon!
Thank you for this longstanding and awesome initiative :D
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
you must be looking to win an award for the most engaging posts Asher. Sure go on and run blockchainbi stats
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I'll take 50k delegation, sure :D
If comments mean the post is engaging, then yeah i'm doing alright this week!
#blockchainbi - execution time: 17:19
Err, a little embarrassing here! haha :D
I'll run it again later without me included!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
lovely, I thought it would show something like that
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
And without me, it's the @paulag show :D
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
you should not have re-run the query to exclude you - say it loud and say it proud - and at least a few names show up beside me - your just a totally awesome steemain...
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
awww <333
Thanks Paula, that is very kind of you to say so! Who needs $500 posts when you get comments like this :D
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hi! I love your new initiative to create a top-sheets! It is very interesting and saves time! In addition, we see what is popular! That's awesome! Thank you! I'll think about it.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you!
I'm trying to help, and it's good to share information and 'popular' posts, even if they are old :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Ooooo. You name dropper you @abh12345. "I'm likely to receive a phone call from @arcange". You're on phone number swapping terms, eh? I'm going to have to check him/her out! 😁
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@abh1245 did the right thing, to call the most appropriate person to help.
BTW, if you have some free witness vote, yours is very welcome :D
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
He owns the DataBase I subscribe to :D
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I notice he's a witness too so I'll take a closer look from that perspective. 😊
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This doesn't look like the best time of the day to post!
I thought I'd get a few requests, but apparently not! :D
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Maybe not only the time of day @abh12345. I was all ready to jump straight in and really please to see one in the morning (for me) but the topic wasn't really relevant.
I've only ever created one tag of my own and didn't use it for long enough for the results to be of interest.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Yes that's ok, I gave the post a boost hoping to reach some 'community leader' type people who've been promoting a tag, like the ones mentioned above.
I'm going to run #walkwithme myself seeing as I have no 'work' to do yet!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Now you come to mention it, that's somthing I would be really interested in knowing . . . what days/times of day bring me the most comments.
I was using Steem activity but it doesn't seem to be working now and I'm not sure have useful it is.
So now, if I'm able to choose, I just post when I notice there seems to be more activity on GINA, although activity is sooooooo low right now.
Sometimes hours pass and there are no posts at all in the "new" tag.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Good one!
I've added it to the list. No promisises but I can see people being intereted in that :)
I suspect it will follow, the time of day you create your blog, as most comments come in the first hour after creation, at least for me anyway :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hi @abh12345. I wonder if you could help us with the SQL code for this one.
I'm trying to find out how many posts use our #newbieresteemday tag, weekly, monthly, or all time.
As you know @mellofello from our team likes BI and data. He is stubborn though so refuses to subscribe or 'pay' for steemSQL, even though I saved the SBD in the account for when he needs it.
So his bright idea is to query the data directly from the steem blockchain. Or some API layer of it with Privex SBSD (whatever that means). He has successfully done so (or thinks he has since he was able to query our acct's data).
Issue is, he's not sure what the search parameters would be used for 'tags'. I remembered this post of yours, and thought any guidance on tables/field names might be helpful to him.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I have sent beeYOU a message on discord :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
wow you are doing so much work for everyone this is truly amazing
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Wonderful post.
Thanks for sharing this information.
I appreciate your post.. resteemit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
its really helpful.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
i can't get it sir... what tag should i give to you?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
good post :) thanks for sharing @abh12345
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Interesting to see that tags created can influence the amount of comments on given post. The data can be useful in writing content that will attract a lot of post engagements and comments also. Great post @abh12345
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Good post :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
great post
awsome post
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Oh another one.. You've shown to me last time my top 10 post that has been resteemed.. now top 10 post got numerous of comments .. very nice!!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
#walkwithme
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This is cent percent good content,infact great content,Thanks a lot for sharing following you.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you! :D
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Not cool to just copy my text and use it as a reply!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
The reputation score of the user speaks volumes :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Indeed it does!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit