I’ve seen Google and Yahoo put out reports on the top search terms of the year, and we’re only a week into December. (Happy Hannukah by the way.)
Seems a bit odd to do that before the actual end of the year, but what the hell, I’ll jump on that bandwagon. Here are some stats for my blog, for the year up to midnight Tuesday.
Total posts for the year: 279
Total comments for the year: 2014
Average comments per post: 7.2
Most frequent post categories:
What do I end up writing most about? Posts in multiple categories counted twice.
Most popular categories by comments:
What do people like commenting on most? (average comments per post per category)
Least popular? Dreams 0.5. Not really surprised at that; more than any other category, my occasional posts about my dreams are for my benefit, not anybody else’s!
Top popular posts by comment:
And what have been the posts that people have commented on the most?
Top ten frequent commenters:
Who’s left the most comments?
Quickest comments (minutes between post and comment):
Thanks to the web, and particularly with RSS feeds, people can see what you’ve written within seconds of it being posted. Who’s been quickest off the mark to comment? Figures in minutes and seconds between the blog post and the first comment.
Some comments come in weeks after the post, and probably nobody notices them except me. Comments are normally closed 90 days after the post date.
Finding these stats
Most of the above extracts came out of the database for the blogging software, Wordpress. For those who want to try this for themselves (and for my own future reference if I try this again next year), here’s the SQL I used.
(Pah — Skip this geeky stuff and go to the comments)
(more…)