🔮$9.90Intermediate
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
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
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
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
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
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
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
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