keyword-research-and-clustering

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

Keyword Research & Clustering

关键词研究与聚类

Research keywords, expand them systematically, cluster by topic and intent, and prioritize for content strategy — all without expensive tools.

无需昂贵工具，即可完成关键词研究、系统性拓展、按主题与意图聚类，并为内容策略进行优先级排序。

Required Input

必要输入

Ask the user for:

Niche/Industry — What space are you in?
Target Audience — Who are you writing for?
Business Goal — Traffic, leads, sales, authority?
Existing Content — Do you have a site/blog already?

请向用户询问以下信息：

细分领域/行业 — 你所处的领域是什么？
目标受众 — 你的内容面向谁？
业务目标 — 流量、线索、销售还是权威打造？
现有内容 — 你是否已有网站/博客？

The 6 Circles Method

六圈层法

Generate 13 content ideas from a single seed keyword using nested topic clusters.

                    ┌─────────────────────┐
                    │   PRIMARY KEYWORD   │  ← 1 pillar topic
                    │   (Largest Circle)  │
                    └─────────────────────┘
                              │
            ┌─────────────────┼─────────────────┐
            ▼                 ▼                 ▼
     ┌───────────┐     ┌───────────┐     ┌───────────┐
     │ Sub-topic │     │ Sub-topic │     │ Sub-topic │  ← 3 supporting themes
     │     A     │     │     B     │     │     C     │
     └───────────┘     └───────────┘     └───────────┘
            │                 │                 │
      ┌─────┼─────┐     ┌─────┼─────┐     ┌─────┼─────┐
      ▼     ▼     ▼     ▼     ▼     ▼     ▼     ▼     ▼
     [1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]  ← 9 content pieces

Process:

Identify primary keyword — high-traffic, high-intent topic in your niche
Brainstorm 3 sub-topics — related themes that support the primary
Generate 3 pieces per sub-topic — specific articles addressing aspects of each

通过嵌套主题聚类，从单个种子关键词生成13个内容创意。

                    ┌─────────────────────┐
                    │   PRIMARY KEYWORD   │  ← 1 pillar topic
                    │   (Largest Circle)  │
                    └─────────────────────┘
                              │
            ┌─────────────────┼─────────────────┐
            ▼                 ▼                 ▼
     ┌───────────┐     ┌───────────┐     ┌───────────┐
     │ Sub-topic │     │ Sub-topic │     │ Sub-topic │  ← 3 supporting themes
     │     A     │     │     B     │     │     C     │
     └───────────┘     └───────────┘     └───────────┘
            │                 │                 │
      ┌─────┼─────┐     ┌─────┼─────┐     ┌─────┼─────┐
      ▼     ▼     ▼     ▼     ▼     ▼     ▼     ▼     ▼
     [1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]  ← 9 content pieces

流程：

确定核心关键词——你所在细分领域中高流量、高意图的主题
构思3个副主题——支撑核心关键词的相关主题
每个副主题生成3个内容——针对各副主题不同方面的具体文章

Content Types for Supporting Pieces

支撑内容的类型

Type	Example
How-to Guide	"How to [achieve outcome] with [method]"
Comparison	"[Option A] vs [Option B]: Which is better for [use case]"
List Post	"[Number] [adjective] ways to [achieve result]"
Case Study	"How [persona] achieved [result] using [approach]"
Trend Analysis	"[Topic] trends in [year]: What's changing"
Beginner Guide	"[Topic] for beginners: Everything you need to know"
Tool Review	"Best [category] tools for [audience/use case]"
Problem-Solution	"Why [problem happens] and how to fix it"

类型	示例
操作指南	"如何用[方法]达成[结果]"
对比分析	"[选项A] vs [选项B]：哪个更适合[使用场景]"
清单文章	"[数字]种[形容词]方法实现[结果]"
案例研究	"[用户画像]如何用[方法]达成[结果]"
趋势分析	"[年份][主题]趋势：有哪些变化"
入门指南	"[主题]入门：你需要知道的一切"
工具评测	"面向[受众/使用场景]的最佳[类别]工具"
问题解决方案	"[问题]产生的原因及解决方法"

