I’ve been thinking a lot recently about how to monitor, capture, measure and report. The good news is that there are ways of doing all of these. The bad news? None of them do it all.
Here’s the current state of play:
- Google Reader is really good for monitoring and going back through old posts, but not for displaying (eg charts and so on), and not for pulling out reports.
- Netvibes is great for display but useless for pulling out individual items to analyse, share or report on.
- Google Docs is great for display and analysis, and good at pulling in RSS feeds – BUT (and I only found this out after doing a lot of work) it only stores up to 20 RSS entries at a time. So, in other words, if you start monitoring pretty much anything on for example Twitter, that total is filled up within minutes and you have no way of knowing what else is going on.
- Excel is great for offline display and analysis, but it’s very clunky when bringing in RSS feeds and often crashes. Plus, it just appends without figuring out whether it’s duplicating content so your spreadsheets quickly become massive and unworkable.
See what I mean? Everything does something, but nothing does everything – unless you actually create your own databases and reporting and all that stuff, which I want to avoid.
So, what we need is:
- Google Reader – a decent front end and some sort of report producing facility – even output to CSV file would be good, for example.
- Netvibes – some way in which to readily share or mark items privately, as well as pull out reports from that.
- Google Docs – a vast increase in the number of RSS entries.
- Excel – a better way to interface with the web, ideally one that recognises items already pulled in. And some way of pushing content back online would be nice too.
Or: we need a package that displays as well as Netvibes; that enables sharing, tagging and general RSS manipulation like Google Reader; and that pulls in data as readily as Google Docs but with the capacity of Excel. One day someone will produce that. Until then, we just have to keep banging the rocks together.
Unless I’m missing something? Given that I seem to have about three readers nowadays, if just one of them could suggest an alternative, that would be great.