FreeA spreadsheetAbout 30 min
Map Keywords to URLs
Assign one primary keyword to each target page. This map becomes the plan for the next two modules. Any time you wonder what a page should target, the answer is in this sheet.
Why This Matters
One keyword per page stops your own pages from competing with each other (called cannibalization). It also makes every later choice obvious. If two pages chase one term, Google may swap between them and neither one holds a good spot.
✓ How To Do It
- Create a column mapping each priority keyword to a single URL.
- Check GSC for the page that already gets impressions for that term. Use that page before you think about a new one.
- If two keywords are almost the same, put them on one page. Search both. If the same pages rank for each, they belong together.
- Flag keywords with no matching page. Those become new pages.
- Scan the URL column for repeats. A URL can have close variations, but only one primary keyword.
- This sheet drives the whole On-Page phase, so keep it up to date as you add pages.
Done WhenEvery priority keyword maps to exactly one URL, and keywords with no page are flagged.
Tools For This StepGoogle Sheets
From the field. New York Intelligence Agency, New York City
For New York Intelligence Agency every page has one job. A case type (matrimonial, corporate, surveillance, background checks, missing persons) is paired with one place. That gave us 600+ pages across the 5 boroughs, Long Island and Westchester, and each page targets its own search.

Tips & Pitfalls
- Your home page shouldn't target everything. Give it your broadest term, and let service pages carry the rest.
- If two of your pages already compete, keep the stronger one, merge the content, and redirect the other.
- A page can rank for many related terms. The primary keyword only tells you where to aim.
Email Me The Free Course
Get your course link in your inbox so you can pick it up on any device. It's free, with no card.