AI SEO In Detail
Free course · 50 episodes · 6 modules

A free SEO course in real analysis

Search traffic, SERP analysis and competitor gaps — the way practitioners actually do it, with Google Search Console, DataForSEO and Claude Code. Every episode uses real data, every method is shown step by step, and every episode comes with a free download.

23episodes out now
50episodes planned
$0the course is free
3part method
Three doorways: Traffic, SERP and Gap

The method: Traffic, SERP, Gap

Traffic: Search Console and GA4 data for one site1

Traffic

What is happening on your site, and where? Search Console and GA4 read properly — page level, query level, real vs bot traffic.

SERP: a live Google results page with its features2

SERP

What does Google actually show for the searches you care about? Live results, features, who ranks and why.

Gap: keywords competitors rank for that you do not3

Gap

What are competitors getting that you're not? Keywords, page types, links — sized by volume, winnability and value.

Who this course is for

Practitioners: consultants, in-house SEOs and people who build sites. It is not a beginner's introduction to SEO — you should already know what indexing, rankings and search intent mean.

You'll need: Google Search Console and GA4 access for a site with some traffic, a Claude subscription or API account for Claude Code, a DataForSEO account with a small budget ($10–20 lasts a long time), and a Google Cloud project for the API pulls (episode 4 shows how). Claude Code writes the scripts; the course teaches you to check them.

Disclosure: the DataForSEO links on this site are affiliate links. If you sign up and pay, we may earn a commission at no extra cost to you. We use DataForSEO ourselves and pay for it like anyone else.

The course roadmap

Latest episode

Episode 23: Keyword Ideas and Related Terms With the DataForSEO API
23

Keyword Ideas and Related Terms With the DataForSEO API

Find keyword ideas with three DataForSEO Labs endpoints: pick seeds, control cost per row, dedupe and merge results, clean out drift, and compare volumes.

Free downloads

Checklists, calculators and ready-to-run scripts. No sign-up.

1

The 3-Part SEO Analysis Checklist

Traffic, SERP, Gap — always in that order. One printable page.

2

SEO Data Budget Calculator

Keywords × frequency × depth → your real monthly SEO data cost. Spreadsheet + one-page guide.

3

DataForSEO First Call Starter Script

Credentials outside the code, a free check first, one live call, cache before you parse. Python, standard library only.

4

Search Console Daily Pull Script + SQLite Schema

Stop exporting 1 000-row CSVs: a daily Search Console pull into SQLite, with pagination, cache and a sanity check.

5

SEO Data Model: SQLite Schema + URL Normalizer

One data model for Search Console, GA4 and DataForSEO: the SQLite schema, the page_summary view and the URL normalizer from episode 5.

6

SEO Workspace Template with a Cost Gate

One folder, one database, a cache for everything, secrets outside, and a gate in front of every paid call. Unzip and start.

7

First-Analysis Prompt + Cost-Gate & Verification Checklist

The prompt, the four-part cost gate and the five-minute verification routine from your first DataForSEO + Claude Code analysis.

8

Search Console Reading Checklist

Four metrics, two averaging traps, whole weeks and a reading order. One printable page.

9

Hidden Query Share Script for Search Console

Why Search Console numbers never add up: measure the visible share of every page's clicks and impressions. Python script + README.

10

Striking Distance Finder + Worksheet

Find the pages stuck on page two, rank them by the striking-distance impressions they collect, and log every change. Python script + Excel worksheet.

11

CTR Underperformer Finder + Title Change Log

Ranks well, gets skipped: find the titles to rewrite with your own CTR curve, then log and re-measure every change.

12

Keyword Cannibalization Checker + Decision Tree

Most flagged cannibalization is healthy overlap. Find the real cases in Search Console: position, time, intent — then the right fix.

13

Season vs SEO Trend Template

Rolling averages, year over year, a demand index from monthly volumes, and clicks per unit of demand. Excel/Sheets template + Python script.

14

Brand Regex Starter Kit

Split brand from non-brand, catch the misspellings, report non-brand as your SEO number. Regex templates + Python script + checklist.

15

GA4 Bot-Filter Checklist

Hostname first, bot patterns in clusters, GA4 against Search Console. One printable page.

16

Traffic Drop Diagnostic Checklist

Six steps, always in the same order, and a one-line diagnosis template. One printable page.

17

Crawl > Index > Rank Funnel Worksheet + Index Sampling Script

Measure crawl, index and rank separately and see where pages get stuck. Excel funnel worksheet + Python index-sampling script.

18

Search Volume Sanity Checklist

Source, time window, grouping, location, rounding: five checks before you trust a volume. One printable page.

19

Zero-Volume Decision Sheet + Impression Check Script

Zero means below the floor, not no demand. Decide Build, Support or Skip from impressions, the results page and the parent topic. Excel sheet + Python script.

20

Singular vs Plural Validation Script + Decision Sheet

Test the form before the big pull: one validation task, a verdict, and the rule for combining volumes. Python script + Excel decision sheet.

21

Intent Classifier Kit: Rules, Prompt, Validation and Sample Sheet

Rules for the obvious keywords, a fixed-label prompt for the rest, automatic validation and a sample check. Python script, prompt, rule file + Excel sheet.

22

Keyword Value Score Sheet

Rank keywords by money, not just volume: volume x your own CTR x CPC, sorted into three tiers. Excel sheet.

23

Keyword Discovery Script

From a few seeds to one clean master list: three Labs endpoints, a limit on every call, a careful merge and flags instead of deletions. Python script.

★

Pro Kit — everything in one bundle

All scripts, templates and checklists from the series, maintained and updated, plus Claude Code workflows. One-time purchase.

All 50 episodes

New episodes are published regularly. Every episode is scripted; the ones marked “coming soon” are on their way.

Module C · Demand and Keyword Research

Where search volume comes from, why “0” lies, intent at scale, clustering and money keywords.

Module F · Putting It Together

A full analysis on a real site, automated with Claude Code, monitored monthly.