Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Analytics For SEO
Getting Started With Analytics
Fundamentals
Rules & Support
What tools you need and how to install them (Data+Notebooks Here)
Python 101 [Check This Before You Start] (36:00)
Google Search Console
Google Analytics 4
Website Auditing
The 8-step Framework
Extracting + Loading Data From GSC & GA4 APIs (10:40)
Data Inspection & Profiling (27:47)
Cleaning & Understanding your data (10:35)
Grouping & Aggregating Data (9:50)
Reshaping Data (25:21)
Analyzing & Classifying Top Pages + Queries (20:53)
Content Decay & Traffic Analysis (55:23)
Internal Linking Audit (13:31)
Detecting Cannibalization (11:43)
Integrating Other Data Sources & Classification (14:02)
Dealing with Big Websites
Tools for big websites
BigQuery and the power of SQL (Super big websites)
Introduction to SQL & Basic Concepts (14:34)
Advanced SQL Concepts (39:57)
Using Polars and DuckDB for large datasets (20GB+) - Micro Lecture
How To Create Effective Reports
How To Create Beautiful Plots (24:32)
The DataViz Rules
Looker Studio
Additional Use Cases
SERP Analysis
Teach online with
BigQuery and the power of SQL (Super big websites)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock