Use Python to Discover Your Biggest Fans
Who is YOUR community?
This is not hypothetical if you want to grow a social account, a Hive presence, or a business.
Your community is a subset, so you can't say "Hive", "bloggers", or even "weekend bloggers over 50 years old" because that is your niche that you try to address, but they are not YOURs.
Judging Your Fans
On Hive we can quantify this in a couple of ways. The first would be who votes for you the most.
Now, of course, we had a Steem/Hive schism so that if we were being really correct about this I would filter out Steem from Hive, but for the sake of this exercise let's pretend that never happened!
Counting Votes
Here are my top 20 voters and how many votes they have made.
Yep, it is pretty clear I owe @themarkymark a case of beer or twenty.
themarkymark 422
rawpride 238
tpvoter1 220
buildawhale 217
upmyvote 211
share4every1 208
taukproung85 200
dmxmaster 186
sbi3 185
ipromote 171
bssman 155
abh12345.stem 149
enforcer48 144
mytechtrail 140
drmake 126
pbock 118
recoveryinc 109
yggdrasil.laguna 105
stemcur 89
stemisaria 87
How did I get this information? Via the magic of HiveSQL which I wrote a tutorial about previously.
This allows us to very quickly not just list all the votes on our blog, but also count them up, group them AND order the result!
select top(20) voter, count(voter) as votes
from TxVotes where author='makerhacks'
group by voter order by votes desc
We translate this into:
- Get only the top 20 results.
- Return the voter name and the number of times that person voted as 'votes'.
- From vote transactions.
- Where they were voting on my post.
- Group by voter name.
- List with the biggest first.
Votes might be the most financially rewarding, but not be the best way to measure who is your biggest fan, though. What else is there?
Let's look at the data ...
Comments, that looks promising!
Top Commenters
Gosh darn it there is Marky again. I am starting to think everyone here is two Marks in a trenchcoat ...
TOP COMMENTERS
@themarkymark 104
@hivebuzz 53
@pbock 33
@steemmakers 33
@steemitboard 32
@mytechtrail 31
@enforcer48 29
@geekpowered 27
@drmake 26
@turkishcrew 26
@lextenebris 24
@postpromoter 24
@leaky20 22
@boucaron 21
@buildawhale 20
@ipromote 18
@netscape101 17
@steampunkkaja 15
@captainglondo 14
@chefbgob 14
In this case, the SQL is very much the same just with field names and tables changed:
select top(20) author, count(author) as comment_count
from comments where parent_author='makerhacks' and not author='makerhacks'
group by author order by comment_count desc;
We want all the comments where they were replying to something I wrote but the comment was not by me.
Reblogs?
On your account, you might look at who reblogs you the most, there is data for that. I thought I very rarely get reblogged but it seems there have been a lot more than I remember!
select top(10) account, count(account) as reblogged from reblogs where author='makerhacks' group by account order by reblogged desc;
Who Doesn't Like Me?
You could go the other way and see who has you muted ...
select * from mutes where muted='makerhacks';
Only 4 people have muted me? I must up my game! Hmm that means I can say what I like about them and they won't know, right? ;)
@marshmellowman
@thepholosopher
@tonygreene113
@mhsiemaszko
I would like to pretend downvotes will raise your mute count significantly, but not that many people mute me either. Lol
Hmm downvotes is a good one
@goidt, 'downvotes': 3
@matt-a, 'downvotes': 2
@sachincool, 'downvotes': 2
@stem.curate, 'downvotes': 2
@thevote, 'downvotes': 2
@timm, 'downvotes': 1
@tonygreene113, 'downvotes': 1
Unsurprisingly Tony appears on both this and the mute list ;)
Yea...one downvote over nearly 5 years should be a good ratio for you...lol
Hang on, how did you see this if you muted me? :o
Your juju has a flaw?
Guess it is just my magnetic personality 🤔
This really gets down to one of the core problems of understanding social media and self-promotion – deciding what "good" means. It can and should vary for pretty much everyone, which is an absolute fact which is overlooked most of the time when you talk about various metrics.
For me, personally, comment engagement is one of the best metrics out there. Not just "number of comments left," but "number of threads in which there is multiple posts by a single commentor." Anyone can leave one comment but very few people engage in conversations; those of the people who either hate you enough or love you enough to really talk about what you're doing.
But that's just my metric.
Good point … It’s interesting how often comments on Hive seem to be just for visibility, but it’s even worse in DeSo which is supposed to be just for conversation - to the point replies seem to be actively hidden in the main apps.
I keep coming back to the idea of making a new UI for Hive myself that encouraged conversation but I fear I’d be the only user.
I can't help but wonder what you did to piss off @thepholosopher, given the other two people on her mute list. I could understand if it were the other way round, all things considered. The same goes for @marshmellowman, since you're the only person he's muted, though I don't follow him, so I don't really know what he's about. The other two have quite long lists of muted people, so that's not something you should take personally.
I may have to find out who's muted me! I have a feeling I already know one name I'm going to find on that list!
Could be any number of things and could be nothing.
Someone accused me of being a marxist on twitter recently even though my profile clearly says my day job is as a marketing director.
I've been accused of trying to take folks' guns away in a thread containing a video of me at the gun range.
People see what they want to see :)
I have been quite open about the fact that I wear an N95 mask and am vaccinated, due to the fact I have a bunch of vulnerable people I can't risk. That and my dislike for Q/45/flat-earth/incels/white nationalists/etc means I piss off a lot of people just as a regular daily thing and there is nothing I can do about that.
Probably the most hate I got was when I said I didn't see a problem with female space marines, though.
Oh dear, you don't have a problem with female space marines? Neither do I, even though I'm willing to acknowledge that goes against the lore... well, the current lore, anyway, since 40K's fluff is wildly inconsistent. I may have to watch myself, but then, I'm Necron player, so why should I care?
I can certainly sympathise with the idea that people see what they want to. False dichotomies make it easier to dehumanise the "other." Communists see me as a science-denying creationist, and creationists see me as a godless communist, even though neither of those things are true (well, the "godless" part is true). It gets wearisome after a while.
Ha yep the other day someone said I was a centrist as an insult, I think they actually meant "decides based on the specific issue and the currently available evidence around it" and that was too long to write ;)
The with us or against us team-sport/tribal stuff will be the end of humanity I am sure!
A centrist, you say? Well, aren't you a filthy little fence-sitter! I jest, of course, but I'm a little more optimistic - "us vs them" tribalism has been around forever. If that sort of thinking were to end humanity, I think it would have happened by now. Every time something happens that seems like the end of the world, it too passes.
I like your attitude :)
This year I was supposed to keep positive and that lasted about ten minutes. It's probably social media/trad media amplification rather than anything real I see. Discord gets clicks a lot more than agreement!
It was strictly a mute back....not sure what i did for @makerhacks to mute me...maybe after i went an joined him for being in the same Canada room and liking and fallowing him based on a room he was in, commenting and voting his work.... I see value to what he is bring to the community as displayed by this post. I may just un-mute him. Or perhaps a finger slipped and a button was hit and it was never meant to go that way...i do not know what happened on his end.
Ill lat that stand there as i read down at more comments.....umm alright so @makerhacks says "That and my dislike for Q/45/flat-earth/incels/white nationalists/etc means I piss off a lot of people just as a regular daily thing and there is nothing I can do about that." Wow, so you know all about me and what i believe, i am not sure what you even mean by half of your list (45/incels/ ...) and i guess you know more about what i do not talk about then even i do. ....humm right alright so perhaps you should look the other way and not click on the memehive room....that would be personal responsibility. Something it seem you want to take way from other by wearing your mask....right check good boy. Ill un-mute you now because i can see value in differing of opinions and I will still learn from those that are supreme stuck in their ways not willing to hear others opinions after clicking on the page to open waiting to load read scroll read scroll and then get offended at the other. What a wonderful world.
You may want to post into specific communities depending on your posts, may get you some more visibility and curation from folk interested in the subject and have an easier time finding you.
https://peakd.com/c/hive-169321/created
for instance^
I am always a bit nervous around communities, especially because I post every day - bit shy about being seen as over-posting or spamming
Eh nothing to worry about, if they think that they often give you a warning first. In general it's just better to make use of communities than not as you may miss out on a lot of new followers by not posting there, especially followers that are interested in what you post about which is even better, else the only way they could find you is through reblogs or other various small and low odd ways.
I will give that more of a try - thanks for the advice! :)
If anyone gets mad I will tell them you forced me into it ;)
xD
Wow, this is really cool! I remember playing around with SteemReports back in 2018. I even mentioned it in #theterminal Discord server recently, asking if there was something comparable here on HIVE. What you have posted here is the closest to the functionality of the old SteemReports network influence map that I've seen here yet.
I’d heard of Hive SQL and this gives it some greater context. I’ll try this out but I’m still just a small account right now.
Great post .... I gotta check this out some time !! Judst not now ... I busy ranting on my Friday music blog {sigh}