Insights

Measured Opinions

The latest news, provocative views and some handy how-tos from the world of data, analytics, cloud and AI.

Browse the archive

234 results · Page 7 of 13

How to build an interactive GA4 BigQuery data schema

What and why? One of the great features of Google Analytics 4 (GA4) is the ability to pass data into BigQuery (BQ). There are many benefits to this which have already been covered in some of our previous blogs (i.e. 10 reasons to export your GA4 data to BigQuery). Passing data to BigQuery is no longer just available to enterprise GA360 customers, but to anyone using GA4 for free. What I wanted to create was a simple interactive way to explore how GA4 data is saved in BigQuery. I found the GA36

Scott Hellmund-23 Mar 2022

The sun is setting on Universal Analytics

It’s finally happening. Google has announced the sunsetting of Universal Analytics, or more specifically, the date when UA will stop processing new hits. The 1st of July, 2023. For those without a calendar to hand, that’s fifteen and a half months from now. So plenty of time still to think about migrating to Google Analytics 4, right? Wrong. Well, wrong if on 1st July 2023 you want to be able to compare your latest GA4 data with comparable data from the previous year. And what analyst wouldn’

Dara Fitzgerald-16 Mar 2022

(BONUS pod) Google is sunsetting Universal Analytics!

Dan and Dara react to the big news (bombshell) from Google about them sunsetting Universal Analytics in 2023. The announcement from Google can be read in full at https://bit.ly/3thHJDq. Check out on LinkedIn: - Dan - https://bit.ly/3JQKHEb - Dara - https://bit.ly/3vzV0bO - Measurelab - https://bit

Daniel Perry-Reed-16 Mar 2022

GA4 BigQuery export schema

In BigQuery, the Google Analytics 4 schema is completely different to the (Universal) Google Analytics 360 schema. This tree map is a simple interactive way to explore the new schema for new and old GA/BigQuery users alike.

Scott Hellmund-10 Mar 2022

From the wild west of data collection to conversion modelling

How will Google’s machine learning conversion modelling and other models change analytics? Is this the end of real data?

George Mendham-24 Feb 2022

How to use the BigQuery Data Transfer Service for Google Ads

To perform advanced data analysis, you need a powerful data warehouse like BigQuery. Here’s how to extract Google Ads data using the BigQuery Data Transfer Service.

Natalia Rizzi-22 Feb 2022

Google Analytics limitations: where GA falls short

It’s an uncomfortable truth for Analytics specialists: GA is not always the answer. Google Analytics' limitations mean it won’t always be the right solution for you.

Vanessa Fitarelli-18 Feb 2022

How to force a hit-level segment in Universal Analytics

In Universal Analytics, you can build a user-level or session-level segment. Here’s a nifty little hack to force a hit-level condition to get the data that you want.

Dara Fitzgerald-15 Feb 2022

5 new GA4 features we want Google to introduce in 2022

Whether GA4 is the ‘new and improved’ version of Universal Analytics remains to be seen. There are some GA4 features and functionality we’d like to see in 2022.

George Mendham-28 Jan 2022

Keep up! - the ultimate analytics resource round-up

Keeping up with the analytics industry is a daunting task. This list is a good starting point for anyone wanting to get caught up - or stay one step ahead.

Daniel Perry-Reed-26 Jan 2022

How to reduce the cost of BigQuery data processing

BigQuery cost optimisation tips to reduce the number of bytes processed and the cost of running queries.

Steven Elliott-25 Jan 2022

The nine signs of analytics maturity

How do you measure up when it comes to analytics maturity? Forget all those finicky frameworks. If you're displaying one of these nine signs then chances are, you're on the right track.

Steven Elliott-20 Dec 2021

2021: Measurelab’s year in review

A reflection on the year gone by and how far we’ve come as a company and team. From remote working to co-working, finding time for fun, and a growing appetite for GA4, we only mention Covid a few times.

Dara Fitzgerald-17 Dec 2021

How to enable the GA4/Firebase DebugView for Android apps

How to enable analytics debug mode on an Android device, using the GA4/Firebase DebugView to monitor app event data.

Mark Rochefort-16 Dec 2021

10 reasons to export your GA4 data to BigQuery

There are a lot of benefits to linking your GA4 data to BigQuery – we’ve got ten good reasons for you to take your analytics to the next level today.

Lace Rogers-25 Nov 2021

How to write a value to a cookie using GTM

Learn how to create and set cookies using Google Tag Manager using this simple script and a Custom HTML tag.

Victor Sarker-10 Nov 2021

The superpower of objectivity

The do-it-yourself approach to data-driven organisational change can be daunting – an objective consultant, removed from the day-to-day operations of the business, can take more risks.

Dave Beatty-8 Nov 2021

Key KPIs, ATM machines and other such nonsense

All KPIs are metrics, but not all metrics are KPIs. Are they key to the business’ success? Or do they contribute to it? When it comes to analytics, not all performance indicators are critical.

Daniel Perry-Reed-6 Oct 2021

What we do

Keep your measurement working as things change.

Diminishing data

Cloud technology

AI disruption