Fictora Labs · SEO + GEO
Episodes 03 & 04 · Keyword Research

Keyword Research Starts With Intent

EP03 & 04 is one keyword research workflow. It starts from the site tree and page structures, collects DataForSEO keyword evidence, maps intent, groups keyword buckets, and highlights early wins.

Copy EP03 & 04 Script Make a Copy of the Sheet Review Workflow
Input
Site tree + page briefs

The workflow uses EP01 and EP02 as planning context instead of dumping unrelated keyword rows.

Output
Intent map + buckets

The final tabs show which keyword groups matter, which page should target them, and what to build first.

Workflow

One keyword research page for EP03 & 04

1 · Create the setup tabs

Run the setup function. The script creates a setup tab, seed keyword tab, raw inventory tab, intent map, keyword buckets, and API log.

Sheet setup

2 · Add DataForSEO credentials

Add the DataForSEO login and API password inside the setup tab of your own copied Google Sheet. Leave the public template blank.

Private credentials

3 · Import seeds from EP01 and EP02

The seed tab pulls planned pages from the site tree and page structure work, then lets you add manual service, location, and topic seeds.

Targeted inputs

4 · Collect keyword evidence

Use DataForSEO keyword ideas, suggestions, and related keywords. The inventory tab keeps raw evidence, but deduplicates repeated rows.

API collection

5 · Detect and review intent

The script enriches keyword intent with DataForSEO, then uses rule-based fallbacks so every keyword can be reviewed with a final intent.

Intent mapping

6 · Build keyword buckets

Keywords are grouped by mapped page, page type, and intent. The final bucket view shows priority, primary keyword, support keywords, and early-win score.

Strategy output
Apps Script

EP03 & 04 setup script

Setup steps

  • Complete EP01 and EP02 in your copied Google Sheet first.
  • Copy the Apps Script code below.
  • Open your copied Google Sheet. Apps Script works only inside a native Google Sheet, not inside Excel .xlsx mode.
  • Go to Extensions > Apps Script.
  • Paste this code below the EP01 and EP02 code, or paste it into the same Apps Script project.
  • Click Run for the function named setupEP0304.
  • Return to the Google Sheet and refresh the browser tab.
  • Open EP03 & 04 SETUP and add the DataForSEO login and API password.
  • Use SEO/GEO Series > EP03 & 04: Import Seeds from EP01/EP02.
  • Review and edit EP03 & 04 SEED KEYWORDS.
  • Use EP03 & 04: Collect DataForSEO Keywords.
  • Use EP03 & 04: Detect Intent with DataForSEO.
  • Use EP03 & 04: Build Intent Map.
  • Use EP03 & 04: Build Keyword Buckets.

What the script creates

EP03 & 04 SETUP

EP03 & 04 SEED KEYWORDS

EP03 & 04 KEYWORD INVENTORY

EP03 & 04 INTENT MAP

EP03 & 04 KEYWORD BUCKETS

EP03 & 04 API LOG

Credential rule

Credentials are read from the setup tab in the user's own copied sheet. Do not add API login details to the public template.

Copy this Apps Script

Loading EP03 & 04 Apps Script...
Sheet views

Separate evidence from strategy

Seed keywords

Targeted inputs from EP01/EP02 plus manual seeds. This keeps the run focused on planned pages instead of every sitemap URL.

Keyword inventory

Raw DataForSEO keyword evidence with volume, CPC, competition, difficulty, source seed, endpoint, and mapped page context.

Intent map

Clean keyword rows with final intent, funnel stage, recommended page type, business fit, early-win score, and recommendation.

Keyword buckets

The final planning view: bucket name, mapped page, primary keyword, supporting keywords, total volume, difficulty, priority, and notes.

Intent classes

How keywords are classified

Informational

The user wants to learn, understand, or solve a problem. Usually maps to guides, explainers, FAQ pages, and educational content.

Commercial

The user is comparing options, agencies, services, prices, or solutions. Usually maps to service pages, comparison pages, or buying guides.

Transactional

The user is close to taking action. Usually maps to quote pages, booking pages, service pages, or conversion-focused location pages.

Navigational

The user is looking for a known brand, company, tool, person, or website. Usually becomes a brand note, competitor input, or exclusion.