Home » News » Between the (spread)sheets with MHKs

Between the (spread)sheets with MHKs

The last wave of data

The last wave of data (image: opensource.com)

This, I promise, is the last post about social media and the Manx election – I’m putting all the data here in a spreadsheet you can browse yourself.

So if you’re a stats nerd or just love Microsoft Excel, tuck in!

I spent some time putting this together, so I may as well explain what each column is.

  • Name is the candidate’s name
  • URL is a clickable link to their Facebook Page
  • Date is the month (not date) they began running their page, in American date forma (month first)
  • Result is whether they won or lost
  • Constituency is where they stood
  • Posts is the total number of posts as of September 15
  • Likes is the total number of page likes as of September 15
  • Likes/post is how many page likes they had per post
  • Months is how long (in months) their pages have been active
  • Likes/month is how many page likes they got on average each month
  • Posts/month is how many posts they put on their page each month
  • Votes is the total number of votes they got on election night
  • #Cands is the number of candidates who stood in that constituency
  • Turnout is the total number of people who voted in that constituency
  • Votes/post is how many votes per page post each candidate received
  • Votes/like is how many votes each candidate got per page like
  • Votes/month is an average of the votes gained each month while the page was active.

Phew.

And here it is!

After the XL list of parameters and calculations, here’s the Excel spreadsheet:

And here’s a download like for anybody desperate enough to want their own copy: https://1drv.ms/x/s!AkSzB6LSEyF0iDcGogE8vie6e4DY

Conclusions

Er, they’re aren’t any – despite the troll on ManxForums trying to put words into my mouth.

It’s not some sort of claim being a Facebook wizard will get you elected. And it’s not a claim being technophobic will derail an election campaign.

It’s simply this: a look at the candidates who were tech-savvy enough to put together a Facebook page rather than use a personal profile to try to campaign on. As far as I know, it’s been the most active Manx election campaign in terms of social media use ever.

It’s simply interesting to see who was active on Facebook and how they fared at the count; no more, no less.

What’s missing

Well, if I’d thought about doing this early enough, I would have liked to have scraped data about posts and likes every day to give a more granular analysis.

And I haven’t looked at Twitter at all (it accounts for only 2.5 per cent of adults), or, for that matter  YouTube (which accounts for 22.5 per cent).

It might have been interesting to use language analysis to try to find out whether each post was positive or negative and try to work out an overall message from candidates: were they spreading their own policy messages or criticising that of others? That, in itself, would have been fascinating.

Maybe next time, although 2021 seems a long way away… Chris Thomas will have surpassed Wikipedia in terms of word count on his page by then!

If you’re thinking of standing in one of the local authority by-elections sparked by the general election, click here to see how Chips Cheese Gravy Media can help your campaign: 60 per cent of those who took training courses with us are now MHKs!

Facebooktwitterredditpinterestlinkedintumblrmail

2 Responses so far.

  1. wilf tomlinson says:

    Why only 40 candidates?

Leave a Reply to wilf tomlinson Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.