create account


advanced mode

Steemit Retention Part 2 – Business Intelligence Steemit by paulag

View this thread on steemit.com
View on official site
· @paulag ·
$29.74
Steemit Retention Part 2 – Business Intelligence Steemit
<html>
<p>Yesterday we looked in detail at Retention for Authors, and we calculated the 60 day retention rate to be 23.3%. However as we all know, Steemit is not just about Authors. &nbsp;It is also about Curators.</p>
<p>In this article, we are going to analyse steemit data for votes to try and calculate the retention rate for Curators.</p>
<p>If you missed yesterday’s analysis you can find it here</p>
<p>https://steemit.com/bisteemit/@paulag/steemit-retention-part-1-business-intelligence-steemit</p>
<p>In the final post, we will combine the results for part 1 and 2 of this analysis and see how Steemit preforms against other social media platforms</p>
<h2>Curator Retention</h2>
<p>Just so you have the values handy, the chart below shows the number of new accounts registered by month for both 2016 in black and 2017 in turquoise.</p>
<p>https://steemitimages.com/DQmS1D9YdEQgdxZzVGtb3KBD1HRxqgmcWSjL3szxsj8Tycc/1.png</p>
<h3>High level overview</h3>
<p>&nbsp;https://steemitimages.com/DQmbTy3nXN2DYMeEPqNMv2FT4e23xLjutfT9XoDhm1kd6Aq/1.png&nbsp;</p>
<p>The first thing I, and probably you, notice from this data is that nearly every account that has registered on Steemit has placed at least 1 vote. &nbsp;There are only 2 accounts out of 361k that have not voted.</p>
<p>In the pie chart it is clear to see, although every account has voted, there is a big drop off. &nbsp;Over 57% of accounts have not voted in the last 60 days. &nbsp;There is however over 28% (102K) of the registered accounts actually voting in the last 30 days. &nbsp;This is nice and high as only 52K accounts actually posted or commented in the last 30 day.</p>
<h3>2016</h3>
<p>&nbsp;https://steemitimages.com/DQmVnUNQBm7EAMyTVX75oWiu4urPqP5VCBvqywLpmx9MUEZ/2.png&nbsp;</p>
<p>There were 118K accounts registered on Steemit in 2016, however only 11k of these accounts (&lt;10%) have voted in the last 60 days</p>
<p>The chart on the right shows by month of registration, the % of users that are actively, or not actively voting.</p>
<h3>2017</h3>
<p>&nbsp;https://steemitimages.com/DQmda1m2pDwgWoJWggH6w9xQBee2AJ9LigPuy7Jos4i5s25/3.png&nbsp;</p>
<p>The visualisations for 2017 shows a much more promising situation. &nbsp;58% of accounts registered have voted in the last 60 day. &nbsp;You must keep in mind that 32% of the accounts registered in 2017 have also registered in the last 60%. &nbsp;This would mean that 26% of accounts registered Between Jan and mid-July are have voted in the last 60 days.</p>
<h3>Clusters and Outlier's</h3>
<p>The last analysis I carried out on the data was to look at the overall clusters and outliers between the number of days accounts have been registered on steemit and the voting ‘active days’.</p>
<p>To calculate the ‘active days’ of a curator I took the last vote date for each user and deducted the account creation date.</p>
<p>https://steemitimages.com/DQmaq7xpDuxyKxz4M9Lm4HsrE5fGVdgopqd9wHqsyC1fcbV/4.png&nbsp;</p>
<p>The Red mass going up the Days Registered on the left give an indication of the number of curators that were only active for a very short period of time, like days. &nbsp;The further to the right that you move on the chart shows users that have remained active on steemit over time</p>
<p>I was expecting to see a cluster around the 0-100 days registered because there has been a spike in new users during this time</p>
<h2>Steemit Curator Retention Rate</h2>
<p>In yesterday’s post I introduced you to the calculation for retention. &nbsp;We are going to calculate the 60 day retention rate for curators</p>
<p>Retention Rate = (CE/CN)) X 100</p>
<p>CE = number of users at end of period (that have voted in the last 60 days)= 152K</p>
<p>CN = number of new users acquired during period = 358K</p>
<p>therefore : 152k / 358k = .424 x 100 &nbsp;= 42.4%</p>
<p><strong>Curator retention calculated to be 42.4% of total users.</strong></p>
<p>All of the data taken in this report was from the superb steemsql managed by @arcange. &nbsp;</p>
<p>I have used Power BI to connect to steemsql and then used DAX calculations for the analysis.</p>
<p><em><strong>&nbsp;I am part of a Steemit Business Intelligence community. We all post under the tag #BIsteemit. If you have an analysis you would like carried out on Steemit data, please do contact me or any of the #bisteemit team and we will do our best to help you...</strong></em></p>
<h2>you can find #bisteemit &nbsp;on discord https://discordapp.com/invite/JN7Yv7j</h2>
<h1>Follow, upvote and resteem&nbsp;</h1>
<p><br></p>
</html>
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
json_metadata{"tags":["bisteemit","marketing","steemit","success","news"],"users":["arcange"],"image":["https://steemitimages.com/DQmS1D9YdEQgdxZzVGtb3KBD1HRxqgmcWSjL3szxsj8Tycc/1.png","https://steemitimages.com/DQmbTy3nXN2DYMeEPqNMv2FT4e23xLjutfT9XoDhm1kd6Aq/1.png","https://steemitimages.com/DQmVnUNQBm7EAMyTVX75oWiu4urPqP5VCBvqywLpmx9MUEZ/2.png","https://steemitimages.com/DQmda1m2pDwgWoJWggH6w9xQBee2AJ9LigPuy7Jos4i5s25/3.png","https://steemitimages.com/DQmaq7xpDuxyKxz4M9Lm4HsrE5fGVdgopqd9wHqsyC1fcbV/4.png"],"links":["https://steemit.com/bisteemit/@paulag/steemit-retention-part-1-business-intelligence-steemit","https://discordapp.com/invite/JN7Yv7j"],"app":"steemit/0.1","format":"html"}
created2017-09-13 16:21:18
active2017-09-18 14:23:42
last_payout2017-09-20 16:21:18
depth0
children36
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value23.235 SBD
curator_payout_value6.507 SBD
author_rewards20,709
net_votes98
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation5,946,479,536,953
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (98)

vote your-acct "paulag" "steemit-retention-part-2-business-intelligence-steemit" 100 true
post_comment your-acct "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454784z" "paulag" "steemit-retention-part-2-business-intelligence-steemit" "" "your reply.." "{}" true

View on official site
@sabbir24 · (edited)
nice information,thanks for sharing
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
last_update2017-09-13 16:25:00
created2017-09-13 16:24:45
active2017-09-13 18:45:18
last_payout2017-09-20 16:24:45
depth1
children1
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation274,690,591,711
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "sabbir24" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t162435732z" 100 true
post_comment your-acct "re-sabbir24-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454791z" "sabbir24" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t162435732z" "" "your reply.." "{}" true

View on official site
@paulag ·
you are welcome
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-13 18:45:18
active2017-09-13 18:45:18
last_payout2017-09-20 18:45:18
depth2
children0
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation5,946,479,536,953
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "paulag" "re-sabbir24-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t184521599z" 100 true
post_comment your-acct "re-paulag-re-sabbir24-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454798z" "paulag" "re-sabbir24-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t184521599z" "" "your reply.." "{}" true

View on official site
@orhun ·
@paulag Sharing to have this witnessed far more (and perhaps open up the eyes of some)! Thanks  for the properly put up and documented report! Resteemed.
json_metadata{"tags":["bisteemit"],"users":["paulag"],"app":"steemit/0.1"}
created2017-09-13 16:50:33
active2017-09-13 16:50:33
last_payout2017-09-20 16:50:33
depth1
children0
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation-99,234,576,842
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "orhun" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t165033229z" 100 true
post_comment your-acct "re-orhun-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454805z" "orhun" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t165033229z" "" "your reply.." "{}" true

View on official site
@valued-customer ·
Thanks for doing this work.

I think either I misunderstand the way the calculation works, or the data needs to be filtered by time a bit.