Seed Generation (50–100 Keywords)

种子关键词生成（50–100个）

Google Autocomplete & PAA

Google自动补全与PAA

Type
```
[keyword]
```
+ a–z variations
"how to [keyword]", "best [keyword] for", "[keyword] vs"
Capture People Also Ask questions from SERP

输入
```
[关键词]
```
+a-z的变体
"how to [keyword]"、"best [keyword] for"、"[keyword] vs"
从SERP中提取「People Also Ask」（相关问题）

Community Mining

社区挖掘

Source	What to Extract
Reddit	Pain points, questions, terminology
Quora	Question patterns, answer gaps
Industry Forums	Niche-specific problems
YouTube Comments	Objections, confusion points
Amazon Reviews	Customer language, unmet needs

来源	提取内容
Reddit	痛点、问题、专业术语
Quora	问题模式、答案空白
行业论坛	细分领域特定问题
YouTube评论	异议、困惑点
亚马逊评论	客户用语、未被满足的需求

Reddit Mining Protocol

Reddit挖掘规则

Search queries:

site:reddit.com "[niche]" + "how do I"
site:reddit.com "[niche]" + "help"
site:reddit.com "[niche]" + "struggling with"
site:reddit.com "[niche]" + "recommend"
site:reddit.com "[niche]" + "vs"

Extract: Questions asked repeatedly (content opportunities), complaints about existing solutions (angle differentiation), terminology and slang (keyword variations), upvote patterns (demand signals).

搜索查询：

site:reddit.com "[niche]" + "how do I"
site:reddit.com "[niche]" + "help"
site:reddit.com "[niche]" + "struggling with"
site:reddit.com "[niche]" + "recommend"
site:reddit.com "[niche]" + "vs"

提取内容：重复出现的问题（内容机会）、对现有解决方案的抱怨（差异化角度）、术语与俚语（关键词变体）、点赞模式（需求信号）。

Keyword Expansion Techniques

关键词拓展技巧

Modifier Categories

修饰词类别

Question modifiers:

What is {keyword} / How to {keyword} / Why {keyword} / When to {keyword}

Comparative modifiers:

{keyword} vs {competitor} / {keyword} alternatives / best {keyword} / {keyword} comparison

Intent modifiers:

{keyword} guide / {keyword} tutorial / {keyword} examples / {keyword} template / buy {keyword} / {keyword} pricing

Audience modifiers:

{keyword} for beginners / {keyword} for {industry} / {keyword} for small business / {keyword} for enterprise

疑问类修饰词：

What is {keyword} / How to {keyword} / Why {keyword} / When to {keyword}

对比类修饰词：

{keyword} vs {competitor} / {keyword} alternatives / best {keyword} / {keyword} comparison

意图类修饰词：

{keyword} guide / {keyword} tutorial / {keyword} examples / {keyword} template / buy {keyword} / {keyword} pricing

受众类修饰词：

{keyword} for beginners / {keyword} for {industry} / {keyword} for small business / {keyword} for enterprise

Expansion Procedure

拓展步骤

Extract current topic scope and any exclusions
Propose expansions: synonyms, related terms, acronyms
Add explicit exclusions for common false positives
Document "why" for each change
Keep query count manageable — merge near-duplicates instead of adding many variations

提取当前主题范围及排除项
提出拓展方向：同义词、相关术语、缩写
明确排除常见误匹配项
记录每项修改的原因
控制查询数量——合并近似重复项，而非添加大量变体

Free Tool Arsenal

免费工具库

Demand Research

需求研究

Tool	Use For	Access
Google Keyword Planner	Volume ranges, competition	ads.google.com (free account)
Google Trends	Seasonality, rising topics	trends.google.com
Ahrefs Free Generator	150 suggestions with difficulty	ahrefs.com/keyword-generator
Ubersuggest	3 searches/day with metrics	neilpatel.com/ubersuggest

工具	用途	获取方式
Google Keyword Planner	搜索量范围、竞争程度	ads.google.com（免费账户）
Google Trends	季节性、上升主题	trends.google.com
Ahrefs Free Generator	150个带难度指数的关键词建议	ahrefs.com/keyword-generator
Ubersuggest	每日3次搜索，附带指标	neilpatel.com/ubersuggest

