Over the past few months, I’ve been working closely with the good folks at Pinqued to develop a Twitter metrics tool called PinqSheets. The idea for the product originated as an add-on service that Pinqued was offering to their TechKaraoke sponsors and clients. Basically, they had a series of scripts and utilities that gave clients insight into how much buzz was being generated by tracking different keywords and hashtags.
When Jen and Brian approached me and asked me to join the team, I immediately agreed with them that this thing had huge potential as a product offering to a wider audience, and off to work we went. Within two weeks, we’d created a UI shell and all the support systems for user registration and management. A few weeks later, we’d nailed down a pretty robust tweet collector and parser. Of course, this is something that always stands for more optimization, and before long we had a backend process that could easily parse a 100 million tweets a day (that isn’t a typo, by the way). All the while, we were testing out various graph-generating tools and finally settled on something both functional (powered by XML, so easy to configure) and quite lovely.
So, what’s the big deal? How is PinqSheets different? The basic idea is very simple:
1. Register and confirm your identity.
2. Start tracking keywords. (Any keywords you add get added to the collector process.)
3. Once we have data streaming in for you, you can generate and save different graphs.
4. Once you’ve got some graphs, start creating and saving reports right in the online tool.
5. Share those graphs and reports via email, Twitter, Facebook, and other social networks.
In other words, this tool isn’t about checking up on your own Twitter brand (although you could use it to track mentions of a twitter handle), it’s about tracking keyword usage on Twitter. You can visualize data as bar, line, pie, polar, scatter, and any number of other types of charts as well as plain old tables. You can combine keywords on a graph for comparisons. You can limit your data view to just a few days if you want, and slice the data hourly, daily, weekly, monthly, or annually.
Right now PinqSheets is in private beta. If you want to take a look around, just send a note to @bwoj on twitter, and he’ll set you right up.
