Steemit Voting Pattern Analysis based on hour and day of the week

in #steemit7 years ago (edited)

Recap:

In my previous post, I looked at the quarterly churn rate of the users based on their voting. You can check it at:

https://steemit.com/steemit/@dbdecoy/steemit-churn-rate-and-engagement-level-an-analysis

The Next Quest

I thought of finding which country is the most influential or engages the most on this network. Sadly, Steemit blockchain is not stringent about storing the geolocation of its users. In fact I came across a whale who has described its location as 'Milky Way Galaxy' 😂 . Good luck with spotting this whale without hacking. So I decided to take up the next most important component after location - Time to find when the network is the busiest with its voting. I am not taking up posting and commenting yet as voting is the primary incentive for rewards I will include them in a later post.

Tools Used

The data being used is still from the ever reliable steemsql.com. I have connected Google sheets to it for pulling up the data I need. For Analysis, I decided to use the Tableau Public BI tool as it is free and has the ability connect to the Google Sheets. You can download it from https://public.tableau.com

The Method

The process involves pulling up the timestamp column of the TxVotes table in the steemsql server based on the Vesting Power of the users and aggregating it on hour and day. I decided to split the data based on Vesting Power so that It would be easier to know when the Influential users are around. A quick rehash of the user classification based on Vesting Power:

Vesting BalanceCoinage
Above 1000 MVestsWhale
Above 100 MVestsOrca
Above 10 MVestsDolphin
Above 1 MVestMinnow
Below 1 MVestPlankton

Fun Fact: We have a new minnow amongst us.

The steemsql server has it's timezone set to GMT+2 hours, I have adjusted the timings to GMT so that it is easier for everyone to comprehend the time being displayed.

Charts

My previous article did not carry any charts, so I decided to spice up things a bit. Using Tableau, I connected to the google sheet and pulled up the dimensions and measures required to get a chart of the Voting patterns on a particular hour in a weekday. Here are the results:

Sunday & Monday
1.png

Tuesday & Wednesday
2.png

Thursday & Friday
3.png

TGIF Again & Saturday
4.png

Observations

  • The users are busy voting between 0900 hrs GMT to 1700 hrs GMT.
  • There is a lull in voting during other hours.
  • The activity graph looks similar from Tuesday to Friday.
  • Lesser number of Votes are registered on Saturday, Sunday and Monday (Monday blues and weekend delights!)
  • The Whales and Orcas are an exception to this as they are active as usual on Saturdays.
  • Whales are really grumpy on Wednesdays compared to other active days. Good luck to Wednesday posters!
  • Whales are very generous with their votes on Tuesdays and Fridays (Authors make a note to give your best on Tuesdays)
  • Planktons really need to catch up with others's voting habits as they are lagging behind 80% of the time.
  • Whales are the forerunners when it comes to voting.

Take Aways

  • First and foremost schedule your posts between 0900 to 1700 GMT to get maximum exposure using a service like streemian.com.
  • Post on Tuesdays or Fridays and you may get lucky with the whales.
  • Newbies should improve their voting habits to increase their voting power. Steemit is a give and take system after all.
  • Sunday and Monday are the days with lowest voter turnout.
  • I am posting this article at 10 AM GMT 😇 🙏

Join the fabulous Steemit Blogger Discord community:
https://discord.gg/e5XFZKa

Steem Tail.jpeg

Sort:  

Great article, thank you! I especially appreciate you mentioning steemsql.com, I'm surely going to dive into that database myself :D

Do check the database. Its fun to query the data there.

Hi @dbdecoy, I just stopped back to let you know your post was one of my favourite reads and I included it in my Steemit Ramble. You can read what I wrote about your post here.

If you’d like to nominate someone’s post just visit the Steemit Ramble Discord

Excellent curation article. Thanks for mentioning my little piece. Following you to get further such good lists.

Thanks for that analysis, @dbdecoy... very useful. Or at least I think it will be; I'm going to try it out for myself.

Since this post is past the 7 day mark, I sent you a small tip from my wallet.