Archive for the ‘how to’ Category
« Older EntriesA first stab at a perl script to create Twitter friend/follow matrices
Tuesday, July 14th, 2009
Geek alert: if the title of this post isn’t a dead giveaway I should tell you — unless you’re interested in APIs and badly-put-together bits of code — this probably isn’t for you.
I’ve recently found myself using a service provided by Damon Clinkscale called DoesFollow. All it does is answer the simple question “does twitter user A follow twitter user B?” Apart from a frill which lets you reverse the order of your question (“does twitter user B follow twitter user A?”) that’s all it does. You can even interrogate it from the address bar like this: http://doesfollow.com/barackobama/mediaczar
While I was thinking about how useful a service this is, I was suddenly struck by a moment of clarity. A lot of the research I’ve been doing could be simplified by something like this.
(more…)
Tags: kludge, network analysis, networks, perl, twitter
Posted in hack, twitter | 6 Comments »
Counting Twitter followers
Saturday, January 24th, 2009
TwitterCounter, the service that tells you how many people followed a given Twitter user on a given date (among other things) has an API – so I thought I’d take a look at it to see whether I could create a quick automated table of rankings.
Here’s the simplest way to query the API:
[code]
http://twittercounter.com/api/?username=mediaczar&output=xml
[/code]
Just cut and paste that into the address bar of your browser for example. Fairly simple. Change the username and you’ll get the data for a different user. Here’s what you get back from the API — an XML file with lots of rich meaty data:
(more…)
Tags: google spreadsheets, twitter, twittercounter, xml
Posted in hack, pipes, twitter | 3 Comments »
The Technorati Authority Yahoo! Pipe
Wednesday, January 7th, 2009
Over the holidays, I started playing with a new Yahoo! pipe to pull information from Technorati into a spreadsheet. The reasons why I wanted to do this are covered in this post about the quantitative analysis of blogs, and my eventual perl-based solution to the problem is covered in this post.
The problem with the perl-based approach is that it’s a little inaccessible to people who aren’t comfortable using a command line environment. So I really wanted to make something that more people would feel comfortable using, and perhaps play around with.
So, with some help and kind words from Bob Briski, one of whose pipes I’d stumbled across and bookmarked during my research for this project, I decided to finish off the pipe and publish it so that others could use it, or (better still) improve upon it.
(more…)
Tags: google docs, google spreadsheet, pipes, technorati, yahoo
Posted in blogger typology, hack, how to, pipes | 10 Comments »
A simple perl script to interrogate the Technorati API
Saturday, January 3rd, 2009
Sometimes (for instance when I’m doing the research for the blogger typology) you need to get a whole load of Technorati data for a whole load of blogs.
This research can (of course) be done by hand. And (of course) for a long list of blogs this would take a great deal of time. Handily, Technorati provides developers with an API that lets you automate those queries. An API (for those of you who don’t know) is an Application Programming Interface – a toolkit provided by a service or application (in this case by Technorati) that lets other computer applications ask it questions and use the answers for their own purposes. It may be helpful to think of APIs as being like the knobs on top of a Lego brick that let you stick other Lego on to it without in any way changing the nature of the brick itself. On the other hand it may not be so helpful after all.
(more…)
Tags: api, bloggers, blogs, perl, research, technorati
Posted in blogger typology, hack, how to | 8 Comments »
Referring to “this cell” using Excel conditional formatting
Sunday, December 28th, 2008
Since writing this post, three simpler, better ways of solving the problem have been submitted in the comments section. Feel free to read this post, but look to the comments for the solution!
If you already know about conditional formatting and navigated here via Google, please jump straight to the hack. If not, I hope the following introduction is useful. You might also like to check out the WikiHow introduction to conditional formatting in Excel. This post is actually concerned with an interesting hack that lets you reference the value of a cell itself when setting up formula-based conditional formatting rule.
Conditional Formatting
Excel’s conditional formatting feature is a boon to heavy spreadsheet users like me. It is a flexible and powerful tool that (among other things) lets me highlight data according to a set of rules so that I can easily spot the interesting bits in what would otherwise be an almost impossibly dense and meaningless cloud of numbers. Here’s an example; a table of the correlations between 32 different statements (taken from some ongoing work looking at a simple blogger typology.)
Tags: conditional formatting, excel, hack
Posted in hack, how to, research | 8 Comments »
Use RSS to Track Thousands of News Sources Easily
Friday, July 4th, 2008
OK – I’m not sure about the “thousands”, but Marshall Kirkpatrick’s article shows how you can use a combination of tools and tricks to get the most out of your RSS feeds – without getting swamped. Useful stuff!
Influence Mapping: The Maverick Cop Way (Part 2)
Wednesday, June 18th, 2008

The story so far: In the last episode of Influence Mapping: The Maverick Cop Way, we discussed a simple process for organizing what you know about influencers. We discussed briefly the decision making unit model we were using, our (very broad) definition of “influencer”, and showed how we can score them quickly for the three key variables reach, authority, and “ease-of-use”. At the end of the process, we found ourselves with something like this:

Now we’re going to go a little further, and show how we can map the relationships between the various stakeholders. This is the second and final post, and it may introduce a lot more that’s new to you. But stick with it – it might be worth it.
What you’ll need before you start
You’re going to need UCINET, a programme that analyses matrices and networks. It comes along with another programme from the same publishers (Analytictech) called NetDraw that draws networks. You’re going to want both. UCINET costs $250 for a corporate license, but the first 30 days are free. NetDraw is a free download.
They only work on Windows, but I’ve not experienced any real problems running them on a Mac using Parallels.
1. Create a matrix
Take your list of influencers (as per the table above), and add in the four key players from the decision making unit; the initiator, the decision maker, the purchaser and the end user.
Paste them down the left hand side of your table, and along the top edge, as in the illustration below. Excel’s Edit > Paste Special > Transpose command is useful, not to say essential, when you’re doing this. At the end of the process, you should have something that looks like this.

The rows show the influencers, the columns show those being influenced, the targets.
Because we don’t think that an influencer can exert influence themselves we drop a line of zeroes down the diagonal. This is more to help us navigate than anything else. Don’t feel you have to do this.
2. Fill in the matrix
Go through the rows one by one, deciding if a given influencer has any effect on the targets (the column headings). So for example, we know that the initiator influences the decision maker, and so on. But knowledge of the end user may well influence the decision maker, too. So – for example – when I’m choosing my dad a computer, I take into account the fact that he’s not so au fait with technology, and that if he can’t use it, he’s going to call me to ask for tech support. So I’d better choose something that will limit these calls.
At the end of the process, you’ll end up with something like this (although probably much bigger). It can take quite a lot of time to go through this process – this may be one of those times when you want to work with a partner to bounce the ideas around.

Tags: audience, influence, mapping, networks, planning, public relations, tool
Posted in how to, influence | 2 Comments »
how to: create alternate row-shading in Excel
Monday, December 31st, 2007
Why would I want to do this?
I think it’s easier to scan along lines if you colour alternate rows, particularly when you print out your sheets. Gridlines are somehow a little disorienting. You may not find this, and you may prefer the big black borders approach. But if you don’t, read on.
What’s wrong with the way I do it?
Well, if you’re doing it by hand, you’re going to run into two problems.
- Depending on how many rows you want to shade, it can take a long time.
- When you delete or add cells, you can throw off the whole thing, and have to start again
These are sufficiently irritating that it’s worth sharing this approach.
More to the point, I wanted to test out some new screen capture software (
Alternate row shading in Excel
Tags: excel
Posted in how to | 1 Comment »







