Tabellab

SEO analytics courses: keywords, technical audits and traffic forecasts

SEO decisions often rest on guesses about traffic and rankings.

SEO & Search Analytics courses (8)

$9.90Intermediate

SEO Forecasting & Business Cases: CTR Curves, Rank-Gain Scenarios, Seasonality, Time to Rank, Revenue Forecasts & Payback vs Paid Search

Turn SEO ideas into a forecast you can defend. You will look up the expected CTR for each position, build your own curve from search data, size rank-gain scenarios, interpolate fractional positions, adjust for results-page features, separate brand from non-brand queries, build a seasonality index and a seasonal run-rate, fit the baseline without the project, model the time to rank with ramp-up curves, weight gains by the chance of success, compare conservative, base and optimistic scenarios, convert clicks into orders, revenue and gross profit, plan the investment, find the payback month and ROI, compare SEO with paid search, run a sensitivity grid, back-test the forecast against actuals and finish with a 24-month business case, in 20 hands-on labs, fictional data, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

SEO Analytics & Keyword Research Math

Prioritise keywords, estimate traffic from a CTR curve, forecast ranking gains, score content gaps, analyse search performance exports, find striking-distance queries and work out SEO ROI, then go further in 20 hands-on labs: keyword clusters, cannibalisation, click bridges, seasonality, your own CTR curve, share of voice, rank volatility, crawl and page-experience audits, branded vs non-branded growth, forecast scenarios and a final dashboard, with every cell checked instantly.

20 lessons · 20 labs

$9.90Intermediate

E-commerce SEO: Category vs Product Page Traffic, Faceted Navigation & Index Bloat, Out-of-Stock Pages, Structured Data & Revenue per Landing Page

Find out which organic pages really earn money in an online shop. You will compare category, product, blog and brand landing pages by conversion and revenue per session, rank pages and measure revenue concentration, match search intent to page type, size the CTR gap to position three, count the URLs that faceted navigation can create, classify crawl-log URLs, measure index bloat, set indexation rules for filter pages and audit canonical, noindex and robots.txt signals, then price out-of-stock pages, decide between keep, redirect and remove, model stock-out duration, audit structured data coverage and run a rich-result what-if grid, check internal links to categories and reallocate them, test click depth, measure a content test against a control group, forecast seasonal revenue and finish with a priority scorecard: 20 hands-on labs, fictional data, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

International SEO & Localisation: Market Prioritisation, Language & Country Coverage, Translation Cost vs Traffic, Local Keyword Demand & Market-Level Conversion

Decide where to localise a website and what it pays back. You will size the search demand of ten markets with demand share, capture rate and visit gap, score and rank markets with weights, compare language and country targeting, measure localised-page coverage, estimate translation cost per language and turn keyword volume into potential visits and orders. You then combine cost and traffic into payback, compare literal translations with the terms people really search for, build a keyword cluster grid, calculate a visibility index, compare conversion and revenue per session by market, price the wrong-language landing, audit hreflang annotations, plan a rollout within a budget, forecast the ramp-up, run a what-if grid, test human edit against machine translation, sample translation quality, report net revenue in euros without VAT and finish with a market scorecard: 20 hands-on labs, fictional Lindenmoor Home data, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

SEO Topic Clusters & Content Briefs: Keyword Clustering, Search Intent, Pillar Pages, Cannibalisation Checks, Opportunity Scores & Word Budgets

Turn a raw keyword list into a content plan you can defend. You will group keywords into topic clusters and size their demand, label search intent from modifiers, compare simple and search-weighted difficulty, estimate click potential with a position CTR curve and assign pillar and supporting pages. Then you find cannibalised queries and choose a primary URL, rank clusters with an opportunity score and a weighted scoring model, measure content gaps, set brief word budgets from the top results, split them across sections, schedule writers with WORKDAY, forecast cluster traffic, model ramp-up and payback, audit internal links, build a what-if grid, review decaying pages, score drafts against their briefs and finish with a cluster roadmap. 20 hands-on labs, fictional garden retailer Mossgate Garden Supply, every cell checked as you go.

