Monthly Archives: November 2010

Content or design? Using analytics to identify your problem

editorial analytics

As an industry, online publishing has gone through a series of obsessions. From ‘Content is King’ to information architecture (IA), SEO (search engine optimisation) to SMO (social media optimisation).

Most people’s view of online publishing is skewed towards one of these areas. For journalists, it’s likely to be SEO; for designers or developers, it’s probably user experience (UX). As a result, we’re highly influenced by fashion when things aren’t going smoothly, and we tend to ignore potential solutions outside of our area.

Content agency Contentini are blogging about the way they use analytics to look at websites and identify which of the various elements above might be worth focusing on. It’s a useful distillation of problems around sites and equally useful as a prompt for jolting yourself out of falling into the wrong ways to solve them.

The post is worth reading in full, and probably pinning to a wall. But here are the bullet points:

  • If you have a high bounce rate and people spend little time on your site, it might be an information architecture problem.
  • If people start things but don’t finish them on your site, it’s probably a UX problem.
  • If people aren’t sharing your content, it may be a content issue. (Image above. This part of their framework could do with fleshing out)
  • If you’re getting less than a third of your traffic from search engines, you need to look at SEO

Solutions in the post itself. Anything you’d add to them?

CCTV spending by councils/how many police officers would that pay? – statistics in context

News organisations across the country will today be running stories based on a report by Big Brother Watch into the amount spent on CCTV surveillance by local authorities (PDF). The treatment of this report is a lesson in how journalists approach figures, and why context is more important than raw figures.

BBC Radio WM, for example, led this morning on the fact that Birmingham topped the table of spending on CCTV. But Birmingham is the biggest local authority in the UK by some distance, so this fact alone is not particularly newsworthy – unless, of course, you omit this fact or allow anyone from the council to point it out (ahem).

Much more interesting was the fact that the second biggest spender was Sandwell – also in the Radio WM region. Sandwell spent half as much as Birmingham – but its population is less than a third the size of its neighbour. Put another way, Sandwell spent 80% more per head of population than Birmingham on CCTV (£18 compared to Birmingham’s £10 per head).

Being on a deadline wasn’t an issue here: that information took me only a few minutes to find and work out.

The Press Association’s release on the story focused on the Birmingham angle too – taking the Big Brother Watch statements and fleshing them out with old quotes from those involved in the last big Birmingham surveillance story – the Project Champion scheme – before ending with a top ten list of CCTV spenders.

The Daily Mail, which followed a similar line, at least managed to mention that some smaller authorities (Woking and Breckland) had spent rather a lot of money considering their small populations.

There’s a spreadsheet of populations by local authority here.

How many police officers would that pay for?

A few outlets also repeated the assertions on how many nurses or police officers the money spent on surveillance would have paid for.

The Daily Mail quoted the report as saying that “The price of providing street CCTV since 2007 would have paid for more than 13,500 police constables on starting salaries of just over £23,000”. The Birmingham Mail, among others, noted that it would have paid the salaries of more than 15,000 nurses.

And here we hit a second problem.

The £314m spent on CCTV since 2007 would indeed pay for 13,500 police officers on £23,000 – but only for one year. On an ongoing basis, it would have paid the wages of 4,500 police officers (it should also be pointed out that the £314m figure only covered 336 local authorities – the CCTV spend of those who failed to respond would increase this number).

Secondly, wages are not the only cost of employment, just as installation is not the only cost of CCTV. The FOI request submitted by Big Brother Watch is a good example of this: not only do they ask for installation costs, but operation and maintenance costs, and staffing costs – including pension liabilities and benefits.

There’s a great ‘Employee True Cost Calculator‘ on the IT Centa website which illustrates this neatly: you have to factor in national insurance, pension contributions, overheads and other costs to get a truer picture.

Don’t blame Big Brother Watch

