Scraping Social Media Statistics


Something essential when working with social media is to keep track of the progress. There are many reasons to work with social media but no matter if it’s for marketing or brand building one needs to have some type of metrics to evaluate work. The simplest is just tracking amount of followers whilst other more complicated could be tracking user sentiment towards your brand.

This blog post describes how to “How to import social media data into a Google spreadsheet with the ImportXML function”. It lists how to do this for Linkedin, Pinterest, Alexa rank, Facebook, twitter, Instagram, Google+, Quora, Reddit and Youtube. Formulaes are working as of January 2016.

Posted in social media Tagged with: , ,

The 3 Best Copywriting Tricks

Icons made by Freepik from is licensed by CC BY 3.0

Guide your consumers as a shepherd would guide his flock (pastor).

P – problem
A – amplify
S – story
T – truth
O – offer
R – response

Present the problem, make it cumbersome by amplifying it. Create a story through the text, how to make if from failure to success. To make it become real you need to present proof on why they should listen to you by some truth. The importance of what you are selling is only 20% of importance, 80% is the change the product you’re selling will bring the customer. Finally end with a CTO (Call To Action).


A framework to keep in mind for any writing.

S – state
P – purpose
I – idea
N – next

The first step is always to know your audience. Who will read this text and why? What kind of setting will it be read in? Figure out what state the reader is in to properly adress the copywriting to reach him. What is your purpose for writing the text? What is the idea that will help the reader? What is the next step, make a clear CTO.


The 7 P’s

P – provoke
P – problem
P – personal
P – proof
P – product
P – proposal
P – prompt

Provoke the reader to grab their attention. Present the problem they’re facing and make it personal. Give some proof of authenticity and why you should be listened to. Describe the product and make a proposal of what change it will create in the reader’s life. End with a prompt (CTO)

Featured image: CC-BY 3.0, Freepik from

Posted in Branding Tagged with: , , , , , , , , ,

The View of the Pirate Party on TTIP (radio-interview)

stop ttip, cc-by-nc-sa, UweHiksch


Last week I did an interview in a student-radio about TTIP (see bottom of post to listen). I expressed the views that the Pirate Party holds and how this trade deal is problematic. In general, the Pirate Party supports free trade deals but with TTIP there are certain aspects we are highly against which is further explained in the radio show as well as below. You can find the complete view of the Pirate Party on trade deals (in Swedish).

‘Radio Utblick’ is a “program focusing on the issues of today’s society through a global perspective”. It’s a local student-radio show that was sent last Tuesday over the FM waves in Gothenburg, Sweden.

This time ‘Radio Utblick‘ will discuss TTIP, the large free trade deal between USA and EU that is currently negotiated. Critics mean that the negotiations are too secretive, that it gives businesses power on the behalf of citizens, that it threatens the food safety and the environment. The people supportive of the trade deal argue that it will improve Europe’s weak economic growth and that tying together the two largest economies in the world will give advantages on both sides of the Atlantic.

How is it that a deal that gathered three million signatures against it, as well as several hundred thousand protesters on the streets in Europe and US, still continues to be negotiated? This is something ‘Radio Utblick’ tries to shine a light on. With us we have Josef Ohlsson Collentine from the Pirate Party of Sweden (Piratpartiet) and Simona Mohamsson from the Liberal People’s Party (Folkpartiet)

My three main concerns about TTIP, that I lifted in the radio interview, were

1) The Copyright maximalizing agenda
2) Investor-state dispute settlement (ISDS)
3) The lack of inclusion of relevant stakeholders


(The show is mostly in English but contains segments in Swedish).

TTIP – Threat against society or a solution to the economic crisis? by K103 on Mixcloud

Featured image: cc-by-nc-sa, UweHiksch

Posted in transparency Tagged with: , , , , , , ,

Think Twice – Whistleblowers, Donations, Identity and Drones

I spent the weekend of 1-2 February  at a conference in Frankfurt, Germany. The conference was called Think Twice and was a conference organized by Pirate Parties International to “bridge [the gap] between the worlds of the Pirate Parties, Academia and NGO to foster a mutual exchange on ideas and experiences that are worth spreading”.

ppi pirate parties international think twice conference

Below are some of my notes from a few of the talks I attended. These are notes that are a mix of what the presenter claimed and what I understood.

Donations to Political Parties

Regulation of donations to political parties is important in order to prevent corruption and choices made on “income motivations”. One way of regulating donations would be to:

  • No donation from “legal persons” (companies)
  • Donation cap for persons
  • Transparency about political parties income/spending

Much of the funding to political parties goes to promoting themselves during elections instead of being spent “for the good of the citizens”. Money that comes from the state should not be used for flyers, banners and regular administrative costs. It should be used for:

  • Fees paid to the state
  • service for public (e.g. information campaigns about topics that concern them)
  • extraordinary international activities


Whistleblowing was a topic in several of the talks at the conference. Whistleblowing always starts with some choices. First of all, if you even look closer at things that look suspicious and how you judge this activity on a moral scale of right and wrong. The next part is a choice of neglecting what you see, avoiding it by leaving the organization or bring it up by giving the topic ‘voice’.

When you have seen a problem there are still three reasons you might choose to not whistleblow about it:

  1. Sociology – People generally strive towards harmony, avoid problems, have obediance towards authority and a loyalty to your workfriends over values
  2. Change? – Will it even change anything if I raise concerns
  3. Fear of retaliation – You might lose more than gained by bringing it public

