Google BigQuery

Tranpose columns to rows and visualise in Data Studio

Using the New UNPIVOT Function in BigQuery to Transpose Data

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

Use LAST_VALUE to dynamically offset data in BigQuery

How to re-attribute your conversions to the correct traffic source in BigQuery

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

Use ROW_NUMBER SQL window function to identify duplicate values in BigQuery

Remove Duplicate Transactions From Your Reporting in BigQuery

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

Cool things you can do using window functions in BigQuery

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.

Identify Potential Session Breakage Using BigQuery

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

Use our BigQuery Statement Builder To Better Understand The Behaviours Of Your Customers

Getting started in BigQuery can be daunting. Even with experience writing SQL, there are some platform-specific nuances you need to learn along the way.

You Can Have Your GA360 BigQuery Voucher Back (Sort Of)

Earlier this year, Google discontinued a very popular little addon that was bundled with GA360.

Consistently selecting randomised rows in BigQuery

How To Consistently Select a Randomly Distributed Sample of Rows From A BigQuery Table

There are occasions where you would like to randomly select rows from your BigQuery tables; but at the same time like to ensure you keep getting the same set of rows every time you work with the da

Calculating What Percentage Of Rows Are In Each Group

How To Calculate Table Level Percentages In BigQuery

In a lot of exploratory queries, you want to know not only how many rows had a certain value but what percentage of all rows in the table this count value represents.