Big Brother Watch’s report is a much more illuminating, and statistically aware, read than the media coverage. Indeed, there’s a lot more information about Sandwell Council’s history in this area which would have made for a better lead story on Radio WM, juiced up the Birmingham Mail report, or just made for a decent story in the Express and Star (which instead simply ran the PA release UPDATE: they led the print edition with a more in-depth story, which was then published online later – see comments).

There’s also more about spending per head, comparisons between councils of different sizes, and between spending on other things*, and spending on maintenance, staffing (where Sandwell comes top) and new cameras – but it seems most reporters didn’t look beyond the first page, and the first name on the leaderboard.

It’s frustrating to see news organisations pass over important stories such as that in Sandwell for the sake of filling column inches and broadcast time with the easiest possible story to write. The result is a homogenous and superficial product: a perfect example of commodified news.

I bet the people at Big Brother Watch are banging their heads on their desks to see their digging reported with so little depth. And I think they could learn something from Wikileaks on why that might be: they gave it to all the media at the same time.

Wikileaks learned a year ago that this free-to-all approach reduced the value of the story, and consequently the depth with which it was reported. But by partnering with one news organisation in each country Wikileaks not only had stories treated more seriously, but other news organisations chasing new angles jealously.

*While we’re at it, the report also points out that the UK spends more on CCTV per head than 38 countries do on defence, and 5 times more in total than Uganda spends on health. “UK spends more on CCTV than Bangladesh does on defence” has a nice ring to me. That said, those defence spending figures turn out to be from 2004 and earlier, and so are not exactly ideal (Wolfram Alpha is a good place to get quick stats like this – and suggests a much higher per capita spend)

Hyperlocal Voices: Richard Jones, Saddleworth News

Hyperlocal voices: Saddleworth News

Richard Jones, an experienced broadcast journalist, set up Saddleworth News just nine months ago. He hoped to combine his journalistic ambitions with a demanding routine as a stay-at home-father whilst providing more online information about an area which he claims “was relatively under-served by the traditional media”. Although not an easy task, Jones has successfully used social media as well as local news stories in order to secure an expanding fan base. This post is part of the Hyperlocal Voices series of interviews.

Who were the people behind the blog,  and what were their backgrounds?

I set it up myself. I used to be a full-time professional journalist. I graduated from the Broadcast Journalism course in Leeds in 2002, then spent six years at Sky News working in TV and radio.

After we relocated to Manchester because of my wife’s career, I freelanced at various radio stations until we had our first child in September 2009 and I gave up work to become a stay-at-home dad.

What made you decide to set up the blog?

Lots of reasons really, but two main themes. I’ll admit the first was selfishness. I couldn’t really combine irregular hours as a radio journalist with being a full-time dad, but I knew that I wanted to return to full-time work one day, so I needed to do something to keep my hand in.

I was also worried about how I’d fill my days, even with a small baby to look after, so was keen to take on a project to help keep me occupied.

The other reasons were more altruistic. When we were thinking of moving to Saddleworth we realised that there wasn’t actually that much information about the place online. I also noticed that, for an area with such a distinctive character, it was relatively under-served by the traditional media. So I thought I could use my journalism skills to do something positive for the community we were about to move into.

When did you set up the blog and how did you go about it?

We moved to Saddleworth in January 2010 and I started the blog the following month. It’s a self-hosted WordPress site.

I’ve written other blogs before (and continue to write about being a stay-at-home dad at www.likefatherlikedaughter.blogspot.com) using Blogger so I had some very basic experience of running a site and tinkering with HTML a little.

I knew in my head how I felt it should look, so it was just a case of picking a free WordPress theme and after an evening playing around I had it more or less as I wanted. I’ve been very impressed with how user-friendly and reliable WordPress is.

What other blogs, bloggers or websites influenced you?

The main one was Kate Feld’s Manchizzle [interviewed previously in the Hyperlocal Voices series]. When I lived in Manchester I used to go to her blog meet-ups, then got into going to the Social Media Cafe Manchester evenings. When I had the idea of doing a hyperlocal site I got lots of encouragement and ideas from people there.

I think the first hyperlocal site I saw was Linda Preston’s Darwen Reporter, now sadly no longer running. I definitely copied the blog format from her.

