Tabellab
Marketing Analytics Intermediate

E-commerce SEO: Category vs Product Page Traffic, Faceted Navigation & Index Bloat, Out-of-Stock Pages, Structured Data & Revenue per Landing Page

Find out which organic pages really earn money in an online shop. You will compare category, product, blog and brand landing pages by conversion and revenue per session, rank pages and measure revenue concentration, match search intent to page type, size the CTR gap to position three, count the URLs that faceted navigation can create, classify crawl-log URLs, measure index bloat, set indexation rules for filter pages and audit canonical, noindex and robots.txt signals, then price out-of-stock pages, decide between keep, redirect and remove, model stock-out duration, audit structured data coverage and run a rich-result what-if grid, check internal links to categories and reallocate them, test click depth, measure a content test against a control group, forecast seasonal revenue and finish with a priority 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 e-commerce SEO as a spreadsheet workflow. In 20 interactive labs you work on the organic search data of Larchmont Home, a fictional online homeware shop. You split landing pages by type and compare conversion and revenue per session, rank pages by revenue, match query intent to page type and size the click gap to a better ranking position. You count the URLs that faceted navigation creates, classify a crawl log, measure index bloat and write indexation rules for filter pages, then audit canonical, noindex and robots.txt signals. You price out-of-stock pages, decide between keep, redirect and remove, audit structured data coverage and run a rich-result what-if grid. You check internal links to categories, reallocate them, test click depth, measure a content test against a control group, forecast seasonal revenue and finish with a priority scorecard. Every formula is checked as you type. All companies, pages and numbers are fictional and for illustration 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. Organic Landing Pages by Type: Sessions, Conversion Rate and Revenue per Session for Category, Product, Blog and Brand PagesLabFree
  2. Revenue per Organic Landing Page: Cumulative Share, Ranking by Revenue per Session and the Concentration of Organic RevenueLab Locked
  3. Query Intent and Page Type: Impressions, CTR and Impression-Weighted Position for Generic, Modifier, Product, Brand and Informational SearchesLab Locked
  4. The CTR Curve and the Gap to Position 3: Expected Clicks, Extra Clicks and Extra Revenue for Category PagesLab Locked
  5. Faceted Navigation Arithmetic: How Many URLs One Category Can Create with Single Filters, Pairs and Full CombinationsLab Locked
  6. Reading a Crawl Log Sample: Classifying URLs, Counting Parameters and Measuring Crawl Hits on Parameter URLs and on URLs Without TrafficLab Locked
  7. Index Coverage and Index Bloat: Sitemap vs Indexed vs Active URLs by Template, Zero-Traffic Share and the Sitewide Bloat RatioLab Locked
  8. Which Facet Combinations Deserve an Index? Search Demand, Product Count Thresholds and the Share of Demand CoveredLab Locked
  9. Canonical, Noindex and Robots.txt Audit for Filter URLs: Conflicting Signals, Hidden Directives and Internal Links to URLs That Cannot RankLab Locked
  10. Out-of-Stock Product Pages: Traffic Retained, Sessions Lost and Revenue Not Earned During Stock-OutsLab Locked
  11. What to Do with Unavailable Products: Keep, Redirect or Remove Based on Restock Dates, Backlinks and Organic SessionsLab Locked
  12. Stock-Out Duration and Organic Sessions: SLOPE, INTERCEPT, RSQ and FORECAST.LINEAR for the Traffic Lost per Day Out of StockLab Locked
  13. Structured Data Coverage by Category: Product Markup, Price and Availability, Rating Markup and Pages with ErrorsLab Locked
  14. Rich Result What-If Grid: Rating Markup Coverage × CTR Uplift, Extra Clicks, Extra Gross Profit, Payback and Break-Even UpliftLab Locked
  15. Internal Links to Category Pages: Linking Pages by Source, Revenue per Linking Page and Categories Below a Link FloorLab Locked
  16. Reallocating Internal Links to Category Pages: Revenue-Weighted Targets, Change Needed, Pages to Move and CorrelationLab Locked
  17. Click Depth and Pagination: Crawl Share, Sessions per Page and Revenue Concentration by Depth LevelLab Locked
  18. Testing Category Page Content: Test and Control Groups, Weighted Change, Difference-in-Differences and Incremental SessionsLab Locked
  19. Organic Revenue Forecast: Trend with FORECAST.LINEAR, Seasonal Index by Calendar Month and a 12-Month Seasonal ForecastLab Locked
  20. Final Project: An E-commerce Organic Scorecard with Revenue per Session, Facet Bloat, Schema Gap, Recoverable Revenue and Priority RankLab 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