Let’s begin the week with a bit of Geek Humor
Monthly Archives: June 2008
Export GA reports into Google docs with just one click
Reading the Blog Spanish Gringo (great name) from Micheal Freeman I fount a very interesting tip for Google Analytics. With your current Google Analytics version if you want to export a report to Excel you have to click on “export –> CSV”. If you do so, you will probably face a problem trying to import the CSV to Excel (you can, but it looks weird). So Micheal got the answer on “Greasemonkey” and now you can export your report into a spreadsheet directly to Google Docs with just one click. Sounds great uh, I guess it is.
Installation
1- Install Greasemonkey and Firefox 2 or a later version (I have Firefox 3 and works great). Once you install Greasemonkey you will see the icon at the bottom right of your Firefox.
2- After than you will need to download and install the user script.
3- Then you need to login into your Google Analytics account and get a report (not the dashboard since is not possible to export it). Once you get the report you will have the export options with a new icon which will export the report, just by a mouse click, into a Google Docs spreadsheet. Is that simple and usefull (take into account that your browser may tend to block the pop up message, if so just click on “allow popups from www.google.com).
4- The Google Docs list opens automatically and you can select to open the one you have just created.
After that you can use the information as you want.
It is important to note that even when this is a very usefull functionallity, it is just helpufull if you normally work exporting the information into excel files and working there, but if you integrate your information with other sources then this is not for you. I just can’t imagine an Analytics Department from a big corporation exporting excel files and integrating that information with the rest manually. If that is your case, this functionallity may be for you “good from far, but far from good”. The optimum functionally in that case is an API, but since is not yet available in Google Analytics, just export it into an CSV file and import it into your information database (SQL, MySQL, PostgreSQL, or even Access).
To wrapup, this is a great thing for Bloggers and SMB’s, so if that’s your case, what are you waiting to try it?
Daily Quote
I have already posted this Quote but I found it just great.
“Be regular and orderly in your life, so you may be violent and original in your work.” Gustave Flauvert.
GAAC training in Buenos Aires
Yesterday (thursday 5th of June) was the first GAAC (Google Analytics Authorized Consultant) training in Buenos Aires. The event was planned by the untiring Enrique Quevedo. Enrique, who was also the speaker, has the non-minor task of developing the product through the Latam Region.
The training lasted two days, the first day was focused on Business while the second was 100% technical. The training went from general to specific topics, and was both technical and pragmatic making very simple to incorporate pretty difficult concepts.
Congratulations Enrique, Great initiative!!!
Enrique is at my right (I’m with the unforgetable “tag my ass” t-shirt), and behind Enrique is Carolina from Intellignos.