resteem.com - Is this re-steeming service worth it? #bisteemit investigates...

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