Snowplow 0.8.13 released with Looker support

08 January 2014  •  Yali Sassoon

We are very pleased to announce the release of Snowplow 0.8.13. This release makes it easy for Snowplow users to get started analyzing their Snowplow data with Looker, by providing an initial Snowplow data model for Looker so that a whole host of standard dimensions, metrics, entities and events are recognized in the Looker query interface.

In this post we will cover:

  1. What’s so special about analyzing Snowplow data with Looker?
  2. What does the Looker metadata model deliver?
  3. How to install the metadata model

Snowplow makes it possible to analyze your granular, event-level data with any BI tool. So what’s so special about Looker?

In a nutshell, Looker makes it fast and simple for people with no SQL knowledge to explore Snowplow data via a convenient web UI. We’ve gone into detail about why Looker is so well suited to analyzing Snowplow data in the following two blog posts:

  1. Introducing Looker - a fresh approach to Business intelligence that works beautifully with Snowplow
  2. Five things that make analyzing Snowplow data in Looker an absolute pleasure

By loading Snowplow’s metadata model into Looker, you immediately have:

1. The ability to slice / dice Snowplow data across a wide range of dimensions and metrics via the Looker query interface

The model includes a large number of metrics and dimensions - the screenshot below illustrates just some of the metrics available:

2. The ability to zoom up to visitor-level, country-level, channel level analysis or down to transaction-level, event-level data seamlessly

The model makes it easy to zoom up to view country-level, channel level data e.g.:

And to drill down to individual event-level data, e.g. so that we can view the event stream for a particular visitor over time:

3. Quick-start dashboards

The model includes a general-purpose dashboard for reporting on the last 7 days:

And a general purpose dashboard for reporting on the last 6 months:

4. A solid basis to extend the model to encompass your own business-specific and product-specific events, dimensions and metrics

The purpose of the model is to get you started using Looker on top of Snowplow. One of the best things about Looker is that the metadata model is easy to extend - we hope that you extend it to incorporate:

  1. Events that are specific to your website / business
  2. Dimensions that are specific to your website / business (e.g. audience segments or stages in funnels)
  3. Metrics that are specific to your website / business

3. How to install the model

If you have a Looker trial setup for you by either the Looker or Snowplow teams, they should be able to install the model for you.

If you are setting up Looker for yourself (or you already have Looker setup and want to incorporate the model), instructions on doing so can be found on our setup guide / wiki.

Over time we plan to add Looker-specific recipes to our Analytics Cookbook. Stay tuned!