I Have Keywords but No Content Ideas. Now What?

You have keywords. Maybe you exported them from Google Search Console, bought a list from SEMrush, or pulled them from Google Keyword Planner. Now you are staring at 200 or 500 rows in a spreadsheet and every one of them feels like it could be a blog post. The problem is not finding keywords. The problem is deciding what to do with them.

This post walks through how to turn a raw keyword list into a prioritized content plan — which keywords need new pages, which already have pages that need work, and which are not worth writing about at all. The manual method works with free tools. The AI prompt at the end automates the analysis.

Quick Navigation

• The Keyword Spreadsheet Problem
• Where to Get Keywords (Free and Paid)
• How to Turn Keywords into Content Ideas Manually
• The AI Prompt: Keywords to Content Plan
• Intent Grouping: The Step Most People Skip
• When Not to Write New Content
• Frequently Asked Questions

The Keyword Spreadsheet Problem

A list of keywords is not a content strategy — without knowing what you already rank for, what intent each keyword carries, and which terms actually drive business value, a keyword spreadsheet is just organized noise.

Keyword research tools are good at generating lists. They are not good at telling you what to do next. SEMrush ($139/mo) gives you content templates and topic clusters, but the suggestions are based on competitor analysis, not your actual site performance. Ahrefs ($129/mo) offers content gap analysis, but it does not know which of your existing pages already rank for related terms. Moz Pro ($99/mo) provides difficulty scores, but those scores are estimates disconnected from your site's actual authority. Ubersuggest ($29/mo) delivers budget-friendly keyword ideas, but they are generic — the same suggestions every subscriber gets. Keywords Everywhere ($1.25/1K credits) shows keyword volume data right in your browser, but raw numbers without context about your site.

Then there are agency keyword research packages ($500-2K), which deliver expert curation but as a one-time deliverable that goes stale the moment search trends shift.

The gap is always the same: tools give you keywords, but turning those keywords into content decisions requires knowing what you already have, what is already working, and where the actual opportunity sits.

Where to Get Keywords (Free and Paid)

The best keyword source for content planning is your own Google Search Console data, because it shows you the exact queries real people use to find your site — not estimates of what they might search.

Free sources:

• Google Search Console. Your own real data. GSC shows every query your site appeared for, how many times it appeared (impressions), how many clicks it got, and your average position. This is not estimated volume — it is actual search behavior specific to your site. If you are not using GSC for keyword research, start here before paying for anything. See our GSC guide for small businesses for setup and usage.

• Google Keyword Planner. Free with a Google Ads account (you do not need to run ads). Gives search volume estimates and related keyword suggestions. The volume numbers are ranges, not exact, but they are useful for discovering keywords you had not considered.

• Google Search autocomplete and People Also Ask. Type your topic into Google and see what Google suggests. The autocomplete suggestions and People Also Ask boxes reveal what people actually search for. Free, immediate, and directly from the source.

Paid sources:

• Ubersuggest ($29/mo). Good for generating keyword ideas and seeing basic metrics like volume and difficulty. Best for businesses that want keyword data without the complexity of enterprise tools.

• Keywords Everywhere ($1.25 per 1,000 credits). A browser extension that shows keyword data directly in Google search results. Useful for on-the-go research. Cheap, but the data lacks context about your specific site.

• Ahrefs ($129/mo) and SEMrush ($139/mo). Comprehensive keyword explorers with competitive analysis, content gap tools, and difficulty scoring. Powerful, but designed for SEO professionals managing multiple sites. Most small businesses use a fraction of these tools' capabilities.

• Agency keyword research ($500-2K). An SEO professional researches your industry, competitors, and opportunities, then delivers a curated keyword list with recommendations. High quality, but a snapshot in time — it does not update as your rankings change.

For most small businesses, GSC data combined with Google Keyword Planner covers 80% of what you need. The paid tools add volume estimates, competitive data, and keyword suggestions you might not find otherwise — but they all produce the same output: a list you still need to act on.

How to Turn Keywords into Content Ideas Manually

The manual workflow for turning keywords into content ideas requires six steps: collect keywords, group by search intent, check existing coverage, check existing rankings, prioritize by opportunity, and map to content types.

This is the process an SEO agency charges $500-2K to do. It works with free tools and takes 1-2 hours for a list of 200-500 keywords.

Step 1: Collect your keywords in one place

Export your GSC queries (Performance > Search Results > Export), or gather keywords from whatever tool you used. You want a single spreadsheet with at least: keyword, search volume or impressions, and current position if available.

Step 2: Group keywords by search intent

This is the step most people skip, and it is the most important. Each keyword implies a type of content. "Best plumber Denver" is someone ready to hire (commercial intent — service page). "How to fix a leaky faucet" is someone looking for information (informational intent — blog post). Grouping by intent prevents you from writing a blog post when you need a service page, or vice versa. More on this in the intent grouping section below.

