Skip to content

Ken Williams

The Analyst's Guide to Google Analytics for Firebase

Menu
  • Home
  • Overview
  • Project Setup
  • Installation
  • Reporting & Analysis
  • Integrations

Category: Reporting & Analysis

Posted onJanuary 15, 2021January 15, 2021Guide

How the WITH Clause Can Simplify Your SQL Queries

by KenLeave a comment on How the WITH Clause Can Simplify Your SQL Queries

This is a quick post to highlight how you can simplify your SQL using the WITH clause. I’ve used this technique a lot lately to…

Read More
Posted onJanuary 7, 2021January 7, 2021Guide

BigQuery + GA4: How To Get the First or Most Recent Event for a User

by KenLeave a comment on BigQuery + GA4: How To Get the First or Most Recent Event for a User

When working with Google Analytics 4 data in BigQuery, it is common to analyze the first or most recent activity for a user. For example:…

Read More
Posted onMay 29, 2020October 14, 2020Guide

How to Use the Over clause to Create a Moving Average in BigQuery

by KenLeave a comment on How to Use the Over clause to Create a Moving Average in BigQuery

In this post I will explain how to use the Over clause to create a moving average, and provide a tutorial for visualizing COVID-19 cases in your area.

Read More
Posted onMay 10, 2020October 14, 2020Guide

Using BigQuery and Data Studio with Google Analytics 4

by KenLeave a comment on Using BigQuery and Data Studio with Google Analytics 4

The goal of this post is to share tips and best practices for visualizing your Firebase Analytics data in BigQuery and Data Studio, and give you a few samples to help get started.

Read More
Posted onMay 10, 2020January 5, 2021Guide

Data Studio + BigQuery + GA4: Viewing a Parameter Across Multiple Events

by KenLeave a comment on Data Studio + BigQuery + GA4: Viewing a Parameter Across Multiple Events

Sometimes you have multiple actions with separate event names that share a common parameter. This post will allow you to view how frequently each event occurs by the value of your event parameter.

Read More
Posted onMay 10, 2020January 5, 2021Guide

Data Studio + BigQuery + GA4: How to View Multiple Parameters on the Same Event

by Ken2 Comments on Data Studio + BigQuery + GA4: How to View Multiple Parameters on the Same Event

This post will show you how to create a table that shows multiple different parameters of the same firebase event as dimensions using Data Studio and BigQuery.

Read More
Posted onMay 10, 2020May 11, 2020Guide

How to Flatten a BigQuery Table with UNNEST

by KenLeave a comment on How to Flatten a BigQuery Table with UNNEST

The UNNEST operator allows you to run queries that flatten the data into the simple format required by your data visualization tools (such as Data Studio).

Read More
Posted onMay 10, 2020October 14, 2020Guide

Understanding the User ID in Google Analytics 4

by Ken6 Comments on Understanding the User ID in Google Analytics 4

At first glance the User ID seems simple enough, but it can get a big complex when you start pulling reports. The purpose of this post is to explain how the User ID is used to generate reports.

Read More
This is my face

Ken Williams

Senior Data Engineer @ Search Discovery


I've spent the last decade helping my clients become experts in Analytics and Tag Management. This is what I've learned.

Connect with me on LinkedIn, or contact me over email or Measure Slack

me@ken-williams.com
@KenWilly on Measure Slack and Twitter

(more about me)

Get a monthly summary of the latest Google Analytics 4 news from the GA product blog, the GMP blog, the Firebase blog as well as other public announcements made available to Google partners and resellers.

[see the archive]

Recent Posts

  • Goals vs. Conversion Events in Google Analytics March 3, 2021
  • How the WITH Clause Can Simplify Your SQL Queries January 15, 2021
  • BigQuery + GA4: How To Get the First or Most Recent Event for a User January 7, 2021
  • 3 Tips for Planning Your Migration to Google Analytics 4 November 16, 2020
  • Google Signals and Privacy in Google Analytics 4 October 20, 2020
Publically available examples of data studio reports
Google is constantly iterating on the products described in this guide, and so please be understanding and notify me if you find any content that is out of date.
Amphibious Theme by TemplatePocket ⋅ Powered by WordPress