Tabellab

Redirect Chains: Hops, Chain and Broken Labels with IFS, Requests per Month and the Requests a Clean-Up Saves

Lesson 3 of 20 Lab 🔒 Locked

Lessons in this course

  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