web analytics

Site health – comments and posts

Written By: - Date published: 4:31 pm, February 12th, 2012 - 36 comments
Categories: admin, The Standard - Tags:

vto made a comment that he thought that the number of comments was diminishing at kiwiblog. Now I have no idea because I usually avoid the sewer that is the comments section there. However it did remind me that I should have a look at the last year or so here. It feels like it has been getting more popular, but intuition is a poor substitute for actually looking at the numbers.

So I ran some SQL against the comments table pulling out the numbers of approved comments and the number of posts with approved comments*, tossed it into LibreOffice Calc and pulled out some numbers.

So looking at the yearly picture for full years, our comments are rising in the last few years and our posts remain pretty constant, so our comments per post has been rising.

The Standard – yearly comments and posts 
Year Comments Posts Comments per Post
2008 64218 2199 29.20
2009 64594 2687 24.04
2010 94558 2888 32.74
2011 131249 2595 50.58

We have been keeping the numbers of posts limited because we’re not really that interested in burning out authors. We all have lives outside of the blogs, don’t want to spend our lives writing posts, and don’t really want to become some kind of news clipping service. You can see the election year effect in 2008 and 2011.

The question for this site in 2012 is if we keep similar numbers of the readers and commentators, and their page views and comments post election year.

You can see the post election slump in December 2008 and Jan 2009 had a virtual reprise of the December 2010 and 2012, albeit from a much higher base and for much the same reasons. The effects of the very short election season in 2011 shows in our comments which actually decreased while the world cup was on in September and the first part of October and then went through the roof after the final game.

But there has been healthy growth throughout the year and the numbers for the latter part of Jan and early Feb point to the comments on the site remaining pretty healthy, but unlikely to repeat the November numbers for a while. Probably in the post-winter commenting boosts. But of course commentators don’t just come to argue with each other. They come for the posts as well.

And then we look at the numbers of posts. There you can see the usual post election slump adding to the usual reduction in authors writing. But overall we maintaining the numbers of posts with spiking going on in times of interest. However what we are seeing is a change upwards in the number of comments per post.

 The spike in later 2007 and early 2008 shows exactly what happens when there is no moderation. You get a considerable increase in trash commenting as the trolls pile in. The average size of the comments goes down (if I get time I’ll put a post up on that) and you notice the lousy commentators drowning out anyone that looks interesting – the sewer provides a good example. When the moderation kicks in and becomes effective the number of comments slumps but the size of the comments, their quality increases, and you see interesting commentators return.

But since early 2010 we have had a steady increase both in the number of comments and crucially in the number of commentators.  We’re also seeing that interesting effect that even when the authors are taking their hard earned rest and the numbers of posts decrease, the commnets carry on as people make their own fun. The threaded nature of the comments sections makes it feasible to do.

Not everyone is particularly happy with the style of moderation on this site or even the style of the site. But it works and I’m more than happy with what we’re doing together.

* Code:

SELECT
YEAR(comment_date) as year,
MONTH(comment_date) as month,
COUNT(*) as comments,
COUNT(DISTINCT comment_post_id) as posts
FROM wp_comments
WHERE comment_approved=1
GROUP BY YEAR(comment_date), MONTH(comment_date)
ORDER BY YEAR(comment_date), MONTH(comment_date)

This particular query eliminates the small number of posts that have no comments (mostly from 2007) and includes the few image pages that have comments that were never moved.  It is close enough for my purposes.

