Looking beyond follower count

A fully interactive map showing everyone who follows BBH Labs (@bbhlabs) on Twitter. Also visualized as a heatmap.

Twitter is still something of a mystery to those of us in advertising and marketing. Everyone thinks they need to be on top of it, but no one is completely sure now to use it. Even fewer people have an idea of how to measure whether or not they’re using it effectively. Most of the time brands think about Twitter like this: Create an account, start tweeting, and then measure success by looking at how many followers we have. But that doesn’t tell you the whole story. In fact, that tells you almost nothing.

Here's a little something I wrote up about how to use the Twitter API and Google Fusion Tables to draw insights about those who follow you (and others) on Twitter. It's amazing how much data is publicly available, and the kind of analysis you can do with a few lines of code. If you ever wanted to know how to map 12,000 points on Google Maps, this is your chance to learn how.

Gelocation information provided by modern mobile devices puts analytics data into an entirely new context. Not only do you know what someone did and when, but now you know where. I'm particularly intrigued to see how these kinds of APIs develop in the future, and at what point brands start using public API data to aggressively target their competitors consumers in a very hostile manner. We aren't far away from the breaking point where you can challenge massive incumbent brands by targeting their most vocal consumers right outside of their house.

Filed under  //

Comments [3]

Microsoft Excel is slowly becoming obsolete

The other day Google released an API for their Fusion Tables project. For those that don't know what Fusion Tables is, well...

What is Fusion Tables? A product launched recently in Google Labs, Fusion Tables is a free service for sharing and visualizing data online. It allows you to upload data, share and mark up your data with collaborators, merge data from multiple tables, and create visualizations like charts and maps.

It's quite remarkable in its simplicity. I only wish this had been available last year when I needed it. You can read the original announcement about Fusion Tables from earlier this summer on the Google Research blog here.

Fusion Tables is a pretty cool product in its own right, and with an API it becomes an even more robust utility for quick trend analysis and a host of other quantitative endeavors. It's pretty amazing how easy Google has made it to create visualizations that would have otherwise taken hours to create by other methods.

But I think what's really remarkable is how Google is shaping their web-based products to challenge Microsoft. Excel has long been the de-facto standard for working with small data sets, but Google may actually be capable of challenging the status quo with a combination of Google Docs and Fusion Tables. While they aren't (yet) a replacement for Microsoft Excel by any means, together they offer a large part of the day-to-day functionality while providing a considerable amount of added value and unique functionality that Microsoft can't deliver on.

There are two things I'd really like to see in the future from Google:

  1. Better integration points between Google Docs, Fusion Tables and Google Analytics. Imagine a flow where you can merge Google Analytics data with sales, inventory, et al. data in a few easy steps. Powerful.
  2. The ability to run (even if limited) regression analysis. Right now Google Docs supports LINEST and a few other tools, but it's pretty limited.

Every day I find that I need Microsoft products a little bit less. And it's not just that I don't need them – I don't even want to use them anymore, because solutions like Google Docs and Fusion Tables are simply better, faster, and inherently easier to work with in a collaborative environment.

Understanding the massiveness of Google

At the time of writing this, Google has about 20,000 employees and over $30 billion in assets. It's a massive company, but it's hard to wrap your head around what 20,000 people look like or what billions in assets even means. The massiveness of Google is lost on most people, including myself until I started looking into it. I wanted to get a better understanding of how one might use things like Google Code, the Google App Engine, or the Google Web Toolkit.

A few interesting tidbits about Google:

  • 87 different Twitter accounts
  • Over 100 active blogs
  • Over 1,000 YouTube videos

You might have seen a few of their blogs, but they have so many that they have their own blog directory, including regional blogs which provide localized information to people all over the world. There are teams running project that I didn't even know existed, like the O3D API team – which is working on a multi-platform plugin that allows 3D rendering within the browser.

One of the ideas me and a few coworkers had a while back was to create a presentation along the lines, "Everything you ever wanted to know about Google." The thing is, you couldn't fit that into a presentation. You would have trouble fitting it into a 10-part series. I'm starting to think that it may be adventageous for companies, particularly digital companies, to have a person who's job it is to understand Google and everything they offer. Search is massive enough, but they also own YouTube – which is the largest content channel on the Internet. And now they are getting into phones and even operating systems. They offer APIs for almost everything. Understanding all those different points of integration and how they might fit into a site or application would be a huge asset.

Google isn't just a search company. In many ways, Google is the Internet. If tomorrow Google disappeared, the entire world would grind to a hault. Google isn't often ranked with the likes of General Electric, Royal Dutch Shell or HSBC Holdings; but it's just as important—if not more so. It is more intertwined in the lives of everyone than I think most people realize. And as they move into new territory with Google Wave and Google Voice, Google is just going to become a more integral part of our everyday lives.

Filed under  //

Comments [0]