Inventory Quality Checks: Source Counts, Issue Labels, Missing from the Sitemap, Session Reconciliation and an Incomplete-Row Highlight
Lessons in this course
- Building a Content Inventory: One Row per URL, Content Age, Stale Pages and Pages per Content TypeFree
- Traffic and Conversion per URL: Conversion Rate, Revenue per Session, Share of Traffic and the Weighted Site Rate Locked
- Cleaning the Inventory: Query Parameters, Variant Rows, Page-Level Sessions and Duplicate Highlighting Locked
- Traffic Trends per URL: Last 3 vs Prior 3 Months, Slope per Month, Declining and Growing Labels and a Monthly Line Locked
- Keep, Update, Merge or Remove: Threshold Table, Rule Order with IFS and Counts of Each Outcome Locked
- Thin Content: Minimum Words per Page Type, Thin Flags, Average Length per Type, Correlation with Traffic and a Scatter Chart Locked
- Overlapping Pages: URLs per Query, Primary URL with MAXIFS, Click Share and Counting Cannibalised Queries Locked
- Merge Plan: Group Sessions, Target Selection, Redirect Map and Expected Sessions After a Merge Locked
- URL Value Score: Indexing Three Signals, Weighted Score, Rank, Core/Support/Low Bands and Revenue Concentration Locked
- Protecting Backlinks When Retiring Pages: Redirect or 410 Rule, Authority Given Up and a Risk Highlight Locked
- Update Backlog Sizing: Hours per Page from Words and Update Level, Hours per Level and Months to Clear the Backlog Locked
- Prioritising Updates: Expected Extra Sessions, Gain per Hour, Rank, Cumulative Hours and a Sprint Cut-Off Locked
- Pruning Impact Tracking: Like-for-Like Sessions, Before and After Averages, Change % and a Two-Line Chart Locked
- Control Groups for Prune and Merge Results: Change per URL, Group Change, Difference in Percentage Points and a Column Chart Locked
- Redirect and Status QA After a Prune: Check Labels, Broken Targets, Problem Counts, Chain Share and a Problem Highlight Locked
- Did the Updates Work? Change per Page, Mean Change, Paired T-Test, Significance Verdict and a Confidence Interval Locked
- Content Decay: Linear Forecast, Months Until a Sessions Floor, Priority Labels and an Actual-vs-Forecast Chart Locked
- What-If Grid for the Audit: Share Updated vs Uplift, Net Sessions, Break-Even Uplift, Annual Value and Loss Scenarios Locked
- Inventory Quality Checks: Source Counts, Issue Labels, Missing from the Sitemap, Session Reconciliation and an Incomplete-Row Highlight Locked
- Final Project: Content Audit Scorecard with Pages, Sessions and Hours per Decision, Projected Change, Net Effect and a Chart Locked