Tabellab
Marketing Analytics Intermediate

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 Certificate

  • 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

  1. The Audit Inventory: Crawled URLs per Site Section, Indexable URLs, Indexable Share and Where the Non-Indexable URLs SitLabFree
  2. Status Codes: Class per URL, URLs and Shares per Class with COUNTIFS, Internal Links into Errors and a ChartLab Locked
  3. Redirect Chains: Hops, Chain and Broken Labels with IFS, Requests per Month and the Requests a Clean-Up SavesLab Locked
  4. Duplicates & Canonical Tags: Self or Other, Issue Labels with IFS, Cluster Size with COUNTIF and a Highlight RuleLab Locked
  5. Index Coverage: Coverage Rate per Sitemap, the Not-Indexed Gap, Each Sitemap's Share of the Gap and a Sorted ChartLab Locked
  6. Crawl Budget: Crawl Share vs Click Share per Section, Requests per URL, Over-Crawled Sections and Requests Without ValueLab Locked
  7. Core Web Vitals: Failing Metrics per Template, Pass or Fail with AND, Passing Templates and the Pageview-Weighted Pass RateLab Locked
  8. Internal Link Depth: Share of URLs per Click Depth, Cumulative Share, Average Depth and the URLs and Clicks Beyond the LimitLab Locked
  9. Server Logs: Requests per Day and per Bot with SUMIFS, the Non-200 Share of a Day, Weighted Response Time and a Trend ChartLab Locked
  10. Orphan Pages: Reconciling Crawl, Sitemap and Logs with IFS, COUNTIFS and SUMIFS, Clicks at Stake and Wasted Bot HitsLab Locked
  11. Prioritising Audit Findings: Severity Weights with XLOOKUP, a Priority Score, RANK.EQ, Developer Days and a Top-3 RuleLab Locked
  12. Core Web Vitals Trend: Weekly Good-URL Share, SLOPE, FORECAST.LINEAR, the Week the Target Is Reached and a Line ChartLab Locked
  13. Crawl Freshness: Days Since the Last Googlebot Visit, Changed-Since-Crawl Flags, AVERAGEIFS per Section and Overdue URLsLab Locked
  14. URL Parameters & Facets: Clicks per 1,000 Requests, Block-Review-Keep Decisions with IFS and the Crawl Requests to Win BackLab Locked
  15. Internal Links & Performance: CORREL of Inlinks and Clicks, Medians, Under-Linked Money Pages and a Scatter ChartLab Locked
  16. Migration QA: Checking a Redirect Map with XLOOKUP, Verdicts with IFS, Clicks at Risk and the Share Safely RedirectedLab Locked
  17. Sample Audits: Error Rate, Standard Error, the Lower 95 % Bound, Projected Errors per Site and a Tolerance RuleLab Locked
  18. What-If Grid: Days for One Full Pass over the Catalogue by Waste Removed and Share Re-Spent, with Mixed References and a Heat MapLab Locked
  19. Audit Health Score: Scoring Checks Against Targets, a Weighted Total, Scores per Area, the Weakest Area and a ChartLab Locked
  20. Final Project: Audit Scorecard by Section for a Report Month with Indexable Share, Error Rate, Good-Vitals Share, Flags and a ChartLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy