Status Codes: Class per URL, URLs and Shares per Class with COUNTIFS, Internal Links into Errors and a Chart
Lessons in this course
- 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