Comments on: Tools and tips for using Google Analytics with Excel to improve business reporting

By: Petr Nemeth

Petr Nemeth — Thu, 04 Dec 2014 16:27:00 +0000

Hi, I am personally involved in project called dataddo.com. It allows you to to extract the data from Google Analytics (you can even set automated extraction). Besides that, you can integrate such with the data from other sources and formats such as CSV, XML or Facebook Insights. Moreover you can use its data analytics platform to conduct statistical computations or data visualization.

By: Nabendu Varma

Nabendu Varma — Sat, 26 Jul 2014 20:33:00 +0000

Hi.
I am using Excel sheet by Mikael Thuneberg. When I am using multiple metrics in the query, separating them by ‘&’, the output is only with respect to the first metric. How to get all the results for multiple metrics. Any suggestions?

Regards.

By: mariah carey

mariah carey — Sat, 08 Mar 2014 12:23:00 +0000

Hi Thanks for sharing this. this post is originally written and it’s very useful for me I recommend it The result is really impressive,

By: Matt

Matt — Tue, 17 Sep 2013 12:52:00 +0000

Hi there,

I would like to ask you. I want to get data from source=facebook reduced by medium=cpc. So I want to get traffic clearly from facebook but not from facebook/cpc
I tried this
=getgadata(SUM!$V$6;example.com!$J$1;”visits”;example.com!O225-6;example.com!O225;”source=~facebook”)-getgadata(SUM!$V$6;example.com!$J$1;”visits”;example.com!O225-6;example.com!O225;”medium=~cpc”) but the result was negative -552

Thanks

By: Mike Sullivan

Mike Sullivan — Thu, 09 Dec 2010 17:19:02 +0000

Although this is an old article, people may land here still. Next Analytics is a new comer on the scene and worth a long look — many features well beyond these old-timers. They are currently giving away over 40 Excel dashboards that are ready-to-run and easily customized, and continue to give away more each week. New release includes social media queries as well!

By: Dave Chaffey

Dave Chaffey — Mon, 27 Sep 2010 16:24:04 +0000

In reply to spanishgringo.

Hi Thanks for sharing this. I don’t think it was available when this post was originally written.

I have used your app when there are multiple country profiles and it’s very useful – recommend it! It’s curious that Google Analytics doesn’t have this functionality yet!

Dave

By: spanishgringo

spanishgringo — Mon, 27 Sep 2010 15:26:01 +0000

Depending on the type of reporting that you need to do, my web app (built w/ AppEngine + GA API jQuery + Flot) could be of use to many users, especially those that need to do regular reporting or dumping of data into excel or want to execute quick comparisons across multiple profiles and/or segments.

http://gaevolution.appspot.com

By: Dave Chaffey

Dave Chaffey — Fri, 04 Sep 2009 08:42:34 +0000

In reply to Mark Red.

Oh yes – meant to include that but I think Excellent Analytics only works with Excel 2007 and I like much of the corporate world am only on Excel 2003. Is that right?

By: Mark Red

Mark Red — Fri, 04 Sep 2009 06:11:13 +0000

We’d also like to encourage web analytics-minded developers to contribute to the free, open source, plug-in Excellent Analytics: http://www.excellentanalytics.com

We can improve it together!