If you take the data for the last 60 days and run your calculation, you will find the retention rate to be 100%, since every account votes at least once, and no account therefore will not have voted in the last 60 days.

I reckon you need to exclude the last 60 days of new accounts from the calculation in order to prevent the data from being skewed.

Or do I misunderstand?
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-13 16:57:36
active2017-09-18 14:23:42
last_payout2017-09-20 16:57:36
depth1
children11
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation1,828,487,362,424
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "valued-customer" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t165726156z" 100 true
post_comment your-acct "re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454811z" "valued-customer" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t165726156z" "" "your reply.." "{}" true

View on official site
@paulag ·
Yes, I have pointed this out in the article
👍  
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-13 17:13:48
active2017-09-18 14:23:42
last_payout2017-09-20 17:13:48
depth2
children10
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes1
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation5,946,479,536,953
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (1)

vote your-acct "paulag" "re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t171350592z" 100 true
post_comment your-acct "re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454818z" "paulag" "re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t171350592z" "" "your reply.." "{}" true

View on official site
@valued-customer ·
>"therefore : 152k / 358k = .424 x 100  = 42.4%"

But this figure includes those who joined since mid-July.

>"You must keep in mind that 32% of the accounts registered in 2017 have also registered in the last 60%.  This would mean that 26% of accounts registered Between Jan and mid-July are have voted in the last 60 days."

This would seem to be the correct percentage, rather than the calculation above, since it does not include the accounts that joined within the last 60 days.

Except that it excludes the accounts that joined in 2016.

>"There were 118K accounts registered on Steemit in 2016, however only 11k of these accounts (<10%) have voted in the last 60 days"

Which is significantly lower than even 26%.  

My guess is that, excluding the accounts that signed up in the last 60 days, the real retention rate is therefore between 26% and <10%.  Is this correct?
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-14 01:51:00
active2017-09-18 14:23:42
last_payout2017-09-21 01:51:00
depth3
children9
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation1,828,487,362,424
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "valued-customer" "re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170914t015048171z" 100 true
post_comment your-acct "re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454825z" "valued-customer" "re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170914t015048171z" "" "your reply.." "{}" true

View on official site
@paulag ·
I would tend to agree, however the 'official' formula for retention as shown about includes all uses to the end of the period being analysed.
👍  
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-14 07:53:45
active2017-09-18 14:23:42
last_payout2017-09-21 07:53:45
depth4
children8
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes1
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation5,946,479,536,953
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (1)

vote your-acct "paulag" "re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170914t075344338z" 100 true
post_comment your-acct "re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454832z" "paulag" "re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170914t075344338z" "" "your reply.." "{}" true

View on official site
@valued-customer ·
Can you provide the number of accounts that joined in 2017 up to mid-July, and the number of them that have voted in the last 60 days?  With that information I can figure the adjusted retention rate.  

Thanks!
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-14 09:17:27
active2017-09-14 09:17:27
last_payout2017-09-21 09:17:27
depth5
children0
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation1,828,487,362,424
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "valued-customer" "re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170914t091716880z" 100 true
post_comment your-acct "re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454838z" "valued-customer" "re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170914t091716880z" "" "your reply.." "{}" true

View on official site
@valued-customer · (edited)
if what we want to know is how many users stay for more than 60 days, accounts less than 60 days old are not useful data to ascertain that information.  No accounts less than 60 days old have stayed for 60 days.

If what we want to know is how many users are inactive for at least 60 days, again, accounts less than 60 days old aren't useful data.  Even if those users are no longer active, they can't have been inactive for more than 60 days.

In either case, including accounts less than 60 days old in calculating 60 day retention rates skews the data, as all the accounts less than 60 days old are 100% retained, and 0% of accounts less than 60 days old have voted for more than 60 days, according to the criteria, simply because they aren't 60 days old yet.

This is why I asked for the numbers excluding accounts less than 60 days old. You provided numbers for 2016, and provided a percentage for accounts more than 60 days old in 2017, but not the number of accounts, so I cannot add the 2017 number to the 2016 number and come up with a total.

Can you please provide the number of accounts for 2017 excluding those that are less than 60 days old?

Thanks!

