Repository
https://github.com/jakipatryk/steeditor
Introduction
Steeditor has been around since last year and it was created by 
Steeditor is an advanced editor for the Steem posts. It is an advanced editor but at the same time very easy to use. The interface is simple and straightforward, even a newbie can grab its concepts in a few minutes and I am not exaggerating.
It is referred to as an advanced editor because of the flexibility and control you have over your post. Very few steem platforms give you such options. This includes the ability to allow votes, allow curation rewards, set the maximum accepted payout, set beneficiaries, control payout whether in steem, sbd or steem power, include your custom JSON metadata.
Most Utopian contributors have been using steeditor for their post, mostly due to the financial incentive. Utopian contributors when they use Steeditor we can earn 20% more than they would normally earn. The condition is to use Steeditor and set 
In this analysis, I will be looking at how well the app has been performing in the last six months in terms of post, comments, authors, category and upvotes.
Outline
Scope
Conclusion
Tools and Scripts
Scope
Date of the analysis: 3rd July 2019
The time frame of the analyzed data: January 2019 to June 2019
Components of the analysis:
MONTHLY NUMBER OF POST
Between January and June 2019 there were a total of 464 posts made via Steeditor app, no comment was made. This is not surprising as most people who use steeditor are using it for Utopian contributions and they do it because of the extra incentive.
Out of the 32 categories which users made a post to, Utopian-io came top and accounted for 34.5% of the total post while contest and sports came second and third with 26.7% and 12.7% respectively.
Between January and June 2019, the price of steem has hovered between $0.26 and $0.53. January 2019, saw the highest number of post and this I believe is due to a sudden rise in steem in that month. Steem price appreciated by more than 50% within a space of 7 days. It has been a well-established fact that steem price does affect the number of posts and activities. At no point in the first half of the year do we see such a sharp change in steem price. I expected the latter half of the year to maintain similar patterns seen between February and June 2019, in which there was no much change in the number of posts made via steeditor.
UNIQUE AUTHORS AND RETENTIONS NUMBERS
Unique authors are simply the number of distinct or differentiable authors who are making a post via Steeditor. As I mentioned previously, between January and June 2019, Steeditor authors have made a total of 464 posts from a total of 45 authors. Thus means on the average each author made 10 posts.
- 55.56% of authors made posts for only a single month between January and June 2019.
- 17.78% of authors made at least one post for any two months between January and June 2019.
- 11.11% of authors made at least one post for any three months between January and June 2019.
- 4.44% of authors made at least one post for any four months between January and June 2019.
- 2.22% of authors made at least one post for any five months between January and June 2019.
- 8.89% of authors made at least one post for six months between January and June 2019.
With the numbers above, it is fair to conclude that Steeditor has a retention rate of about 9%. In drawing this conclusion, I used a time frame of 30 days or one month. Making at least one post a day shows the user is still hooked to the application.
FINANCIAL ANALYSIS
MONTHLY PAYOUT
Earnings are a major part of the steem blockchain, most times, it determines the amount and level of engagement.
- About 7% of posts made from Steeditor earned $0. And about 23% of posts earned less than $5.
- The highest-earning was from user
with $145, out of the top 50 highest earning posts, 46 posts come from him. On checking his profile, I discovered he is not a Utopian contributor but a crypto gamer.
Is there any relationship between the numbers of characters and the payout, number of comments, number of votes. Considering Steeditor is mostly used by Utopian contributors, in which in many categories, the number of words is been put into consideration when reviewing and giving rewards.
The table below shows there is no direct correlation between the variables listed above. Instead, the variables are dependent on factors like the category/section, the reputation and community of the author. e.g a contributor who contributes to the Analysis section will on the average use fewer characters than the person who contributes to the blog section. And the Analysis section has a higher potential reward than the blog category.
A user who has a high reputation and good followership on Steemit will also enjoy better interaction in terms of comments, votes and payout. I have seen Utopian contributions that drew a lot of attention and support even without Utopian support because of the author.
Conclusion
People use Steeditor not only because of Utopian contributions but also for its extra features, flexibility and control that you have over your posts. Steditor is not doing bad and it is going to be around for time to come.
Tools and Scripts
Microsoft SQL Server Management Studio 17 was used to access the data from STEEMSQL ( a publicly managed database by 
Microsoft Excel 2019 was used to plot graphs and Charts.
Scripts
SELECT
author,
created,
category,
body_length,
json_metadata,
(JSON_VALUE (json_metadata,'$.app')) AS App,
children,
total_payout_value,
net_votes,
depth
FROM COMMENTS (NOLOCK)
WHERE
created>= CONVERT(datetime,'1/01/2019') AND created< CONVERT(datetime,'7/01/2019')
AND
IIF(isjson(comments.json_metadata) = 1, IIF(CHARINDEX('/', json_value(comments.json_metadata, '$.app')) > 0, SUBSTRING(json_value(comments.json_metadata, '$.app'), 1, CHARINDEX('/', json_value(comments.json_metadata, '$.app'))-1),json_value(comments.json_metadata, '$.app')), null) = 'steeditor'