SEO Keyword Analysis: A Practical DIY Guide With a Worked Example

Most keyword research dies in a spreadsheet. Someone exports 800 phrases from a tool, highlights the ones with big numbers, and then nobody ever looks at the file again. That is the opposite of useful. Good seo keyword analysis is not about collecting words. It is about deciding which searches are worth your time, what the people behind them actually want, and which page on your site should answer them.

This guide walks through how we do seo keyword analysis at Zarle Infotech, the same process we run for clients before we write a single line of content. You will get the concepts (intent, volume, difficulty, business value), a repeatable workflow, free and paid tools, and a full worked example using a Noida dental clinic. By the end you should be able to sit down with a blank sheet and build a keyword plan you can actually act on.

What seo keyword analysis actually means

Keyword research is finding the phrases people type into Google. Seo keyword analysis is the harder part that comes next: judging those phrases. You are asking three questions about every candidate.

• Is anyone searching for this, and how many?
• Can a site like mine realistically rank for it?
• If I rank, does it bring me money or just traffic?

A phrase only earns a place in your plan when the answers line up. A term with 40,000 searches a month is useless to a two-month-old dental clinic if the first page is owned by national hospital chains. A term with 90 searches a month can be gold if those 90 people are ready to book an appointment.

So the goal is not the biggest list. It is the shortest list of terms that you can win and that pay you back.

Start with search intent, not volume

Before you look at a single number, sort your keywords by what the searcher wants. Google has spent years getting good at this, and it will not rank a product page for a question, no matter how strong your backlinks are.

There are four intents worth knowing:

• Informational. The person wants to learn. "what causes tooth sensitivity", "how does root canal work". These suit blog posts and guides.
• Navigational. They already know where they want to go. "ranvay dental noida", "hdfc net banking". You rank for these mostly by being the brand.
• Commercial. They are comparing options before deciding. "best dentist in sector 66 noida", "invisalign vs braces cost". These suit comparison pages and service pages with proof.
• Transactional. They are ready to act. "dental clinic near me open now", "book teeth cleaning noida". These suit your booking pages and local landing pages.

The fastest way to confirm intent is to search the keyword yourself and look at what already ranks. If the first page is all blog articles, Google reads the term as informational. If it is all product or booking pages, it is transactional. Match the page type to what is already winning, or you fight gravity.

This step alone fixes the most common keyword mistake we see: trying to rank a sales page for a question, or a blog post for a buying query.

Volume vs difficulty vs business value

Once intent is sorted, weigh each keyword on three axes. Think of them as a triangle. You rarely get all three at maximum, so you trade.

Search volume

This is the rough number of monthly searches. Treat it as a range, not a fact. Different tools report different figures because they model it differently, and Google Keyword Planner buckets volumes into wide bands unless you are running ads. A term showing "1,000 to 10,000" in Planner could be either. Use volume to compare keywords against each other, not as gospel.

Keyword difficulty

Difficulty estimates how hard it is to crack the first page, usually scored 0 to 100 based on the strength of the sites already ranking. A young site should chase low to mid difficulty (roughly under 20 to 25 to start). The honest way to check difficulty is still manual: search the term and look at who ranks. Ten national brands and Wikipedia means stay away for now. A couple of thin pages and a forum thread means there is an opening.

Business value

This is the one tools cannot score for you, and it is the most important. How close is this searcher to paying you? We grade it simply: high, medium, low. "dental implant cost noida" is high value even at low volume because that person is pricing a real procedure. "is flossing good" is low value even at high volume because most of those readers will never become patients.

The sweet spot is the overlap: decent volume, manageable difficulty, real business value. Here is how the three usually trade off across keyword types.

New sites win on the bottom two rows first, then climb. There is nothing wrong with a keyword that has 70 searches a month if it converts at 10 percent and the difficulty is near zero.

How to find keywords (seed to list)

You do not need a fancy stack to build a list. Start with seeds and expand.

1. Write down your seeds. Plain terms for what you do: "root canal", "teeth whitening", "kids dentist", "dental clinic noida". Five to ten is plenty.
2. Mine Google itself. Type a seed and read the autocomplete suggestions. Scroll to "People also ask" and "Related searches" at the bottom. This is free, real, and current.
3. Run the seeds through a keyword tool. Each seed becomes dozens of variations with volume and difficulty attached.
4. Steal from competitors. Find two or three rivals ranking well and pull the keywords their pages already rank for. Tools like Ubersuggest, Ahrefs, or Semrush show this. Anything they rank for that you do not is a gap.
5. Check your own Search Console. If your site has been live a while, the Performance report shows queries you already get impressions for. These are the easiest wins because Google already knows you exist for them.

Dump everything into one sheet with columns for keyword, intent, volume, difficulty, and value. Do not filter yet. Get it all down first.

Cluster keywords instead of chasing each one

Here is where most people go wrong: they treat every keyword as a separate page. You end up with fifty thin pages that compete with each other.

Instead, group keywords that mean the same thing into one cluster, and give each cluster one page. "cost of root canal", "root canal price noida", and "how much does rct cost" are the same search wearing three outfits. They get one strong page, not three weak ones.

Two ways to cluster:

• By meaning (semantic). Group obvious synonyms and rephrasings by hand. Fine for small lists.
• By SERP overlap. Search two keywords and see if the same URLs rank for both. If yes, Google treats them as one topic, so one page can serve both. This is the more reliable method and it is what clustering tools automate.

For most local businesses with a few hundred keywords, manual clustering in a spreadsheet works fine. Sort by topic, eyeball the groups, name each cluster. You will usually land on 10 to 25 clusters, and each becomes a page on your roadmap.

