[Prototype] User Report Ver 6.3

http://isshiki.donmai.us/user-reports/inactive_approvers/%21CURRENT.html
About this...@BrokenEagle98 or @albert : Do you know what "Age" means in that category?
And since the sub-category "Disapproval" counts for "Inactive Approvers", I think it should also be implemented for the "Approvers" category.

"Age" is the age of the account in months.

What is the point of that "age"? Should this play a role if a Janitor is not doing that many approvals today?

Don't know about age... some might consider that important. Regardless, I submitted Issue 9 on Reportbooru regarding the disapprovals.

Thank you :3.
Well, to me it is utterly unimportant. In my book, it shouldn't count how long a Janitor was there if the results are the same with newer Janitors. Just want to hear the reason, but not start any discussion here, because I don't understand it.

Issue 9 was fixed, which means that the amount of disapprovals can now be seen per approver on the Approver's report.

I think for the "Inactive Approver" report, we should also include Janitors that didn't do any approval in the 30 days. Because we have some of them (I'd be very surprised if not) and I think that they should be included, because "inactive" should especially count those approvers, who didn't do any approval.

@BrokenEagle98
I have a question about the Contributor report, since I was in a conversation with kittey and "we" (more like kittey :P) noticed something pretty interesting.
http://isshiki.donmai.us/user-reports/contributor_uploads/%21CURRENT.html
The "Bypass" column is the point of interest here.
Just let me create an example what is meant here:
If I upload 100 posts and send no one through the queue, then "Bypass" should be 0.
Now one posts gets flagged out the 100. Does that mean that it increases the number in "Bypass" to 1?
It's interesting because the number of deleted posts is roughly the difference between "Total" and "Bypass" posts.

And sorry, I know I asked before, but what does "Unq flag" and "Unq downvote" means^^?

If you upload 100 and send none to the queue, then Queue Bypass would be 100. If one gets flagged, then reapproved or deleted, then Queue Bypass would be 99.

Unq flag is the sum of all unique flaggers for that user.
Unq downvote is the sum of all unique downvoters for that user.

Thanks. Just as we expected it works after this observation.

I am in the process of moving post versions to an off-site database. In so doing I've messed up the mapping of the old version ids. I don't think this has any practical effect on most users, but it does kind of screw up the tables in Google BigQuery. Instead of trying to come up with some mapping I've decided to just resync the table from scratch, so the user reports for this week may be messed up. This affects the post_versions and post_versions_flat_part tables.

Latest Update

Ver 4.9 -> Ver 5.0

• Added delta columns for uploads table <evazion: forum #118890>
• Parent delta is the number of posts parented after upload
• Rating delta is the number of posts with rating changes after upload
• Tag delta is the number of tags added/removed after upload
• This does not include metatags or request tags
• Added score and favcount metrics to uploads table
• Changed how upload tables are split
• Instead of Builder+/Platinum-, it is now Contributor/Member
• Removed queue bypass column from Member Upload table
• Added additional links to the uploads table
• Tag categories redirect to the related tags page, which shows the top 25 upload tags for that user over the previous month
• Combined delete and undelete columns for notes and wiki pages
• Added user feedback table
• Truncate user names > 15 characters
• Added prior column to request and translate tables
• Removed '+' or '-' from all column names
• Positive or adds are normal
• Negative or removes are surrounded with parentheses '( )'
• Added page analytics for wiki and artist
• Removed intro and implementation details sections

My top 10 tags are more or less what I expected them to be based on what I'm currently tagging but it's always nice to see confirmation. And I'm glad to see I'm still so high up on the list of top taggers, getting close to 30K Post Changes atm.

Unbreakable said:

My top 10 tags are more or less what I expected them to be based on what I'm currently tagging but it's always nice to see confirmation. And I'm glad to see I'm still so high up on the list of top taggers, getting close to 30K Post Changes atm.

:o.
Well, that is appreciativeand still no Builder. Hmm, I have an idea^^...

BrokenEagle98 said:

• Changed how upload tables are split
• Instead of Builder+/Platinum-, it is now Contributor/Member

Much-needed change, that. Thanks.

I used/removed 1540 different tags this time, which is a seventh increase in a row. Something tells me that won't last much longer.

Provence said:

:o.
Well, that is appreciativeand still no Builder. Hmm, I have an idea^^...

I'm used to be the quiet guy working in the background but yeah, it's always nice to see people appreciating your work of course. And tagging helps me find images easier too.

@BrokenEagle98
It seems that some categories stopped updating (wiki pages + translator tags).

Provence said:

@BrokenEagle98
It seems that some categories stopped updating (wiki pages + translator tags).

Created Reportbooru/Issue 10.

Vandalism report was broken but it should be fixed now.

Latest Update

• Updated data for March 2017

Edit:

• Forgot to remove the Page $ column from the analytics tables