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.

Making magazine awards more user-friendly

Given I’ve already linked to Tony Hirst twice this week I thought I’d make it a hat-trick. Last month Tony wrote two blog posts which I thought were particularly instructive for magazine publishers organising blog awards.

In the first post Tony complained after seeing Computer Weekly’s shortlist:

“Why, oh why, don’t publishers of blog award nomination lists see them as potentially useful collections on a particular subject that can be put to work for the benefit of that community?

“… There are umpteen categories – each category has it’s own web page – and umpteen nominations per award. To my mind, lists of nominations for an award are lists of items on a related topic. Where the items relate to blogs, presumably with an RSS feed associated with each, the lists should be published as an OPML file, so you can at-a-click subscribe to all the blogs on a list in a reader such as Google Reader, or via a dashboard such as netvibes. Where there are multiple awards, I’d provide an OPML file for each award, and a meta-bundle that collects nominations for all the awards together in a single OPML file, though with each category in its own nested outline element.”

I’d suggest something even more simple: an aggregator widget pulling together the RSS feeds for each category, or a new Twitter account, or a Google Reader bundle.

In a second post the following day Tony finds a further way to extract value from the list: use Google Custom Search to create a custom search engine limited to those sites you have shortlisted as award-worthy. His post explains exactly how to do that.

Tony’s approach demonstrates the difference between story-centred and data-centred approaches to journalism. Computer Weekly are approaching the awards as a story (largely because of limitations of platform and skills – see comments), with the ultimate ending ‘Blog publisher wins award’. Tony, however, is looking at the resources being gathered along the way: a list of blogs, each of which has an RSS feed, and each of which will be useful to readers and journalists. Both are valid, but ignoring either is to miss something valuable in your journalism.

Statistics and data journalism: seasonal adjustment for journalists

seasonal adjustment image from Junk Charts

When you start to base journalism around data it’s easy to overlook basic weaknesses in that data – from the type of average that is being used, to distribution, sample size and statistical significance. Last week I wrote about inflation and average wages. A similar factor to consider when looking at any figures is seasonal adjustment.

Kaiser Fung recently wrote a wonderful post on the subject:

“What you see [in the image above] is that almost every line is an inverted U. This means that no matter what year, and what region, housing starts peak during the summer and ebb during the winter.

“So if you compare the June starts with the October starts, it is a given that the October number will be lower than June. So reporting a drop from June to October is meaningless. What is meaningful is whether this year’s drop is unusually large or unusually small; to assess that, we have to know the average historical drop between October and June.

“Statisticians are looking for explanations for why housing starts vary from month to month. Some of the change is due to the persistent seasonal pattern. Some of the change is due to economic factors or other factors. The reason for seasonal adjustments is to get rid of the persistent seasonal pattern, or put differently, to focus attention on other factors deemed more interesting.

“The bottom row of charts above contains the seasonally adjusted data (I have used the monthly rather than annual rates to make it directly comparable to the unadjusted numbers.)  Notice that the inverted U shape has pretty much disappeared everywhere.”

The first point is not to think you’ve got a story because house sales are falling this winter – they might fall every winter. In fact, for all you know they may be falling less dramatically than in previous years.

The second point is to be aware of whether the figures you are looking at have been seasonally adjusted or not.

The final – and hardest – point is to know how to seasonally adjust data if you need to.

For that last point you’ll need to go elsewhere on the web. This page on analysing time series takes you through the steps in Excel nicely. And Catherine Hood’s tipsheet on doing seasonal adjustment on a short time series in Excel (PDF) covers a number of different types of seasonal variation. For more on how and where seasonal adjustment is used in UK government figures check out the results of this search (adapt for your own county’s government domain).

Hyperlocal Voices: lovelevenshulme’s Tim Simmonds

Hyperlocal voices: Love Levenshulme

The latest in the Hyperlocal Voices series looks at love levenshulme. When its founder moved on the site was handed on to two other people – this year the blog won the Manchester Blog Award for ‘Blog of the Year’.

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

Lovelevenshulme was started by a gentlemen call Matt Clements who I have never met! He wanted to be positive about where he lived and so set up a blog.

What made you decide to set up the blog?

I was a reader of lovelevenshulme and liked the countercultural feel of being positive about a locality. I suppose I thought it was different from the standard moany English mentality.

Matt Clements wrote one day that he was moving out of the area and wanted someone else to take it over. So myself and Helen Power offered to talk it over.

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

We took over the blog and decided to carry on with his positive take. We looked around our area and decided to write about the things we love. This can range from kebab houses, poetry nights, film clubs and cafes. We also try and promote any local event or group.

We use Blogger because it is simple and easy.

What other blogs, bloggers or websites influenced you?

Levenshulme Daily Photograph, Inside the M60, Manchester Mule, Manchizzle, Fat Roland, Sounds Good to me Too

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

I don’t see us a news operation. We are very biased in our love of Levenshulme and have decided that we won’t write about things that aren’t positive. There is enough of that in the blogosphere already.

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

We won blog of the year at Manchester Blog Award 2010. I think that helped us to realize that being hyperlocal and positive is actually quite unusual and powerful.

Linking properly with a Twitter feed and a Facebook fan page have helped us develop the community side of the blog.

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

Our traffic has only been tracked properly since August 1st 2010. We have seen our numbers double every month so far. I think we may now be at (or near) our peak (roughly 1500 hits a month)

How did you find taking on a blog that was already running?

Easy to be honest. The guy who set it up didn’t want to do it anymore and was happy for us to take it in whatever direction we wanted. In fact, he has emailed us since and been very complimentary indeed.

I guess the only problem we have is finding the information or local events but as the blog’s profile has grown people have been sending stuff through to us.

Using Yahoo! Clues to target your headlines by demographic

Yahoo! Search Clues - Emma Watson hair

Tony Hirst points my attention (again) to Yahoo! Clues, a tool that, like Google’s Insights For Search, allows you to see what search terms are most popular. However, unlike Insights, Yahoo! Clues gives much deeper demographic information about who is searching for particular terms.

Tony’s interest is in how libraries might use it. I’m obviously interested in the publishing side – and search engine optimisation (SEO). And here’s where the tool is really interesting.

Until now SEO has generally taken a broad brush approach. You use tools like Insights to get an idea – based on the subject of your journalism – of what terms people are using, related terms, and rising terms. But what if your publication is specifically aimed at women – or men? Or under-25s? Or over-40s? Or the wealthy?

With Yahoo! Clues, if the search term is popular enough you can drill down to those groups with a bit more accuracy (US-only at the moment, though). Taking “Emma Watson haircut”, for example, you can see that a girls’ magazine and one aimed at boys may take different SEO approaches based on what they find from Yahoo! Clues.

Apart from anything else, it demonstrates just what an immature discipline web writing and SEO is. As more and more user data is available, processed at faster speeds, we should see this area develop considerably in the next decade.

UPDATE: After reading this post, Tony has written a follow-up post on other tools for seeing demographics around search behaviour.

Yahoo! Search Clues - Emma Watson haircut - oops/katie leung