Intent Discovery

意图挖掘

Tool	Use For	Access
Google Autocomplete	Real-time user queries	Type in search bar
People Also Ask	Question-based content	Scroll down in SERP
Answer the Public	Visual question maps	answerthepublic.com
AlsoAsked	PAA clustering	alsoasked.com

工具	用途	获取方式
Google自动补全	实时用户查询	搜索栏输入
People Also Ask	基于问题的内容	SERP中向下滚动查看
Answer the Public	可视化问题图谱	answerthepublic.com
AlsoAsked	PAA聚类	alsoasked.com

Competition Assessment (Manual SERP Analysis)

竞品评估（手动SERP分析）

For each target keyword, analyze top 10 results:

Signal	What to Look For	Opportunity If...
Content Depth	Word count, comprehensiveness	Top results are thin (<1000 words)
Freshness	Publication date, last update	Top results are 2+ years old
Format Match	Does format match intent?	Results don't match searcher need
Authority Gap	Domain strength of rankers	Small sites ranking (not all big brands)
Content Gaps	Missing subtopics, unanswered questions	PAA questions not covered

针对每个目标关键词，分析排名前10的结果：

信号	关注要点	机会点
内容深度	字数、全面性	排名靠前的内容较浅显（<1000字）
时效性	发布日期、最后更新时间	排名靠前的内容已发布2年以上
格式匹配度	格式是否符合意图	结果未满足搜索者需求
权威差距	排名网站的域名权重	小型网站排名（并非全是大品牌）
内容空白	缺失的副主题、未解答的问题	PAA中的问题未被覆盖

Sweet Spot Targets by Site Stage

不同网站阶段的最优目标

Site Stage	Monthly Search Volume	Competition Level
New site (0–6 months)	100–500	Low
Growing site (6–18 months)	500–2,000	Low–Medium
Established site (18+ months)	1,000–10,000	Medium

网站阶段	月搜索量	竞争程度
新网站（0–6个月）	100–500	低
成长中网站（6–18个月）	500–2,000	低–中
成熟网站（18个月以上）	1,000–10,000	中

Clustering Algorithm

聚类算法

Extract seed topics — Identify main themes from expanded list
Group by semantic similarity — Keywords with overlapping meaning
Map intent — Assign Informational / Commercial / Transactional / Navigational
Identify pillar — Highest-volume, broadest term = pillar page
Map supporting — Lower-volume terms support pillar

提取种子主题——从拓展后的关键词列表中识别核心主题
按语义相似度分组——含义重叠的关键词归为一组
映射意图——分配信息型/商业型/交易型/导航型
确定支柱关键词——搜索量最高、范围最广的术语 = 支柱页面
映射支撑关键词——搜索量较低的术语用于支撑支柱关键词

Cluster Structure Example

聚类结构示例

PILLAR: "content marketing" (highest volume)
├── CLUSTER: "content marketing strategy" (commercial)
│   ├── content marketing plan template
│   ├── content marketing framework
│   └── how to create content marketing strategy
├── CLUSTER: "content marketing examples" (informational)
│   ├── B2B content marketing examples
│   ├── content marketing case studies
│   └── content marketing success stories
└── CLUSTER: "content marketing tools" (commercial)
    ├── best content marketing tools
    ├── content marketing software
    └── content marketing platforms

PILLAR: "content marketing" (highest volume)
├── CLUSTER: "content marketing strategy" (commercial)
│   ├── content marketing plan template
│   ├── content marketing framework
│   └── how to create content marketing strategy
├── CLUSTER: "content marketing examples" (informational)
│   ├── B2B content marketing examples
│   ├── content marketing case studies
│   └── content marketing success stories
└── CLUSTER: "content marketing tools" (commercial)
    ├── best content marketing tools
    ├── content marketing software
    └── content marketing platforms

Intent Classification

意图分类

Signal	Intent
"what is", "how to", "guide"	Informational
"best", "vs", "review", "compare"	Commercial
"buy", "price", "discount", brand	Transactional
Brand name, specific product	Navigational

