In this post we will cover:
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:
By loading Snowplow’s metadata model into Looker, you immediately have:
The model includes a large number of metrics and dimensions - the screenshot below illustrates just some of the metrics available:
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:
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:
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:
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!