Data Runs Deep Blog

Lately, I’ve found myself using a number of window functions in BigQuery. They are really handy functions but can be difficult to wrap your head around.

We know that colours are a powerful communication tool. Our eyes are drawn to patterns and colours which makes data easier to analyse. With that said, Emojis add another layer of visual communication that sometimes words cannot portray. 

App + Web is here, and we certainly see it as the future of digital analytics.

I’ve been using Google Tag Manager (GTM) for over a year now and its potential never ceases to amaze me. If you haven’t already, I would suggest first reading Max’s blog post from February, “

It’s amusing how we choose to make metrics optional. That’s not what we want to do, is it? We want everything! All of it!

Hello there!  In this first ever series of Up Your Data Studio Game, we bring you ways to use conditional formatting in your dashboard. What’s conditional formatting you may ask? It’s similar to what’s available in Excel: formatting the cell when the condition is met.

Google Analytics generally stops tracking a session after 30mins of inactivity. Any activity after that will start a new session.

I've had my head in Channel Groupings for a couple of days and thought I’d share an overview of the key things to be aware of when working with Default & Custom Channel Groupings. 

Unfortunately custom channel groupings that are configured in Google Analytics aren’t available in Google Data Studio.

There is no shortage of COVID-19 dashboards in our industry so don’t worry we’re not throwing another one into the ring.