Tabellab
Marketing Analytics Intermediate

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.

20 lessons 20 labs Certificate

  • 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

  1. Building a Content Inventory: One Row per URL, Content Age, Stale Pages and Pages per Content TypeLabFree
  2. Traffic and Conversion per URL: Conversion Rate, Revenue per Session, Share of Traffic and the Weighted Site RateLab Locked
  3. Cleaning the Inventory: Query Parameters, Variant Rows, Page-Level Sessions and Duplicate HighlightingLab Locked
  4. Traffic Trends per URL: Last 3 vs Prior 3 Months, Slope per Month, Declining and Growing Labels and a Monthly LineLab Locked
  5. Keep, Update, Merge or Remove: Threshold Table, Rule Order with IFS and Counts of Each OutcomeLab Locked
  6. Thin Content: Minimum Words per Page Type, Thin Flags, Average Length per Type, Correlation with Traffic and a Scatter ChartLab Locked
  7. Overlapping Pages: URLs per Query, Primary URL with MAXIFS, Click Share and Counting Cannibalised QueriesLab Locked
  8. Merge Plan: Group Sessions, Target Selection, Redirect Map and Expected Sessions After a MergeLab Locked
  9. URL Value Score: Indexing Three Signals, Weighted Score, Rank, Core/Support/Low Bands and Revenue ConcentrationLab Locked
  10. Protecting Backlinks When Retiring Pages: Redirect or 410 Rule, Authority Given Up and a Risk HighlightLab Locked
  11. Update Backlog Sizing: Hours per Page from Words and Update Level, Hours per Level and Months to Clear the BacklogLab Locked
  12. Prioritising Updates: Expected Extra Sessions, Gain per Hour, Rank, Cumulative Hours and a Sprint Cut-OffLab Locked
  13. Pruning Impact Tracking: Like-for-Like Sessions, Before and After Averages, Change % and a Two-Line ChartLab Locked
  14. Control Groups for Prune and Merge Results: Change per URL, Group Change, Difference in Percentage Points and a Column ChartLab Locked
  15. Redirect and Status QA After a Prune: Check Labels, Broken Targets, Problem Counts, Chain Share and a Problem HighlightLab Locked
  16. Did the Updates Work? Change per Page, Mean Change, Paired T-Test, Significance Verdict and a Confidence IntervalLab Locked
  17. Content Decay: Linear Forecast, Months Until a Sessions Floor, Priority Labels and an Actual-vs-Forecast ChartLab Locked
  18. What-If Grid for the Audit: Share Updated vs Uplift, Net Sessions, Break-Even Uplift, Annual Value and Loss ScenariosLab Locked
  19. Inventory Quality Checks: Source Counts, Issue Labels, Missing from the Sitemap, Session Reconciliation and an Incomplete-Row HighlightLab Locked
  20. Final Project: Content Audit Scorecard with Pages, Sessions and Hours per Decision, Projected Change, Net Effect 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