Zappl is a fun app built upon the Steem Blockchain that allows you earn STEEM by posting or up voting on short form content up to 240 characters that are just like tweets.
Zappl was previously in receipt of funding Steemit Inc by way of delegation from Misterdelegation. However this funding has now been revoked.
The aim of this analysis is to monitor the monthly activity from @Zappl in terms of voting. It is also to analyse posts made via the Zappl app and posts made to the Zappl category on the STEEM Blockchain.
This analysis will be carried out on a monthly basis so that trends can be established and growth measured.
If you missed last months post you can read it here
https://steemit.com/utopian-io/@paulag/feb-18-zappl-steem-app-analysis-blockchainbi
The Data
Using PowerBI, I have connected to the SteemSQL database (paid subscription service held and managed by @arcange). You can find the full query at the end of this post.
The Analysis
March @Zappl Votes Analysis
The visualization above show the voting for @zappl in March 2018.
In March 2018 Zappl voted 15K times for 4339 Authors. The average vote pay out was SBD $1 and the total approx. pay out given by Zappl was SBD $40.06 We can also see from above that the average % voting weight used by @Zappl was .69% and the average number of votes given per day was 483.
In addition to this the vote value reduced from $103.45 to only $0.40 as the delegation was removed by MisterdelegationWe can see also that the voting from @zappl came to an almost complete halt after the 11th March.
For comparison Feb 2018 Zappl voted 26K times for 4480 Authors. The average vote pay out was SBD $1 and the total approx. pay out given by Zappl was SBD $24.17K We can also see from above that the average % voting weight used by @Zappl was .89% and the average number of votes given per day was 928.
March Voting Time Series
The time series above shows the No of Authors, No of Votes, Average SBD value and the average voting weight used by @zappl each day during the reporting period. It is disappointing to see the drop off in votes, although I am sure this is down to the removal of delegation.
Popular Steemains in terms of Upvotes from @Zappl
Zappl Tag Post Analysis
The visualisation above show all postings – both Posts and Comments made in the category/tag for #zappl in March 2018
In March 48K posts were made by 7955 authors receiving 49K comments and 334K votes. The pay-out value of these posts was SBD $15.50K
For comparison in February 49K posts were made by 6889 authors receiving 126K comments and 255K votes. The pay-out value of these posts was SBD $23.65K.
We can see when Zappl stopped voting, there was also a steep decline in posting.
These 48K posts received 49K comments from 8,503 authors. The comments received 11K votes and received rewards of SBD $1.10KThe average post pay out in Feb for #Zappl posts was $3.10 substantially up from the $0.48 in Feb.
Creators
Below shows which accounts have posted the most to Zappl in the month of March
And the list below shows those that engage with the posts via comments
Conclusion
The Stats for Zappl this month show major changes. Delegation has been removed and the vote from Zappl is no longer sizeable.
This has had a major impact on activity. Both the number Votes made by @zappl and the number of posts have taken a hit. Although the first two weeks of March saw almost the same number of posts as all of February.
It is also worth pointing out that the value of the vote for @zappl was taken 10 April. Delegation was removed during the month and some of the votes were made with the delegation in place. Therefore the payout values shown are not accurate.
The SQL Queries
The SQL query used to collect data for votes made by @zappl was:
SELECT *
FROM Txvotes (NOLOCK)
WHERE [voter] in ('zappl')
AND CONVERT(DATE,timestamp) BETWEEN '2018-03-01' AND '2018-03-31'
The query used to collect data for posts made to the category/tag Zappl on steemit was:
SELECT
author,
json_metadata,
permlink,
total_payout_value,
pending_payout_value,
net_votes,
created,
children,
Category,
Depth
FROM comments (NOLOCK)
where CONVERT(DATE,created) BETWEEN '2018-03-01' AND '2018-03-31'
and json_metadata like ('%"zappl"%')
The Current vote worth for Zappl has been taken from https://steemworld.org/@zappl at 10th April 2018.
I am part of a Blockchain Business Intelligence community. We all post under the tag #BlockchainBI. If you have an analysis you would like carried out on Steemit or Blockchain data, please do contact me or any of the#BlockchainBI team and we will do our best to help you...
You can find #BlockchainBI on discord https://discordapp.com/invite/JN7Yv7j
Posted on Utopian.io - Rewarding Open Source Contributors
i have long not get a vote from zappl
.
Okay, quick question, if utopian don't approve the post do they still take a portion of author rewards?
.
no way. Okay thanks.
Your post has been selected by Connect to the World FR
@cw-fr
We promote English posts in the French community!!https://steemitimages.com/0x0/https://gateway.ipfs.io/ipfs/QmYzPJNVRmfzfeMQKLKCtxSVxuw5KLbmKv3snEh2DJGPjg
We are writing a post with our selection that we share within the French community
you can see the post by clicking on the image below
Thanks for the great content!!
Thank you for this accurate information hopefully can increase knowledge and inspiration for stemians especially newcomers in steemit.
Seems like this project may be fading away....
Zappl is a company with institutional share holders. And zappl cannot reward its delegators like utopian does. Thus assuming this, the delegation may have been revoked due to this issue.
With ROI seemingly of number 1 importance, this does sound to be the most likely reason. Cheers.
Utopian are not even accepting posts on zappl lol....not looking good