November‘18 STEEM Post Bench-Marking Report - Blockchain Business Intelligence
utopian-io·@paulag·
0.000 HBDNovember‘18 STEEM Post Bench-Marking Report - Blockchain Business Intelligence
<html> <h2> Repository</h2> <p><a href="https://github.com/steemit/steem">https://github.com/steemit/steem</a> </p> <h2>Aim of Analysis</h2> <p>Every month I produce a Post bench-marking report with the aims of:</p> <p>• Aiding the STEEM Community with a place to benchmark their posts and growth</p> <p>• Create a report that can be used for comparisons in other periods</p> <p>• To track my personal targets and record achievements</p> <p><em>Please note this data is based on Posts and not Comments.</em></p> <p>If you missed last months report you can check it out here</p> <p>https://steemit.com/utopian-io/@paulag/october-18-steem-post-bench-marking-report-blockchain-business-intelligence-1541714847409</p> <p>In September we had HF20, this caused a reduction in on chain activity for the last week of the month. This lead to an increase in rewards pool which would have inflated payments in for a time October. This report for november should show a true reflection of activity with everything from HF20 now leveled off.</p> <p><br></p> <h2>Financial Performance</h2> <p>https://cdn.steemitimages.com/DQmfSH6RQ1xC1Y3KgiRnXRXNTRieuqKkFux2kfAuHoXcAVM/2.png </p> <p>In November 18 the % of posts with no payout was just over 16%, remaining consistent with last month. Pre fork this was always above 20%</p> <p>The % of posts with a payout of <$1 has increased from 56% last month to +60% in November.</p> <p>There were no posts with a payout of above $500 this month</p> <p>The average post pay-out value in Nov was $1.68 and if we exclude posts with no payout this increases to $2.02</p> <p>The median payout value was $0.10 with a standard deviation of 7.64</p> <p>The number of posts decreased by 14% on the previous month and the gross payouts decreased by 57%. The drop in the price of steem has had an impact on payouts.</p> <p>You can see how this compares to previous period in the charts below.</p> <p>https://cdn.steemitimages.com/DQmbPKnwfhpwWmvpTdvHQ9961znUZVTcyFAC3x4sYQ4tft6/3.png </p> <h3>Top Authors based on Gross post payouts</h3> <p>https://cdn.steemitimages.com/DQmZe8C4goLarAQtqnPUh5npcXVVoPfUxqt2K7ExZabNfTV/4.png </p> <h3>Top Category</h3> <p>https://cdn.steemitimages.com/DQmV4XmQaqH1k2FZan8hwRTWcZMPPo4D4Y5syqJySJ2RY7s/5.png </p> <h2>Comments</h2> <p>https://cdn.steemitimages.com/DQmXHcVtASZ3c7kVWQCKFv7711E5ZXEuRTdxVk46nbMB7FJ/6.png </p> <p>The % of posts with no comments 41.72%, this is consistent with October.</p> <p>The mean number of comments per post is 3.10, and the median is 1. You can see how this compares to previous period in the chart below.</p> <p>https://cdn.steemitimages.com/DQmSLKUnjRu7vsjSteSx5XHZUSeMR3NHCXAxr4EpSKNvHoF/10.png </p> <h2>Votes </h2> <p>https://cdn.steemitimages.com/DQmU8F3TMqhGtWeG6qyMzoTH9ejBHHVLQvQHA2ad4uvfcf9/7.png </p> <p>The % of posts with 0 net votes has also remained consistent with last month at 7.21%.</p> <p>The median votes per post was 13 and the average was 43.57. You can see how this compares to previous period below.</p> <p>https://cdn.steemitimages.com/DQmPs7bNVndez89CREjcdoPtihrB9cnoNrtDPY6Z9nzh4Km/11.png</p> <h2>Flags</h2> <p>In votes above we also have flags, however combined only 2.6% of posts had a net downvote. </p> <p>https://cdn.steemitimages.com/DQmNreA2ztmmE6tXtQh4GmyLXCLu7nMxxFoF11c2Hoo6fGR/8.png </p> <p>20.5K posts received 1 or more flags (this is posts not comments). This makes up 5.72% of all posts made. This is also consistent with last month.</p> <p>In the first table we can see the authors with the highest % of flags and after this the table shows who gave the most flags. Following this we can see the time series for when flags were given</p> <h2>Other Data</h2> <p>https://cdn.steemitimages.com/DQmPGqwM1M8DW9dHCKeXZTMP4hxEAvX63GZzjn8H63rPJyr/9.png </p> <p> The line chart above represents the number of new posts per day in September 18 and the bar chart below that shows the peak posting hours. </p> <h2>Conclusion</h2> <p>The number of posts each month has been on a downtrend this year and November was no exception. I expect that the crypto downturn is responsible for much of the recent drop.</p> <p>As expected the payouts reduced as the rewards pool had leveled off by the end of October from the HF20 changes, however there was an additional hit with the lower price of steem.</p> <p>Engagement in terms of comments per post has remained rather consistent, however last month we seen a massive jump (over 100% jump) in the median number of votes per post and this has remained consistent this month. This can be tied in with the new user report I produce where I have found less inactive accounts registering and more voting only accounts.</p> <p>The % of posts that received flags has remained consistent.</p> <p>Keeping track of my own posts, on average I earned $17.41 per post, and each post received an average of 209 votes.</p> <p>How did you posts do in November, please do leave a comment below and let me know how you got on?</p> <p><br></p> <p><br></p> <h2>The Data and Queries</h2> <p> As always I have connected to Steemsql managed by <a href="https://steemit.com/@arcange">@arcange</a> using Power BI and the query is used was<br> </p> <pre><code> SELECT</code></pre> <pre><code> author,</code></pre> <pre><code> category,</code></pre> <pre><code> created,</code></pre> <pre><code> children,</code></pre> <pre><code> total_payout_value,</code></pre> <pre><code> net_votes,</code></pre> <pre><code> pending_payout_value</code></pre> <pre><code> FROM </code></pre> <pre><code> Comments (NOLOCK)</code></pre> <pre><code> where created >= CONVERT(DATE,'2018-11-01')</code></pre> <pre><code> and created< CONVERT(DATE,'2018-12-01')</code></pre> <pre><code> and depth = 0</code></pre> <p><br></p> <p><code>The code used to get flag details was </code></p> <p><br></p> <pre><code>SELECT</code></pre> <pre><code>*</code></pre> <pre><code>FROM </code></pre> <pre><code>txVotes (NOLOCK)</code></pre> <pre><code>where timestamp >= CONVERT(DATE,'2018-11-01')</code></pre> <pre><code>and timestamp< CONVERT(DATE,'2018-12-01')</code></pre> <pre><code>and weight <0</code></pre> <p> </p> <h2>Shameless Promotion</h2> <p> Like what we are doing? Dont forget to vote for <a href="https://steemit.com/@steemcommunity">@steemcommunity</a> as your steem witness. <br> https://steemitimages.com/0x0/https://cdn.steemitimages.com/DQmbQRxg3R9M2AFLHQjW388a6ng6ofoN3UVux5B8FGtiiWA/1.png</p> </html>
👍 aeiou00, princessamber, ghostdylan, steeming-hot, eforucom, shammi, east.autovote, clumsysilverdad, jacekw.dev, goodcontentbot, king-oghie, leir, norbu, damahsyari, gamer86, hazard10, tfq86, johnhtims, abh12345, lebey1, simplymike, jacekw, amosbastian, espoem, jaff8, asaj, merlin7, mops2e, blanchy, eastmael, revisesociology, miniature-tiger, make-a-whale, helpie, rycharde, redrica, hz432creations, melavie, art-mess, socent, eonwarped, pechichemena, kernelillo, luisferchav, soulturtle, carpedimus, silentscreamer, hazem91, atomcollector, spawnband, veckinon, javicuesta, free-reign, misterro, isaria, christianolu, paulag, professorbromide, lunaticpandora, warpedpoetic, juandvg, mindtrap, siomarasalmeron, foxyspirit, derangedvisions, zaxan, kbr, shookriya, frejafri, flordiaman, melor9, lillywilton, preventsuicide, butt-memes, adesojisouljay, solominer, blewitt, stonerfeed, bigriffsbongrips, zaxan-blog, allaboutfood, theduskinus, ripperone, mangos, autobodhi, nanzo-scoop, hitmeasap, flauwy, steembasicincome, beeyou, zcool, legendchew, musmui, roleerob, semperenglish, markaustin, beautifuldata, bennettitalia, niallon11, mummyimperfect, ak2020, emily-cook, t-bot, mafeeva, memorysports, fitat40, nanzo-snaps, kerrywolf, mcfarhat, aneukpineung78, josephsavage, torrey.blog, bafi, aerial-italy, j3dy, arteem, ab123, jasonbu, freebornsociety, crimsonclad, discordiant, krnel, clayboyn, resiliencia, steemitph, mrday, fego, boxcarblue, rt395, gokulnk, steemitbc, orlandumike, codingdefined, krazypoet, trevorpetrie, familytree, edwardstobia, raoufwilly, seanlloyd, amriadits, luoq, ladiesofsteemit, mrshev, tebarsuara, smk-trail, teamsteem, inquiringtimes, momogrow, gamsam, camuel, yestermorrow, hornetmusic, silverade, amarspm53, timons, steem.lion, steem.peng, steem-bar, power.steem, king.steem, hafismultim, bar-bar1903, icsan, good-karma2, steem.sport, amymya, cobloc, protegeaa, anarcho-andrei, verhp11, ameliabartlett, arcange, raphaelle, marysemciver, omitaylor, jayna, evecab, musicvoter, avesa, grizzle, recordpool, archaimusic, musicvoter2, elamental, p4ragon, ogsenti, theturtleproject, kimzwarch, etcmike, mammasitta, jenkinrocket, nonameslefttouse, stevelivingston, spectrumecons, jonmagnusson, holger80, edicted, travelling-two, loshcat, we-are-steemians, newageinv, vallesleoruther, we-are-vietnam, tarazkp, we-are-welcoming, dalz, chrnerd, jakipatryk, eturnerx, scipio, someaddons, crokkon, steem-ua, newsrx, xinvista, utopian-io, jga, berniesanders, nextgencrypto, thecyclist, engagement, iflagtrash, randomthoughts, thedelegator, ngc, ace108,