
How to flatten tables with user-defined functions in BigQuery
Flattening tables in Google BigQuery can be painful when doing multiple fields with UNNEST. User-defined functions (UDFs) make life easier and this one will do it for you automatically.
Insights
Firebase Analytics implementation, mobile app tracking, and event measurement (47 posts)
Explore a topic across our insights
47 results · Page 3 of 3

Flattening tables in Google BigQuery can be painful when doing multiple fields with UNNEST. User-defined functions (UDFs) make life easier and this one will do it for you automatically.

This week Dan and Dara discuss the four things analytics practitioners should consider before rolling out Google Analytics 4 (GA4).

This week Dan and Dara chat about the three key reasons they think we should care about GA4 right now.

Be warned: the risk of sticking with your current Google Analytics implementation may well be greater than any costs associated with the "migration" to GA4.

There's a surprising number of data feeds and transfers for Google Analytics 4, BigQuery, Data Studio and all its connected accounts and platforms. We set out to map them all to assist with your architecting.

At Measurelab we live and breathe the Google Cloud Platform, so our specialists are experts in Bigquery. We have decided in this series to share our knowledge and take you through some great techniques to maintain your BigQuery data warehouse. So firstly-what is BigQuery? BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data. ...and that means? Simply put, BigQuery is a fantastic cloud-based data warehouse in which you can store huge

The new future version of Google Analytics has been announced - now branded as Google Analytics 4. Building on the "App + Web" property that was released last year, this sets the direction for Google Analytics going forwards. It is now the default experiences for all new properties and is where all product developments will be focussed. Google Analytics 3, commonly known as Universal Analytics, was released in October 2012. This next product iteration for Google Analytics is a major step on fro

Speaking at Measurefest For the first time in a few years, I took to the stage at Measurefest to talk about how to get your data from Google Analytics into BigQuery, and what you can do with it when you get there. Affordable BigQuery solutions Obviously, Analytics 360 can do this, but it costs $$$ per year. I outlined some more affordable methods, including third-party connector solutions, and provided a detailed example of how we would use our own Pipelines solution and what we could achiev

Last week, Google announced they were unifying their analytics and advertising platforms under a single new name: Google Marketing Platform. The Google Analytics 360 Suite and DoubleClick brands are being replaced with this single name. What does this mean for DoubleClick? If anything this is a change that has needed to happen for years. DoubleClick always sat rather clumsily alongside other tools from Google and this shift heralds the beginning of a more unified approach. Search Ads 360 wil

<span style="font-weight: 400;">This article describes how to integrate Google Analytics for Firebase (formerly Firebase Analytics) to a React Native app. </span><span style="font-weight: 400;">In order to do this, you need to use a JavaScript bridge called </span><a href="https://github.com/invertase/react-native-firebase"><span style="font-weight: 400;">RNFirebase</span></a><span style="font-weight: 400;">. </span> This is lightweight layer sitting on top of native Firebase librarie

<span style="font-weight: 400;">After a steep learning curve into the world of Firebase Analytics or Google Analytics for Firebase, it seems that a blog post about it would be much valued and appreciated. I’ve compiled a list of the most frequently asked questions.</span> 1. How does Firebase Analytics define a session? Firebase Analytics defines a session as a user engaging with your app for a minimum amount of time (10 seconds by default) followed by your user not engaging with your app