Planning your content migration – a dull but essential task

May 28th, 2010 2 comments

Migrating the content of a council website can be a pretty intimidating task. The typical local government site will have thousands of pages, pdf downloads and images. Depending on the way you work you might also have a couple of hundred content owners/authors to think about.

Having recently gone through the migration process at Southwark Council I thought I’d share how we went about it and what we learnt along the way – what worked well and what we would do differently.

To give you an idea of timeframes, we first started planning for content migration in August 2009, carried out the migration in January 2010, did quality checks and rewrites throughout February and then launched the new site at the end of March 2010.

Step 1: Know where you stand

August 2009: The first thing we did was ask our CMS support company to provide us with a spreadsheet listing all the content on the site. We wanted to know:

  • Folder structure – how many levels deep did the content go? Where was the bulk of the content located and how many pages were there in total?
  • Creation dates and review dates – how long had pages been in existence and when were they last updated?
  • Content owners – how many gaps were there in content ownership? How many authors did we have, how many pages did they own and when did they last log in to the CMS?

The findings of this review were that we had:

  • 2,630 live pages  - of which 1,489 had not been reviewed in the past six months. Aargh!
  • 1,389 unpublished or archived pages
  • More than 300 CMS author accounts but only about 50 ‘active’ authors

Step 2: Cut the crap

My advice – before you even think about migrating anything you should delete everything you can.

Start by looking at your stats

We had implemented Google Analytics on the site about a year previously so we had enough data to see what information was popular, what search terms were used – and just as importantly – what pages nobody was looking at.

Patterns among council sites don’t differ much. On an average month just 30 pages accounted for almost half of all page views on the site (not counting the homepage and search).

July 2009

Section Page views Pages
Planning 36,377 Planning, Planning applications, Planning and building control, Search the planning application register
Job vacancies 22,477 Jobs and careers, Schools vacancy bulletin
Housing 14,359 Housing and homes, Southwark Homesearch, Properties to let
Libraries 12,259 Southwark libraries, Library catalogue – renewals, requests, Library locations
Schools and Education 11,234 Find a school, Education and learning, Schools in Southwark
Payments 9,797 Payments, Debit or credit card over the internet
Contact 9,413 Contacts, A-Z of services, Contact us
Rubbish and Recycling 8,892 Recycling, Environment, Household refuse collections, Bulky collections
Events 8,024 Events diary, What’s on, Discover Southwark, The Event
Council Tax and Benefits 7,960 Council tax and benefits, Council tax
= 140,792

Set some basic criteria for content culling

  • How many visits does the page have to get to make it worthwhile? If it hasn’t been viewed more than ten times in a month is it really necessary?
  • When was it last updated? Does the page have an owner? Can you verify that the information is up to date and correct?
  • Is there a statutory need for the information to be online?
  • Give it a sanity check. Is anyone still interested in the results of a 2005 football tournament?  Has the event/consultation you’re advertising been and gone?

So, between August and December:

  • We cut the number of live pages by 20%
  • We filed the remaining archived and unpublished pages into a ‘do not migrate folder’ – just in case it turned out there was anything worth keeping (there wasn’t).
  • We worked with authors on priority areas of the site to make sure that they were reviewed before migration. By priority I mean pages with a high volume of traffic or that contained essential information e.g. child protection
  • All authors were given notice that a content freeze was going to be put in place in January and were asked to check their content beforehand. A few last minute training sessions were provided in order to make sure everyone was able to update their information.

Step 3: Plan your information architecture

If you’re moving all your content from one CMS to another it is the perfect opportunity to review the structure of your pages and do some thorough user research.

We were working on the move to a new content management system and new design but there was no way in the world we wanted to keep the same information architecture.

We had previously had five headings: Your Council, Your Community, Your Services, Discover Southwark. Unsurprisingly enough 75% of content was found under the heading of ‘Your Services’.

We’re lucky within local government to have the local government navigation list. Don’t get me wrong, I think it has a lot of flaws but it gives a great starting point. I’d used the LGNL at Winchester City Council so already knew it pretty well, and was aware of some of the issues around its ‘poly-hierarchical’ and all-embracing (kitchen sink included) nature.

I don’t believe anyone else should dictate your IA – it needs to be tailored to your local community, focusing on local priorities and using the language of your residents not central government.

So, we used the LGNL as our basis, stripped it down, moved things around and compared about 100 other council sites to see if there was anything we wanted to copy. For example, through our knowledge of Southwark it was decided that regeneration deserved to be a top level category, rather than be tucked in under planning.

