EmergencyEMERGENCY? Get 24/7 Help Now!

ClickAider – Track Adsense Clicks and much more

 | July 9, 2007 |  Posted In: Events and Announcements


Let me announce ClickAider – another projects we were working on in stealth mode for last several Months.

ClickAider is Hosted Web Statistics system but it tracks Clicks rather than page views as most web counters do. And by clicks I mean not just clicks on the urls and images but clicks on many sophisticated advertisement systems – Google Adsense, Yahoo Publishers Network, AdBrite, AuctionAds and few others, plus ClickAider also can track form submissions.

The Click Tracking is done non-intrusive way, without Advertisers JavaScript modification so typically it is compatible with advertisers terms of service.

Why did we decide to do it ? Most PPC Advertisers we worked with have very poor statistics about clicks and we wanted to know much more. We wanted to know which search engine keyword bring traffic which clicks, which countries are clicking as well as where people go to from your web site (may be you’re sending traffic to your worst competitor and just have not noticed it).

ClickAider can do all of this and much more – you can drill down to all details available about every click as well as filter all reports by any fields. For example you can view information about clicks for users which came to you from particular referring domain or see from which countries people clicked on given page URL come from.

This flexibility with filtering of course comes at cost, meaning all reports have to be dynamically generated.

The fact we’re working with clicks rather than page views means it can work for reasonably large sites, and we’re working on technologies which should allow us to bring this limit much higher.

The fact hardware have improved over recent years is also quite helpful. When I was designing another Web Statistics System – SpyLOG back in 1999 you could hardly do much of real time aggregation and we had to store aggregated data for all stats.

Compared to SpyLOG we also significantly simplified architecture based on experience gained during the years and simply because not having so many resources we have to innovate and keep things simple but powerful way.

If you’re interested what is under the hood – it is typical LAMP application at this point. We use Scale-Out MySQL architecture
based on MySQL 5.1 with some partitioning and mostly Innodb storage engines. Initially we tried to use PBXT for log storage but it had some stability and performance gotchas so we decided to give it some time to settle.

We use ClickAider on bunch of our own projects and most people we invited as beta testers during our close beta testing period think it is quite cool even though still has some rough edges.

Now we’re finally open and pleased to invite you to try it out, tell your friends to try it out and report us all bugs and suggestions you may have.

Peter Zaitsev

Peter managed the High Performance Group within MySQL until 2006, when he founded Percona. Peter has a Master’s Degree in Computer Science and is an expert in database kernels, computer hardware, and application scaling.


Leave a Reply