Enjoy all the articles in the section “All articles”. Here you can read about Google Sheets, Looker Studio, Data Visualization online course, Digital marketing and find template overviews and useful tutorials!
If you want to build time-based charts that highlight trends, peaks, and seasonality in your data, this guide walks you through the exact steps I use when creating time series charts in this Looker Studio Tutorial. I cover selection, formatting, …
How to Visualize Data Over Time in Looker Studio Reports Read more »
The fastest way to make any dashboard readable is to give people the key numbers first. In this article I walk you step by step through building a clean KPI strip at the top of a Looker Studio report: adding …
Tutorial #5 – How to Add Scorecards and KPIs to Your Looker Studio Report Read more »
If you want a clean, client-ready top section for your Looker Studio dashboard, this step-by-step guide will walk you through building a polished header: add a logo, create a clear title, add an interactive date range control, and align and …
How to Make Your Looker Studio Dashboard Look Professional (Header Setup Guide) Read more »
I’m going to build a clean, shareable Looker Studio dashboard step by step and explain every decision I make while I set up the theme, the layout, and connect a GA4 demo account. If you prefer to follow the clicks …
How to Set Theme and Layout in Looker Studio and Connect Your GA4 Data Read more »
If you want a practical, step‑by‑step guide to take your first Looker Studio report from “blank canvas” to a usable, shareable dashboard, this article walks you through the exact workflow I use. Note: This is the second lesson in my …
Looker Studio Tutorial 2025: Clean Dashboards Made Easy. Lesson 2 Read more »
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 …
0 items in the cart (0 €)