36 comments on “Site health – comments and posts ”

  1. G 1

    Whle you are talking about site health… can you please restore the RSS feed to the entire post? For some of us, work tracks what we look at, but they are too dumb (to be fair, their programme is too dumb) to realise that reader.google.com is Google Reader and not Google Search (which could be work-related). So I read blogs through RSS feeds only.

    • Lanthanide 1.1

      There was a problem where posts that were edited/updated did not have those edits reflected in the RSS feed. Sometimes posts are put up with chunks missing or error that are later corrected, but people reading the RSS feed didn’t see the updates.

      I think turning the RSS off was the short-term workaround for this problem.

    • lprent 1.2

      Plus the overseas traffic running on the RSS feed. The spam bots have been reading the RSS feed to look for new posts, which they then try to spam. Since there are literally thousands of the little buggers and I have no easy way to determine that they are spam there is no easy way to discriminate. I wish I could get at google analytics spambot discriminators. I’d use them on the reader and RSS reader side.

      The RSS feed got dropped from full to excerpt on about the 10th of last month. Since then we have dropped a lot of overseas traffic Gb compared to December. That costs $3 + GST per Gb.

      Of course the actual solution around NZ’s crazy costs for overseas traffic (when are we getting some competition for the southern cross?) is to bounce an up to date replication to a US server and let the rest of the world read their 45GB/month from there while NZ read their local ~300GB/month per month of it. However it costs about 50GB of overseas traffic to maintain a replication on a site that is this active.

      Of course I could fix everything by moving everything back to a US server. Of course it I did that then the actual traffic over the southern would increase to the full 300GB and the response times would slow.

      I have been playing with a astrill VPN setup at present. Hopefully that will push the replication costs elsewhere out of my budget. But I am finding it hard to get it to restart the connections reliably when I put in failures.

      Next one I am going to try is to change the RSS feeder to discriminate between known ‘good’ aggregation sites (like Google reader and feedburner) and everyone else. To be precise only allow a couple of feeders to use the RSS feeds.

      • infused 1.2.1

        Use a better provider. DTS don;t charge for outbound, which is what most of your traffic is.

        • lprent 1.2.1.1

          If it is the provider I just looked at then they don’t do dedicated servers. They do have collocation rackspace, but in Wellington and Christchurch. But I really don’t have time to chase around with hardware anyway. Their GB rates for the racks look ruinous for our volumes. http://dts.net.nz/hosting/co-location/ $6 + GST per 5Gb per month. We move at least 300GB per month.

          Unless there is something I am not seeing?

  2. Gruntie 3

    I mostly read the standard on my iphone 4s – (no I’m not a rich prick) but find The Standard blog the most buggy if all blogs – very slow and crashes a lot – have given up writing comments lately ( also coincided with my depression following 26 Nov 2011)
    Does anyone else have same issue with iOS on iPhone?

    • McFlock 3.1

      I got a similarissue on my android – but then it was the only blog I looked at that 100+ comments in a thread, so figured it was just that.
      Bloody stupid trying to go through all those with a 4″ screen 🙂

    • lprent 3.2

      I will have a look at it. We’re using the wpPhone ‘theme’ for phones. I have to confess that I haven’t tested it for a while.

      I should probably look at finding or even writing a barebones themes for the smart phones. Most of the ones I’ve looked at appear to be too sluggish when there are large numbers of comments with our 3G data. They need to paginate them.

    • Trowlie 3.3

      I’m the same on my iPhone. The page takes an age to load and will then crash as soon as I start to scroll down.

    • SHG 3.4

      Agreed – The Standard is a dog with the mobile theme enabled.

      • lprent 3.4.1

        Looking around for another theme. Tried it out on the my old iphone 3G yesterday and it was sluggish on wifi! It was interesting because the theme wasn’t nearly as bad last time I used it.

  3. Congrats Lprent.  Good to see the Standard is going from strength to strength.

    One thing I am interested in.  Did the 2011 post election dip occur before or after the Labour leadership campaign?  My impression is that the campaign caused considerable interest but it may be that it was amongst the Labour members rather than your readership as a whole.

    • lprent 4.1

      After. We had a hell of a spike for the leadership campaign. The December figures look like they dropped a lot, but the reality is that they are higher than almost every month.

      When it hit Dec 25 the page views dropped to about 5k per day and stayed there until the Ports of Auckland dispute.resurfaced in Jan. Comments had the same effect.

  4. Tangled up in blue 5

    vto made a comment that he thought that the number of comments was diminishing at kiwiblog.

    Imo “lefties” should stay away from Kiwiblog completely. I mean don’t even go there for a laugh to see what those clowns are up to. Giving it traffic is unnecessary and indirectly supports the site. It used to be that a left voice on there was helpful to show up the usual biased tripe but lately (since about a month before last election) it’s gotten so hard-right and hateful that people are realising it’s just a place for angry 1% Act supporters to rage. Stay away and let Kiwiblog fade into obscurity.

    • Populuxe1 5.1

      Really? Keep your friends close and your enemies closer. I like to know what the bastards are saying, otherwise you’re just reinforcing the stereotype that the Left lives in an ivory tower.

      • McFlock 5.1.1

        Much as I tend to agree with the sentiment, if they’re saying anything much more tory than kk, james3 or so on I probably wouldn’t want to burn my eyeballs.

  5. Anne 6

    Imo “lefties” should stay away from Kiwiblog completely.

    Absolutely. Don’t give Farrablog the traffic. He holds it up as evidence of his supposed political insight and importance. The MSM are too thick – or lazy – to investigate the reality.

  6. Blue 7

    @Anne – “Imo “lefties” should stay away from Kiwiblog completely.’,Absolutely”

    Ah yes, ‘we can’t debate, so lets run away’, Why am I not surprised that you’re not prepared to listen to an opposing view. Ever wonder why the National Party handed you your asses again? Its this sort of head in the sand thinking that costs you your support. Mindless stuff.

    • Colonial Viper 7.1

      Why should anyone be prepared to listen to shite? You know like how selling off our country is good for us, how kicking the poor a bit harder will be “motivational” or how SOEs don’t need to respect Treaty obligations after being sold off.

      Ever wonder why the National Party handed you your asses again?

      You must be talking about the National led coalition which came in 4 seats down on 2008.

    • McFlock 7.2

      “Opposing view” is one thing.
      Calling people “parasites” is another thing entirely.
      One will never persuade people who freely use that (and similar language) to recognise that society extends beyond their personal chequebook, and their pretensions to logic are futile at best. “Debating” with them on their territory lends them a legitimacy they don’t deserve.
         
      Let KB become a mad corner of the internet, the NZ equivalent of militias and supremacists. After a while even the corporate media will have to admit that “newsworthy” story needs to be based on something more than the fanciful masturbations of a national party tool.

    • Gosman 7.3

      Interestingly I’d hazzard a guess that the posts with the mosts comments are the ones that have the most right wing comments on them. So to make a big deal about this stat you also have to acknowedge that opposing comment viewpoints make the blog more popular. You just need to lookat what has happened to Tumeke since Martyn Bradbury elbowed aside Tim Selwyn and implemented his Stalinist moderation policy. I believe the blog averages in the low single digits now per post.

      • Draco T Bastard 7.3.1

        And here’s me thinking that it was Tumeke’s layout and general user unfriendliness that did it.

        • Gosman 7.3.1.1

          How has that changed over the past couple of years?

        • just saying 7.3.1.2

          I’ve tried to comment at Tumeke and been unable to navigate the system.

          While it’s true posts that generate large numbers of comments are often those that generate debate and or argument (often over several days) it is just as likely (if not more) to be between differing views within the left. I think the overwhelming majority of regular commenters here come here to read the posts, follow some links, and exchange ideas with other left-wingers, and even those willing to engage the regular trolls do so mostly as a side-sport.

  7. Rich 9

    I actually think you can have too many comments (though maybe not from a revenue point of view).

    I tend to have this site down my list because of the number of Tories that comment on it (along with the Grauniad). If I wanted to know what RWS think, I’d read the mass media or listen to talkback.

    If there was a Tory-free politics site with reasonable traffic, I’d read it a lot.

    • lprent 9.1

      Yeah, well there is always that. But in their defence, the RWS that survive here tend to be somewhat “smarter” than those who frequent the mass media or talkback or the sewer. I feel it is healthy for the left to engage with the right, partially for the cross-fertilisation, but also because left activists tend to start arguing over minutiae of dogma that few voters care about if they are only talking to the like minded.

      The filter mechanism is simple. We are interested in people who can and will argue. We tend to turf the commentators that don’t appear to have a brain and simply repeat statements over and over again like some kind of dumbarse parrot – in other words the talkback crowd. Cameron Slater is pretty good example of the genre.

      In the usual link between stupidity, short-term thinking, arrogance, and conservative, the bulk of the right get winnowed here because they simply can’t help themselves. They drop into repetitive or troll behaviours, attack the authors, or pick up one of the other site’s Darwin awards that we will moderate for and ban on.

      There are some on the left with the similar dogmatic ways, but I generally find them either indignantly dropping off the site or changing their behaviour when they get a warning.

      Obviously I like the balance. It covers a pretty wide range of the political spectrum, it is pretty well limited to people who can and do argue mostly without too much rancour and aren’t too thin-skinned. And with the exception of the prohibitions about our losing authors allows a lot of freedom in what can be commented about.

      Tory-free politics site with reasonable traffic

      I have seen a few over the years – there were several interesting ones in the usenet days and you can find some quite doctrinaire ones in various places. I haven’t been that impressed. The further they seem to get from having to actually win votes in general elections, the less rational they seem to be.

      In my opinion their comments sections usually look distinctly like the bullying behaviour in the sewer. Fortunately they seldom seem to last that long as being busy with comments either.

    • lprent 9.2

      Oh and comments don’t seem to have that much of a correlation with page views, unique visitors or what data I have on clickthru. Those are what attracts advertisers and what the site gets paid for on the advertising.

      The best overall correlation for those things is with what is happening in the political world and what is not getting reported. We get enormous numbers of hits when the media start missing a story or trying to spin it. The Ports of Auckland dispute is the most recent example (26k page views in a day), with the Crafar farms one less so. I’ve been intrigued with this for a while because it tends to indicate that people bullshit meters go off the scale then and they come and see what we are saying.

  8. Same issue. Goes crazy once the comments get to about 50.