Step 4: Getting to the actual migration process

Migration can be slow and boring and there will always be a temptation to outsource. My personal choice would be to avoid this.

Migration does not equal copy and paste

Don’t listen to anyone who tells you migration is just copy and pasting or that they can ‘write a script for it’. If that is all you are doing you are wasting a brilliant opportunity.

Give a small team of e-comms professionals a style guide and the remit to delete and re-write bad content they will work wonders with your website, ensuring that pages are jargon-free, up to date and that they cross link to other relevant pages within the site. You just can’t get that from a robot.

If you can use people who actually already know a bit about your council they will also pick up all kinds of potentially embarrassing things lurking in the deepest darkest depths of your site…

Start small and simple

Take your migration plan and test it out on a small section of the site. Choose a section that doesn’t require very regular updates e.g. the business section and check that everything goes as expected. It probably won’t so it is useful to know what the problems might be as soon as possible. And by migrating the more static content first you run less risk of having to duplicate the work down the line.

Verify as you go along

If you can, get authors to check their content once it has been moved over to the new CMS and it has gone through your initial quality checks.

If you have time you might also ask managers, then portfolio holders, then all staff to look for problems. Some of these will be quick fixes and some will be more fundamental problems but if you know what all the issues are you then have the choice about whether to fix them prior to launch.

The more internal buy-in you can get during this phase the easier your life will be post launch.

Step 5: And finally

  • You can’t put lipstick on a pig! Allow enough time for internal quality checks of the content before going live. No one will care about a new design etc if the content is rubbish.
  • Make sure you have easy access to your old site for at least a few months after you launch. No matter how rigorous you are, sometimes things get missed.
  • It doesn’t have to be perfect. It probably never will be, but you do need to make sure that the top pages, and the key tasks are tested sufficiently prior to launch.
  • Ensure you have enough people power post-launch to fix problems quickly.
  • Get authors re-trained as quickly as possible

Introducing and integrating social media into your intranet

March 15th, 2010 No comments

So, not content with spending all my waking hours working on the redesign and relaunch of Southwark Council’s website, a couple of months ago I also agreed to speak at a conference on public sector intranets – namely on how to introduce social media.

I’ve managed a couple of council intranets now and they always seem to play second fiddle to the website.  But, after spending a bit of time researching this presentation I’m starting to feel more inspired about all the great tools that are now available and how some organisations are using them.

So, this presentation is less about what I’ve done at Southwark and more about how to get started in the world of social media within a public sector organisation – what must be a daunting task for most! I have gleaned most of what I know from a couple of very generous bloggers/tweeters – namely Sharon O’Dea and Ingrid Koehler, whose sites you should check out if you haven’t already.

Anyway – here is my take on the subject. Let me know what you think and if you have any good case studies.

Categories: Social media Tags:

Social media in a local government campaign – a case study

August 10th, 2009 3 comments

**UPDATE – shortlisted for Digital Excellence in CIPR Local Public Services Group’s Excellence in Communications Awards**

I was yabbering away in one of the Building the Perfect Council Website (#pcw09) plenary sessions a couple of weeks ago about how council comms/web/marketing people should just dip their toe into the water of social media – and was surprised by the general feeling of hesitation in the room.

My thinking: if you’re worried it might backfire or fall flat on its face just make it clear to everyone that it is a ‘pilot’. If it works, ‘excellent – the pilot was successsful, hooray’. If it fails ‘well, it doesn’t matter – it was only a pilot’.

(Pilot idea stolen from chief storyteller Tony Quinlan’s talk at LGComms conference earlier this year)

So, I thought I’d share an example of how we dipped our toes in the water at Southwark – and how it turned out pretty well. Not to say it wasn’t a steep learning curve but it was a fun one – and more to the point, a worthwhile one.

The case study below has been entered into the Digital Excellence category of the CIPR Local Public Services Group’s Excellence in Communications Awards (fingers crossed). A similar entry won Silver in the LGComms & LGA Reputation Awards for Best Environmental Campaign.

Background

Prior to December 2008 Southwark Council had no social media presence and no policy in place for using Facebook or Twitter. In fact the newly-established e-communications team had never used social media to implement a marketing campaign before.

So when Mayor of London Boris Johnson launched his ‘Help a London Park’ grants competition we considered it a perfect opportunity to pilot the use of a Facebook campaign.

Objectives

Our campaign had some key objectives:

Win Boris’s millions

Our main objective was to win the Mayor’s top grant of £2 million for Burgess Park which at 50 hectares sits in the poorest part of one of London’s most deprived boroughs, surrounded by sprawling 70s housing estates.

We had the added motivation that if we secured the £2 million we would then receive a further £4 million in match funding from Southwark Council and the New Deal for Communities.

Get local people actively involved
Burgess Park is central to a massive £2.5 billion regeneration scheme but as it stands, residents consider it “unloved”, “in need of a redesign”, and “unsafe after dark”.

Yet for most of the 70,000 people living within 5km of Burgess Park it is their only accessible, local, quality green space.

A particular focus of the campaign was to engage these local people, encourage them to take ownership of their local area and feel proud of their park.

Strategy and implementation

From the moment the shortlist was announced to the date of the decision there were just 10 short weeks. With a limited budget and a restrictive timeframe for planning and delivery we decided online media would be our most powerful tool.

The target audience for our campaign was Burgess Park users – young people, families and students not typically involved in council activity – as well as the local voluntary sector and community groups.

Our social media approach

We knew from research that our residents are keen Facebook users and that thousands of members already belonged to Southwark-related groups.

We created the group ‘Back the Burgess Park bid – we need Boris’s millions!’, allowing local people to get actively involved but in an informal, less traditional way.

Our approach was to:

  • Choose an alliterative, eye-catching and amusing title for the group
  • Use friendly, jargon-free language that focuses on the park and the people – not on the council’s involvement
  • Give enthusiastic calls to action

We took a grass-roots approach to building a Facebook presence, knowing that people are far more likely to buy in to an idea if they hear it from their peers rather than their council. We wanted to create a word of mouth effect

We launched a range of social media applications, including a YouTube channel, Twitter account and Flickr photo library to help raise awareness of the campaign – all linking back to the Facebook group.

Other ways of driving traffic to our Facebook group included news stories on the council’s website homepage, links from the parks web pages, items posted in the local online community forums e.g. SE1, and prominent features on local newspaper websites and on the Friends of Burgess Park website.

We sent email messages to supporters over the weeks updating them on any news or events and encouraged them to provide their suggestions on what they wanted to see improved in the park.

Developing an integrated campaign

We recognised that our social media approach would work best if supported by traditional media.

Stakeholder support: Briefing notes from the Leader went to local strategic stakeholders including the police and NHS, asking them to write letters supporting the council’s bid, and also encouraged them to sign up to the Facebook group.

Councillors and influential local groups such as Friends of Burgess Park were briefed and asked to join our social media campaign.

We also arranged for Boris to receive hundreds of children’s drawings, as well as letters from local schools in support of the bid.

Internal communications:
E-newsletters were sent to council staff and a series of news stories were published to the council‘s website and intranet.

Events: More than 500 locals turned out to support two concurrently run Help a London Park voting events – many of whom received the invitation through our Facebook group. Council staff donned blonde Boris-lookalike wigs to provide imaginative photo opportunities.

Presentation: A well thought-out presentation was made to the GLA panel, including a short video of resident voxpops (see YouTube video below). Exhibition panels produced by the Young Friends of Burgess Park expressed their aspirations for the park.

Media: We specifically targeted publications we knew the judging panel read, e.g. Horticulture Week.

Partnering the Southwark News provided weekly positive stories and the popularity of the Facebook group was used as a hook to sell stories into the trade and London press.

Evaluation and measurement

On March 4 2009 the Mayor of London announced that Burgess Park had won the transformational £2 million grant!

The Facebook group was considered a major factor in the park’s success and an example of good practice for the council’s new approach to online campaigns.

  • We invited no more than 10 people to join the group yet within 10 weeks the group had swelled to 1,135 members – demonstrating effective word of mouth
  • There were more than 80 posts to the wall and discussion forum about what people wanted to see happen to their park
  • On the whole messages were overwhelmingly supportive of the council and the bid

The group was a powerful way to demonstrate the strength of feeling in the local community. Real people with honest opinions and experiences of the park provided depth to the campaign and the human face of the bid provided an emotive and convincing argument for us to win.

Comments made during the campaign

“Since I was a kid I regularly used Burgess Park to play football…but I always dreamed of just how good it would look if some serious money was spent on landscaping the park and making it feel like a destination. It still feels like a piece of reclaimed wasteland (which is what it actually is) and although funds have been allocated on an ad-hoc basis over the years to keep it looking vaguely presentable, Southwark Council have never had the budget to sort it out properly”

“Burgess park is such a huge green space in the middle of a very densely populated area. But, there is nothing to do in the park, the play facilities are awful, there is no designated footbal/basketball or tennis areas and it feels very unsafe and unkept. Please get some money to develop this rare open space in Central London for the people who live nearby.”

Comments made after we won:

“Yay this is amazing, good work. The lake is lovely i just really hope they put some lights up so we can walk through at night. YAY :)

