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 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
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? ;)