Most people first try by raising concerns internally first. If internal does not work you need to find someone that is more powerful and can support you and your issue against the “blockade” of your opinion. A power fight will ensue, which is why whistleblowing often is the last step you take.

Most whistleblowers don’t see themselves as heroes, they often see the system they work within as a good system. This brings up another aspect of whistleblowing dynamics. You are probably not alone in seeing the problem but if you are the one blowing the whistle you are saying that “others did not see it” which might put them in bad light and make them your “enemies” as well. Even if you’re several people that have noted the problem it’s hard to join up since finding allies for whistleblowing means that you can’t be anonymous anymore.

When you find innovative, smart solutions for a company there are normally bonuses. It ought to be the same for people that find negative things for a company. Blowing the whistle on a crime can’t be a crime.

A legal protection for whistleblowers is not all that is needed. Legal law doesn’t care about the subject. Ideally a whistleblower should have at least a lawyer, a doctor (shrink), the union and a journalist on his side.

We’re living in an attention economy which means each whistleblowing can’t get deserved attention from media. We need public authorities to regain control. One of the things that would help would be a change of burden of proof for the whistleblower. If any sanctions happen against the whistleblower the company ought to prove this was not connected to the whistleblowing.

Media is not the solution to most problems. Journalists try to be very careful and have their own agendas and topics. There is very few investigative journalists and even then the newspaper has to agree to publish the story as well. Typically you need to create a “media wave” for something to happen, a task that is very hard to achieve.

Identity 2.0

Detailing your identity is a way to provide means to build and develop a coherent communication approach. An identity is important as an enabler to be situational in a transcultural context. Knowing what defines you will allow you to be reactive instead of proactive.

The pirate party is a bridge between politics and the “real world”. PP is an enabler for citizens to be active in democracy. The pirates are a bridge between the digital age and normal people.


There were a few talks about drones at the conference. I learnt that drones are much more common than I believed and used frequently, even outside of war. Only Germany owns ~871 UAVs (Unmanned Aerial Vehicles). The german railway company (DB) plan to use drones against grafitti users!

One of the scariest parts about drones is that they can be flying for days without landing at a height where you won’t be able to see them. With modern cameras they are getting more and more detailed analysis of what is happening on the ground. Combine videos from these drones with processing power in super-computer centers and they can detail a lot about people if they want. Having drones above you is very like an “eye in the sky”. Just the fact that “someone might be watching” will cause a change in behavior for people.

Posted in transparency

Top 7 Collaborative Tools for More Efficient Team-Work

Working with others online requires organization and good tools in order to be efficient. Having a good way of communicating, somewhere to share files and a way of managing tasks is essential for efficient work. These are some of the tools that work for best for me and I hope you enjoy them as  well.

TLDR; Short version

To share files use Copy (20gb free) or Dropbox (2.5 gb free). For writing collaborative use PiratePad or LiveMinutes. To organize your team’s tasks use Trello. For communication use  mail, Skype and Mumble.

working more efficient online in group or with projects

Sharing Files

The best way to share files is having a shared resource of them between the team. Putting them online in a cloud which syncs down changes and additions to your desktop is an efficient way of doing this. I used dropbox for a long time for this. It’s efficient and makes sure you can share folders easily with other team-mates. It also provides you with the security of always having a backup in case you hard-drive fails. Another better alternative I found recently is called “copy“, basically working the same way as dropbox but counting shared folder space divided by people sharing them instead of the way that Dropbox counts the same space as used for each person. Copy also gives 8x the amount of space that Dropbox does for new users!

Sign up with this link for a free 2.5 gb Dropbox account:
Sign up with this link for a free 20 gb Copy account:

Collaborative Writing

One normal problem of working in a team is passing around the same file to different people to add text. The problem is often that you send it back and forth through e-mail and sometimes have trouble of keeping track of which file is the newest version or try and make changes to the file at the same time. A better solution to collaborative writing is being able to work together in the same document seeing the live updates as the other person types. Google developed a product called ‘etherpad’ before they closed it down. Fortunately they released the code for it so you can use it on your own server if you want or just google “etherpad clone” and you will find several options. I mostly use one called (hosted by the Swedish Pirate Party). Another option is to use a service called LiveMinutes that gives you more control over several documents instead of just one.

Organizing Tasks

When you are working together you often need somewhere to keep track of all the small tasks that need to be completed and the progress with each one. Trello is an excellent tool for managing tasks, assigning persons, assigning due dates and everything else you need for keeping track of what needs to be done. Using trello will make your bigger projects much more manageable and easier to overview.


One of the most important part is communicating with your team. Mailing  back and forth is important to a certain extent but you need more channels to be efficient. Skype works great for medium/larger teams for holding a permanent group chat where you can give small asynchronous updates about progress and sometimes get instant feedback. A good compliment to the longer mails. Skype is also a good option for smaller meeting calls to discuss your project. For larger teams you reach better stability and quality of call using a tool such as Mumble that is optimized for voice-calls.

If you enjoyed this post please share it with a friend who you think might have use of it as well!

Picture: CC-BY, Chris Potter

Posted in Get inspired and create! Tagged with: , , , , , , , , , , ,

Josef Ohlsson Collentine

A transparent and kind American/Swede who likes cultural patterns and Social Media. A creative early-adopter who sports, discusses and explores. More about me
free counters