Edit:  presently, the best calculation of long term retention is the figure you provide for 2016 accounts, as all of them have been accounts for more than 60 days.  This is <10%, and that is the apparent 1 year retention rate on Steemit.

For 2017, the percentage you provided that excludes accounts less than 60 days old is 26%.  I expect the real percentage of total accounts more than 60 days old - the only accounts that can provide relevant data for 60 day retention rate - is somewhere between 26% and <10%.
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
last_update2017-09-15 20:12:27
created2017-09-15 19:58:06
active2017-09-18 14:23:42
last_payout1970-01-01 00:00:00
depth5
children6
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time2017-09-22 19:58:06
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation1,828,487,362,424
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "valued-customer" "re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170915t195805976z" 100 true
post_comment your-acct "re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454844z" "valued-customer" "re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170915t195805976z" "" "your reply.." "{}" true

View on official site
@paulag ·
$0.02
you are looking at about 62K accounts in the last 60days
👍  
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-16 08:18:15
active2017-09-18 14:23:42
last_payout1970-01-01 00:00:00
depth6
children5
net_rshares6,290,435,791
vote_rshares6,290,435,791
children_abs_rshares0
cashout_time2017-09-23 08:18:15
max_cashout_time1969-12-31 23:59:59
total_vote_weight80,760
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes1
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.018 SBD
total_pending_payout_value0.000 STEEM
author_reputation5,946,479,536,953
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward0.00%
vote details (1)

vote your-acct "paulag" "re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170916t081817352z" 100 true
post_comment your-acct "re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454851z" "paulag" "re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170916t081817352z" "" "your reply.." "{}" true

View on official site
@valued-customer ·
So, if we exclude the 62k from both the total accounts, and the accounts that have voted in the last 60 days, we should have corrected for the effect of the criteria.

So 90k/296k = .30 * 100 = 30% overall.  I am flummoxed that this is not between 26% and 10%.  

Can you explain why?

Thanks!
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-16 14:52:33
active2017-09-18 14:23:42
last_payout1970-01-01 00:00:00
depth7
children4
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time2017-09-23 14:52:33
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation1,828,487,362,424
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "valued-customer" "re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170916t145230539z" 100 true
post_comment your-acct "re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454858z" "valued-customer" "re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170916t145230539z" "" "your reply.." "{}" true

View on official site
@paulag ·
$0.01
I would look at that calculation a different way

a) 152-90 = 62  (no of active accounts at end of period  - number of new accounts during period)

b) 62 / 296 = .2094   ( a / no of accounts at start of period)

.2094 * 100 = 20.94%.
👍  
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-17 22:23:45
active2017-09-18 14:23:42
last_payout1970-01-01 00:00:00
depth8
children3
net_rshares4,903,624,706
vote_rshares4,903,624,706
children_abs_rshares0
cashout_time2017-09-24 22:23:45
max_cashout_time1969-12-31 23:59:59
total_vote_weight70,179
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes1
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.014 SBD
total_pending_payout_value0.000 STEEM
author_reputation5,946,479,536,953
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward0.00%
vote details (1)

vote your-acct "paulag" "re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170917t222346706z" 100 true
post_comment your-acct "re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454864z" "paulag" "re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170917t222346706z" "" "your reply.." "{}" true

View on official site
@valued-customer ·
Welp, this is why I turn to you for your insights =D  

Thanks much!
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-18 05:55:21
active2017-09-18 14:23:42
last_payout1970-01-01 00:00:00
depth9
children2
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time2017-09-25 05:55:21
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation1,828,487,362,424
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "valued-customer" "re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170918t055514094z" 100 true
post_comment your-acct "re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454870z" "valued-customer" "re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170918t055514094z" "" "your reply.." "{}" true

View on official site
@paulag ·
$0.01
You are most welcome, especially since you had to wait some time for a response from me
👍  
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-18 09:00:27
active2017-09-18 14:23:42
last_payout1970-01-01 00:00:00
depth10
children1
net_rshares5,142,825,912
vote_rshares5,142,825,912
children_abs_rshares0
cashout_time2017-09-25 09:00:27
max_cashout_time1969-12-31 23:59:59
total_vote_weight72,004
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes1
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.014 SBD
total_pending_payout_value0.000 STEEM
author_reputation5,946,479,536,953
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward0.00%
vote details (1)

vote your-acct "paulag" "re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170918t090029701z" 100 true
post_comment your-acct "re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454877z" "paulag" "re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170918t090029701z" "" "your reply.." "{}" true

View on official site
@valued-customer ·
I'd much rather wait for the good stuff than just run with my own incompetence.  You got the goods!
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-18 14:23:42
active2017-09-18 14:23:42
last_payout1970-01-01 00:00:00
depth11
children0
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time2017-09-25 14:23:42
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation1,828,487,362,424
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "valued-customer" "re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170918t142336488z" 100 true
post_comment your-acct "re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454883z" "valued-customer" "re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-re-valued-customer-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170918t142336488z" "" "your reply.." "{}" true

View on official site
@stellabelle ·
this info is very valuable. Have we ever been able to figure out, how many accounts are bots?
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-13 18:20:48
active2017-09-13 19:45:33
last_payout2017-09-20 18:20:48
depth1
children5
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation378,720,294,248,949
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "stellabelle" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t182048733z" 100 true
post_comment your-acct "re-stellabelle-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454890z" "stellabelle" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t182048733z" "" "your reply.." "{}" true

View on official site
@paulag ·
not at the moment, it is proving rather difficult
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-13 18:43:09
active2017-09-13 19:45:33
last_payout2017-09-20 18:43:09
depth2
children4
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation5,946,479,536,953
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "paulag" "re-stellabelle-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t184312557z" 100 true
post_comment your-acct "re-paulag-re-stellabelle-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454895z" "paulag" "re-stellabelle-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t184312557z" "" "your reply.." "{}" true

View on official site
@stellabelle ·
that's what I thought. Great work you're doing....very impressed.
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-13 19:07:30
active2017-09-13 19:45:33
last_payout2017-09-20 19:07:30
depth3
children3
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation378,720,294,248,949
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "stellabelle" "re-paulag-re-stellabelle-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t190731141z" 100 true
post_comment your-acct "re-stellabelle-re-paulag-re-stellabelle-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454901z" "stellabelle" "re-paulag-re-stellabelle-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t190731141z" "" "your reply.." "{}" true

View on official site
@paulag ·
I would like to ask you about getting posts translated and how it worked out for you, can I dm you on steemit chat?
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-13 19:16:33
active2017-09-13 19:45:33
last_payout2017-09-20 19:16:33
depth4
children2
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation5,946,479,536,953
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "paulag" "re-stellabelle-re-paulag-re-stellabelle-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t191636071z" 100 true
post_comment your-acct "re-paulag-re-stellabelle-re-paulag-re-stellabelle-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454907z" "paulag" "re-stellabelle-re-paulag-re-stellabelle-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t191636071z" "" "your reply.." "{}" true

View on official site
@stellabelle ·
sure, are you there now?
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-13 19:40:03
active2017-09-13 19:45:33
last_payout2017-09-20 19:40:03
depth5
children1
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation378,720,294,248,949
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "stellabelle" "re-paulag-re-stellabelle-re-paulag-re-stellabelle-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t194005300z" 100 true
post_comment your-acct "re-stellabelle-re-paulag-re-stellabelle-re-paulag-re-stellabelle-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454914z" "stellabelle" "re-paulag-re-stellabelle-re-paulag-re-stellabelle-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t194005300z" "" "your reply.." "{}" true

View on official site
@paulag ·
loging in now
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-13 19:45:33
active2017-09-13 19:45:33
last_payout2017-09-20 19:45:33
depth6
children0
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation5,946,479,536,953
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "paulag" "re-stellabelle-re-paulag-re-stellabelle-re-paulag-re-stellabelle-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t194528730z" 100 true
post_comment your-acct "re-paulag-re-stellabelle-re-paulag-re-stellabelle-re-paulag-re-stellabelle-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454920z" "paulag" "re-stellabelle-re-paulag-re-stellabelle-re-paulag-re-stellabelle-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t194528730z" "" "your reply.." "{}" true

