This context, can explain in great detail every necklace, its shape, how many stones and what type, color, which metal, finish and more.
Is this too much? Let’s see some questions from the Marketing team.
Which campaigns drove more sales?
What was the conversion rate by campaign?
While these questions are straightforward to answer with any out-of-the-box analytics solution, the answer will rarely drive great insights.
With additional context we can drill down and explore, this is a process that drives insights and leads to action.
With additional context we can answer potentially more interesting questions:
Which campaign has better performance for Gold necklaces with diamonds?
Are there any spikes in interest of heart shaped stones?
What is the conversion rate for necklaces by design shape?
How Snowplow Analytics provides relevant context
Snowplow doesn’t work like Google Analytics or Adobe in the sense where it has a limited number of custom dimensions or eVars to describe an event. With Snowplow you can define an entire product taxonomy in the form of jsonschema files.
In our example, we will have four jsonschema files to describe our jewelry products. This is our jewerly taxonomy.
This table is the Snowplow Analytics backbone. It is used to record ALL events. Unlike Google Analytics the additional contexts are not stored here. This increases performance and forward compatibility.
Below are two examples of the DDL for two contexts, product and metal. You probably noticed the _1 appended to each table.
Snowplow Analytics uses semantic versioning, which allows you to properly version your jsonschemas and maintain forward compatibility.
Tracking events with additional context
Now that we have the schemas and tables ready, we can start capturing events with additional contexts. Below is what the pageview of a Sapphire and Sterling Silver Heart Necklace would look like.
Contexts can be re-used and mixed to describe any object.
Why is this mindblowing? Because you can answer the questions:
Which necklaces received more views?
Which necklaces drove more revenue? Which shapes? Which Metal?
Which campaings are profitable?
As an exercise, look at the context and come up with an original question.
To answer any questions we need a data visualization tool and some data-modelling skills.
You can build a dashboard that not only answers the primary questions, but let’s us drill down for insights. Below is a dashboard mockup.
You gotta love SQL!.
Determining your products/services taxonomy and adding it to relevant events on your website/application is the catalyst to drive insights and action from your data.
Snowplow Analytics enables you to bring your business context into your data with ease and scalability, giving full data ownership and the hability to answer the questions you need, with as much drilling down as you want.
Ready to take Snowplow for a spin? Contact us!
João is a Solutions Director at Igloo Analytics and an experienced analytics professional, helping organizations embed analytics for growth and innovation. You can find him on his company website, Twitter and LinkedIn.