Recent Comments

Recent Posts

  • Minister of Foreign Affairs makes three diplomatic appointments
    Foreign Affairs Minister Hon Nanaia Mahuta today announced three diplomatic appointments: Alana Hudson as Ambassador to Poland John Riley as Consul-General to Hong Kong Stephen Wong as Consul-General to Shanghai   Poland “New Zealand’s relationship with Poland is built on enduring personal, economic and historical connections. Poland is also an important ...
    BeehiveBy beehive.govt.nz
    38 mins ago
  • Major redevelopment of Wainuiomata High School underway
    Work begins today at Wainuiomata High School to ensure buildings and teaching spaces are fit for purpose, Education Minister Chris Hipkins says. The Minister joined principal Janette Melrose and board chair Lynda Koia to kick off demolition for the project, which is worth close to $40 million, as the site ...
    BeehiveBy beehive.govt.nz
    3 hours ago
  • New expert group appointed to advise Government on Oranga Tamariki
    A skilled and experienced group of people have been named as the newly established Oranga Tamariki Ministerial Advisory Board by Children’s Minister Kelvin Davis today. The Board will provide independent advice and assurance to the Minister for Children across three key areas of Oranga Tamariki: relationships with families, whānau, and ...
    BeehiveBy beehive.govt.nz
    8 hours ago
  • COVID-19 vaccine slated for possible approval next week
    The green light for New Zealand’s first COVID-19 vaccine could be granted in just over a week, Prime Minister Jacinda Ardern said today. “We’re making swift progress towards vaccinating New Zealanders against the virus, but we’re also absolutely committed to ensuring the vaccines are safe and effective,” Jacinda Ardern said. ...
    BeehiveBy beehive.govt.nz
    21 hours ago
  • New ACC Board members announced.
    The Minister for ACC is pleased to announce the appointment of three new members to join the Board of ACC on 1 February 2021. “All three bring diverse skills and experience to provide strong governance oversight to lead the direction of ACC” said Hon Carmel Sepuloni. Bella Takiari-Brame from Hamilton ...
    BeehiveBy beehive.govt.nz
    23 hours ago
  • Economic boost for Southland marae
    The Government is investing $9 million to upgrade a significant community facility in Invercargill, creating economic stimulus and jobs, Infrastructure Minister Grant Robertson and Te Tai Tonga MP Rino Tirikatene have announced.  The grant for Waihōpai Rūnaka Inc to make improvements to Murihiku Marae comes from the $3 billion set ...
    BeehiveBy beehive.govt.nz
    1 day ago
  • Celebrating the Entry Into Force of the Treaty on the Prohibition of Nuclear Weapons
    [Opening comments, welcome and thank you to Auckland University etc] It is a great pleasure to be here this afternoon to celebrate such an historic occasion - the entry into force of the Treaty on the Prohibition of Nuclear Weapons. This is a moment many feared would never come, but ...
    BeehiveBy beehive.govt.nz
    5 days ago
  • Supporting disabled people to stay connected
    The Government is providing $3 million in one-off seed funding to help disabled people around New Zealand stay connected and access support in their communities, Minister for Disability Issues, Carmel Sepuloni announced today. The funding will allow disability service providers to develop digital and community-based solutions over the next two ...
    BeehiveBy beehive.govt.nz
    5 days ago
  • Voluntary saliva testing offered to quarantine workers from Monday
    Border workers in quarantine facilities will be offered voluntary daily COVID-19 saliva tests in addition to their regular weekly testing, COVID-19 Response Minister Chris Hipkins said today. This additional option will be rolled out at the Jet Park Quarantine facility in Auckland starting on Monday 25 January, and then to ...
    BeehiveBy beehive.govt.nz
    5 days ago
  • Next steps in firearms buy-back
    The next steps in the Government’s ambitious firearms reform programme to include a three-month buy-back have been announced by Police Minister Poto Williams today.  “The last buy-back and amnesty was unprecedented for New Zealand and was successful in collecting 60,297 firearms, modifying a further 5,630 firearms, and collecting 299,837 prohibited ...
    BeehiveBy beehive.govt.nz
    5 days ago
  • Jobs for Nature projects target iconic ecosystems
    Upscaling work already underway to restore two iconic ecosystems will deliver jobs and a lasting legacy, Conservation Minister Kiri Allan says.  “The Jobs for Nature programme provides $1.25 billion over four years to offer employment opportunities for people whose livelihoods have been impacted by the COVID-19 recession. “Two new projects ...
    BeehiveBy beehive.govt.nz
    6 days ago
  • New Public Housing Plan announced
    The Government has released its Public Housing Plan 2021-2024 which outlines the intention of where 8,000 additional public and transitional housing places announced in Budget 2020, will go. “The Government is committed to continuing its public house build programme at pace and scale. The extra 8,000 homes – 6000 public ...
    BeehiveBy beehive.govt.nz
    6 days ago
  • Prime Minister congratulates President Joe Biden on his inauguration
    Prime Minister Jacinda Ardern has congratulated President Joe Biden on his inauguration as the 46th President of the United States of America. “I look forward to building a close relationship with President Biden and working with him on issues that matter to both our countries,” Jacinda Ardern said. “New Zealand ...
    BeehiveBy beehive.govt.nz
    6 days ago
  • Jobs for Nature funding will create training and employment opportunities
    A major investment to tackle wilding pines in Mt Richmond will create jobs and help protect the area’s unique ecosystems, Biosecurity Minister Damien O’Connor says. The Mt Richmond Forest Park has unique ecosystems developed on mineral-rich geology, including taonga plant species found nowhere else in the country. “These special plant ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Pre-departure testing extended to all passengers to New Zealand
    To further protect New Zealand from COVID-19, the Government is extending pre-departure testing to all passengers to New Zealand except from Australia, Antarctica and most Pacific Islands, COVID-19 Response Minister Chris Hipkins said today. “The change will come into force for all flights arriving in New Zealand after 11:59pm (NZT) on Monday ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Bay Cadets learn skills to protect environment
    Bay Conservation Cadets launched with first intake Supported with $3.5 million grant Part of $1.245b Jobs for Nature programme to accelerate recover from Covid Cadets will learn skills to protect and enhance environment Environment Minister David Parker today welcomed the first intake of cadets at the launch of the Bay ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Cook Islanders to resume travel to New Zealand
    The Prime Minister of New Zealand Jacinda Ardern and the Prime Minister of the Cook Islands Mark Brown have announced passengers from the Cook Islands can resume quarantine-free travel into New Zealand from 21 January, enabling access to essential services such as health. “Following confirmation of the Cook Islands’ COVID ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Supporting communities and landowners to grow employment opportunities
    Jobs for Nature funding is being made available to conservation groups and landowners to employ staff and contractors in a move aimed at boosting local biodiversity-focused projects, Conservation Minister Kiritapu Allan has announced. It is estimated some 400-plus jobs will be created with employment opportunities in ecology, restoration, trapping, ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Border exception for some returning international tertiary students
    The Government has approved an exception class for 1000 international tertiary students, degree level and above, who began their study in New Zealand but were caught offshore when border restrictions began. The exception will allow students to return to New Zealand in stages from April 2021. “Our top priority continues ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Tiwai deal gives time for managed transition
    Today’s deal between Meridian and Rio Tinto for the Tiwai smelter to remain open another four years provides time for a managed transition for Southland. “The deal provides welcome certainty to the Southland community by protecting jobs and incomes as the region plans for the future. The Government is committed ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • New member for APEC Business Advisory Council
    Prime Minister Jacinda Ardern has appointed Anna Curzon to the APEC Business Advisory Council (ABAC). The leader of each APEC economy appoints three private sector representatives to ABAC. ABAC provides advice to leaders annually on business priorities. “ABAC helps ensure that APEC’s work programme is informed by business community perspectives ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Govt’s careful economic management recognised
    The Government’s prudent fiscal management and strong policy programme in the face of the COVID-19 global pandemic have been acknowledged by the credit rating agency Fitch. Fitch has today affirmed New Zealand’s local currency rating at AA+ with a stable outlook and foreign currency rating at AA with a positive ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Additional actions to keep COVID-19 out of NZ
    The Government is putting in place a suite of additional actions to protect New Zealand from COVID-19, including new emerging variants, COVID-19 Response Minister Chris Hipkins said today. “Given the high rates of infection in many countries and evidence of the global spread of more transmissible variants, it’s clear that ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • 19 projects will clean up and protect waterways
    $36 million of Government funding alongside councils and others for 19 projects Investment will clean up and protect waterways and create local jobs Boots on the ground expected in Q2 of 2021 Funding part of the Jobs for Nature policy package A package of 19 projects will help clean up ...
    BeehiveBy beehive.govt.nz
    3 weeks ago
  • New Zealand Government acknowledges 175th anniversary of Battle of Ruapekapeka
    The commemoration of the 175th anniversary of the Battle of Ruapekapeka represents an opportunity for all New Zealanders to reflect on the role these conflicts have had in creating our modern nation, says Associate Minister for Arts, Culture and Heritage Kiri Allan. “The Battle at Te Ruapekapeka Pā, which took ...
    BeehiveBy beehive.govt.nz
    3 weeks ago