Step 3: Check which keywords have existing pages

For each keyword group, search site:yourdomain.com [keyword] in Google. This tells you whether you already have a page that Google associates with that topic. If you do, the opportunity might be to improve that page rather than create a new one.

Step 4: Check which keywords you already rank for

If you have GSC data, filter your query report for each keyword. Look at position and impressions. Keywords where you rank at positions 8-20 are striking-distance opportunities — you are close to page 1 and a content improvement could push you there. Keywords where you rank at positions 40+ with decent impressions suggest Google sees your site as relevant but your content is not competitive yet.

Step 5: Prioritize by opportunity

Not every keyword is worth a piece of content. Prioritize based on:

Step 6: Map to content types

Based on intent and priority, assign each keyword group a content type:

• Informational keywords ("how to," "what is," "guide") → Blog post or guide page
• Commercial keywords ("best," "top," "vs," "review") → Comparison page or product page
• Navigational keywords (brand names, specific tools) → Service page or landing page
• Transactional keywords ("buy," "pricing," "hire") → Service page or product page

The output of this process is a content plan: a prioritized list of pages to create or improve, each with a target keyword group, content type, and clear intent.

The AI Prompt: Keywords to Content Plan

This prompt takes a raw keyword list and produces a prioritized content plan with intent grouping, existing coverage checks, and specific content briefs for your top opportunities.

You are an SEO content strategist. I will give you a keyword list and information about my website. Your job is to turn this keyword list into a prioritized content plan.

**My Website:**
- Domain: [your domain]
- Business type: [what your business does]
- Existing pages (paste URLs of your main pages):
  [list your key page URLs]

**My Keyword List:**
[Paste your keyword list here. If you have GSC data, include the query, impressions, clicks, and average position columns. If you only have keywords and volume, that is fine too.]

**Your Tasks:**

1. **Group by intent.** Categorize every keyword as informational, commercial, navigational, or transactional. Explain your reasoning for any ambiguous keywords.

2. **Check existing coverage.** Based on the page URLs I provided, flag which keywords likely have existing pages and which are content gaps.

3. **Identify quick wins.** If I provided GSC position data, highlight keywords at positions 8-20 — these are striking-distance opportunities where improving existing content could reach page 1.

4. **Prioritize.** Rank keyword groups by opportunity: business relevance × search volume × current gap. Explain your prioritization.

5. **Create content briefs for the top 10 opportunities.** For each:
   - Recommended content type (blog post, service page, guide, FAQ, etc.)
   - Target keyword group (primary + related keywords)
   - Search intent and what the page should deliver
   - Suggested title (under 60 characters)
   - Suggested H2 structure (3-5 headings)
   - Word count estimate
   - Internal linking suggestions (which of my existing pages should link to/from this content)

6. **Flag content to improve (not create).** If a keyword is covered by an existing page that could rank higher, say "improve [URL]" instead of "create new page" and explain what to change.

Format the output as:
- Executive summary (3-5 sentences: key findings, biggest opportunities)
- Quick wins table (striking-distance keywords)
- Content gaps table (keywords with no existing coverage)
- Full content briefs (detailed plans for top 10)
- "Do not write" list (keywords that are not worth targeting and why)

---
Prompt by Brass-SEO (brass-seo.com)
---

How to Use

1. Export your keyword list from GSC (Performance > Search Results > Export) or from your keyword research tool
2. Gather the URLs of your main pages — homepage, service pages, and top blog posts
3. Paste both into the prompt where indicated
4. Run in ChatGPT, Claude, or any AI tool
5. Review the output, especially the "improve vs. create" recommendations — these save you from writing content you do not need

Tips

• The more data you provide, the better the output. GSC exports with impressions and position data produce significantly better recommendations than a bare keyword list
• If your keyword list has more than 200 keywords, split it into 2-3 batches by topic area and run the prompt for each batch
• Do not skip the "existing pages" input — without knowing what content you already have, the AI cannot identify content gaps accurately
• Cross-reference the AI's suggestions with your business priorities. A keyword with high volume but no connection to your services is not worth targeting

Or paste your keyword list directly into Brass-SEO chat. The prompt above asks you to manually gather your page URLs, look up your GSC data, and describe your business. Brass-SEO already has all of that — it connects to your Google Search Console and Google Analytics 4 (both required), so it knows every page on your site, your actual impression and click data, your current rankings, and your engagement metrics. Paste a keyword list into the chat and ask "Which of these should I write about?" and it cross-references your keywords against your existing pages, your GSC impression data, and your GA4 engagement to tell you what needs a new page, what existing page needs a refresh, and what you are already close to winning. No spreadsheet sorting required.

