Our colleague David Westby is presenting at Brighton SEO 2025 on personalizing GA4 sessions with raw BigQuery data.

Brighton SEO 2025: Personalizing GA4 Sessions with Raw BigQuery Data

GA4 only attributes the first touchpoint in a session. UA (arguably!) did it better. Learn how to create multi-touch attribution sessions.

Bringing Back UA Multi-Touch Attribution

Bringing Back UA Multi-Touch Attribution - BigQuery & Basics

GA4 not matching what you're seeing in BigQuery? Or is the Looker Studio not matching it? Here are 12 reasons why and how to fix them.

Why doesnt GA4/Looker Studio match GA4 BigQuery?

Why doesn't GA4/Looker Studio match GA4 BigQuery?

Still pining for Universal Analytics? Well we've moved on. GA4 is here. Let's talk through the differences.

What is the difference between UA & GA4?

How are Universal Analytics and GA4 different? - BigQuery & Basics

Learn how to query date ranges with GA4 BigQuery streaming and daily tables.

How to query your streaming & daily GA4 BigQuery tables

Query date ranges with the GA4 BigQuery events_ tables

How does GA4 sort out traffic sources? How does last non direct click work in BigQuery?

GA4 Traffic Sources Explained

GA4 Traffic Sources - BigQuery & Basics

There is a lot to the GA4 BigQuery export schema. We dive into it in agonising detail.

Explaining the GA4 BigQuery Export Schema

The GA4 BigQuery Export Schema - BigQuery & Basics

Learn how to set up the GA4 BigQuery export and the differences between GA4 BigQuery streaming and daily tables

How to set up the GA4 BigQuery export?

How to set up the GA4 BigQuery Export? - BigQuery & Basics

The BigQuery export is the best part of GA4. Stop fighting the UI and instead get to work with the best part of it.

An Introduction to GA4 & BigQuery

Intro to GA4 BigQuery Export - BigQuery & Basics

Do you understand GA4 scoping? If you don’t there’s a good chance you’re looking at wrong numbers. This post will talk you though all you need to know.

GA4 Scoping Explained

GA4 Scope Explained - BigQuery & Basics

In GA4, you’ll see Google uses the term "User" fairly liberally. This post will talk through what you need to know.

GA4 Users Explained

GA4 Users Explained - BigQuery & Basics

How do GA4 Sessions work? We'll cover the basics and then apply to that to BigQuery.

GA4 Sessions Explained

GA4 Sessions Explained - BigQuery & Basics

A starter GA4 BigQuery query with all the default dimensions and metrics that you can just paste into Looker Studio.

 GA4 BigQuery Starter Query

The reports for your SEO leadership team aren't the same as the ones you should be using every day.

4 Steps for SEO reporting for C-Suite & Leadership

Need to report on SEO and not sure where to get started? We'll talk you through the whole process and point you to some example templates to boot.

How to Useful SEO Reports

How to Create Useful SEO Reports - (With Templates!)

We've got a free Looker Studio template to help you escape the Search Console interface. Dive on in.

Free Search Console Looker Studio Template + Setup Guide

Free Search Console Looker Studio Template

Need something to get going with? We've got free templates to get you started on your journey to better reporting.

Free SEO Looker Studio Dashboards + Setup Guide

2 SEO Looker Studio Dashboard Templates - With a Setup Guide!

How can we get all of our data out of Search Console? Particularly when it samples.

How to reduce Search Console data limits and get 4x the data

Search Console Data Limits. How to be and get 4x the data

Revenue per keyword? Sessions broken down by brand? We can get both of those by joining our SC and GA data together.

How to join GA4 and Search Console data

How to Join GA4 and Search Console Data | Piped Out

Can we just compare sessions, page views and conversions from GA4 and UA? Are medium and source still the same thing?

What are the practical differences between UA and GA4 (Dims & Metrics)

Why don't UA and GA4 match up? (Dims & Metrics)

How can we merge GA4 and UA in Looker Studio? Depending on which metric you might need to make some adjustments to have it all work.

How to merge GA4 & UA in Looker Studio?

How to blend GA4 & UA in Looker Studio?

Why doesn’t my Search Console data doesn’t match Looker Studio numbers?

Why are there data discrepancies between Search Console & Looker Studio. 

Why don't Search Console (GSC) numbers match Looker Studio?

What’s the difference between URL and Site Reporting in Search Console?

URL vs Site Reporting in Search Console - Explained | Piped Out

Slowly more and more of the searcher journey is going to take place on Google. What can you do about it?

Google's One Stop Shop SERP

Google's One Stop Shop SERP | Piped Out

Struggling to use GA4? Need a quick dashboard to get you started with measuring your SEO efforts? We've got you covered.

How to setup our GA4 Looker (Data) Studio Template

How to setup our Free GA4 SEO Looker Template

Why is your Looker Studio dashboard slow and how can we speed it up? Too many data sources, too much data processing, endless charts, and heavy formatting all sorts of things could be preventing you.

Why is my Looker Studio dashboard slow and how can I make it faster?

How to Speed Up a Slow Looker Studio Dashboard

Want to win featured snippets? Do you also want to not over estimate what is possible and spend a lot of time and money on a snippet you can't win?

How to Win Featured Snippets and Set Expectations

How to Win Featured Snippets (Help from 400 SERPs) | Piped Out

Still on that GA4 migration? Here are the most common problems we've seen with people going through migrations.

The 5 most common problems we’ve seen with GA4 migrations

5 most common issues we've seen with GA4 migrations

We've seen a fair few GA4 migrations. If you're still looking to migrate here are some helpful steps to think about when doing it.

GA4 Migration - Setting up the backend

GA4 Migration - Lessons on validating & exporting your data

Are you wondering what's missing from your dashboard? It's probably cross filtering. If you're building a dashboard in Looker Studio (or any other BI tool), please consider it.

Cross Filtering in Looker Studio. It's incredible.

Use Cross Filtering in Looker Studio

Are you putting together a rank tracking dashboard? Are you wondering what a good one looks like? We can help.

How To Build a Great Organic Rank Tracking Dashboard

Organic Rank Tracking Dashboard - Teardown & Build

Keeping track of everything happening on large websites is hard, even for large teams. Unit tests help to keep it under control, but they sit in the tech team. How can we re-create something close to a unit/integration test?

DIY Unit Testing for SEO

DIY Unit Testing for SEO - Free Tool

The only thing better than Search Console, is getting all your data from Search Console. This post describes details of building the search console data downloading tool.

Notes on building the search console data downloader

Instructions on how to set-up our free Search Console dashboard and personalise it for your own website.