Welcome to the Q&A Forum
Browse the forum for helpful insights and fresh discussions about all things SEO.
Oh yeah, that's totally doable using the API. I wrote a post on how to use Excellent Analytics, a free Excel plugin that's very user friendly. But you can set up individual calls to the API for each profile/account from one spreadsheet and then just refresh the data when you need to. You can also create charts from it and refresh them by clicking the Refresh button in Excel.
Annie
Oh yeah, that's totally doable using the API. I wrote a post on how to use Excellent Analytics, a free Excel plugin that's very user friendly. But you can set up individual calls to the API for each profile/account from one spreadsheet and then just refresh the data when you need to. You can also create charts from it and refresh them by clicking the Refresh button in Excel.
Annie
7/16/2014 Visualizing marketing data can be arduous, especially data from Google Analytics. This post provides a clear blueprint for what charts are best suited for your marketing exports.
8/13/2013 You can do your own Watergate-style investigation, learning the secrets of your competitors' marketing strategies by scrutinizing their backlinks. Pivot tables in Excel can help you make sense of all that data, and this post will show you how.
1/10/2013 If you've ever dreamed of replicating the charts Moz uses to display your data, today's your lucky day. Excel master Annie Cushing has compiled everything you need to make your data identical to our exportable reports. Do-it-yourselfers, rejoice!