With this in mind, I thought I'd share a technique that I've used for pulling Google Analytics data into Excel without having to write a single line of code - not everyone can install plugins afterall! Just follow these steps: You can also write your own VBA code in Excel to directly access the Google Analytics API, but this isn't for the faint hearted! There are a few paid plugins out there such as Supermetrics and NextAnalytics that help you do this, as well as the now OpenSource Excellent Analytics which currently only supports the old Oauth method (due to be switched off by Google on 20th April!), and also the a free plugin from Analytics Edge. I've just returned from MeasureCamp and one of the most common question I heard from people related to getting data out of Google Analytics and into Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |