If you are like me you frequently have to update various excel based dashboards. In the pursuit of even more automation, I thought it would be fun to make Excel figure out the current date and automatically set the date of my dashboard to the end of the previous week.
All you need is three Excel [...]
As the economy continues to take multiple turns for the worse, you need to step up your game to get hired as a web analyst. I have been seeing a lot of resumes lately, and since not everyone does what I do, some people can use the help. Feel free to ignore this if you [...]
I am posting this solely as a means to get me writing again. I have been stepping up my experience and learning in web analytics so much over the past six months, and there is so much to share but the sheer amount of things to write about works against writing at all. So, today [...]
Google Analytics recently updated their product to allow users to trend data across a week or a month instead of just daily. This is a very nice improvement in their trend viewing capabilities.
Which one of these tells the story best at a glance?
A.
B.
Gotta give credit, this is a nice small enhancement that adds a lot [...]
I just got back from Portland, Oregon, where I had the good fortune to have lunch with Eric Peterson, dine with WebTrends (twice), and spend a whole day on the cutting edge of web analytics with the WebTrends Customer Advisory Board.
First, lunch with Eric. It is pretty cool that a guy who barely knows who [...]
One of the nice things about having my own web site is that I can express my own opinions. Here is one of them.
I have been annoyed for a long time with Omniture’s sales methods. Omniture is having their extremely well attended Customer conference this week so, I figure this is as good a time [...]
These are some of my thoughts related to Avinash’s recent post about how to make HiPPOs hungry for more web site analysis and optimization.
I think this goes deeper than employing this or that tactic or strategy to advance web analytics. It is fundamentally how to get business decisions to be made in your favor and [...]
Surprise! Surprise! I recently had a chance to do some analysis of reporting tasks when done with Google Analytics vs. WebTrends. The idea here was to see if I could save some money using Google Analytics for web analytics reporting. Make sure to read at the bottom for caveats galore.
The Challenge
Compare reporting effort between Google [...]
I love web analytics. It is one of my life’s highlights to have gotten involved with it when it was still fairly young, all the way back in 2004. For all of you that are longer in the tooth than I am, before scoffing just think about what was available online back then. Basically a [...]
Starcom, Tacoda, and Comscore jointly published a study yesterday revealing that 6% of the online population accounts for 50% of all display advertising clicks. This audience fits the demographic of 25-44 and household income less than $40,000 annually. Additional details regarding this segment are that their online buying is not proportionate to time spent online, [...]