Our Blog

At Analytics Demystified we have been blogging and contributing to the global analytics community for nearly twenty years. We don’t write as much these days — mostly because we stay pretty busy with our clients — our analytics tell us that the content contained herein is still valuable.

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

    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 with that data at a daily level, but, often, I want to roll the data up by week,…

  • Re-Examining Attribution

    Attributing credit across a multitude of marketing efforts is one of those sticky problems in digital analytics that seems to generate a whole lot of controversy. This is a topic that comes up with nearly all of my clients and is one that both Eric T. Peterson and I have been researching and writing about…

  • Alternative Conversion Flows

    Many online marketers have a desire to test out different conversion flows on their website. Whether those flows are for an alternative checkout process or a new application process, the overall desire is the same. By testing out an alternative conversion flow, you can see how website conversion differs and find opportunities to optimize your…

  • Happy New Year from Analytics Demystified

    On behalf of the rapidly growing team at Analytics Demystified I wanted to wish all of my clients, readers, and friends a Happy New Year! I say rapidly growing because 2012 saw unprecedented growth for the Demystified team: In February we added Brian Hawkins to the team to build out our Testing, Optimization, and Personalization…

  • Breaking in to the Digital Analytics Field

    Over the past few years, I’ve been asked many times for advice on how to “get into digital analytics.” Without fail, these requests come from people who have gotten just enough of a taste of the field that they’re pondering a redirection of their career. After having written a long-ish email in response to one…

  • Michele Kiss joins the team at Analytics Demystified

    I am both thrilled and humbled to announce I have joined the Analytics Demystified team as the newest partner, adding dedicated analyst services to enhance Demystified’s offerings to clients. I will be helping Demystified clients use analysis to proactively identify business opportunities, as well as developing the right skill sets and teams to generate insights…

  • Small Charts in Excel: Beyond Sparklines, Still Economical

    I’m a fan of Stephen Few; pretty much, always have been, and, pretty much, always will be. When developing dashboards, reports, and analysis results, it’s not uncommon at all for me to consciously consider some Few-oriented data visualization principles. One of those principles is “maximize the data-pixel ratio,” which is a derivation of Edward R.…

  • Quotable Quotes from Nate Silver

    It’s hard to be an analyst and not be a fan of Nate Silver. Actually, I think it might actually be the law — one of those “natural law” things, like gravity (“Obey gravity! It’s the law!”), rather than one of those legislated ones. Not too long ago, I wrote a post that gave my take…

  • Products & SKU’s

    When I work with retailers who use Adobe SiteCatalyst, one topic that often emerges is the best way to handle the tracking Product ID’s and SKU’s. In this post, I will outline the challenges that exist and share some ways to handle product and SKU tracking in SiteCatalyst. The Product vs. SKU Dilemma The primary…

  • Adobe SiteCatalyst – ClickTale Integration

    About a year ago, I wrote a blog post discussing ways that you could integrate Adobe SiteCatalyst and Tealeaf. In that post, I talked about some of the cool integration points between the two products. In this post, I’d like to talk about how the same integration would work with ClickTale and share some cool…