Content Audits: Inventory, URL Performance, Keep/Update/Merge/Remove Rules, Thin & Overlapping Pages, Pruning Impact & Update Backlog Sizing
Audit and prune a website's content with evidence instead of opinions. You will build a content inventory, calculate content age and stale pages, clean URL variants, add traffic and conversion per URL, read trends, apply ordered keep, update, merge and remove rules, flag thin and overlapping pages, plan merges and redirect maps, score the value of every URL, protect backlinks, size and prioritise the update backlog, measure pruning impact with like-for-like figures, control groups and a paired test, forecast content decay, run what-if grids, check redirects and data sources, and finish with an audit scorecard: 20 hands-on labs, fictional data, every cell checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This course teaches content audits with the practical arithmetic of a spreadsheet in 20 interactive labs. You work for Alderquay Outdoors, a fictional retailer of camping and hiking gear with guides, a blog, category pages and landing pages, and build every table yourself: a content inventory with content age and stale flags, clean URL variants, traffic, conversion and revenue per URL, trends, ordered keep, update, merge and remove rules, thin and overlapping pages, merge plans with redirect maps, URL value scores, backlink protection, the size and priority of the update backlog, pruning impact with like-for-like figures, control groups and a paired t-test, content decay forecasts, what-if grids, redirect checks and a final audit scorecard. Every formula is checked as you type, so you learn by doing. All companies, pages and numbers are fictional and for learning only.
Why learn with Tabellab
- Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
- Verifiable certificatePass the final exam and get a certificate with a public verification code.
- Try before you buyLesson 1 is free, with no sign-up or card needed.
- Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint
Lessons
- 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
Learner reviews
Be the first to review this course.