Estimating Social Media usage within a geographic area

I’m an enthusiastic supporter of the adage ”go where the people go” if you want to connect with customers and service users. I believe it applies equally – if not more – in the virtual world, than the physical world.

I don’t pretend to be an expert – far from it – but because I keep on banging on about social media, colleagues have started asking me about it. One of the questions I really struggle with is: “what is the actual take-up of social media in Hampshire?” (which is where I live and work).

This is the first in what will probably turn in to a series of posts documenting my search for some answers.

Hampshire

To briefly set the scene, Hampshire is a large county in the South of England, covering around 1,420 square miles. Major cities include the historic capital of Wessex: Winchester, and the major ports of Southampton and Portsmouth. Most of the county falls within 25 miles of Winchester, which is handy for reasons I will explain in a moment.

If you want more detail on Hampshire, there are loads of stats and other information on the County Council’s Facts and Figures web pages.

Map showing population estimates within 10 25 and 50 miles of Winchester

Map showing population estimates within 10 25 and 50 miles of Winchester

Social media usage: Existing studies

According to the BDO Local Government report From Housing and Litter to Facebook and Twitter:

  • 77% of the population has a social media account
  • Half of Facebook’s users log on every single day
  • 18% of pensioners have their own account on a social media network

There’s lots of evidence at a national or international level that social media use is on the increase. Recent examples include:

  • A report by Fishburn Hedges states: “In only eight months, the number of British consumers who have dealt with companies through social media has almost doubled – from 19% in August 2011, to 36% in April 2012″
  • According to Internet World Stats:
    • there were 52,731,209 Internet users in the UK in Dec.31, 2011, with a 84.1 % penetration
    • there were 30,485,180 Facebook users on Mar 31/12, with a 48.6% penetration
  • An average of 57% of people said they use the Internet for Social Networking (91% of 16-24 year olds), according to the Office for National Statistics (ONS)
  • Weekly use of mobile for social networking has increased from 15% in 2010 to 29% in 2011, according to Ofcom’s Adults Media Use and Attitudes Report

This is only a small selection, and there are many colourful infographics charting the success (or otherwise) of the bigger social platforms like Facebook, Twitter, Pinterest, Youtube and LinkedIn. The trouble is, there’s little – if any data – available publicly at anything more detailed than country-level. Some of the infographics are also of pretty dubious quality, and it’s getting difficult to know which you can trust.

I therefore decided to have a go at gathering some data myself. I’ve started with the platform with the largest number of users worldwide: Facebook.

warning: geek

Please don’t rely on any of the number in the following section, as it’s all work in progress.

 Facebook

If the estimates of a national Facebook penetration mentioned above are correct (around 48.6%), and with a population of around 1.7 million, we might expect approximately 826,200 Facebook users in Hampshire*.

I’m not personally a big Facebook user – I do have a profile, and sometimes venture in to Facebook-land to comment on friends or relatives updates or upload the occasional photo – but I’m by no means a Facebook native. Having tried and failed to find published sources, I had a go at searching within Facebook, but didn’t get very far.

The Digital Engagement Guide

The Digital Engagement Guide

Thankfully, there’s a brilliant resource: The Digital Engagament Guide which is full of ideas and practical help for digital and social media in the public sector. I submitted a question through the web site and a couple of days later the answer was published.

The answer was pretty simple – ‘pretend to be an advertiser’. Kudos to Dan Slee who shared this tip originally.

You just have to fill in a few fields like country and city, and then select any other criteria you’re interested in like gender, age and interests. I’ve had a go at collecting data for users within 10, 25 and 50 miles of Winchester. I’m most interested in numbers within 25 miles of Winchester, as that covers the majority of the county.

Facebook small business users in Hampshire by gender and age range

Small business users by age range

I recorded the numbers in a Google spreadsheet, and produced some charts, a few of which are included in this post. I plan to re-jig (technical term) the spreadsheet so it’s better organised, and repeat the exercise in a month. If it looks worth continuing after that, I’ll automate the process, as it’s pretty laborious (and not really how I like to spend my weekends). I reckon something like Scraperwiki should be able to handle the automation, although I’d really welcome any suggestions on how best to do it.