“fantastic news,hope the money will be well spent on improving a great park!”

In the months since the announcement the Facebook group has been used to keep members informed of the progress and now forms part of the strategy to involve local people in the long-term future of their park.

Lessons learnt in the process have helped inform the social media policy for the council.

Positive media coverage

Throughout the campaign we received positive coverage in the South London Press, Southwark News, Horticulture Week, the Evening Standard and PR Week.

Our success was featured prominently on ITV London News, in the Evening Standard, London Paper and the locals.

Other evidence

An Ipsos-MORI survey carried out in the lead up to the parks announcement showed 83% of residents were satisfied with Southwark’s parks and open spaces – an all-time high.

Google for local government

August 9th, 2009 No comments

The local gov day at Google’s London HQ this week (#googlelocalgov) definitely gave me some food for thought. No, they didn’t have all the answers, but as a group we do tend to have a LOT of questions.

There are a few things I’ll be looking into over the next few weeks as a result:

1. Google Adwords - I want to see just how much bang a council can get for its £300 buck in adwords. The Hillingdon example (pdf) was very interesting.

2. Site Links – The links that appear under Southwark Council when you do a google search are probably already the most appropriate but I’m not sure the landing pages they take you to are totally up to scratch…

3. Being more garish and less subtle – if it really only takes eight seconds for someone to decide if they’re going to click through to anything else from a page we need to make things REALLY obvious. What are the pages we really want people to see? We need to make the links more prominent!

4. Make registration easy and useful – when we move to a CMS that allows registration we need to make it SIMPLE, show the benefits, be reassuring and transparent and avoid distractions. Test test test to make sure we’re not losing people at the same stage every time and make sure we get them to the finish line. Sounds obvious but it will take a fair bit of work to get it right.

5. Advertising on a council site – This isn’t a high priority and I’m not sure how well it would go down but it might be a consideration when looking at template design – particularly for the what’s on section of the site. I was quite impressed by some aspects of Nottingham Council’s what’s on section.

6. YouTube – I didn’t know that YouTube was the second most popular search after google. At Southwark we have a channel and a few videos on it but nothing particularly new or exciting. But I think this will take off soon. A couple of good examples were shown on the day:

I really like the way annotations have been used in this video:

I thought the Visit Blackpool video was original and entertaining:

Both of these examples relate well to the kind of campaigns that we’re running at Southwark Council…

7. Google maps – There doesn’t seem to be a ready answer about how councils should be using Google and Ordnance Survey maps so it makes it even more important that we work together. Residents don’t care what goes on behind the scenes – what they care about is being able to find local services. They’re not interested in the boundaries of a borough when they’re looking for their local park or nearest recycling centre.

There were plenty more subjects being discussed on the day but these are the key points I took away from the day.

Go to the Google local government resource centre for more info.

Social media checklist

August 1st, 2009 No comments

A few months ago the number of people asking for advice about Facebook, Twitter etc was starting to alarm me. I mean, at least they were asking questions and not plunging headfirst into their own online campaigns but still, talking people down from their big ideas was taking up a lot of time.

I would have to explain what the council’s stance was on social media, why we’d chosen that route and then ask a whole heap of questions about what they wanted to achieve, when, why, who etc.

Fortunately I work in a good comms team which plans the council’s communications and marketing work around campaigns that have to have clear objectives, and the rest of the council seems to be coming round to the idea of planning. Radical I know :-)

So, I pulled together some background research, examples of good practice (and bad) and now when someone comes aknocking I pass them:

1. An introduction – what is social media and how can it benefit the council

2. Some guidelines – outlining the council’s policy of corporate communications and a reminder that the same protocols about confidentiality etc still apply in social media

Then, if they’re not put off I give them

3. A social media checklist which follows the ROSIE rules: Research -> Objectives -> Strategy -> Implementation, -> Evaluation.

Anyone who wants to invest time and money in a campaign should be able to answer all these questions:

