Presentations: Talking social at The Wall Street Journal

Here’s a list of presentations I’ve done since joining The Wall Street Journal six months ago. I thought it would be handy to gather my notes and slides in one place.

Coming up:


How to export a Twitter list to an Excel spreadsheet

Having created a Google spreadsheet from that dynamically adds follower counts, I wondered if there is a way to create a spreadsheet based on a Twitter list.

The Twitter API no longer allows you to do this but in my search I came across a useful tool for exporting Twitter lists.

TwExList allows you to export a Twitter list into an Excel spreadsheet, and what is particularly useful is that it gives you a summary of data.

imageFor example, you can:

  • Analyse follower counts*
  • See how active list members are
  • See when members joined Twitter
  • See the percentage of people who are verified
  • Analyse by location
  • Analyse by language

*Of course quality is far more important than quality but sorting by follower count can help a social media manager / editor see at a glance if any reporters with a large following are not verified.

I was able to create a spreadsheet from the WSJ staff Twitter listWSJ accounts Twitter listWSJ reporters based in EMEA and WSJ reporters based in London.

imageIt’s free to create a spreadsheet from a list with up to 50 members, it costs €0.99 for up to 100 members, €1.99 for a list of up to 500 members, €2.99 for up to 1,000, plus there are options for far larger lists. You can pay by PayPal or credit card.

Don’t be put off by the look and feel of the TwExList site (it looks a bit 1995); it’s an effective way of getting data from a list and well worth a few euro.

You don’t need to have access to the Twitter account that created the list as you can export data from any public Twitter list.

One tip: if you want to pull data on list members, you must copy and paste the url which points to the member list (the one with ‘members’ at the end of the url).

imageTwExList also allows you to export other data from Twitter.

Related: Here’s how to create a Google spreadsheet with dynamically updating Twitter follower counts 

Top tip for searching social media: Storyful Multisearch Chrome extension

