analytics | DEMYSTIFIED

Popular pages

• A Primer on Cookies in Web Analytics | analytics

  Some of you may have noticed that I don’t blog as much as some of my colleagues (not to mention any names, but this one, this one, or this one). The main reason is that I’m a total nerd (just ask my w...

• Converting a Date in Excel to Week, Bi-Week, Month, and More | analytics

  I often find myself getting data out of one system or another (or multiple systems, and then combining them) as "daily" data -- a series of metrics by day for a sequence of days. Sometimes, I work wit...

• The Anatomy of a URL: Protocol, Hostname, Path, Parameters | analytics

  Put this post in the "very tactical" bucket, covering some things I've found myself explaining off and on over the years. Just last week, I wound up digging into an "oops" on some client work that was...

• Excel Dropdowns Done Right: Data Validation and Named Ranges | analytics

  NOTE: There is an updated version of this post posted here. I recommend reading that one rather than this one. Every once in a very rare while, I find myself not motivated to expound upon deep and mea...

• A Step-By-Step Guide To Creating Funnels in Google’s Data Studio | analytics

  A Step-By-Step Guide To Creating Funnels in Google's Data Studio This is an update to a 2017 blog post, since there are a ton of new features in Data Studio that make some of the old methods unnecessa...

• An Excel Dashboard Widget | analytics

  As I wrote in my last post, I've been spending a lot of time building out Excel-based dashboard structures and processes of late. I also wrote a few weeks ago about calculating trend indicators. A nat...