Problem on database server 1 - UPDATED

If your site ID is below 15,000 or so, you have probably noticed that all of your visitors have 1 action, and no referrers. There is a corruption on the actions database table that has prevented new data from being logged in this table since about 12 hours ago. We are working to fix it as soon as we can. Because of the size of this table, however, it will likely be several hours before it's done. The database will have to be taken offline during this time. Sorry for any inconvenience.

Update 10:15am PST I have to make a trip to our data center to fix this, which is 90 minutes away. Thanks for your patience.

Update 3:30pm PST We have run into an extremely irritating problem with MySQL and have to re-import the actions database into a new file to fix it. There are hundreds of millions of entries, this will take approximately 8-12 hours. We are very sorry about this and will get this database back up as soon as is humanly possible.

Update 11pm PST The problems have been resolved and the server is processing the 12 hour backlog of traffic. This will probably take a good 6 hours. We're really sorry about this. These things happen, thanks for understanding.
27 comments |   Jan 07 2008 7:59am

Love Clicky? Vote for us in The Crunchies

TechCrunch and a few other high profile blogs have started an award competition for internet startups, dubbed "The Crunchies". If you love Clicky, we would appreciate your vote! The voting page just asks you to type in the name of the startup. For consistency, I would suggest everyone use "". You can vote here.

There are a lot of categories, we'd like to think we're eligible for:
- Best bootstrapped startup - we are 100% self funded
- Best design (user interface) - our simple and clean interface is key to our success
- Best overall - hey why not?
15 comments |   Dec 03 2007 3:16pm

A year ago today...

How many of you remember this logo? It's what I managed to whip up in Photoshop when Clicky launched a year ago today at It was only 6 weeks in the making at that point and rather scant for features, but one thing we did well from the beginning was showing you every visitor to your site and every action by said visitors. People loved that, and even today, there are still very few affordable products on the market that show you that level of detail per visitor. This remains one of our biggest selling points for a majority of people.

In one year's time, we've had 20,000 sites register on, and tracked almost 600 million clicks for those sites. We've partnered with Performancing and FreeWebs to bring our product to their userbase of 40,000+ and 17,000,000+, respectively. (Plus one other company with over 150,000 users, but that has not launched yet so I can't talk about it). We've had 4 buyout offers - 2 laughable, 2 reasonable - but we turned all of them down. Hard to believe there's still only two of us running this thing. At this rate, that's likely to change soon.

And what would be a year without controversy? We've had three big ones. First was when we announced pricing. We were open about this from the beginning (e.g. it was mentioned on the registration page that Clicky was "free while in beta"), but a lot of people were caught off guard and we got torn a new one. This was when people started saying "Google does the same thing for free", which I still hear plenty today, and which still makes me extremely irritated every time.

(I love Google and their analytics product is really good - BUT, it is vastly different in functionality than Clicky and has a much different target market. Saying that they are the same except that one is free is completely inaccurate! Does Google Analytics have an API? RSS feeds? FeedBurner subscription data? Detailed visitor information? Widgets? Visitor labeling? Custom data tracking? Outbound link tracking? Download tracking? Tag Clouds? Real time data? In case you were wondering, the answer to all of those questions is NO! Likewise, Google's product has some great features that we don't, particularly with trend data and segmentation - but our upcoming release will address some of that!)

Second big controversy was when we were trying to pick a new logo. Here is our first logo, and here is the logo we ended up choosing ("choice 2" in the blog post, images are broken for some reason). We were dirt poor at the time and could only rely on our users to submit their entries in exchange for free premium service. I liked the new logo at the time but it started to feel too dark and evil after a while. That's when we switched to our current look, that was in May or so.

And the last controversy was when we launched the new dashboard in July. (Check out screenshots of the old school dashboard: first one, second one). Most people absolutely loved it, but there were a few users who were extremely vocal about how much they hated it. That post had 90 comments - our most ever by far.

(I found a few other old screenshots too. Our original visitors page looked like this, but soon after changed into this, which is still quite similar to what it is today.)

So it's been a year and we're having a blast. But what about this new version of Clicky I've been yammering about recently? Unfortunately, it's not ready yet. I was trying my damndest to have it ready by today for our one year anniversary, but alas, there was just too much to do. The launch is still several weeks away. The wait will be worth it though, trust me!
19 comments |   Nov 27 2007 10:17am

Scheduled downtime this weekend


Our scheduled database maintenance has been delayed, probably until next weekend (11/24). We didn't get quite enough done in time to make the changes today. And it absolutely must be done on a Saturday, so as to inconvenience the least amount of people, and then also give the system enough time to catch back up with real time before the week starts again.


In preparation for our upcoming release, we have to make some structural changes to the database. The web site will be unavailable during this time, as the database is unusable while changes are being made. We'll still be logging traffic, though!

The plan is to start early Saturday morning (USA PST) and go until it's done, or we collapse from exhaustion. We expect this process to take about 24 hours and involve many, many pots of coffee.

The new version of Clicky is still weeks away, so you won't notice any differences when it comes back up. Sorry! But it's coming soon and it will rock your world.
18 comments |   Nov 12 2007 11:48am

Some handy new tracking features; major update also in the works

A number of you have downloads and outbound links on your site that link to an internal script and then redirect to the real URL. Our tracking code has no way of knowing this will happen and just sees these as internal links, and hence, has not tracked them appropriately. Until today. Now you can tell our tracking code that a link really is a download or an outbound link just by adding a class to the link. Easy!

There is now also the ability to manually call our logging function from a javascript onclick event. This is similar to the way Google Analytics urchinTracker() function works, which people use to "hack" GA so that they can track downloads and outbounds, in a way that leaves much to be desired. Anyways, with this new function, you can manually track clicks on any item on your web page, even if it's not a download or outbound link. I know this will be very handy for some of you. We're going to implement it soon in a few spots on our site.

All the details about how to use this new functionality are available here: Please note that if you are hosting a version of the tracking code on your own server, you must grab an updated copy for these things to work. However, if you're not going to use this features, there is no need to update.

Also, a few new features in the site management area, which you can see by editing a site or adding a new one. These features strip off index.* and default.* from the end of URLs, and add or remove a trailing slash from all URLs. Both are disabled by default. They are designed to make the statistics for your individual pages more accurate. They are explained in more detail on the site management page.

Major update in the works

It's been fairly quiet around these parts for a while. I haven't been able to work on the site much during the past few months because of a number of big things going on. I hate neglecting the site but it's been necessary! We have a HUGE partnership deal that will be announced next week, with a company who has over 15 million users. This will be a near thousand fold increase in our userbase, and will put us on top of nearly every hosted analytics offering in existence. We are obviously thrilled. Expect an annoucement here next week.

The point is that I'm finally done dealing with all this... stuff. I finally have time to go back to working on Clicky and making it even better. We have a huge update in the works that will contain a few very exciting features, and I know you will love them dearly when they are released. The 1 year anniversary of our public launch is later this month, and we're aiming to release it all on that date in celebration of 365 days of love. Stay tuned!
11 comments |   Nov 01 2007 6:41pm

Next Page »

Copyright © 2018, Roxr Software Ltd     Blog home   |   Clicky home   |   RSS