Charts and initial observations

I’ve spent most of my time gathering data so far, and haven’t really done much in the way of analysis. Here are a couple of charts, the first showing the number of users within 25 miles of Winchester, split by gender:

The second chart shows small business owners in the same area. This is obviously dependent on people saying saying in Facebook that they own a small business, so the numbers do need to be taken with a pinch of salt.

The third and last chart is a good example of some of the difficulties encountered when trying to make sense of the numbers. A quick comparison between the number of Facebook users within 10 miles of Winchester and population estimates for the same area suggests there are MORE Facebook users for some age groups than there are people in the area!

A possible explanation is that population estimates are based on a static address, and people actually move around a great deal, posting updates in Facebook as they go. This theory seems to be supported when comparing the lines on the chart for mobile and total Facebook usage.

That’s it for this post

I’m already late posting this for WeeklyBlogClub, and had to invoke the squidgy deadline this week. I can also smell my supper burning, so I’ll sign off at this point. If you’ve made it this far, thank you for persevering.

If you have any thoughts or suggestions, links to material etc I’d be really grateful if you would leave a comment.

* According to the figures I collected, there are just over 700,000 Facebook users within 25 miles of Winchester and just over 1.5 million within 50 miles.

I’m interested in lots of things, in no particular order: society, politics, public services, open data, technology (and what you can do with it), wildlife, photography, the countryside, and long distance walking.

Tagged with: , , , , , , , , ,
Posted in Facebook, Hampshire, Social Media, Technology, weekly blog club
7 comments on “Estimating Social Media usage within a geographic area
  1. Reblogged this on live free range and commented:
    Brilliant post, really well thought through.

  2. markbraggins says:

    I’m really pleased you enjoyed it Jennifer, and thanks very much for reblogging it.

  3. Louise says:

    Such useful tips – thanks Mark!

  4. Ken Burbary says:

    Mark,

    Good post on an important topic. It’s historically been difficult to precisely target social interactions and conversations to a specific geo/region/area. If you haven’t already, I suggest looking at tools like Geofeedia, which are leading the way in this space. https://geofeedia.com/

    Ken

  5. markbraggins says:

    Ken,
    Thanks for leaving a comment. I have signed up for Geofeedia, but haven’t spent much time exploring it yet. It’s on my to do list.
    Thanks,
    Mark

7 Pings/Trackbacks for "Estimating Social Media usage within a geographic area"
  1. [...] Estimating Social Media usage within a geographic area by Mark Braggins. Share this:TwitterFacebookLinkedInPinterestMoreEmailRedditPrintDiggStumbleUponTumblrLike this:LikeBe the first to like this. This entry was posted in apps, communicating, data, digital technology, local government, public sector, working practices by weeklyblogclub. Bookmark the permalink. [...]

  2. [...] could find very useful to give some indication on how effective their social media use could be: Estimating Social Media usage within a geographic area. Kate Bentham revealed just how many social media accounts she has (or is it even more? read the [...]

  3. [...] markbraggins Bilbo Braggins, blogging Skip to content HomeProtoHubTesting, testing, 1, 2, 3…Attempt to embed DebategraphExperimental Interactive Word CloudsQR CodesTestTagsexplorer for IslandGovCampTools I likeAbout ← Estimating Social Media usage within a geographic area [...]

  4. [...] markbraggins Bilbo Braggins, blogging Skip to content HomeProtoHubTesting, testing, 1, 2, 3…Attempt to embed DebategraphExperimental Interactive Word CloudsQR CodesTestTagsexplorer for IslandGovCampTools I likeAbout ← Estimating Social Media usage within a geographic area [...]

  5. [...] in estimating social media use within his county. The first part was published in Week 27: Estimating Social Media usage within a geographic area . He includes lots of illustrations in this latest [...]

  6. [...] CodesTestTagsexplorer for IslandGovCampTools I likeTrade FlowTrade Imports and ExportsAbout ← Estimating Social Media usage within a geographic area We love #lgovsm [...]

  7. [...] area to see if it bore any relation to national & international stats. Posts about that are here, here and [...]

Leave a Reply

%d bloggers like this: