In a previous suggestion, this author saw that the moderation time has been added to the Utopian API.
This analysis aims to analyze data based on this new information, which is the time a contribution was reviewed.
Outline
- Scope of Analysis
- How Long was the Average Review Time?
- Who Were the Fastest Reviewers? Which Ones Took Time?
- Which Category Took the Longest to Review? Which Took the Shortest?
- Conclusion
- Thoughts
- Tools
1. Scope of Analysis
- Posts that were reviewed after the
moderator timewas introduced to the API (Jan. 18, 2018 2:18AM GMT+8) - In consideration that actual deployment may also have been later than when that change was done, one more day was added to the filter (
'created' > 2018-01-19 00:00:00)
2. How Long was the Average Review Time?
There were 2667 contributions reviewed (created > 2018/01/19). These contributions were created by 766 authors and reviewed by 82 moderators. This amounts to around 33 reviews per moderator. Further dividing this into 8 days (from Jan. 19 to Jan. 26) amounts to 4 contributions per day.
The average review time (the time a contribution was created until it was reviewed) was 24 hours or 1 day.
Looking at this from a different angle:
172 contributions (around 6%) of contributions were reviewed within the first hour. While 60% (1619 out of 2667) of contributions were reviewed within 24 hours.
The time that most contributions were reviewed were those in the 1-hour timeframe with 110 contributions.
3. Who Were the Fastest Reviewers? Which Ones Took Time?
 |  |
Based on the left chart above, the contribution that took the longest to review was from @asifte78 under translation which took @redjepi 120 hours or 5 days to review. This author looked at that contribution and initially it was not approved, but after a few messages, it was later approved.
The shortest was from @suesa for this contribution which was a bug for steemit/condenser which only took 1 minute for @reggaemuffin to review.
4. Which Category Took the Longest to Review? Which Took the Shortest?
Let's now look into the review time per category.
Based on the charts above, task-development took the longest to review which took an average of 57 hours or around 2 to 3 days for each of the 2 contributions.
The quickest to review was analysis which took an average of 6 hours for each of the 14 contributions.
5. Conclusion
The moderator time was introduced to the Utopian API last January 18. The day after this, there were 2667 that contained this data when a contribution was marked as review. 82 moderators reviewed these contributions which amounts to around 4 contributions reviewed per moderator per day.
Based on this analysis, we saw that 60% of the contributions were reviewed within 24 hours. The longest being reviewed within 5 days, and the shortest by 1 minute.
We also saw that task-development was the category that took the longest to review which took around 2 to 3 days, while the analysis category was the shortest with contributions reviewed within 6 hours.
6. Thoughts
Another reason this author looked into this data is to know how many moderators it will take to review contributions once Utopian receives 5 to 10 times the amount of contributions it receive today. That is of course another story.
7. Tools
- Utopian API
- Review Time was extracted by getting the time difference between the
moderator.timefromjson_metadataand thecreatedfield - An issue this author encountered was the format the two fields had was different;
createdwas in2018-01-26T13:28:42format, whilejson_metadata.moderator.timewas in2018-01-26T13:32:57.256Z; As a solution these fields were first converted to UTC format using the following DAX:created_utc = DATEVALUE(MID('posts?limit=5000&skip=0'[created],1,10))+TIMEVALUE(MID('posts?limit=5000&skip=0'[created],12,8))modtime_utc = DATEVALUE(MID('posts?limit=5000&skip=0'[meta.mod.time],1,10))+TIMEVALUE(MID('posts?limit=5000&skip=0'[meta.mod.time],12,8))
- Review Time was extracted by getting the time difference between the
- Power BI
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
[Credits to the Author of Life]
Posted on Utopian.io - Rewarding Open Source Contributors
.
Thank you.
This is where the beauty of community comes in. :)
Lol. Yes, you did and the analysis category as a whole as well. ;)
Hey @eastmael I am @utopian-io. I have just upvoted you!
Achievements
Community-Driven Witness!
I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!
Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x
great post. Looking at your dax, you might find it easier to look at the date field while in the query editor (or M). Try split the column by number of characters. do a replace text and replace T with blank and then set the new columns to date and time data types respectively. then load the data to your model
Thank you Paula. Will try this.
Hi @eastmael, great analysis.
Is the review time the same as the duration between original posting and the upvote from utopian?
Hey @eroche.
I would think the review time is the moment at which the mod finishes their review and passes the post as meeting the requirements for the Utopian category. It's an intermediate step between - the Utopian bot wanders around and upvotes later once it's charged up - there can be quite a delay between the two.
Thank you for answering. Yes, review time is the intermediate step. Attempt to differentiate based on fields:
created)json_metadata.moderator.time)active_votes[utopian-io].timestamp)Nice work @eastmael!
And great work from the analysis mods too, top of the pile!
Thank you @miniature-tiger. I just realized now from your comment that I should have changed the sorting of the categories from shortest to longest.
Hope to learn to evolve these charts to more user friendly visualizations.
Extraordinary work @ eastmael,
to help solve existing problems.
Thank you.
Your are welcome, up-vote me