Wrote dozens of blog posts, still no traffic? 90% of your keywords are wishful thinking

If you build indie products, you've probably done this:

Built a website for your app, blogged seriously. Two posts a week, for six months.

Then you check the dashboard — organic search traffic: double digits a day.

I blamed my writing at first and pushed even harder. Then it hit me: it wasn't the content. Step one was already wrong.

The keywords were wrong.

Say you make a budgeting app and your site's main keyword is "expense tracker". Huge search volume — but open Google and look at the front page: NerdWallet, big review sites, products with hundreds of millions of users. A new site fighting for that? Forget it.

Wrong keywords, and nothing after matters — not great writing, not aggressive backlinks.

Keyword research is the origin of all SEO. One degree off at the start, miles off at the end.

Here's the method I keep coming back to — it avoids the trap 90% of people fall into.

1. Don't stare at search volume alone

Most people pick keywords on one criterion: how many people search it.

Search volume is only a third of the picture. Look at three things:

• Search volume: your traffic ceiling
• Competition: how many resources you'll burn
• Commercial value: is the searcher here to learn, or carrying a wallet?

Is there a formula? Yes.

Efficiency = Search Volume ÷ Competition

Three candidate keywords for a budgeting app's site, side by side:

• "expense tracker": biggest volume, but the front page is all giants → efficiency ranks last, park it
• "expense tracker for freelancers": medium volume, medium competition → decent efficiency, worth doing
• "receipt scanning app for small business": smallest volume, lowest competition → highest efficiency, do it first

See the pattern? The biggest keyword ranks LAST on efficiency.

Volume decides how high you can fly, competition decides how much fuel you'll burn, commercial value decides whether the trip pays. Look at all three, or you're just cheering for yourself.

2. Don't guess difficulty — run a checkup on the keyword

"Is this keyword hard?" — guessing is malpractice. Six quantitative checks:

1. Total results: hundreds of millions vs a few thousand — different worlds
2. intitle results: search "intitle:your keyword" — big numbers mean professionals are watching it
3. Ad bids: crowded ads and expensive CPC mean the word is valuable — organic won't be easy either
4. Competitor strength: big brands and review media on page one, or small indie sites? The latter is your opening
5. Page types on page one: if inner pages rank, Google is lenient here — you have a shot
6. Supporting signals: how many exact-match domains, how full are the ad slots

Read all six together. A classic combo: few intitle results but high bids — few people competing organically, yet the word is extremely valuable. That's an unnoticed gold mine. Dig quietly. Don't tell anyone.

3. What is the searcher actually thinking?

Same traffic, different intent, completely different value. Three intent types:

• Navigational: they want a specific site. You can't take it. Skip.
• Informational: "how to track expenses" — 80% of all searches. Catch it with blog tutorials, play the long game.
• Transactional: "best expense tracker app" — small traffic, but every query smells like money. Catch it with product and comparison pages.

The most common faceplant: taking an informational keyword and dragging people to a purchase page. They came to learn, they land on "Download Now" everywhere — they close the tab and resent you. Intent-page mismatch means no conversion no matter the traffic. All that work for nothing.

4. Long-tail keywords aren't "made", they're "grown"

Hearing "long-tail", many people pull tens of thousands of obscure keywords from a tool and churn out content like a robot. Don't.

Long-tail grows naturally. Just do three things right:

1. Structure your site so search engines can crawl every page
2. Keep writing content that genuinely solves problems
3. Accumulate domain authority slowly, with backlinks and time

Do these three and long-tail traffic comes on its own. A hundred hours of keyword digging is worth less than one genuinely good article.

5. Don't let your pages fight each other

The deepest trap: your homepage targets "expense tracker", and your blog keeps writing "expense tracker" too. Feels like coverage? Wrong. That's your left hand punching your right.

Search engines pick only ONE most relevant page from your site. Multiple pages fighting for the same keyword splits the authority, and none of them ranks.

The fix takes five steps, one afternoon:

1. List your core keywords
2. Classify by intent: informational → blog, transactional → product pages
3. Bind each keyword to exactly ONE URL
4. Place it naturally in the target page's title, H tags, and body
5. Every other page avoids that keyword and sticks to its own job

It's called keyword mapping. In plain words: give every keyword one owner, so it doesn't go around adopting random dads.

Last thing

Keyword picking isn't one-and-done. Review every quarter: which words dropped, which new words emerged.

But run this playbook once — the three-way balance, the six-point checkup, intent classes, growing long-tail, keyword mapping — and you're ahead of 90% of people still picking keywords by gut feel.

Right keywords make every post count. Wrong keywords make every post a monologue.

What keyword mistakes have you made? The indie dev friend still grinding blog posts in the dark is usually stuck on this step.

X Article: https://x.com/bb833dong/article/2103849742975615418