I wanted to get away from the typical information-heavy newspaper websites, partly because I think they’re often a bit confusing, but mostly because I didn’t want to feel under pressure to update it more than once a day.  And if you do one story a day on a blog, there’s always something new on top of the site to keep it fresh for regular readers.

How did – and do – you see yourself in relation to a traditional news operation?

The similarities are to do with the basic skills of journalism. I still research stories, make phone calls, do interviews, write copy, take pictures, nurture contacts, take editorial decisions, just as I did when I worked in a newsroom. Although I have to compress all that into an hour or two each day during my daughter’s lunchtime nap!

There are plenty of differences, but one main one is that I don’t have to run my story ideas by an editor. So instead of hearing excuses like “I’m interested in that” or “Nobody cares” or “We did that last week/month/year” I can just do whatever I like.

For example, during the election campaign I decided to interview all the candidates standing in the general and local elections, so I went and did it. A local newspaper journalist told me he’d suggested the same thing, but his editor had said there “wasn’t space” in the paper for it. That’s the kind of public service a site like mine can provide.

What have been the key moments in the blog’s development editorially?

By far the biggest story of the year has been the local political situation. We had a bitterly-fought general election, a legal challenge, then the local MP Phil Woolas got found guilty of cheating and was thrown out of parliament.

I covered the campaign in much greater detail than anyone else at the time, and I’ve now built up a huge archive of articles about every aspect of the saga. It’s helped raise the profile and credibility of the site locally, and I’ve also given interviews and help to national journalists who have come to cover the story, which has hopefully given the site a bit of a wider reputation too.

The day of the Woolas verdict was the busiest ever for the site, with 1500 unique visits and a great amount of attention on Twitter. I have to take my daughter out with me on stories, and to their credit Oldham Council’s press team who were controlling the media let me into an ante-room so I could follow the verdict (I was doing Twitter updates with one hand, and trying to entertain her with a toy car in the other) and then into the news conference later.

I also had with me a crew of teenage media students from Oldham College who have been making some video reports for the site. I overheard someone say rather sniffily “Who are they covering it for, CBeebies?” but the fact people in this area are prepared to accept the site as legitimate journalism, no matter how unconventional some aspects of it are, I think says a lot about how far it’s come in such a short time.

What sort of traffic do you get and how has that changed over time?

I was amazed when the site got more than 6,000 unique visits in the first full month. It’s increased steadily since, and last month there were 12,000.

The Woolas verdict means there have already been more than that during November, so it’ll be another new record.

I haven’t spent anything on promotion apart from getting a few business cards printed, but Facebook has been a great way of growing awareness and building a regular audience. There are almost 700 fans on there now.

The best online projects that monitored Brazil’s 2010 Elections

“Last year, electoral reform opened the door for politics 2.0 by authorizing parties to use social networks to raise campaign donations and participate in streamlined debates”, claims Manuella Ribeiro about the recent Brazilian election that made Dilma Rousseff the new president.

Ribeiro made a compilation of the best online projects that worked on transparency, civic engagement and public policies monitors. Here are my personal favorites:

eu lembro

Eu lembro: “Be a voter with an elephant’s memory. Vote and remember everything that happens to politicians”.

VotenaWeb: “A site where you can approach the decisions of National Congress that directly affect your life. Vote and be heard”. Citizens can compare, with an easy interface, their votes on bills and the votes of politicians. The congressional bills are translated into simple language and you can monitor the voting records of different candidates.

Quanto vale seu candidato?: in English “How much is your candidate worth?” is a nice piece of data journalism with information about the patrimony of candidates.

eleitor 2010

Eleitor 2010: developed with Ushahidi to monitor the elections, receive and map complaints about electoral crimes through Twitter, SMS, email and social networks.

Adote um Vereador: encourages citizens to “adopt” a city councilman and open blog about their work to keep an eye on them and their parliamentary activities.

The News Diamond reinterpreted: “Let the crowd have the middle”

