My last blog post took a look at calculating average position. Let’s now look at another instance where people make the dreaded “take the average of an average” mistake, calculating impression share. (See the average position post to learn more about averages of averages.) Again, let’s take a look at some dummy data. We have date, […]
I’ve been asked more times than I can remember, “How do you calculate the real average position?” The good news is that everyone asking realizes that taking an average of an average will get you in trouble. The bad news is they still don’t know how to actually calculate the true average position. In this post, […]
You know what really grinds my gears? Poor table formatting. It can be hard enough to stare at a large table of numbers and try to find what you need, but sometimes it’s more difficult than it should be thanks to poor formatting. In this episode of WRGMG, let’s take a look at some common […]
I tend to make big deals out of small things. Especially when I know I’m right. You don’t earn the nickname “Sheldon” without furiously arguing over minor details. One of the smallest things in the reporting world that drives me straight up a wall is seeing a dollar sign in front of ROI. It’s unitless […]
It’s been a couple of weeks since Google unveiled its new PPC & SEO Report in Adwords. When the report first came out, I was super excited. But then I remembered a few times when I have been burned by new Google features (see: Wave, Buzz, WebmasterTools Data Sets, Knol, Answers, etc…). However, I could not help but get super stoked about seeing a new report that combined PPC data and SEO data lined up side by side and ready to be thrown into my arsenal of pivot tables. So without any hesitation, I jumped right in. #RefreshTable