Analytics to Excel

[KJ-Rodgers]

I am looking for a Excel template to pull GA directly into the spreadsheets. I have seen them around before, but I have always had trouble with them. Does anyone know a good how to or template somewhere?

Hopefully this can include some areas to customize areas such as date and fields.

[Confetti_Wedding]

Hi,

I think the best one around is Excellent Analytics. It's a free plugin for Excel, has decent(ish) 'how to' guides on their site and is recommended by Google so should do everything you're looking for.

Hope that helps.

[Nobody1556905035114]

I completely agree with Brendan - Excellent Analytics really is excellent

It's useful in allowing you easily save your queries in text format so if you want to get similar data, you don't have to go through the rigmarole of recreating it via the interface, just copy and paste!  I have not tried to dynamically build the queries yet, but I'm sure you could build the query string based on variables set elsewhere in a spreadsheet...

I also like the fact that you can grab all your data in one go (unlike the web interface which forces you do click endlessly...).

[KJ-Rodgers]

Awesome. I will try this out.

[KJ-Rodgers]

This looks like a great program and has great reviews, but my company is behind on versions of MSO Products.** We have 2002, this calls for 2007, does anyone have a alternative?

**I will try this on my personal computer when I get home

[RobMay]

I miss this tool from my PC !! I would love for them to develop a MAC version now but that just ins't a reality yet. Nice suggestion. I would have done said the same thing!