Tabellab

Traffic and Conversion per URL: Conversion Rate, Revenue per Session, Share of Traffic and the Weighted Site Rate

Lesson 2 of 20 Lab 🔒 Locked

Lessons in this course

  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