I want to talk about comments today.
You may or may not be aware, but we get a few comments here. Even if you think we get a lot of comments, you may not be aware of how many... and I'm actually not, either, because the system has only a partial count of comments because, as we all know, comments are temporary and sort of second-class citizens in the SE world.
So, what I want to see is some data so that we can decide if we need to do something about the sheer volume of comments we get. I have been able to use a SEDE inquiry to get info about the number of comments that currently exist on each post... or at least existed the last time the SEDE query ran - Monday the 21st - as of right now we have 377 questions and 1739 answers, so the info is a bit out-of-date. If I have time on Monday, I'll try to update everything below so that it matches more nicely with some of the "right now" data.
The majority of answers have no comments - 744 vs 683 for a total of 1427 answers but they add up to 2193 total comments on answers. So, this represents about 1.5 comments per answer, though if you exclude answers with zero comments, you get a little over 3 comments per answer.
Most of the questions have comments, though - 41 vs 277 for a total of 318. This is probably expected. We want to help people improve their questions, which requires comments. In total, there were 1662 comments on questions the last time SEDE ran. This means that, on average questions get a little over 5 comments each or exactly six per question if you exclude those with zero.
While this doesn't sound too bad, there are 16 questions and 9 answers with ten or more comments each - up to 26 comments on a single question.
That's a total of 3855 comments on 1745 posts (2.20/post) since this site went into public beta. I don't know if this is completely out of line but it seems somewhat high. Computer Science Educators, a site that is at 94 days in beta has 3964 total comments on 1875 posts (2.11/post). Bioinformatics has 2087 comments on 1172 posts (1.78/post) after 104 days in beta.
Also remember what I said earlier - this data is incomplete. This represents only non-deleted comments. Any comment deleted by either the moderators or by the user who posted the comment or through flags aren't included in this count.
I can add a little bit of light to that. As a moderator, I can see a count of total moderator-deleted comments (includes CM deletions). That number is 1352 (as of right now, not when SEDE ran). You read that right. In two months, we have deleted over 1300 comments - or about 23 per day. Compare that to the total from the SEDE query, that's about 1/3 of the existing comments, so about one in four comments ever posted on this site have been deleted by a moderator (there's some fudging in there because it's been so long since SEDE ran).
A - smaller, I assume - number have been deleted by the person who wrote them, through abusive comment flags, or have a keyword that makes them auto-delete with one "no longer needed" flag. I don't have numbers for that.
So, what I'd like from a CM is the rest of the data I'm missing - or as much as the system is able to serve up.
- total current comments on all posts (I understand it may not be possible to include deleted posts in this).
- total current deleted comments
- by type (self-deleted, mod-deleted, flag-deleted but no diamond involvement)
If it's possible, I'd also like to see the correlation between deleted comments and posts on the HNQ list. I know there's no "tag" for HNQ posts but I think we can safely say that if views > 1000 it was on the HNQ, since the site is new enough that it's uncommon for non-HNQ posts to get that many views. Giles made me a query for existing comments in SEDE here. It's pretty nifty but doesn't take into account deleted ones.
I'd also like to know how many auto comment flags have been raised by Community - these flags are raised on a post that gets more than 20 comments. We get a lot of them but they're not tracked. There's an MSE post that seems to indicate that you can give us that data, too.
Some thoughts regarding the comment volume would be useful, too.