Marco Gioardano – Analytics For SEO

• Use GSC and GA4 data to their fullest potential
• Learn Python/SQL for your needs
• A complete blueprint for auditing websites
• How to 10x your productivity
• BigQuery explained easily

The modules below are purely for demonstrative purposes.
Each module contains several lectures with videos and code.
This course is over 30 hours long with videos, tutorials, and code notebooks.

Getting Started With Analytics

• Fundamentals
• Rules & Support
• What tools you need & how to install them (Data + Notebooks Included)
• Python 101 (Check This Before You Start)
• Virtual Environments & More
• Google Search Console
• Google Analytics 4

Website Auditing

• The 8-step Framework
• Extracting & Loading Data From GSC & GA4 APIs
• Data Inspection & Profiling
• Cleaning & Understanding Your Data
• Grouping & Aggregating Data
• Reshaping Data
• Analyzing & Classifying Top Pages + Queries
• Content Decay & Traffic Analysis
• Internal Linking Audit
• Detecting Cannibalization
• Integrating Other Data Sources & Classification

Dealing with Big Websites + BigQuery/SQL

• Tools for Big Websites
• BigQuery & The Power of SQL (Super Big Websites)
• Introduction to SQL & Basic Concepts
• Advanced SQL Concepts
• Using Polars & DuckDB for Large Datasets (20GB+)
• GA4 In Detail
• GA4 Dataform: Shortcut for Modelling
• CTR Analysis

Additional Use Cases

• SERP Analysis