News Diamond showing area where journalists should focus - the edges

Shuler’s amended News Diamond showing area where journalists should focus – the edges

Jonathon Shuler has published a post exploring the News Diamond from my Model for a 21st Century Newsroom. As part of that he’s added an extra layer to the diamond showing which areas professional journalists should focus on, and which ones they should let go:

“Let the crowd have the middle of the diamond. Just let it go, our time there is ending. There’s too many of them, they are too fast, they will out man and out maneuver you every time that it matters to them–and if it doesn’t matter to them, I bet there’s not much of a market for it. Just walk away… and watch.”

He finishes by arguing that commercial journalism needs to raise the bar:

“The future of Journalism is not to become public service with the hopes of gratuity, but a professional service with professional expectations and results. If people are going to blogs and the crowd instead of your publications, it’s because your publication is not meeting the expectations of your audience. As a publication you have the choice to evolve to meet those expectations, find a new audience, or leave.”

Read his post in full here.

Comment call: Are you teaching data journalism?

On Monday The Guardian published an article about data journalism and the future of journalism. As part of that I was asked what university courses taught data journalism. I could only think of Glyn Mottershead at Cardiff and – probably – Steve Hill at Southampton Solent.

So let me ask: are you involved in – or study on – a course that covers any aspect of data journalism? That might be statistics, computer assisted reporting, or mashing, or something else. Please comment – I’d really like to know what’s out there.

Hyperlocal Voices: Cathy Watson, Uckfield News

Hyperlocal voices - Uckfield News

Cathy Watson, an experienced journalist, first set up the Uckfield News 3 and a half years ago to promote her PR business, which it has since outgrown. The site is “reactive”, says Cathy, both in the directions that it has grown, and in many of the stories that it covers: “Where I see people hunting for information, perhaps on Twitter or Facebook, about traffic hold ups or fires I make the calls to find and post answers but I don’t make the traditional daily calls.”

This is part of the ongoing Hyperlocal Voices series of interviews.

Who were the people behind the blog, and what were their backgrounds?

I set up the blog but my husband, Paul Watson, now helps with it. We are both journalists.

I have worked as reporter, news editor, sub-editor, deputy editor and acting editor moving, within one company, between the Bury Free Press, Newmarket Journal and Lynn News and Advertiser. After moving to Sussex I worked as a freelance for the Sussex Express.

Paul too worked in all jobs across the newsroom before becoming an editor. He edited free newspapers in King’s Lynn and Wisbech before moving to edit the Middy, (the Mid Sussex Times at Haywards Heath) and then the Sussex Express.

Most recently he has been looking at the future training of journalists in managing a project led by the National Council for the Training of Journalists supported by the Broadcast Journalism Training Council, the Periodicals Training Council and the Society of Editors.

The project has included a survey of employers of journalists, relevant education providers and new entrants to the profession.

He continues to work as an editorial consultant for the NCTJ.

What made you decide to set up the blog?

I started a PR business, wanted to attract the attention of local businesses and thought it would help to have an Uckfield News page on my website. I updated it daily with nibs (news in brief).

When did you set up the blog and how did you go about it?

I started the news page three-and-a-half years ago using the free Microsoft Office Live platform. After about 18 months I altered the focus of the site to Uckfield News and a year ago had a bespoke site built.

What other blogs, bloggers or websites influenced you?

None. I didn’t know people were setting up ‘hyperlocal’ sites. Everything I have done has been reactive, people liked the news so I added more of it, I tested a shopping feature and it led to the listings, the listings are now leading to more features and people who pay to list (so supporting the site) are, where possible, sources for stories.

How did – and do – you see yourself in relation to a traditional news operation?

Uckfield is on the edge of circulation areas of three paid-for newspapers. They cover the town well but can’t pick up the ‘nitty gritty’ because of commitments to other towns.

I’m particularly interested in planning applications, change within the town, shopping and business news. I concentrate on reporting facts, leaving people to add their views in the comment sections at the end of stories, and on Uckfield News Twitter and Facebook pages.

I also mix paid-for ad features in with the news.

Where I see people hunting for information, perhaps on Twitter or Facebook, about traffic hold ups or fires I make the calls to find and post answers but I don’t make the traditional daily calls and tend to avoid “shock, horror, probe”.

What have been the key moments in the blog’s development editorially?

Adding shopping, business and history features. They are a good way of bringing people back to the site on a regular basis.

What sort of traffic do you get and how has that changed over time?

It doesn’t seem long since I was pleased to have four or five visitors a day! Growth has been slow but by the time we launched the new site a year ago we were getting about 1,000 unique visitors a month.

In our most recent peak we hit about 4,500 unique visitors, 9,000 visitors and 25,000 page views. The figures have settled again to about 3,000 unique visitors, 5,000 visits and 14,000 page views a month but the trend is upwards.

Paul and I have the desire to cover everything that moves because old habits die hard! But I am reining back because I don’t want to do this without advertising support. I have just had the site altered to accommodate advertising and hope to start building that side of the business.

From journalist to blogger: the experience of The Lichfield Blog’s Ross Hawkes

Although I’ve already published an interview with The Lichfield Blog’s Philip John (as part of the Hyperlocal Voices series) I recently returned to ask the site’s editor, Ross Hawkes, about how his own approach as a professional journalist has been changed through running the site. I thought it worth publishing his response in full – here it is:

My background has been in regional journalism in Staffordshire and the West Midlands. I began at the Lichfield Post as a fresh-faced 16-year-old, so it’s quite ironic that I’ve pretty much gone full circle in the space of 12 or 13 years, yet have never been happier. I started off as a sports reporter, then branched out into page design, edited a weekly paper in Coventry before making the move to the dailies at the Birmingham Mail as a page planner and sub-editor. So I’ve had a fairly varied career even though it hasn’t taken me a million miles from my own doorstep. It also skilled me for The Lichfield Blog because I got to see some patch reporters in the greatest sense of the word – people who lived and breathed a community. My integration into the online landscape came after the opportunity arose to take on their web operation.

My time in this role saw me eventually become Senior Multimedia Editor for the Midlands. I’ve been lucky as a journalist in changing times – I’ve been able to spend time learning about the positives and negatives of online work, what works and what doesn’t etc, while many of my colleagues in the industry have had a timescale imposed on them.

But for a variety of reasons the chance to teach online journalism at Staffordshire University came up and here I am today. One of the things I’m keen to stress to students is that I’m not a geek (I leave that to Phil!) but a journalist who has found practical uses for technology etc. During my time at Trinity Mirror I saw plenty of great things, but in a busy newsroom only so much of it could really be of benefit. So that’s what I try to get across to my guys and girls here.

Anyway, back to journalism. Coming to Staffordshire I was really keen that I didn’t want to become rusty – but at the same time I didn’t want to burden myself with freelance concerns, especially in a market which didn’t offer many opportunities anyway. I was also mindful that there were plenty of out-of-work journalists who needed paid employment more than I did. So I decided that I’d write about what I know – basically, where I live. It astonished me to discover that for a city (albeit a small one) there was nowhere to get a regular taste of life here online. Even the newspapers were struggling to fill the void for anyone interested in ye olde city. Although the early versions of The Lichfield Blog were crap, with nothing more than me trying to provoke a response, I soon found that there was a desire for somewhere to discuss Lichfield. Crucially, there was an audience.

Admission time – I never got the value of Twitter as a full-time journalist. But in wanting to grow an audience for TLB I learned how to use it to my benefit. In effect it has been the driving force behind the site. It was at a Tweetup in the early days that I discovered the appetite for the site. It was also where I was able to hook up with my professional other-half – Phil. And herein lies the first journalistic lesson I picked up from The Lichfield Blog. I quickly acknowledged that I wasn’t an expert in everything and that other people held the key to the success of TLB. By working with people like Phil I’ve been able to pull ideas and take suggestions and feedback from a non-journalistic source. I suppose it was collaboration in its rawest form. And we’ve worked like that ever since. Phil has been invaluable and anyone thinking of going hyperlocal needs to find a Phil. With his expertise in the technical side of it, it has allowed me to concentrate on my strengths. So what did Phil get in return? Well, I recommended a good hairdresser once…