View on official site
@fractalnode · (edited)
Thanks, but ...
Those images are too small...
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
last_update2017-09-13 20:51:57
created2017-09-13 18:41:15
active2017-09-13 20:51:57
last_payout2017-09-20 18:41:15
depth1
children1
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation832,167,438,763
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "fractalnode" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t184109864z" 100 true
post_comment your-acct "re-fractalnode-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454926z" "fractalnode" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t184109864z" "" "your reply.." "{}" true

View on official site
@paulag ·
if you right click on the image and select open in new window, you will see the large image
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-13 18:44:24
active2017-09-13 18:44:24
last_payout2017-09-20 18:44:24
depth2
children0
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation5,946,479,536,953
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "paulag" "re-fractalnode-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t184425961z" 100 true
post_comment your-acct "re-paulag-re-fractalnode-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454932z" "paulag" "re-fractalnode-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t184425961z" "" "your reply.." "{}" true

View on official site
@sports-2018 ·
@paulag Very well performed for sticking at it! It's really a new technique for lifetime therefore you are modern-day pioneers. Adore it..
json_metadata{"tags":["bisteemit"],"users":["paulag"],"app":"steemit/0.1"}
created2017-09-13 19:02:24
active2017-09-13 21:18:42
last_payout2017-09-20 19:02:24
depth1
children1
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation-103,458,434,023
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "sports-2018" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t190220056z" 100 true
post_comment your-acct "re-sports-2018-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454938z" "sports-2018" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t190220056z" "" "your reply.." "{}" true

View on official site
@paulag ·
ah thanks
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-13 21:18:42
active2017-09-13 21:18:42
last_payout2017-09-20 21:18:42
depth2
children0
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation5,946,479,536,953
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "paulag" "re-sports-2018-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t211843038z" 100 true
post_comment your-acct "re-paulag-re-sports-2018-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454944z" "paulag" "re-sports-2018-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t211843038z" "" "your reply.." "{}" true

View on official site
@jahidhasan ·
Very nice post.. already i am upvoted your post,,i am new at here,,i'm following you,,,please follow me back N upvote my post, thanks
👍  
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-13 19:04:18
active2017-09-13 19:04:18
last_payout2017-09-20 19:04:18
depth1
children0
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes1
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation-2,400,362,054
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (1)

vote your-acct "jahidhasan" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t190413648z" 100 true
post_comment your-acct "re-jahidhasan-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454950z" "jahidhasan" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t190413648z" "" "your reply.." "{}" true

View on official site
@clumsysilverdad ·
@paulag, while it's mostly a bloodbath today STEEM and especially I/O Coin are two of the winners right now... what do you make of it??
https://coinmarketcap.com/currencies/iocoin/
json_metadata{"tags":["bisteemit"],"users":["paulag"],"links":["https://coinmarketcap.com/currencies/iocoin/"],"app":"steemit/0.1"}
created2017-09-13 19:26:03
active2017-09-13 19:52:39
last_payout2017-09-20 19:26:03
depth1
children1
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation2,007,206,270,100
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "clumsysilverdad" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t192602153z" 100 true
post_comment your-acct "re-clumsysilverdad-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454956z" "clumsysilverdad" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t192602153z" "" "your reply.." "{}" true

View on official site
@paulag ·
I dont know anything about ioc, but steem is still down too
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-13 19:52:39
active2017-09-13 19:52:39
last_payout2017-09-20 19:52:39
depth2
children0
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation5,946,479,536,953
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "paulag" "re-clumsysilverdad-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t195240168z" 100 true
post_comment your-acct "re-paulag-re-clumsysilverdad-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454962z" "paulag" "re-clumsysilverdad-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t195240168z" "" "your reply.." "{}" true

View on official site
@clumsysilverdad ·
I try to upvote people that are growing in the ranks, and then also for some dolphins and newbies as it occurs.  I don't have enough Steem yet to really think too much about curation.
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-13 19:49:51
active2017-09-13 19:49:51
last_payout2017-09-20 19:49:51
depth1
children0
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation2,007,206,270,100
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "clumsysilverdad" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t194953229z" 100 true
post_comment your-acct "re-clumsysilverdad-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454967z" "clumsysilverdad" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t194953229z" "" "your reply.." "{}" true

