Data Runs Deep Blog

It was exciting waking up today to the preview release of three new functions in BigQuery: 

Scenario: I want to know more about how users are navigating through my site to reach our top-level blog page. I am also curious as to where they go from there -- are they likely to click a recent blog post, explore a dedicated topic subpage or do something else entirely?

Today I thought it would be fun to build a heat map in Data Studio. I was inspired by a chart and Melbourne's unusually warm week.

We previously did a blog post about identifying session breakage using BigQuery.

A lot of companies report duplicate transactions (and therefore increased revenue) in Google Analytics.

Here’s what you usually need: Access to the platforms that is connected to Data Studio. Edit access to the dashboard and data sources. A cool head. Plenty of patience. Lots of breaks (don’t be too hard on yourself here).

Today is an exciting day, as the new version of Google Analytics is finally here!

There’s little we can do about default aggregation when using Google Analytics data. It’s the three things certain in life, right? Death, taxes, and auto aggregation in Google Analytics data.

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.