Analysis into how many true followers these services really have - Is $2 good value to re-steem your post for you?
edited from source
Introducing resteem.com
So you may have seen in your Wallet recently, a memo from @carlobelgado looking something like this:
Not seen this memo in the last 3 days? Sorry, you are not one of the lucky 2339 who have had this privilege!
Carlo, and his business partner @joanaltres offer a re-steem service for 2 SBD or 2 Steem and, as far as I am aware, are the longest service of this kind on the Steem Blockchain.
The following image is taken from their website - resteem.com
As you can see, the site looks quite professional, and the service boasts the ability to send to over 32,000 followers - and over 35,000 followers in the recent memo I received.
Sounds good - but lets have a look at the data before we send our crypto, eh?
Follower analysis
Using @arcange's lovely SteemSQL database, I've been doing a little data mining to see if these numbers add up, and if it's a wise decision to send crypto to this service.
Firstly, lets check how many followers they have combined:
SELECT count(*)
FROM [SQL.STEEMSQL.COM].[DBSteem].[dbo].[Followers] a WITH (NOLOCK)
WHERE following in ('carlobelgado','joanaltres')
= 35483
Looking good, even more than advertised!
Next, lets check how many followers they have combined, that do not appear as followers by both accounts:
SELECT DISTINCT follower
FROM [SQL.STEEMSQL.COM].[DBSteem].[dbo].[Followers] a WITH (NOLOCK)
WHERE following in ('carlobelgado','joanaltres')
= 23152
Hmmm, so that's a little less than advertised - the re-steem will reach this many unique accounts.
So this isn't too bad, the re-steem will still be going out to over 20,000 users. I wonder how many of them are 'active'?
In this example, I've chosen an active user to be someone who has voted in the past month - 31 days:
SELECT distinct follower
FROM [SQL.STEEMSQL.COM].[DBSteem].[dbo].[Followers] f WITH (NOLOCK)
INNER JOIN [SQL.STEEMSQL.COM].[DBSteem].[dbo].[Accounts] a ON f.follower = a.name
WHERE following in ('carlobelgado','joanaltres')
AND [last_vote_time] NOT BETWEEN GETDATE()-31 AND GETDATE()
= 10003
Just over 10000 of these users have voted in the past month.
And in the past week?
= 6530
The number of users likely to see (and potentially vote) on your blog looks to be around 80% less than the number I received in the memo yesterday.
Catch a whale, or dolphin?
While the above numbers look less promising than what's advertised, lets see if we could possibly catch a dolphin, or even a whale with this re-steem service.
The number of accounts with Steem Power greater than 5000 and less than 100,000 which are following this service, and have voted in the past month:
SELECT distinct follower
FROM [Followers] f WITH (NOLOCK)
INNER JOIN [Accounts] a ON f.follower = a.name
WHERE ((cast(left(vesting_shares, len(vesting_shares)-6) as float)486.681/1000000) > cast(5000 as float) AND >
(cast(left(vesting_shares, len(vesting_shares)-6) as float)486.681/1000000) < cast(100000 as float))
AND [last_vote_time] BETWEEN GETDATE()-31 AND GETDATE()
AND following in ('carlobelgado','joanaltres')
= 161
The number of accounts with Steem Power greater than 100,000, which are following this service, and have voted in the past month:
SELECT distinct follower
FROM [Followers] f WITH (NOLOCK)
INNER JOIN [Accounts] a ON f.follower = a.name
WHERE (cast(left(vesting_shares, len(vesting_shares)-6) as float)*486.681/1000000) > cast(100000 as float)
AND [last_vote_time] BETWEEN GETDATE()-31 AND GETDATE()
AND following in ('carlobelgado','joanaltres')
= 9
Not a vast number of big accounts looking at these re-steemed blogs at all.
Summary
Overall, the data behind this service is disappointing to me.
Clearly the numbers advertised are misleading as the account have a lot of overlap with regards to their followers.
Obviously, you cant expect every user who sees the re-steem to vote, but there are a lot less 'active' users than the number of followers stated by the memo and website.
The number of larger accounts that are following this service and 'active', total a very small percentage of the users who will see the re-steemed blog.
In conclusion, I think that 2 SBD or 2 Steem is a high enough price to pay for a re-steem. My suggestion.... write an awesome blog :)
Has anyone found success with resteem.com or do you have any tales of disappointment to share?
Edit: I just received another memo promoting the service - Should I send this blog and see what happens?
awwwww
I am part of a Steemit Business Intelligence community. We all post under the tag #bisteemit. If you have analysis you would like to be carried out on Steemit data, please do contact me or any of the #bisteemit team and we will do our best to help you.
I am contactable on many discord channels under the same username.
Data was extracted for these reports at 11:00am CET on 11th November 2017
Thanks for reading
Asher