信号	意图
"what is"、"how to"、"guide"	信息型
"best"、"vs"、"review"、"compare"	商业型
"buy"、"price"、"discount"、品牌名	交易型
品牌名、特定产品	导航型

Prioritization Matrix

优先级矩阵

Score each keyword 1–10:

Keyword	Demand	Competition	Intent Fit	Opportunity
[keyword]	[1–10]	[1–10, lower=easier]	[1–10]	Demand − Competition

Prioritize: Opportunity score > 3, Intent fit > 6

为每个关键词打1–10分：

关键词	需求度	竞争度	意图匹配度	机会值
[keyword]	[1–10]	[1–10，分数越低越容易]	[1–10]	需求度 − 竞争度

优先级标准： 机会值 > 3，意图匹配度 > 6

Output Format

输出格式

markdown

undefined

markdown

undefined

Keyword Research: [Niche/Topic]

6 Circles Content Plan

Primary Keyword: [keyword]

Monthly searches: [range]
Competition: [low/medium/high]
Intent: [informational/commercial/transactional]

Monthly searches: [range]
Competition: [low/medium/high]
Intent: [informational/commercial/transactional]

Sub-topic A: [theme]

[Article idea] — [target keyword] — [volume]
[Article idea] — [target keyword] — [volume]
[Article idea] — [target keyword] — [volume]

[Article idea] — [target keyword] — [volume]
[Article idea] — [target keyword] — [volume]
[Article idea] — [target keyword] — [volume]

Sub-topic B: [theme]

4–6. [...]

Sub-topic C: [theme]

7–9. [...]

Prioritized Content Queue

Priority	Topic	Keyword	Volume	Difficulty	Opportunity
1	[topic]	[keyword]	[vol]	[1–10]	[score]

Priority	Topic	Keyword	Volume	Difficulty	Opportunity
1	[topic]	[keyword]	[vol]	[1–10]	[score]

Quick Wins (Low Competition, Decent Volume)

[keyword 1] — [rationale]
[keyword 2] — [rationale]

[keyword 1] — [rationale]
[keyword 2] — [rationale]

Content Gaps Found

[gap 1] — competitors missing [what]
[gap 2] — outdated content on [topic]

[gap 1] — competitors missing [what]
[gap 2] — outdated content on [topic]

Community Insights

Top pain point: [description]
Common question: [question]
Terminology used: [terms]

---

Top pain point: [description]
Common question: [question]
Terminology used: [terms]

---

keyword-research-and-clustering

Original

Translation

Keyword Research & Clustering

关键词研究与聚类

Required Input

必要输入

The 6 Circles Method

六圈层法

Content Types for Supporting Pieces

支撑内容的类型

Seed Generation (50–100 Keywords)

种子关键词生成（50–100个）

Google Autocomplete & PAA

Google自动补全与PAA

Community Mining

社区挖掘

Reddit Mining Protocol

Reddit挖掘规则

Keyword Expansion Techniques

关键词拓展技巧

Modifier Categories

修饰词类别

Expansion Procedure

拓展步骤

Free Tool Arsenal

免费工具库

Demand Research

需求研究

Intent Discovery

意图挖掘

Competition Assessment (Manual SERP Analysis)

竞品评估（手动SERP分析）

Sweet Spot Targets by Site Stage

不同网站阶段的最优目标

Clustering Algorithm

聚类算法

Cluster Structure Example

聚类结构示例

Intent Classification

意图分类

Prioritization Matrix

优先级矩阵

Output Format

输出格式

Keyword Research: [Niche/Topic]

Keyword Research: [Niche/Topic]

6 Circles Content Plan

6 Circles Content Plan

Primary Keyword: [keyword]

Primary Keyword: [keyword]

Sub-topic A: [theme]

Sub-topic A: [theme]

Sub-topic B: [theme]

Sub-topic B: [theme]

Sub-topic C: [theme]

Sub-topic C: [theme]

Prioritized Content Queue

Prioritized Content Queue

Quick Wins (Low Competition, Decent Volume)

Quick Wins (Low Competition, Decent Volume)

Content Gaps Found

Content Gaps Found

Community Insights

Community Insights

Related Skills

相关技能