Worksheets

Copy each worksheet into your spreadsheet program or notebook. They are the method from Chapters 2–10 in fill-in form.

Worksheet 1: The Keyword Map (Chapters 2–4)

One row per intent. This single document is your research record, your site plan, and your work queue.

(The three rows above are the worked example from Chapters 2–4, shown so you can copy the pattern. Replace them with your own.)

Rules taped to the top of the sheet: - One intent = one owning URL. Two rows may never share an owning URL with the same intent. - Counts are estimates. Thresholds are heuristics. Eyes on the actual top 10 decide. - Delete what you don't sell. No path to a product = no row.

Change log (Chapter 9): add a Notes column per row — date, change made, reason. Your future self, reading month-4 results, will thank you.

Worksheet 2: The allintitle Validation Log (Chapter 3)

Use one block per serious candidate keyword, before classifying it.

Keyword: ______________________________________
Volume (est.): ____________   CPC: ____________
allintitle: count: __________  Date checked: ____________
  (Under 50 = green zone · 50–100 = yellow zone · Over 100 = deliberate competition)

WINNING FORMULA — inspect the actual top 10:
[ ] Signal 1: A small / low-authority site sits in the top 5.  Which? ______________
[ ] Signal 2: Irrelevant or loosely-matching results are ranking.  Which positions? ______
[ ] Signal 3: Old / stale pages are holding positions.  Which? ______________
[ ] Signal 4: allintitle count is low (above).

Signals scored: ____ / 4
Classification:  [ ] Priority (3–4 signals)   [ ] Maybe (2 signals)   [ ] Parked (0–1)
Owning page (from Worksheet 1): ______________________________

Worksheet 3: Page Optimization Checklist (Chapters 6–7)

Run once per page — priority categories first, then top products, then the rest in batches. All boxes checked = the page is "done" and enters the measurement loop.

Targeting - [ ] Page owns exactly one intent on the keyword map; primary keyword recorded - [ ] No other page on the site targets the same intent

Content coverage (Chapter 6) - [ ] Subtopic list built from: top-ranking outlines + Wikipedia contents + marketplace attributes + customer questions - [ ] Every major subtopic covered; at least one competitor gap deliberately filled - [ ] Shopping layer (grid/prices/filters) unobstructed; guidance layer complete below it - [ ] Product description is unique — written by/for this store, not manufacturer text - [ ] Every factual claim (specs, materials, measurements) verified against the real product - [ ] Length sanity check: far under ~1,500 words (category) / ~1,000 (product)? → ask "what coverage is missing?" and add coverage, not filler

On-page elements (Chapter 7) - [ ] Title tag: unique, keyword-led, natural, ~50–60 characters of substance - [ ] Meta description: unique, written as an ad (offer + differentiator + reason to click) - [ ] Exactly one H1; H2s match the subtopic outline - [ ] Images: descriptive file names, honest alt text, compressed (WebP where possible) - [ ] Reviews: displayed on the page; post-purchase request flow active; zero fabricated reviews - [ ] Schema: Product (+ price/availability/rating) and BreadcrumbList validated in Google's Rich Results Test; schema matches what's visibly on the page - [ ] FAQ section (where genuine) with FAQPage schema

Structure & links (Chapter 5) - [ ] URL: short, readable, keyword-bearing, stable - [ ] Reachable within 3 clicks of the homepage; breadcrumb shows primary category - [ ] Links up to hub, down/across to clusters; linked FROM at least one relevant page with descriptive anchor text

Technical spot-checks (Chapter 8) - [ ] Page indexed (URL Inspection: "Indexing allowed — Yes") - [ ] Canonical points to this page's clean URL - [ ] Loads acceptably on a real phone (PageSpeed Insights checked for the template)

Worksheet 4: The 30 / 60 / 90-Day Plan (Chapter 10)

Days 1–30 — Research and foundation - [ ] Search Console verified; sitemap submitted (Ch. 1, 8) - [ ] Master keyword list built: Amazon → Google related searches → Wikipedia contents (Ch. 2) - [ ] Every keyword deleted that isn't sold here (Ch. 2) - [ ] allintitle counts + Winning Formula scores recorded; Priority/Maybe/Parked sorted (Ch. 3) - [ ] Keyword map complete — one intent, one page (Ch. 4) - [ ] Structure audit done: hierarchy, URLs, breadcrumbs, navigation (Ch. 5) - [ ] Technical day-one checklist passed: indexing, robots.txt, canonicals, 404s, speed (Ch. 8)

Days 31–60 — Build - [ ] Priority category pages rebuilt: coverage content + all Worksheet 3 boxes (Ch. 6–7) - [ ] Top product pages optimized; review requests on (Ch. 7) - [ ] First 1–2 guides published and internally linked (Ch. 5–6) - [ ] Foundational links done: profiles, citations, supplier/brand listings (Ch. 10)

Days 61–90 — Measure and improve - [ ] First monthly Search Console review held (Ch. 9) - [ ] Near-miss list (positions 8–20) built; top 3 improvements shipped (Ch. 9) - [ ] First content audit slice: one category, four verdicts, redirects placed (Ch. 9) - [ ] First Stage 2 link push toward a performing page (Ch. 10) - [ ] Change log reviewed; next month's queue written (Ch. 9)

Monthly, forever after: Search Console review → near-miss fixes → one audit slice → one link push → change log. That loop is the strategy.

Worksheet 5: The Monthly Scorecard (Chapter 9)

Fill in on the same day each month. Judge trends over quarters, not weeks.

The three questions that matter: 1. Are impressions trending up over the quarter? (The earliest honest success signal.) 2. Is the near-miss list shrinking because pages moved up — or because I stopped looking? 3. What are next month's top 3 improvements?

Print / save as PDF