Is this you?
Sound familiar?
01
You freeze the moment someone asks you to go deeper
You can pull a report in GA4. But the moment someone says "OK and so what?" or asks you to do an actual analysis that goes beyond Explorations, you freeze.
You know there is more than standard reports from tools...
The Marketing Gap
You know there is more than standard reports from tools...
02
You've basic Web Analytics knowledge. None of that helps with real business.
You studied GA4 and GTM. Maybe some ML. You did the tutorials. But when you're at your desk on Monday morning, none of it applies.
The gap between what you learned years ago and what your actual job needs is enormous and no one warned you.
The Generic Course Trap
The gap between what you learned years ago and what your actual job needs is enormous and no one warned you.
03
You spend ages to do a meaningful analysis.
It takes weeks or more to prepare what you were asked because there is no consistency in your data.
You are forced to do a lot of manual work that could be prevented.
The Stack Gap
You are forced to do a lot of manual work that could be prevented.
Module 1 — Data Foundation
GA4, GSC & Crawl Data
in one place
in one place
The GA4 interface gives you aggregated numbers someone else decided to show you. In BigQuery, you own the raw data. You'll learn to export GA4 events, pipe in Search Console data, and pull additional data sources, then join all of them for analysis you can actually trust.
- GA4 raw event schema and BigQuery export setup
- GSC tables via Bulk Export and how to interpret them
- Additional data in BigQuery (Crawl Data, Google Merchant Center, etc.)
- Full breakdown of what matters in each source
- Avoiding the UI limits that hide your data
Module 2 — Work With Data
LLMs, SQL & Python
as actual tools
as actual tools
Most analytics courses skip LLMs. This module teaches you how to use them together on real data. You'll write SQL queries that answer business questions, use Python where it actually saves time, and build LLM workflows that fit into Web Analytics.
- SQL for Web Analytics: sessions, attribution, conversion logic
- Python for automation
- LLM workflows for coding, documentation and diagramming
- Claude Code + Terminal
- Agent use cases and how to use them for Web Analytics
Module 3 — Model Your Data
Dataform & the art of
clean data
clean data
Raw Google data is not analysis-ready. This module covers how to model your data properly in Dataform so every query downstream is faster, cheaper, and easier to trust. You'll build pipelines that process incrementally, handle schema changes, and produce tables your stakeholders (or you) can actually use.
- Dataform project setup and BigQuery integration
- Incremental vs. full refresh strategies for web data
- Unnesting GA4 events into clean, queryable tables
- One big table vs. normalized schema, when each makes sense
- Combining GA4 & GSC in a single pipeline + other sources
Module 4 - Real-World Use Cases
The work that
actually ships
actually ships
This is where everything from the previous modules gets applied to problems real clients and teams bring to the table. Website audits, product catalog analysis, scraping pipelines, dashboards.
You'll work through end-to-end workflows that you can adapt and reuse immediately after the course.
You'll work through end-to-end workflows that you can adapt and reuse immediately after the course.
- Website auditing with GSC, GA4, and crawl data combined
- Product and catalog auditing for ecommerce teams
- Scraping pipelines for content research and competitive analysis
- Data visualization in Looker Studio and Python notebooks
- Structuring deliverables stakeholders can understand and act on
Module 5 — Applied Use Cases
What you'll be able
to build and deliver
to build and deliver
End-to-end analyses and workflows, ready to adapt and reuse on your own projects. P.S. Subject to changes, placeholder images!
Add screenshot
Content/Product Auditing
Audit a website with GA4, GSC & Crawl data to give relevant business advice. Not just a technical checklist.
Add screenshot
Small Web Apps & Automation
Make your work simpler and show your clients something they will be able to use. You won't just send an Excel and forget.
Add screenshot
Ecommerce analysis
Get your full picture of what is selling in your Ecommerce and what are the key opportunities.
Add screenshot
Pipelines that combine GA4, GSC & More Data
What every business needs but not many do. I will show you how to have a holistic view of a website.
Add screenshot
Scraping & Content Pipeline
A full process to create and improve content based on scraping websites. You'll learn how to extract information from the web and make it available to LLMs.
Add screenshot
Advanced Data Visualization
How to build high-level data visualizations that Looker Studio can't match.
Before you enroll
Is this the right course for you?
This course is built for you
You know GA4 but feel like you are hitting a ceiling every time an analysis needs to go deeper than Explorations.
You are a digital analyst who wants to work directly with raw data instead of relying on what the interface shows.
You want to learn SQL and BigQuery in the context of real web and marketing problems, not abstract exercises.
You are tired of reports nobody acts on and want to understand how to connect data to actual decisions.
You want a workflow that combines GA4, GSC, Python, and LLMs in a way that fits an analyst's actual working week.
You want to build things: pipelines, dashboards, use case analyses, not just watch someone else build them.
This is probably not for you
You are a complete beginner with no exposure to GA4 or web analytics. The course assumes baseline familiarity with the tools.
You are looking for a pure data engineering course. This is for analysts and marketers who want to level up, not engineers building infra.
You want generalist content. This is strictly applied to Web Analytics and real use cases.
You want click-through UI tutorials. Everything here is hands-on analysis on real data from the first module.
FAQs
Do I need coding experience or technical background?
+
No prior coding experience required. As outlined above, the course is designed for marketers and analysts who want to become more technical without becoming full developers. We start with fundamentals and build complexity gradually.
Code is provided inside the course. Most of it requires no further setup and is ready to go. By the end of the course, you will be confident to do your own analyses.
How can I get an invoice for my company?
+
When purchasing the course, there is an option to get a VAT invoice. I can't give you an invoice myself as the legal seller of the course is Teachable, not me.
If you forgot to request the invoice, contact me.
Do we pay for updates?
+
You get access to free updates forever.
You can also request specific topics if you think they are missing from the course.
Are there group discounts?
+
If you are a company and need a group discount, feel free to contact me.
Teachable can detect multiple logins, avoid sharing the same course within your organization.
How much Python and SQL will I learn?
+
Enough to make more money and add value. With LLMs, now it's easier to write code even if you have never done it.
I show you the basics, as well as some advanced concepts, but coding per se is NOT important for you as an Analyst.
You get paid to rank pages and make companies more profitable, remember that.
Coding is just a means to achieve an end. Don't obsess over technologies, focus on the method.
How does the 1:1 support work?
+
After you have completed a given section or lesson of the course, you can contact me and we can review it together.
You can ask me anything as long as it's related to the content of the course.
Topics outside of the course are not included in the 1:1 support.
Is this course suitable for people working with local/small websites?
+
Absolutely yes but keep in mind that most of the advanced content of the course will be of little use to you.
Small companies still require a decent understanding of Analytics.
Hi - I am Marco Giordano. I help companies and agencies to make the most out of their web data.
I am a Web Analyst with a background in Business, SEO and Content.
A lot of people worldwide read my content and use my advice to add value to their projects.
I've a newsletter and website called Seotistics and have been helping 1000s of people like you to improve in Web Analytics.
If you feel lost with all of that data and don't know how to integrate it into your business...
I am the right guy for you!
As Featured In
Recognized by leading industry publications and invited to speak at top conferences worldwide
Conference Speaker
BrightonSEO
Marketing Business Summit
MeasureSummit
SerpConf
2.2K+
Newsletter Subscribers
10+
Conference Talks
350+
Students Helped