Google Data

Sophisticated, useful and cool applications are being developed everyday through the open Google Analytics API. We're loving what we're seeing. Basically, developers are grabbing their data from Google Analytics and slicing and dicing it, mixing it and mashing it with other data and applications, creating dashboards and widgets, and innovating some of the coolest stuff a data driven person could hope for. For example, we're really impressed with an app called Trendly which makes it easier to find important movers and shakers among your data via an innovative new interface, cutting down on the time you need to monitor your profiles. The team who built Trendly is using it as their one stop Google Analytics dashboard. We asked the team to share how this application came about, and here's what they wrote:

How many of you can afford to pay someone to monitor your analytics full time? We can't. We're a small startup, and we just don't have the resources to make that happen.

We use Google Analytics to track visits to our website, www.dabbledb.com. We'd love to have someone watching the hundreds of keywords, referrers, and campaigns that drive traffic to our site, someone who would send us a quick email whenever something really interesting happened: "Hey guys, thought you'd like to know that your average visitors from 'online database' doubled last week, and it's staying there - guess that SEO is working!"

So, using the Google Analytics API, we created Trendly, a monitoring and visualization tool which you can look at anytime and easily see what's changed. In short, Trendly uses mathematical models to take noisy data like this:

and figure out when significant changes have happened, marking it like this:

According to Trendly, our average daily visitors from the search words "online database" went up from 18 to 32 in mid-January, and then up again to 50 in early February. Also, Trendly sends us periodic emails to let us know about changes like these, saving us a lot of time. It also prepares a news feed with attractive charts that put the changes into perspective relative to everything else that's going on. Take a look at this - it calls out significant changes and makes them easy to notice with a timeline on the right.


When we first built Trendly for our internal use, we cobbled it together by screen-scraping and downloading exports from Google Analytics. But part of what made this tool exciting to us is that it solves a pretty universal problem. Trendly is your analyst until you can afford to hire a full time analyst. Heck, it probably keeps a clearer log of important changes than an analyst would! And with Trendly, you can delay this much longer since it cuts down your worflow by hours per week.

The new GA Data API allowed us to share it! With no signup and a couple of clicks, anyone can authenticate with Google and authorize us to grab their data and generate the reports. Suddenly our internal tool became a new product offering which can help any Google Analytics user. Give it a try and see for yourself.

What the guys at DabbleDB built is amazing. If you have developed a useful new tool or integration on top of Google Analytics, drop us an email at . If it's innovative and useful we'll highlight it to our readers on this blog.


Nick Mihailovski, The Google Analytics API Team