20 lessons · 20 labs

$9.90Beginner

Local SEO & Google Business Profile: Profile Insights, Local Rank Grids, Citations, Review Velocity & Local Lead Value

Measure local search the way a branch manager needs it. You will turn Business Profile views, calls, direction requests and website clicks into action rates, split views by Search and Maps, separate brand from discovery searches, find missed calls and price a profile action. Then you summarise local rank grids, check name, address and phone consistency across listings, track review velocity, replies and review requests, set realistic rating targets, judge service-area pages and travel profit, estimate clicks from keyword ranks, compare grids before and after, plan a citation clean-up, score profile completeness, forecast calls, build a what-if grid and finish with a branch scorecard. 20 hands-on labs, fictional home-services company Brindlewick Plumbing & Heating, every cell checked as you go.

20 lessons · 20 labs

$9.90Advanced

SEO for Site Migrations & Redesigns: URL Mapping, Redirect Coverage, Traffic at Risk, Benchmarks, Recovery Curves & Rollback Thresholds

Protect organic traffic through a site migration or redesign. You build a URL map and measure redirect coverage by URLs and by sessions, size the traffic at risk for each redirect type, freeze pre-launch benchmarks, audit redirect chains and dead ends, value backlinks, rank the work by revenue at risk, translate keyword positions into clicks and run a staging launch gate. After launch you monitor errors hour by hour, track the handover in the index, measure the gap against the benchmark, fit recovery curves, test whether a drop is real, diagnose segments, split lost revenue into traffic and conversion, set rollback thresholds, plan phased waves, build a scenario grid, prioritise the fix backlog and finish with a migration scorecard: 20 hands-on labs, fictional data, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Technical SEO Site Audits: Crawl Budget, Index Coverage, Redirect Chains, Canonicals, Core Web Vitals & Server Logs

Audit a website the way a technical SEO does, in 20 hands-on spreadsheet labs. You will turn a crawl export into an inventory of indexable URLs, read the status code mix, find redirect chains and the requests they waste, check canonical tags and duplicate clusters, measure index coverage per sitemap, compare crawl share with click share, judge Core Web Vitals per template and analyse click depth. Then you go deeper: bot traffic from server logs, orphan pages, a priority score for the findings, a trend forecast for the vitals, crawl freshness, URL parameters, internal links against revenue, the redirect map of a migration, sample audits with confidence bounds, a what-if grid for crawl budget and a weighted health score, finishing with a scorecard by section. 20 hands-on labs, a fictional online shop, illustrative thresholds, every cell checked as you go.

20 lessons · 20 labs

SEO decisions often rest on guesses about traffic and rankings. These courses replace the guesswork with spreadsheet methods: scoring keywords, mapping topic clusters and search intent, reading crawl and index data in a technical audit, planning URL redirects for a migration, and forecasting the traffic a ranking improvement could bring. Local, international and e-commerce SEO each get their own course, so you can pick the one that matches the site you work on.

This topic hub gathers 8 SEO & Search Analytics courses from Marketing: 1 beginner, 6 intermediate, 1 advanced. Most courses have about 20 hands-on labs, a final exam and a certificate, and the first lesson of every course is free. Searches this hub is built for: seo analytics excel; keyword research spreadsheet; technical seo audit checklist; seo forecast template.

Frequently asked questions

Which SEO & Search Analytics course should I start with?

Start with “SEO Analytics & Keyword Research Math”. It is the most central course in this topic at intermediate level. Then move on to the more specialised courses in the list above.

How much do the SEO & Search Analytics courses cost?

Every course costs a one-time $9.90, with no subscription, and the first lesson of each course is free so you can try it before buying. Each course ends with a final exam and a certificate.

How are the SEO & Search Analytics courses taught?

Each course is a series of hands-on labs in a built-in spreadsheet that checks your formulas as you type, with short explanations alongside. You need only a web browser; nothing to install. Examples use fictional data and are for learning, not professional advice.

Open your first lab in under a minute

Pick a course, pay once and start right away. Your progress is saved in your account.

Browse the courses