Research


What are people saying about us already?

Before you can take part in these conversations you need to know what people are already talking about, who they’re talking to, and where they’re having these conversations.

There are lots of places you can find out:

  • The council’s online forums
  • Local community forums
  • Councillor blogs
  • Facebook – including the council’s own wall and discussion topics
  • Twitter – including responses to council’s twitter, cllr tweets

What do you already know about your target audience?

  • Where do they go for their information? Local radio, local newspapers, forums?
  • Do you know if they use particular social media i.e. Facebook or YouTube?

Look at the demographics of the group you’re trying to reach e.g. age/gender. You have to go to them – where will you find them?


Objectives


What are you trying to achieve?

  • Improvements to a specific service? E.g. finding out what people want and giving it to them
  • Raising levels of awareness of a service
  • Increasing uptake or involvement
  • Increased value for money of a service. Will you be able to provide the same (or better) level of service for less money if you use social media?

For each of these points you need to have qualitative objectives that you can measure e.g.

  • Increased participation in housing strategy consultation by 20%
  • Decreased printing costs for events brochure by improving online search and providing an invite a friend facility
  • Video of Leader’s vision for the borough viewed by at least 4,000 people

Strategy


What do you want to talk about?

  • What do you want to talk about?
  • Are the issues controversial?
  • Any sensitive/ confidential/anonymity issues need to be considered carefully.
  • Will there be events advertised?
  • Will you post news?
  • Is there a timeline for actions?

Timeframe

  • For preparation
  • Need to factor time in to build up momentum online

How will you let people know about your campaign?

  • What offline/online publicity are you going to do?
  • Will you want to engage with the media – send press releases, do radio interviews etc?
  • Will you need to advertise your campaign through the council website – e.g. homepage news stories or the e-newsletter?

How will you deal with feedback?

  • Are you ready for what people have to say – how will you deal with questions?
  • What happens if you receive a torrent of negative comments?

How will you moderate people’s comments?

  • Are there going to be online discussions involved? Will you be asking for people’s opinions?
  • Who is going to moderate these comment?
  • How much time can you allow for this?
  • Do you know what our moderation policy is? E.g. when you should remove a post and how you go about it


Results


Before you start you need to know what you’re measuring

  • Were you able to engage people in new conversations?
  • Did you learn something about our residents/service/ etc that you didn’t know before?
  • Did members of the public learn something about us?

We need to be monitoring these conversations and collecting data.

You can do so by setting up RSS feeds from blogs and forums (RSS in plain English YouTube video) as well as by the traditional method of reading newspaper cuttings.

You need to identify what keywords you’re interested in – just ‘Southwark Council’ or ‘Heygate’, ‘Aylesbury’ etc?


Evaluation


When will you decide whether you have achieved what you set out to do?

  • Is there a specific deadline or climax of the campaign

You need to evaluate how you’re doing as you’re going along

  • If you aim to engage 1,000 people over the course of three months then do you know where you need to be after the first two weeks? Or at the half-way point?
  • Are people reacting positively to your presence on a social networking site?

Developing a social media policy

July 16th, 2009 No comments

When you’re representing your organisation through social media a bit of common sense goes a long way. But when there are a few of you involved it can be useful to have to have some guidelines in place.

We don’t have an official policy at Southwark Council but these are the headline principles I share with colleagues:

Don’t get offended


Council bashing is inevitable. We can’t be offended if people don’t like us we just have to respond positively.

Be polite and sympathetic and refer people to the customer service centre if they have a problem. If they are making a complaint then point them in the direction of the complaints procedure.

Be human


Social media works best when it’s facilitating conversations between individuals rather than organisations. You need to write in a personable and conversational style but avoid the use of ‘I’. Use ‘we’ instead if possible.

Work on the basis that if another council officer took over from you then members of the public should be unaware of the change.

Be professional


Facebook users should set up a work account if they wish to represent the council online. Do you want residents to see photos from your last party? No, didn’t think so.

Setting up a work account also ensures notifications will be sent to your work email address.

It is important not to abuse the good will of people who join your cause or group by intruding on their spaces – you can easily become SPAM.

Beware of elections


Purdah is imposed roughly six before elections. During this time the council is not allowed to communicate with members of the public about any new or controversial Government initiatives (such as modernisation initiatives, administrative and legislative changes).

If are unsure in any way it is better to be safe than sorry. Ask your communications colleagues for advice.