If you’re like me (exactly maybe, as scary as that might be) and have a Motorola Droid, and use Clicky for awesome and simple web analytics – you’ll want this. Its only 1 dollar – which is the same as a double cheeseburger at McDonalds (if you local vendors participate – since we all know that “participation may vary”) if you want to make a dollar-for-dollar comparison… It uses the Clicky API to grab the unique visitors and actions from a given site that you are monitoring on a hourly basis (ie – it get refreshed hourly), and show the data...

A few months ago, I showed how you can do simple back and forth ETL task with python scripts – this time I’m going to take it one step further and show how with an extra python module we can actually export data to a usable Excel format as well. I often use this method for automated data extracts AS WELL AS doing full blown Excel reports (yes, that’s right – with formula calculations, formatting and everything – its pretty sweet – that’ll come later though). I always say that “ease of use” and “flexibility” are at opposite ends of...

In the Data Transformation Services (DTS) / Extract Transform and Load (ETL) world these days we’ve got a LOT of expensive ass products. Some are good, some are marginal, and some are pieces of over-complicated (and poorly performing) java-based shit. But, hey, enough with the negativity – I digress, I just want to show you that its pretty easy to do the same types of data manipulations in pure easy-to-read python code. Why lock yourselves into an expensive proprietary ETL system that requires expensive consultants to maintain (badly)? In this multi-part post I’m going to start...

Have you ever had an activity that you became totally lost in – where time either flashed by in an instant or seemed to stand still – your entire concentration was on that task at hand and the rest of the world just kind of faded away temporarily? Well, then you have experienced the “State of Flow“. Some people call it different weird things, such as “In The Zone” or “In The Moment” – but I think that “Flow” sums it up the best. It could be anything, it could be painting, photography, gardening, whatever it is that really makes your...

You stay classy, Brock Lesnar! Before you think I’m just writing a rant (which it is), take a minute to think about how this relates in the marketing world. Its somewhere between an industrial accident and a PR stunt, depending on where the truth lies and who you believe. Either way, its creating a new branding message in the WRONG direction (in my opinion). Now I know this subject has been beaten to death since the fight on Saturday night (which I paid $45 to watch at home in lieu of ‘hitting the town’ for it and probably ended up SAVING myself money, but I digress). I’m...