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.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This intermediate course teaches technical SEO site audits through the numbers behind them. In 20 interactive spreadsheet labs you audit Quillmere Outdoor, a fictional online shop for hiking and camping gear with about 41,000 URLs. You build an inventory of indexable URLs from a crawl export, count status codes with COUNTIFS, label redirect chains, check canonical tags and duplicate clusters, measure index coverage per sitemap and compare where Googlebot spends its requests with where the organic clicks come from. You judge Core Web Vitals per template, analyse click depth, summarise server logs, find orphan pages, rank the findings with a priority score, forecast a trend, test a migration redirect map, put confidence bounds on a sample audit and finish with a weighted health score and a scorecard with a chart. Every formula is checked instantly. All companies, URLs and figures are fictional, and platform thresholds are illustrative.
Lessons
- The Audit Inventory: Crawled URLs per Site Section, Indexable URLs, Indexable Share and Where the Non-Indexable URLs SitFree
- Status Codes: Class per URL, URLs and Shares per Class with COUNTIFS, Internal Links into Errors and a Chart Locked
- Redirect Chains: Hops, Chain and Broken Labels with IFS, Requests per Month and the Requests a Clean-Up Saves Locked
- Duplicates & Canonical Tags: Self or Other, Issue Labels with IFS, Cluster Size with COUNTIF and a Highlight Rule Locked
- Index Coverage: Coverage Rate per Sitemap, the Not-Indexed Gap, Each Sitemap's Share of the Gap and a Sorted Chart Locked
- Crawl Budget: Crawl Share vs Click Share per Section, Requests per URL, Over-Crawled Sections and Requests Without Value Locked
- Core Web Vitals: Failing Metrics per Template, Pass or Fail with AND, Passing Templates and the Pageview-Weighted Pass Rate Locked
- Internal Link Depth: Share of URLs per Click Depth, Cumulative Share, Average Depth and the URLs and Clicks Beyond the Limit Locked
- Server Logs: Requests per Day and per Bot with SUMIFS, the Non-200 Share of a Day, Weighted Response Time and a Trend Chart Locked
- Orphan Pages: Reconciling Crawl, Sitemap and Logs with IFS, COUNTIFS and SUMIFS, Clicks at Stake and Wasted Bot Hits Locked
- Prioritising Audit Findings: Severity Weights with XLOOKUP, a Priority Score, RANK.EQ, Developer Days and a Top-3 Rule Locked
- Core Web Vitals Trend: Weekly Good-URL Share, SLOPE, FORECAST.LINEAR, the Week the Target Is Reached and a Line Chart Locked
- Crawl Freshness: Days Since the Last Googlebot Visit, Changed-Since-Crawl Flags, AVERAGEIFS per Section and Overdue URLs Locked
- URL Parameters & Facets: Clicks per 1,000 Requests, Block-Review-Keep Decisions with IFS and the Crawl Requests to Win Back Locked
- Internal Links & Performance: CORREL of Inlinks and Clicks, Medians, Under-Linked Money Pages and a Scatter Chart Locked
- Migration QA: Checking a Redirect Map with XLOOKUP, Verdicts with IFS, Clicks at Risk and the Share Safely Redirected Locked
- Sample Audits: Error Rate, Standard Error, the Lower 95 % Bound, Projected Errors per Site and a Tolerance Rule Locked
- What-If Grid: Days for One Full Pass over the Catalogue by Waste Removed and Share Re-Spent, with Mixed References and a Heat Map Locked
- Audit Health Score: Scoring Checks Against Targets, a Weighted Total, Scores per Area, the Weakest Area and a Chart Locked
- Final Project: Audit Scorecard by Section for a Report Month with Indexable Share, Error Rate, Good-Vitals Share, Flags and a Chart Locked
Learner reviews
Be the first to review this course.