EP01 · Site Structure
Search the main keyword in incognito, list the top-ranking companies, visit each website, and understand what pages the website should have.
This series explains SEO and GEO one reel at a time. EP01, EP02, and the EP03 & 04 keyword research workflow are live now. Start with site structure, build page structures, then map keywords, intent, and early wins.
The live workflow covers site structure, page structure, DataForSEO keyword collection, intent mapping, and keyword buckets.
The next full sheet task will be published here after the EP03 & 04 script and later episode plans are ready.
Make a copy of the main template once. Future episode pages will explain how to update the same copied sheet.
Each reel introduces one SEO/GEO concept and explains why that step matters.
Each episode page contains the concept explanation, task steps, sheet instructions, and Apps Script code when automation is needed.
Use the main template copy as the working file. Open the tab mentioned in the episode page and complete only that episode's task.
When a new reel needs a new tab or automation, paste the Apps Script from that episode page into the same copied sheet and run the given steps.
Make one copy of the main SEO/GEO template sheet. This copied file becomes the working sheet for the whole series. The template is a native Google Sheet, so Apps Script can be used inside it.
Read the episode page before working on the sheet. The page explains the concept, what to fill, what script to paste, and what output to expect.
Search the main keyword in incognito, list the top-ranking companies, visit each website, and understand what pages the website should have.
Import target pages from the EP01 tree, add positioning, scrape competitor content, and generate a clean section brief for each selected page.
Create setup, seed, inventory, intent map, and keyword bucket tabs for the combined DataForSEO keyword research workflow.
The next task will be defined after the EP03 & 04 keyword research sheet and script are complete.
The main template sheet is copied once and used throughout the series.
The sheet is for doing the work. The episode page explains what to do, why it matters, and how to make the tab work.
When an episode needs automation, the Apps Script code and setup steps will be shared on that episode page. Apps Script works only inside a native Google Sheet, not inside Excel .xlsx mode.
When API credentials are needed, enter them only inside your own copied sheet or Apps Script setup. Never enter private credentials into a public template.