This post was originally written for Comms2Point0 and was published on https://comms2point0.co.uk/comms2point0/2022/3/30/april-fools-day-for-the-public-sector. A massive thank you to Darren Caveney for publishing it.I have reproduced it here with the tweets embedded as part of my own personal archive of my work. I am a big fan of social media pranks – especially on April Fools’ Day. …
A friend of mine works in the NHS. She is an awesome writer, but worries as she struggles to produce video content for her social media channels. When I sent her this fantastic piece of award-winning kinetic typography written by Thread And Fable, and designed by Lynn PR, she loved it – and responded: Jeeez, …
Recreating Kinetic Typography… using PowerPoint??!! Read More »
Andrew… I’ve got a list of postcodes… Is there a way to use Excel to find out which local authority they are all in…? Yes… but first a few caveats! (or just skip to the code) Excel is a “quick and dirty” solution – If you are doing this properly you’d use GIS, but Excel …
This is another note to self, on how to clean performance data extracted from Twitter Analytics. Tweet ID Due to the length of Twitter ID’s Excel turns the ID into scientific notation and so the ID is not exactly right.Luckily, that can be extracted from the Permanent Link using the following excel formula: Twitter account …
One of the things that I have to do regularly is export data from Facebook pages of Facebook posts. I import the data to Excel to clean it and analyse it. One of the frustrations with this is that some of the dates in the data source get formatted as US dates, and some of …
The map goddess @AngharadStone posed an interesting poser on Twitter last night. @AngharadStone Good question. Do you mean the full postcode or just the first part? B, BB, DD, E, G, LL, M, N, NN, S, SS, W. — BX Postcode Area (@BXpostcodearea) December 31, 2016 It seemed like an interesting problem, so I thought …
This tweet caught my eye earlier this month: @AccLeicsPolice @nickkeane @TrueBlueLine Better version with Scotland. CoLP is at over 800… pic.twitter.com/aK8FcVDDQJ — Alex Ray (@AlexJTRay) December 3, 2016 For each of the police forces in the UK (ex BTP, Civil Nuclear Constabulary and City of London*) Alex has worked out the proportion of people served …
What proportion of local people follow police accounts on Facebook? Read More »
Unicode (the standards body that decides what emoji are available) have released guidelines to address the lack of diversity in emoji. The ethnicity guidelines were released last year (and at the end of August the last major vendor – Google – implemented them). The gender guidelines are not yet ratified, but vendors are already starting …
In the last week Twitter has quietly announced a little change that could should have an enormous impact on how the public contacts public sector organisations in the future. The rumours are that Facebook is heading in the same direction.
As they might have said in Zoolander… What with instagram revealing 56% of UK comments include at least one emoji, it being declared the fastest growing language EVER, journalists writing news articles in emoji and someone even translating a film into emoji. My fave emoji fact of the last month is that Instagram won’t allow you to search …
