Even if you’re not familiar with the Google Analytics API, chances are that you’ve probably needed access. Maybe it’s because you need 5000 results from the GA interface, but your browser keeps crashing. Maybe you need more than 5000 URLs and you’re not in the mood to hack the URL in order to get it. Or maybe you just wish that you could perform month over month growth calculations quick and easily.
Well, today’s tutorial is about showing you how to get the data you need quick and easily - even if you don’t know your variables from your arrays. A clever Googler, Nick Mihailovski put together the Google Analytics Magic script which integrates with Google docs back in August 2012 - and it’s the best thing since sliced bread. Except, I’ve noticed that many marketers either don’t know about it, or find it too daunting.