SEO + GEO content opportunity workbook
Decide what to create, refresh or skip — for search results and AI answers — from evidence, not keyword lists.
This free workbook turns scattered search, audience, competitor, existing-content and AI-visibility signals into a prioritised content queue, with a clear decision and handoff for each opportunity.
9 worksheets · 6 signal types · No paid SEO tools required
The problem
Search changed. Most content plans didn’t.
People now get answers from search results and from AI. Most plans still start from a keyword export, and treat every query as its own page.
A keyword list mistaken for a strategy
One page for every wording of the same question
High volume chosen over real business value
An AI citation counted as if it were traffic
Ideas from a chatbot treated as evidence
Definition
What is a content opportunity?
A meaningful user need or content job that may justify creating, improving, consolidating, repositioning, monitoring or rejecting content.
One opportunity usually covers many keyword variations. A GEO opportunity is evidence that AI answers address the topic, and that better-evidenced content could be useful there.
The rules
Six rules that keep it honest.
Opportunity ≠ keyword
One opportunity is one meaningful user need or content job, not every query variation.
Evidence has provenance
Observed evidence, proxies and AI-generated hypotheses stay distinguishable.
AI visibility ≠ traffic
A citation or appearance is a visibility signal, not proof of visits, conversions or impact.
Volume ≠ value
High demand doesn’t justify investment if relevance or your right to win is weak.
Human owns strategy
AI speeds up analysis. You approve relevance, evidence, differentiation and priority.
Don’t manufacture pages
No separate pages for small wording variations of the same need.
The evidence
Six kinds of signal. Use the ones you have.
Every signal gets a date and a source, so you always know what was observed, what is a proxy, and what is still a hypothesis. Audience questions often beat keyword volume.
Full workflow
You have search, content, audience or competitive data.
Score normally, and use evidence confidence to separate strong signals from weak ones.
Lightweight workflow
You have limited data, or you are exploring a new topic.
Use at least one real signal plus labelled proxies. AI ideas stay hypotheses until validated.
How it works
Seven stages, one prioritised queue.
It starts with what matters to your business, and ends by learning from what you published. AI helps at each stage; you approve each decision.
- 01
Define
What counts as a valuable opportunity: audience, offers, goals, priority themes and genuine expertise.
- 02
Gather
Capture signals with provenance: dated, attributable, and labelled as observed, proxy or hypothesis.
- 03
Consolidate
Cluster signals into opportunities, one per meaningful user need.
- 04
Research
Investigate each candidate just far enough to make a defensible investment decision.
- 05
Prioritise
Score consistently, keep risk and confidence separate, and override with a documented reason.
- 06
Hand off
Turn each approved opportunity into a brief-ready handoff for whoever creates the content.
- 07
Measure
After publishing, compare what happened with what you assumed, and feed it into the next cycle.
The important part
Business value outweighs volume.
Six factors make up a 0–100 priority score. Risk and evidence confidence sit outside it, so a high score built on guesses can’t pass as certain, and a serious risk can’t be averaged away.
Change the weights if your strategy needs it. Keep the total at 100.
Default weights
Six priority categories
Act now
High priority, strong evidence, no blocking risk. Move to handoff.
Validate further
Potentially valuable, but uncertainty or risk remains.
Refresh existing
Improving an existing page beats creating a new one.
Strategic bet
High strategic or GEO potential despite weaker search signals.
Monitor
Not strong enough yet; keep it with a review trigger.
Do not pursue
Insufficient value or a blocking risk. Record why, and close it.
A worked example
From a repeated question to a decision.
The workbook’s fictional example: a small B2B consultancy whose prospects keep asking the same thing.
Raw signal
Prospects repeatedly ask how to standardise client onboarding.
Opportunity
A practical client-onboarding process guide for small consultancies.
Search evidence
Visible search interest and existing competing guides.
AI-answer evidence
Competitor sources appear in AI answers; the business is absent.
Gap
Existing coverage explains concepts but lacks implementation examples.
Decision
Act now, after evidence review.
Handoff
Create an evidence-led guide with first-hand workflow examples.
The workbook
Plan content for search and AI answers, from evidence.
Everything above is on this page for free. The workbook does the part a webpage can’t: hold the evidence, calculate the scores and categories, and carry each decision into a handoff and a results review.
5 optional AI prompts
seo-geo-content-opportunity-workbook.xlsx
XLSX · 9 worksheets
Enter your email and we’ll send the workbook straight to your inbox. Free, no account, no card.
We may email you occasionally for feedback, or to tell you about new Cognardo resources. Unsubscribe any time.
Keep it where you work
Run the research prompts on every opportunity.
Question expansion, clustering and gap analysis get run again for each topic. Workbench is our browser extension for exactly that — keep prompts organised, fill the variables in a form, and run them without leaving ChatGPT, Claude or Gemini.
FAQ
Questions, answered.
What is GEO?+
Generative engine optimisation: making your content a useful, credible source for AI answer systems such as ChatGPT, Gemini, Perplexity and AI search overviews. In this workbook, a GEO opportunity is evidence that these systems address a topic and that stronger, better-evidenced content could be useful there.
How is SEO different from GEO?+
SEO is about being found and chosen in search results. GEO is about being used or cited in AI-generated answers. They overlap heavily, since both reward genuinely useful, well-evidenced content, so the workbook scores them side by side rather than as separate strategies.
How do I check AI visibility?+
Ask the questions your audience asks, on the platforms they use, and record what you see: the date, the platform, whether an answer was generated, whether your site appeared, and which sources did. Treat each check as one observation, not a permanent ranking.
Is an AI citation the same as traffic?+
No. A citation is a visibility signal. It doesn’t prove visits, conversions or business impact. The workbook keeps AI visibility as its own signal and asks you to record business outcomes separately.
Do I need paid SEO tools?+
No. Search volume and difficulty are optional. You can work from search-performance data you already have, audience questions, competitor reviews and recorded AI checks. With limited data, use the lightweight path and keep confidence low until real evidence supports it.
What is a content opportunity?+
A meaningful user need or content job that may justify creating, refreshing, expanding, consolidating, repositioning, monitoring or rejecting content. One opportunity usually covers many keyword variations.
Does it write the content brief?+
It stops deliberately at a brief-ready handoff: the audience, problem, intent, angle, evidence needed and next workflow. The full brief belongs in a dedicated content brief template.