sea-of-data

Back to Basics: How We Should Really Look at Data

  |  May 27, 2013   |  Comments

Visualize the data, segment the data, and choose the right metrics to uncover amazing insights for your clients.

A few days ago I came across an article written by Thomas Baekdal, "Measuring Results: Don't be Fooled By Math," that really got me thinking. And not just the usual "Hmm, this is interesting" type of thinking, but the "I'm five levels deep in the Matrix and I just bent a spoon with my mind" type of thinking. My mind was flooded with flashbacks of reports that still haunt my dreams; metrics so meaningless that I'm still not sure why the requests were made.

This caused me to analyze and ask questions about most of the activities I do on a daily basis as an analyst. After thinking about the differences between B2B, B2C, and e-commerce clients, I decided on the below three steps that will help uncover amazing insights for clients, regardless of the industry or who they are selling to.

  1. Visualize the data. Visualize your data beyond the spreadsheets and tables you are used to seeing in your analytics tools. Some of the most interesting and valuable insights can quickly get lost in a spreadsheet. Instead, use your complete set of data to create bar charts or line graphs, or whatever type of chart best represents what is actually occurring in the data. Once you find something interesting, dig in deeper, create another chart, and repeat.
  2. Segment the data. Segmentation is one of the most powerful features of your analytics tool, but to leverage the full power of segmentation you need to go beyond the typical segments, such as marketing channel. Segmenting traffic by channel isn't good enough, you need to look at the specific sets that comprise each channel. For example, if you were to only segment based on your paid search traffic you would likely be lumping a large group of unrelated visitors together. Visitors have different motives for coming to your site; some come for product information or research, some come for support, and some come to purchase. Make your segments reflect the different motives for someone visiting your site. Instead of just "paid search traffic," break your segments out into "paid search current customers," "paid search non-customers," "paid search product support," and so on for whatever fits your site and business.
  3. Choose the right metrics. Current analytics platforms and tools are much more powerful and convenient than going through server logs and pulling together information about your site's visitors. However, with this power and convenience often comes laziness. It's very easy to just log in to Google Analytics or Adobe SiteCatalyst, pull a quick key performance indicator (KPI), and then go about your day. But what do the metrics even mean? How are they calculated? What defines a visit? What's the difference between a visitor and a unique visitor?

    Let's take a second and look at a metric that Thomas talks about in his article, average order value (AOV). At first glance, AOV is a pretty solid metric. It's easy to understand, and easy to calculate. But does it always tell what is happening? Let's compare it to another common metric that practically every American has heard of, median household income (MHI). Fluctuations in household income that you hear about on the news use MHI. But why median and not average? That's because the Warren Buffetts and Bill Gates' of the world will significantly skew the average household income. For example, during the 2010 census there were roughly 120,000 households in the U.S. In the same year, the MHI was $49,445, while the average household income was $67,530. That's a difference of almost 37 percent, even with a population of 120,000 households! Just looking at the average presents a much different picture than the median, which has been accepted as a more accurate representation of the "average" American household. Take a deeper look into the metrics you use that are averages (pages/visit, average time on site, conversion rate, etc.), and try to identify if you have some Warren Buffetts that may be hiding what is actually going on.

So those are my main steps to uncovering insights that may be missed by just looking at the default metrics presented in your analytics tool. The process will take you a bit longer, but the reward is definitely worth the effort. The outcome should be sounder and better informed insights, produced by deeper data analysis, which will help increase sales, form submissions, or whatever your organization's KPI is.

Image on home page via Shutterstock.

Tags:

ClickZ Live New York What's New for 2015?
You spoke, we listened! ClickZ Live New York (Mar 30-Apr 1) is back with a brand new streamlined agenda. Don't miss the latest digital marketing tips, tricks and tools that will make you re-think your strategy and revolutionize your marketing campaigns. Super Saver Rates are available now. Register today!

ABOUT THE AUTHOR

Robert Miller

Robert Miller is a Senior Analyst at Search Discovery. He is actively involved in industry organizations, such as the Analysis Exchange and the Digital Analytics Association.

With the Analysis Exchange, he helps non-profits capitalize on their website data, and educates aspiring digital analysts about the foundation of digital analytics, from the implementation of a digital analytics tool to performing analysis and making data-driven recommendations for organizations.

COMMENTSCommenting policy

comments powered by Disqus

Get the ClickZ Analytics newsletter delivered to you. Subscribe today!

COMMENTS

UPCOMING EVENTS

UPCOMING TRAINING

Featured White Papers

Google My Business Listings Demystified

Google My Business Listings Demystified
To help brands control how they appear online, Google has developed a new offering: Google My Business Locations. This whitepaper helps marketers understand how to use this powerful new tool.

5 Ways to Personalize Beyond the Subject Line

5 Ways to Personalize Beyond the Subject Line
82 percent of shoppers say they would buy more items from a brand if the emails they sent were more personalized. This white paper offer five tactics that will personalize your email beyond the subject line and drive real business growth.

WEBINARS

    Information currently unavailable

Jobs

    • Lead Generation Specialist
      Lead Generation Specialist (The Oxford Club) - BaltimoreThe Oxford Club is seeking a talented writer/marketer to join our growing email lead-generation...
    • Health Marketing Editor
      Health Marketing Editor (Agora Inc.) - BaltimoreCome flex your intellectual muscle as part of Agora, Inc’s (http://agora-inc.com/) legal team...
    • Technical Business Analyst
      Technical Business Analyst (OmniVista Health) - BaltimoreOmniVista Health is looking to add a Technical Business Analyst to our expanding team...