Content Planning Workflow: From Keywords to Editorial Calendar

Chapter 4: Content Marketing · Question 52

“I know content marketing matters, but every time I sit down to write, I have no idea what to write about." — This may be the most common dilemma for marketers. The solution isn't "inspiration”," buta repeatable content planning workflow。

Complete workflow: 5 steps

关键词研究 → 主题聚类 → 内容缺口分析 → 选题排优先级 → 编辑日历落地

Here's the step-by-step breakdown:

Step 1: Keyword research (uncover demand)

Don't guess what users want to read — let data speak:

Practical tip: Starting from your core business terms, use "5118long-tail keywordmining" to export 200-500 related keywords in one go (example count, varies by business scale) — this is your "demand pool."

Take songbing.com.cn as an example. Its core business terms are "organic marketing / AI search optimization," and the long-tail keywords mined around them include "what is GEO," “how do I get AI to recommend my brand," “how to rank in Xiaohongshu search," and hundreds more.

Step 2: Topic clustering (group into categories)

Take the hundreds ofKeywordand group them bysearch intent. For example, the "organic marketing" topics covered by songbing.com.cn:

• Awareness: What is organic marketing, what is GEO, what is AEO, what is organic traffic
• Selection: What's the difference between SEO and GEO, which matters more — AEO or GEO, SEO vs SEM
• Hands-on：how to get AI to recommend my brand, how to do Xiaohongshu search ranking, and how to handle content deduplication
• Industry type：how cross-border e-commerce does SEO, AI marketing for maternal and baby brands, SEO for luxury brand official websites

Each group is one of yourcontent matrixOne of the "Pillar Topic”" (Pillar Topic). songbing.com.cn turned these groups into different Q&A pages: awareness type → “XX What Is" series (what-is-geo/ etc.), practical type → step-by-step tutorials (get-ai-to-recommend-your-brand/ etc.), and finally all organized by chapter into the /100wen/ directory.

Step 3: Content gap analysis (find opportunities)

Compare competitors and your existing content, and draw a table (taking songbing.com.cn supplementing the "organic marketing" topic as an example):

What competitors have but you don't = gaps that must be filled; what competitors don't have but still has decent search volume = blue ocean opportunities. The way songbing.com.cn fills gaps like "how to get AI to recommend my brand" is by writing them as standalone Q&A pages and merging them into /100wen/ the corresponding chapters.

Step 4: Prioritize

Not all topics are worth writing immediately. Score them using these three dimensions (1-5 points each):

1. Business relevance：Can this topic bring in potential customers?
2. Search opportunity：Does it have search volume and is competition not particularly intense?
3. Resource feasibility：Can our team produce high-quality content on this within a reasonable time?

Multiply the three scores to get a total score; sorting by score gives you your publishing priority.

Step 5: Put the editorial calendar into practice

Fill the prioritized topics into a monthly editorial calendar:

(The table above uses songbing.com.cn's publishing cadence as an example—it follows the "one question, one article" approach, turning each topic into a Q&A page and then organizing them into chapters in the directory.)

Cadence recommendation：For early-stage teams, 1 high-quality long-form article per week > 1 low-quality article per day. Content marketing is a compounding game; quality always takes priority over quantity.

Practical recommendations

• Spend half a day each month on a "topic sprint”：Complete keyword research → clustering → scheduling in one focused session, then devote the remaining time to writing, avoiding the daily struggle of "what should I write today”."
• Manage your editorial calendar with Feishu/Notion multi-dimensional tables：Fields include topic, keyword, owner, deadline, publishing channel, and current status—all at a glance.
• Reserve 20% flexible space for trending content：The editorial calendar isn't rigid; leave room to chase industry trends, but keep the main framework stable.