For web developer

Google Analytics offers various ways to view the data & make comparisons, which is great. But if you need a totally unique view or want to make comparisons with another data source, you’re limited.

Excellent Analytics is an Excel plug-in for importing web analytics data from Google Analytics in to an Excel spreadsheet.

So, you can easily build queries with all dimensions and metrics available or apply filters to create advanced queries

The plug-in is open source & for improving it further, it can be found here.

Open Web Analytics is an open source framework that developers can use to integrate web analytics into any application.

It is built with PHP & besides the standalone usage, it has built-in support for WordPress, Gallery & MediaWiki.

OWA comes with 2 APIs:

PHP: which makes it easier to integrate into any PHP application
JavaScript: for usage in non PHP pages/websites

It has powerful tracking/reporting features like heat maps, multiple websites, Google Maps integration, RSS/Atom subscription tracking &standard ones like:

page views, visits, and unique visitors over time
unique, new, repeat visitors over time

Click-streams – view the actual click-stream of each visitor
Click Tracking – Track where exactly on a web page users are clicking and view clicks by browser type
Click Heat Maps – view a heat map of where users are clicking on your web pages

Visitor Aging – understand the age of your repeat visitors.
Canned and Custom Time Periods – generate reports using pre-defined reporting periods or custom date ranges
Refering Page Analysis – View the title, anchor text, and surrounding text of inbound links from refering web pages
View visits by user agent
Track entry and exit pages
Track pages by custom page type

The frameworks uses other open source resources like Open Flash Chart or PHP Mailer & requires PHP 4.2.2+ with GD enabled to run. 

Requirements: PHP 4.2.2+ With GD Enabled, *nix Servers
Compatibility: All Major Browsers

GoingUp! is a free web-based website statistics service with powerful SEO features.

The service has a slick Ajaxed interface & offers a complete analytics package with web stats, referring keywords, action/goals & more.

GoingUp! tracks every activity & presents data nicely with charts, heatmaps, flags (for countries), etc.

Some of its SEO features are:

Inbound Link Monitoring
Google Page Rank Tracking
Alexa Rank Tracking
Keyword Research
Keyword Position Tracking
Page Optimizer Tool
Keyword Density Tool

The service also has some other free SEO tools like "bulk domain analyzer" or "link & SEO optimizer" which can be used directly without the need of signing up.

Requirements: No Requirements

Piwik is an open source website analytics application which provides detailed statistics about visitors, keywords, pages & more in real-time.

It can be installed on an any PHP-MySQL compatible webserver & the rest works similar to Google Analytics; inserting the tracking codes into the websites we want to track.

One installation of Piwik can track unlimited number of websites which is great for web design companies who would prefer to offer a branded/customized solution to their customers.

Also, the user interface is fully customizable: you can drag and drop the widgets you want to display and create a report especially tailored to you.

The application is built around plugins which means it is possible to add/remove features easily.

Its open API makes integrations with 3rd party software possible. And, here are 2 desktop applications that use this API to bring Piwik to your desktop:

Read the rest of this entry »

Requirements: PHP 5.13+, MySQL 4.1+
Compatibility: All Major Browsers

Google Browser Size is a visualization tool by Google Labs that shows any website behind an overlay of browser-window-sizes average

The overlay information is actually created from the data of people who visit Google (which won't be wrong to call it an average).

The tool is perfect for learning what percentage of the visitors are seeing the most important parts at initial load & what are they missing.

When you move the mouse, a rectangle which follows the mouse pointer enables us to interact with the website. And, optionally, the opacity level can be changed.

But, like mentioned, it is created with the data from google.com & will work for websites that target average internet users. It would be great to see this integrated into Google Analytics creating a custom overlay.

FeedBurner's popular chicklet FeedCount is the most-used way to display the number of subscribers for a feed.

Also, a similar design is used by TwitterCounter to display your Twitter followers.

We'll be creating a dynamic FeedCount-like interface that can display your website's statistics like pageviews, visits, etc. (one or all of them) using PHP.

At the end of this tutorial, we'll have 2 different counters:

a counter that can display only one metric – basic version
a counter that can display multiple metrics (some jQuery fun here) – advanced version

Read the rest of this entry »

SlimStat is an open source web analytics application that collects & presents statistics information about your website.

It is built with PHP-MySQL & can be integrated into websites with JavaScript (like Google Analytics) or PHP.

For  the given period, the application can display:

the number of visitors/pageviews
referrer URLs, domains
search terms
browsers, OSs, countries, screen sizes

There is also a "paths" feature that shows a user's browsing path page-by-page.

You may be asking, "why to use SlimStat instead of Google Analytics?" The best answer would be "live stats".

Requirements: PHP 4.3+ & MySQL 4+

TraceWatch is an open source and free website analytics application that works real-time.

With the help of an easy-to-use interface, the application has everything for making a deep analysis of websites (like visitors, pageviews, browsers, referrers, robots and much more).

It can track both static and dynamic web pages with the choice of PHP or JavaScript tracking codes.

TraceWatch offers private and/or public stats report pages (which is great for sharing the data).

The application is highly customizable and has a powerful admin menu that can control almost every aspect of it.

It is multilingual and requires PHP/MySQL + uploading few files to function.

Requirements: PHP & MySQL

W3Perl is an open source analytics application that doesn't require any code to be inserted into websites for monitoring.

Rather, it goes through the log files generated on the server-side and creates the reports in real-time.

The application is not limited to web servers and it can also render the logs of  FTP, Squid, CUPS and mail servers.

W3Perl stores the data for a period configured and can display statistics from hours to years.

It can provide information on many details about the visitors like their countries, browsers, screen sizes and pages they browsed, the amount of traffic created and much more.

Requirements: Perl

While using an analytics application, ability to analyze the funnel users go through to reach an event is a very valuable way for understanding users and improving leads.

Using Google Analytics, it is possible to get a report like:

users who browsed the product details page –>
downloaded the brochure –>
purchased the product –>
used PayPal.

by using many segments, filters and exporting data.

PadiTrack, a totally free application that can do this very easily for you.

It connects to your Google Analytics account (no tracking code required) and pulls the data automatically + instantly.

The greatest part of it is that segments can be applied to the funnels so you get to see how people converted from different traffic sources