Rankfill

Keyword Research Methods That Lead to Published Content

You've spent two hours in a keyword tool. You've exported a spreadsheet with 400 rows. You've color-coded by difficulty, sorted by volume, maybe even added a "priority" column. Then you close the tab and don't publish anything for three weeks.

That's the real problem with most keyword research — it produces lists, not content. The method you use to find keywords determines whether you actually write the article or let it rot in a Google Sheet.

Here's how to do research that ends in a published page.

The Split That Matters: Discovery vs. Prioritization

Most people treat keyword research as one step. It's two.

Discovery is finding candidates — every relevant phrase your audience might search.

Prioritization is deciding which ones to write about this week, in what order, and with what angle.

When you collapse these into one messy session, you end up with an unfocused list and no publishing plan. Separate them deliberately.

Method 1: Start From What You Already Rank For

Before hunting for new keywords, pull the ones where you already exist — pages ranking on positions 8 through 25. These are your fastest wins.

Use Google Search Console → Performance → Search Results. Filter to queries where you're averaging position 8–25 with at least 50 impressions over 90 days. These pages are already indexed, already trusted slightly, and need a content improvement to move up — not a new article.

This method is underused because it's unsexy. But updating an existing page to rank for a term it's already close to ranking for is faster and more reliable than publishing from scratch.

Method 2: Competitor Gap Analysis

Open any page from a competitor that ranks for something you want. Put it into a tool like Ahrefs, Semrush, or Ubersuggest. Look at what other keywords that page ranks for. Then look at which of those keywords you have no content for.

Do this across five to ten competitor URLs and you'll see patterns — clusters of topics they've built out that you haven't touched. Those clusters represent a content gap with proven demand. Someone already validated that people search for this and that these pages can rank.

This is different from guessing what your audience wants. You're reading what the market has already answered.

How to find and target low competitive keywords goes deeper on filtering these gaps by difficulty so you're not walking into a fight you can't win.

Method 3: Topic Clustering, Not One-Off Articles

Random articles don't compound. A cluster does.

Pick one broad topic your site should own. Then map out every question, sub-question, and use case underneath it. A pillar page covers the broad topic; cluster pages answer each specific question in depth. Internal links connect them.

This method works because search engines reward topical depth. A site with twelve inter-linked articles about project management software pricing will outrank a site with one article and eleven unrelated posts — even if domain authority is similar.

To build the cluster map:

  1. Pick your core topic
  2. List every question a beginner, intermediate, and advanced reader would ask about it
  3. Check which questions have search volume (tools: Google's "People Also Ask," keyword tools, Reddit threads)
  4. Assign one page per question

The result is a publishing roadmap, not a list of isolated ideas.

Method 4: Search Intent Sorting

You can find a keyword with 2,000 monthly searches and write the wrong article for it. If someone searches "CRM software" they want a comparison. If they search "how to set up CRM workflows," they want a tutorial. Write a sales page for the second one and you'll rank for nothing.

Every keyword you add to your list should have a single-word intent label: informational, commercial, transactional, or navigational.

Match your content format to the intent. Tutorials for informational. Comparison pages for commercial. Landing pages for transactional. Getting this wrong wastes your effort even when the keyword itself is right.

For keywords where someone is close to a decision, see buyer keywords: how to find terms that convert — the intent signals are specific and worth understanding before you write a single word.

Method 5: The "Can I Win This?" Filter

Before any keyword goes into your publishing queue, ask three questions:

  1. What's the current SERP look like? Open an incognito window and search the term. Are the top results from massive publications with thousands of backlinks? Or are there mid-authority sites ranking with thin content you could beat?

  2. What's my domain authority relative to what's ranking? A DA 30 site trying to rank against DA 80 domains on a head term is wasted effort. Head terms vs. long-tail keywords explains why newer and mid-authority sites should prioritize specificity over volume.

  3. Can I write something meaningfully better than what's there? Not just longer — better. More specific. More accurate. More useful to someone who read the current results and still has questions.

If you can't say yes to question three, skip the keyword. Publishing mediocre content on hard keywords is how you waste six months.

Building a Publishing Queue From Your Research

Here's a simple system that converts your keyword list into a schedule:

Column structure for your tracker:

Anything without a publish date is just a list. Assign dates. Even rough ones. The act of scheduling forces prioritization.

Sort by difficulty ascending, then by volume descending within similar difficulty bands. Start with the winnable terms that still have real search demand. Build momentum before attacking competitive keywords — and if you do eventually go after the hard ones, competitive keywords: how to rank when you're behind is worth reading first.

The Tool Question

You don't need an expensive subscription to start. Google Search Console (free), Google's autocomplete, and "People Also Ask" boxes give you more than enough to build a 90-day content plan. Paid tools like Ahrefs or Semrush add speed and data depth — they're worth it once you have a process that works.

If you want the competitor gap analysis done systematically across your entire market, Rankfill maps every keyword opportunity competitors are capturing that your site is missing and delivers a full content plan you can execute.

But the method doesn't require any tool to work. The method requires deciding that a keyword is worth writing about before you open a blank document — not after.

FAQ

How many keywords should I target per article? One primary keyword. Two to four secondary phrases that are semantically related and share the same intent. Trying to rank one article for ten different topics produces a page that doesn't serve any of them well.

Should I go after high-volume or low-volume keywords? It depends on your domain's current strength. A newer or mid-authority site should start with lower-volume, lower-difficulty terms where it can actually rank. Traffic from a ranking position 3 on a 200/month keyword is real traffic. Traffic from position 40 on a 10,000/month keyword is zero.

How do I know if a keyword is too competitive? Look at who's ranking, not just the difficulty score. Tools can underestimate difficulty. If the top five results are from Wikipedia, major news outlets, and enterprise software companies, that's a real signal. If mid-size blogs are ranking with solid but beatable content, that's opportunity.

How often should I do keyword research? Quarterly is a practical cadence for most sites. Monthly if you're publishing aggressively. The market shifts, competitors publish new content, and new questions emerge. Your keyword list from six months ago is already partially stale.

What's the biggest mistake people make in keyword research? Researching without a clear connection to publishing. If your research process doesn't end with a specific article assigned to a specific date, you're doing hobby SEO. The goal is content that gets indexed and ranks — everything else is preparation.