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.

The method: Traffic, SERP, Gap
1Traffic
What is happening on your site, and where? Search Console and GA4 read properly — page level, query level, real vs bot traffic.
2SERP
What does Google actually show for the searches you care about? Live results, features, who ranks and why.
3Gap
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.

Latest episode
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.
The 3-Part SEO Analysis Checklist
Traffic, SERP, Gap — always in that order. One printable page.
2SEO Data Budget Calculator
Keywords × frequency × depth → your real monthly SEO data cost. Spreadsheet + one-page guide.
3DataForSEO First Call Starter Script
Credentials outside the code, a free check first, one live call, cache before you parse. Python, standard library only.
4Search 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.
5SEO 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.
6SEO 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.
7First-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.
8Search Console Reading Checklist
Four metrics, two averaging traps, whole weeks and a reading order. One printable page.
9Hidden 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.
10Striking 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.
11CTR 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.
12Keyword Cannibalization Checker + Decision Tree
Most flagged cannibalization is healthy overlap. Find the real cases in Search Console: position, time, intent — then the right fix.
13Season 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.
14Brand Regex Starter Kit
Split brand from non-brand, catch the misspellings, report non-brand as your SEO number. Regex templates + Python script + checklist.
15GA4 Bot-Filter Checklist
Hostname first, bot patterns in clusters, GA4 against Search Console. One printable page.
16Traffic Drop Diagnostic Checklist
Six steps, always in the same order, and a one-line diagnosis template. One printable page.
17Crawl > 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.
18Search Volume Sanity Checklist
Source, time window, grouping, location, rounding: five checks before you trust a volume. One printable page.
19Zero-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.
20Singular 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.
21Intent 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.
22Keyword Value Score Sheet
Rank keywords by money, not just volume: volume x your own CTR x CPC, sorted into three tiers. Excel sheet.
23Keyword 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 A · Foundations
The 3-part method, the data you need, and a working setup: Search Console, GA4, DataForSEO and Claude Code.
- 01The SEO Analysis Framework: Traffic, SERP, Gap (the 3-part method)free download
- 02What Data You Actually Need (and what it costs)free download
- 03DataForSEO From Zero: Account, API, First Callfree download
- 04Google Search Console API: Pull Your Own Datafree download
- 05GA4 + GSC + DataForSEO: One Data Modelfree download
- 06Set Up Your SEO Analysis Workspace (Python + SQLite + Claude Code)free download
- 07DataForSEO + Claude Code: Your First Analysis in Ten Minutesfree download
Module B · Search Traffic Analysis
Read your own traffic properly: page vs query data, striking distance, CTR, cannibalization, drops and bots.
- 08How to Read Search Console Properly (clicks, impressions, CTR, position)free download
- 09Why Query Reports Lie: Page-Level vs Query-Level Datafree download
- 10Find Pages Stuck on Page 2 (Striking Distance)free download
- 11CTR Underperformers: Which Titles to Rewritefree download
- 12Keyword Cannibalization: Detect and Fixfree download
- 13Seasonality and Trend Analysis for Organic Trafficfree download
- 14Branded vs Non-Branded Trafficfree download
- 15Is Your Traffic Real? Filtering Bots in GA4free download
- 16Explaining a Traffic Drop: A Diagnostic Checklistfree download
- 17Crawl vs Index vs Rank: Reading Crawl and Index Signalsfree download
Module C · Demand and Keyword Research
Where search volume comes from, why “0” lies, intent at scale, clustering and money keywords.
- 18Search Volume Explained: Where the Numbers Come Fromfree download
- 19Why "0 Volume" Doesn't Mean No Demandfree download
- 20Singular vs Plural: The Mistake That Ruins Datasetsfree download
- 21Keyword Intent Classification at Scalefree download
- 22CPC and Commercial Value: Ranking Keywords by Moneyfree download
- 23Keyword Ideas and Related Terms With the DataForSEO APIfree download
- 24Clustering Keywords by SERP Overlapcoming soon
- 25Break Down Head Terms Into Buying Phrasescoming soon
Module D · SERP Analysis
What Google actually shows: features, who ranks, intent from the SERP, difficulty and weak-SERP hunting.
- 26How to Do SERP Analysis, Step by Stepcoming soon
- 27Live SERP API: Get Real Results Programmaticallycoming soon
- 28Reading SERP Features (PAA, snippets, local pack, AI Overviews)coming soon
- 29Classify Who Ranks: Forums, Brands, Niche Sites, Aggregatorscoming soon
- 30Search Intent From the SERP (not from guessing)coming soon
- 31Estimating Keyword Difficulty Yourselfcoming soon
- 32Weak-SERP Hunting: Spot Winnable Keywordscoming soon
- 33SERP Volatility and Freshness Signalscoming soon
- 34Mobile vs Desktop vs Location SERPscoming soon
- 35SERP Gates: Validate Before You Buildcoming soon
- 36Competitor SERP Analysis: Who Really Ranks — and Which Competitors to Pickcoming soon
Module E · Gap Analysis
What competitors get that you don't — keywords, page types, internal links and authority — sized and prioritized.
- 37Gap Analysis Explained: Content, Page-Type, Structural Gapscoming soon
- 38Ranked Keywords Export: What Your Competitors Rank Forcoming soon
- 39Keyword Gap: What They Have and You Don'tcoming soon
- 40Missing Page Types: Gaps Keywords Can't Showcoming soon
- 41Internal Linking Gap: Breadth vs Depthcoming soon
- 42Backlink and Authority Gap (Light Version)coming soon
- 43Sizing the Gap: Volume * Winnability * Valuecoming soon
- 44Prioritization Framework: What to Build Firstcoming soon
- 45Write the Gap Analysis Report (Template)coming soon
- 46Re-Measure After Shipping: Did the Fix Work?coming soon
Module F · Putting It Together
A full analysis on a real site, automated with Claude Code, monitored monthly.
- 47Full SEO Analysis on a Real Site, Start to Finishcoming soon
- 48Automate the Whole Analysis With Claude Codecoming soon
- 49Monthly Monitoring Dashboardcoming soon
- 50Lessons Learned: 10 Mistakes in SEO Data Analysiscoming soon