I'm thrilled to see Mikael has fixed the problem with his glorious Excel/Google Analytics system.  It turns out the problem was not ampersands but the length of some of the data coming back from GA.  Excel can only handle 255 characters per cell, but some URL's or keyword combinations can be longer than that, which caused the #VALUE! error.If you haven't downloaded and played with his Excel or Powerpoint systems which pull data direct from Google Analytics, I strongly urge you to try.  This stuff is hot!As far as I'm concerned, this is the future.  Businesses run on internal data - databases, spreadsheets, automated machinery, etc.  If you want to cross-reference web activity with the rest of the business, you need your web analytics data in the same systems as everything else, not on some website.  That's why Google gave us export capabilities.  But who wants to spend hours copying and pasting, manually adding functions or cross-links, when you can have software do it all automatically.
From Google Analytics to Excel to chart to Powerpoint and Word - automatically and instantly.  That's the future.For those of you who hate Microsoft or the PC, Mikael is now adapting his work to Open Office, so keep an eye on his blog.
And do the guy a favour - click his ads.  He's giving away his work, let him earn a little for it - it won't cost you anything.

• Add a comment
• Print This Post
• Share