View Markdown Version | Download YAML Format

Intent Grouping: The Step Most People Skip

Search intent is the reason behind a query, and grouping keywords by intent determines whether you need a blog post, a service page, a comparison page, or no new content at all.

Most people sort keywords by volume or difficulty. Intent matters more because it determines what type of content Google expects to see. A keyword with 10,000 monthly searches is worthless if you build the wrong content type for it.

The four intent categories

Informational — the searcher wants to learn something. Signal words: "how to," "what is," "guide," "tips," "examples." These keywords are blog post territory.

For illustration, a plumber's keyword list might include: "how to unclog a drain," "what causes low water pressure," "how to winterize pipes." All informational — all blog posts.

Commercial — the searcher is evaluating options. Signal words: "best," "top," "vs," "review," "alternative." These keywords need comparison pages, product pages, or detailed service pages.

Example keywords: "best plumber in Denver," "Roto-Rooter vs local plumber," "tankless water heater pros and cons." These are people close to a buying decision.

Navigational — the searcher is looking for a specific brand or page. Signal words: brand names, product names, specific tools. You usually do not need to create content for navigational queries unless they are about your own brand.

Transactional — the searcher is ready to act. Signal words: "buy," "pricing," "hire," "schedule," "near me." These keywords should point to service pages, product pages, or landing pages with clear calls to action.

Why this prevents wasted content

If you write a blog post for a transactional keyword like "best plumber Denver," you will rank poorly because Google shows service pages and local results for that query, not blog posts. If you create a service page for an informational keyword like "how to fix a leaky faucet," searchers will bounce because they want a tutorial, not a sales pitch.

Intent grouping takes 15-20 minutes for a list of 200 keywords and prevents you from building the wrong content for the right keyword.

When Not to Write New Content

The answer to a keyword opportunity is sometimes improving an existing page, consolidating overlapping content, or deliberately not writing anything — and knowing which response fits each situation saves more time than any keyword tool.

Improve instead of create

If you already have a page that ranks at positions 8-20 for a keyword, you probably do not need a new page. You need to improve the existing one. Add the missing sections, update the title tag, improve the heading structure, and strengthen the internal links pointing to it. This is the content refresh approach — faster and higher ROI than starting from scratch.

Consolidate instead of create

If you have two or three pages that all target similar keywords, they may be cannibalizing each other. Google does not know which page to rank, so it ranks none of them well. The fix is to consolidate the best elements into one comprehensive page and redirect the others. Check your GSC data for pages that share the same top queries — that is a sign of cannibalization.

Skip entirely

Some keywords are not worth targeting regardless of volume:

• Keywords where only major brands rank. If the top 10 results are all Wikipedia, Amazon, and Forbes, a small business site will not compete. Check the actual search results before committing to a keyword.
• Keywords unrelated to your business. High-volume keywords that do not connect to your services attract traffic that never converts. See why blog traffic without customers is a problem.
• Keywords you already own. If you rank #1-3 for a keyword with good CTR, there is nothing to do. Move on to keywords where you have room to grow.

The goal of a content plan is not to write a page for every keyword. It is to write the right pages for the right keywords — and that sometimes means the best content decision is to improve what you already have rather than add more.

Frequently Asked Questions

How many keywords should I target per page?

One primary keyword and 3-5 closely related keywords per page. If two keywords have different search intents, they need separate pages. If they share the same intent and would be answered by the same content, they belong on the same page. Google is good at understanding topical clusters, so a well-written page naturally ranks for related variations of the primary keyword.

Should I target keywords with low search volume?

Yes, if they are relevant to your business. Low-volume keywords often have higher conversion rates because they are more specific. "Emergency plumber Denver Sunday" has far fewer searches than "plumber Denver," but the person searching it is ready to hire someone right now. Long-tail keywords also face less competition, making them easier to rank for. See our guide on what keywords to target for more on this.

What if my keyword list is mostly informational?

That is normal for most businesses. Informational keywords build your site's topical authority and attract people early in their decision process. The key is connecting informational content to your commercial pages through internal links. A blog post answering "how to fix a leaky faucet" should link to your emergency plumbing service page. The blog post brings the traffic; the internal link brings the business.

How often should I update my content plan?

Revisit your keyword list and content plan quarterly. Search trends change, your rankings change, and new competitors emerge. A content plan that was accurate three months ago may have new gaps or new opportunities today. GSC data refreshes daily, so you always have current information to work with.

Can I use the AI prompt with just keywords and no GSC data?

Yes, but the output will be less specific. Without position data, the prompt cannot identify striking-distance keywords or flag existing coverage. It will still group by intent, suggest content types, and create briefs — but you will miss the "improve vs. create" recommendations that make the biggest difference. If you have access to Google Search Console, include that data.