So what have I learned from my hyperlocal experience? The Lichfield Blog allows me to enjoy what I do. I’m my own boss, I can try random things, if it doesn’t work I don’t have a news editor kicking my backside. It’s allowed me to be experimental and enjoy the career I’ve got. I like to think I’ve gone back to the future in terms of how I operate. Yes, it’s a new platform and it’s new media, but the basic skills are more needed than ever. It’s about knowing your patch inside out, it’s about attending community meetings and knowing local decision-makers, it’s about getting away from deadline and target driven writing – it’s about being a journalist. I’ve always loved local journalism deep down, that ability to know what makes a community tick. The Lichfield Blog has allowed me to do that and more. It’s given me the opportunity to see that partnerships are the way forward. I’ve also re-evaluated what I think (and that’s the crucial bit – my thoughts) media should be doing. We try to combine news and info. We try and make advertising affordable to local businesses. We try to do exactly the sort of things local newspapers did once upon a time. It’s perhaps not the formula to get me rich, but I never got into journalism for the money, so why should I change that now?

Government Spending Data Explorer

So… the UK Gov started publishing spending data for at least those transactions over £25,0000. Lots and lots of data. So what? My take on it was to find a quick and dirty way to cobble a query interface around the data, so here’s what I spent an hour or so doing in the early hours of last night, and a couple of hours this morning… tinkering with a Gov spending data spreadsheet explorer:

Guardian/gov datastore explorer

The app is a minor reworking of my Guardian datastore explorer, which put some of query front end onto the Guardian Datastore’s Google spreadsheets. Once again, I’m exploiting the work of Simon Rogers and co. at the Guardian Datablog, a reusing the departmental spreadsheets they posted last night. I bookmarked the spreadsheets to delicious (here) and use these feed to populate a spreadsheet selector:

Guardian datastore selector - gov spending data

When you select a spreadsheet, you can preview the column headings:

Datastore explorer - preview

Now you can write queries on that spreadsheet as if it was a database. So for example, here are Department for Education spends over a hundred million:

Education spend - over 100 million

The query is built up in part by selecting items from lists of options – though you can also enter values directly into the appropriate text boxes:

Datstrore explorer - build a query

You can bookmark and share queries in the datastore explorer (for example, Education spend over 100 million), and also get URLs that point directly to CSV and HTML versions of the data via Google Spreadsheets.

Several other example queries are given at the bottom of the data explorer page.

For certain queries (e.g. two column ones with a label column and an amount column), you can generate charts – such as Education spends over 250 million:

Education spend - over 250 million

Here’s how we construct the query:

Education - query spend over 250 million

If you do use this app, and find some interesting queries, please bookmark them and tag them with wdmmg-gde10, or post a link in a comment below, along with a description of what the query is and why its interesting. I’ll try to add interesting examples to the app’s list of example queries.

Notes: the datastore explorer is an example of a single web page application, though it draws on several other external services – delicious for the list of spreadsheets, Google spreadsheets for the database and query engine, Google charts for the charts and styled tabular display. The code is really horrible (it evolved as a series of bug fixes on bug fixes;-), but if anyone would like to run with the idea, start coding afresh maybe, and perhaps make a production version of the app, I have a few ideas I could share;-)

Libel advice for bloggers

Sense About Science – along with a whole raft of other organisations* – have published a libel guide for bloggers: ‘So you’ve had a threatening letter. What can you do?’ Below is the animated button they’ve created that practically begs you to click it and download the PDF.

I’m curious why they haven’t published it as a series of webpages to make it easier to find via search, and to link to – maybe I’m missing something. In the meantime, the PDF is well worth a download.

*Index on Censorship, English PEN, the Media Legal Defence Initiative, the Association of British Science Writers and the World Federation of Science Journalists.