Map clusters to pages

Every cluster needs a home, and every page needs one primary keyword plus a handful of supporting ones. This is keyword mapping, and it doubles as your site structure and content plan.

A simple map looks like this:

Two rules keep this clean. One page should own one primary keyword, so you are never two of your own pages fighting for the same term. And every cluster you care about should map to exactly one page, with no orphans. If a cluster has no page, that is your next thing to build.

This is the phase where keyword research stops being abstract and turns into a list of pages to write. It is also the phase where we get client sign-off at Zarle before any writing starts, because it makes the plan visible.

Tools: free and paid

You can run solid seo keyword analysis for free. Paid tools save time and add competitor depth.

A practical starter combo for a small business: Keyword Planner for volume ranges, Search Console for existing wins, and one freemium tool for difficulty and competitor gaps. That covers the essentials without a subscription.

A repeatable workflow you can reuse

This is the loop we run, start to finish.

1. List seeds. What you sell, in plain words.
2. Expand. Autocomplete, related searches, a keyword tool, competitor keywords.
3. Tag intent. Informational, navigational, commercial, transactional.
4. Score. Add volume, difficulty, and a high/medium/low value grade.
5. Filter. Cut high-difficulty terms a new site cannot win, and cut zero-value terms.
6. Cluster. Group same-meaning keywords into topics.
7. Map. One cluster, one page, one primary keyword.
8. Prioritize. Start with low difficulty plus high value. Quick wins build momentum.
9. Write and publish. One page per cluster, intent-matched.
10. Review quarterly. Search Console shows new queries and pages slipping. Re-cluster and refresh.

The last step matters. Keyword analysis is not a one-off. Search behavior shifts, competitors move, and your own pages surface new queries you never targeted.

Worked example: a Noida dental clinic

Let us run the workflow on a real-style case. When Zarle worked on Ranvay Dental, a Noida clinic, online bookings rose around 200 percent after we rebuilt the site and ran SEO. Keyword analysis was the first phase. Here is a trimmed version of how that kind of list comes together.

Seeds: root canal, teeth whitening, braces, dental implant, dentist noida.

After expanding and scoring, a slice of the sheet looks like this.

Notice the choices. We did not chase "best dentist near me" despite the huge volume, because difficulty was brutal and intent was generic. We grabbed "painless root canal sector 66" even at 40 searches, because difficulty was near zero and those forty people are local and ready to book. We sent "does root canal hurt" to a blog post, not a service page, because the SERP was full of articles.

Clustered, that list collapses into a clean plan: a root canal service page, a whitening service page, a few sector-level local landing pages, and a handful of aftercare blog posts that feed the FAQ. Each one targets a topic, not a single keyword. That structure is what turned searches into bookings.

The same logic worked for Optima Learning, an edtech client, where the clusters were exam terms like "CAT preparation strategy" and "CAT mock test" rather than dental ones. Different industry, identical method. Organic traffic showed up within weeks of publishing intent-matched pages.

Common mistakes to avoid

• Chasing volume and ignoring intent, so your page never matches what Google wants to show.
• Building a separate page for every keyword and splitting your own ranking power.
• Treating tool difficulty scores as absolute instead of eyeballing the actual SERP.
• Ignoring low-volume long tail terms that convert far better than head terms.
• Doing it once and never revisiting Search Console.

Frequently asked questions

What is seo keyword analysis in simple terms?

It is the process of deciding which search phrases are worth targeting. You look at how many people search a term, how hard it is to rank for, what those searchers actually want, and whether ranking would earn you business. Then you keep only the terms that pass all four checks.

How is keyword analysis different from keyword research?

Keyword research is finding the phrases. Keyword analysis is judging them: scoring volume, difficulty, intent, and value, then deciding which ones to act on and which page should target each. Research builds the list; analysis turns it into a plan.

What is a good keyword difficulty for a new website?

Aim low at first, generally under 20 to 25 on most tools. New sites lack the authority to outrank established brands, so quick wins come from long tail and local terms with little competition. As you publish and earn links, you can climb toward harder keywords.

Do low-volume keywords matter?

Often they matter more than high-volume ones. A term with 50 searches a month can convert at a high rate if the searcher has clear buying intent, and it is usually far easier to rank for. Stacking many specific long tail keywords frequently beats fighting for one broad head term.

How many keywords should one page target?

One primary keyword and several closely related supporting ones from the same cluster. A page about root canal cost can naturally cover "rct price", "root canal charges", and similar phrasings, because they share one intent. Avoid forcing unrelated keywords onto the same page.

How often should I redo keyword analysis?

Review quarterly at minimum. Check Search Console for new queries you are getting impressions for, watch for rankings slipping, and refresh clusters as your services or the market change. A yearly deep pass plus light quarterly reviews keeps the plan current.

Can I do keyword analysis without paid tools?

Yes. Google autocomplete, People Also Ask, related searches, Keyword Planner for volume, and Search Console for existing queries cover the basics for free. Paid tools mainly speed things up and add competitor depth, which helps once you are scaling.

Where to go from here

Solid keyword analysis is the difference between content that ranks and content that just exists. Sort by intent, weigh volume against difficulty and value, cluster ruthlessly, and give every topic one clear page. Then keep checking the data and adjusting.

If you would rather hand the spreadsheet, the SERP digging, and the content mapping to a team that does it daily, that is what we do. Zarle's SEO & content strategy service starts with exactly this keyword research phase, and our clients typically see at least 30 to 40 percent organic growth within six months, with some well past 100 percent. Tell us what you sell, and we will tell you which searches are worth winning.