I wrote about the Storyful Multisearch Chrome extension when it launched (here’s the post I wrote when I was at but want to flag it up to journalists who aren’t aware of it.

The browser extension was created for Storyful’s journalists to use to quickly search social media. The Storyful folk then generously open sourced Multisearch for all.

Link: Storyful Multisearch

Simply add a search term, check the boxes of the media you want to search and in the click of the button you get your results in different browser tabs.

This week I used Multisearch a number of times:

  • I used it to search for images of the mine disaster in Turkey

As I searched #Soma I spotted a story. I saw that people in Turkey and beyond were showing solidarity with the miners by creating human chains spelling Soma and sharing the photos on social media.

The search led me to create this Storify of the images, which was embedded on a WSJ blog and on the blog of our Turkish-language site.

  • I also used Multisearch to find images of a bomb scare outside the Bank of England

  • And I used it to search for images of an oil spill in Los Angeles

Disclaimer: The Storyful folk are now cousins of WSJ as News Corp acquired the social news agency in December.

5 things I learned at The Next Web conference

I was lucky enough to attend The Next Web conference in Amsterdam a couple of weeks ago.

Those of you who follow me on Twitter may know that I share quite a few @TheNextWeb links as it’s one of the sites I follow via RSS. (Here are other sites I follow.)

Here are a few of the things I learned at the conference. Most of these nuggets are not related to digital journalism directly but it’s good to learn lessons from beyond the industry.

1. 15% of the world’s population have helped digitise books

You know those (often annoying) Captcha codes you have to answer in order to make a secure transaction online? There’s a valuable byproduct aside from security.

The two random words displayed are actually words from a scanned book. Computers are not good at reading the words and require help from humans. By typing the words you are making sense of the books. The process is effectively data entry by the crowd two words at a time.

So far 1.1 billion people – or 15% of the world’s population – have helped digitise books in this way, Luis von Ahn, who invented Captcha codes, said.

2. People learning English as a foreign language will be able to take a standardised test via a mobile phone for just $20

Duolingo came to my attention as the site where language learners translate Buzzfeed articles.

It works like this: advanced learners translate Buzzfeed and CNN articles with several people working on the same article collaboratively. The learner gets a real rather than fictional article to translate; Duolingo brings in revenue by the service it provides which enables free language learning for anyone with a web connection.

Luis von Ahn, co-founder of Duolingo (and also inventor of Captcha codes), said:

"In a sense, CNN sponsoring language education." 

The free-to-learn site is now branching out and making standardised English testing affordable and possible via mobile.

A learner maybe in Brazil or Burkina Faso but will be able to use a Skype-like video conference option either on a desktop or mobile phone to take the test. Some smart checks are done to ensure the learner is not cheating, with the user showing the examiner all corners of the room, for example.

My colleague at WSJ Lisa Fleisher has written about the new test. It is due to launch tomorrow.

3. People spend just six minutes browsing a retail website

One of the sessions was on the future of shopping.

John Lunn, global senior director at Paypal, said the average teenager spends just six seconds looking at a website and the over 60s only go up to four pages deep into a website.

Lunn said:

"You have to help people make their decisions before they come to you." 

These are important lessons for news organisations. Not only do we need to find ways to ensure those who want to pay for our digital subscriptions make a decision before they come to us, we also need to think about the attention span people have when presented with an article page or homepage.

4. Audiences have their own audiences

That might seem obvious in the days of selfies, memes, YouTube and Twitter. But ‘the guy with the hair’ David Shing – who has the title of 'digital prophet' for AOL – provided a good summary of how brands are now storytellers.

I particularly enjoyed lines such as:

"We must start talking about mobile as the first screen not the second. Nobody walked into this room with a TV.”

This talk also discussed media overload and the fight for attention. And as digital publishers we should keep that oft-used abbreviation of tl;dr (too long; didn’t read) to mind.

But while there’s a drive to be brief, Shingy laid out an argument for longer reads. We’ve moved from the age of information to the age of social to the age of interest, he said. People want authenticity, and slow journalism is part of that.

5. Social scientists are studying social media connections

One of the tools social scientists have created is called NodeXL. It is open source and can be downloaded so anyone can turn Excel into a social media network browser, allowing you to display connections around hashtags, topics or people.

Social scientist Marc A. Smith said:

"We are interested in revealing the shape of the crowd." 

Here’s the social network analysis of #TNWeurope.

One week in social media at The Wall Street Journal

I was part of a panel discussion that considered a world ‘without social media' at the International Journalism Festival in Perugia on Friday.

I decided to illustrate this by talking about what The Wall Street Journal wouldn’t have done last week in a social media-less world. 

Saturday, 26 April

On Saturday, Sam Dagher, our Syria correspondent, would not have shared images of Aleppo. Sam had been to the city the previous week but did not share tweets and images while he was there due to safety concerns.

He tweeted once we was back in Damascus and we packaged his photos into this slideshow.

Sunday, 27 April

On Sunday, Giada Zampano and Liam Moloney would not have been sharing tweets and pictures from the Vatican on the occasion of the canonization of two popes.

We would not have pulled together social media posts from people in the crowds using RebelMouse.

Monday, 28 April

On Monday, we would not have gained Instagram insight into Gennady Kernes, the mayor of Kharkiv, who was shot and injured. This colourful character has more than 63,000 Instagram followers, with whom he has shared pictures of himself cycling, playing sport and with his pets.

Kernes is now recovering in Israel and yesterday shared a photo from his hospital bed.

Tuesday, 29 April

On Tuesday, we would not have used user-generated content in a video. Storyful verified and licensed the footage from Ukraine and we were able to use it in a video package.

Wednesday, 30 April

On Wednesday, Matt Bradley would not have shared WorldStream clips of the Iraq elections. WorldStream, social videos that are up to 45 seconds in length, provide colour, insight and a snapshot of a story.

imageThursday, 1 May

On May Day, the day of protests in Turkey, our Istanbul bureau chief Joe Parkinson would not have re-shared this photo.

In a non-social world, Patrick McGroaty would not have shared this 13-second clip of Mugabe arriving at an election rally in Harare, Zimbabwe.

And Heidi Vogt, our east Africa correspondent, would not have been following John Kerry and sharing tweets and images.

In a world without social media, The Wall Street Journal would not have used Facebook video and an Instagram image to tell this story of an oil train crash in Lynchburg. Both the video and image were verified and licensed by Storyful.


Friday, 2 May

On Friday, Matina Stevis, who is based in Brussels, would not have been tweeting on behalf of a journalist in Ukraine and would not have got a safety message out, warning journalists not to go to Slovyansk.

Bojan Pancevski, who is a Sunday Times reporter, found he couldn’t tweet. He therefore asked Matina, a friend, to share the message on his behalf. Matina tried logging into his Twitter account but could not get access so pushed out the message from her own account to her 35,000 followers.

Matina told me that other news organisations called her to find out more information and she was able to share what she knew.

In a world without social media Bojan would probably have sent a text message to Matina and a few others, but the warning message would not have been amplified.

My slides from the talk are here:

2 tips for using Facebook Follow as a journalist

I’m guessing that a major reason deterring journalists from activating Facebook Follow is a concern for keeping their personal and professional lives separate.

Once activated, Facebook Follow, (which used to be called Facebook Subscribe), allows other Facebook users to follow a person’s public updates. It is a one-way, Twitter-like follow without the need for a two-way reciprocal relationship of Facebook friendship.

Here are two tips:

1. Change your privacy settings so people who are not ‘friends of friends’ only get the option to ‘follow’, not add you as a friend.

I was recently at Facebook HQ in London with a colleague who is usually based in the Middle East. My colleague was saying that he gets Facebook requests from people he doesn’t know and wanted to encourage follows instead of friend requests. By hiding the friend request option, he does not have to decline requests.

2. Don’t let followers see the photos other people post on your timeline

Perhaps you don’t want your subscribers to see pictures of you added by a friend. For my Middle East-based colleague, this could avoid the potential embarrassment caused by a friend posting a picture of him drinking a beer on a night out.

Visual journalism and web video at BBC News

Last Wednesday I heard Angus Foster, world editor, BBC News online, speak at the Global Editors Network and Gazeta Wyborcza event in Poland. 

Angus explained how the BBC has increasingly shifted to visually-led storytelling and demonstrated this by showing what a BBC News web story would have looked like a few years ago, and how they would treat the same story today. The 2014 approach is one of including not one but a number of photos.

One thing that is particularly interesting is how BBC News uses analytics to look at the point on the average article page when people click away from a story. BBC News has responded by keeping readers on the page by including images.

Angus also shared examples of new experiments in video. Traditionally a broadcaster shooting for TV, BBC News is now thinking of formats that are best suited to web audiences.

Example 1: Ukraine crisis: BBC on board blockaded Ukrainian ship

Here reporter Christian Fraser takes you on a VICE-style tour, with shots including him transporting the camera equipment.

imageThe style is more informal than a shot-for-TV package.

Example 2: Five ways Crimea is becoming Russian

Example 3: Europe Explained: How the EU budget is decided


Angus said the informal style is “informing but not didactic” and “rough at the edges and authentic”.

Angus Foster also showed an important slide regarding mobile and traffic growth:

Tools for social storytelling and curation

Last week I gave a presentation at a Global Editors Network and Gazeta Wyborcza conference in Warsaw, Poland.

I talked about tools we use at the Wall Street Journal for live storytelling and how we curate these conversations on site.

I chose to share social tools that are free and open to all. Some of the curation tools are proprietary.

Tool 1. Twitter lists

We curate lists and share them so people can connect directly with journalists, whether reporting on elections in Afghanistan, Turkey or on the ongoing situation in Ukraine.

Tool 2: RT

The RT is simple yet so powerful. By retweeting updates and images shared on Twitter by reporters on the ground, followers of @WSJ get reports in real-time.

I blogged about the power of real-time reporting from Ukraine, Turkey and Syria so won’t repeat here.


We display some of the photos shared by our reporters on social media on WSJ using an in-house social slideshow tool. Here’s an example of a slideshow on Crimea.


A new in-house tool we have for curating social media and web content is the streaming story (built by my colleague Joe Kendall). The back end feels a lot like Storify and you can automate or manually pull in tweets, Instagram photos and more.

This example, which pulled in stories and tweets from our Syria correspondent Sam Dagher, was done as a test, but it demonstrates the idea. And the new streaming story looks great on mobile.

Tool 3: Reddit AMA

A Reddit AMA (Ask Me Anything) is a great way to introduce our reporters to new audiences. Pre-arranged at a set time (there is a request an AMA button here), the Reddit community can then ask questions to the host reporter.

Paul Sonne, our Russia correspondent who has been in Crimea, and Joe Parkinson, our Istanbul bureau chief, have recently hosted AMAs.


Reddit AMA highlights can then be curated and posted on site by pulling parts of the conversation into a Storify, a tool for telling stories using social media content.

Tool 4: Google Hangout

Google Hangout video chats are a great way of hosting a conversation with up to 10 people and broadcasting it live on YouTube.

We have done four in the last month or so, including on funding for startups in the Middle East, new routes for Emirates Airlines, inside our coverage of the Malaysia Airlines story, and just yesterday our Gerard Baker, our editor-in-chief, interviewed Alex Salmond, which was broadcast via a Hangout.

Tool 5: Tout

Tout is an Android and iPhone app for recording and sharing microvideo. WSJ reporters use it to film from the scene of breaking news events and to provide behind-the-scenes views of stories they are covering.


We curate these Tout clips using WorldStream, an area of our site dedicated to these social videos. I reported on the launch of WorldStream (by Mark Scheffler and Liz Heron) when in my former life at

Another way to use these short video clips is within a story. I embedded 30-second WorldStream clips shot and shared by Sam Dagher when he was reporting on the evacuation of Yarmouk, an area of Damascus. Here’s the blog post.

Here are my slides from the presentation.

How to search for Twitter lists if you can’t yet see the option in Twitter

Last week I posted to say Twitter is rolling out functionality to allow you to search for Twitter lists.

If you cannot yet see the option within Twitter, here’s the fix:

Great spot, Rob. And the even better news:

Hurrah! You can now search for Twitter lists

This is the best tweet I’ve seen all week. Or possibly the best Twitter-related news of the year:

I’ve been wanting to search for Twitter lists for yonks and recently blogged about this workaround, a Google site search:*/ukraine

Update: Actually, I have been corrected:

As a journalist it is so useful to be able to find and follow other people’s lists and get access to a curated collection of sources on a given news event.

I’m not yet seeing the list search on my Twitter account and understand it is a gradual roll out for both desktop and mobile. This is what it will look like:


Hurrah for @gilad and the other folk at Twitter search. Now should I just follow the people named in the above tweet or set up a Twitter list?