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.
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.
Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.
Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below.