I recently published a short video where I walk through a few SQL tricks in BigQuery that I use every day to get actionable insights from GA4 data. In this article I’ll expand on those ideas, explain the SQL patterns …
GA4 BigQuery Tutorial: How to Calculate 7-Day Moving Averages, Shares and DoD with SQL Read more »
I love turning raw GA4 data in BigQuery into actionable metrics, and one of the most useful techniques I rely on is a cumulative sum (also called a running total). In this article I’ll walk you step-by-step through a practical …
How to Calculate Running Totals in BigQuery (GA4) Read more »
If you want clean, queryable Facebook Ads data in BigQuery without writing a single line of code, this tutorial is for you. In this step‑by‑step guide, I walk you through setting up a Supermetrics Transfer from Facebook Ads into BigQuery, …
Connect Facebook Ads to BigQuery — Full Guide (No Code) Read more »
I created a simple, practical Google Search Console (GSC) dashboard for Looker Studio that helps marketers and analysts get fast answers about search performance. In this article, I walk you through how I built the dashboard, why I included three …
Free GSC Report Template for Marketers in Looker Studio Read more »
You open Looker Studio, and… it’s just a big empty page. What now? Before you panic or close the tab, let me walk you through exactly what to do first. If you prefer a quick visual walkthrough, watch the …
If you’re building marketing dashboards in Looker Studio, choosing the right connector for Looker Studio makes a massive difference. I recorded a short video walkthrough where I compare the most popular Facebook Ads connectors for Looker Studio and explain which …
I usually write here about marketing analytics — dashboards, GA4, BigQuery.But today’s story is different. It’s about my first app that we built using AI tools. And yes, we built it in just two days. Last weekend, I joined an …
Can You Really Build an App in 48 Hours Using AI Tools? Read more »
If you want to streamline your marketing analytics by sending your advertising data directly into BigQuery, you’re in the right place. This guide will walk you through the process of connecting Supermetrics with BigQuery from scratch. I’ll cover everything from …
Send Ad Data to BigQuery with Supermetrics – Easy Setup Read more »
If you’re working with GA4 data in BigQuery — welcome. It can feel overwhelming at first, but once you get a few core queries in place, everything starts making sense. I’ve put together 10 simple, reusable queries that I use …
How to Use SQL with GA4 in BigQuery: 10 Real Examples for Marketers Read more »
Facebook Ads Manager is messy. Long tables, unclear charts, and endless columns make it hard to understand what’s really working. That’s why more marketers and small businesses are turning to Looker Studio (formerly Google Data Studio) to build clear, visual …
3 Ways to Connect Facebook Ads to Looker Studio (2025 Guide + Free Template) Read more »
0 items in the cart (0 €)
* Your contact data is confidential and may be used only to reach you.