Excel
Here you find 4 blog posts about Excel.
How to Track Multiple Links to the same URL automatically in Google Analytics
- 05.02.2011
If you have multiple links on a page pointing to the same URL, you are not able to identify in Google Analytics which link were clicked. Neither the In-Page Analytics report or the Navigation Summary report (or what somebody calls a Next Page report) will show you this.
The usual method to overcome this problem is to manually tag links, which is (normally) a time consuming implementation method.
Because of this I have created a script that is easy to implement and configure. The script will automatically track which link the user clicked on, the Anchor Text of the link and the Link ID (number). The information is stored as Events in Google Analytics.
And as a "bonus" I have included a Excel Spreadsheet using the Google Analytics API that makes the report more readable.
Free Excel Goal Funnel Report for Google Analytics
- 11.10.2010
Have you ever came across Google Analytics accounts where Goal Funnels are missing or wrongly setup, and been wondering how you could analyze and track these missing goals easy?
Or you have been staring at the Goal Funnel Visialization report in Google Analytics and thought "Why can't I use Advanced Segmentation for this report?".
Or perhaps you just need to create and analyze conversion funnels on the fly?
My answer to all these problems was to create a Excel Spreadsheet using the Google Analytics API, which means that you can log into Google Analytics inside Excel and do Goal Funnel Tracking on the fly.
Excel Feedback Form Reporting using Google Analytics API
- 27.09.2010
Recently I released my Free Feedback Form for Google Analytics. Although it is pretty easy to drill down into the Feedback Form data, exporting the data and putting together a useful report can take some time.
Because of this I have made an Excel sheet using the Google Analytics API which means that you can log into Google Analytics inside Excel, and your Feedback Form Report will be automatically generated.
Video Analytics using Google Analytics API and Excel
- 17.03.2010
Google Analytics Event Tracking is a flexible solution for measuring user interaction with your website - including videos. I have demonstrated this before with my YouTube Chromeless Player with Google Analytics Event Tracking (you can download the player from that article).
Since Event Tracking isn't made especially for video analytics, it can be a little bit difficult to understand what the data means.
To make the video analytics data more understandable I have made an Excel 2007 spreadsheet that is connected directly to Google Analytics using the Google Analytics API.
