Analyzing Utopian Moderator Review Times - Blockchain Business Intelligence
utopian-io·@eastmael·
0.000 HBDAnalyzing Utopian Moderator Review Times - Blockchain Business Intelligence
<center></center>
<center><sup>[Image Source](https://steemit.com/blockchainbi/@plushzilla/blockchainbi-logo-design-concept) credits to @plushzilla</sup></center>
In a [previous suggestion](https://steemit.com/utopian-io/@eastmael/suggestion-to-add-review-timestamp-to-utopian-api), 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
1. Scope of Analysis
1. How Long was the Average Review Time?
1. Who Were the Fastest Reviewers? Which Ones Took Time?
1. Which Category Took the Longest to Review? Which Took the Shortest?
1. Conclusion
1. Thoughts
1. Tools
#### 1. Scope of Analysis
* Posts that were reviewed after the `moderator time` was 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?
| <center>Longest Review Time</center> | <center>Shortest Review Time</center> |
| -- | -- |
|  |  |
Based on the left chart above, the [contribution](https://steemit.com/utopian-io/@asifte78/dollar-street-english-turkish-translate-three) 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](https://steemit.com/utopian-io/@suesa/not-able-to-show-posting-key-in-spanish-interface) 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](https://api.utopian.io/api/posts?limit=1000&skip=0)
* Review Time was extracted by getting the time difference between the `moderator.time` from `json_metadata` and the `created` field
* An issue this author encountered was the format the two fields had was different; `created` was in `2018-01-26T13:28:42` format, while `json_metadata.moderator.time` was in `2018-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))`
* Power BI
***
<sup>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...</sup>
<sup>You can find #blockchainbi on discord https://discordapp.com/invite/JN7Yv7j</sup>
<center>
**[Credits to the Author of Life]**
</center>
<br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@eastmael/analyzing-utopian-moderator-review-times-blockchain-business-intelligence">Utopian.io - Rewarding Open Source Contributors</a></em><hr/>👍 eastmael, allalamsteem, dwaeji-aizelle, dominiqueruiz, ellerysunga, east.autovote, wendyruiz, beautifuldata, joshruiz, alliruiz, steemitbc, j-alhomestudio, rt395, steemitdoctor, steemph.manila, topbro, abh12345, steemitph, steemfix, jassennessaj, crokkon, cifer, reggaemuffin, foxniner, surpassinggoogle, shakeelptc1234, revisesociology, rajarizki, vallesleoruther, jaredcwillis, eroche, shamuel, plushzilla, miniature-tiger, zallina, utopian-io, isaganicabrales, teamsteem, paulag,