Reshaping Data | Seotistics Academy

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 (20:14)
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
GA4 In Detail

How To Create Effective Reports

How To Create Beautiful Plots (24:32)
The DataViz Rules
Looker Studio
Reporting & Operations

Additional Use Cases

SERP Analysis

Teach online with

Reshaping Data

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock