Articles

Web analytics, written for people who have to make the number hold up in a meeting.

Combining GSC & GA4 Data In BigQuery (SQL Code Included)

November 6, 2026April 9, 2024 by Marco Giordano

BigQuery is a powerful data warehousing solution by Google that allows you to export Google Search Console and Google Analytics 4 data easily. Many don’t know that what you get after is quite different from the API output. The BigQuery tables are chaotic and hard to decipher without proper guidance. I will explain to you … Read more

The Definitive SEO Analytics Stack [+ Workflows]

November 6, 2026March 12, 2024 by Marco Giordano

Many of you have asked me what is the best stack to do Analytics for SEO. The answer is quite straightforward as the problems we face are always the same, and thus the tools we can use. You are free to experiment and test new tools but the important is realizing that they are simple … Read more

Combining GSC & GA4 Data In BigQuery (SQL Code Included)

The Definitive SEO Analytics Stack [+ Workflows]

Modern Python Scraping Libraries: What To Use?

The LLM Measurement Guide: Metrics, Methods & Tools

Dataform Ultimate Guide: Build Your GA4 + GSC Pipeline