To organize keywords quickly, combine search queries and related terms, remove duplicates and irrelevant items, then tag them by topic. To find content opportunities, cross-check search volume, keyword difficulty, existing pages, and questions competitors have not fully answered. The goal is not to keep as many keywords as possible, but to find topics relevant to your business that merit new or updated content. Search volume and competitive gaps help narrow the list; they do not guarantee that your content will rank.
Build and categorize a keyword list from existing queries
Semrush’s 2019 workflow demonstration began by exporting queries from Search Console, grouping them into main keyword categories, and then collecting phrase-match keywords and related search data for each category. You can follow this organizing sequence without replicating the tool integrations or interfaces used at the time.
- Use existing queries to establish topic categories, such as lighting, sofas, and tables for a home furnishings brand.
- Combine related terms from all categories into a single column and remove duplicates so the same term does not appear in multiple places.
- Use automatic tagging to help categorize terms, then manually remove terms unrelated to your business or referring to products you do not sell. Add tags to the remaining terms.
This workflow leaves repetitive compilation work to tools, but deciding which terms are relevant still requires human judgment.
Compare keywords with existing pages to decide what to create or update
Once the list is organized, add monthly search volume, keyword difficulty, and the corresponding landing page for each keyword. Semrush’s 2023 article recommends sorting by search volume and difficulty to identify terms worth creating content for. Keyword difficulty measures how hard it is to reach the top ten search results; it does not guarantee rankings.
Next, check whether each page matches the topic. In the 2019 demonstration, the keyword “bedside tables” was mapped to a table lamp page, leading the author to suggest that a separate bedside table page might be useful. A missing page or a mismatch with an existing page’s topic warrants further investigation, but does not mean every keyword needs its own page. Seasonal data can also help determine which months to publish in.
Turn keywords into questions your audience would actually ask
Content topics need not be limited to product names. A 2022 article on Neil Patel’s website recommends starting with questions your audience wants answered and consulting Google’s “People also ask” section and Answer the Public for questions framed around “how,” “what,” “when,” “where,” “why,” and “who.”
For example, “What is a CTA in marketing?” states the question more clearly than the abbreviation alone. These suggestions can help you plan new content or expand existing articles. The original article focused on earning featured snippets, but its advice does not justify promises about search placements or visibility today.
At Procrustes, our content services also turn the questions clients genuinely care about into articles, with ongoing planning, writing, and updates.
Look for competitive gaps, not just competitors’ ranking keywords
Another set of potential topics comes from keywords your competitors rank for but your website does not. First, filter by search volume and difficulty, then read competitors’ content to check whether it leaves questions unanswered. Tenten’s 2019 article suggests that when competitors’ content does not fully answer relevant questions, a more targeted page can fill the gap. Not ranking for a keyword is a reason to investigate; a question that has not been fully answered is an opportunity for content.
Keyword organization and content opportunities: perspectives from across the web
Can competitors’ content that performs well on social media also signal a search content opportunity?
Potentially. If competitors’ content receives substantial social shares or overall traffic but performs poorly in terms of the keywords it ranks for and estimated search traffic, it may be resonating with readers without fully realizing its potential for search visibility. This is only a lead to investigate; the data alone cannot establish the cause. You still need to read the content to determine whether there are questions worth addressing further or answering more directly.
How can you use competitors’ older articles to find opportunities?
Look for older content with many links but few ranking keywords and little estimated search traffic. Tenten’s 2019 article suggests that outdated content with declining rankings may present a competitive opportunity. This applies only after confirming that the information genuinely needs updating. Many links or low traffic alone cannot establish that a lack of updates caused a ranking decline.
Can estimated revenue help prioritize content topics?
Estimated monthly revenue can serve as a reference for further analysis, but should not be treated as actual income or a revenue guarantee. Semrush’s 2019 workflow demonstration used tools and spreadsheets to compile keyword difficulty, monthly search volume, and basic monthly revenue estimates. These figures are estimates and should be considered alongside how well a topic fits your business and audience needs.
References
- SEO Management: How to Successfully Run Your Campaignwww.semrush.com · 2023-08-14T18:29:00Z — Source used in the article above.
- What are Featured Snippets? How to Get Themneilpatel.com · 2022-08-18T19:00:00+00:00 — Source used in the article above.
- 5 步驟掌握競爭對手 SEO 優勢,提升網站排名tenten.co · 2019-01-11T00:00:00.000Z — Discusses: Can competitors’ content that performs well on social media also signal a search content opportunity?; How can you use competitors’ older articles to find opportunities?
- Weekly Wisdom with Ross Tavendale: Super Fast Keyword Researchwww.semrush.com · 2019-01-29T08:00:00Z — Discusses: Can estimated revenue help prioritize content topics?