View on official site
@inquiringtimes ·
now I'm just waiting for someone to tell me what this all means!!!! lol.
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-13 21:54:15
active2017-09-13 21:54:15
last_payout2017-09-20 21:54:15
depth1
children0
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation3,346,047,056,203
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "inquiringtimes" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t215415737z" 100 true
post_comment your-acct "re-inquiringtimes-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454973z" "inquiringtimes" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170913t215415737z" "" "your reply.." "{}" true

View on official site
@eastmael · (edited)
Hello @paulag. Do you have a post I can refer to in order to connect to steemsql via Power BI?
json_metadata{"tags":["bisteemit"],"users":["paulag"],"app":"steemit/0.1"}
last_update2017-09-14 00:32:06
created2017-09-14 00:31:45
active2017-09-14 07:54:30
last_payout2017-09-21 00:31:45
depth1
children1
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation921,325,670,684
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "eastmael" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170914t003145150z" 100 true
post_comment your-acct "re-eastmael-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454979z" "eastmael" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170914t003145150z" "" "your reply.." "{}" true

View on official site
@paulag ·
no not yet ( dm me on discord will sort you out)
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-14 07:54:30
active2017-09-14 07:54:30
last_payout2017-09-21 07:54:30
depth2
children0
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation5,946,479,536,953
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "paulag" "re-eastmael-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170914t075430504z" 100 true
post_comment your-acct "re-paulag-re-eastmael-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454985z" "paulag" "re-eastmael-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170914t075430504z" "" "your reply.." "{}" true

View on official site
@dbdecoy ·
Glad that you revisited and gave this excellent article on retention as you had mentioned in my Churn rate post. Looking forward to the conclusion.
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-14 09:44:51
active2017-09-14 12:02:24
last_payout2017-09-21 09:44:51
depth1
children1
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation446,766,265,928
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "dbdecoy" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170914t094450381z" 100 true
post_comment your-acct "re-dbdecoy-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454991z" "dbdecoy" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170914t094450381z" "" "your reply.." "{}" true

View on official site
@paulag ·
conclusion is out now
👍  
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-14 12:02:24
active2017-09-14 12:02:24
last_payout2017-09-21 12:02:24
depth2
children0
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes1
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation5,946,479,536,953
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (1)

vote your-acct "paulag" "re-dbdecoy-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170914t120224809z" 100 true
post_comment your-acct "re-paulag-re-dbdecoy-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085454998z" "paulag" "re-dbdecoy-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170914t120224809z" "" "your reply.." "{}" true

View on official site
@darkerhorse ·
this is a great and insightful curation report, thanks for sharing.
json_metadata{"tags":["bisteemit"],"app":"steemit/0.1"}
created2017-09-15 08:19:18
active2017-09-15 08:19:18
last_payout1970-01-01 00:00:00
depth1
children0
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time2017-09-22 08:19:18
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation816,402,027,441
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "darkerhorse" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170915t081531840z" 100 true
post_comment your-acct "re-darkerhorse-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085455004z" "darkerhorse" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170915t081531840z" "" "your reply.." "{}" true

View on official site
@sophistryproof ·
Coming upon a post like this is like walking into a classroom for the first time and realizing you are in a position to learn and I can't wait till I am not a newbie anymore.  From my limited understanding it seems that well over 50% have not voted in the last 60 days.  That is surprising to me.  Thanks, @paulag Now I want to read your previous post.
json_metadata{"tags":["bisteemit"],"users":["paulag"],"app":"steemit/0.1"}
created2017-09-16 15:26:21
active2017-09-16 15:26:21
last_payout1970-01-01 00:00:00
depth1
children0
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time2017-09-23 15:26:21
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,744,837
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"Steemit Retention Part 2 – Business Intelligence Steemit"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation123,085,897,251
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "sophistryproof" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170916t152618510z" 100 true
post_comment your-acct "re-sophistryproof-re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170921t085455010z" "sophistryproof" "re-paulag-steemit-retention-part-2-business-intelligence-steemit-20170916t152618510z" "" "your reply.." "{}" true


created by @roadscape